View file sql.sql

File size: 30.48Kb
CREATE TABLE `anekdot` (
  `klu4` int(11) NOT NULL default '0',
  `message` blob NOT NULL,
  PRIMARY KEY  (`klu4`)
) TYPE=MyISAM;

CREATE TABLE `bannlist` (
  `klu4` int(11) NOT NULL auto_increment,
  `ip` varchar(255) binary NOT NULL default '',
  `soft` varchar(255) binary NOT NULL default '',
  `user` varchar(255) binary NOT NULL default '',
  PRIMARY KEY  (`klu4`)
) TYPE=MyISAM AUTO_INCREMENT=10 ;

CREATE TABLE `bomj` (
  `klu4` int(11) NOT NULL default '0',
  `night_act` text NOT NULL,
  PRIMARY KEY  (`klu4`)
) TYPE=MyISAM;

CREATE TABLE `bots` (
  `number` int(5) NOT NULL auto_increment,
  `vopros` blob NOT NULL,
  `answer` varchar(100) binary NOT NULL default '',
  `tran` varchar(60) binary NOT NULL default '',
  PRIMARY KEY  (`number`)
) TYPE=MyISAM PACK_KEYS=0 AUTO_INCREMENT=1 ;

CREATE TABLE `doktor` (
  `klu4` int(11) NOT NULL default '0',
  `night_act` text NOT NULL,
  PRIMARY KEY  (`klu4`)
) TYPE=MyISAM;
INSERT INTO `doktor` VALUES (1, '&#x414;&#x43E;&#x43A;&#x442;&#x43E;&#x440;, &#x437;&#x430;&#x445;&#x432;&#x430;&#x442;&#x438;&#x432; &#x441; &#x441;&#x43E;&#x431;&#x43E;&#x439; &#x448;&#x43F;&#x440;&#x438;&#x446; &#x43F;&#x43E;&#x431;&#x43E;&#x43B;&#x44C;&#x448;&#x435;, &#x440;&#x44B;&#x449;&#x435;&#x442; &#x43F;&#x43E; &#x433;&#x43E;&#x440;&#x43E;&#x434;&#x443;, &#x43A;&#x43E;&#x43C;&#x443; &#x436;&#x435; &#x438; &#x43A;&#x443;&#x434;&#x430; &#x435;&#x433;&#x43E; &#x432;&#x441;&#x442;&#x430;&#x432;&#x438;&#x442;&#x44C;...');

CREATE TABLE `golos` (
  `id` int(11) NOT NULL auto_increment,
  `user` int(11) NOT NULL default '0',
  `who` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM PACK_KEYS=0 AUTO_INCREMENT=1 ;

CREATE TABLE `help` (
  `rm` int(2) NOT NULL default '0',
  `who` int(10) NOT NULL default '0',
  `var` int(1) NOT NULL default '0',
  PRIMARY KEY  (`rm`)
) TYPE=MyISAM;
INSERT INTO `help` VALUES (0, 15, 0);
INSERT INTO `help` VALUES (1, 15, 0);
INSERT INTO `help` VALUES (2, 15, 0);
INSERT INTO `help` VALUES (3, 352, 0);
INSERT INTO `help` VALUES (4, 0, 0);
INSERT INTO `help` VALUES (5, 0, 0);
INSERT INTO `help` VALUES (6, 0, 0);
INSERT INTO `help` VALUES (7, 100, 0);
INSERT INTO `help` VALUES (8, 222, 0);
INSERT INTO `help` VALUES (9, 0, 0);
INSERT INTO `help` VALUES (10, 0, 0);
INSERT INTO `help` VALUES (11, 100, 0);
INSERT INTO `help` VALUES (12, 0, 0);
INSERT INTO `help` VALUES (13, 0, 0);
INSERT INTO `help` VALUES (14, 0, 0);
INSERT INTO `help` VALUES (15, 0, 0);
INSERT INTO `help` VALUES (16, 0, 0);
INSERT INTO `help` VALUES (17, 0, 0);
INSERT INTO `help` VALUES (18, 0, 0);
INSERT INTO `help` VALUES (19, 0, 0);
INSERT INTO `help` VALUES (20, 100, 0);

CREATE TABLE `ingame1` (
  `gamer_id` int(11) NOT NULL default '0',
  `role` varchar(100) NOT NULL default '',
  `gamer_act` varchar(50) NOT NULL default '',
  `id_in_game` int(11) NOT NULL default '0',
  `dvote` int(11) NOT NULL default '0',
  `wholin` int(11) NOT NULL default '0',
  `onl` int(12) NOT NULL default '0',
  `state` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`gamer_id`)
) TYPE=MyISAM;

CREATE TABLE `komissar` (
  `klu4` int(11) NOT NULL default '0',
  `night_act` text NOT NULL,
  PRIMARY KEY  (`klu4`)
) TYPE=MyISAM;
INSERT INTO `komissar` VALUES (1, '&#x418;&#x43D;&#x441;&#x43F;&#x435;&#x43A;&#x442;&#x43E;&#x440; &#x41A;&#x430;&#x442;&#x430;&#x43D;&#x438;, &#x441;&#x435;&#x432; &#x432; &#x441;&#x432;&#x43E;&#x439; &#x431;&#x43E;&#x431;&#x438;&#x43A;, &#x43F;&#x43E;&#x435;&#x445;&#x430;&#x43B; &#x438;&#x441;&#x43A;&#x430;&#x442;&#x44C; &#x43F;&#x440;&#x435;&#x441;&#x442;&#x443;&#x43F;&#x43D;&#x438;&#x43A;&#x43E;&#x432;...');

