Просмотр архива Chats 7ba

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`)
);