More documentation updates.

1 files changed, 0 insertions, 308 deletions

diff --git a/docs/sgml/dbschema.mysql b/docs/sgml/dbschema.mysql
index c75c4caa4..8b1378917 100644
--- a/docs/sgml/dbschema.mysql
+++ b/docs/sgml/dbschema.mysql
@@ -1,309 +1 @@
-# MySQL dump 7.1
-#
-# Host: localhost    Database: bugs
-#--------------------------------------------------------
-# Server version	3.22.32
 
-#
-# Table structure for table 'attachments'
-#
-CREATE TABLE attachments (
-  attach_id mediumint(9) DEFAULT '0' NOT NULL auto_increment,
-  bug_id mediumint(9) DEFAULT '0' NOT NULL,
-  creation_ts timestamp(14),
-  description mediumtext NOT NULL,
-  mimetype mediumtext NOT NULL,
-  ispatch tinyint(4),
-  filename mediumtext NOT NULL,
-  thedata longblob NOT NULL,
-  submitter_id mediumint(9) DEFAULT '0' NOT NULL,
-  PRIMARY KEY (attach_id)
-);
-create index index_41 on attachments (bug_id); 
-create index index_42 on attachments (creation_ts);
-
-#
-# Table structure for table 'bugs'
-#
-CREATE TABLE bugs (
-  bug_id mediumint(9) DEFAULT '0' NOT NULL auto_increment,
-  groupset bigint(20) DEFAULT '0' NOT NULL,
-  assigned_to mediumint(9) DEFAULT '0' NOT NULL,
-  bug_file_loc text,
-  bug_severity enum DEFAULT 'blocker' NOT NULL,
-  bug_status enum DEFAULT 'UNCONFIRMED' NOT NULL,
-  creation_ts datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
-  delta_ts timestamp(14),
-  short_desc mediumtext,
-  op_sys enum DEFAULT 'All' NOT NULL,
-  priority enum DEFAULT 'P1' NOT NULL,
-  product varchar(64) DEFAULT '' NOT NULL,
-  rep_platform enum,
-  reporter mediumint(9) DEFAULT '0' NOT NULL,
-  version varchar(16) DEFAULT '' NOT NULL,
-  component varchar(50) DEFAULT '' NOT NULL,
-  resolution enum DEFAULT '' NOT NULL,
-  target_milestone varchar(20) DEFAULT '---' NOT NULL,
-  qa_contact mediumint(9) DEFAULT '0' NOT NULL,
-  status_whiteboard mediumtext NOT NULL,
-  votes mediumint(9) DEFAULT '0' NOT NULL,
-  keywords mediumtext NOT NULL,
-  lastdiffed datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
-  everconfirmed tinyint(4) DEFAULT '0' NOT NULL,
-  PRIMARY KEY (bug_id)
-);
-create index index_7 on bugs (assigned_to);
-create index index_8 on bugs (creation_ts);
-create index index_9 on bugs (delta_ts);
-create index index_10 on bugs (bug_severity);
-create index index_11 on bugs (bug_status);
-create index index_12 on bugs (op_sys);
-create index index_13 on bugs (priority);
-create index index_14 on bugs (product);
-create index index_15 on bugs (reporter);
-create index index_16 on bugs (version);
-create index index_17 on bugs (component);
-create index index_18 on bugs (resolution);
-create index index_19 on bugs (target_milestone); 
-create index index_20 on bugs (qa_contact);
-create index index_21 on bugs (votes);
-
-#
-# Table structure for table 'bugs_activity'
-#
-CREATE TABLE bugs_activity (
-  bug_id mediumint(9) DEFAULT '0' NOT NULL,
-  who mediumint(9) DEFAULT '0' NOT NULL,
-  bug_when datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
-  fieldid mediumint(9) DEFAULT '0' NOT NULL,
-  oldvalue tinytext,
-  newvalue tinytext
-);
-create index index_43 on bugs_activity (bug_id); 
-create index index_44 on bugs_activity (bug_when); 
-create index index_45 on bugs_activity (fieldid);
-
-#
-# Table structure for table 'cc'
-#
-CREATE TABLE cc (
-  bug_id mediumint(9) DEFAULT '0' NOT NULL,
-  who mediumint(9) DEFAULT '0' NOT NULL
-);
-create index index_31 on cc (who);
-create unique index index_32 on cc (bug_id,who);
-
-#
-# Table structure for table 'components'
-#
-CREATE TABLE components (
-  value tinytext,
-  program varchar(64),
-  initialowner tinytext NOT NULL,
-  initialqacontact tinytext NOT NULL,
-  description mediumtext NOT NULL
-);
-
-#
-# Table structure for table 'dependencies'
-#
-CREATE TABLE dependencies (
-  blocked mediumint(9) DEFAULT '0' NOT NULL,
-  dependson mediumint(9) DEFAULT '0' NOT NULL
-);
-create index index_34 on dependencies (blocked); 
-create index index_35 on dependencies (dependson);
-
-#
-# Table structure for table 'duplicates'
-#
-CREATE TABLE duplicates (
-  dupe_of mediumint(9) DEFAULT '0' NOT NULL,
-  dupe mediumint(9) DEFAULT '0' NOT NULL,
-  PRIMARY KEY (dupe)
-);
-
-#
-# Table structure for table 'fielddefs'
-#
-CREATE TABLE fielddefs (
-  fieldid mediumint(9) DEFAULT '0' NOT NULL auto_increment,
-  name varchar(64) DEFAULT '' NOT NULL,
-  description mediumtext NOT NULL,
-  mailhead tinyint(4) DEFAULT '0' NOT NULL,
-  sortkey smallint(6) DEFAULT '0' NOT NULL,
-  PRIMARY KEY (fieldid)
-);
-create unique index index_28 on fielddefs (name); 
-create index index_29 on fielddefs (sortkey);
-
-#
-# Table structure for table 'groups'
-#
-CREATE TABLE groups (
-  bit bigint(20) DEFAULT '0' NOT NULL,
-  name varchar(255) DEFAULT '' NOT NULL,
-  description text NOT NULL,
-  isbuggroup tinyint(4) DEFAULT '0' NOT NULL,
-  userregexp tinytext NOT NULL
-);
-create unique index index_3 on groups (bit);
-create unique index index_4 on groups (name);
-
-#
-# Table structure for table 'keyworddefs'
-#
-CREATE TABLE keyworddefs (
-  id smallint(6) DEFAULT '0' NOT NULL,
-  name varchar(64) DEFAULT '' NOT NULL,
-  description mediumtext,
-  PRIMARY KEY (id)
-);
-create unique index index_33 on keyworddefs (name);
-
-#
-# Table structure for table 'keywords'
-#
-CREATE TABLE keywords (
-  bug_id mediumint(9) DEFAULT '0' NOT NULL,
-  keywordid smallint(6) DEFAULT '0' NOT NULL
-);
-create index index_39 on keywords (keywordid); 
-create unique index index_40 on keywords (bug_id, keywordid);
-
-#
-# Table structure for table 'logincookies'
-#
-CREATE TABLE logincookies (
-  cookie mediumint(9) DEFAULT '0' NOT NULL auto_increment,
-  userid mediumint(9) DEFAULT '0' NOT NULL,
-  cryptpassword varchar(64),
-  hostname varchar(128),
-  lastused timestamp(14),
-  PRIMARY KEY (cookie)
-);
-create index index_30 on logincookies (lastused);
-
-#
-# Table structure for table 'longdescs'
-#
-CREATE TABLE longdescs (
-  bug_id mediumint(9) DEFAULT '0' NOT NULL,
-  who mediumint(9) DEFAULT '0' NOT NULL,
-  bug_when datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
-  thetext mediumtext
-);
-create index index_22 on longdescs (bug_id);
-create index index_23 on longdescs (bug_when);
-
-#
-# Table structure for table 'milestones'
-#
-CREATE TABLE milestones (
-  value varchar(20) DEFAULT '' NOT NULL,
-  product varchar(64) DEFAULT '' NOT NULL,
-  sortkey smallint(6) DEFAULT '0' NOT NULL,
-);
-create unique index index_24 on milestones (product, value);
-
-#
-# Table structure for table 'namedqueries'
-#
-CREATE TABLE namedqueries (
-  userid mediumint(9) DEFAULT '0' NOT NULL,
-  name varchar(64) DEFAULT '' NOT NULL,
-  watchfordiffs tinyint(4) DEFAULT '0' NOT NULL,
-  linkinfooter tinyint(4) DEFAULT '0' NOT NULL,
-  query mediumtext NOT NULL
-);
-create unique index index_25 on namedqueries (userid, name);
-create index index_26 on namedqueries (watchfordiffs);
-
-#
-# Table structure for table 'products'
-#
-CREATE TABLE products (
-  product varchar(64),
-  description mediumtext,
-  milestoneurl tinytext NOT NULL,
-  disallownew tinyint(4) DEFAULT '0' NOT NULL,
-  votesperuser smallint(6) DEFAULT '0' NOT NULL,
-  maxvotesperbug smallint(6) DEFAULT '10000' NOT NULL,
-  votestoconfirm smallint(6) DEFAULT '0' NOT NULL,
-  defaultmilestone varchar(20) DEFAULT '---' NOT NULL
-);
-
-#
-# Table structure for table 'profiles'
-#
-CREATE TABLE profiles (
-  userid mediumint(9) DEFAULT '0' NOT NULL auto_increment,
-  login_name varchar(255) DEFAULT '' NOT NULL,
-  password varchar(16),
-  cryptpassword varchar(64),
-  realname varchar(255),
-  groupset bigint(20) DEFAULT '0' NOT NULL,
-  emailnotification enum DEFAULT 'ExcludeSelfChanges' NOT NULL,
-  disabledtext mediumtext NOT NULL,
-  newemailtech tinyint(4) DEFAULT '0' NOT NULL,
-  mybugslink tinyint(4) DEFAULT '1' NOT NULL,
-  blessgroupset bigint(20) DEFAULT '0' NOT NULL,
-  PRIMARY KEY (userid)
-);
-create unique index index_27 on profiles (login_name);
-
-#
-# Table structure for table 'profiles_activity'
-#
-CREATE TABLE profiles_activity (
-  userid mediumint(9) DEFAULT '0' NOT NULL,
-  who mediumint(9) DEFAULT '0' NOT NULL,
-  profiles_when datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
-  fieldid mediumint(9) DEFAULT '0' NOT NULL,
-  oldvalue tinytext,
-  newvalue tinytext
-);
-create index index_0 on profiles_activity (userid); 
-create index index_1 on profiles_activity (profiles_when); 
-create index index_2 on profiles_activity (fieldid);
-
-#
-# Table structure for table 'shadowlog'
-#
-CREATE TABLE shadowlog (
-  id int(11) DEFAULT '0' NOT NULL auto_increment,
-  ts timestamp(14),
-  reflected tinyint(4) DEFAULT '0' NOT NULL,
-  command mediumtext NOT NULL,
-  PRIMARY KEY (id)
-);
-create index index_38 on shadowlog (reflected);
-
-#
-# Table structure for table 'versions'
-#
-CREATE TABLE versions (
-  value tinytext,
-  program varchar(64) DEFAULT '' NOT NULL
-);
-
-#
-# Table structure for table 'votes'
-#
-CREATE TABLE votes (
-  who mediumint(9) DEFAULT '0' NOT NULL,
-  bug_id mediumint(9) DEFAULT '0' NOT NULL,
-  count smallint(6) DEFAULT '0' NOT NULL
-);
-create index index_5 on votes (who);
-create index index_6 on votes (bug_id);
-
-#
-# Table structure for table 'watch'
-#
-CREATE TABLE watch (
-  watcher mediumint(9) DEFAULT '0' NOT NULL,
-  watched mediumint(9) DEFAULT '0' NOT NULL
-);
-create index index_36 on watch (watched);
-create unique index index_37 on watch (watcher, watched);