View file sql.sql

-- HOOF_CHAT_v1.5 --
CREATE TABLE `antirekl` (
  `id_ant` int(255) NOT NULL auto_increment,
  `ant` varchar(1000) character set utf8 NOT NULL,
  PRIMARY KEY  (`id_ant`)
) ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=cp1251 AUTO_INCREMENT=18 ;

INSERT INTO `antirekl` VALUES (1, '.ru');
INSERT INTO `antirekl` VALUES (2, '.su');
INSERT INTO `antirekl` VALUES (3, '.net');
INSERT INTO `antirekl` VALUES (4, '.org');
INSERT INTO `antirekl` VALUES (5, '.ws');
INSERT INTO `antirekl` VALUES (6, '.info');
INSERT INTO `antirekl` VALUES (7, '.com');
INSERT INTO `antirekl` VALUES (8, '.wen');
INSERT INTO `antirekl` VALUES (9, '.biz');
INSERT INTO `antirekl` VALUES (10, '.us');
INSERT INTO `antirekl` VALUES (11, '.cn');
INSERT INTO `antirekl` VALUES (12, '.pp');
INSERT INTO `antirekl` VALUES (13, '.ua');
INSERT INTO `antirekl` VALUES (14, '.kmx');
INSERT INTO `antirekl` VALUES (15, 'http://');
INSERT INTO `antirekl` VALUES (16, '.vg');

CREATE TABLE `banned` (
  `id_ban` int(255) NOT NULL auto_increment,
  `ipban` varchar(100) NOT NULL,
  `btime` int(255) NOT NULL,
  `id_user` int(255) NOT NULL,
  PRIMARY KEY  (`id_ban`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

CREATE TABLE `messages` (
  `id_mes` int(255) NOT NULL auto_increment,
  `id_user` int(255) NOT NULL,
  `id_room` int(255) NOT NULL,
  `mtext` varchar(1000) character set utf8 default NULL,
  `mdate` varchar(50) NOT NULL,
  `mtime` varchar(20) NOT NULL,
  `sect` int(255) NOT NULL,
  PRIMARY KEY  (`id_mes`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

CREATE TABLE `rooms` (
  `id_room` int(255) NOT NULL auto_increment,
  `name` varchar(300) character set utf8 NOT NULL,
  `opis` varchar(500) character set utf8 default NULL,
  PRIMARY KEY  (`id_room`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

CREATE TABLE `system` (
  `vict_status` int(255) NOT NULL,
  `vict_room` int(255) NOT NULL,
  `vopros_zadan` int(255) NOT NULL,
  `vremya` int(255) NOT NULL,
  `otvet` varchar(200) character set utf8 default NULL,
  `podsk` int(1) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;

INSERT INTO `system` VALUES (0, 1, 0, 1233726475, '', 0);

CREATE TABLE `users` (
  `id_user` int(255) NOT NULL auto_increment,
  `login` varchar(30) NOT NULL,
  `pass` varchar(400) default NULL,
  `status` varchar(10) NOT NULL,
  `rdate` varchar(30) NOT NULL,
  `posts` int(255) NOT NULL default '0',
  `pol` int(1) NOT NULL,
  `color` varchar(50) NOT NULL,
  `avob` int(2) NOT NULL default '30',
  `kols` int(2) NOT NULL default '10',
  `last` int(255) NOT NULL,
  `info` varchar(1000) character set utf8 default NULL,
  `icq` int(12) default NULL,
  `email` varchar(200) NOT NULL,
  `data` int(2) NOT NULL,
  `mesyac` int(2) NOT NULL,
  `god` int(4) NOT NULL,
  `sec_code` varchar(255) NOT NULL,
  PRIMARY KEY  (`id_user`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=cp1251 AUTO_INCREMENT=3 ;

INSERT INTO `users` VALUES (1, 'admin', '827ccb0eea8a706c4c34a16891f84e7b', 'admin', '01.01.1990 - 00:00:00', 306, 1, '#ff5000', 99, 3, 1233726910, '', 478884835, '[email protected]', 20, 11, 1990, '');
INSERT INTO `users` VALUES (2, 'UmNik', '827ccb0eea8a706c4c34a16891f84e7b', '', '01.01.1990 - 00:00:00', 0, 1, '#ff7000', 0, 0, 1233726657, '', 0, '', 0, 0, 0, '');

CREATE TABLE `voprosy` (
  `id_vop` int(255) NOT NULL auto_increment,
  `vopros` varchar(1000) character set utf8 default NULL,
  `otvet` varchar(200) character set utf8 default NULL,
  `status` int(1) NOT NULL,
  PRIMARY KEY  (`id_vop`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;