CREATE TABLE `levels` (
  `level` smallint(5) NOT NULL default '0',
  `name` blob,
  PRIMARY KEY  (`level`)
) TYPE=MyISAM;
INSERT INTO `levels` VALUES (0, 0xd094d18cd18fd0b2d0bed0bbd191d0bdd0bed0ba);
INSERT INTO `levels` VALUES (1, 0xd090d180d185d0b0d0bdd0b3d0b5d0bb);
INSERT INTO `levels` VALUES (2, 0xd090d0bdd0b3d0b5d0bbd0bed0ba);
INSERT INTO `levels` VALUES (3, 0xd090d0bdd0b3d0b5d0bb);
INSERT INTO `levels` VALUES (4, 0xd0a5d180d0b0d0bdd0b8d182d0b5d0bbd18c);
INSERT INTO `levels` VALUES (5, 0xd098d181d0bfd0bed0bbd0bdd0b8d182d0b5d0bbd18c);
INSERT INTO `levels` VALUES (6, 0xd0a1d182d0b0d180d188d0b8d0b920d0bcd0bed0b4d0b5d180);
INSERT INTO `levels` VALUES (7, 0xd090d0b4d0bcd0b8d0bd);

CREATE TABLE `maf1` (
  `klu4` int(8) NOT NULL default '0',
  `time` varchar(5) NOT NULL default '',
  `who` varchar(100) NOT NULL default '',
  `message` text NOT NULL,
  `messagewosm` text NOT NULL,
  `messagewoasm` text NOT NULL,
  `id` double NOT NULL default '0',
  `towhom` varchar(12) NOT NULL default '',
  `hid` smallint(1) NOT NULL default '0',
  `usid` int(12) NOT NULL default '0',
  `gamemes` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`klu4`)
) TYPE=MyISAM;
INSERT INTO `maf1` VALUES (1, '', '', 'Русская мафия', '', '', 2147483647, '', 0, 0, 0);

CREATE TABLE `mafaction1` (
  `klu4` tinyint(1) NOT NULL default '0',
  `action` varchar(100) NOT NULL default '',
  `nexttime` int(11) NOT NULL default '0',
  `kiked` tinyint(1) NOT NULL default '0',
  `prevprev` int(11) NOT NULL default '0',
  `prev` int(11) NOT NULL default '0',
  `current` int(11) NOT NULL default '0',
  `cround` smallint(2) NOT NULL default '0',
  PRIMARY KEY  (`klu4`)
) TYPE=MyISAM;
INSERT INTO `mafaction1` VALUES (1, 'nogame', 1153148348, 0, 4, 4, 4, 3);

CREATE TABLE `mafia` (
  `klu4` int(11) NOT NULL default '0',
  `night_act` text NOT NULL,
  PRIMARY KEY  (`klu4`)
) TYPE=MyISAM;
INSERT INTO `mafia` VALUES (1, '&#x41C;&#x430;&#x444;&#x438;&#x43E;&#x437;&#x438;, &#x432;&#x43E;&#x43E;&#x440;&#x443;&#x436;&#x438;&#x432;&#x448;&#x438;&#x441;&#x44C; &#x434;&#x43E; &#x437;&#x443;&#x431;&#x43E;&#x432;, &#x43D;&#x430;&#x43F;&#x440;&#x430;&#x432;&#x43B;&#x44F;&#x44E;&#x442;&#x441;&#x44F; &#x43D;&#x430;&#x432;&#x441;&#x442;&#x440;&#x435;&#x447;&#x443; &#x441;&#x432;&#x43E;&#x435;&#x439; &#x436;&#x435;&#x440;&#x442;&#x432;&#x435;...');

CREATE TABLE `maniac` (
  `klu4` int(11) NOT NULL default '0',
  `night_act` text NOT NULL,
  PRIMARY KEY  (`klu4`)
) TYPE=MyISAM;
INSERT INTO `maniac` VALUES (1, '&#x41C;&#x430;&#x43D;&#x44C;&#x44F;&#x43A; &#x43D;&#x43E;&#x441;&#x438;&#x442;&#x441;&#x44F; &#x441; &#x442;&#x43E;&#x43F;&#x43E;&#x440;&#x43E;&#x43C; &#x432; &#x440;&#x443;&#x43A;&#x430;&#x445; &#x43F;&#x43E; &#x442;&#x435;&#x43C;&#x43D;&#x44B;&#x43C; &#x43F;&#x435;&#x440;&#x435;&#x443;&#x43B;&#x43A;&#x430;&#x43C;...');

