View file MySQL_utf8.sql

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

INSERT INTO `bomj` (`klu4`, `night_act`) VALUES
(1, 'Городской бомж, оставив помойку, wарит своими грязными руками по карманам прохожих...'),
(2, 'Вонючий бомж wныряет по переулкам, и между очередной мусоркой копается в чьих-то карманах...'),
(3, 'Бомж, распространяя по городу чудесный аромат своих подмыwек, умудряется еще проверять карманы горожан...');

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

INSERT INTO `doktor` (`klu4`, `night_act`) VALUES
(1, 'Доктор, захватив с собой wприц побольwе, рыщет по городу, кому же и куда его вставить...'),
(2, 'Доктор, наглотавwись дури, реwил залечить что-нибудь у кого-нибудь этой ночью...'),
(3, 'Наw бравый городской врач выwел на охоту за пациентами. У него так и чеwутся руки кого-нибудь вылечить...');

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

INSERT INTO `komissar` (`klu4`, `night_act`) VALUES
(1, 'Комиссар Катани, сев в свой бобик, поехал искать преступников...'),
(2, 'Комиссар Катани, наглотавwись колес, ходит по комнате и вычисляет мафию...'),
(3, 'Комиссар Катани лежит в засаде в куче навоза и следит за мафией... Фуу-у, ну и запаwок:)');


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

INSERT INTO `mafia` (`klu4`, `night_act`) VALUES
(1, 'Мафиози, вооруживwись до зубов, направляются навстречу своей жертве...'),
(2, 'Главарь мафии высматривает свою жертву. За ним, лизоблюдя, следуют его wестерки...'),
(3, 'Мафия на четырех маwинах носится по ночному городу и пугает редких прохожих...');

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

INSERT INTO `maniac` (`klu4`, `night_act`) VALUES
(1, 'Маньяк носится с топором в руках по темным переулкам...'),
(2, 'Маньяк с гадкой ухмылкой на лице точит свой топор...'),
(3, 'Маньяк сидит в засаде с оружием наготове и поджидает случайных прохожих...');

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

INSERT INTO `wluha` (`klu4`, `night_act`) VALUES
(1, 'Wлюха выwла из дома, кому-то сегодня не удастся поспать...'),
(2, 'Девка, виляя бедрами, ходит ночью по городу, не пропуская ни одного мужчины.'),
(3, 'Городская wлюwка в откровенном виде wастает по улицам, выбирая жертву...');

