CREATE TABLE `bannedib` (
  `mid` int(11) NOT NULL auto_increment,
  `ip` varchar(30) NOT NULL default '',
  `browser` varchar(255) NOT NULL default '',
  `login` text NOT NULL,
  `ci` int(255) NOT NULL default '0',
  PRIMARY KEY  (`mid`)
) TYPE=MyISAM AUTO_INCREMENT=25;

CREATE TABLE `chat_ignor` (
  `id` int(11) NOT NULL auto_increment,
  `loginid` int(11) NOT NULL default '0',
  `user` text NOT NULL,
  `ci` int(11) default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=8 ;

CREATE TABLE `chat_intim` (
  `id` int(11) NOT NULL auto_increment,
  `login` text NOT NULL,
  `msg` text NOT NULL,
  `key` text,
  `time` text NOT NULL,
  `ci` int(11) default NULL,
  PRIMARY KEY  (`id`)
);

CREATE TABLE `chat_letters` (
  `id` int(11) NOT NULL auto_increment,
  `from_user` text NOT NULL,
  `to_user` text NOT NULL,
  `subject` text,
  `letter` text NOT NULL,
  `time` text NOT NULL,
  `new` int(11) default NULL,
  `ci` int(11) default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=107 ;
DROP TABLE IF EXISTS cusers;

CREATE TABLE `cusers` (
  `ci` int(11) NOT NULL auto_increment,
  `admin` text NOT NULL,
  `pass` text NOT NULL,
  `topic` text NOT NULL,
  `link` text NOT NULL,
  `name` text NOT NULL,
  `date` text NOT NULL,
  PRIMARY KEY  (`ci`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

CREATE TABLE `chat_users` (
  `id` int(11) NOT NULL auto_increment,
  `login` text NOT NULL,
  `pass` text NOT NULL,
  `name` text,
  `sex` text NOT NULL,
  `bday` int(11) default '0',
  `bmonth` int(11) default '0',
  `byear` int(11) default '0',
  `photo` text,
  `live` text,
  `mobile` text,
  `operator` text,
  `email` text,
  `wapsite` text,
  `website` text,
  `icq` int(11) default '0',
  `about` text,
  `status` text,
  `posts` int(11) NOT NULL default '0',
  `vposts` int(11) NOT NULL default '0',
  `nmsgs` int(11) default '0',
  `tupdate` int(11) default '0',
  `fsize` text,
  `ban` text,
  `breason` text,
  `btime` text,
  `room` text,
  `moder` int(11) default '0',
  `admin` int(11) default '0',
  `rtime` int(11) NOT NULL default '0',
  `ltime` int(11) NOT NULL default '0',
  `ip` text,
  `soft` text,
  `ci` int(255) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM ;


CREATE TABLE `chat_settings` (
  `id` int(11) NOT NULL auto_increment,
  `mod` text,
  `var` text,
  `val1` text,
  `val2` text,
  `val3` int(11) default '0',
  `ci` int(11) default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1336 ;

CREATE TABLE `chat_messages` (
  `id` int(11) NOT NULL auto_increment,
  `login` text NOT NULL,
  `msg` text NOT NULL,
  `pr_from` text,
  `pr_to` text,
  `time` text NOT NULL,
  `room` text,
  `ci` int(255) NOT NULL default '0',
  PRIMARY KEY  (`id`)
);

CREATE TABLE `chat_meets` (
  `id` int(11) NOT NULL auto_increment,
  `login` text NOT NULL,
  `title` text NOT NULL,
  `content` text NOT NULL,
  `organizatory` text NOT NULL,
  `ci` int(255) NOT NULL default '0',
  PRIMARY KEY  (`id`)
);
CREATE TABLE `chat_newserv` (
  `id` int(11) NOT NULL auto_increment,
  `otkogo` text NOT NULL,
  `text` text NOT NULL,
  `title` text NOT NULL,
  `ci` int(11) default NULL,
  PRIMARY KEY  (`id`)
);

CREATE TABLE `chat_unlim` (
  `id` int(11) NOT NULL auto_increment,
  `login` text NOT NULL,
  `msg` text NOT NULL,
  `pr_from` text,
  `pr_to` text,
  `time` text NOT NULL,
  `ci` int(11) default NULL,
  PRIMARY KEY  (`id`)
);

DROP TABLE IF EXISTS chat_vict;
CREATE TABLE `chat_vict` (
  `id` int(11) NOT NULL auto_increment,
  `login` text NOT NULL,
  `msg` text NOT NULL,
  `pr_from` text,
  `pr_to` text,
  `vopros` text,
  `answered` text,
  `time` text NOT NULL,
  `ci` int(255) NOT NULL default '0',
  PRIMARY KEY  (`id`)
);

CREATE TABLE `chat_news` (
  `id` int(11) NOT NULL auto_increment,
  `otkogo` text NOT NULL,
  `text` text NOT NULL,
  `title` text NOT NULL,
  `ci` int(11) default NULL,
  PRIMARY KEY  (`id`)
);


CREATE TABLE `chat_ques` (
  `id` int(11) NOT NULL auto_increment,
  `vopros` text NOT NULL,
  `otvet` text NOT NULL,
  PRIMARY KEY  (`id`)
);