Просмотр файла chat_servis/tabl.txt

Размер файла: 4.77Kb
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,
  `cid` int(255) NOT NULL default '0',
  PRIMARY KEY  (`mid`)
) TYPE=MyISAM AUTO_INCREMENT=12 ;

---------------------------------------------------------
CREATE TABLE `cusers` (
  `cid` int(11) NOT NULL auto_increment,
  `admin` text NOT NULL,
  `pass` text NOT NULL,
  `chatname` text NOT NULL,
  `link` text NOT NULL,
  `name` text NOT NULL,
  `email` text NOT NULL,
  `rdate` text NOT NULL,
  `date` text NOT NULL,
  `today` int(11) NOT NULL default '0',
  `allday` int(11) NOT NULL default '0',
  PRIMARY KEY  (`cid`)
) TYPE=MyISAM AUTO_INCREMENT=22 ;

-- 
-- Дамп данных таблицы `cusers`
-- 



------------------------------------------------------

CREATE TABLE `ignor` (
  `id` int(11) NOT NULL auto_increment,
  `kto` text NOT NULL,
  `ykogo` text NOT NULL,
  `cid` int(255) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=13 ;

-------------------------------------------------------

CREATE TABLE `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,
  `cid` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=6 ;

------------------------------------------------------

CREATE TABLE `room` (
  `id` int(11) NOT NULL auto_increment,
  `login` text NOT NULL,
  `idl` int(255) NOT NULL default '0',
  `msg` text NOT NULL,
  `room` text NOT NULL,
  `pr_from` text,
  `pr_to` text,
  `time` time NOT NULL default '00:00:00',
  `dbid` int(11) NOT NULL default '0',
  `wtime` text NOT NULL,
  `cid` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=54 ;


INSERT INTO `room` VALUES (53, 'bitel', 10, '<u><b>Всем привет ошани помогите мне общайтесь у меня</b></u>', 'room1', '-', '-', '10:13:16', 10, '1117177996', 6);
INSERT INTO `room` VALUES (52, 'Pups', 9, '<img src="smiles/smiles/smirk.gif" alt=".smirk."/>', 'room1', '-', '-', '09:26:23', 9, '1117175183', 5);
INSERT INTO `room` VALUES (51, 'Pups', 9, ':)', 'room1', '-', '-', '09:25:44', 9, '1117175144', 5);
INSERT INTO `room` VALUES (50, 'Pups', 9, 'Привет', 'room1', '-', '-', '09:25:34', 9, '1117175134', 5);
        
---------------------------------------------------------------------------

CREATE TABLE `setts` (
  `id` int(8) NOT NULL auto_increment,
  `mod` varchar(10) default NULL,
  `var` varchar(40) default NULL,
  `val1` varchar(40) default NULL,
  `val2` varchar(40) default NULL,
  `val3` int(8) default '0',
  `cid` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=492 ;
        

---------------------------------------------------------------------------

CREATE TABLE `users` (
  `id` int(11) NOT NULL auto_increment,
  `login` text NOT NULL,
  `pass` text NOT NULL,
  `name` text NOT NULL,
  `sex` text NOT NULL,
  `bday` int(11) default NULL,
  `bmonth` int(11) default NULL,
  `byear` int(11) default NULL,
  `photo` text,
  `live` text,
  `mobile` text,
  `email` text,
  `url` text,
  `about` text,
  `icq` int(9) NOT NULL default '0',
  `regdate` date NOT NULL default '0000-00-00',
  `status` text NOT NULL,
  `posts` int(11) NOT NULL default '0',
  `num_msgs` int(11) NOT NULL default '8',
  `time_update` int(11) default NULL,
  `trans` int(11) default NULL,
  `smile` int(11) default NULL,
  `ban` text,
  `banb` text NOT NULL,
  `banf` int(15) NOT NULL default '0',
  `banw` text NOT NULL,
  `moder` int(11) default NULL,
  `admin` int(11) default NULL,
  `smoder` int(11) default NULL,
  `vip` int(11) default NULL,
  `ltime` int(11) NOT NULL default '0',
  `lroom` text NOT NULL,
  `ip` varchar(30) NOT NULL default '',
  `browser` varchar(255) NOT NULL default '',
  `safe` int(2) NOT NULL default '0',
  `vposts` int(255) NOT NULL default '0',
  `fsize` varchar(10) NOT NULL default 'small',
  `cid` int(255) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=26 ;


-----------------------------------------------------------------------

CREATE TABLE `vstrechi` (
  `id` int(11) NOT NULL auto_increment,
  `login` text NOT NULL,
  `title` text NOT NULL,
  `content` text NOT NULL,
  `organizatory` text NOT NULL,
  `cid` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
        

-----------------------------------