CREATE TABLE `anekdot` (
  `klu4` int(11) NOT NULL auto_increment,
  `message` blob NOT NULL,
  `who` int(11) NOT NULL default '0',
  PRIMARY KEY  (`klu4`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

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=1 ;

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

CREATE TABLE `bot_dialog` (
  `id` int(11) NOT NULL auto_increment,
  `message` blob NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=255 ;



CREATE TABLE `frazi` (
  `klu4` int(11) NOT NULL auto_increment,
  `message` blob NOT NULL,
  PRIMARY KEY  (`klu4`)
) TYPE=MyISAM AUTO_INCREMENT=42 ;

CREATE TABLE `friends` (
  `klu4` int(11) NOT NULL auto_increment,
  `id` int(11) NOT NULL default '0',
  `usid` int(11) NOT NULL default '0',
  PRIMARY KEY  (`klu4`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

CREATE TABLE `golos` (
  `id` int(11) NOT NULL auto_increment,
  `user` int(11) NOT NULL default '0',
  `who` int(11) NOT NULL default '0',
  `ip` varchar(20) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM 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` (`rm`, `who`, `var`) VALUES (0, 1474, 0),
(1, 180, 0),
(2, 15, 0),
(3, 1309, 0),
(4, 0, 0),
(5, 0, 0),
(6, 45, 0),
(7, 100, 0),
(8, 222, 0),
(9, 486, 0),
(10, 0, 0),
(11, 100, 0),
(12, 59, 0),
(13, 0, 0),
(14, 0, 0),
(15, 0, 0),
(16, 0, 0),
(17, 0, 0),
(18, 0, 0),
(19, 0, 0),
(20, 100, 0),
(21, 0, 0),
(22, 100, 0);

CREATE TABLE `ignor` (
  `klu4` int(11) NOT NULL auto_increment,
  `id` int(11) NOT NULL default '0',
  `usid` int(11) NOT NULL default '0',
  PRIMARY KEY  (`klu4`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;



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` (`klu4`, `go`, `anekdot`) VALUES (1, 1174437926, 1098370704);

CREATE TABLE `room0` (
  `klu4` int(8) NOT NULL default '0',
  `time` varchar(8) 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',
  `komu` varchar(40) NOT NULL default '',
  PRIMARY KEY  (`klu4`),
  KEY `id` (`id`)
) TYPE=MyISAM;


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',
  `komu` varchar(40) NOT NULL default '',
  PRIMARY KEY  (`klu4`),
  KEY `id` (`id`)
) TYPE=MyISAM;



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 '',
  `komu` varchar(40) NOT NULL default '',
  PRIMARY KEY  (`klu4`),
  KEY `id` (`id`)
) TYPE=MyISAM;


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',
  `komu` varchar(40) NOT NULL default '',
  PRIMARY KEY  (`klu4`),
  KEY `id` (`id`)
) TYPE=MyISAM;


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',
  `komu` varchar(40) NOT NULL default '',
  PRIMARY KEY  (`klu4`),
  KEY `id` (`id`)
) TYPE=MyISAM;


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',
  `komu` varchar(40) NOT NULL default '',
  PRIMARY KEY  (`klu4`),
  KEY `id` (`id`)
) TYPE=MyISAM;

CREATE TABLE `room23` (
  `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',
  `komu` varchar(40) NOT NULL default '',
  PRIMARY KEY  (`klu4`),
  KEY `id` (`id`)
) TYPE=MyISAM;


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',
  `komu` varchar(40) NOT NULL default '',
  PRIMARY KEY  (`klu4`),
  KEY `id` (`id`)
) TYPE=MyISAM;


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',
  `komu` varchar(40) NOT NULL default '',
  PRIMARY KEY  (`klu4`),
  KEY `id` (`id`)
) TYPE=MyISAM;


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',
  `komu` varchar(40) NOT NULL default '',
  PRIMARY KEY  (`klu4`),
  KEY `id` (`id`)
) TYPE=MyISAM;


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',
  `komu` varchar(40) NOT NULL default '',
  PRIMARY KEY  (`klu4`),
  KEY `id` (`id`)
) TYPE=MyISAM;


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',
  `komu` varchar(40) NOT NULL default '',
  PRIMARY KEY  (`klu4`),
  KEY `id` (`id`)
) TYPE=MyISAM;


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',
  `komu` varchar(40) NOT NULL default '',
  PRIMARY KEY  (`klu4`),
  KEY `id` (`id`)
) TYPE=MyISAM;


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',
  `komu` varchar(40) NOT NULL default '',
  PRIMARY KEY  (`klu4`),
  KEY `id` (`id`)
) TYPE=MyISAM;


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',
  `komu` varchar(40) NOT NULL default '',
  PRIMARY KEY  (`klu4`),
  KEY `id` (`id`)
) TYPE=MyISAM;


CREATE TABLE `room21` (
  `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',
  `komu` varchar(40) NOT NULL default '',
  PRIMARY KEY  (`klu4`),
  KEY `id` (`id`)
) TYPE=MyISAM;


CREATE TABLE `room22` (
  `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',
  `komu` varchar(40) NOT NULL default '',
  PRIMARY KEY  (`klu4`),
  KEY `id` (`id`)
) TYPE=MyISAM;





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',
  `komu` varchar(40) NOT NULL default '',
  PRIMARY KEY  (`klu4`),
  KEY `id` (`id`)
) TYPE=MyISAM;


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',
  `komu` varchar(40) NOT NULL default '',
  PRIMARY KEY  (`klu4`),
  KEY `id` (`id`)
) TYPE=MyISAM;


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',
  `komu` varchar(40) NOT NULL default '',
  PRIMARY KEY  (`klu4`),
  KEY `id` (`id`)
) TYPE=MyISAM;


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',
  `komu` varchar(40) NOT NULL default '',
  PRIMARY KEY  (`klu4`),
  KEY `id` (`id`),
  KEY `id_2` (`id`)
) TYPE=MyISAM;


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',
  `komu` varchar(40) NOT NULL default '',
  PRIMARY KEY  (`klu4`),
  KEY `id` (`id`)
) TYPE=MyISAM;


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',
  `komu` varchar(40) NOT NULL default '',
  PRIMARY KEY  (`klu4`),
  KEY `id` (`id`)
) TYPE=MyISAM;


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',
  `komu` varchar(40) NOT NULL default '',
  PRIMARY KEY  (`klu4`),
  KEY `id` (`id`)
) TYPE=MyISAM;


CREATE TABLE `room24` (
  `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',
  `komu` varchar(40) NOT NULL default '',
  PRIMARY KEY  (`klu4`),
  KEY `id` (`id`)
) TYPE=MyISAM;


CREATE TABLE `room25` (
  `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',
  `komu` varchar(40) NOT NULL default '',
  PRIMARY KEY  (`klu4`),
  KEY `id` (`id`)
) TYPE=MyISAM;


CREATE TABLE `room26` (
  `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',
  `komu` varchar(40) NOT NULL default '',
  PRIMARY KEY  (`klu4`),
  KEY `id` (`id`)
) TYPE=MyISAM;


CREATE TABLE `room27` (
  `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',
  `komu` varchar(40) NOT NULL default '',
  PRIMARY KEY  (`klu4`),
  KEY `id` (`id`)
) TYPE=MyISAM;


CREATE TABLE `room28` (
  `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',
  `komu` varchar(40) NOT NULL default '',
  PRIMARY KEY  (`klu4`),
  KEY `id` (`id`)
) TYPE=MyISAM;


CREATE TABLE `room29` (
  `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',
  `komu` varchar(40) NOT NULL default '',
  PRIMARY KEY  (`klu4`),
  KEY `id` (`id`)
) TYPE=MyISAM;


CREATE TABLE `room30` (
  `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',
  `komu` varchar(40) NOT NULL default '',
  PRIMARY KEY  (`klu4`),
  KEY `id` (`id`)
) TYPE=MyISAM;

CREATE TABLE `rooms` (
  `rm` smallint(5) NOT NULL auto_increment,
  `name` blob,
  `topic` blob,
  `pos` tinyint(2) NOT NULL default '0',
  PRIMARY KEY  (`rm`)
) TYPE=MyISAM PACK_KEYS=0 AUTO_INCREMENT=25 ;
INSERT INTO `rooms` (`rm`, `name`, `topic`, `pos`) VALUES
(0, 0xd092d0b8d0bad182d0bed180d0b8d0bdd0b0, 0xd0a120d094d0bdd191d0bc20d0a0d0bed0b6d0b4d0b5d0bdd0b8d18f2cd0a1d0b0d0bdd18ed1883a292929, 0),
(1, 0xd09720d09020d09320d0a1, 0xd09720d09020d09320d0a1, 9),
(2, 0xd097d0bdd0b0d0bad0bed0bcd181d182d0b2d0b0, 0xd0a1d0bbd0b0d0b4d0bad0b0d18f20d0bfd0b0d180d0bed187d0bad0b020d0b3d0b3, 2),
(3, 0xd093d0bed181d182d0b8d0bdd0bdd0b0d18f, 0xd09cd0bdd0b520d0b1d18b20d0b220d0bdd0b5d0b1d0be21, 2),
(4, 0xd094d0b8d181d0bad0bed0b1d0b0d180, '', 3),
(5, 0xd09ad0b0d184d0b5d188d0bad0b0, 0xd09fd0b8d182d0b5d1805f464d5fd0b7d0b0d0b6d0b8d0b3d0b0d0b5d182, 4),
(6, 0xd0a1d0bfd0bed180d182d0bbd0b0d0bdd0b4d0b8d18f, 0x2e, 7),
(7, 0xd091d0b5d0b7d0b4d0b5d0bbd18cd0bdd0b8d0bad0b8, 0x2e, 6),
(8, 0xd092d18bd181d188d0b8d0b920d0a1d0bed0b2d0b5d182, 0xd0a1d0b0d0bcd0bcd0b8d182, 12),
(9, 0xd097d0bed0bed0bfd0b0d180d0ba, 0xd091d0b5d0b720d181d182d0b8d181d0bdd0b5d0bdd0b8d18f203a29, 13),
(10, 0xd098d0bdd182d0b8d0bc, 0xd0a2d0b5d1822dd0902dd0a2d0b5d182, 10),
(11, 0xd09ad0bbd0b0d0b7d0bdd0b5d18220d0b7d0bdd0b0d182d0bed0bad0bed0b2, 0xd182d183d0bfd0b8d0ba20d0b3d0bed0bdd0b820d0b3d183d181d0b5d0b9, 9),
(12, 0xd0a2d180d0b0d185d182d0b5d0bdd0b1d0b5d180d0b32043697479, '', 11),
(13, 0xd09bd0b8d182d0b2d0b0, 0xd09bd18ed0b1d0b8d0bcd0b0d18f20d0bcd0bed18f20d0a0d095d094d098d0a1d09ed0a7d09ad090212121, 13),
(14, 0xd09bd0b0d182d0b2d0b8d18f, '', 14),
(15, 0xd0a3d0bad180d0b0d0b8d0bdd0b0, '', 15),
(16, 0xd091d0b5d0bbd0bed180d183d181d181d0b8d18f, '', 16),
(17, 0xd090d0b7d0b5d180d0b1d0b0d0b9d0b4d0b6d0b0d0bd, '', 17),
(18, 0xd09ad0b0d0b7d0b0d185d181d182d0b0d0bd, '', 18),
(19, 0xd093d180d183d0b7d0b8d18f, '', 19),
(20, 0xd09ad0b0d0b2d0bad0b0d0b7d181d0bad0b0d18f, '', 20),
(21, 0xd098d0b7d180d0b0d0b8d0bbd18c, '', 21),
(22, 0xd098d181d0bfd0b0d0bdd0b8d18f, '', 22),
(23, 0xd098d0b3d180d0b020d09cd0b0d184d0b8d18f, 0xd09cd0b0d184d0b8d0bed0b7d0b8, 24),
(24, 0xd098d181d0bfd0b0d0bdd0b8d18f, '', 24),
(31, 0xd098d181d0bfd0b0d0bdd0b8d18f, '', 25),
(26, 0xd098d181d0bfd0b0d0bdd0b8d18f, '', 26),
(27, 0xd098d181d0bfd0b0d0bdd0b8d18f, '', 27),
(28, 0xd098d181d0bfd0b0d0bdd0b8d18f, '', 28),
(29, 0xd098d181d0bfd0b0d0bdd0b8d18f, '', 29),
(30, 0xd098d181d0bfd0b0d0bdd0b8d18f, '', 30);



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',
  `prod` smallint(1) NOT NULL default '0',
  `link1` varchar(200) NOT NULL default '',
  `link2` varchar(200) NOT NULL default '',
  `link3` varchar(200) NOT NULL default '',
  `link1_name` varchar(50) binary NOT NULL default '',
  `link2_name` varchar(50) binary NOT NULL default '',
  `link3_name` varchar(50) binary NOT NULL default '',
  `rus` smallint(1) NOT NULL default '0',
  `reg` smallint(1) NOT NULL default '1',
  `podarreg` varchar(50) NOT NULL default '10000',
  PRIMARY KEY  (`klu4`)
) TYPE=MyISAM;
INSERT INTO `setting` (`klu4`, `shut`, `vict`, `shutint`, `victint`, `roomon`, `roomoff`, `prod`, `link1`, `link2`, `link3`, `link1_name`, `link2_name`, `link3_name`, `rus`, `reg`, `podarreg`) VALUES (1, 1, 1, 1800, 30, 2, 9, 0, 'v4ate.us', '', '', 0xd093d0bbd0b0d0b2d0bdd0b0d18f, '', '', 0, 1, 10000);

