Файл: sys/db_tables/forum_p.sql
Строк: 12
CREATE TABLE IF NOT EXISTS `forum_p` (
`id` int(11) NOT NULL
AUTO_INCREMENT,
`id_forum` int(11) NOT NULL,
`id_razdel` int(11) NOT
NULL,
`id_them` int(11) NOT NULL,
`id_user` int(11) NOT NULL,
`time`
int(11) NOT NULL,
`msg` varchar(1024) NOT NULL,
`cit` int(11) DEFAULT
NULL,
`opros` enum('0','1') NOT NULL DEFAULT '0',
`red` int(1) NOT NULL
DEFAULT '0',
`ban` int(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `id_user` (`id_user`),
KEY `time` (`time`),
KEY `id_forum`
(`id_forum`),
KEY `id_razdel` (`id_razdel`),
KEY `id_them`
(`id_them`),
FULLTEXT KEY `msg` (`msg`),
FULLTEXT KEY `msg_2` (`msg`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;