# MySQL dump 8.13
#
# Host: localhost Database: gdr_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('blocker','critical','major','normal','minor','trivial','enhancement') NOT NULL default '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'
#
#
# 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'
#
#
# 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'
#
#
# 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 ('project','infosys',8,0,'The infosys project itself.');
INSERT INTO components VALUES ('mmref','mmref',8,0,'The Memory Management Reference web site');
INSERT INTO components VALUES ('mps','mps',6,0,'The Memory Pools System.');
INSERT INTO components VALUES ('project','mps',6,0,'The MPS project itself.');
INSERT INTO components VALUES ('p4dti','p4dti',4,0,'The Perforce Defect Tracking Integration with Bugzilla');
INSERT INTO components VALUES ('project','p4dti',4,0,'The P4DTI project itself.');
INSERT INTO components VALUES ('project','p4report',7,0,'The P4Report project itself.');
INSERT INTO components VALUES ('project','p4sr',8,0,'The P4SR project itself.');
INSERT INTO components VALUES ('project','www.ravenbrook.com',8,0,'The Ravenbrook web site project itself.');
#
# 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'
#
#
# 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'
#
#
# 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);
#
# 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,'Gyy19sDNX4Klk','193.112.141.254',20011127171152);
#
# 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'
#
#
# 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 ('---','p4dti',0);
INSERT INTO milestones VALUES ('---','p4sr',0);
INSERT INTO milestones VALUES ('---','p4report',0);
INSERT INTO milestones VALUES ('---','www.ravenbrook.com',0);
INSERT INTO milestones VALUES ('---','mps',0);
INSERT INTO milestones VALUES ('---','mmref',0);
INSERT INTO milestones VALUES ('---','infosys',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 'p4dti_bugs'
#
CREATE TABLE p4dti_bugs (
bug_id mediumint(9) NOT NULL default '0',
rid varchar(32) NOT NULL default '',
sid varchar(32) NOT NULL default '',
jobname text NOT NULL,
migrated datetime default NULL,
PRIMARY KEY (bug_id),
KEY bug_id (bug_id)
) TYPE=MyISAM;
#
# Dumping data for table 'p4dti_bugs'
#
#
# Table structure for table 'p4dti_bugs_activity'
#
CREATE TABLE p4dti_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',
oldvalue tinytext,
newvalue tinytext,
rid varchar(32) NOT NULL default '',
sid varchar(32) NOT NULL default '',
KEY bug_id (bug_id),
KEY bug_when (bug_when)
) TYPE=MyISAM;
#
# Dumping data for table 'p4dti_bugs_activity'
#
#
# Table structure for table 'p4dti_changelists'
#
CREATE TABLE p4dti_changelists (
changelist int(11) NOT NULL default '0',
rid varchar(32) NOT NULL default '',
sid varchar(32) NOT NULL default '',
user mediumint(9) NOT NULL default '0',
flags int(11) NOT NULL default '0',
description longtext NOT NULL,
client text NOT NULL,
p4date text NOT NULL,
PRIMARY KEY (changelist,rid,sid)
) TYPE=MyISAM;
#
# Dumping data for table 'p4dti_changelists'
#
#
# Table structure for table 'p4dti_config'
#
CREATE TABLE p4dti_config (
rid varchar(32) NOT NULL default '',
sid varchar(32) NOT NULL default '',
config_key text NOT NULL,
config_value longtext,
KEY rid (rid,sid)
) TYPE=MyISAM;
#
# Dumping data for table 'p4dti_config'
#
INSERT INTO p4dti_config VALUES ('replicator0','perforce0','schema_version','3');
INSERT INTO p4dti_config VALUES ('replicator0','perforce0','p4_server_description','Perforce server on thrush.ravenbrook.com:16668');
INSERT INTO p4dti_config VALUES ('replicator0','perforce0','replicator_user','gdr+p4dti-replicator0@ravenbrook.com');
#
# Table structure for table 'p4dti_filespecs'
#
CREATE TABLE p4dti_filespecs (
bug_id mediumint(9) NOT NULL default '0',
rid varchar(32) NOT NULL default '',
sid varchar(32) NOT NULL default '',
filespec longtext NOT NULL,
KEY bug_id (bug_id)
) TYPE=MyISAM;
#
# Dumping data for table 'p4dti_filespecs'
#
#
# Table structure for table 'p4dti_fixes'
#
CREATE TABLE p4dti_fixes (
changelist int(11) NOT NULL default '0',
bug_id mediumint(9) NOT NULL default '0',
rid varchar(32) NOT NULL default '',
sid varchar(32) NOT NULL default '',
user mediumint(9) NOT NULL default '0',
client text NOT NULL,
status text NOT NULL,
p4date text NOT NULL,
PRIMARY KEY (bug_id,changelist,rid,sid),
KEY bug_id_2 (bug_id)
) TYPE=MyISAM;
#
# Dumping data for table 'p4dti_fixes'
#
#
# Table structure for table 'p4dti_replications'
#
CREATE TABLE p4dti_replications (
rid varchar(32) NOT NULL default '',
sid varchar(32) NOT NULL default '',
start datetime NOT NULL default '0000-00-00 00:00:00',
end datetime NOT NULL default '0000-00-00 00:00:00',
id int(11) NOT NULL auto_increment,
PRIMARY KEY (start,rid,sid,id),
UNIQUE KEY id (id),
KEY rid (rid,sid),
KEY end (end)
) TYPE=MyISAM;
#
# Dumping data for table 'p4dti_replications'
#
INSERT INTO p4dti_replications VALUES ('replicator0','perforce0','1996-12-31 23:59:59','1996-12-31 23:59:59',1);
#
# 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 ('p4dti','Perforce Defect Tracking Integration','',0,0,10000,0,'---');
INSERT INTO products VALUES ('p4sr','Perforce Sample Repository','',0,0,10000,0,'---');
INSERT INTO products VALUES ('p4report','Perforce reporting','',0,0,10000,0,'---');
INSERT INTO products VALUES ('www.ravenbrook.com','Ravenbrook web site','',0,0,10000,0,'---');
INSERT INTO products VALUES ('mps','Memory Pool System','',0,0,10000,0,'---');
INSERT INTO products VALUES ('mmref','Memory Management Reference','',0,0,10000,0,'---');
INSERT INTO products VALUES ('infosys','Ravenbrook Information System','',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','Gyy19sDNX4Klk','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,'gdr+p4dti-replicator0@ravenbrook.com','cAzyWgwZjf5t2','P4DTI replicator 0',0,'Special user representing P4DTI replicator.',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,'dsm@ravenbrook.com','3sHgPnF4Doidc','David Moore',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 (4,'gdr@ravenbrook.com','3sHgPnF4Doidc','Gareth Rees',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 (6,'nb@ravenbrook.com','3sHgPnF4Doidc','Nick Barnes',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 (7,'ndl@ravenbrook.com','3sHgPnF4Doidc','Nick Levine',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 (8,'rb@ravenbrook.com','3sHgPnF4Doidc','Richard Brooksby',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,'lmb@ravenbrook.com','3sHgPnF4Doidc','Leah Bateman',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~');
#
# 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 (2,1,'2001-11-27 16:52:09',30,'96','0');
#
# 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','p4dti');
INSERT INTO versions VALUES ('unspecified','p4sr');
INSERT INTO versions VALUES ('unspecified','p4report');
INSERT INTO versions VALUES ('unspecified','www.ravenbrook.com');
INSERT INTO versions VALUES ('unspecified','mps');
INSERT INTO versions VALUES ('unspecified','mmref');
INSERT INTO versions VALUES ('unspecified','infosys');
#
# 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'
#