1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
|
DROP TABLE IF EXISTS `term`;
CREATE TABLE `term` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL DEFAULT '',
`term_type` varchar(55) NOT NULL,
`acc` varchar(255) NOT NULL,
`is_obsolete` int(11) NOT NULL DEFAULT '0',
`is_root` int(11) NOT NULL DEFAULT '0',
`is_relation` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `acc` (`acc`),
UNIQUE KEY `t0` (`id`),
KEY `t1` (`name`),
KEY `t2` (`term_type`),
KEY `t3` (`acc`),
KEY `t4` (`id`,`acc`),
KEY `t5` (`id`,`name`),
KEY `t6` (`id`,`term_type`),
KEY `t7` (`id`,`acc`,`name`,`term_type`)
) TYPE=utf8 AUTO_INCREMENT=32195; |
Partager