walzer / tasktracer Goto Github PK

What steps will reproduce the problem?
1. 访问默认页面，创建数据库成功
2. 全新安装，创建表失败


What is the expected output? What do you see instead?
需要用哪个版本的mysql？需要做什么配置？

What version of the product are you using? On what operating system?
0.1.0 和 trunk18 都存在

Please provide any additional information below.

ERROR OCCUR TO /tasktracer/install.php:
 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM DEFAULT CHARSET=UTF8' at line 62

 The FULL SQL IS:
 CREATE TABLE `tt_BugInfo` ( `BugID` mediumint(7) unsigned NOT NULL auto_increment, `ProjectID` smallint(5) unsigned NOT NULL default '0', `ProjectName` varchar(100) NOT NULL default '', `ModuleID` int(10) unsigned NOT NULL default '0', `ModulePath` varchar(240) NOT NULL default '', `BugTitle` varchar(150) default NULL, `BugSeverity` tinyint(4) NOT NULL default '0', `BugPriority` tinyint(4) default NULL, `BugType` varchar(20) NOT NULL default '', `BugOS` varchar(100) default NULL, `BugBrowser` varchar(100) default NULL, `BugMachine` varchar(255) default NULL, `HowFound` varchar(50) default NULL, `ReproSteps` text, `BugStatus` varchar(20) NOT NULL default '', `BugSubStatus` varchar(50) NOT NULL default '', `LinkID` varchar(255) default NULL, `CaseID` varchar(255) default NULL, `DuplicateID` varchar(255) default NULL, `MailTo` varchar(255) NOT NULL default '', `OpenedBy` varchar(30) NOT NULL default '', `OpenedDate` datetime NOT NULL default '0000-00-00 00:00:00', `OpenedBuild` varchar(100) NOT NULL default '', `AssignedTo` varchar(30) NOT NULL default '', `AssignedDate` datetime NOT NULL default '0000-00-00 00:00:00', `ResolvedBy` varchar(30) NOT NULL default '', `Resolution` varchar(20) NOT NULL default '', `ResolvedBuild` varchar(100) NOT NULL default '', `ResolvedDate` datetime NOT NULL default '0000-00-00 00:00:00', `ClosedBy` varchar(30) NOT NULL default '', `ClosedDate` datetime NOT NULL default '0000-00-00 00:00:00', `LastEditedBy` varchar(30) NOT NULL default '', `LastEditedDate` datetime NOT NULL default '0000-00-00 00:00:00', `ModifiedBy` text, `BugKeyword` varchar(255) default NULL, `ResultID` mediumint(8) unsigned default NULL, `CustomField1` varchar(255) default NULL, `CustomField2` varchar(255) default NULL, `CustomField3` varchar(255) default NULL, `IsDroped` enum('1','0') NOT NULL default '0', `BugScore` TINYINT NOT NULL DEFAULT '1', `FixQuality` FLOAT NOT NULL DEFAULT '1', `BugAffairStr` VARCHAR( 100 ) DEFAULT NULL , `UnlistedScore` TINYINT UNSIGNED NULL DEFAULT '0', `Deadline` DATETIME NULL DEFAULT '0000-00-00 00:00:00', `DeadlineStatus` VARCHAR( 20 ) DEFAULT NULL, PRIMARY KEY (`BugID`), KEY `ModuleID` (`ModuleID`), KEY `BugTitle` (`BugTitle`), KEY `BugSeverity` (`BugSeverity`), KEY `BugType` (`BugType`), KEY `BugStatus` (`BugStatus`), KEY `OpenedBy` (`OpenedBy`), KEY `AssignedTo` (`AssignedTo`), KEY `ResolvedBy` (`ResolvedBy`), KEY `Resolution` (`Resolution`), KEY `ClosedBy` (`ClosedBy`), KEY `LastEditedBy` (`LastEditedBy`), KEY `BugScore` (`BugScore`), KEY `DeadlineStatus` (`DeadlineStatus`) ) TYPE=MyISAM DEFAULT CHARSET=UTF8

Feature TBD:
1、在任务中加入紧前紧后关系。
2、在父模块中可以查看并链接所有子模块所包含的任务
3、任务状态中加入预审。预审->解决->审核->关闭。预审主要�
��来对开发者分配给自己的工作
量估分进行确认