sajXewVk

1CREATE TABLE IF NOT EXISTS `bug` (
2  `idBug` int(11) NOT NULL AUTO_INCREMENT,
3  `refStatus` int(11) NOT NULL,
4  `author` varchar(255) NOT NULL,
5  `summary` text NOT NULL,
6  `plateform` varchar(255) NOT NULL,
7  `phpVersion` varchar(255) NOT NULL,
8  `branch` varchar(255) NOT NULL,
9  `composant` varchar(255) NOT NULL,
10  `do` longtext NOT NULL,
11  `did` longtext NOT NULL,
12  `want` longtext NOT NULL,
13  `hashControl` varchar(255) NOT NULL,
14  `timeCreate` date NOT NULL,
15  `timeClose` date NOT NULL,
16  PRIMARY KEY (`idBug`),
17  FULLTEXT KEY `summary` (`summary`,`do`,`did`,`want`)
18) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;