1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35
|
CREATE TABLE IF NOT EXISTS `mantis_bug_table` (
`id` int(7) unsigned NOT NULL auto_increment,
<b>`project_id` int(7) unsigned NOT NULL default '0',</b>
`reporter_id` int(7) unsigned NOT NULL default '0',
`handler_id` int(7) unsigned NOT NULL default '0',
`duplicate_id` int(7) unsigned NOT NULL default '0',
`priority` int(2) NOT NULL default '30',
`severity` int(2) NOT NULL default '50',
`reproducibility` int(2) NOT NULL default '10',
`status` int(2) NOT NULL default '10',
`resolution` int(2) NOT NULL default '10',
`projection` int(2) NOT NULL default '10',
`category` varchar(64) NOT NULL default '',
`date_submitted` datetime NOT NULL default '1970-01-01 00:00:01',
`last_updated` datetime NOT NULL default '1970-01-01 00:00:01',
`eta` int(2) NOT NULL default '10',
`bug_text_id` int(7) unsigned NOT NULL default '0',
`os` varchar(32) NOT NULL default '',
`os_build` varchar(32) NOT NULL default '',
`platform` varchar(32) NOT NULL default '',
`version` varchar(64) NOT NULL default '',
`fixed_in_version` varchar(64) NOT NULL default '',
`build` varchar(32) NOT NULL default '',
`profile_id` int(7) unsigned NOT NULL default '0',
`view_state` int(2) NOT NULL default '10',
`summary` varchar(128) NOT NULL default '',
`sponsorship_total` int(7) NOT NULL default '0',
`sticky` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `sponsorship_total` (`sponsorship_total`),
KEY `fixed_in_version` (`fixed_in_version`),
KEY `status` (`status`),
KEY `project_id` (`project_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=0 AUTO_INCREMENT=1368 ; |