Вы не зашли.
Главная » SQL » подробно объясните как залить бд
#1. dol@r Off (0)
Участник
2010.11.15 22:10
пожалуста объясните как залить таблицу на h2m....вот таблица
Код:
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
 
 
CREATE TABLE `album` (
`id` int(11) NOT NULL auto_increment,
`refid` int(20) NOT NULL,
`name` varchar(60) NOT NULL,
`about` varchar(600) default NULL,
`nick` int(6) NOT NULL,
`type` varchar(1) default NULL,
`type_album` int(1) NOT NULL,
`vote` int(10) NOT NULL,
`vote_col` int(10) NOT NULL,
`count` int(10) NOT NULL,
`date` tinytext NOT NULL,
`new_date` tinytext NOT NULL,
`attach` varchar(3) NOT NULL,
`rating` int(10) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
 
 
CREATE TABLE `album_dostup` (
`id` int(11) NOT NULL auto_increment,
`user` int(11) NOT NULL default '0',
`uid_album` int(11) NOT NULL default '0',
`uid_user` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
 
CREATE TABLE `anekdot` (
`klu4` int(11) NOT NULL auto_increment,
`message` blob NOT NULL,
`who` int(11) NOT NULL default '0',
PRIMARY KEY (`klu4`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
 
 
CREATE TABLE `bank` (
`id` int(11) NOT NULL auto_increment,
`kurs` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
 
 
INSERT INTO `bank` VALUES(1, 25);
 
CREATE TABLE `bannlist` (
`klu4` int(11) NOT NULL auto_increment,
`ip` varchar(255) character set cp1251 collate cp1251_bin NOT NULL default '',
`soft` varchar(255) character set cp1251 collate cp1251_bin NOT NULL default '',
`user` varchar(255) character set cp1251 collate cp1251_bin NOT NULL default '',
PRIMARY KEY (`klu4`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
 
 
CREATE TABLE `blog` (
`id` int(11) NOT NULL auto_increment,
`who` int(11) NOT NULL default '0',
`topic` varchar(60) NOT NULL default '',
`text` blob NOT NULL,
`bdata` varchar(14) default '0',
`bread` int(10) default '0',
`blog` int(11) default '0',
`votes` int(5) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `who` (`who`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
 
 
CREATE TABLE `blogvote` (
`key` int(10) NOT NULL auto_increment,
`id` int(10) NOT NULL default '0',
`who` int(10) NOT NULL default '0',
PRIMARY KEY (`key`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
 
CREATE TABLE `bomj` (
`klu4` int(11) NOT NULL default '0',
`night_act` text NOT NULL,
PRIMARY KEY (`klu4`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
 
INSERT INTO `bomj` VALUES(1, 'Городской бомж, оставив помойку, шарит своими грязными руками по карманам прохожих...');
INSERT INTO `bomj` VALUES(2, 'Вонючий бомж шныряет по переулкам, и между очередной мусоркой копается в чьих-то карманах...');
INSERT INTO `bomj` VALUES(3, 'бомж, распространяя по городу чудесный аромат своих подмышек, умудряется еще проверять карманы горожан...');
 
CREATE TABLE IF NOT EXISTS `botg` (
`number` int(5) NOT NULL default '0',
`vopros` blob NOT NULL,
`answer` varchar(100) collate utf8_unicode_ci NOT NULL default '',
`tran` varchar(60) collate utf8_unicode_ci NOT NULL default '',
PRIMARY KEY (`number`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 
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`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
 
CREATE TABLE `bot_dialog` (
`id` int(11) NOT NULL auto_increment,
`message` blob NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
 
CREATE TABLE `doktor` (
`klu4` int(11) NOT NULL default '0',
`night_act` text NOT NULL,
PRIMARY KEY (`klu4`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
 
 
INSERT INTO `doktor` VALUES(1, 'Доктор, захватив с собой щприц побольwе, рыщет по городу, кому же и куда его вставить...');
INSERT INTO `doktor` VALUES(2, 'Доктор, наглотавщись дури, рещил залечить что-нибудь у кого-нибудь этой ночью...');
INSERT INTO `doktor` VALUES(3, 'Нащ бравый городской врач выщел на охоту за пациентами. у него так и чешутся руки кого-нибудь вылечить...');
 
 
CREATE TABLE `forum_message` (
`id` int(11) NOT NULL auto_increment,
`topic` int(11) NOT NULL default '0',
`login` text NOT NULL,
`msg` text NOT NULL,
`time` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
 
 
 
CREATE TABLE `forum_sections` (
`id` int(11) NOT NULL auto_increment,
`name` text character set cp1251 collate cp1251_bin NOT NULL,
`topic` int(11) NOT NULL default '0',
`time` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=11 ;
 
 
INSERT INTO `forum_sections` VALUES(1, 'О чате', 0, 1235573230);
INSERT INTO `forum_sections` VALUES(2, 'Музыка', 0, 1235929211);
INSERT INTO `forum_sections` VALUES(3, 'Спорт', 0, 1236132537);
INSERT INTO `forum_sections` VALUES(4, 'iнтернеt', 0, 1235115992);
INSERT INTO `forum_sections` VALUES(5, 'Мобилы', 0, 1235480763);
INSERT INTO `forum_sections` VALUES(6, 'Любофф', 0, 1235748623);
INSERT INTO `forum_sections` VALUES(7, 'Знакомства', 0, 1235236382);
INSERT INTO `forum_sections` VALUES(8, 'Планета земля', 0, 1236583002);
INSERT INTO `forum_sections` VALUES(9, 'Флудилка', 0, 1235124019);
INSERT INTO `forum_sections` VALUES(10, 'Запретная зона', 0, 1235822016);
 
 
CREATE TABLE `forum_topic` (
`id` int(11) NOT NULL auto_increment,
`section` int(11) NOT NULL default '0',
`login` text NOT NULL,
`name` text NOT NULL,
`close` int(11) NOT NULL default '0',
`time` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
 
 
CREATE TABLE `frazi` (
`klu4` int(11) NOT NULL auto_increment,
`message` blob NOT NULL,
PRIMARY KEY (`klu4`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
 
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`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
 
 
CREATE TABLE `gazeta` (
`id` int(11) NOT NULL auto_increment,
`login` varchar(50) NOT NULL default '',
`content` text,
`date` varchar(10) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 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`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 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`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
 
 
 
INSERT INTO `help` VALUES(0, 37, 0);
INSERT INTO `help` VALUES(1, 180, 0);
INSERT INTO `help` VALUES(2, 105, 0);
INSERT INTO `help` VALUES(3, 87, 0);
INSERT INTO `help` VALUES(4, 0, 0);
INSERT INTO `help` VALUES(5, 0, 0);
INSERT INTO `help` VALUES(6, 45, 0);
INSERT INTO `help` VALUES(7, 100, 0);
INSERT INTO `help` VALUES(8, 222, 0);
INSERT INTO `help` VALUES(9, 486, 0);
INSERT INTO `help` VALUES(10, 0, 0);
INSERT INTO `help` VALUES(11, 100, 0);
INSERT INTO `help` VALUES(12, 59, 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);
INSERT INTO `help` VALUES(21, 0, 0);
INSERT INTO `help` VALUES(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`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
 
 
CREATE TABLE `ingame23` (
`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`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
 
 
CREATE TABLE `komissar` (
`klu4` int(11) NOT NULL default '0',
`night_act` text NOT NULL,
PRIMARY KEY (`klu4`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
 
 
INSERT INTO `komissar` VALUES(1, 'Комиссар Катани, сев в свой бобик, поехал искать преступников...');
INSERT INTO `komissar` VALUES(2, 'Комиссар Катани, наглотавшись колес, ходит по комнате и вычисляет мафию...');
INSERT INTO `komissar` VALUES(3, 'Комиссар Катани лежит в засаде в куче навоза и следит за мафией... Фуу-у, ну и запашок:)');
 
 
CREATE TABLE `levels` (
`level` smallint(5) NOT NULL default '0',
`name` blob,
PRIMARY KEY (`level`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
 
 
INSERT INTO `levels` VALUES(0, 0xd09dd0bed0b2d0b8d187d0bed0ba);
INSERT INTO `levels` VALUES(1, 0xd09fd0bed0bbd18cd0b7d0bed0b2d0b0d182d0b5d0bbd18c);
INSERT INTO `levels` VALUES(2, 0xd0a7d0b0d182d182d0b5d180);
INSERT INTO `levels` VALUES(3, 0xd0a2d183d181d0bed0b2d189d0b8d0ba);
INSERT INTO `levels` VALUES(4, 0x562e492e50);
INSERT INTO `levels` VALUES(5, 0xd09ad0b8d0bbd0bbd0b5d180);
INSERT INTO `levels` VALUES(6, 0xd0a1d182d0b0d180d188d0b8d0b920d0bcd0bed0b4d0b5d180);
INSERT INTO `levels` VALUES(7, 0xd090d0b4d0bcd0b8d0bd);
INSERT INTO `levels` VALUES(8, 0xd093d0bbd0b0d0b2d0bdd18bd0b920d090d0b4d0bcd0b8d0bdd0b8d181d182d180d0b0d182d0bed180);
 
 
CREATE TABLE `mafaction23` (
`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`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
 
 
INSERT INTO `mafaction23` VALUES(1, 'nogame', 1235709856, 0, 199, 199, 200, 1);
 
CREATE TABLE `mafia` (
`klu4` int(11) NOT NULL default '0',
`night_act` text NOT NULL,
PRIMARY KEY (`klu4`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
 
 
INSERT INTO `mafia` VALUES(1, 'Мафиози, вооружившись до зубов, направляются навстречу своей жертве...');
INSERT INTO `mafia` VALUES(2, 'Главарь мафии высматривает свою жертву. За ним, лизоблюдя, следуют его шестерки...');
INSERT INTO `mafia` VALUES(3, 'Мафия на четырех машинах носится по ночному городу и пугает редких прохожих...');
 
 
CREATE TABLE `maniac` (
`klu4` int(11) NOT NULL default '0',
`night_act` text NOT NULL,
PRIMARY KEY (`klu4`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
 
 
INSERT INTO `maniac` VALUES(1, 'Маньяк носится с топором в руках по темным переулкам...');
INSERT INTO `maniac` VALUES(2, 'Маньяк с гадкой ухмылкой на лице точит свой топор...');
INSERT INTO `maniac` VALUES(3, 'Маньяк сидит в засаде с оружием наготове и поджидает случайных прохожих...');
 
 
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`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 PACK_KEYS=0 AUTO_INCREMENT=17 ;
 
 
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`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=72 ;
 
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`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
 
 
INSERT INTO `optim` VALUES(1, 1236617954, 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`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
 
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`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
 
 
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`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
 
 
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`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
 
 
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`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
 
 
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`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
 
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`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
 
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`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
 
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`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
 
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`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
 
CREATE TABLE `room10` (
`klu4` int(8) NOT NULL default '0',
`time` varchar(5) character set cp1251 collate cp1251_bin 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) character set cp1251 collate cp1251_bin 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`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
 
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`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
 
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`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
 
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`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
 
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`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
 
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`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
 
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`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
 
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`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
 
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`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
 
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`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
 
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`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
 
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`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
 
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`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
 
CREATE TABLE `room23` (
`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`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
 
CREATE TABLE `rooms` (
`rm` smallint(5) NOT NULL auto_increment,
`name` blob,
`topic` blob,
`pos` tinyint(2) NOT NULL default '0',
PRIMARY KEY (`rm`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 PACK_KEYS=0 AUTO_INCREMENT=24 ;
 
INSERT INTO `rooms` VALUES (0, 0xd092d0b8d0bad182d0bed180d0b8d0bdd0b0, 0xd092d0b8d0bad182d0bed180d0b8d0bdd0b0, 0);
INSERT INTO `rooms` VALUES (1, 0xd09720d09020d09320d0a1, 0xd0b6d0b5d0bdd0b8d18520d0b820d0bdd0b5d0b2d0b5d181d182d0b021, 9);
INSERT INTO `rooms` VALUES (2, 0xd097d0bdd0b0d0bad0bed0bcd181d182d0b2d0b0, 0xd0a1d0bbd0b0d0b4d0bad0b0d18f20d0bfd0b0d180d0bed187d0bad0b020d0b3d0b3, 2);
INSERT INTO `rooms` VALUES (3, 0x696e636f676e69746f, 0xd09fd180d0bed185d0bed0b4d0b8d182d0b52cd0bdd0b520d181d182d0b5d181d0bdd18fd0b9d182d0b5d181d18c, 2);
INSERT INTO `rooms` VALUES (4, 0xd094d0b8d181d0bad0bed0b1d0b0d180, 0xd093d183d0bbd18fd182d18c2cd182d0b0d0ba20d0b3d183d0bbd18fd182d18c2e2e, 3);
INSERT INTO `rooms` VALUES (5, 0xd09ad0b0d184d0b5d188d0bad0b0, 0xd09dd0b02ed0bbd0b82ed0b2d0b0d0b93a29d0b3d0b3, 4);
INSERT INTO `rooms` VALUES (6, 0x434f4d45445920434c5542, 0xd0a5d0b8d185d0b0d0bdd18cd0bad0b8, 7);
INSERT INTO `rooms` VALUES (7, 0xd091d0b5d0b7d0b4d0b5d0bbd18cd0bdd0b8d0bad0b8, 0xd091d18cd191d0bc20d0b1d0b0d0bad0bbd183d188d0ab, 6);
INSERT INTO `rooms` VALUES (8, 0xd092d18bd181d188d0b8d0b920d0a1d0bed0b2d0b5d182, 0xd0a1d0b0d0bcd0bcd0b8d182, 12);
INSERT INTO `rooms` VALUES (9, 0xd097d0bed0bed0bfd0b0d180d0ba, 0xd09dd0b5d184d182d18fd0ba, 2);
INSERT INTO `rooms` VALUES (10, 0xd098d0bdd182d0b8d0bc, 0xd0a2d0b5d1822dd0902dd0a2d0b5d182, 10);
INSERT INTO `rooms` VALUES (11, 0xd09ad0bbd0b0d0b7d0bdd0b5d18220d0b7d0bdd0b0d182d0bed0bad0bed0b2, 0xd182d180d0b0d185d0bed0b4d180d0bed0bc, 9);
INSERT INTO `rooms` VALUES (12, 0xd0a2d180d0b0d185d182d0b5d0bdd0b1d0b5d180d0b32043697479, 0xd09ed0b4d0bdd0be20d0b3d0b0d0b2d0bdd0be20d0b820d0b4d0b8d0b1d0b8d0bbd0b8d0b7d0bc2e2e2e, 11);
INSERT INTO `rooms` VALUES (13, 0xd09bd0b8d182d0b2d0b0, 0xd09bd18ed0b1d0b8d0bcd0b0d18f20d0bcd0bed18f20d0a0d095d094d098d0a1d09ed0a7d09ad090212121, 13);
INSERT INTO `rooms` VALUES (14, 0xd09bd0b0d182d0b2d0b8d18f, '', 14);
INSERT INTO `rooms` VALUES (15, 0xd0a3d0bad180d0b0d0b8d0bdd0b0, '', 15);
INSERT INTO `rooms` VALUES (16, 0xd091d0b5d0bbd0bed180d183d181d181d0b8d18f, '', 16);
INSERT INTO `rooms` VALUES (17, 0xd090d0b7d0b5d180d0b1d0b0d0b9d0b4d0b6d0b0d0bd, '', 17);
INSERT INTO `rooms` VALUES (18, 0xd09ad0b0d0b7d0b0d185d181d182d0b0d0bd, '', 18);
INSERT INTO `rooms` VALUES (19, 0xd093d180d183d0b7d0b8d18f, '', 19);
INSERT INTO `rooms` VALUES (20, 0xd09ad0b0d0b2d0bad0b0d0b7d181d0bad0b0d18f, '', 20);
INSERT INTO `rooms` VALUES (21, 0xd098d0b7d180d0b0d0b8d0bbd18c, '', 21);
INSERT INTO `rooms` VALUES (22, 0xd098d181d0bfd0b0d0bdd0b8d18f, '', 22);
INSERT INTO `rooms` VALUES (23, 0xd098d0b3d180d0b020d09cd0b0d184d0b8d18f, 0xd09cd0b0d184d18bd0abd0ab, 24);
 
 
CREATE TABLE `scores23` (
`gamer_id` int(11) NOT NULL default '0',
`score` int(11) NOT NULL default '0',
PRIMARY KEY (`gamer_id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
 
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',
`rus` smallint(1) NOT NULL default '0',
`reg` smallint(1) NOT NULL default '1',
`priwat` smallint(1) NOT NULL default '0',
`bestfoto` smallint(1) NOT NULL default '0',
`regstatus` varchar(255) collate utf8_unicode_ci DEFAULT '0' NOT NULL ,
`regposts` varchar(255) collate utf8_unicode_ci DEFAULT '0' NOT NULL ,
PRIMARY KEY (`klu4`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 
INSERT INTO `setting` VALUES(1, 0, 1, 1800, 10, 6, 6, 0,1, 1, 0, 0,'','');
 
CREATE TABLE `shutki` (
`klu4` int(11) NOT NULL auto_increment,
`message` blob NOT NULL,
PRIMARY KEY (`klu4`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
 
 
CREATE TABLE `stihi` (
`id` int(11) NOT NULL auto_increment,
`login` text NOT NULL,
`title` text NOT NULL,
`content` text NOT NULL,
`autor` varchar(255) character set utf8 collate utf8_unicode_ci default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
 
CREATE TABLE `svadbi` (
`id` int(11) NOT NULL auto_increment,
`zhenih` text NOT NULL,
`nevesta` text NOT NULL,
`frzhenih` blob NOT NULL,
`frnevesta` blob NOT NULL,
`date` varchar(10) character set cp1251 collate cp1251_bin default NULL,
`vremya` varchar(10) character set cp1251 collate cp1251_bin default NULL,
`organizatory` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
 
CREATE TABLE `users` (
`id` int(11) NOT NULL auto_increment,
`user` varchar(50) character set cp1251 collate cp1251_bin NOT NULL default '',
`pass` varchar(30) character set cp1251 collate cp1251_bin default NULL,
`name` varchar(30) character set cp1251 collate cp1251_bin default NULL,
`sex` varchar(6) character set cp1251 collate cp1251_bin 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) character set cp1251 collate cp1251_bin NOT NULL default 'User',
`date` varchar(10) character set cp1251 collate cp1251_bin default NULL,
`avr` smallint(3) NOT NULL default '300',
`max` smallint(2) NOT NULL default '10',
`op` varchar(100) character set cp1251 collate cp1251_bin default NULL,
`mob` varchar(100) character set cp1251 collate cp1251_bin default NULL,
`level` smallint(6) NOT NULL default '0',
`kik` int(20) NOT NULL default '0',
`whokik` varchar(20) character set cp1251 collate cp1251_bin NOT NULL default '',
`whykik` varchar(200) character set cp1251 collate cp1251_bin NOT NULL default '',
`user_ip` varchar(20) character set cp1251 collate cp1251_bin NOT NULL default '',
`user_soft` varchar(200) character set cp1251 collate cp1251_bin 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) character set cp1251 collate cp1251_bin NOT NULL default '',
`translit` tinyint(1) NOT NULL default '0',
`visit` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`ruser` varchar(30) character set cp1251 collate cp1251_bin NOT NULL default '',
`latuser` varchar(30) character set cp1251 collate cp1251_bin NOT NULL default '',
`onl` int(11) NOT NULL default '0',
`room` varchar(10) character set cp1251 collate cp1251_bin 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 '0',
`anketa` tinyint(1) NOT NULL default '1',
`money` varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL default '0',
`thema` varchar(255) character set utf8 collate utf8_unicode_ci default NULL,
`color` varchar(255) character set utf8 collate utf8_unicode_ci default NULL,
`referal` int(10) NOT NULL default '0',
`blog` int(10) NOT NULL default '0',
`kn_smiles` tinyint(1) NOT NULL default '0',
`credits2` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
FULLTEXT KEY `img` (`img`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 PACK_KEYS=0 AUTO_INCREMENT=291 ;
 
--
-- Дамп данных таблицы `users`
--
 
INSERT INTO `users` VALUES (1, 0x2dd0a1d0b8d181d182d0b5d0bcd0bdd0bed0b52d, 0x5273725253725352, 0x2d, 0xd096, '01-09-2008', '-', '', '', '', 0x2d, 0, 0xd09fd0bed0bbd18cd0b7d0bed0b2d0b0d182d0b5d0bbd18c, 0x31312d31312d31313131, 0, 10, '', '', 0, 0, '', '', 0x3132372e302e302e31, 0x4d6f7a696c6c612f352e30202857696e646f7773204e5420352e313b20553b20727529204f7065726120382e3534, 0, 0, 1, 0, '', 0, '2009-06-23 10:38:11', 0x2d73697374656d6e6f652d, '', 1209563317, 0x686f6c6c, 2, 0, 'small', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, '0', 0, '88.6', '3.3', 0, 0, 0, 0, 0, 0, '', 0, '', '', '', '', '', '', '', '', '', '', '1', '', 0, 8, 2, 1, 0, 0, 1, 0, '', 0, '', 0, 1, '0', NULL, '1', 0, 0, 0, 0);
INSERT INTO `users` VALUES (2, 0x2dd09dd0b5d097d0bdd0b0d0b9d0bad0b02d, 0x5273725253725352, 0x2d, 0xd09c, '01-09-2008', '-', '', 'http://wapsuper.ru', '', 0x2d, 79447, '', '', 100, 10, '', '', 3, 0, '', '', 0x3132372e302e302e31, 0x4f706572612f392e3230202857696e646f7773204e5420352e313b20553b20727529, 0, 1, 0, 0, '', 0, '2009-06-26 14:06:51', 0x626f74616e696b, '', 1246010811, 0x30, 0, 0, 'small', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, '0', 0, '356.3', '4.5', 0, 0, 0, 0, 0, 0, '', 0, '', '', '', '', '', '', '', '', '', '', '1', '', 0, 8, 2, 1, 0, 0, 1, 0, '', 0, '', 1, 1, '0', NULL, '1', 0, 0, 0, 0);
INSERT INTO `users` VALUES (3, 0x2d434f4d4544592d, 0x5273725253725352, 0x2d, 0xd096, '01-09-2008', '-', '', 'http://wapsuper.ru', '', 0x2d, 0, '', 0x32322d30312d32303036, 0, 10, '', '', 0, 0, '', '', 0x38332e3134332e36352e313839, 0x4d6f7a696c6c612f342e302028636f6d70617469626c653b204d53494520362e303b2057696e646f7773204e5420352e313b20727529204f7065726120382e3531, 0, 1, 0, 0, '', 0, '2009-06-23 10:38:11', 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, '0', NULL, NULL, 0, 0, 0, 0);
INSERT INTO `users` VALUES (4, 0x2dd0a1d0bfd0b5d0bad183d0bbd18fd0bdd1822d, 0x5273725253725352, 0x2d, 0xd09c, '01-09-2008', '-', '', 'wapsuper.ru', '', 0x2d, 0, 0xd09fd0bed0bbd18cd0b7d0bed0b2d0b0d182d0b5d0bbd18c, 0x31332d30352d32303036, 150, 10, '', '', 0, 0, '', '', 0x38352e3139352e3132332e3232, 0x687474703a2f2f416e6f6e796d6f7573652e6f72672f2028556e697829, 0, 0, 0, 0, '', 0, '2009-06-23 10:38:11', 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, '0', NULL, NULL, 0, 0, 0, 0);
INSERT INTO `users` VALUES (5, 0x2dd09cd0b0d184d0b8d0bed0b7d0b82d, 0x5273725253725352, 0x2d, 0xd09c, '01-09-2008', '-', '', 'http://wapsuper.ru', '', 0x2d, 1819, 0xd09fd0bed0bbd18cd0b7d0bed0b2d0b0d182d0b5d0bbd18c, 0x31342d30352d32303036, 150, 10, '', '', 0, 0, '', '', 0x38352e3139322e3133322e313335, 0x4d6f7a696c6c612f342e302028636f6d70617469626c653b204d53494520362e303b2057696e646f7773204e5420352e313b20727529204f7065726120382e3534, 0, 0, 0, 0, '', 0, '2009-06-23 10:38:11', 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, '0', NULL, NULL, 0, 0, 0, 0);
INSERT INTO `users` VALUES (6, 0x2dd0a2d180d0b0d185d182d0b5d0bdd0b1d0b5d180d0b32d, 0x5273725253725352, 0x2d, 0xd09c, '01-09-2008', '-', '', 'wapsuper.ru', '', 0x2d, 0, '', 0x30372d30382d32303036, 300, 10, '', '', 0, 0, '', '', 0x38352e3139322e3133382e3534, 0x4d6f7a696c6c612f342e302028636f6d70617469626c653b204d53494520362e303b2057696e646f7773204e5420352e313b20727529204f7065726120382e3532, 0, 0, 0, 0, '', 0, '2009-06-23 10:38:11', 0x2d7472616874656e626572672d, '', 1154923090, 0x686f6c6c, 2, 1, 'small', '', 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, '0', NULL, NULL, 0, 0, 0, 0);
INSERT INTO `users` VALUES (7, 0x2dd097d0b0d0b3d0b0d0b4d0bad0b02d, 0x5273725253725352, 0x2d, 0xd09c, '01-09-2008', '-', '', '', '', 0x2d, 79458, '', '', 100, 10, '', '', 3, 0, '', '', 0x3132372e302e302e31, 0x4f706572612f392e3230202857696e646f7773204e5420352e313b20553b20727529, 0, 1, 0, 0, '', 0, '2009-06-26 14:06:26', 0x626f74616e696b, '', 1246010786, 0x32, 0, 0, 'small', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, '0', 0, '356.3', '4.5', 0, 0, 0, 0, 0, 0, '', 0, '', '', '', '', '', '', '', '', '', '', '1', '', 0, 8, 2, 1, 0, 0, 1, 0, '', 0, '', 1, 1, '0', NULL, '1', 0, 0, 0, 0);
INSERT INTO `users` VALUES (8, 0x2dd0a3d0bcd0bdd0b8d0ba2d, 0x5273725253725352, 0x2d, 0xd09c, '01-01-1985', '-', '', '', '', 0x2d, 1627, '', 0x30372d30382d32303036, 300, 10, '', '', 0, 0, '', '', 0x3132372e302e302e31, 0x4d6f7a696c6c612f352e30202857696e646f7773204e5420352e313b20553b20727529204f7065726120382e3534, 0, 0, 0, 0, '', 0, '2009-06-26 10:22:40', 0x2d7475706971612d, '', 1245997360, 0x30, 2, 1, 'small', '', 0, 0, 0, 1, 0, 0, 0, 0, 1, '0', 0, '9.5', '1.3', 0, 0, 0, 1, 0, 0, '', 0, '', '', '', '', '', '', '', '', '', '', '1', '', 0, 8, 2, 1, 1, 0, 1, 0, '', 0, '', 0, 1, '0', NULL, NULL, 0, 0, 0, 0);
INSERT INTO `users` VALUES (10, 0x61646d696e, 0x3132333435, 0x61646d696e, 0xd09c, '22-05-1988', 'internet', '', '', '', 0x2d, 3034, 0xd0a1d0bed0b7d0b4d0b0d182d0b5d0bbd18c, 0x30312d31322d32303038, 200, 15, '', '', 8, 0, '', '', 0x3132372e302e302e31, 0x4f706572612f392e3230202857696e646f7773204e5420352e313b20553b20727529, 0, 0, 2, 0, '', 0, '2009-06-26 14:06:51', '', 0x61646d696e, 1246010803, 0x686f6c6c, 2, 0, 'medium', '', 1, 1, 1, 1, 1, 1, 1, 0, 1, '', 0, '4878', '7.2', 8, 0, 1, 1, 0, 0, '', 0, '', '', '', '', '', '', '', '', '', '', '0', '', 0, 8, 2, 1, 1, 1, 0, 0, '', 1, '', 2, 1, '', 'teal', '11', 0, 0, 0, 0);
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) character set cp1251 collate cp1251_bin NOT NULL default '',
`tran` varchar(100) character set cp1251 collate cp1251_bin NOT NULL default '',
PRIMARY KEY (`klu4`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
 
INSERT INTO `vopros` VALUES (1, 1, 1245993791, 0xd0a7d0b8d181d0bbd0bed0b2d0bed0b920d0b8d0bbd0b820d0b1d183d0bad0b2d0b5d0bdd0bdd18bd0b920d0bcd0bdd0bed0b6d0b8d182d0b5d0bbd18c20d0b220d0b0d0bbd0b3d0b5d0b1d180d0b0d0b8d187d0b5d181d0bad0bed0bc20d0b2d18bd180d0b0d0b6d0b5d0bdd0b8d0b82e20283c623e313120d0b1d183d0bad0b23c2f623e29, 0xd0bad0bed18dd184d184d0b8d186d0b8d0b5d0bdd182, 0x6b6f656666696369656e74);
INSERT INTO `vopros` VALUES (2, 1, 1236450619, 0x3c623ed092d0bed0bfd180d0bed1813a3c2f623e20d0a1d0bed0b3d0bbd0b0d181d0bed0b2d0b0d0bdd0bdd0bed181d182d18c2c20d0b5d0b4d0b8d0bdd181d182d0b2d0be20d187d0b0d181d182d0b5d0b92c20d0bed0b1d180d0b0d0b7d183d18ed189d0b8d18520d186d0b5d0bbd0bed0b52e2028d0bdd0b8d185d183d18f20d0bdd0b520d181d0bad0b0d0b6d1832e2e2e29, 0xe0edf1e0ece1ebfc, 0x616e73616d626c2e);
INSERT INTO `vopros` VALUES (3, 1, 1236450619, 0x3c623ed092d0bed0bfd180d0bed1813a3c2f623e20d0a1d0bed0b3d0bbd0b0d181d0bed0b2d0b0d0bdd0bdd0bed181d182d18c2c20d0b5d0b4d0b8d0bdd181d182d0b2d0be20d187d0b0d181d182d0b5d0b92c20d0bed0b1d180d0b0d0b7d183d18ed189d0b8d18520d186d0b5d0bbd0bed0b52e2028d0bdd0b8d185d183d18f20d0bdd0b520d181d0bad0b0d0b6d1832e2e2e29, 0xe0edf1e0ece1ebfc, 0x616e73616d626c2e);
 
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=cp1251 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=cp1251 AUTO_INCREMENT=1 ;
 
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`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
 
CREATE TABLE `wluha` (
`klu4` int(11) NOT NULL default '0',
`night_act` text NOT NULL,
PRIMARY KEY (`klu4`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
 
INSERT INTO `wluha` VALUES(1, 'Шлюха вышла из дома, кому-то сегодня не удастся поспать...');
INSERT INTO `wluha` VALUES(2, 'Девка, виляя бедрами, ходит ночью по городу, не пропуская ни одного мужчины.');
INSERT INTO `wluha` VALUES(3, 'Городская шлюшка в откровенном виде шастает по улицам, выбирая жертву...');
 
CREATE TABLE `zapiski` (
`klu4` int(8) NOT NULL default '0',
`who` varchar(40) character set cp1251 collate cp1251_bin NOT NULL default '',
`idwho` int(12) NOT NULL default '0',
`message` blob NOT NULL,
`towhom` varchar(40) character set cp1251 collate cp1251_bin 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) character set cp1251 collate cp1251_bin NOT NULL default '',
`date` varchar(50) character set cp1251 collate cp1251_bin NOT NULL default '',
`insend` tinyint(1) NOT NULL default '1',
`ininc` tinyint(1) NOT NULL default '1',
PRIMARY KEY (`klu4`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
....говорят залить тоесть что с ней сделать??? может ктот человеческим языком объяснит????????? big_smile
Отредактировано Gemorroj (2010.11.16 10:10)
#2. Gemorroj Off (107)
Administrator
2010.11.16 10:10
открываешь phpmyadmin, выбираешь базу, нажимаешь вкладку SQL, вставляешь этот код, нажимаешь "Выполнить"
Страниц: 1
Главная
WEB
PunBB Mod v0.6.2
0.016 s