View file forum/db_0001.sql

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