CREATE TABLE `shutki` (
  `klu4` int(11) NOT NULL auto_increment,
  `message` blob NOT NULL,
  PRIMARY KEY  (`klu4`)
) TYPE=MyISAM AUTO_INCREMENT=563 ;

CREATE TABLE `svadbi` (
  `id` int(11) NOT NULL auto_increment,
  `zhenih` text NOT NULL,
  `nevesta` text NOT NULL,
  `frzhenih` text NOT NULL,
  `frnevesta` text NOT NULL,
  `date` varchar(10) character set utf8 collate utf8_bin default NULL,
  `time` varchar(5) default '0',
  `organizatory` text,
  `done` binary(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=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` (`klu4`, `number`, `time`, `question`, `answer`, `tran`) VALUES (1, 5, 1174384141, 0xd094d180d0b5d0b2d0bdd0b5d0b3d180d0b5d187d0b5d181d0bad0b0d18f20d182d0b5d180d180d0b8d182d0bed180d0b8d18f20d0bdd0b020d0bcd0b0d0bbd0bed0b0d0b7d0b8d0b9d181d0bad0bed0bc20d0bfd0bed0b1d0b5d180d0b5d0b6d18cd0b520d0add0b3d0b5d0b9d181d0bad0bed0b3d0be20d0bcd0bed180d18f2e20283c623e3520d0b1d183d0bad0b23c2f623e29, '', ''),
(2, 0, 1174346903, 0x3c623ed092d0bed0bfd180d0bed1813a3c2f623e20d093d0bed180d0b1d0b0d182d18bd0b920d187d0b5d0bbd0bed0b2d0b5d0ba2e2028d0b1d183d0bad0b220d0bcd0b0d0bbd0be2e20d098d0bbd0b820d0bcd0bdd0bed0b3d0be2e20d09ad0bed180d0bed187d0b520d0bfd0bed185d183d0b92e29, 0xd0b3d0bed180d0b1d183d0bd, 0x676f7262756e);

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=1 ;

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;


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',
  `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,
  `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 'medium',
  `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',
  `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',
  `kn_cabinet` tinyint(1) NOT NULL default '0',
  `kn_clroom` tinyint(1) NOT NULL default '1',
  `votefoto` int(11) NOT NULL default '0',
  `para` varchar(50) NOT NULL default '',
  `kn_privat` tinyint(1) NOT NULL default '0',
  `myavatar` varchar(50) NOT NULL default '',
  `version` smallint(1) NOT NULL default '2',
  `anketa` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM PACK_KEYS=0 AUTO_INCREMENT=11 ;
INSERT INTO `users` VALUES (1, 0x2dd0a1d0b8d181d182d0b5d0bcd0bdd0bed0b52d, 0x53657256696345, 0x31, 0xd096, '19-01-1977', 'Оренбург', '', '', '', 0x2d2d, 66, 0xd09fd0bed0bbd18cd0b7d0bed0b2d0b0d182d0b5d0bbd18c, 0x31312d31312d31313131, 0, 10, '', '', 0, 1173538012, 0xd09ed184d0b5d0bbd18cd0bad0b0, '', 0x38352e3139322e3133382e3534, 0x4d6f7a696c6c612f342e302028636f6d70617469626c653b204d53494520362e303b2057696e646f7773204e5420352e313b20727529204f7065726120382e3534, 0, 0, 1, 0, '', 0, '2007-03-10 12:46:52', 0x2d73697374656d6e6f652d, '', 1160996209, 0x30, 2, 0, 'small', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, '0', 0, '85.3', '4.5', 0, 0, 0, 0, 0, 0, '', 0, '', '', '', '', '', '', '', '', '', '', '1', '', 0, 8, 2, 1, 0, 0, 1, 0, '', 0, '', 0, 1);
INSERT INTO `users` VALUES (2, 0x2dd09dd0b5d097d0bdd0b0d0b9d0bad0b02d, 0x53657256696345, 0xd09dd0b5d0b7d0bdd0b0d0b9d0bad0b0, 0xd09c, '00-00-0000', 'РЈРС?ноград', 'neznaika@znanii.net', 'http://uma.net', '', 0xd09cd0b0d0bbd0b5d0bdd18cd0bad0b8d0b920d185d183d0b4d0b5d0bdd18cd0bad0b8d0b920d0bed187d0bad0b0d180d0b8d0ba, 290607, 0xd09ed187d0bad0b0d180d0b8d0ba, '', 0, 10, 0xd0a3d0bcd0bdd18bd0b9, 0xd0a5d0bed180d0bed188d0b0d18f, 3, 0, '', '', 0x3139352e3138392e3134322e323238, 0x4f706572612f382e303120284a324d452f4d4944503b204f70657261204d696e692f312e322e333231342f313532383b2072753b20553b2073737229, 0, 1, 0, 0, '', 0, '2007-03-20 13:30:20', 0x2d6e657a6e61796b612d, '', 1174386619, 0x30, 0, 0, 'small', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, '0', 0, '178.5', '3.1', 0, 0, 0, 0, 0, 0, '', 0, '', '', '', '', '', '', '', '', '', '', '1', '', 0, 8, 2, 1, 0, 0, 1, 0, '', 0, '', 0, 1);
INSERT INTO `users` VALUES (3, 0x2dd0a4d0bed0bcd0b5d0bdd0bad0be2d, 0x53657256696345, 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, '2006-12-13 12:29:08', 0x2d666f6d656e6b6f2d, '', 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, '', '', '', '', '', '', '', '', '', '', '1', '', 0, 8, 2, 1, 0, 0, 1, 0, '', 0, '', 0, 1);
INSERT INTO `users` VALUES (4, 0x2dd0a1d0bfd0b5d0bad183d0bbd18fd0bdd1822d, 0x53657256696345, 0x313131, 0xd09c, '11-11-1960', '1111111', '', '', '', 0x313131313131, 8, 0xd09fd0bed0bbd18cd0b7d0bed0b2d0b0d182d0b5d0bbd18c, 0x31332d30352d32303036, 150, 10, '', '', 0, 0, '', '', 0x38352e3139352e3132332e3232, 0x687474703a2f2f416e6f6e796d6f7573652e6f72672f2028556e697829, 0, 0, 0, 0, '', 0, '2007-02-08 07:38:38', 0x2d7370656b756c7d6e742d, '', 1165964639, 0x686f6c6c, 2, 1, 'small', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, '0', 0, '86.3', '3', 0, 0, 0, 0, 0, 0, '', 0, '', '', '', '', '', '', '', '', '', '', '1', '', 0, 8, 2, 1, 0, 0, 1, 0, '', 0, '', 0, 1);
INSERT INTO `users` VALUES (5, 0x2dd09cd0b0d184d0b8d0bed0b7d0b82d, 0x53657256696345, 0xd09ad180d191d181d182d0bdd18bd0b920d0bed182d0b5d186, 0xd09c, '11-11-1938', 'Оренбург', 'seaquest@mail.ru', 'http://wap.region-56.ru', '', 0x2d, 2725, 0xd09fd0bed0bbd18cd0b7d0bed0b2d0b0d182d0b5d0bbd18c, 0x31342d30352d32303036, 150, 10, 0xd09cd0b5d0b3d0b0d184d0bed0bd, '', 0, 0, '', '', 0x38352e3139322e3133322e313335, 0x4d6f7a696c6c612f342e302028636f6d70617469626c653b204d53494520362e303b2057696e646f7773204e5420352e313b20727529204f7065726120382e3534, 0, 0, 0, 0, '', 0, '2007-02-26 07:10:30', 0x2d6d6166696f7a692d, '', 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, '', '', '', '', '', '', '', '', '', '', '1', '', 0, 8, 2, 1, 0, 0, 1, 0, '', 0, '', 0, 1);
INSERT INTO `users` VALUES (6, 0x2dd0a2d180d0b0d185d182d0b5d0bdd0b1d0b5d180d0b32d, 0x53657256696345, 0xd0a2d180d0b0d185d182d0b5d0bdd0b1d0b5d180d0b3, 0xd09c, '11-11-1959', 'Оренбург', '', '', '', 0xd0a1d0bcd0b5d188d0bdd0bed0b920d187d0b5d0bb2e, 0, 0xd094d18cd18fd0b2d0bed0bbd191d0bdd0bed0ba, 0x30372d30382d32303036, 300, 10, '', 0x4d6f7a696c6c61, 0, 0, '', '', 0x38352e3139322e3133382e3534, 0x4d6f7a696c6c612f342e302028636f6d70617469626c653b204d53494520362e303b2057696e646f7773204e5420352e313b20727529204f7065726120382e3532, 0, 0, 0, 0, '', 0, '2006-12-13 12:29:50', 0x2d7472616874656e626572672d, '', 1154923090, 0x686f6c6c, 2, 1, 'small', '7', 0, 0, 0, 1, 0, 0, 0, 0, 1, '0', 0, '3.2', '3.2', 0, 0, 0, 1, 0, 0, '', 0, '', '', '', '', '', '', '', '', '', '', '1', '', 0, 8, 2, 1, 1, 0, 1, 0, '', 0, '', 0, 1);
INSERT INTO `users` VALUES (7, 0x2dd0a0d0bed0b1d0bed0bad0bed0bf2d, 0x53657256696345, 0xd0a2d180d0b0d185d182d0b5d0bdd0b1d0b5d180d0b3, 0xd09c, '11-11-1959', 'Оренбург', '', '', '', 0xd0a1d0bcd0b5d188d0bdd0bed0b920d187d0b5d0bb2e, 0, 0xd094d18cd18fd0b2d0bed0bbd191d0bdd0bed0ba, 0x30372d30382d32303036, 300, 10, '', 0x4d6f7a696c6c61, 0, 0, '', '', 0x38352e3139322e3133382e3534, 0x4d6f7a696c6c612f342e302028636f6d70617469626c653b204d53494520362e303b2057696e646f7773204e5420352e313b20727529204f7065726120382e3532, 0, 0, 0, 0, '', 0, '2007-03-20 15:55:27', 0x2d7472616874656e626572672d, '', 1154923090, 0x686f6c6c, 2, 1, 'small', '7', 0, 0, 0, 1, 0, 0, 0, 0, 1, '0', 0, '3.2', '3.2', 0, 0, 0, 1, 0, 0, '', 0, '', '', '', '', '', '', '', '', '', '', '1', '', 0, 8, 2, 1, 1, 0, 1, 0, '', 0, '', 0, 1);
INSERT INTO `users` VALUES (8, 0x2dd0a2d183d0bfd0b8d186d0b02d, 0x53657256696345, 0xd0a2d180d0b0d185d182d0b5d0bdd0b1d0b5d180d0b3, 0xd09c, '11-11-1959', 'Оренбург', '', '', '', 0xd0a1d0bcd0b5d188d0bdd0bed0b920d187d0b5d0bb2e, 0, 0xd094d18cd18fd0b2d0bed0bbd191d0bdd0bed0ba, 0x30372d30382d32303036, 300, 10, '', 0x4d6f7a696c6c61, 0, 0, '', '', 0x38352e3139322e3133382e3534, 0x4d6f7a696c6c612f342e302028636f6d70617469626c653b204d53494520362e303b2057696e646f7773204e5420352e313b20727529204f7065726120382e3532, 0, 0, 0, 0, '', 0, '2007-03-20 15:55:27', 0x2d7472616874656e626572672d, '', 1154923090, 0x686f6c6c, 2, 1, 'small', '7', 0, 0, 0, 1, 0, 0, 0, 0, 1, '0', 0, '3.2', '3.2', 0, 0, 0, 1, 0, 0, '', 0, '', '', '', '', '', '', '', '', '', '', '1', '', 0, 8, 2, 1, 1, 0, 1, 0, '', 0, '', 0, 1);
INSERT INTO `users` VALUES (9, 0x2dd0a0d0bed0b1d0bed0bad0bed0bf2d, 0x53657256696345, 0xd0a2d180d0b0d185d182d0b5d0bdd0b1d0b5d180d0b3, 0xd09c, '11-11-1959', 'Оренбург', '', '', '', 0xd0a1d0bcd0b5d188d0bdd0bed0b920d187d0b5d0bb2e, 0, 0xd094d18cd18fd0b2d0bed0bbd191d0bdd0bed0ba, 0x30372d30382d32303036, 300, 10, '', 0x4d6f7a696c6c61, 0, 0, '', '', 0x38352e3139322e3133382e3534, 0x4d6f7a696c6c612f342e302028636f6d70617469626c653b204d53494520362e303b2057696e646f7773204e5420352e313b20727529204f7065726120382e3532, 0, 0, 0, 0, '', 0, '2007-03-20 15:55:27', 0x2d7472616874656e626572672d, '', 1154923090, 0x686f6c6c, 2, 1, 'small', '7', 0, 0, 0, 1, 0, 0, 0, 0, 1, '0', 0, '3.2', '3.2', 0, 0, 0, 1, 0, 0, '', 0, '', '', '', '', '', '', '', '', '', '', '1', '', 0, 8, 2, 1, 1, 0, 1, 0, '', 0, '', 0, 1);
INSERT INTO `users` VALUES (10, 0x41646d696e, 0x3132333435, 0xd090d0bdd0b6d0b5d0bbd0b8d0bad0b0, 0xd096, '31-08-1979', 'Латвия', 'Anza79@list.ru', '', '.', 0xd09fd180d0bed181d182d0be20d0bcd0b0d0bcd0b02e20d09bd18ed0b1d0bbd18e20d181d18bd0bdd0b020d0add0b4d0b8d187d0bad1832ed09ed0b1d0b0d0b6d0b0d18e20d0a161d188d1832ed0a1d0b0d188d0b020d182d18b20d0bbd183d187d188d0b520d0b2d181d0b5d1852e, 2736, 0xd091d0b0d0b1d183d0bbd18f, 0x31312d30312d32303036, 200, 15, 0x2e2e, 0x2e, 8, 0, '', '', 0x3132372e302e302e31, 0x4d6f7a696c6c612f342e302028636f6d70617469626c653b204d53494520362e303b2057696e646f7773204e5420352e313b20727529204f7065726120382e3534, 0, 0, 1659, -485790, '', 1, '2007-03-20 15:57:28', '', 0x61646d696e, 1174388248, 0x686f6c6c, 0, 0, 'medium', '000000000000', 0, 0, 0, 0, 0, 0, 0, 0, 1, 'ЗадуРС?чивое', 78, '14766', '3.8', 15, 0, 0, 0, 0, 75, 0xd097d0b0d0bdd18fd182d0b020d0af202929, 0, 'Злобна', 'МурлыСвЂ', 'Р  ыча', 'ХолоднР', 'Р РЋР С?еясвЂ&', '', '', '', '', '', '0', '11.gif', 0, 8, 2, 1, 0, 1, 0, 46, '', 0, '', 1, 1);

ALTER TABLE `users` ADD `theme` tinyint(2) unsigned NOT NULL default 2;

ALTER TABLE `users` ADD `postmag` int(11) NOT NULL default 0;

ALTER TABLE `users` ADD `picpol` tinyint(1) NOT NULL default 1;

CREATE TABLE kurs (
  `id` int(11) NOT NULL auto_increment,
  `nik` int(11) NOT NULL default '0',
  `status` int(11) NOT NULL default '0',
  `objav` int(11) NOT NULL default '0',
  `top` int(11) NOT NULL default '0',
  `vstrecha` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
INSERT INTO kurs VALUES (1, '20', '20', '20', '20', '20');

CREATE TABLE `akcyi` (
  `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=1 ;

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

ALTER TABLE `users` ADD `ot` int(11) NOT NULL default 0;

CREATE TABLE `levels` (
  `level` smallint(5) NOT NULL default '0',
  `name` blob,
  PRIMARY KEY  (`level`)
) TYPE=MyISAM;
INSERT INTO `levels` (`level`, `name`) VALUES (0, 0xd09dd0bed0b2d0b8d187d0bed0ba),
(1, 0xd09fd0bed0bbd18cd0b7d0bed0b2d0b0d182d0b5d0bbd18c),
(2, 0xd0a7d0b0d182d182d0b5d180),
(3, 0xd0a2d183d181d0bed0b2d189d0b8d0ba),
(4, 0x562e492e50),
(5, 0xd09ad0b8d0bbd0bbd0b5d180),
(6, 0xd0a1d182d0b0d180d188d0b8d0b920d0bcd0bed0b4d0b5d180),
(7, 0xd090d0b4d0bcd0b8d0bd),
(8, 0xd0a1d183d0bfd0b5d18020d090d0b4d0bcd0b8d0bd);

ALTER TABLE `rooms` ADD `vid` int(11) NOT NULL default 1;

ALTER TABLE `obiav` ADD `chit` int(11) NOT NULL default 0;

CREATE TABLE IF NOT EXISTS `newskom` (
  `id` int(11) NOT NULL auto_increment,
  `mid` int(11) NOT NULL default '0',
  `login` text character set utf8 NOT NULL,
  `content` text character set utf8 NOT NULL,
  `date` varchar(10) default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM PACK_KEYS=0 AUTO_INCREMENT=1 ;

CREATE TABLE `konkurs` (
  `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=1 ;


ALTER TABLE `setting` ADD `privetstvie` text character set utf8 NOT NULL;
ALTER TABLE `setting` ADD `fotogav` int(11) NOT NULL default '1';

ALTER TABLE `setting` ADD `thema` tinyint(2) unsigned NOT NULL default 2;



ALTER TABLE `setting` ADD `clon` int(11) NOT NULL default '1';

ALTER TABLE `users` ADD `rating` int(11) NOT NULL default 0;

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

ALTER TABLE `users` ADD `vopros` int(11) NOT NULL default 0;

ALTER TABLE `users` ADD `otvet` text character set utf8 NOT NULL;

ALTER TABLE `users` ADD `bind5` tinyint(1) NOT NULL default 3;

ALTER TABLE `users` ADD `pole` int(11) NOT NULL default 0;

ALTER TABLE `users` ADD `cvetn` int(11) NOT NULL default 0;

UPDATE `rooms` SET `rm` = '0' WHERE `rm` =25 LIMIT 1 ;

UPDATE `rooms` SET `rm` = '25' WHERE `rm` =31 LIMIT 1 ;

CREATE TABLE `color` (
  `id` int(11) NOT NULL auto_increment,
  `nazwan` text NOT NULL,
  `fon_osn` text NOT NULL,
  `text_osn` text NOT NULL,
  `hrift` text NOT NULL,
  `ssilka_osn` text NOT NULL,
  `razmer_osn` int(11) NOT NULL default '0',
  `fon_1` text NOT NULL,
  `text_1` text NOT NULL,
  `border_1` text NOT NULL,
  `razmer_1` int(11) NOT NULL default '0',
  `fon_2` text NOT NULL,
  `text_2` text NOT NULL,
  `border_2` text NOT NULL,
  `razmer_2` int(11) NOT NULL default '0',
  `fon_3` text NOT NULL,
  `text_3` text NOT NULL,
  `border_3` text NOT NULL,
  `razmer_3` int(11) NOT NULL default '0',
  `fon_4` text NOT NULL,
  `text_4` text NOT NULL,
  `border_4` text NOT NULL,
  `razmer_4` int(11) NOT NULL default '0',
  `fon_f` text NOT NULL,
  `text_f` text NOT NULL,
  `border1_f` text NOT NULL,
  `border2_f` text NOT NULL,
  `border3_f` text NOT NULL,
  `border4_f` text NOT NULL,
  `razmer_f` int(11) NOT NULL default '0',
  `razdel` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE `infamgs` (
  `id` int(11) NOT NULL auto_increment,
  `nazwan` text NOT NULL,
  `mgs` text NOT NULL,
  `raz` int(11) NOT NULL default '0',
  `liven` int(11) NOT NULL default '0',
  `kto` text NOT NULL,
  `pol` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE `infaraz` (
  `id` int(11) NOT NULL auto_increment,
  `nazwan` text NOT NULL,
  `pol` int(11) NOT NULL default '0',
  `liven` int(11) NOT NULL default '0',
  `kto` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE `blogs` (
  `id` int(11) NOT NULL auto_increment,
  `avtor` text NOT NULL,
  `name` text NOT NULL,
  `blog` text NOT NULL,
  `golos` int(11) NOT NULL default '0',
  `chit` int(11) NOT NULL default 0,
  `date` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;

CREATE TABLE `bloggolos` (
  `id` int(11) NOT NULL auto_increment,
  `blog` int(11) NOT NULL default '0',
  `who` int(11) NOT NULL default '0',
  `ip` varchar(20) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;

ALTER TABLE `users` ADD `myblogs` varchar(50) NOT NULL default '0';
CREATE TABLE `clans` (
  `id` int(11) NOT NULL auto_increment,
  `lider` text NOT NULL,
  `name` text NOT NULL,
  `opis` text NOT NULL,
  `users` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;

ALTER TABLE `users` ADD `clan` int(11) NOT NULL;

ALTER TABLE `clans` ADD `logo` text NOT NULL;

ALTER TABLE `setting` ADD `anti` text character set utf8 NOT NULL;
ALTER TABLE `setting` ADD `regroom` text character set utf8 NOT NULL;
ALTER TABLE `setting` ADD `postclan` text character set utf8 NOT NULL;

CREATE TABLE IF NOT EXISTS `stenaclan` (
  `id` int(11) NOT NULL auto_increment,
  `mid` int(11) NOT NULL default '0',
  `login` text character set utf8 NOT NULL,
  `content` text character set utf8 NOT NULL,
  `date` varchar(10) default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM PACK_KEYS=0 AUTO_INCREMENT=1 ;

CREATE TABLE `foto_add` (
  `id` int(11) NOT NULL auto_increment,
  `kto` text NOT NULL,
  `komentar` text NOT NULL,
  `raz_v` int(11) NOT NULL default '0',
  `raz_n` int(11) NOT NULL default '0',
  `razdel` int(11) NOT NULL default '0',
  `album` int(11) NOT NULL default '0',
  `prosm` int(11) NOT NULL default '0',
  `time` text NOT NULL,
  `adres` text NOT NULL,
  `format` text NOT NULL,
  `razmer` text NOT NULL,
  `liven` int(11) NOT NULL default '0',
  `nazwan` text NOT NULL,
  `tegas` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE `foto_albom` (
  `id` int(11) NOT NULL auto_increment,
  `nazwan` text NOT NULL,
  `kto` text NOT NULL,
  `razdel` int(11) NOT NULL default '0',
  `kometatr` int(11) NOT NULL default '0',
  `liven` int(11) NOT NULL default '0',
  `sozdan` text NOT NULL,
  `izmenen` text NOT NULL,
  `prosm` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE TABLE `foto_komm` (
  `id` int(11) NOT NULL auto_increment,
  `kto` text NOT NULL,
  `komm` text NOT NULL,
  `time` text NOT NULL,
  `liven` int(11) NOT NULL default '0',
  `foto` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE TABLE `foto_raz` (
  `id` int(11) NOT NULL auto_increment,
  `nazwan` text NOT NULL,
  `pol` int(11) NOT NULL default '0',
  `liven` int(11) NOT NULL default '0',
  `time` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE TABLE `falii` (
  `id` int(11) NOT NULL auto_increment,
  `kto` text NOT NULL,
  `format` text NOT NULL,
  `adres` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
ALTER TABLE `users` ADD `money` int(11) NOT NULL default 0;

ALTER TABLE `setting` ADD `ban1` varchar(200) NOT NULL default '';
ALTER TABLE `setting` ADD `ban2` varchar(200) NOT NULL default '';
ALTER TABLE `setting` ADD `ban3` varchar(200) NOT NULL default '';
ALTER TABLE `setting` ADD `ban1_img` varchar(50) binary NOT NULL default '';
ALTER TABLE `setting` ADD `ban2_img` varchar(50) binary NOT NULL default '';
ALTER TABLE `setting` ADD `ban3_img` varchar(50) binary NOT NULL default '';
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 `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` (`klu4`, `action`, `nexttime`, `kiked`, `prevprev`, `prev`, `current`, `cround`) VALUES (1, 'nogame', 1172463028, 0, 200, 3, 2, 2);

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',
  `komu` varchar(40) NOT NULL default '',
  PRIMARY KEY  (`klu4`)
) TYPE=MyISAM;

CREATE TABLE `scores1` (
  `gamer_id` int(11) NOT NULL default '0',
  `score` int(11) NOT NULL default '0',
  PRIMARY KEY  (`gamer_id`)
) TYPE=MyISAM;
INSERT INTO `scores1` (`gamer_id`, `score`) VALUES (1457, 0),
(913, 20),
(839, 60),
(1472, 75);

INSERT INTO `color` VALUES (1, 'Стандпртный', 'DADADA', '000000', 'Arial', '0000FF', 12, '0080FF', '000000', '000000', 1, '9393FF', '000000', '000000', 1, 'CCFFFF', '000000', '000000', 1, 'C0C0C0', '000000', '000000', 1, '0080FF', '000000', '336688', '003366', '003366', '336688', 1, '0080FF');

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

ALTER TABLE `clans` ADD `vid` int(11) NOT NULL;

ALTER TABLE `users` ADD `clanz` int(11) NOT NULL;

CREATE TABLE `present` (
  `id` int(11) NOT NULL auto_increment,
  `refid` int(20) NOT NULL,
  `name` varchar(60) NOT NULL,
  `about` varchar(3000) default NULL,
  `nick` int(20) NOT NULL,
  `type` varchar(10) NOT NULL,
  `text` varchar(3000) NOT NULL,
  `comm` int(1) NOT NULL,
  `attach` varchar(200) NOT NULL,
  `down_type` varchar(10) NOT NULL,
  `personal_id` int(10) NOT NULL,
  `date` tinytext NOT NULL,
  `count` int(10) NOT NULL,
  `new_date` tinytext NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1405 DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

ALTER TABLE `users` ADD  `presentset` int(1) NOT NULL default '1';

CREATE TABLE `votes` (
  `id` int(2) NOT NULL auto_increment,
  `name` varchar(100) NOT NULL default '',
  `avtor` varchar(20) NOT NULL default '',
  `date` varchar(10) NOT NULL default '',
  `vopros` varchar(200) default NULL,
  `v1` varchar(100) NOT NULL default '',
  `v2` varchar(100) NOT NULL default '',
  `v3` varchar(100) NOT NULL default '',
  `v4` varchar(100) NOT NULL default '',
  `v5` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE `voting` (
  `klu4` int(3) NOT NULL auto_increment,
  `vote` int(2) NOT NULL default '0',
  `date` varchar(10) NOT NULL default '',
  `var` smallint(1) NOT NULL default '0',
  `who` int(5) NOT NULL default '0',
  PRIMARY KEY  (`klu4`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;