CREATE TABLE `chat_ignor` (
`id` int(11) NOT NULL auto_increment,
`loginid` int(11) NOT NULL default '0',
`user` text NOT 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,
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,
PRIMARY KEY (`id`)
) ;
-- --------------------------------------------------------
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,
PRIMARY KEY (`id`)
) ;
-- --------------------------------------------------------
CREATE TABLE `chat_news` (
`id` int(11) NOT NULL auto_increment,
`login` text NOT NULL,
`content` text NOT NULL,
`ltime` 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`)
) ;
-- --------------------------------------------------------
CREATE TABLE `chat_settings` (
`id` int(11) NOT NULL auto_increment,
`mod` text,
`var` text,
`val1` text,
`val2` text,
`val3` int(11) default '0',
PRIMARY KEY (`id`)
) ;
-- --------------------------------------------------------
CREATE TABLE `chat_users` (
`id` int(11) NOT NULL auto_increment,
`login` varchar(15) NOT NULL,
`pass` varchar(15) NOT NULL,
`name` varchar(30) NOT NULL,
`sex` varchar(2) NOT NULL,
`bday` int(2) default '0',
`bmonth` int(2) default '0',
`byear` int(2) default '0',
`photo` text,
`live` varchar(150) NOT NULL,
`mobile` varchar(50) NOT NULL,
`operator` varchar(50) NOT NULL,
`wapsite` varchar(50) NOT NULL,
`email` varchar(30) NOT NULL,
`style` int(1) NOT NULL,
`about` text,
`status` varchar(50) NOT NULL,
`posts` int(11) NOT NULL default '0',
`vposts` int(11) NOT NULL default '0',
`nmsgs` int(11) default '0',
`tupdate` int(11) default '0',
`ban` varchar(30) NOT NULL,
`breason` text,
`btime` int(20) default '0',
`level` int(1) default '0',
`rtime` int(11) NOT NULL default '0',
`ip` text,
`soft` text,
`traf` varchar(30) NOT NULL,
`vst` int(11) default '0',
`adtime` int(50) default '0',
`atraf` int(50) default '0',
PRIMARY KEY (`id`)
) ;
-- --------------------------------------------------------
CREATE TABLE `chat_vopros` (
`id` int(11) NOT NULL default '0',
`login` text NOT NULL,
`msg` text NOT NULL,
`vopros` text,
`answered` text,
`time` text NOT NULL,
PRIMARY KEY (`id`)
) ;
CREATE TABLE `chat_session` (
`id` int(11) NOT NULL auto_increment,
`login` varchar(15) NOT NULL,
`session` varchar(100) NOT NULL,
`timeout` int(40) default '0',
`online` int(2) default '0',
PRIMARY KEY (`id`)
);
CREATE TABLE `aworld_u` (
`id` INT( 11 ) NOT NULL AUTO_INCREMENT ,
`login` VARCHAR( 15 ) NOT NULL ,
`psevdonim` VARCHAR( 15 ) NOT NULL ,
`time` INT( 30 ) NOT NULL ,
PRIMARY KEY ( `id` )
);
-- --------------------------------------------------------
#################################################
INSERT INTO chat_settings
VALUES ( 0, 'room', 'vict', 'vict', 'vict', '' ) ;
INSERT INTO chat_settings
VALUES ( 0, 'room', 'room1', 'room1', 'room1', '' ) ;
INSERT INTO chat_settings
VALUES ( 0, 'room', 'room2', 'room2', 'room2', '' ) ;
INSERT INTO chat_settings
VALUES ( 0, 'room', 'room3', 'room3', 'room3', '' ) ;
INSERT INTO chat_settings
VALUES ( 0, 'room', 'room4', 'room4', 'room4', '' ) ;
INSERT INTO chat_settings
VALUES ( 0, 'room', 'sort', 'sort', 'sort', '' ) ;
#################################################