Просмотр архива wm двиг на Stronge

DROP TABLE IF EXISTS `antispam`;

CREATE TABLE `antispam` (
  `id` int(11)
NOT NULL AUTO_INCREMENT,
  `news` varchar(244) NOT NULL,
  `stena`
varchar(244) NOT NULL,
  `chat` varchar(244) NOT NULL,
  `forum_tema`
varchar(255) NOT NULL,
  `forum_post` varchar(255) NOT NULL,
  `guest`
varchar(255) NOT NULL,
  `blog` varchar(244) NOT NULL,
  `mes` varchar(244)
NOT NULL,
  `down` varchar(244) NOT NULL,
  `repa` varchar(255) NOT NULL,
 
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT
CHARSET=utf8;

INSERT INTO antispam
VALUES("1","60","60","60","60","60","60","60","60","60","4");



DROP
TABLE IF EXISTS `ban_list`;

CREATE TABLE `ban_list` (
  `id` int(11) NOT
NULL AUTO_INCREMENT,
  `kto` varchar(255) DEFAULT NULL,
  `about`
varchar(255) DEFAULT NULL,
  `time_play` varchar(255) DEFAULT NULL,
 
`time_end` varchar(255) DEFAULT NULL,
  `add_ban` varchar(255) DEFAULT
NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT
CHARSET=cp1251;




DROP TABLE IF EXISTS `blog_com`;

CREATE TABLE
`blog_com` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `msg` text NOT
NULL,
  `avtor` varchar(100) NOT NULL,
  `time` varchar(100) NOT NULL,
 
`blog` varchar(244) NOT NULL,
  `avtorlogin` varchar(100) NOT NULL,
 
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;




DROP TABLE IF
EXISTS `blog_r`;

CREATE TABLE `blog_r` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `name` varchar(30) NOT NULL,
  PRIMARY KEY (`id`)
)
ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

INSERT INTO blog_r
VALUES("2","Куски кодов");



DROP TABLE IF
EXISTS `blog_reit`;

CREATE TABLE `blog_reit` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `stat` varchar(244) NOT NULL,
  `r` varchar(244) NOT
NULL,
  `kto` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB
DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS `blog_search`;

CREATE TABLE
`blog_search` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `meta`
varchar(100) NOT NULL,
  `kto` varchar(100) NOT NULL,
  PRIMARY KEY
(`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS
`blog_stat`;

CREATE TABLE `blog_stat` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `titlename` varchar(100) NOT NULL,
  `text` text NOT
NULL,
  `meta` varchar(100) NOT NULL,
  `razdel` varchar(100) NOT NULL,
 
`avtor` varchar(100) NOT NULL,
  `time` varchar(100) NOT NULL,
  `readlen`
varchar(244) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB
AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

INSERT INTO blog_stat
VALUES("2","Генератор всех возможных
перестановок.","&lt;pre&gt;&lt;code
class=&quot;php&quot;&gt;\r\n/**\r\n* Генерация
всех возможных перестановок\r\n*\r\n* @param array
$newarr заполняемый массив\r\n* @param string $string
исходная строка\r\n* @param string $prefix
перфикс\r\n*/\r\nfunction variant(array &amp;$newarr, $string,
$prefix=\'\') {\r\nif(empty($string)) {\r\n$newarr[] =
$prefix;\r\nreturn;\r\n}\r\n\r\n$len = mb_strlen($string,
\'utf-8\');\r\nfor($i=0; $i&lt;$len; $i++) {\r\n$string_array =
str_split($string);\r\nif(isset($string_array[$i]))
unset($string_array[$i]); \r\nvariant($newarr, implode(\'\',
$string_array),
$prefix.$string{$i});\r\n}\r\n}\r\n\r\n#-------------------------#\r\n\r\n$string
= \'abcdef\';\r\n$arr = array();\r\n\r\nvariant($arr,
$string);\r\nvar_dump($arr);&lt;/code&gt;&lt;/pre&gt;","Ну
вот","2","1","1399213010","3");



DROP
TABLE IF EXISTS `chat_post`;

CREATE TABLE `chat_post` (
  `id` int(11) NOT
NULL AUTO_INCREMENT,
  `room` int(10) NOT NULL,
  `msg` text NOT NULL,
 
`avtor` varchar(244) NOT NULL,
  `avtorlogin` varchar(244) NOT NULL,
 
`time` varchar(244) NOT NULL,
  `color` varchar(25) NOT NULL,
  `emotion`
varchar(40) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT
CHARSET=utf8;




DROP TABLE IF EXISTS `chat_room`;

CREATE TABLE
`chat_room` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(244)
NOT NULL,
  `about` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB
DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS `forum_kat`;

CREATE TABLE
`forum_kat` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `razdel`
varchar(244) NOT NULL,
  `name` varchar(244) NOT NULL,
  PRIMARY KEY
(`id`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8;

INSERT INTO
forum_kat VALUES("2","2","DCMS");
INSERT INTO
forum_kat VALUES("3","2","JohnCMS");
INSERT
INTO forum_kat
VALUES("4","2","Wap-Motor");
INSERT INTO
forum_kat VALUES("5","2","Rotor CMS");
INSERT
INTO forum_kat
VALUES("6","2","Peascms");
INSERT INTO
forum_kat VALUES("7","2","StrongCMS");
INSERT
INTO forum_kat VALUES("8","2","Движки
КоТа");
INSERT INTO forum_kat
VALUES("9","2","Прочие cms");
INSERT
INTO forum_kat VALUES("10","3","Платежные
системы");
INSERT INTO forum_kat
VALUES("11","3","Оценка/Реклама");
INSERT
INTO forum_kat
VALUES("12","3","Кредиты/Займы");
INSERT
INTO forum_kat
VALUES("13","3","Арбитраж");
INSERT
INTO forum_kat
VALUES("14","3","Халява/Бесплатные
ресурсы/Поиск");
INSERT INTO forum_kat
VALUES("15","3","Купля/Продажа/Обмен");
INSERT
INTO forum_kat
VALUES("16","4","Программирование");
INSERT
INTO forum_kat
VALUES("17","4","Хостинг/Домены");
INSERT
INTO forum_kat VALUES("18","4","Вопросы
новичков");
INSERT INTO forum_kat
VALUES("19","4","Помощь по
установке");
INSERT INTO forum_kat
VALUES("20","4","Скрипты/Поиск");
INSERT
INTO forum_kat
VALUES("21","4","Графика");
INSERT
INTO forum_kat
VALUES("22","5","Конкурсы");
INSERT
INTO forum_kat
VALUES("23","5","Вопросы/Предложения");
INSERT
INTO forum_kat VALUES("24","5","Жизнь
сайта");
INSERT INTO forum_kat
VALUES("25","5","Обновления");
INSERT
INTO forum_kat
VALUES("26","5","Баги/Ошибки");
INSERT
INTO forum_kat
VALUES("27","6","Общение/Флуд/Оффтоп");
INSERT
INTO forum_kat
VALUES("28","6","Музыка/Тв/Кино");
INSERT
INTO forum_kat
VALUES("29","6","Политика/Обсуждения");



DROP
TABLE IF EXISTS `forum_post`;

CREATE TABLE `forum_post` (
  `id` int(11)
NOT NULL AUTO_INCREMENT,
  `razdel` int(11) NOT NULL,
  `kat` int(11) NOT
NULL,
  `tema` int(11) NOT NULL,
  `text` mediumtext NOT NULL,
  `us`
varchar(255) NOT NULL,
  `time` varchar(255) NOT NULL,
  `citata`
mediumtext NOT NULL,
  `citata_us` varchar(255) NOT NULL,
  PRIMARY KEY
(`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8;

INSERT INTO
forum_post
VALUES("13","6","27","2","Топ
тема общения! Общаемся, знакомимся и
т.д.\r\nМат разрешен.\r\nФлуд
разрешен.\r\nОффтоп разрешен.\r\nРеклама
запрещена.","1","1399141992","","");
INSERT
INTO forum_post
VALUES("14","6","27","3","ТоП
тема приколов. Оставляем разные скрины с
приколами.","1","1399142290","","");
INSERT
INTO forum_post
VALUES("16","6","27","2",".пох.","1","1399144359","","");
INSERT
INTO forum_post
VALUES("17","6","27","2","А
че бля мат
разрешен","6","1399144453","","");
INSERT
INTO forum_post
VALUES("18","6","27","2","Ты
стерва
.данет.","1","1399144960","А че
бля мат разрешен...","6");
INSERT INTO
forum_post
VALUES("19","6","27","2","Тыы
Сучка.данет.","6","1399148581","","");
INSERT
INTO forum_post
VALUES("20","6","27","2",".данет.","1","1399184576","","");



DROP
TABLE IF EXISTS `forum_razdel`;

CREATE TABLE `forum_razdel` (
  `id`
int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(244) NOT NULL,
  `opis`
varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB
AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

INSERT INTO forum_razdel
VALUES("2","Обзор
движков","Обсуждаем разные
cms");
INSERT INTO forum_razdel
VALUES("3","Рынок","Купля и
продажа скриптов, оценка сайтов.");
INSERT
INTO forum_razdel
VALUES("4","Wap-мастер","Разная
помощь по языкам");
INSERT INTO forum_razdel
VALUES("5","Наш сайт","Все о нашем
сайте");
INSERT INTO forum_razdel
VALUES("6","Общение","Общение,
знакомства.");



DROP TABLE IF EXISTS `forum_tema`;

CREATE
TABLE `forum_tema` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `razdel`
int(11) NOT NULL,
  `kat` int(11) NOT NULL,
  `text` varchar(244) NOT
NULL,
  `name` varchar(244) NOT NULL,
  `us` varchar(255) NOT NULL,
 
`time` varchar(255) NOT NULL,
  `status` int(11) NOT NULL,
  `up`
varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB
AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

INSERT INTO forum_tema
VALUES("2","6","27","Топ тема
общения! Общаемся, знакомимся и т.д.\r\nМат
разрешен.\r\nФлуд разрешен.\r\nОффтоп
разрешен.\r\nРеклама запрещена.","Топ
|
Общение","1","1399141992","0","1399184576");
INSERT
INTO forum_tema
VALUES("3","6","27","ТоП тема
приколов. Оставляем разные скрины с
приколами.","Топ |
Приколы","1","1399142290","0","1399142290");



DROP
TABLE IF EXISTS `forum_zaklad`;

CREATE TABLE `forum_zaklad` (
  `id`
int(11) NOT NULL AUTO_INCREMENT,
  `tema` varchar(244) NOT NULL,
  `us`
varchar(244) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB
AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS
`guest`;

CREATE TABLE `guest` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
 
`msg` text NOT NULL,
  `avtor` varchar(244) NOT NULL,
  `time` varchar(244)
NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT
CHARSET=utf8;

INSERT INTO guest VALUES("5","[php] Тест
bb кодов [/php]","1","1399202068");



DROP
TABLE IF EXISTS `jalob_ba`;

CREATE TABLE `jalob_ba` (
  `id` int(11) NOT
NULL AUTO_INCREMENT,
  `about` text NOT NULL,
  `avtor` varchar(244) NOT
NULL,
  `komy` varchar(244) NOT NULL,
  `time` varchar(244) NOT NULL,
 
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT
CHARSET=utf8;

INSERT INTO jalob_ba
VALUES("1","сас","6","1","1399128836");



DROP
TABLE IF EXISTS `lenta`;

CREATE TABLE `lenta` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `text` text NOT NULL,
  `kto` varchar(100) NOT NULL,
 
`komy` varchar(100) NOT NULL,
  `time` varchar(100) NOT NULL,
  `readlen`
varchar(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8
DEFAULT CHARSET=utf8;

INSERT INTO lenta
VALUES("1","написал в
вашей[url=http://wap-masterok.tk/forum/tema1?selection=top]теме[/url]","3","1","1398959731","1");
INSERT
INTO lenta VALUES("2","написал в
вашей[url=http://wap-masterok.tk/forum/tema1?selection=top]теме[/url]","2","1","1398962828","1");
INSERT
INTO lenta VALUES("3","Повысил вашу
[url=http://wap-masterok.tk/reputation6?selection=top]репутацию[/url]","1","6","1399125684","1");
INSERT
INTO lenta VALUES("4","написал в
вашей[url=http://www.wap-masterok.tk/forum/tema2?selection=top]теме[/url]","6","1","1399144304","1");
INSERT
INTO lenta VALUES("5","написал в
вашей[url=http://www.wap-masterok.tk/forum/tema2?selection=top]теме[/url]","6","1","1399144453","1");
INSERT
INTO lenta VALUES("6","процитировал ваш
пост[url=http://www.wap-masterok.tk/forum/tema2?selection=top] в
теме[/url]","1","6","1399144960","1");
INSERT
INTO lenta VALUES("7","написал в
вашей[url=http://www.wap-masterok.tk/forum/tema2?selection=top]теме[/url]","6","1","1399148581","1");



DROP
TABLE IF EXISTS `lib_razdel`;

CREATE TABLE `lib_razdel` (
  `id` int(11)
NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  `opis`
varchar(244) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM
AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

INSERT INTO lib_razdel
VALUES("3","Куски
кодов","Полезные куски
кодов");



DROP TABLE IF EXISTS `lib_stat`;

CREATE TABLE
`lib_stat` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `razdel` int(11) NOT
NULL,
  `name` varchar(100) DEFAULT NULL,
  `opis` varchar(244) NOT NULL,
 
`meta` varchar(100) NOT NULL,
  `files` varchar(255) NOT NULL,
  PRIMARY
KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS
`load_com`;

CREATE TABLE `load_com` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `time` varchar(244) NOT NULL,
  `msg` text NOT NULL,
 
`avtor` int(244) NOT NULL,
  `avtorlogin` varchar(244) NOT NULL,
  `file`
varchar(244) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT
CHARSET=utf8;




DROP TABLE IF EXISTS `load_dir`;

CREATE TABLE `load_dir`
(
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_dir` int(11) NOT NULL
DEFAULT '0',
  `url` text,
  `name` varchar(100) DEFAULT NULL,
  `icon`
varchar(244) NOT NULL,
  `files` varchar(1) NOT NULL,
  PRIMARY KEY
(`id`)
) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=utf8;

INSERT INTO
load_dir
VALUES("1","0","0","Скрипты","files_1719_5658_rekl.png","0");
INSERT
INTO load_dir
VALUES("3","1","0/1","DCMS","files_1702_1297_rekl.png","1");
INSERT
INTO load_dir
VALUES("4","0","0","Дизайны","files_1488_4837_lol.png","0");
INSERT
INTO load_dir
VALUES("5","1","0/1","JohnCms","files_1339_5543_repa.png","1");
INSERT
INTO load_dir
VALUES("6","1","0/1","Rotor
CMS","files_5640_2115_repa.png","1");
INSERT INTO
load_dir
VALUES("7","1","0/1","Модули","files_4010_1720_repa.png","1");
INSERT
INTO load_dir
VALUES("8","1","0/1","Движки","files_3705_2429_repa.png","1");
INSERT
INTO load_dir
VALUES("9","1","0/1","Игры","files_1916_4836_repa.png","1");
INSERT
INTO load_dir
VALUES("10","1","0/1","Топы","files_2137_4931_repa.png","1");
INSERT
INTO load_dir
VALUES("11","1","0/1","Блоги","files_1355_4221_repa.png","1");
INSERT
INTO load_dir
VALUES("12","1","0/1","Форумы","files_2332_3987_repa.png","1");
INSERT
INTO load_dir
VALUES("13","4","0/4","Под
DCMS","files_4064_2174_repa.png","1");
INSERT INTO
load_dir
VALUES("14","4","0/4","Шаблоны","files_3738_5231_repa.png","1");
INSERT
INTO load_dir
VALUES("15","4","0/4","Другие","files_5635_5629_repa.png","1");
INSERT
INTO load_dir
VALUES("16","4","0/4","Графика","files_3397_3219_repa.png","1");



DROP
TABLE IF EXISTS `load_file`;

CREATE TABLE `load_file` (
  `id` int(11) NOT
NULL AUTO_INCREMENT,
  `id_dir` int(11) NOT NULL,
  `name` varchar(100)
DEFAULT NULL,
  `url` text,
  `time` int(11) NOT NULL,
  `avtor`
varchar(25) NOT NULL,
  `format` varchar(244) NOT NULL,
  `about` text NOT
NULL,
  `files` varchar(244) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM
AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

INSERT INTO load_file
VALUES("1","3","Смена
ника","0/1/3","1398963364","1","zip","Мод
не новый (зделал для новичков), я просто
изменил оплату из 100 на 30
монет.","files_2746_1894_nick.zip");



DROP TABLE IF
EXISTS `load_reit`;

CREATE TABLE `load_reit` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `file` varchar(244) NOT NULL,
  `r` varchar(244) NOT
NULL,
  `kto` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB
AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

INSERT INTO load_reit
VALUES("1","1","1","6");



DROP
TABLE IF EXISTS `message`;

CREATE TABLE `message` (
  `id` int(11) NOT
NULL AUTO_INCREMENT,
  `kto` varchar(244) NOT NULL,
  `komy` varchar(244)
NOT NULL,
  `text` text NOT NULL,
  `time` varchar(244) NOT NULL,
 
`readlen` varchar(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB
AUTO_INCREMENT=33 DEFAULT CHARSET=utf8;

INSERT INTO message
VALUES("1","2","1","Приветттттт
ето тест","1398951924","1");
INSERT INTO
message
VALUES("2","3","1","Привет..","1398959459","1");
INSERT
INTO message
VALUES("3","1","3","Чувак
здорова! Если че то я сайт только сделал и
ничего хорошего на нем нету пока! Ты
пришел из
статка?!","1398959489","1");
INSERT INTO
message VALUES("4","3","1","Я
пришёл из коталога, моего лудшего друга я
активировал модернизацию твоего
сайта.","1398959664","1");
INSERT INTO
message
VALUES("5","1","3","Аааа","1398959795","1");
INSERT
INTO message VALUES("6","3","1","Я
уже понял что он новый сайт.. Тебе скока
лет?","1398959902","1");
INSERT INTO message
VALUES("7","1","3","15, а
тебе?!","1398959931","1");
INSERT INTO message
VALUES("8","3","1","Ну пока что
ли?","1398959999","1");
INSERT INTO message
VALUES("9","1","3","Пока...","1398960045","1");
INSERT
INTO message VALUES("10","3","1","Мне
16лет! Если захочешь меня найти, вот
сайтовый сервис, wm-classic.lark.ru на пишешь в
гостевую если я тебе
нужен.","1398960119","1");
INSERT INTO
message VALUES("11","1","3","Okay! php
хорошо
знаешь?!","1398960253","1");
INSERT INTO
message VALUES("12","3","1","На
4","1398960528","1");
INSERT INTO message
VALUES("13","1","3","Из
5?","1398960599","1");
INSERT INTO message
VALUES("14","3","1","Да) всё
больше не могу тут сидить. Заходи в
сайтовый
сервис","1398960811","1");
INSERT INTO
message
VALUES("15","1","2","drgerge","1398962807","1");
INSERT
INTO message VALUES("16","1","5","Ты
тут?!","1399031281","1");
INSERT INTO message
VALUES("17","5","1","Yes","1399054535","1");
INSERT
INTO message
VALUES("18","5","6","Здраствуйте,я
могу вам чем то
помогти?","1399055013","1");
INSERT INTO
message
VALUES("19","5","6","*Помочь","1399055109","1");
INSERT
INTO message
VALUES("20","6","5","Чем?","1399055244","1");
INSERT
INTO message
VALUES("21","5","6","Незнаю Вам
помощь не
нужна?","1399055383","1");
INSERT INTO
message VALUES("22","6","5","Нет
конечно","1399056262","1");
INSERT INTO
message
VALUES("23","5","1","Привет","1399117099","1");
INSERT
INTO message
VALUES("24","1","5","Здорова...","1399117876","1");
INSERT
INTO message
VALUES("25","1","6","Чего
делаешь?!","1399140484","1");
INSERT INTO
message VALUES("26","6","1","С
бабой сасус","1399140933","1");
INSERT
INTO message VALUES("27","1","6",":D
:D","1399140980","1");
INSERT INTO message
VALUES("28","7","1","А чо
своего логотипа придумать
несмог?","1399146951","1");
INSERT INTO
message VALUES("29","1","7","Был бы
с пк сделал
бы","1399147101","1");
INSERT INTO message
VALUES("30","5","1","чё Всё
время Офф","1399149555","1");
INSERT INTO
message VALUES("31","1","5","Это ты
все время
офф","1399150280","1");
INSERT INTO message
VALUES("32","5","1","Нехую
подобного я всё время он просто я на
других сайтах через время захожу сюда
вижу ты офф и ухожу и так
обратно","1399151645","1");



DROP TABLE
IF EXISTS `message_c`;

CREATE TABLE `message_c` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `kto` varchar(244) NOT NULL,
  `kogo` varchar(244) NOT
NULL,
  `time` varchar(244) NOT NULL,
  `ignor` varchar(1) NOT NULL,
 
`posl_time` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB
AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;

INSERT INTO message_c
VALUES("1","2","1","1398951917","","1398962807");
INSERT
INTO message_c
VALUES("2","1","2","1398951917","","1398962807");
INSERT
INTO message_c
VALUES("3","3","1","1398959449","","1398960811");
INSERT
INTO message_c
VALUES("4","1","3","1398959449","","1398960811");
INSERT
INTO message_c
VALUES("5","1","5","1399031277","","1399151645");
INSERT
INTO message_c
VALUES("6","5","1","1399031277","","1399151645");
INSERT
INTO message_c
VALUES("7","5","6","1399054975","","1399056262");
INSERT
INTO message_c
VALUES("8","6","5","1399054975","","1399056262");
INSERT
INTO message_c
VALUES("9","1","6","1399117637","0","1399140980");
INSERT
INTO message_c
VALUES("10","6","1","1399117637","","1399140980");
INSERT
INTO message_c
VALUES("11","7","1","1399146913","","1399147101");
INSERT
INTO message_c
VALUES("12","1","7","1399146913","","1399147101");



DROP
TABLE IF EXISTS `message_save`;

CREATE TABLE `message_save` (
  `id`
int(11) NOT NULL AUTO_INCREMENT,
  `text` text NOT NULL,
  `kto`
varchar(244) NOT NULL,
  `ktoavtor` varchar(244) NOT NULL,
  `uid`
varchar(244) NOT NULL,
  `time` varchar(244) NOT NULL,
  PRIMARY KEY
(`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS
`news`;

CREATE TABLE `news` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
 
`text` text NOT NULL,
  `avtor` varchar(244) NOT NULL,
  `time`
varchar(244) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB
AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

INSERT INTO news
VALUES("2","Новостей пока
нет!","1","1398791694");



DROP TABLE IF
EXISTS `news_com`;

CREATE TABLE `news_com` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `time` varchar(244) NOT NULL,
  `msg` text NOT NULL,
 
`avtor` int(244) NOT NULL,
  `avtorlogin` varchar(244) NOT NULL,
  `news`
varchar(244) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT
CHARSET=utf8;




DROP TABLE IF EXISTS `photo_files`;

CREATE TABLE
`photo_files` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name`
varchar(255) NOT NULL,
  `opis` varchar(100) DEFAULT NULL,
  `us`
varchar(244) NOT NULL,
  `time` varchar(100) NOT NULL,
  `files`
varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8;




DROP TABLE IF EXISTS `repa_user`;

CREATE TABLE
`repa_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `text` text NOT
NULL,
  `kto` varchar(244) NOT NULL,
  `komy` varchar(244) NOT NULL,
 
`time` varchar(244) NOT NULL,
  `repa` varchar(11) NOT NULL,
  PRIMARY KEY
(`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

INSERT INTO
repa_user
VALUES("1","+++","1","6","1399125684","+");



DROP
TABLE IF EXISTS `rules`;

CREATE TABLE `rules` (
  `site` text NOT NULL,
 
`forum` text NOT NULL,
  `chat` text NOT NULL
) ENGINE=InnoDB DEFAULT
CHARSET=utf8;

INSERT INTO rules VALUES("Правил пока
нет!","Правил пока нет!","Правил
пока нет!");



DROP TABLE IF EXISTS `settings`;

CREATE TABLE
`settings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `key` text NOT
NULL,
  `des` text NOT NULL,
  `cop` varchar(50) NOT NULL,
  PRIMARY KEY
(`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

INSERT INTO
settings VALUES("1","wm | site","wm |
site","by ProGrammep");



DROP TABLE IF EXISTS
`smile`;

CREATE TABLE `smile` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
 
`name` varchar(244) NOT NULL,
  `icon` varchar(244) NOT NULL,
  `papka`
varchar(30) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB
AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;

INSERT INTO smile
VALUES("1",".пох.","pox.png","1");
INSERT
INTO smile
VALUES("2",".данет.","files_4094_2628_nunet.png","2");
INSERT
INTO smile
VALUES("3",".лис.","files_5628_5411_profiwm_ru_lis.png","2");
INSERT
INTO smile
VALUES("4",".кайф.","files_3051_2210_profiwm_ru_er.png","2");
INSERT
INTO smile
VALUES("5",".а?.","files_2336_2857_profiwm_ru_danu5.png","2");
INSERT
INTO smile
VALUES("6",".круть.","files_3594_1306_profiwm_ru_neploho.png","2");
INSERT
INTO smile
VALUES("7",".шта.","files_2292_3760_profiwm_ru_wto.png","2");
INSERT
INTO smile
VALUES("8",".лох.","files_2270_2105_profiwm_ru_you.png","2");
INSERT
INTO smile
VALUES("9",".зол.","files_1717_2705_profiwm_ru_zol2.png","2");
INSERT
INTO smile
VALUES("10",".зол2.","files_2567_1339_zol_profiwm_ru.png","2");
INSERT
INTO smile
VALUES("11",".лох2.","files_2745_3851_рол.png","2");



DROP
TABLE IF EXISTS `smile_p`;

CREATE TABLE `smile_p` (
  `id` int(11) NOT
NULL AUTO_INCREMENT,
  `name` varchar(30) NOT NULL,
  PRIMARY KEY (`id`)
)
ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

INSERT INTO smile_p
VALUES("1","Разные");
INSERT INTO smile_p
VALUES("2","Приколы");



DROP TABLE IF EXISTS
`stena`;

CREATE TABLE `stena` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
 
`msg` text NOT NULL,
  `avtor` varchar(244) NOT NULL,
  `ukogo`
varchar(244) NOT NULL,
  `time` varchar(244) NOT NULL,
  PRIMARY KEY
(`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

INSERT INTO
stena
VALUES("1","Хай","6","6","1399054482");



DROP
TABLE IF EXISTS `users`;

CREATE TABLE `users` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `login` varchar(20) NOT NULL,
  `pass` varchar(255) NOT
NULL,
  `sex` varchar(1) NOT NULL,
  `name` varchar(30) NOT NULL,
  `email`
varchar(40) NOT NULL,
  `strana` varchar(255) NOT NULL,
  `gorod`
varchar(255) NOT NULL,
  `osebe` varchar(555) NOT NULL,
  `datareg`
varchar(255) NOT NULL,
  `level` varchar(1) NOT NULL,
  `browser`
varchar(250) NOT NULL,
  `ip` varchar(250) NOT NULL,
  `viz` varchar(250)
NOT NULL,
  `online` varchar(250) NOT NULL,
  `gde` varchar(255) NOT NULL,

 `xstatus` varchar(255) NOT NULL,
  `color_nick` varchar(255) NOT NULL,
 
`max` int(30) NOT NULL DEFAULT '10',
  `avatar` varchar(255) NOT NULL,
 
`wmid` varchar(50) NOT NULL,
  `site` varchar(50) NOT NULL,
  PRIMARY KEY
(`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

INSERT INTO
users
VALUES("1","ProGrammep","c56d0e9a7ccec67b4ea131655038d604","1","Макс","locoste99@mail.ru","Россия","Кострома","О
себе оставлю при
себе...","1398709414","3","Mozilla/5.0
(Windows NT 5.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/35.0.1916.27
Safari/537.36 OPR/22.0.1471.8 (Edition
Developer)","109.161.0.144","1399230284","28330","/","7","008000","20","files_2869_4901_4476.jpg","618735952796","Obschays.Ru");
INSERT
INTO users
VALUES("2","test","c56d0e9a7ccec67b4ea131655038d604","1","Test","nickhere@mail.ru","","","","1398951888","0","Mozilla/5.0
(Windows NT 5.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/35.0.1916.27
Safari/537.36 OPR/22.0.1471.8 (Edition
Developer)","109.161.7.102","1399184561","126","/exit.php?okda","","","10","","","");
INSERT
INTO users
VALUES("3","CLASSIC","7e10bd78661b24aa2e37a840aba0e759","1","Ринат","wm_classic@spaces.ru","Россия","Томск","Оставлю
при
себе..","1398959331","0","Opera/9.80
(J2ME/MIDP; Opera Mini/4.2.13057/34.1944; U; ru) Presto/2.8.119
Version/11.10","82.145.220.117","1399175904","1028","/","5","0000FF","10","","","");
INSERT
INTO users
VALUES("4","Tera","cf6ebf3453bf1877ee3f1dce7bd1ec19","1","Влад","dom2.net.i.molodca@mail.ru","","","","1398971392","0","Opera/9.80
(J2ME/MIDP; Opera Mini/7.1.32052/34.1944; U; ru) Presto/2.8.119
Version/11.10","82.145.220.126","1398971562","158","/","","","10","","","");
INSERT
INTO users
VALUES("5","DarkWM","c2d07c613be62f046efd321bd17a79c7","1","Александр","Dark_WM@mail.ru","","","","1399027798","0","Mozilla/5.0
(Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko)
Chrome/33.0.1750.154 Safari/537.36
OPR/20.0.1387.91","37.73.250.110","1399221814","2041","/?","12","","10","","","");
INSERT
INTO users
VALUES("6","ReMiKs","c56d0e9a7ccec67b4ea131655038d604","1","Женя","Anion1997@mail.ru","Россия","К-а","(\'\'_\'\')","1399054076","0","Opera/9.80
(J2ME/MIDP; Opera Mini/4.2.13918/34.1944; U; ru) Presto/2.8.119
Version/11.10","82.145.221.30","1399229302","2852","/online.php","1","008000","10","files_2493_5480_fSHe80JNtlY.jpg","300609884014","nah.ru");
INSERT
INTO users
VALUES("7","poma","e6ca2d9b129535cfa72231cef5f77f58","1","roma","programmer98@spaces.ru","","","","1399146836","0","Opera/9.80
(J2ME/MIDP; Opera Mini/7.0.30567/34.1944; U; ru) Presto/2.8.119
Version/11.10","82.145.211.134","1399167637","133","/mes/dialog1","","","10","","","");
INSERT
INTO users
VALUES("8","Maxwell","ae3db9e7cf85cd65aaa5de1746512e0b","1","Макс","gamelife94@bk.ru","","","","1399223716","0","Nokia5130c-2/2.0
(07.95) Profile/MIDP-2.1 Configuration/CLDC-1.1 Mozilla/5.0 (Java; U; ru;
nokia5130c-2) UCBrowser8.3.0.154/69/444/UCWEB Mobile
UNTRUSTED/1.0","195.189.123.11","1399223725","","/","","","10","","","");