CREATE TABLE `forum` (
`id` int(10) NOT NULL auto_increment,
`name` varchar(250) default NULL,
`message` varchar(250) default NULL,
`topic` varchar(10) default NULL,
`date` varchar(15) default NULL,
`room` int(3) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM ;
-- --------------------------------------------------------
--
-- Структура таблицы `rating`
--
CREATE TABLE `rating` (
`id` int(10) NOT NULL auto_increment,
`room` int(3) default NULL,
`ident` int(10) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM ;
-- --------------------------------------------------------
--
-- Структура таблицы `topic`
--
CREATE TABLE `topic` (
`id` int(10) NOT NULL auto_increment,
`name` varchar(30) default NULL,
`message` text ,
`date` varchar(15) default NULL,
`room` int(2) default NULL,
`prosm` int(10) default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM ;
-- --------------------------------------------------------
--
-- Структура таблицы `users`
--
CREATE TABLE `users` (
`id` int(8) unsigned NOT NULL auto_increment,
`name` varchar(15) default NULL,
`pass` varchar(100) default NULL,
`datereg` varchar(10) default NULL,
`post` int(6) default '0',
`banned` char(1) default '0',
`status` varchar(50) default NULL,
`about` varchar(255) default NULL,
`imya` varchar(40) default NULL,
`truba` varchar(200) default NULL,
`otkuda` varchar(30) default NULL,
`oper` varchar(100) default NULL,
`work` varchar(50) default NULL,
`age` varchar(6) default '',
`setting_trans` int(2) default '0',
`email` varchar(30) default NULL,
`icq` varchar(30) default NULL,
`admin` int(1) default '0',
`forum_post` int(10) default '0',
`setting_forum` int(3) default '8',
`mops` varchar(6) default '',
`nick` text ,
`status2` varchar(200) 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) default '',
`god` varchar(12) default '',
`picture` varchar(30) default '',
`color` int(2) default '0',
`wap` int(2) default NULL,
`last` varchar(25) default NULL,
`num_tel` text ,
`vit` int(2) NOT NULL default '0',
`fon_color` varchar(7) NOT NULL default '000000',
`font_color` varchar(7) NOT NULL default 'FFD700',
`link_color` varchar(7) NOT NULL default '00FF00',
PRIMARY KEY (`id`),
KEY `id` (`id`)
) ENGINE=MyISAM ;