CREATE TABLE `news` (
  `id` int(11) NOT NULL auto_increment,
  `login` varchar(50) NOT NULL default '',
  `content` blob NOT NULL,
  `date` varchar(10) default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM PACK_KEYS=0 AUTO_INCREMENT=1 ;

CREATE TABLE `obiav` (
  `id` int(11) NOT NULL auto_increment,
  `login` text NOT NULL,
  `title` text NOT NULL,
  `content` text NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

CREATE TABLE `optim` (
  `klu4` tinyint(1) NOT NULL default '0',
  `go` int(11) NOT NULL default '0',
  `anekdot` int(11) NOT NULL default '0',
  PRIMARY KEY  (`klu4`)
) TYPE=MyISAM;
INSERT INTO `optim` VALUES (1, 1153469697, 1098370704);

CREATE TABLE `room0` (
  `klu4` int(8) NOT NULL default '0',
  `time` varchar(5) NOT NULL default '',
  `who` varchar(40) NOT NULL default '',
  `message` blob NOT NULL,
  `messagewosm` blob NOT NULL,
  `messagewoasm` blob NOT NULL,
  `id` double NOT NULL default '0',
  `towhom` varchar(12) NOT NULL default '',
  `hid` smallint(1) NOT NULL default '0',
  `usid` int(12) NOT NULL default '0',
  PRIMARY KEY  (`klu4`),
  KEY `id` (`id`)
) TYPE=MyISAM;
INSERT INTO `room0` VALUES (1, '', '', 0xd093d0bed0bbd0bed0b2d0b0d181d182d0b8d0bad0b821, '', '', 2147483647, '', 0, 0);

CREATE TABLE `room1` (
  `klu4` int(8) NOT NULL default '0',
  `time` varchar(5) NOT NULL default '',
  `who` varchar(40) NOT NULL default '',
  `message` blob NOT NULL,
  `messagewosm` blob NOT NULL,
  `messagewoasm` blob NOT NULL,
  `id` double NOT NULL default '0',
  `towhom` varchar(12) NOT NULL default '',
  `hid` smallint(1) NOT NULL default '0',
  `usid` int(12) NOT NULL default '0',
  PRIMARY KEY  (`klu4`),
  KEY `id` (`id`)
) TYPE=MyISAM;
INSERT INTO `room1` VALUES (1, '', '', 0xd0a1d0bfd0b5d182d18c3f, '', '', 2147483647, '', 0, 0);

CREATE TABLE `room10` (
  `klu4` int(8) NOT NULL default '0',
  `time` varchar(5) binary NOT NULL default '',
  `who` varchar(40) NOT NULL default '',
  `message` blob NOT NULL,
  `messagewosm` blob NOT NULL,
  `messagewoasm` blob NOT NULL,
  `id` double NOT NULL default '0',
  `towhom` varchar(12) binary NOT NULL default '',
  `hid` smallint(1) NOT NULL default '0',
  `usid` int(12) NOT NULL default '0',
  `pwd` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`klu4`),
  KEY `id` (`id`)
) TYPE=MyISAM;
INSERT INTO `room10` VALUES (1, '', '', 0x486d2e2e2e65746f206e65206d6f6521, '', '', 2147483647, '', 0, 0, '');

CREATE TABLE `room11` (
  `klu4` int(8) NOT NULL default '0',
  `time` varchar(5) NOT NULL default '',
  `who` varchar(40) NOT NULL default '',
  `message` blob NOT NULL,
  `messagewosm` blob NOT NULL,
  `messagewoasm` blob NOT NULL,
  `id` double NOT NULL default '0',
  `towhom` varchar(12) NOT NULL default '',
  `hid` smallint(1) NOT NULL default '0',
  `usid` int(12) NOT NULL default '0',
  PRIMARY KEY  (`klu4`),
  KEY `id` (`id`)
) TYPE=MyISAM;
INSERT INTO `room11` VALUES (1, '', '', 0x2a536f6c6e7973686b6f2a202b20d090d0b2d0bed181d18c, '', '', 2147483647, '', 0, 0);

CREATE TABLE `room12` (
  `klu4` int(8) NOT NULL default '0',
  `time` varchar(5) NOT NULL default '',
  `who` varchar(40) NOT NULL default '',
  `message` blob NOT NULL,
  `messagewosm` blob NOT NULL,
  `messagewoasm` blob NOT NULL,
  `id` double NOT NULL default '0',
  `towhom` varchar(12) NOT NULL default '',
  `hid` smallint(1) NOT NULL default '0',
  `usid` int(12) NOT NULL default '0',
  PRIMARY KEY  (`klu4`),
  KEY `id` (`id`)
) TYPE=MyISAM;
INSERT INTO `room12` VALUES (1, '', '', 0xd096d0b8d0b2d0bed182d0bdd18bd18520d0bdd0b520d0bad0bed180d0bcd0b8d182d18c21, '', '', 2147483647, '', 0, 0);

CREATE TABLE `room13` (
  `klu4` int(8) NOT NULL default '0',
  `time` varchar(5) NOT NULL default '',
  `who` varchar(40) NOT NULL default '',
  `message` blob NOT NULL,
  `messagewosm` blob NOT NULL,
  `messagewoasm` blob NOT NULL,
  `id` double NOT NULL default '0',
  `towhom` varchar(12) NOT NULL default '',
  `hid` smallint(1) NOT NULL default '0',
  `usid` int(12) NOT NULL default '0',
  PRIMARY KEY  (`klu4`),
  KEY `id` (`id`)
) TYPE=MyISAM;
INSERT INTO `room13` VALUES (1, '', '', 0xd096d0b8d0b2d0bed182d0bdd18bd18520d0bdd0b520d0bad0bed180d0bcd0b8d182d18c21, '', '', 2147483647, '', 0, 0);

CREATE TABLE `room14` (
  `klu4` int(8) NOT NULL default '0',
  `time` varchar(5) NOT NULL default '',
  `who` varchar(40) NOT NULL default '',
  `message` blob NOT NULL,
  `messagewosm` blob NOT NULL,
  `messagewoasm` blob NOT NULL,
  `id` double NOT NULL default '0',
  `towhom` varchar(12) NOT NULL default '',
  `hid` smallint(1) NOT NULL default '0',
  `usid` int(12) NOT NULL default '0',
  PRIMARY KEY  (`klu4`),
  KEY `id` (`id`)
) TYPE=MyISAM;
INSERT INTO `room14` VALUES (1, '', '', 0xd096d0b8d0b2d0bed182d0bdd18bd18520d0bdd0b520d0bad0bed180d0bcd0b8d182d18c21, '', '', 2147483647, '', 0, 0);

CREATE TABLE `room15` (
  `klu4` int(8) NOT NULL default '0',
  `time` varchar(5) NOT NULL default '',
  `who` varchar(40) NOT NULL default '',
  `message` blob NOT NULL,
  `messagewosm` blob NOT NULL,
  `messagewoasm` blob NOT NULL,
  `id` double NOT NULL default '0',
  `towhom` varchar(12) NOT NULL default '',
  `hid` smallint(1) NOT NULL default '0',
  `usid` int(12) NOT NULL default '0',
  PRIMARY KEY  (`klu4`),
  KEY `id` (`id`)
) TYPE=MyISAM;
INSERT INTO `room15` VALUES (1, '', '', 0xd096d0b8d0b2d0bed182d0bdd18bd18520d0bdd0b520d0bad0bed180d0bcd0b8d182d18c21, '', '', 2147483647, '', 0, 0);

CREATE TABLE `room16` (
  `klu4` int(8) NOT NULL default '0',
  `time` varchar(5) NOT NULL default '',
  `who` varchar(40) NOT NULL default '',
  `message` blob NOT NULL,
  `messagewosm` blob NOT NULL,
  `messagewoasm` blob NOT NULL,
  `id` double NOT NULL default '0',
  `towhom` varchar(12) NOT NULL default '',
  `hid` smallint(1) NOT NULL default '0',
  `usid` int(12) NOT NULL default '0',
  PRIMARY KEY  (`klu4`),
  KEY `id` (`id`)
) TYPE=MyISAM;
INSERT INTO `room16` VALUES (1, '', '', 0xd096d0b8d0b2d0bed182d0bdd18bd18520d0bdd0b520d0bad0bed180d0bcd0b8d182d18c21, '', '', 2147483647, '', 0, 0);

CREATE TABLE `room17` (
  `klu4` int(8) NOT NULL default '0',
  `time` varchar(5) NOT NULL default '',
  `who` varchar(40) NOT NULL default '',
  `message` blob NOT NULL,
  `messagewosm` blob NOT NULL,
  `messagewoasm` blob NOT NULL,
  `id` double NOT NULL default '0',
  `towhom` varchar(12) NOT NULL default '',
  `hid` smallint(1) NOT NULL default '0',
  `usid` int(12) NOT NULL default '0',
  PRIMARY KEY  (`klu4`),
  KEY `id` (`id`)
) TYPE=MyISAM;
INSERT INTO `room17` VALUES (1, '', '', 0xd096d0b8d0b2d0bed182d0bdd18bd18520d0bdd0b520d0bad0bed180d0bcd0b8d182d18c21, '', '', 2147483647, '', 0, 0);

CREATE TABLE `room18` (
  `klu4` int(8) NOT NULL default '0',
  `time` varchar(5) NOT NULL default '',
  `who` varchar(40) NOT NULL default '',
  `message` blob NOT NULL,
  `messagewosm` blob NOT NULL,
  `messagewoasm` blob NOT NULL,
  `id` double NOT NULL default '0',
  `towhom` varchar(12) NOT NULL default '',
  `hid` smallint(1) NOT NULL default '0',
  `usid` int(12) NOT NULL default '0',
  PRIMARY KEY  (`klu4`),
  KEY `id` (`id`)
) TYPE=MyISAM;
INSERT INTO `room18` VALUES (1, '', '', 0xd096d0b8d0b2d0bed182d0bdd18bd18520d0bdd0b520d0bad0bed180d0bcd0b8d182d18c21, '', '', 2147483647, '', 0, 0);

CREATE TABLE `room19` (
  `klu4` int(8) NOT NULL default '0',
  `time` varchar(5) NOT NULL default '',
  `who` varchar(40) NOT NULL default '',
  `message` blob NOT NULL,
  `messagewosm` blob NOT NULL,
  `messagewoasm` blob NOT NULL,
  `id` double NOT NULL default '0',
  `towhom` varchar(12) NOT NULL default '',
  `hid` smallint(1) NOT NULL default '0',
  `usid` int(12) NOT NULL default '0',
  PRIMARY KEY  (`klu4`),
  KEY `id` (`id`)
) TYPE=MyISAM;
INSERT INTO `room19` VALUES (1, '', '', 0xd096d0b8d0b2d0bed182d0bdd18bd18520d0bdd0b520d0bad0bed180d0bcd0b8d182d18c21, '', '', 2147483647, '', 0, 0);

CREATE TABLE `room2` (
  `klu4` int(8) NOT NULL default '0',
  `time` varchar(5) NOT NULL default '',
  `who` varchar(40) NOT NULL default '',
  `message` blob NOT NULL,
  `messagewosm` blob NOT NULL,
  `messagewoasm` blob NOT NULL,
  `id` double NOT NULL default '0',
  `towhom` varchar(12) NOT NULL default '',
  `hid` smallint(1) NOT NULL default '0',
  `usid` int(12) NOT NULL default '0',
  PRIMARY KEY  (`klu4`),
  KEY `id` (`id`)
) TYPE=MyISAM;
INSERT INTO `room2` VALUES (1, '', '', 0xd092d0b5d181d0b5d0bbd183d188d0bad0b03a29, '', '', 2147483647, '', 0, 0);

CREATE TABLE `room20` (
  `klu4` int(8) NOT NULL default '0',
  `time` varchar(5) NOT NULL default '',
  `who` varchar(40) NOT NULL default '',
  `message` blob NOT NULL,
  `messagewosm` blob NOT NULL,
  `messagewoasm` blob NOT NULL,
  `id` double NOT NULL default '0',
  `towhom` varchar(12) NOT NULL default '',
  `hid` smallint(1) NOT NULL default '0',
  `usid` int(12) NOT NULL default '0',
  PRIMARY KEY  (`klu4`),
  KEY `id` (`id`)
) TYPE=MyISAM;
INSERT INTO `room20` VALUES (1, '', '', 0xd096d0b8d0b2d0bed182d0bdd18bd18520d0bdd0b520d0bad0bed180d0bcd0b8d182d18c21, '', '', 2147483647, '', 0, 0);

CREATE TABLE `room3` (
  `klu4` int(8) NOT NULL default '0',
  `time` varchar(5) NOT NULL default '',
  `who` varchar(40) NOT NULL default '',
  `message` blob NOT NULL,
  `messagewosm` blob NOT NULL,
  `messagewoasm` blob NOT NULL,
  `id` double NOT NULL default '0',
  `towhom` varchar(12) NOT NULL default '',
  `hid` smallint(1) NOT NULL default '0',
  `usid` int(12) NOT NULL default '0',
  PRIMARY KEY  (`klu4`),
  KEY `id` (`id`)
) TYPE=MyISAM;
INSERT INTO `room3` VALUES (1, '', '', 0x4d6e652062692076206e65626f, '', '', 2147483647, '', 0, 0);

CREATE TABLE `room4` (
  `klu4` int(8) NOT NULL default '0',
  `time` varchar(5) NOT NULL default '',
  `who` varchar(40) NOT NULL default '',
  `message` blob NOT NULL,
  `messagewosm` blob NOT NULL,
  `messagewoasm` blob NOT NULL,
  `id` double NOT NULL default '0',
  `towhom` varchar(12) NOT NULL default '',
  `hid` smallint(1) NOT NULL default '0',
  `usid` int(12) NOT NULL default '0',
  PRIMARY KEY  (`klu4`),
  KEY `id` (`id`)
) TYPE=MyISAM;
INSERT INTO `room4` VALUES (1, '', '', '', '', '', 2147483647, '', 0, 0);

CREATE TABLE `room5` (
  `klu4` int(8) NOT NULL default '0',
  `time` varchar(5) NOT NULL default '',
  `who` varchar(40) NOT NULL default '',
  `message` blob NOT NULL,
  `messagewosm` blob NOT NULL,
  `messagewoasm` blob NOT NULL,
  `id` double NOT NULL default '0',
  `towhom` varchar(12) NOT NULL default '',
  `hid` smallint(1) NOT NULL default '0',
  `usid` int(12) NOT NULL default '0',
  PRIMARY KEY  (`klu4`),
  KEY `id` (`id`)
) TYPE=MyISAM;
INSERT INTO `room5` VALUES (1, '', '', 0xd09bd18ed0b1d0bbd18e20d182d0b5d0b1d18f21, '', '', 2147483647, '', 0, 0);

CREATE TABLE `room6` (
  `klu4` int(8) NOT NULL default '0',
  `time` varchar(5) NOT NULL default '',
  `who` varchar(40) NOT NULL default '',
  `message` blob NOT NULL,
  `messagewosm` blob NOT NULL,
  `messagewoasm` blob NOT NULL,
  `id` double NOT NULL default '0',
  `towhom` varchar(12) NOT NULL default '',
  `hid` smallint(1) NOT NULL default '0',
  `usid` int(12) NOT NULL default '0',
  PRIMARY KEY  (`klu4`),
  KEY `id` (`id`),
  KEY `id_2` (`id`)
) TYPE=MyISAM;
INSERT INTO `room6` VALUES (1, '', '', 0xd0b7d0b0d0bdd18fd182d0be21, '', '', 2147483647, '', 0, 0);

CREATE TABLE `room7` (
  `klu4` int(8) NOT NULL default '0',
  `time` varchar(5) NOT NULL default '',
  `who` varchar(40) NOT NULL default '',
  `message` blob NOT NULL,
  `messagewosm` blob NOT NULL,
  `messagewoasm` blob NOT NULL,
  `id` double NOT NULL default '0',
  `towhom` varchar(12) NOT NULL default '',
  `hid` smallint(1) NOT NULL default '0',
  `usid` int(12) NOT NULL default '0',
  PRIMARY KEY  (`klu4`),
  KEY `id` (`id`)
) TYPE=MyISAM;
INSERT INTO `room7` VALUES (1, '', '', 0xd09fd180d0b8d0b2d0b5d1822cd180d0bed0b4d0bdd183d0bbd18f21, '', '', 2147483647, '', 0, 0);

CREATE TABLE `room8` (
  `klu4` int(8) NOT NULL default '0',
  `time` varchar(5) NOT NULL default '',
  `who` varchar(40) NOT NULL default '',
  `message` blob NOT NULL,
  `messagewosm` blob NOT NULL,
  `messagewoasm` blob NOT NULL,
  `id` double NOT NULL default '0',
  `towhom` varchar(12) NOT NULL default '',
  `hid` smallint(1) NOT NULL default '0',
  `usid` int(12) NOT NULL default '0',
  PRIMARY KEY  (`klu4`),
  KEY `id` (`id`)
) TYPE=MyISAM;
INSERT INTO `room8` VALUES (1, '', '', 0xd096d0b8d0b2d0bed182d0bdd18bd18520d0bad0bed180d0bcd0b8d182d18c21, '', '', 2147483647, '', 0, 0);

CREATE TABLE `room9` (
  `klu4` int(8) NOT NULL default '0',
  `time` varchar(5) NOT NULL default '',
  `who` varchar(40) NOT NULL default '',
  `message` blob NOT NULL,
  `messagewosm` blob NOT NULL,
  `messagewoasm` blob NOT NULL,
  `id` double NOT NULL default '0',
  `towhom` varchar(12) NOT NULL default '',
  `hid` smallint(1) NOT NULL default '0',
  `usid` int(12) NOT NULL default '0',
  PRIMARY KEY  (`klu4`),
  KEY `id` (`id`)
) TYPE=MyISAM;
INSERT INTO `room9` VALUES (1, '', '', '', '', '', 2147483647, '', 0, 0);

CREATE TABLE `rooms` (
  `rm` smallint(5) NOT NULL default '0',
  `name` blob,
  `topic` blob,
  PRIMARY KEY  (`rm`)
) TYPE=MyISAM;
INSERT INTO `rooms` VALUES (0, 0xd092d0b8d0bad182d0bed180d0b8d0bdd0b0, 0x506f207069766b75);
INSERT INTO `rooms` VALUES (1, 0xd092d0bed0b7d0b4d183d188d0bdd18bd0b920d097d0b0d0bcd0bed0ba, '');
INSERT INTO `rooms` VALUES (2, 0xd096d0b5d0bcd187d183d0b6d0bdd0b0d18f20d0a0d0b5d0bad0b0, '');
INSERT INTO `rooms` VALUES (3, 0xd0a1d0b5d0b4d18cd0bcd0bed0b520d09dd0b5d0b1d0be, 0x4e65626f);
INSERT INTO `rooms` VALUES (4, 0xd09bd183d0bdd0bdd0b0d18f20d0a1d0bed0bdd0b0d182d0b0, '');
INSERT INTO `rooms` VALUES (5, 0xd0a5d180d0b0d0bc20d090d0bdd0b3d0b5d0bbd0bed0b2, '');
INSERT INTO `rooms` VALUES (6, 0xd0a0d0b0d0b9d181d0bad0b8d0b920d0a3d0b3d0bed0bbd0bed0ba, '');
INSERT INTO `rooms` VALUES (7, 0xd09bd0b8d180d0b8d187d0b5d181d0bad0b0d18f, '');
INSERT INTO `rooms` VALUES (8, 0xd092d18bd181d188d0b8d0b920d0a1d0bed0b2d0b5d182, '');
INSERT INTO `rooms` VALUES (9, 0xd097d0bed0bed0bfd0b0d180d0ba, '');
INSERT INTO `rooms` VALUES (10, 0xd092d0b8d0b7d0b0d0b2d0b8, 0xd0a2d0b5d1822dd0902dd0a2d0b5d182);
INSERT INTO `rooms` VALUES (11, 0xd09bd0b8d182d0b2d0b0, 0xd09cd0b0d184d0b8d18f);
INSERT INTO `rooms` VALUES (12, 0xd09bd0b0d182d0b2d0b8d18f, '');
INSERT INTO `rooms` VALUES (13, 0xd0a3d0bad180d0b0d0b8d0bdd0b0, '');
INSERT INTO `rooms` VALUES (14, 0xd091d0b5d0bbd0bed180d183d181d181d0b8d18f, '');
INSERT INTO `rooms` VALUES (15, 0xd090d0b7d0b5d180d0b1d0b0d0b9d0b4d0b6d0b0d0bd, '');
INSERT INTO `rooms` VALUES (16, 0xd09ad0b0d0b7d0b0d185d181d182d0b0d0bd, '');
INSERT INTO `rooms` VALUES (17, 0xd093d180d183d0b7d0b8d18f, '');
INSERT INTO `rooms` VALUES (18, 0xd09ad0b0d0b2d0bad0b0d0b7d181d0bad0b0d18f, '');
INSERT INTO `rooms` VALUES (19, 0xd098d0b7d180d0b0d0b8d0bbd18c, '');
INSERT INTO `rooms` VALUES (20, 0xd098d181d0bfd0b0d0bdd0b8d18f, '');
INSERT INTO `rooms` VALUES (21, 0xd098d0b3d180d0b020d09cd0b0d184d0b8d18f, '');

CREATE TABLE `scores1` (
  `gamer_id` int(11) NOT NULL default '0',
  `score` int(11) NOT NULL default '0',
  PRIMARY KEY  (`gamer_id`)
) TYPE=MyISAM;

CREATE TABLE `setting` (
  `klu4` smallint(1) NOT NULL default '0',
  `shut` smallint(1) NOT NULL default '0',
  `vict` smallint(1) NOT NULL default '0',
  `shutint` smallint(4) NOT NULL default '0',
  `victint` smallint(4) NOT NULL default '0',
  `roomon` smallint(2) NOT NULL default '0',
  `roomoff` smallint(2) NOT NULL default '0',
  PRIMARY KEY  (`klu4`)
) TYPE=MyISAM;
INSERT INTO `setting` VALUES (1, 0, 1, 1800, 30, 1, 9);

CREATE TABLE `users` (
  `id` int(11) NOT NULL auto_increment,
  `user` varchar(50) binary NOT NULL default '',
  `pass` varchar(30) binary default NULL,
  `name` varchar(30) binary default NULL,
  `sex` varchar(6) binary default NULL,
  `birth` varchar(10) default NULL,
  `city` varchar(100) default NULL,
  `mail` varchar(200) default NULL,
  `site` varchar(200) NOT NULL default '',
  `icq` varchar(100) default NULL,
  `infa` blob,
  `posts` int(11) NOT NULL default '0',
  `status` varchar(100) binary NOT NULL default 'Дьяволёнок',
  `date` varchar(10) binary default NULL,
  `avr` smallint(3) NOT NULL default '300',
  `max` smallint(2) NOT NULL default '10',
  `op` varchar(100) binary default NULL,
  `mob` varchar(100) binary default NULL,
  `level` smallint(6) NOT NULL default '0',
  `ignor` blob,
  `kik` int(20) NOT NULL default '0',
  `whokik` varchar(20) binary NOT NULL default '',
  `whykik` varchar(200) binary NOT NULL default '',
  `user_ip` varchar(20) binary NOT NULL default '',
  `user_soft` varchar(200) binary NOT NULL default '',
  `inv` tinyint(1) NOT NULL default '0',
  `say` smallint(6) NOT NULL default '0',
  `credits` int(11) NOT NULL default '0',
  `gposts` int(11) NOT NULL default '0',
  `img` varchar(50) binary NOT NULL default '',
  `translit` tinyint(1) NOT NULL default '0',
  `visit` timestamp(14) NOT NULL,
  `friends` blob NOT NULL,
  `ruser` varchar(30) binary NOT NULL default '',
  `latuser` varchar(30) binary NOT NULL default '',
  `onl` int(11) NOT NULL default '0',
  `room` varchar(10) binary NOT NULL default '',
  `smiles` tinyint(1) NOT NULL default '2',
  `safe` tinyint(1) NOT NULL default '1',
  `fsize` varchar(10) NOT NULL default 'small',
  `number` text NOT NULL,
  `kn_say` tinyint(1) NOT NULL default '0',
  `kn_update` tinyint(1) NOT NULL default '0',
  `kn_letters` tinyint(1) NOT NULL default '0',
  `kn_whochat` tinyint(1) NOT NULL default '1',
  `kn_whoroom` tinyint(1) NOT NULL default '0',
  `kn_holl` tinyint(1) NOT NULL default '0',
  `kn_stats` tinyint(1) NOT NULL default '0',
  `kn_topic` tinyint(1) NOT NULL default '0',
  `kn_kommands` tinyint(1) NOT NULL default '1',
  `nastroi` varchar(100) NOT NULL default '0',
  `byeotv` int(11) NOT NULL default '0',
  `alltraf` varchar(255) NOT NULL default '0',
  `lasttraf` varchar(255) NOT NULL default '0',
  `costtraf` int(255) NOT NULL default '0',
  `banned` tinyint(1) NOT NULL default '0',
  `trade` tinyint(1) NOT NULL default '0',
  `kn_nood` tinyint(1) NOT NULL default '1',
  `creditsingame` int(11) NOT NULL default '0',
  `mafcredits` int(11) NOT NULL default '0',
  `anketa` tinyint(1) NOT NULL default '0',
  `avtootvet` blob NOT NULL,
  `emocmenu` tinyint(1) NOT NULL default '0',
  `emoc1` varchar(25) NOT NULL default '',
  `emoc2` varchar(25) NOT NULL default '',
  `emoc3` varchar(25) NOT NULL default '',
  `emoc4` varchar(25) NOT NULL default '',
  `emoc5` varchar(25) NOT NULL default '',
  `emoc6` varchar(25) NOT NULL default '',
  `emoc7` varchar(25) NOT NULL default '',
  `emoc8` varchar(25) NOT NULL default '',
  `emoc9` varchar(25) NOT NULL default '',
  `emoc10` varchar(25) NOT NULL default '',
  `selemoc` varchar(25) NOT NULL default '1',
  `mysmile` varchar(50) NOT NULL default '',
  `bind4` tinyint(1) NOT NULL default '0',
  `bind3` tinyint(1) NOT NULL default '8',
  `bind2` tinyint(1) NOT NULL default '2',
  `bind1` tinyint(1) NOT NULL default '1',
  `kn_sos` tinyint(1) NOT NULL default '1',
  `votefoto` int(11) NOT NULL default '0',
  `kn_cabinet` tinyint(1) NOT NULL default '0',
  `kn_clroom` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`id`),
  KEY `say` (`say`),
  KEY `say_2` (`say`)
) TYPE=MyISAM PACK_KEYS=0 AUTO_INCREMENT=11 ;
INSERT INTO `users` VALUES (1, 0x5bd0a1d0b8d181d182d0b5d0bcd0b05d, 0x363636, 0x31, 0xd09c, '11-11-1111', '11', '', '', '', 0x313131, 52, 0xd09fd0bed0bbd18cd0b7d0bed0b2d0b0d182d0b5d0bbd18c, 0x31312d31312d31313131, 0, 10, '', '', 0, '', 0, '', '', 0x38332e3134332e36352e313839, 0x4d6f7a696c6c612f342e302028636f6d70617469626c653b204d53494520362e303b2057696e646f7773204e5420352e313b20727529204f7065726120382e3531, 0, 0, 0, 0, '', 0, '20060729225021', '', 0x61646d696e697374726171697d, '', 1154198776, 0x30, 2, 0, 'small', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, '0', 0, '9.4', '1.7', 0, 0, 0, 0, 0, 0, 0, '', 0, '', '', '', '', '', '', '', '', '', '', '1', '', 0, 8, 2, 1, 0, 0, 0, 1);
INSERT INTO `users` VALUES (2, 0xd091d0bed0a2d0b0d09dd0b8d0ba, 0x363636, 0xd09dd0b5d0b7d0bdd0b0d0b9d0bad0b0, 0xd09c, '00-00-0000', 'Умноград', 'neznaika@znanii.net', 'http://uma.net', '', 0xd09cd0b0d0bbd0b5d0bdd18cd0bad0b8d0b920d185d183d0b4d0b5d0bdd18cd0bad0b8d0b920d0bed187d0bad0b0d180d0b8d0ba, 59902, 0xd09ed187d0bad0b0d180d0b8d0ba, '', 0, 10, 0xd0a3d0bcd0bdd18bd0b9, 0xd0a5d0bed180d0bed188d0b0d18f, 3, '', 1150889261, 0x6d69636861656c, 0xd0a7d182d0be20d0b1d18b20d0b220d0bfd180d0b8d0b2d0b0d18220d0bdd0b520d0bfd0b8d181d0b0d0bb2120d093d0b32e2e, 0x38332e3134332e36352e313839, 0x4d6f7a696c6c612f342e302028636f6d70617469626c653b204d53494520362e303b2057696e646f7773204e5420352e313b20727529204f7065726120382e3531, 0, 1, 0, 0, '', 0, '20060803095311', '', 0x626f74616e696b, '', 1154584391, 0x30, 0, 0, 'small', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, '0', 0, '115.4', '4.8', 0, 0, 0, 0, 0, 0, 0, '', 0, '', '', '', '', '', '', '', '', '', '', '1', '', 0, 8, 2, 1, 0, 0, 0, 1);
INSERT INTO `users` VALUES (3, 0x2dd0a1d0bcd0b5d188d0b8d0bdd0bad0b02d, 0x363636, 0xd0a1d0bcd0b5d188d0b8d0bdd0bad0b0, 0xd096, '00-00-0000', 'Хахатунград', 'smewinka@ymor.ru', 'http://smewinka.grusti.net', '', 0xd0a1d0bcd0b5d0b5d182d181d18f20d182d0bed18220d0bad182d0be20d181d0bcd0b5d0b5d182d181d18f20d0bfd0bed181d0bbd0b5d0b4d0bdd0b8d0bc21, 13, 0x55736572, 0x32322d30312d32303036, 0, 10, 0xd0a1d0bcd0b5d188d0bdd0bed0b9, 0xd0a5d0b0d185d0b0d182d183d188d0bad0b0, 0, '', 0, '', '', 0x38332e3134332e36352e313839, 0x4d6f7a696c6c612f342e302028636f6d70617469626c653b204d53494520362e303b2057696e646f7773204e5420352e313b20727529204f7065726120382e3531, 0, 1, 0, 0, '', 0, '20060729224441', '', 0x2d736d6577696e6b612d, '', 1154198681, 0x30, 0, 0, 'small', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, '0', 0, '72', '4.8', 0, 0, 0, 0, 0, 0, 0, '', 0, '', '', '', '', '', '', '', '', '', '', '1', '', 0, 8, 2, 1, 0, 0, 0, 1);
INSERT INTO `users` VALUES (4, 0xd0a1d0bfd0b5d0bad183d0bbd18fd0bdd182, 0x363636, 0x313131, 0xd09c, '11-11-1960', '1111111', '', '', '', 0x313131313131, 4, 0xd09fd0bed0bbd18cd0b7d0bed0b2d0b0d182d0b5d0bbd18c, 0x31332d30352d32303036, 150, 10, '', '', 0, '', 1151148286, 0x7e2a616e67656c2a7e, 0xd097d0b020d182d0b0d0ba, 0x38332e3134332e36352e313839, 0x4d6f7a696c6c612f342e302028636f6d70617469626c653b204d53494520362e303b2057696e646f7773204e5420352e313b20727529204f7065726120382e3531, 0, 0, 0, 0, '', 0, '20060729225036', '', 0x7370656b756c7d6e74, '', 1154198564, 0x30, 2, 1, 'small', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, '0', 0, '348.4', '1.7', 0, 0, 0, 0, 0, 0, 0, '', 0, '', '', '', '', '', '', '', '', '', '', '1', '', 0, 8, 2, 1, 0, 0, 0, 1);
INSERT INTO `users` VALUES (5, 0xd09cd0b0d184d0b8d0bed0b7d0b8, 0x363636, 0xd09ad180d191d181d182d0bdd18bd0b920d0bed182d0b5d186, 0xd09c, '11-11-1938', 'Оренбург', 'seaquest@mail.ru', 'http://wap.region-56.ru', '', 0x2d, 365, 0xd09fd0bed0bbd18cd0b7d0bed0b2d0b0d182d0b5d0bbd18c, 0x31342d30352d32303036, 150, 10, 0xd09cd0b5d0b3d0b0d184d0bed0bd, '', 0, '', 0, '', '', 0x38352e3139322e3133322e313335, 0x4d6f7a696c6c612f342e302028636f6d70617469626c653b204d53494520362e303b2057696e646f7773204e5420352e313b20727529204f7065726120382e3534, 0, 0, 0, 0, '', 0, '20060729224441', '', 0x6d6166696f7a69, '', 0, '', 2, 1, 'medium', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, '0', 0, '2.5', '2.5', 0, 0, 0, 0, 0, 0, 0, '', 0, '', '', '', '', '', '', '', '', '', '', '1', '', 0, 8, 2, 1, 0, 0, 0, 1);

