CREATE TABLE `forum` (
`id` int(10) NOT NULL auto_increment,
`name` varchar(250) collate cp1251_general_cs default NULL,
`message` varchar(250) collate cp1251_general_cs default NULL,
`topic` varchar(10) collate cp1251_general_cs default NULL,
`date` varchar(15) collate cp1251_general_cs default NULL,
`room` int(3) default NULL,
PRIMARY KEY (`id`)
)
CREATE TABLE `rating` (
`id` int(10) NOT NULL auto_increment,
`room` int(3) default NULL,
`ident` int(10) default NULL,
PRIMARY KEY (`id`)
)
CREATE TABLE `topic` (
`id` int(10) NOT NULL auto_increment,
`name` varchar(30) collate cp1251_general_cs default NULL,
`message` text collate cp1251_general_cs,
`date` varchar(15) collate cp1251_general_cs default NULL,
`room` int(2) default NULL,
`prosm` int(10) default '0',
PRIMARY KEY (`id`)
)
CREATE TABLE `users` (
`id` int(8) unsigned NOT NULL auto_increment,
`name` varchar(15) collate cp1251_general_cs default NULL,
`pass` varchar(100) collate cp1251_general_cs default NULL,
`datereg` varchar(10) collate cp1251_general_cs default NULL,
`post` int(6) default '0',
`banned` char(1) collate cp1251_general_cs default '0',
`status` varchar(50) collate cp1251_general_cs default NULL,
`about` varchar(255) collate cp1251_general_cs default NULL,
`imya` varchar(40) collate cp1251_general_cs default NULL,
`truba` varchar(200) collate cp1251_general_cs default NULL,
`otkuda` varchar(30) collate cp1251_general_cs default NULL,
`oper` varchar(100) collate cp1251_general_cs default NULL,
`work` varchar(50) collate cp1251_general_cs default NULL,
`age` varchar(6) collate cp1251_general_cs default '',
`setting_trans` int(2) default '0',
`email` varchar(30) collate cp1251_general_cs default NULL,
`icq` varchar(30) collate cp1251_general_cs default NULL,
`admin` int(1) default '0',
`forum_post` int(10) default '0',
`setting_forum` int(3) default '8',
`mops` varchar(6) collate cp1251_general_cs default '',
`nick` text collate cp1251_general_cs,
`status2` varchar(200) collate cp1251_general_cs default 'User',
`setting_theme` int(3) default '10',
`setting_string` int(2) default '0',
`addmin` int(2) default '0',
`mini_chat` int(2) default '0',
`telnum` varchar(15) collate cp1251_general_cs default '',
`god` varchar(12) collate cp1251_general_cs default '',
`picture` varchar(30) collate cp1251_general_cs default '',
`color` int(2) default '0',
`wap` int(2) default NULL,
`last` varchar(25) collate cp1251_general_cs default NULL,
`num_tel` text collate cp1251_general_cs,
`vit` int(2) NOT NULL default '0',
`fon_color` varchar(7) collate cp1251_general_cs NOT NULL default '000000',
`font_color` varchar(7) collate cp1251_general_cs NOT NULL default 'FFD700',
`link_color` varchar(7) collate cp1251_general_cs NOT NULL default '00FF00',
PRIMARY KEY (`id`),
KEY `id` (`id`)
)
unsigned