DROP TABLE feature; DROP TABLE feature_change; DROP TABLE feature_comment; DELETE FROM field_def WHERE tablesql = 'feature'; DELETE FROM fktable WHERE tablesql = 'feature';
CREATE TABLE `feature` (
`featureId` int(10) unsigned NOT NULL auto_increment,
`create_by` int(10) unsigned default NULL,
`createTS` int(10) unsigned NOT NULL default '0',
`mod_by` int(10) unsigned default NULL,
`modifyTS` int(10) unsigned NOT NULL default '0',
`_Title` mediumtext,
`_Product` enum('--','Widget') default NULL,
`_State` enum('--','Proposed','Accepted','Scheduled','Development','Testing','Shipped') default NULL,
`_Priority` int(11) default NULL,
`_Dpndncs` text,
`_Owner` mediumint(8) unsigned default NULL,
`_Dv_MnWks` float default NULL,
`_Tst_MnWks` float default NULL,
`_Definition` text,
`_Trgt_Rls` enum('--','0.9','1.0','1.1','2.0') default NULL,
`changeId` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`featureId`),
KEY `modifyTS` (`modifyTS`),
KEY `_Priority` (`_Priority`,`_State`),
KEY `_Owner` (`_Owner`),
KEY `_Product` (`_Product`),
KEY `_Title` (`_Title`(15))
) TYPE=MyISAM;
CREATE TABLE `feature_change` (
`changeId` int(10) unsigned NOT NULL auto_increment,
`featureId` int(10) unsigned NOT NULL default '0',
`createTS` int(10) unsigned NOT NULL default '0',
`create_by` int(10) unsigned NOT NULL default '0',
`fieldId` mediumint(8) unsigned NOT NULL default '0',
`old_val` text,
PRIMARY KEY (`changeId`),
KEY `featureId` (`featureId`,`createTS`),
KEY `featureId_2` (`featureId`,`changeId`),
KEY `create_by` (`create_by`,`createTS`),
KEY `fieldId` (`fieldId`,`createTS`)
) TYPE=MyISAM;
CREATE TABLE `feature_comment` (
`commentId` int(10) unsigned NOT NULL auto_increment,
`featureId` int(10) unsigned NOT NULL default '0',
`create_by` int(10) unsigned default NULL,
`createTS` int(10) unsigned NOT NULL default '0',
`mod_by` int(10) unsigned default NULL,
`modifyTS` int(10) unsigned NOT NULL default '0',
`format` enum('text','html') default NULL,
`subject` text,
`body` text,
`changeId` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`commentId`),
KEY `featureId` (`featureId`,`createTS`),
KEY `featureId_2` (`featureId`,`changeId`),
KEY `create_by` (`create_by`,`createTS`),
FULLTEXT KEY `subject` (`subject`,`body`)
) TYPE=MyISAM;
INSERT INTO field_def (fieldName, tablesql, sqlName, type, mult_choices,
min, max, deflt, read_only, on_edit_form, on_new_form, list_show,
cmt_list_show, basic_search, adv_search, new_summary, cmt_summary, batch,
rset_on_dup, unique_, create_by, createTS, mod_by, modifyTS, sort,
short_help, long_help, width, height, changeId, fixed_sql) VALUES
('Title', 'feature', '_Title', 'oneline', NULL, NULL, NULL, '', '0', '1', '1', '1', '1', '1', '1', '1', '1', '0', '0', '1', NULL, '1118599764', NULL, '1118599764', '100', '', NULL, '80', '8', '0', '0'),
('Product', 'feature', '_Product', 'mult_choice', '--
Widget
', NULL, NULL, '--', '0', '1', '1', '1', '0', '1', '1', '1', '1', '1', '0', '0', NULL, '1118599764', NULL, '1118599764', '200', '', NULL, '80', '8', '0', '0'),
('State', 'feature', '_State', 'mult_choice', '--
Proposed
Accepted
Scheduled
Development
Testing
Shipped
', NULL, NULL, '--', '0', '1', '1', '1', '0', '1', '1', '0', '1', '1', '0', '0', NULL, '1118599764', NULL, '1118599764', '200', '', NULL, '80', '8', '0', '0'),
('Priority', 'feature', '_Priority', 'integer', NULL, NULL, NULL, '100', '0', '1', '1', '1', '0', '1', '1', '1', '1', '1', '0', '0', NULL, '1118599764', NULL, '1118599764', '200', '(1 is most urgent)', NULL, '80', '8', '0', '0'),
('Target Release', 'feature', '_Trgt_Rls', 'mult_choice', '--
0.9
1.0
1.1
2.0
', NULL, NULL, '1.0', '0', '1', '1', '1', '0', '1', '1', '0', '0', '1', '0', '0', NULL, '1118599764', NULL, '1118599764', '200', '', NULL, '80', '8', '0', '0'),
('Owner', 'feature', '_Owner', 'user', NULL, NULL, NULL, '', '0', '1', '1', '1', '0', '0', '1', '0', '0', '1', '0', '0', NULL, '1118599764', NULL, '1118599764', '250', '', NULL, '80', '8', '0', '0'),
('Dependencies', 'feature', '_Dpndncs', 'oneline', NULL, NULL, NULL, '', '0', '1', '1', '1', '0', '0', '1', '0', '0', '0', '0', '0', NULL, '1118599764', NULL, '1118599764', '260', '', NULL, '80', '8', '0', '0'),
('Dev. Man-Weeks', 'feature', '_Dv_MnWks', 'float', NULL, '0', NULL, '100', '0', '1', '1', '1', '0', '0', '1', '0', '0', '1', '0', '0', NULL, '1118599764', NULL, '1118599764', '300', '', NULL, '80', '8', '0', '0'),
('Test Man-Weeks', 'feature', '_Tst_MnWks', 'float', NULL, '0', NULL, '100', '0', '1', '1', '1', '0', '0', '1', '0', '0', '1', '0', '0', NULL, '1118599764', NULL, '1118599764', '300', '', NULL, '80', '8', '0', '0'),
('Definition', 'feature', '_Definition', 'multiline', NULL, NULL, NULL, '', '0', '1', '1', '0', '0', '0', '1', '1', '0', '0', '0', '0', NULL, '1118599764', NULL, '1118599764', '400', '', NULL, '80', '8', '0', '0'),
('Creator', 'feature', 'create_by', 'user', NULL, NULL, NULL, NULL, '1', '1', '0', '1', '0', '0', '1', '0', '0', '1', '0', '0', NULL, '1118599764', NULL, '1118599764', '10040', '', NULL, '80', '8', '0', '1'),
('Create Time', 'feature', 'createTS', 'unix_ts', NULL, NULL, NULL, '0', '1', '1', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', NULL, '1118599764', NULL, '1118599764', '10042', '', NULL, '80', '8', '0', '1'),
('Last Modifier', 'feature', 'mod_by', 'user', NULL, NULL, NULL, NULL, '1', '1', '0', '1', '0', '0', '1', '0', '0', '1', '0', '0', NULL, '1118599764', NULL, '1118599764', '10044', '', NULL, '80', '8', '0', '1'),
('Last Modify Time', 'feature', 'modifyTS', 'unix_ts', NULL, NULL, NULL, '0', '1', '1', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', NULL, '1118599764', NULL, '1118599764', '10046', '', NULL, '80', '8', '0', '1');
INSERT INTO fktable (name, recprefix, url, tablesql, pkey, internal,
changes, comments, ext_mod, down_maint, descrip, advertise, create_by,
createTS, mod_by, modifyTS, sort) VALUES
('Feature', 'f', 'feature', 'feature', 'featureId', '0', '1', '1', '0', '', 'Please customize me.', '1', NULL, '1118599763', NULL, '1118599763', '1000');
FeatureKong 3.0pre19 Warning: These are static pages for demonstration. Many of the links will not work.