From d819eae3af3b13d4b6f17e818d449eaabe58ff9d Mon Sep 17 00:00:00 2001 From: "barnboy%trilobyte.net" <> Date: Sat, 11 Aug 2001 05:13:47 +0000 Subject: Checkin for 2.14 release. Still some problems; this cannot yet be used for 2.14 documentation due to inconsistencies. --- docs/sgml/dbschema.mysql | 309 +++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 309 insertions(+) create mode 100644 docs/sgml/dbschema.mysql (limited to 'docs/sgml/dbschema.mysql') diff --git a/docs/sgml/dbschema.mysql b/docs/sgml/dbschema.mysql new file mode 100644 index 000000000..c75c4caa4 --- /dev/null +++ b/docs/sgml/dbschema.mysql @@ -0,0 +1,309 @@ +# 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); -- cgit v1.2.3-24-g4f1b