Файл: promotion/sql.txt
Строк: 14
CREATE TABLE `promotion`(
`id` int(11) NOT
NULL
auto_increment,
`id_user` int(11) NOT NULL,
`all` int(11) NOT
NULL,
`time` int(11) NOT NULL,
`msg` varchar(1024) NOT NULL,
PRIMARY KEY
(`id`), KEY `id_user`(`id_user`),
KEY `msg` (`msg`)) ENGINE=MyISAM DEFAULT
CHARSET=utf8;
и ещё
CREATE TABLE `otvet_tiket` (
`id` int(11) NOT
NULL auto_increment,
`id_user` int(11) NOT NULL,
`id_tiket`
varchar(50) NOT NULL,
`msg` varchar(1024) NOT NULL,
`time` int(11)
NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT
CHARSET=cp1251 AUTO_INCREMENT=1 ;
ну и
ALTER TABLE `user` ADD `mod`
enum('0','1') NOT NULL default '0';