CREATE TABLE `vopros` (
  `klu4` tinyint(1) NOT NULL default '0',
  `number` int(11) NOT NULL default '0',
  `time` int(11) NOT NULL default '0',
  `question` blob NOT NULL,
  `answer` varchar(100) binary NOT NULL default '',
  `tran` varchar(100) binary NOT NULL default '',
  PRIMARY KEY  (`klu4`)
) TYPE=MyISAM;
INSERT INTO `vopros` VALUES (1, 0, 1153473674, 0xd09ed182d180d0b0d0b2d0bbd0b5d0bdd0b8d0b520d0bed180d0b3d0b0d0bdd0b8d0b7d0bcd0b020d18fd0b4d0bed0b2d0b8d182d18bd0bcd0b820d0b2d0b5d189d0b5d181d182d0b2d0b0d0bcd0b82c20d0b2d18bd180d0b0d0b1d0b0d182d18bd0b2d0b0d18ed189d0b8d0bcd0b8d181d18f20d0b220d0bdd0b5d0bc20d181d0b0d0bcd0bed0bc2e2028313420d0b1d183d0bad0b229, 0xd181d0b0d0bcd0bed0bed182d180d0b0d0b2d0bbd0b5d0bdd0b8d0b5, 0x73616d6f6f747261766c656e6965);

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,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=13 ;

CREATE TABLE `zapiski` (
  `klu4` int(8) NOT NULL default '0',
  `who` varchar(40) binary NOT NULL default '',
  `idwho` int(12) NOT NULL default '0',
  `message` blob NOT NULL,
  `towhom` varchar(40) binary NOT NULL default '',
  `idtowhom` int(12) NOT NULL default '0',
  `time` int(11) NOT NULL default '0',
  `readd` tinyint(1) NOT NULL default '0',
  `topic` varchar(80) binary NOT NULL default '',
  `date` varchar(50) binary NOT NULL default '',
  `insend` tinyint(1) NOT NULL default '1',
  `ininc` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`klu4`)
) TYPE=MyISAM;