# MySQL dump 8.13 # # Host: localhost Database: bugs #-------------------------------------------------------- # Server version 3.23.37 # # Table structure for table 'attachments' # CREATE TABLE attachments ( attach_id mediumint(9) NOT NULL auto_increment, bug_id mediumint(9) NOT NULL default '0', creation_ts timestamp(14) NOT NULL, description mediumtext NOT NULL, mimetype mediumtext NOT NULL, ispatch tinyint(4) default NULL, filename mediumtext NOT NULL, thedata longblob NOT NULL, submitter_id mediumint(9) NOT NULL default '0', PRIMARY KEY (attach_id), KEY bug_id (bug_id), KEY creation_ts (creation_ts) ) TYPE=MyISAM; # # Dumping data for table 'attachments' # # # Table structure for table 'bugs' # CREATE TABLE bugs ( bug_id mediumint(9) NOT NULL auto_increment, groupset bigint(20) NOT NULL default '0', assigned_to mediumint(9) NOT NULL default '0', bug_file_loc text, bug_severity enum('1 blocker','2 critical','3 major','4 normal','5 minor','6 trivial','7 enhancement') NOT NULL default '1 blocker', bug_status enum('UNCONFIRMED','NEW','ASSIGNED','REOPENED','RESOLVED','VERIFIED','CLOSED') NOT NULL default 'UNCONFIRMED', creation_ts datetime NOT NULL default '0000-00-00 00:00:00', delta_ts timestamp(14) NOT NULL, short_desc mediumtext, op_sys enum('All','Windows 3.1','Windows 95','Windows 98','Windows ME','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','Linux','BSDI','FreeBSD','NetBSD','OpenBSD','AIX','BeOS','HP-UX','IRIX','Neutrino','OpenVMS','OS/2','OSF/1','Solaris','SunOS','other') NOT NULL default 'All', priority enum('P1','P2','P3','P4','P5') NOT NULL default 'P1', product varchar(64) NOT NULL default '', rep_platform enum('All','DEC','HP','Macintosh','PC','SGI','Sun','Other') default NULL, reporter mediumint(9) NOT NULL default '0', version varchar(64) NOT NULL default '', component varchar(50) NOT NULL default '', resolution enum('','FIXED','INVALID','WONTFIX','LATER','REMIND','DUPLICATE','WORKSFORME','MOVED') NOT NULL default '', target_milestone varchar(20) NOT NULL default '---', qa_contact mediumint(9) NOT NULL default '0', status_whiteboard mediumtext NOT NULL, votes mediumint(9) NOT NULL default '0', keywords mediumtext NOT NULL, lastdiffed datetime NOT NULL default '0000-00-00 00:00:00', everconfirmed tinyint(4) NOT NULL default '0', reporter_accessible tinyint(4) NOT NULL default '1', assignee_accessible tinyint(4) NOT NULL default '1', qacontact_accessible tinyint(4) NOT NULL default '1', cclist_accessible tinyint(4) NOT NULL default '1', 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) ) TYPE=MyISAM; # # Dumping data for table 'bugs' # INSERT INTO bugs VALUES (1,0,3,'','4 normal','RESOLVED','2001-09-25 15:53:14',20011016163006,'bug 1.1.1','Mac System 8.5','P2','product 1','Macintosh',4,'unspecified','component 1.1','WORKSFORME','---',0,'',0,'','2001-10-16 16:30:07',1,1,1,1,1); INSERT INTO bugs VALUES (2,0,5,'','2 critical','NEW','2001-09-25 16:07:32',20011016155939,'bug 1.2.1','All','P1','product 1','All',5,'unspecified','component 1.2','','---',0,'',0,'','2001-10-16 15:59:40',1,1,1,1,1); INSERT INTO bugs VALUES (3,0,2,'','6 trivial','NEW','2001-09-25 16:08:23',20010925160823,'bug 2.1.1','Linux','P2','product 2','Macintosh',2,'unspecified','component 2.1','','---',0,'',0,'','2001-09-25 16:08:24',1,1,1,1,1); INSERT INTO bugs VALUES (4,0,4,'','5 minor','NEW','2001-09-25 16:14:04',20011016162122,'bug 2.2.1','All','P5','product 2','All',3,'unspecified','component 2.2','','---',0,'',0,'','2001-10-16 16:21:23',1,1,1,1,1); INSERT INTO bugs VALUES (5,0,5,'','4 normal','RESOLVED','2001-10-16 15:50:09',20011016155259,'RESOLVED/FIXED','OS/2','P5','product 1','Other',3,'unspecified','component 1.2','FIXED','---',0,'',0,'','2001-10-16 16:03:08',1,1,1,1,1); INSERT INTO bugs VALUES (6,0,2,'','6 trivial','RESOLVED','2001-10-16 15:53:56',20011016155422,'RESOLVED/INVALID','OpenBSD','P2','product 2','Macintosh',5,'unspecified','component 2.1','INVALID','---',0,'',0,'','2001-10-16 15:54:23',1,1,1,1,1); INSERT INTO bugs VALUES (7,0,3,'','7 enhancement','RESOLVED','2001-10-16 15:55:13',20011016155539,'RESOLVED/WONTFIX','BSDI','P1','product 1','Sun',5,'unspecified','component 1.1','WONTFIX','---',0,'',0,'','2001-10-16 15:55:40',1,1,1,1,1); INSERT INTO bugs VALUES (8,0,5,'','1 blocker','RESOLVED','2001-10-16 15:56:37',20011016155727,'RESOLVED/LATER','OSF/1','P4','product 1','Sun',5,'unspecified','component 1.2','LATER','---',0,'',0,'','2001-10-16 15:57:28',1,1,1,1,1); INSERT INTO bugs VALUES (9,0,4,'','2 critical','RESOLVED','2001-10-16 15:58:05',20011016155820,'RESOLVED/REMIND','Mac System 9.0','P4','product 2','PC',3,'unspecified','component 2.2','REMIND','---',0,'',0,'','2001-10-16 15:58:21',1,1,1,1,1); INSERT INTO bugs VALUES (10,0,5,'','5 minor','RESOLVED','2001-10-16 15:58:55',20011016155938,'RESOLVED/DUPLICATE','Mac System 8.6','P1','product 1','HP',3,'unspecified','component 1.2','DUPLICATE','---',0,'',0,'','2001-10-16 15:59:39',1,1,1,1,1); INSERT INTO bugs VALUES (11,0,3,'','4 normal','VERIFIED','2001-10-16 16:00:34',20011016160126,'VERIFIED/FIXED','Windows 2000','P2','product 1','DEC',4,'unspecified','component 1.1','FIXED','---',0,'',0,'','2001-10-16 16:04:51',1,1,1,1,1); INSERT INTO bugs VALUES (12,0,4,'','5 minor','VERIFIED','2001-10-16 16:02:00',20011016160304,'VERIFIED/INVALID','NetBSD','P4','product 2','Macintosh',4,'unspecified','component 2.2','INVALID','---',0,'',0,'','2001-10-16 16:04:52',1,1,1,1,1); INSERT INTO bugs VALUES (13,0,2,'','2 critical','VERIFIED','2001-10-16 16:03:52',20011016160449,'VERIFIED/WONTFIX','Neutrino','P4','product 2','HP',3,'unspecified','component 2.1','WONTFIX','---',0,'',0,'','2001-10-16 16:04:50',1,1,1,1,1); INSERT INTO bugs VALUES (14,256,3,'','3 major','NEW','2001-10-16 16:05:00',20011016161818,'lots of longdesc entries with different sorts of whitespace','Mac System 9.0','P1','group','Other',2,'unspecified','group1','','---',0,'',0,'','2001-10-16 16:18:19',1,1,1,1,1); INSERT INTO bugs VALUES (15,0,2,'','4 normal','NEW','2001-10-16 16:05:36',20011016163051,'','BeOS','P3','product 2','Sun',3,'unspecified','component 2.1','','---',0,'',0,'','2001-10-16 16:30:52',1,1,1,1,1); INSERT INTO bugs VALUES (16,0,2,'','4 normal','VERIFIED','2001-10-16 16:05:37',20011016160611,'VERIFIED/LATER','BeOS','P3','product 2','Sun',3,'unspecified','component 2.1','LATER','---',0,'',0,'','2001-10-16 16:06:12',1,1,1,1,1); INSERT INTO bugs VALUES (17,0,3,'','1 blocker','VERIFIED','2001-10-16 16:06:57',20011016160814,'VERIFIED/REMIND','All','P1','product 1','All',3,'unspecified','component 1.1','REMIND','---',0,'',0,'','2001-10-16 16:08:15',1,1,1,1,1); INSERT INTO bugs VALUES (18,0,5,'','2 critical','VERIFIED','2001-10-16 16:08:45',20011016160940,'VERIFIED/DUPLICATE','Windows 3.1','P2','product 1','DEC',5,'unspecified','component 1.2','DUPLICATE','---',0,'',0,'','2001-10-16 16:09:42',1,1,1,1,1); INSERT INTO bugs VALUES (19,0,2,'','3 major','VERIFIED','2001-10-16 16:10:14',20011016161057,'VERIFIED/WORKSFORME','Windows 95','P3','product 2','HP',5,'unspecified','component 2.1','WORKSFORME','---',0,'',0,'','2001-10-16 16:10:58',1,1,1,1,1); INSERT INTO bugs VALUES (20,0,4,'','4 normal','CLOSED','2001-10-16 16:11:28',20011016161226,'CLOSED/FIXED','Windows 98','P4','product 2','Macintosh',5,'unspecified','component 2.2','FIXED','---',0,'',0,'','2001-10-16 16:12:27',1,1,1,1,1); INSERT INTO bugs VALUES (21,0,3,'','5 minor','CLOSED','2001-10-16 16:12:56',20011016161454,'CLOSED/INVALID','Windows ME','P5','product 1','PC',4,'unspecified','component 1.1','INVALID','---',0,'',0,'','2001-10-16 16:14:55',1,1,1,1,1); INSERT INTO bugs VALUES (22,0,5,'','6 trivial','CLOSED','2001-10-16 16:15:32',20011016161603,'CLOSED/WONTFIX','Windows 2000','P1','product 1','SGI',3,'unspecified','component 1.2','WONTFIX','---',0,'',0,'','2001-10-16 16:16:04',1,1,1,1,1); INSERT INTO bugs VALUES (23,0,2,'','7 enhancement','CLOSED','2001-10-16 16:16:43',20011016161735,'CLOSED/LATER','Windows NT','P2','product 2','Sun',3,'unspecified','component 2.1','LATER','---',0,'',0,'','2001-10-16 16:17:36',1,1,1,1,1); INSERT INTO bugs VALUES (24,0,4,'','1 blocker','CLOSED','2001-10-16 16:18:56',20011016161942,'CLOSED/REMIND','Mac System 7','P3','product 2','Other',2,'unspecified','component 2.2','REMIND','---',0,'',0,'','2001-10-16 16:19:43',1,1,1,1,1); INSERT INTO bugs VALUES (25,0,3,'','2 critical','CLOSED','2001-10-16 16:21:04',20011016162134,'CLOSED/DUPLICATE','Mac System 7.5','P4','product 1','All',5,'unspecified','component 1.1','DUPLICATE','---',0,'',0,'','2001-10-16 16:21:35',1,1,1,1,1); INSERT INTO bugs VALUES (26,0,5,'','3 major','CLOSED','2001-10-16 16:22:17',20011016162312,'CLOSED/WORKSFORME','Mac System 7.6.1','P5','product 1','DEC',5,'unspecified','component 1.2','WORKSFORME','---',0,'',0,'','2001-10-16 16:23:13',1,1,1,1,1); INSERT INTO bugs VALUES (27,0,2,'','7 enhancement','UNCONFIRMED','2001-10-16 16:23:45',20011016162345,'unconfirmed bug','HP-UX','P2','unconfirmed','Other',5,'unspecified','unconf1','','---',0,'',0,'','2001-10-16 16:23:47',0,1,1,1,1); INSERT INTO bugs VALUES (28,0,2,'','4 normal','RESOLVED','2001-10-16 16:24:17',20011016162556,'RESOLVED/WORKSFORME','Mac System 8.0','P1','product 2','HP',5,'unspecified','component 2.1','WORKSFORME','---',0,'',0,'','2001-10-16 16:25:57',1,1,1,1,1); INSERT INTO bugs VALUES (29,0,4,'','4 normal','NEW','2001-10-16 16:25:43',20011016162543,'lots of ccs','OSF/1','P2','product 1','Other',5,'unspecified','component 1.1','','---',0,'',0,'','2001-10-16 16:25:44',1,1,1,1,1); INSERT INTO bugs VALUES (30,0,4,'','5 minor','NEW','2001-10-16 16:27:41',20011016162741,'NEW','Mac System 8.5','P2','product 2','Macintosh',5,'unspecified','component 2.2','','---',0,'',0,'','2001-10-16 16:27:42',1,1,1,1,1); INSERT INTO bugs VALUES (31,0,3,'','6 trivial','ASSIGNED','2001-10-16 16:28:10',20011016162818,'ASSIGNED','Mac System 8.6','P3','product 1','PC',5,'unspecified','component 1.1','','---',0,'',0,'','2001-10-16 16:28:19',1,1,1,1,1); INSERT INTO bugs VALUES (32,0,9,'','7 enhancement','REOPENED','2001-10-16 16:29:05',20011016162932,'REOPENED','Mac System 9.0','P4','product 1','SGI',5,'unspecified','component 1.2','','---',0,'',0,'','2001-10-16 16:29:33',1,1,1,1,1); # # Table structure for table 'bugs_activity' # CREATE TABLE bugs_activity ( bug_id mediumint(9) NOT NULL default '0', who mediumint(9) NOT NULL default '0', bug_when datetime NOT NULL default '0000-00-00 00:00:00', fieldid mediumint(9) NOT NULL default '0', added tinytext, removed tinytext, KEY bug_id (bug_id), KEY bug_when (bug_when), KEY fieldid (fieldid) ) TYPE=MyISAM; # # Dumping data for table 'bugs_activity' # INSERT INTO bugs_activity VALUES (1,2,'2001-10-16 15:39:15',2,'','Bug 1.1.1'); INSERT INTO bugs_activity VALUES (5,5,'2001-10-16 15:51:09',8,'ASSIGNED','NEW'); INSERT INTO bugs_activity VALUES (5,5,'2001-10-16 15:52:59',8,'RESOLVED','ASSIGNED'); INSERT INTO bugs_activity VALUES (5,5,'2001-10-16 15:52:59',11,'FIXED',''); INSERT INTO bugs_activity VALUES (6,5,'2001-10-16 15:54:22',8,'RESOLVED','NEW'); INSERT INTO bugs_activity VALUES (6,5,'2001-10-16 15:54:22',11,'INVALID',''); INSERT INTO bugs_activity VALUES (7,5,'2001-10-16 15:55:39',8,'RESOLVED','NEW'); INSERT INTO bugs_activity VALUES (7,5,'2001-10-16 15:55:39',11,'WONTFIX',''); INSERT INTO bugs_activity VALUES (8,3,'2001-10-16 15:57:27',8,'RESOLVED','NEW'); INSERT INTO bugs_activity VALUES (8,3,'2001-10-16 15:57:27',11,'LATER',''); INSERT INTO bugs_activity VALUES (9,3,'2001-10-16 15:58:20',8,'RESOLVED','NEW'); INSERT INTO bugs_activity VALUES (9,3,'2001-10-16 15:58:20',11,'REMIND',''); INSERT INTO bugs_activity VALUES (10,4,'2001-10-16 15:59:38',8,'RESOLVED','NEW'); INSERT INTO bugs_activity VALUES (10,4,'2001-10-16 15:59:38',11,'DUPLICATE',''); INSERT INTO bugs_activity VALUES (2,4,'2001-10-16 15:59:38',19,'gdr@ravenbrook.com',''); INSERT INTO bugs_activity VALUES (11,4,'2001-10-16 16:01:02',8,'RESOLVED','NEW'); INSERT INTO bugs_activity VALUES (11,4,'2001-10-16 16:01:02',11,'FIXED',''); INSERT INTO bugs_activity VALUES (11,4,'2001-10-16 16:01:26',8,'VERIFIED','RESOLVED'); INSERT INTO bugs_activity VALUES (12,4,'2001-10-16 16:02:20',8,'RESOLVED','NEW'); INSERT INTO bugs_activity VALUES (12,4,'2001-10-16 16:02:20',11,'INVALID',''); INSERT INTO bugs_activity VALUES (11,3,'2001-10-16 16:03:04',21,'12',''); INSERT INTO bugs_activity VALUES (12,3,'2001-10-16 16:03:04',20,'11',''); INSERT INTO bugs_activity VALUES (5,3,'2001-10-16 16:03:04',20,'12',''); INSERT INTO bugs_activity VALUES (12,3,'2001-10-16 16:03:04',21,'5',''); INSERT INTO bugs_activity VALUES (12,3,'2001-10-16 16:03:04',12,'5 minor','6 trivial'); INSERT INTO bugs_activity VALUES (12,3,'2001-10-16 16:03:04',8,'VERIFIED','RESOLVED'); INSERT INTO bugs_activity VALUES (12,3,'2001-10-16 16:03:04',13,'P4','P5'); INSERT INTO bugs_activity VALUES (12,3,'2001-10-16 16:04:10',21,'13',''); INSERT INTO bugs_activity VALUES (13,3,'2001-10-16 16:04:10',20,'12',''); INSERT INTO bugs_activity VALUES (11,3,'2001-10-16 16:04:10',20,'13',''); INSERT INTO bugs_activity VALUES (13,3,'2001-10-16 16:04:10',21,'11',''); INSERT INTO bugs_activity VALUES (13,3,'2001-10-16 16:04:10',8,'RESOLVED','NEW'); INSERT INTO bugs_activity VALUES (13,3,'2001-10-16 16:04:10',11,'WONTFIX',''); INSERT INTO bugs_activity VALUES (12,3,'2001-10-16 16:04:49',21,'','13'); INSERT INTO bugs_activity VALUES (13,3,'2001-10-16 16:04:49',20,'','12'); INSERT INTO bugs_activity VALUES (11,3,'2001-10-16 16:04:49',20,'','13'); INSERT INTO bugs_activity VALUES (13,3,'2001-10-16 16:04:49',21,'','11'); INSERT INTO bugs_activity VALUES (13,3,'2001-10-16 16:04:49',8,'VERIFIED','RESOLVED'); INSERT INTO bugs_activity VALUES (16,3,'2001-10-16 16:05:55',8,'RESOLVED','NEW'); INSERT INTO bugs_activity VALUES (16,3,'2001-10-16 16:05:55',11,'LATER',''); INSERT INTO bugs_activity VALUES (16,3,'2001-10-16 16:06:11',8,'VERIFIED','RESOLVED'); INSERT INTO bugs_activity VALUES (17,2,'2001-10-16 16:07:41',8,'RESOLVED','NEW'); INSERT INTO bugs_activity VALUES (17,2,'2001-10-16 16:07:41',11,'REMIND',''); INSERT INTO bugs_activity VALUES (17,5,'2001-10-16 16:08:14',8,'VERIFIED','RESOLVED'); INSERT INTO bugs_activity VALUES (18,5,'2001-10-16 16:09:02',8,'ASSIGNED','NEW'); INSERT INTO bugs_activity VALUES (18,5,'2001-10-16 16:09:23',8,'RESOLVED','ASSIGNED'); INSERT INTO bugs_activity VALUES (18,5,'2001-10-16 16:09:23',11,'DUPLICATE',''); INSERT INTO bugs_activity VALUES (1,5,'2001-10-16 16:09:23',19,'rb@ravenbrook.com',''); INSERT INTO bugs_activity VALUES (18,5,'2001-10-16 16:09:40',8,'VERIFIED','RESOLVED'); INSERT INTO bugs_activity VALUES (19,5,'2001-10-16 16:10:31',8,'ASSIGNED','NEW'); INSERT INTO bugs_activity VALUES (19,5,'2001-10-16 16:10:46',8,'RESOLVED','ASSIGNED'); INSERT INTO bugs_activity VALUES (19,5,'2001-10-16 16:10:46',11,'WORKSFORME',''); INSERT INTO bugs_activity VALUES (19,5,'2001-10-16 16:10:57',8,'VERIFIED','RESOLVED'); INSERT INTO bugs_activity VALUES (20,4,'2001-10-16 16:12:11',8,'RESOLVED','NEW'); INSERT INTO bugs_activity VALUES (20,4,'2001-10-16 16:12:11',11,'FIXED',''); INSERT INTO bugs_activity VALUES (20,4,'2001-10-16 16:12:26',8,'CLOSED','RESOLVED'); INSERT INTO bugs_activity VALUES (21,3,'2001-10-16 16:14:14',8,'ASSIGNED','NEW'); INSERT INTO bugs_activity VALUES (21,3,'2001-10-16 16:14:30',8,'RESOLVED','ASSIGNED'); INSERT INTO bugs_activity VALUES (21,3,'2001-10-16 16:14:30',11,'INVALID',''); INSERT INTO bugs_activity VALUES (21,3,'2001-10-16 16:14:44',8,'VERIFIED','RESOLVED'); INSERT INTO bugs_activity VALUES (21,3,'2001-10-16 16:14:54',8,'CLOSED','VERIFIED'); INSERT INTO bugs_activity VALUES (22,3,'2001-10-16 16:15:48',8,'RESOLVED','NEW'); INSERT INTO bugs_activity VALUES (22,3,'2001-10-16 16:15:48',11,'WONTFIX',''); INSERT INTO bugs_activity VALUES (22,3,'2001-10-16 16:16:03',8,'CLOSED','RESOLVED'); INSERT INTO bugs_activity VALUES (23,2,'2001-10-16 16:17:23',8,'RESOLVED','NEW'); INSERT INTO bugs_activity VALUES (23,2,'2001-10-16 16:17:23',11,'LATER',''); INSERT INTO bugs_activity VALUES (23,2,'2001-10-16 16:17:35',8,'CLOSED','RESOLVED'); INSERT INTO bugs_activity VALUES (24,2,'2001-10-16 16:19:09',8,'RESOLVED','NEW'); INSERT INTO bugs_activity VALUES (24,2,'2001-10-16 16:19:09',11,'REMIND',''); INSERT INTO bugs_activity VALUES (24,5,'2001-10-16 16:19:42',8,'CLOSED','RESOLVED'); INSERT INTO bugs_activity VALUES (25,5,'2001-10-16 16:21:21',8,'RESOLVED','NEW'); INSERT INTO bugs_activity VALUES (25,5,'2001-10-16 16:21:21',11,'DUPLICATE',''); INSERT INTO bugs_activity VALUES (4,5,'2001-10-16 16:21:21',19,'rb@ravenbrook.com',''); INSERT INTO bugs_activity VALUES (25,5,'2001-10-16 16:21:34',8,'CLOSED','RESOLVED'); INSERT INTO bugs_activity VALUES (26,5,'2001-10-16 16:22:34',8,'ASSIGNED','NEW'); INSERT INTO bugs_activity VALUES (26,5,'2001-10-16 16:22:56',8,'RESOLVED','ASSIGNED'); INSERT INTO bugs_activity VALUES (26,5,'2001-10-16 16:22:56',11,'WORKSFORME',''); INSERT INTO bugs_activity VALUES (26,5,'2001-10-16 16:23:12',8,'CLOSED','RESOLVED'); INSERT INTO bugs_activity VALUES (28,5,'2001-10-16 16:24:51',8,'RESOLVED','NEW'); INSERT INTO bugs_activity VALUES (28,5,'2001-10-16 16:24:51',11,'LATER',''); INSERT INTO bugs_activity VALUES (28,5,'2001-10-16 16:25:10',8,'REOPENED','RESOLVED'); INSERT INTO bugs_activity VALUES (28,5,'2001-10-16 16:25:10',11,'','LATER'); INSERT INTO bugs_activity VALUES (1,5,'2001-10-16 16:25:25',8,'RESOLVED','NEW'); INSERT INTO bugs_activity VALUES (1,5,'2001-10-16 16:25:25',11,'WORKSFORME',''); INSERT INTO bugs_activity VALUES (28,5,'2001-10-16 16:25:56',8,'RESOLVED','REOPENED'); INSERT INTO bugs_activity VALUES (28,5,'2001-10-16 16:25:56',11,'WORKSFORME',''); INSERT INTO bugs_activity VALUES (31,5,'2001-10-16 16:28:18',8,'ASSIGNED','NEW'); INSERT INTO bugs_activity VALUES (32,5,'2001-10-16 16:29:19',8,'RESOLVED','NEW'); INSERT INTO bugs_activity VALUES (32,5,'2001-10-16 16:29:19',11,'FIXED',''); INSERT INTO bugs_activity VALUES (32,5,'2001-10-16 16:29:32',8,'REOPENED','RESOLVED'); INSERT INTO bugs_activity VALUES (32,5,'2001-10-16 16:29:32',11,'','FIXED'); INSERT INTO bugs_activity VALUES (1,5,'2001-10-16 16:30:06',2,'bug 1.1.1',''); INSERT INTO bugs_activity VALUES (15,5,'2001-10-16 16:30:51',2,'','VERIFIED/LATER'); # # Table structure for table 'cc' # CREATE TABLE cc ( bug_id mediumint(9) NOT NULL default '0', who mediumint(9) NOT NULL default '0', PRIMARY KEY (bug_id,who), KEY who (who) ) TYPE=MyISAM; # # Dumping data for table 'cc' # INSERT INTO cc VALUES (1,5); INSERT INTO cc VALUES (2,3); INSERT INTO cc VALUES (4,5); INSERT INTO cc VALUES (29,5); # # Table structure for table 'components' # CREATE TABLE components ( value tinytext, program varchar(64) default NULL, initialowner mediumint(9) NOT NULL default '0', initialqacontact mediumint(9) NOT NULL default '0', description mediumtext NOT NULL ) TYPE=MyISAM; # # Dumping data for table 'components' # INSERT INTO components VALUES ('component 1.1','product 1',3,0,'Component 1 for product 1'); INSERT INTO components VALUES ('component 1.2','product 1',5,0,'Component 2 for product 1.'); INSERT INTO components VALUES ('component 2.1','product 2',2,0,'Component 1 for product 2.'); INSERT INTO components VALUES ('component 2.2','product 2',4,0,'Component 2 for product 2.'); INSERT INTO components VALUES ('unconf1','unconfirmed',2,0,'first component of \'unconfirmed\' product'); INSERT INTO components VALUES ('unconf2','unconfirmed',3,0,'Second component of \'unconfirmed\' product'); INSERT INTO components VALUES ('group1','group',5,0,'first component of \'group\' product'); INSERT INTO components VALUES ('group2','group',4,0,'Second component of \'group\' product'); # # Table structure for table 'dependencies' # CREATE TABLE dependencies ( blocked mediumint(9) NOT NULL default '0', dependson mediumint(9) NOT NULL default '0', KEY blocked (blocked), KEY dependson (dependson) ) TYPE=MyISAM; # # Dumping data for table 'dependencies' # INSERT INTO dependencies VALUES (12,11); INSERT INTO dependencies VALUES (5,12); # # Table structure for table 'duplicates' # CREATE TABLE duplicates ( dupe_of mediumint(9) NOT NULL default '0', dupe mediumint(9) NOT NULL default '0', PRIMARY KEY (dupe) ) TYPE=MyISAM; # # Dumping data for table 'duplicates' # INSERT INTO duplicates VALUES (2,10); INSERT INTO duplicates VALUES (1,18); INSERT INTO duplicates VALUES (4,25); # # Table structure for table 'fielddefs' # CREATE TABLE fielddefs ( fieldid mediumint(9) NOT NULL auto_increment, name varchar(64) NOT NULL default '', description mediumtext NOT NULL, mailhead tinyint(4) NOT NULL default '0', sortkey smallint(6) NOT NULL default '0', PRIMARY KEY (fieldid), UNIQUE KEY name (name), KEY sortkey (sortkey) ) TYPE=MyISAM; # # 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',0,9); INSERT INTO fielddefs VALUES (10,'keywords','Keywords',0,10); INSERT INTO fielddefs VALUES (11,'resolution','Resolution',0,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',1,18); INSERT INTO fielddefs VALUES (19,'cc','CC',1,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); INSERT INTO fielddefs VALUES (30,'groupset','groupset',0,0); # # Table structure for table 'groups' # CREATE TABLE groups ( bit bigint(20) NOT NULL default '0', name varchar(255) NOT NULL default '', description text NOT NULL, isbuggroup tinyint(4) NOT NULL default '0', userregexp tinytext NOT NULL, isactive tinyint(4) NOT NULL default '1', PRIMARY KEY (name), UNIQUE KEY bit (bit) ) TYPE=MyISAM; # # Dumping data for table 'groups' # INSERT INTO groups VALUES (1,'tweakparams','Can tweak operating parameters',0,'',1); INSERT INTO groups VALUES (2,'editusers','Can edit or disable users',0,'',1); INSERT INTO groups VALUES (4,'creategroups','Can create and destroy groups.',0,'',1); INSERT INTO groups VALUES (8,'editcomponents','Can create, destroy, and edit components.',0,'',1); INSERT INTO groups VALUES (16,'editkeywords','Can create, destroy, and edit keywords.',0,'',1); INSERT INTO groups VALUES (32,'editbugs','Can edit all aspects of any bug.',0,'.*',1); INSERT INTO groups VALUES (64,'canconfirm','Can confirm a bug.',0,'.*',1); INSERT INTO groups VALUES (256,'group','group Bugs Access',1,'',1); # # Table structure for table 'keyworddefs' # CREATE TABLE keyworddefs ( id smallint(6) NOT NULL default '0', name varchar(64) NOT NULL default '', description mediumtext, PRIMARY KEY (id), UNIQUE KEY name (name) ) TYPE=MyISAM; # # Dumping data for table 'keyworddefs' # # # Table structure for table 'keywords' # CREATE TABLE keywords ( bug_id mediumint(9) NOT NULL default '0', keywordid smallint(6) NOT NULL default '0', PRIMARY KEY (bug_id,keywordid), KEY keywordid (keywordid) ) TYPE=MyISAM; # # Dumping data for table 'keywords' # # # Table structure for table 'logincookies' # CREATE TABLE logincookies ( cookie mediumint(9) NOT NULL auto_increment, userid mediumint(9) NOT NULL default '0', cryptpassword varchar(34) default NULL, hostname varchar(128) default NULL, lastused timestamp(14) NOT NULL, PRIMARY KEY (cookie), KEY lastused (lastused) ) TYPE=MyISAM; # # Dumping data for table 'logincookies' # INSERT INTO logincookies VALUES (1,1,'0X1TBswiBl8Pc','193.112.141.254',20010925155018); INSERT INTO logincookies VALUES (2,1,'AmKZcay58SjEk','193.112.141.254',20010925155124); INSERT INTO logincookies VALUES (3,4,'UcaZVIiRorCbY','193.112.141.254',20010925155424); INSERT INTO logincookies VALUES (4,5,'fTwEjmW8Ohp/A','193.112.141.254',20010925160222); INSERT INTO logincookies VALUES (5,5,'fTwEjmW8Ohp/A','193.112.141.254',20010925160732); INSERT INTO logincookies VALUES (6,2,'xKIWbJSg2svyI','193.112.141.254',20010925160823); INSERT INTO logincookies VALUES (7,3,'ztk5OoGybwvh.','193.112.141.254',20010925161404); INSERT INTO logincookies VALUES (8,2,'xKIWbJSg2svyI','193.112.141.249',20011016153915); INSERT INTO logincookies VALUES (9,1,'AmKZcay58SjEk','193.112.141.249',20011016160015); INSERT INTO logincookies VALUES (10,3,'ztk5OoGybwvh.','193.112.141.254',20011016155009); INSERT INTO logincookies VALUES (11,5,'fTwEjmW8Ohp/A','193.112.141.254',20011016155637); INSERT INTO logincookies VALUES (12,3,'ztk5OoGybwvh.','193.112.141.254',20011016155855); INSERT INTO logincookies VALUES (13,4,'UcaZVIiRorCbY','193.112.141.254',20011016160220); INSERT INTO logincookies VALUES (14,2,'xKIWbJSg2svyI','193.112.141.249',20011016161218); INSERT INTO logincookies VALUES (15,3,'ztk5OoGybwvh.','193.112.141.254',20011016160657); INSERT INTO logincookies VALUES (16,2,'xKIWbJSg2svyI','193.112.141.254',20011016160741); INSERT INTO logincookies VALUES (17,5,'fTwEjmW8Ohp/A','193.112.141.254',20011016161128); INSERT INTO logincookies VALUES (18,4,'UcaZVIiRorCbY','193.112.141.254',20011016161256); INSERT INTO logincookies VALUES (19,3,'ztk5OoGybwvh.','193.112.141.254',20011016161643); INSERT INTO logincookies VALUES (20,2,'xKIWbJSg2svyI','193.112.141.254',20011016161909); INSERT INTO logincookies VALUES (21,5,'fTwEjmW8Ohp/A','193.112.141.249',20011016163139); INSERT INTO logincookies VALUES (22,5,'fTwEjmW8Ohp/A','193.112.141.254',20011016163051); # # Table structure for table 'longdescs' # CREATE TABLE longdescs ( bug_id mediumint(9) NOT NULL default '0', who mediumint(9) NOT NULL default '0', bug_when datetime NOT NULL default '0000-00-00 00:00:00', thetext mediumtext, KEY bug_id (bug_id), KEY who (who), KEY bug_when (bug_when) ) TYPE=MyISAM; # # Dumping data for table 'longdescs' # INSERT INTO longdescs VALUES (1,4,'2001-09-25 15:53:14','Bug 1 for component 1 of product 1.'); INSERT INTO longdescs VALUES (2,5,'2001-09-25 16:07:32','Bug 1 for component 2 of product 1'); INSERT INTO longdescs VALUES (3,2,'2001-09-25 16:08:23','Bug 1 for component 1 of product 2'); INSERT INTO longdescs VALUES (4,3,'2001-09-25 16:14:04','Bug 1 for component 2 of product 2.'); INSERT INTO longdescs VALUES (5,3,'2001-10-16 15:50:09','This is a bug to test status=RESOLVED, resolution=FIXED.'); INSERT INTO longdescs VALUES (5,5,'2001-10-16 15:51:09','Accepted bug.\n'); INSERT INTO longdescs VALUES (5,5,'2001-10-16 15:52:59','Set resolution to FIXED.\n'); INSERT INTO longdescs VALUES (6,5,'2001-10-16 15:53:56','This tests status=RESOLVED, resolution=INVALID.'); INSERT INTO longdescs VALUES (7,5,'2001-10-16 15:55:13','Tests status=RESOLVED, resolution=WONTFIX.'); INSERT INTO longdescs VALUES (7,5,'2001-10-16 15:55:39','Resolved bug, changing resolution to WONTFIX\n'); INSERT INTO longdescs VALUES (8,5,'2001-10-16 15:56:37','Tests status=RESOLVED, resolution=LATER'); INSERT INTO longdescs VALUES (8,3,'2001-10-16 15:57:27','Resolved bug, changing resolution to LATER.\n'); INSERT INTO longdescs VALUES (9,3,'2001-10-16 15:58:05','This tests status=RESOLVED, resolution=REMIND.'); INSERT INTO longdescs VALUES (10,3,'2001-10-16 15:58:55','This tests status=RESOLVED, resolution=DUPLICATE.'); INSERT INTO longdescs VALUES (10,4,'2001-10-16 15:59:38','Resolved bug as duplicate.\n\n\n*** This bug has been marked as a duplicate of 2 ***'); INSERT INTO longdescs VALUES (2,4,'2001-10-16 15:59:39','*** Bug 10 has been marked as a duplicate of this bug. ***'); INSERT INTO longdescs VALUES (11,4,'2001-10-16 16:00:35','Tests status=VERIFIED, resolved=FIXED.'); INSERT INTO longdescs VALUES (11,4,'2001-10-16 16:01:02','Resolved as FIXED.\n'); INSERT INTO longdescs VALUES (11,4,'2001-10-16 16:01:26','Marked as verified.\n'); INSERT INTO longdescs VALUES (12,4,'2001-10-16 16:02:00','Tests status=VERIFIED, resolution=INVALID.'); INSERT INTO longdescs VALUES (12,4,'2001-10-16 16:02:20','Resolved as INVALKID.\n'); INSERT INTO longdescs VALUES (12,3,'2001-10-16 16:03:04','Marked as VERIFIED.\n'); INSERT INTO longdescs VALUES (13,3,'2001-10-16 16:03:52','Tests status=VERIFIED, resolution=WONTFIX.'); INSERT INTO longdescs VALUES (13,3,'2001-10-16 16:04:10','Resolved as WONTFIX.\n'); INSERT INTO longdescs VALUES (13,3,'2001-10-16 16:04:49','Marked as VERIFIED.\n'); INSERT INTO longdescs VALUES (14,2,'2001-10-16 16:05:00','Here is the first longdesc entry.\n It has a line with leading whitespace.\nAnd a line with trailing whitespace. \n And a line with both. \nAnd a whitespace-only line.\nAnd whitespace at the end.'); INSERT INTO longdescs VALUES (14,2,'2001-10-16 16:05:19','-'); INSERT INTO longdescs VALUES (15,3,'2001-10-16 16:05:36','Tests status=VERIFIED, resolution=LATER.'); INSERT INTO longdescs VALUES (16,3,'2001-10-16 16:05:37','Tests status=VERIFIED, resolution=LATER.'); INSERT INTO longdescs VALUES (14,2,'2001-10-16 16:05:44','There was a longdesc entry which was nearly empty.'); INSERT INTO longdescs VALUES (16,3,'2001-10-16 16:05:55','Resolved as LATER.\n'); INSERT INTO longdescs VALUES (14,2,'2001-10-16 16:06:06','The next longdesc entry will be just whitespace.'); INSERT INTO longdescs VALUES (16,3,'2001-10-16 16:06:11','Marked as VERIFIED.\n'); INSERT INTO longdescs VALUES (17,3,'2001-10-16 16:06:57','Tests status=VERIFIED, resolution=REMIND'); INSERT INTO longdescs VALUES (14,2,'2001-10-16 16:07:20','That longdesc was just three spaces. It doesn\'t seem to have appeared.'); INSERT INTO longdescs VALUES (17,2,'2001-10-16 16:07:41','Resolved as REMIND.\n'); INSERT INTO longdescs VALUES (17,5,'2001-10-16 16:08:14','Marked as VERIFIED.\n'); INSERT INTO longdescs VALUES (14,2,'2001-10-16 16:08:32','Indeed; longdescs which are whitespace only do not appear at all.\n \nHere\'s another attempt at a longdesc with a whitespace-only line.\nI\'m sure I had one of these when I was testing before.'); INSERT INTO longdescs VALUES (18,5,'2001-10-16 16:08:45','Tests status=VERIFIED, resolution=DUPLICATE.'); INSERT INTO longdescs VALUES (18,5,'2001-10-16 16:09:02','Accepted.\n'); INSERT INTO longdescs VALUES (18,5,'2001-10-16 16:09:23','Resolved as DUPLICATE.\n\n\n*** This bug has been marked as a duplicate of 1 ***'); INSERT INTO longdescs VALUES (1,5,'2001-10-16 16:09:24','*** Bug 18 has been marked as a duplicate of this bug. ***'); INSERT INTO longdescs VALUES (14,2,'2001-10-16 16:09:39','That\'s better.\nNow here\'s a longdesc with a couple of whitespace-only lines\nat the end:\n \n \n'); INSERT INTO longdescs VALUES (18,5,'2001-10-16 16:09:40','Marked as VERIFIED.\n'); INSERT INTO longdescs VALUES (19,5,'2001-10-16 16:10:14','Tests status=VBERIFIED, resolution=WORKSFORME.'); INSERT INTO longdescs VALUES (19,5,'2001-10-16 16:10:31','Accepted.\n'); INSERT INTO longdescs VALUES (14,2,'2001-10-16 16:10:33',' \n \nThose appear to have come through. This longdesc has a couple of \nwhitespace-only lines at the beginning.'); INSERT INTO longdescs VALUES (19,5,'2001-10-16 16:10:46','Resolved as WORKSFORME.\n'); INSERT INTO longdescs VALUES (19,5,'2001-10-16 16:10:57','Marked as VERIFIED.\n'); INSERT INTO longdescs VALUES (14,2,'2001-10-16 16:11:05','OK, now some really blank lines at the end.\n\n\n\n'); INSERT INTO longdescs VALUES (20,5,'2001-10-16 16:11:28','Tests status=CLOSED, resolution=FIXED.'); INSERT INTO longdescs VALUES (20,4,'2001-10-16 16:12:11','Resolved as FIXED.\n'); INSERT INTO longdescs VALUES (14,2,'2001-10-16 16:12:18','Those blank lines appear in the database but not on the web form.'); INSERT INTO longdescs VALUES (20,4,'2001-10-16 16:12:26','Marked as CLOSED.\n'); INSERT INTO longdescs VALUES (21,4,'2001-10-16 16:12:56','Tests status=CLOSED, resolution=INVALID.'); INSERT INTO longdescs VALUES (21,3,'2001-10-16 16:14:14','Accepted.\n'); INSERT INTO longdescs VALUES (21,3,'2001-10-16 16:14:30','Resolved as INVALID.\n'); INSERT INTO longdescs VALUES (21,3,'2001-10-16 16:14:44','Marked as VERIFIED.\n'); INSERT INTO longdescs VALUES (21,3,'2001-10-16 16:14:54','Marked as CLOSED.\n'); INSERT INTO longdescs VALUES (22,3,'2001-10-16 16:15:32','Tests status=CLOSED, resolution=WONTFIX.'); INSERT INTO longdescs VALUES (22,3,'2001-10-16 16:15:48','Resolved as WONTFIX.\n'); INSERT INTO longdescs VALUES (22,3,'2001-10-16 16:16:03','Marked CLOSED.\n'); INSERT INTO longdescs VALUES (23,3,'2001-10-16 16:16:43','Tests status=CLOSED, resolution=LATER.'); INSERT INTO longdescs VALUES (23,2,'2001-10-16 16:17:23','Resolved as LATER.\n'); INSERT INTO longdescs VALUES (23,2,'2001-10-16 16:17:35','Marked as CLOSED.\n'); INSERT INTO longdescs VALUES (14,5,'2001-10-16 16:18:00','Now some longdescs from a different person.'); INSERT INTO longdescs VALUES (14,5,'2001-10-16 16:18:18','And another.'); INSERT INTO longdescs VALUES (24,2,'2001-10-16 16:18:56','Tests status=CLOSED, resolution=REMIND.'); INSERT INTO longdescs VALUES (24,2,'2001-10-16 16:19:09','Resolved as REMIND\n'); INSERT INTO longdescs VALUES (24,5,'2001-10-16 16:19:42','Marked as CLOSED.\n'); INSERT INTO longdescs VALUES (25,5,'2001-10-16 16:21:04','Tests status=CLOSED, resolution=DUPLICATE.'); INSERT INTO longdescs VALUES (25,5,'2001-10-16 16:21:21','Resolved as duplicate.\n\n\n*** This bug has been marked as a duplicate of 4 ***'); INSERT INTO longdescs VALUES (4,5,'2001-10-16 16:21:22','*** Bug 25 has been marked as a duplicate of this bug. ***'); INSERT INTO longdescs VALUES (25,5,'2001-10-16 16:21:34','Marked as CLOSED.\n'); INSERT INTO longdescs VALUES (26,5,'2001-10-16 16:22:17','Tests status=CLOSED, resolution=WORKSFORME.'); INSERT INTO longdescs VALUES (26,5,'2001-10-16 16:22:34','Accepted.\n'); INSERT INTO longdescs VALUES (26,5,'2001-10-16 16:22:56','Resolved as WORKSFORME.\n'); INSERT INTO longdescs VALUES (26,5,'2001-10-16 16:23:12','Marked as CLOSED.\n'); INSERT INTO longdescs VALUES (27,5,'2001-10-16 16:23:45','Here is an unconfirmed bug. We need one for testing.'); INSERT INTO longdescs VALUES (28,5,'2001-10-16 16:24:17','Tests status=RESOLVED, resolution=WORKSFORME.'); INSERT INTO longdescs VALUES (28,5,'2001-10-16 16:24:51','Resolved as LATER.\n'); INSERT INTO longdescs VALUES (1,5,'2001-10-16 16:25:25','Resolved as WORKSFORME.\n'); INSERT INTO longdescs VALUES (29,5,'2001-10-16 16:25:43','This bug has lots of ccs.'); INSERT INTO longdescs VALUES (28,5,'2001-10-16 16:25:56','Resolved as WORKSFORME.\n'); INSERT INTO longdescs VALUES (30,5,'2001-10-16 16:27:41','Tests status=NEW.'); INSERT INTO longdescs VALUES (31,5,'2001-10-16 16:28:10','Tests status=ASSIGNED.'); INSERT INTO longdescs VALUES (32,5,'2001-10-16 16:29:05','Tests status=REOPENED.'); INSERT INTO longdescs VALUES (32,5,'2001-10-16 16:29:19','Resolved as FIXED.\n'); INSERT INTO longdescs VALUES (32,5,'2001-10-16 16:29:32','Reopened.\n'); INSERT INTO longdescs VALUES (15,5,'2001-10-16 16:30:51','Empty summary.\n'); # # Table structure for table 'milestones' # CREATE TABLE milestones ( value varchar(20) NOT NULL default '', product varchar(64) NOT NULL default '', sortkey smallint(6) NOT NULL default '0', PRIMARY KEY (product,value) ) TYPE=MyISAM; # # Dumping data for table 'milestones' # INSERT INTO milestones VALUES ('---','product 1',0); INSERT INTO milestones VALUES ('---','product 2',0); INSERT INTO milestones VALUES ('---','unconfirmed',0); INSERT INTO milestones VALUES ('---','group',0); # # Table structure for table 'namedqueries' # CREATE TABLE namedqueries ( userid mediumint(9) NOT NULL default '0', name varchar(64) NOT NULL default '', watchfordiffs tinyint(4) NOT NULL default '0', linkinfooter tinyint(4) NOT NULL default '0', query mediumtext NOT NULL, PRIMARY KEY (userid,name), KEY watchfordiffs (watchfordiffs) ) TYPE=MyISAM; # # Dumping data for table 'namedqueries' # # # Table structure for table 'products' # CREATE TABLE products ( product varchar(64) default NULL, description mediumtext, milestoneurl tinytext NOT NULL, disallownew tinyint(4) NOT NULL default '0', votesperuser smallint(6) NOT NULL default '0', maxvotesperbug smallint(6) NOT NULL default '10000', votestoconfirm smallint(6) NOT NULL default '0', defaultmilestone varchar(20) NOT NULL default '---' ) TYPE=MyISAM; # # Dumping data for table 'products' # INSERT INTO products VALUES ('product 1','Test product 1','',0,0,10000,0,'---'); INSERT INTO products VALUES ('product 2','Test product 2','',0,0,10000,0,'---'); INSERT INTO products VALUES ('unconfirmed','A product which has UNCONFIRMED bugs','',0,0,10000,10,'---'); INSERT INTO products VALUES ('group','a product with a bug group, from which we can exclude some users','',0,0,10000,0,'---'); # # Table structure for table 'profiles' # CREATE TABLE profiles ( userid mediumint(9) NOT NULL auto_increment, login_name varchar(255) NOT NULL default '', cryptpassword varchar(34) default NULL, realname varchar(255) default NULL, groupset bigint(20) NOT NULL default '0', disabledtext mediumtext NOT NULL, mybugslink tinyint(4) NOT NULL default '1', blessgroupset bigint(20) NOT NULL default '0', emailflags mediumtext, PRIMARY KEY (userid), UNIQUE KEY login_name (login_name) ) TYPE=MyISAM; # # Dumping data for table 'profiles' # INSERT INTO profiles VALUES (1,'gdr+bugzilla@ravenbrook.com','AmKZcay58SjEk','Gareth Rees',9223372036854775807,'',1,0,'ExcludeSelf~on~emailOwnerRemoveme~~emailOwnerComments~~emailOwnerAttachments~~emailOwnerStatus~~emailOwnerResolved~~emailOwnerKeywords~~emailOwnerCC~~emailOwnerOther~~emailReporterRemoveme~~emailReporterComments~~emailReporterAttachments~~emailReporterStatus~~emailReporterResolved~~emailReporterKeywords~~emailReporterCC~~emailReporterOther~~emailQAcontactRemoveme~~emailQAcontactComments~~emailQAcontactAttachments~~emailQAcontactStatus~~emailQAcontactResolved~~emailQAcontactKeywords~~emailQAcontactCC~~emailQAcontactOther~~emailCClistRemoveme~~emailCClistComments~~emailCClistAttachments~~emailCClistStatus~~emailCClistResolved~~emailCClistKeywords~~emailCClistCC~~emailCClistOther~~emailVoterRemoveme~~emailVoterComments~~emailVoterAttachments~~emailVoterStatus~~emailVoterResolved~~emailVoterKeywords~~emailVoterCC~~emailVoterOther~'); INSERT INTO profiles VALUES (2,'nb@ravenbrook.com','xKIWbJSg2svyI','Nick Barnes',352,'',1,0,'ExcludeSelf~on~emailOwnerRemoveme~~emailOwnerComments~~emailOwnerAttachments~~emailOwnerStatus~~emailOwnerResolved~~emailOwnerKeywords~~emailOwnerCC~~emailOwnerOther~~emailReporterRemoveme~~emailReporterComments~~emailReporterAttachments~~emailReporterStatus~~emailReporterResolved~~emailReporterKeywords~~emailReporterCC~~emailReporterOther~~emailQAcontactRemoveme~~emailQAcontactComments~~emailQAcontactAttachments~~emailQAcontactStatus~~emailQAcontactResolved~~emailQAcontactKeywords~~emailQAcontactCC~~emailQAcontactOther~~emailCClistRemoveme~~emailCClistComments~~emailCClistAttachments~~emailCClistStatus~~emailCClistResolved~~emailCClistKeywords~~emailCClistCC~~emailCClistOther~~emailVoterRemoveme~~emailVoterComments~~emailVoterAttachments~~emailVoterStatus~~emailVoterResolved~~emailVoterKeywords~~emailVoterCC~~emailVoterOther~'); INSERT INTO profiles VALUES (3,'gdr@ravenbrook.com','ztk5OoGybwvh.','Gareth Rees',352,'',1,0,'ExcludeSelf~on~emailOwnerRemoveme~~emailOwnerComments~~emailOwnerAttachments~~emailOwnerStatus~~emailOwnerResolved~~emailOwnerKeywords~~emailOwnerCC~~emailOwnerOther~~emailReporterRemoveme~~emailReporterComments~~emailReporterAttachments~~emailReporterStatus~~emailReporterResolved~~emailReporterKeywords~~emailReporterCC~~emailReporterOther~~emailQAcontactRemoveme~~emailQAcontactComments~~emailQAcontactAttachments~~emailQAcontactStatus~~emailQAcontactResolved~~emailQAcontactKeywords~~emailQAcontactCC~~emailQAcontactOther~~emailCClistRemoveme~~emailCClistComments~~emailCClistAttachments~~emailCClistStatus~~emailCClistResolved~~emailCClistKeywords~~emailCClistCC~~emailCClistOther~~emailVoterRemoveme~~emailVoterComments~~emailVoterAttachments~~emailVoterStatus~~emailVoterResolved~~emailVoterKeywords~~emailVoterCC~~emailVoterOther~'); INSERT INTO profiles VALUES (4,'ndl@ravenbrook.com','UcaZVIiRorCbY','Nick Levine',352,'',1,0,'ExcludeSelf~on~emailOwnerRemoveme~~emailOwnerComments~~emailOwnerAttachments~~emailOwnerStatus~~emailOwnerResolved~~emailOwnerKeywords~~emailOwnerCC~~emailOwnerOther~~emailReporterRemoveme~~emailReporterComments~~emailReporterAttachments~~emailReporterStatus~~emailReporterResolved~~emailReporterKeywords~~emailReporterCC~~emailReporterOther~~emailQAcontactRemoveme~~emailQAcontactComments~~emailQAcontactAttachments~~emailQAcontactStatus~~emailQAcontactResolved~~emailQAcontactKeywords~~emailQAcontactCC~~emailQAcontactOther~~emailCClistRemoveme~~emailCClistComments~~emailCClistAttachments~~emailCClistStatus~~emailCClistResolved~~emailCClistKeywords~~emailCClistCC~~emailCClistOther~~emailVoterRemoveme~~emailVoterComments~~emailVoterAttachments~~emailVoterStatus~~emailVoterResolved~~emailVoterKeywords~~emailVoterCC~~emailVoterOther~'); INSERT INTO profiles VALUES (5,'rb@ravenbrook.com','fTwEjmW8Ohp/A','Richard Brooksby',352,'',1,0,'ExcludeSelf~on~emailOwnerRemoveme~~emailOwnerComments~~emailOwnerAttachments~~emailOwnerStatus~~emailOwnerResolved~~emailOwnerKeywords~~emailOwnerCC~~emailOwnerOther~~emailReporterRemoveme~~emailReporterComments~~emailReporterAttachments~~emailReporterStatus~~emailReporterResolved~~emailReporterKeywords~~emailReporterCC~~emailReporterOther~~emailQAcontactRemoveme~~emailQAcontactComments~~emailQAcontactAttachments~~emailQAcontactStatus~~emailQAcontactResolved~~emailQAcontactKeywords~~emailQAcontactCC~~emailQAcontactOther~~emailCClistRemoveme~~emailCClistComments~~emailCClistAttachments~~emailCClistStatus~~emailCClistResolved~~emailCClistKeywords~~emailCClistCC~~emailCClistOther~~emailVoterRemoveme~~emailVoterComments~~emailVoterAttachments~~emailVoterStatus~~emailVoterResolved~~emailVoterKeywords~~emailVoterCC~~emailVoterOther~'); INSERT INTO profiles VALUES (6,'nb+p4dti-replicator0@ravenbrook.com','x5llgroRjNYY2','P4DTI replicator',352,'P4DTI replicator -- not a real user.',1,0,'ExcludeSelf~on~emailOwnerRemoveme~~emailOwnerComments~~emailOwnerAttachments~~emailOwnerStatus~~emailOwnerResolved~~emailOwnerKeywords~~emailOwnerCC~~emailOwnerOther~~emailReporterRemoveme~~emailReporterComments~~emailReporterAttachments~~emailReporterStatus~~emailReporterResolved~~emailReporterKeywords~~emailReporterCC~~emailReporterOther~~emailQAcontactRemoveme~~emailQAcontactComments~~emailQAcontactAttachments~~emailQAcontactStatus~~emailQAcontactResolved~~emailQAcontactKeywords~~emailQAcontactCC~~emailQAcontactOther~~emailCClistRemoveme~~emailCClistComments~~emailCClistAttachments~~emailCClistStatus~~emailCClistResolved~~emailCClistKeywords~~emailCClistCC~~emailCClistOther~~emailVoterRemoveme~~emailVoterComments~~emailVoterAttachments~~emailVoterStatus~~emailVoterResolved~~emailVoterKeywords~~emailVoterCC~~emailVoterOther~'); INSERT INTO profiles VALUES (7,'nb+disabled@ravenbrook.com','yREXPOEijS9xw','First Disabled User',352,'this user is broken because he has a \"disable text\"',1,0,'ExcludeSelf~on~emailOwnerRemoveme~~emailOwnerComments~~emailOwnerAttachments~~emailOwnerStatus~~emailOwnerResolved~~emailOwnerKeywords~~emailOwnerCC~~emailOwnerOther~~emailReporterRemoveme~~emailReporterComments~~emailReporterAttachments~~emailReporterStatus~~emailReporterResolved~~emailReporterKeywords~~emailReporterCC~~emailReporterOther~~emailQAcontactRemoveme~~emailQAcontactComments~~emailQAcontactAttachments~~emailQAcontactStatus~~emailQAcontactResolved~~emailQAcontactKeywords~~emailQAcontactCC~~emailQAcontactOther~~emailCClistRemoveme~~emailCClistComments~~emailCClistAttachments~~emailCClistStatus~~emailCClistResolved~~emailCClistKeywords~~emailCClistCC~~emailCClistOther~~emailVoterRemoveme~~emailVoterComments~~emailVoterAttachments~~emailVoterStatus~~emailVoterResolved~~emailVoterKeywords~~emailVoterCC~~emailVoterOther~'); INSERT INTO profiles VALUES (8,'nb+notingroup@ravenbrook.com','DLsAFggNEswqE','A User Not in a Group',96,'',1,0,'ExcludeSelf~on~emailOwnerRemoveme~~emailOwnerComments~~emailOwnerAttachments~~emailOwnerStatus~~emailOwnerResolved~~emailOwnerKeywords~~emailOwnerCC~~emailOwnerOther~~emailReporterRemoveme~~emailReporterComments~~emailReporterAttachments~~emailReporterStatus~~emailReporterResolved~~emailReporterKeywords~~emailReporterCC~~emailReporterOther~~emailQAcontactRemoveme~~emailQAcontactComments~~emailQAcontactAttachments~~emailQAcontactStatus~~emailQAcontactResolved~~emailQAcontactKeywords~~emailQAcontactCC~~emailQAcontactOther~~emailCClistRemoveme~~emailCClistComments~~emailCClistAttachments~~emailCClistStatus~~emailCClistResolved~~emailCClistKeywords~~emailCClistCC~~emailCClistOther~~emailVoterRemoveme~~emailVoterComments~~emailVoterAttachments~~emailVoterStatus~~emailVoterResolved~~emailVoterKeywords~~emailVoterCC~~emailVoterOther~'); INSERT INTO profiles VALUES (9,'user with space@ravenbrook.com','fTwEjmW8Ohp/A','User with space',352,'',1,0,'ExcludeSelf~on~emailOwnerRemoveme~~emailOwnerComments~~emailOwnerAttachments~~emailOwnerStatus~~emailOwnerResolved~~emailOwnerKeywords~~emailOwnerCC~~emailOwnerOther~~emailReporterRemoveme~~emailReporterComments~~emailReporterAttachments~~emailReporterStatus~~emailReporterResolved~~emailReporterKeywords~~emailReporterCC~~emailReporterOther~~emailQAcontactRemoveme~~emailQAcontactComments~~emailQAcontactAttachments~~emailQAcontactStatus~~emailQAcontactResolved~~emailQAcontactKeywords~~emailQAcontactCC~~emailQAcontactOther~~emailCClistRemoveme~~emailCClistComments~~emailCClistAttachments~~emailCClistStatus~~emailCClistResolved~~emailCClistKeywords~~emailCClistCC~~emailCClistOther~~emailVoterRemoveme~~emailVoterComments~~emailVoterAttachments~~emailVoterStatus~~emailVoterResolved~~emailVoterKeywords~~emailVoterCC~~emailVoterOther~'); # # Table structure for table 'profiles_activity' # CREATE TABLE profiles_activity ( userid mediumint(9) NOT NULL default '0', who mediumint(9) NOT NULL default '0', profiles_when datetime NOT NULL default '0000-00-00 00:00:00', fieldid mediumint(9) NOT NULL default '0', oldvalue tinytext, newvalue tinytext, KEY userid (userid), KEY profiles_when (profiles_when), KEY fieldid (fieldid) ) TYPE=MyISAM; # # Dumping data for table 'profiles_activity' # INSERT INTO profiles_activity VALUES (3,1,'2001-10-16 15:56:33',30,'96','352'); INSERT INTO profiles_activity VALUES (7,1,'2001-10-16 15:56:50',30,'96','352'); INSERT INTO profiles_activity VALUES (2,1,'2001-10-16 15:57:21',30,'96','352'); INSERT INTO profiles_activity VALUES (4,1,'2001-10-16 15:57:34',30,'96','352'); INSERT INTO profiles_activity VALUES (5,1,'2001-10-16 15:57:45',30,'96','352'); INSERT INTO profiles_activity VALUES (6,1,'2001-10-16 15:58:01',30,'96','352'); # # Table structure for table 'shadowlog' # CREATE TABLE shadowlog ( id int(11) NOT NULL auto_increment, ts timestamp(14) NOT NULL, reflected tinyint(4) NOT NULL default '0', command mediumtext NOT NULL, PRIMARY KEY (id), KEY reflected (reflected) ) TYPE=MyISAM; # # Dumping data for table 'shadowlog' # # # Table structure for table 'tokens' # CREATE TABLE tokens ( userid mediumint(9) NOT NULL default '0', issuedate datetime NOT NULL default '0000-00-00 00:00:00', token varchar(16) NOT NULL default '', tokentype varchar(8) NOT NULL default '', eventdata tinytext, PRIMARY KEY (token), KEY userid (userid) ) TYPE=MyISAM; # # Dumping data for table 'tokens' # # # Table structure for table 'versions' # CREATE TABLE versions ( value tinytext, program varchar(64) NOT NULL default '' ) TYPE=MyISAM; # # Dumping data for table 'versions' # INSERT INTO versions VALUES ('unspecified','product 1'); INSERT INTO versions VALUES ('unspecified','product 2'); INSERT INTO versions VALUES ('unspecified','unconfirmed'); INSERT INTO versions VALUES ('unspecified','group'); # # Table structure for table 'votes' # CREATE TABLE votes ( who mediumint(9) NOT NULL default '0', bug_id mediumint(9) NOT NULL default '0', count smallint(6) NOT NULL default '0', KEY who (who), KEY bug_id (bug_id) ) TYPE=MyISAM; # # Dumping data for table 'votes' # # # Table structure for table 'watch' # CREATE TABLE watch ( watcher mediumint(9) NOT NULL default '0', watched mediumint(9) NOT NULL default '0', PRIMARY KEY (watcher,watched), KEY watched (watched) ) TYPE=MyISAM; # # Dumping data for table 'watch' #