# MySQL dump 7.1
#
# Host: localhost Database: bugs
#--------------------------------------------------------
# Server version 3.22.32-log
#
# 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),
KEY bug_id (bug_id),
KEY creation_ts (creation_ts)
);
#
# Dumping data for table 'attachments'
#
#
# 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('blocker','critical','major','normal','minor','trivial','enhancement') DEFAULT 'blocker' NOT NULL,
bug_status enum('UNCONFIRMED','NEW','ASSIGNED','REOPENED','RESOLVED','VERIFIED','CLOSED') 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('All','Windows 3.1','Windows 95','Windows 98','Windows 2000','Windows NT','Mac System 7','Mac System 7.5','Mac System 7.6.1','Mac System 8.0','Mac System 8.5','Mac System 8.6','Mac System 9.0','AIX','BSDI','HP-UX','IRIX','Linux','FreeBSD','OSF/1','Solaris','SunOS','Neutrino','OS/2','BeOS','OpenVMS','other') DEFAULT 'All' NOT NULL,
priority enum('P1','P2','P3','P4','P5') DEFAULT 'P1' NOT NULL,
product varchar(64) DEFAULT '' NOT NULL,
rep_platform enum('All','DEC','HP','Macintosh','PC','SGI','Sun','Other'),
reporter mediumint(9) DEFAULT '0' NOT NULL,
version varchar(16) DEFAULT '' NOT NULL,
component varchar(50) DEFAULT '' NOT NULL,
resolution enum('','FIXED','INVALID','WONTFIX','LATER','REMIND','DUPLICATE','WORKSFORME') 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),
KEY assigned_to (assigned_to),
KEY creation_ts (creation_ts),
KEY delta_ts (delta_ts),
KEY bug_severity (bug_severity),
KEY bug_status (bug_status),
KEY op_sys (op_sys),
KEY priority (priority),
KEY product (product),
KEY reporter (reporter),
KEY version (version),
KEY component (component),
KEY resolution (resolution),
KEY target_milestone (target_milestone),
KEY qa_contact (qa_contact),
KEY votes (votes)
);
#
# Dumping data for table 'bugs'
#
INSERT INTO bugs VALUES (1,0,2,'','normal','NEW','2000-12-14 13:22:34',20001214132234,'test bug 1.1.1','other','P2','product 1','Other',1,'unspecified','component 1.1','','---',0,'',0,'','0000-00-00 00:00:00',1);
INSERT INTO bugs VALUES (2,0,2,'','normal','NEW','2000-12-14 13:23:00',20001214132300,'test bug 1.1.2','other','P2','product 1','Other',1,'unspecified','component 1.1','','---',0,'',0,'','0000-00-00 00:00:00',1);
INSERT INTO bugs VALUES (3,0,3,'','normal','NEW','2000-12-14 13:23:30',20001214132330,'test bug 1.1.2','other','P2','product 1','Other',1,'unspecified','component 1.1','','---',0,'',0,'','0000-00-00 00:00:00',1);
INSERT INTO bugs VALUES (4,0,3,'','normal','NEW','2000-12-14 13:23:50',20001214132350,'test bug 1.2.1','other','P2','product 1','Other',1,'unspecified','component 1.2','','---',0,'',0,'','0000-00-00 00:00:00',1);
INSERT INTO bugs VALUES (5,0,2,'','normal','NEW','2000-12-14 13:24:19',20001214132419,'test bug 2.1.1','other','P2','product 2','Other',1,'unspecified','component 2.1','','---',0,'',0,'','0000-00-00 00:00:00',1);
INSERT INTO bugs VALUES (6,0,4,'','normal','NEW','2000-12-14 13:24:46',20001214132446,'test bug 2.1.2','other','P2','product 2','Other',1,'unspecified','component 2.1','','---',0,'',0,'','0000-00-00 00:00:00',1);
INSERT INTO bugs VALUES (7,0,2,'','normal','NEW','2000-12-14 13:50:37',20001214135037,'test bug 3.1.1','other','P2','unconfirmed product','Other',1,'unspecified','component 3.1','','---',0,'',0,'','2000-12-14 13:50:38',1);
INSERT INTO bugs VALUES (8,0,3,'','normal','UNCONFIRMED','2000-12-14 13:55:34',20001214135534,'test bug 3.2.2','other','P2','unconfirmed product','Other',1,'unspecified','component 3.2','','---',0,'',0,'','2000-12-14 13:55:35',0);
#
# 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,
KEY bug_id (bug_id),
KEY bug_when (bug_when),
KEY fieldid (fieldid)
);
#
# Dumping data for table 'bugs_activity'
#
#
# Table structure for table 'cc'
#
CREATE TABLE cc (
bug_id mediumint(9) DEFAULT '0' NOT NULL,
who mediumint(9) DEFAULT '0' NOT NULL,
KEY who (who),
UNIQUE bug_id (bug_id,who)
);
#
# Dumping data for table 'cc'
#
#
# 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
);
#
# Dumping data for table 'components'
#
INSERT INTO components VALUES ('component 1.1','product 1','nb+test1@ravenbrook.com','','test component 1.1');
INSERT INTO components VALUES ('component 1.2','product 1','nb+test2@ravenbrook.com','','test component 1.2');
INSERT INTO components VALUES ('component 1.3','product 1','nb+test3@ravenbrook.com','','test component 1.3');
INSERT INTO components VALUES ('component 2.1','product 2','nb+test1@ravenbrook.com','','test component 2.1');
INSERT INTO components VALUES ('component 2.2','product 2','nb+disabled@ravenbrook.com','','test component 2.2');
INSERT INTO components VALUES ('component 2.3','product 2','nb+test3@ravenbrook.com','','test component 2.3');
INSERT INTO components VALUES ('component 3.1','unconfirmed product','nb+test1@ravenbrook.com','','test component 3.1');
INSERT INTO components VALUES ('component 3.2','unconfirmed product','nb+test2@ravenbrook.com','','test component 3.2');
#
# Table structure for table 'dependencies'
#
CREATE TABLE dependencies (
blocked mediumint(9) DEFAULT '0' NOT NULL,
dependson mediumint(9) DEFAULT '0' NOT NULL,
KEY blocked (blocked),
KEY dependson (dependson)
);
#
# Dumping data for table 'dependencies'
#
#
# 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),
UNIQUE name (name),
KEY sortkey (sortkey)
);
#
# Dumping data for table 'fielddefs'
#
INSERT INTO fielddefs VALUES (1,'bug_id','Bug #',1,1);
INSERT INTO fielddefs VALUES (2,'short_desc','Summary',1,2);
INSERT INTO fielddefs VALUES (3,'product','Product',1,3);
INSERT INTO fielddefs VALUES (4,'version','Version',1,4);
INSERT INTO fielddefs VALUES (5,'rep_platform','Platform',1,5);
INSERT INTO fielddefs VALUES (6,'bug_file_loc','URL',1,6);
INSERT INTO fielddefs VALUES (7,'op_sys','OS/Version',1,7);
INSERT INTO fielddefs VALUES (8,'bug_status','Status',1,8);
INSERT INTO fielddefs VALUES (9,'status_whiteboard','Status Whiteboard',1,9);
INSERT INTO fielddefs VALUES (10,'keywords','Keywords',1,10);
INSERT INTO fielddefs VALUES (11,'resolution','Resolution',1,11);
INSERT INTO fielddefs VALUES (12,'bug_severity','Severity',1,12);
INSERT INTO fielddefs VALUES (13,'priority','Priority',1,13);
INSERT INTO fielddefs VALUES (14,'component','Component',1,14);
INSERT INTO fielddefs VALUES (15,'assigned_to','AssignedTo',1,15);
INSERT INTO fielddefs VALUES (16,'reporter','ReportedBy',1,16);
INSERT INTO fielddefs VALUES (17,'votes','Votes',0,17);
INSERT INTO fielddefs VALUES (18,'qa_contact','QAContact',0,18);
INSERT INTO fielddefs VALUES (19,'cc','CC',0,19);
INSERT INTO fielddefs VALUES (20,'dependson','BugsThisDependsOn',0,20);
INSERT INTO fielddefs VALUES (21,'blocked','OtherBugsDependingOnThis',0,21);
INSERT INTO fielddefs VALUES (22,'attachments.description','Attachment description',0,22);
INSERT INTO fielddefs VALUES (23,'attachments.thedata','Attachment data',0,23);
INSERT INTO fielddefs VALUES (24,'attachments.mimetype','Attachment mime type',0,24);
INSERT INTO fielddefs VALUES (25,'attachments.ispatch','Attachment is patch',0,25);
INSERT INTO fielddefs VALUES (26,'target_milestone','Target Milestone',0,26);
INSERT INTO fielddefs VALUES (27,'delta_ts','Last changed date',0,27);
INSERT INTO fielddefs VALUES (28,'(to_days(now()) - to_days(bugs.delta_ts))','Days since bug changed',0,28);
INSERT INTO fielddefs VALUES (29,'longdesc','Comment',0,29);
#
# 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,
UNIQUE bit (bit),
UNIQUE name (name)
);
#
# Dumping data for table 'groups'
#
INSERT INTO groups VALUES (1,'tweakparams','Can tweak operating parameters',0,'');
INSERT INTO groups VALUES (2,'editusers','Can edit or disable users',0,'');
INSERT INTO groups VALUES (4,'creategroups','Can create and destroy groups.',0,'');
INSERT INTO groups VALUES (8,'editcomponents','Can create, destroy, and edit components.',0,'');
INSERT INTO groups VALUES (16,'editkeywords','Can create, destroy, and edit keywords.',0,'');
INSERT INTO groups VALUES (32,'editbugs','Can edit all aspects of any bug.',0,'.*');
INSERT INTO groups VALUES (64,'canconfirm','Can confirm a bug.',0,'.*');
#
# 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),
UNIQUE name (name)
);
#
# Dumping data for table 'keyworddefs'
#
#
# Table structure for table 'keywords'
#
CREATE TABLE keywords (
bug_id mediumint(9) DEFAULT '0' NOT NULL,
keywordid smallint(6) DEFAULT '0' NOT NULL,
KEY keywordid (keywordid),
UNIQUE bug_id (bug_id,keywordid)
);
#
# Dumping data for table 'keywords'
#
#
# 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),
KEY lastused (lastused)
);
#
# Dumping data for table 'logincookies'
#
INSERT INTO logincookies VALUES (1,1,'np6ZEGIe/CFAA','193.112.141.249',20001214125049);
INSERT INTO logincookies VALUES (2,1,'dFEvr4MyXv75o','193.112.141.249',20001214135534);
#
# 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,
KEY bug_id (bug_id),
KEY bug_when (bug_when)
);
#
# Dumping data for table 'longdescs'
#
INSERT INTO longdescs VALUES (1,1,'2000-12-14 13:22:34','test bug 1.1.1');
INSERT INTO longdescs VALUES (2,1,'2000-12-14 13:23:00','test bug 1.1.2');
INSERT INTO longdescs VALUES (3,1,'2000-12-14 13:23:30','test bug 1.1.2');
INSERT INTO longdescs VALUES (4,1,'2000-12-14 13:23:50','test bug 1.2.1');
INSERT INTO longdescs VALUES (5,1,'2000-12-14 13:24:19','test bug 2.1.1');
INSERT INTO longdescs VALUES (6,1,'2000-12-14 13:24:46','test bug 2.1.2');
INSERT INTO longdescs VALUES (7,1,'2000-12-14 13:50:37','test bug 3.1.1');
INSERT INTO longdescs VALUES (8,1,'2000-12-14 13:55:34','test bug 3.2.2');
#
# 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,
UNIQUE product (product,value)
);
#
# Dumping data for table 'milestones'
#
INSERT INTO milestones VALUES ('---','product 1',0);
INSERT INTO milestones VALUES ('---','product 2',0);
INSERT INTO milestones VALUES ('---','unconfirmed product',0);
#
# 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,
UNIQUE userid (userid,name),
KEY watchfordiffs (watchfordiffs)
);
#
# Dumping data for table 'namedqueries'
#
#
# 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
);
#
# Dumping data for table 'products'
#
INSERT INTO products VALUES ('product 2','test product number 2','',0,0,10000,0,'---');
INSERT INTO products VALUES ('unconfirmed product','test product which requires confirmation','',0,0,10000,50,'---');
INSERT INTO products VALUES ('product 1','test product 1: no confirmation','',0,0,10000,0,'---');
#
# 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('ExcludeSelfChanges','CConly','All') 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),
UNIQUE login_name (login_name)
);
#
# Dumping data for table 'profiles'
#
INSERT INTO profiles VALUES (1,'nb@ravenbrook.com','p4dtitest','dFEvr4MyXv75o','Nick Barnes',281474976710655,'ExcludeSelfChanges','',0,1,0);
INSERT INTO profiles VALUES (2,'nb+test1@ravenbrook.com','p4dtitest','2Iwc27TLT.1u2','Test User 1',96,'ExcludeSelfChanges','',0,1,0);
INSERT INTO profiles VALUES (3,'nb+test2@ravenbrook.com','p4dtitest','UJLSwZW1buk2s','Test User 2',0,'ExcludeSelfChanges','',0,1,0);
INSERT INTO profiles VALUES (4,'nb+disabled@ravenbrook.com','p4dtitest','1qBpwP0G49FPE','Disabled User',127,'ExcludeSelfChanges','This user is disabled.',0,1,0);
INSERT INTO profiles VALUES (5,'nb+test3@ravenbrook.com','p4dtitest','crpchBfoHhkFw','Test User 3',96,'ExcludeSelfChanges','',0,1,0);
INSERT INTO profiles VALUES (6,'nb+p4dti-replicator0@ravenbrook.com','p4dtitest','crpchBfoHhkFw','Test User 3',96,'ExcludeSelfChanges','',0,1,0);
#
# 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,
KEY userid (userid),
KEY profiles_when (profiles_when),
KEY fieldid (fieldid)
);
#
# Dumping data for table 'profiles_activity'
#
#
# 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),
KEY reflected (reflected)
);
#
# Dumping data for table 'shadowlog'
#
#
# Table structure for table 'versions'
#
CREATE TABLE versions (
value tinytext,
program varchar(64) DEFAULT '' NOT NULL
);
#
# Dumping data for table 'versions'
#
INSERT INTO versions VALUES ('unspecified','product 2');
INSERT INTO versions VALUES ('unspecified','product 1');
INSERT INTO versions VALUES ('unspecified','unconfirmed product');
#
# 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,
KEY who (who),
KEY bug_id (bug_id)
);
#
# Dumping data for table 'votes'
#
#
# Table structure for table 'watch'
#
CREATE TABLE watch (
watcher mediumint(9) DEFAULT '0' NOT NULL,
watched mediumint(9) DEFAULT '0' NOT NULL,
KEY watched (watched),
UNIQUE watcher (watcher,watched)
);
#
# Dumping data for table 'watch'
#