CREATE TABLE `chat_users` (
`id` int(11) unsigned NOT NULL auto_increment,
`nickname` tinytext NOT NULL,
`password` tinytext NOT NULL,
`ip` tinytext NOT NULL,
`ua` text NOT NULL,
`level` tinyint(1) NOT NULL default '0',
`photo` tinytext NOT NULL,
`invisible` tinyint(1) NOT NULL default '0',
`status` tinytext NOT NULL,
`kick` int(11) unsigned NOT NULL default '0',
`moder` tinytext NOT NULL,
`reason` text NOT NULL,
`ban` tinyint(1) NOT NULL default '0',
`name` tinytext NOT NULL,
`sex` tinyint(1) NOT NULL default '0',
`email` text NOT NULL,
`site` text NOT NULL,
`birthday` tinytext NOT NULL,
`from` text NOT NULL,
`mobile` tinytext NOT NULL,
`about` text NOT NULL,
`posts` int(11) NOT NULL default '0',
`answers` int(11) NOT NULL default '0',
`gbalans` int(11) NOT NULL default '0',
`smiles` tinyint(1) NOT NULL default '1',
`translit` tinyint(1) NOT NULL default '0',
`msgs` tinyint(2) NOT NULL default '5',
`refresh` tinyint(3) unsigned NOT NULL default '20',
`fsize` tinyint(1) NOT NULL default '1',
`security` tinyint(1) NOT NULL default '1',
`place` mediumint(9) NOT NULL default '0',
`time` int(11) unsigned NOT NULL default '0',
`intim` int(11) unsigned NOT NULL default '0',
`key` tinytext NOT NULL,
`regdate` tinytext NOT NULL,
`hidden` tinyint(1) NOT NULL default '0',
`mood` tinyint(2) NOT NULL default '0',
`emotions` tinyint(1) NOT NULL default '1',
PRIMARY KEY (`id`)
) TYPE=MyISAM ;
|