Файл: bloodlands.pw/db_backup-02.12.14_06:57-db1417268946.sql
Строк: 450
DROP TABLE IF EXISTS `adm_logs`;
CREATE TABLE `adm_logs` (
`id` int(11)
NOT NULL AUTO_INCREMENT,
`user` char(15) NOT NULL,
`who` int(11) NOT
NULL DEFAULT '0',
`type` char(10) NOT NULL,
`date` int(11) NOT NULL
DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT
CHARSET=utf8;
DROP TABLE IF EXISTS `albums`;
CREATE TABLE `albums` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user` int(11) NOT NULL DEFAULT
'0',
`parol` int(11) NOT NULL DEFAULT '0',
`friend_looks` smallint(2)
NOT NULL DEFAULT '0',
`path` char(100) NOT NULL,
`name` char(50) NOT
NULL,
`type` char(1) NOT NULL,
`cat` int(11) NOT NULL DEFAULT '0',
`date` int(11) NOT NULL DEFAULT '0',
`rotate` int(11) NOT NULL DEFAULT
'0',
`friend_comm` smallint(2) NOT NULL DEFAULT '0',
`last` int(11) NOT
NULL DEFAULT '0',
`cover` smallint(1) NOT NULL DEFAULT '0',
`block`
smallint(1) NOT NULL DEFAULT '0',
`who_block` int(11) NOT NULL DEFAULT
'0',
`why_block` char(50) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM
AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS
`bannlist`;
CREATE TABLE `bannlist` (
`id` int(11) NOT NULL
AUTO_INCREMENT,
`ip` char(100) NOT NULL DEFAULT '0',
`who` int(11) NOT
NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM
AUTO_INCREMENT=9742178 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS
`blog`;
CREATE TABLE `blog` (
`blog_id` int(11) NOT NULL
AUTO_INCREMENT,
`user` text,
`blog_title` text,
`blog_content` text,
PRIMARY KEY (`blog_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
DROP
TABLE IF EXISTS `blog_files`;
CREATE TABLE `blog_files` (
`id` int(11)
NOT NULL AUTO_INCREMENT,
`id_blog` int(11) NOT NULL,
`name` varchar(64)
DEFAULT NULL,
`ras` varchar(32) NOT NULL,
`size` int(11) NOT NULL,
`type` varchar(32) NOT NULL,
`count` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `id_post` (`id_blog`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8;
DROP TABLE IF EXISTS `blog_img`;
CREATE TABLE `blog_img`
(
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_blog` int(11) NOT NULL,
`name` varchar(64) DEFAULT NULL,
`ras` varchar(32) NOT NULL,
`size`
int(11) NOT NULL,
`type` varchar(32) NOT NULL,
PRIMARY KEY (`id`),
KEY `id_post` (`id_blog`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
DROP
TABLE IF EXISTS `blog_komm`;
CREATE TABLE `blog_komm` (
`id` int(11) NOT
NULL AUTO_INCREMENT,
`id_user` int(11) NOT NULL,
`id_blog` varchar(50)
NOT NULL,
`msg` varchar(1024) NOT NULL,
`time` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
DROP TABLE IF
EXISTS `blog_list`;
CREATE TABLE `blog_list` (
`id` int(11) NOT NULL
AUTO_INCREMENT,
`id_user` int(11) NOT NULL,
`name` varchar(50) NOT
NULL,
`msg` varchar(5000) NOT NULL,
`time` int(11) NOT NULL,
`privat`
int(11) NOT NULL,
`count` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY
(`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
DROP
TABLE IF EXISTS `cat_smiles`;
CREATE TABLE `cat_smiles` (
`id` int(11)
NOT NULL AUTO_INCREMENT,
`name` char(20) NOT NULL DEFAULT '0',
PRIMARY
KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;
DROP
TABLE IF EXISTS `dialog`;
CREATE TABLE `dialog` (
`id` int(11) NOT NULL
AUTO_INCREMENT,
`message` text NOT NULL,
`type` char(10) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=74 DEFAULT
CHARSET=utf8;
INSERT INTO dialog
VALUES("65","Привет!","hello");
INSERT
INTO dialog VALUES("66","Обращайтесь к
Администратору!","quest");
INSERT INTO dialog
VALUES("67","ая-яй-яй, не
хорошо!!!","mat");
INSERT INTO dialog
VALUES("68","Ну и что
такого?","robot");
INSERT INTO dialog
VALUES("69","спасибо!)","love");
INSERT
INTO dialog VALUES("70","не
когда!","talk");
INSERT INTO dialog
VALUES("71","А тебя?","name");
INSERT
INTO dialog VALUES("72","Не за
что!","sps");
INSERT INTO dialog
VALUES("73","Не
флудим!","fuck");
DROP TABLE IF EXISTS
`f_message`;
CREATE TABLE `f_message` (
`id` int(11) NOT NULL
AUTO_INCREMENT,
`tid` int(11) NOT NULL DEFAULT '0',
`msg` text NOT
NULL,
`user` int(11) NOT NULL DEFAULT '0',
`whoedit` int(11) NOT NULL
DEFAULT '0',
`path` char(255) NOT NULL DEFAULT '0',
`date` char(20) NOT
NULL,
`podforum` int(11) NOT NULL DEFAULT '0',
`time` int(11) NOT NULL
DEFAULT '0',
`best` tinyint(1) NOT NULL DEFAULT '0',
`worse` tinyint(1)
NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM
AUTO_INCREMENT=55 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS
`f_pod`;
CREATE TABLE `f_pod` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`pid` int(11) NOT NULL DEFAULT '0',
`name` char(50) NOT NULL DEFAULT '',
`time` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM
AUTO_INCREMENT=89 DEFAULT CHARSET=utf8;
INSERT INTO f_pod
VALUES("83","20","Скрипты/Поиск/Продажа","1417281872");
INSERT
INTO f_pod
VALUES("84","20","Графика","1417281891");
INSERT
INTO f_pod
VALUES("85","20","Дизайны/Стили","1417281906");
INSERT
INTO f_pod VALUES("86","21","Помощь по
css","1417282049");
INSERT INTO f_pod
VALUES("87","21","Помощь по
установкам","1417282065");
INSERT INTO f_pod
VALUES("88","22","Куплю/Продам","1417282113");
DROP
TABLE IF EXISTS `f_razdel`;
CREATE TABLE `f_razdel` (
`id` int(11) NOT
NULL AUTO_INCREMENT,
`name` char(50) NOT NULL DEFAULT '',
`ico` char(6)
NOT NULL,
`opis` char(50) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
)
ENGINE=MyISAM AUTO_INCREMENT=23 DEFAULT CHARSET=utf8;
INSERT INTO f_razdel
VALUES("20","Скрипты/Графика/Дизайн","","вап
мастеру");
INSERT INTO f_razdel
VALUES("21","Новичкам","","вопросы
новичков");
INSERT INTO f_razdel
VALUES("22","Продажа/Покупка","","прочее");
DROP
TABLE IF EXISTS `f_them`;
CREATE TABLE `f_them` (
`id` int(11) NOT NULL
AUTO_INCREMENT,
`rid` int(11) NOT NULL DEFAULT '0',
`name` char(255)
NOT NULL DEFAULT '',
`author` int(11) NOT NULL DEFAULT '0',
`close`
smallint(2) NOT NULL DEFAULT '0',
`whoedit` int(11) NOT NULL DEFAULT
'0',
`date` int(11) NOT NULL DEFAULT '0',
`firstpost` text NOT NULL,
`fix` smallint(2) NOT NULL DEFAULT '0',
`razdel_id` int(11) NOT NULL
DEFAULT '0',
`last` int(11) NOT NULL DEFAULT '0',
`quest` char(255) NOT
NULL,
`var1` char(20) NOT NULL,
`var2` char(20) NOT NULL,
`var3`
char(20) NOT NULL,
`var4` char(20) NOT NULL,
PRIMARY KEY (`id`)
)
ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=utf8;
INSERT INTO f_them
VALUES("17","87","Набор
модераторов","1","0","0","1417283986","Составляем
анкету и цель работы модератором и
ожидаем
одобрения","1","21","1417283986","","","","","");
DROP
TABLE IF EXISTS `f_votes`;
CREATE TABLE `f_votes` (
`id` int(11) NOT
NULL AUTO_INCREMENT,
`user` int(11) NOT NULL DEFAULT '0',
`them`
int(11) NOT NULL DEFAULT '0',
`var` smallint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT
CHARSET=utf8;
DROP TABLE IF EXISTS `fo_cat`;
CREATE TABLE `fo_cat` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` char(30) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=20 DEFAULT
CHARSET=utf8;
INSERT INTO fo_cat
VALUES("18","Скрипты");
INSERT INTO fo_cat
VALUES("19","Графика");
DROP TABLE IF EXISTS
`fo_files`;
CREATE TABLE `fo_files` (
`id` int(11) NOT NULL
AUTO_INCREMENT,
`url` char(100) NOT NULL,
`time` int(11) NOT NULL,
`clicks` int(11) NOT NULL DEFAULT '0',
`author` int(11) NOT NULL,
`title` char(100) NOT NULL,
`info` text NOT NULL,
`parol` char(10)
DEFAULT NULL,
`moder` smallint(2) NOT NULL DEFAULT '0',
`rid` int(11)
NOT NULL DEFAULT '0',
`cat` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY
(`id`)
) ENGINE=MyISAM AUTO_INCREMENT=239 DEFAULT CHARSET=utf8;
INSERT
INTO fo_files
VALUES("237","files/44110masteram_us_4664_cron.zip","1417454745","0","1","ElementForce","Просили
добавить","0","0","18","121");
INSERT
INTO fo_files
VALUES("238","files/23890masteram_us_1501_arms_(2).zip","1417454853","0","1","CounterStrike","Онлайн
игра","0","0","18","121");
DROP
TABLE IF EXISTS `fo_komm`;
CREATE TABLE `fo_komm` (
`id` int(11) NOT
NULL AUTO_INCREMENT,
`user` int(11) NOT NULL DEFAULT '0',
`uid` int(11)
NOT NULL DEFAULT '0',
`msg` text NOT NULL,
`date` int(11) NOT NULL
DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT
CHARSET=utf8;
DROP TABLE IF EXISTS `fo_pap`;
CREATE TABLE `fo_pap` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`pid` int(11) NOT NULL DEFAULT
'0',
`title` char(50) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM
AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
INSERT INTO fo_pap
VALUES("1","61","Колхоз / Для
него");
DROP TABLE IF EXISTS `fo_pod`;
CREATE TABLE `fo_pod`
(
`id` int(11) NOT NULL AUTO_INCREMENT,
`cid` int(11) NOT NULL DEFAULT
'0',
`title` char(50) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM
AUTO_INCREMENT=124 DEFAULT CHARSET=utf8;
INSERT INTO fo_pod
VALUES("42","9","Aвторизация");
INSERT
INTO fo_pod
VALUES("43","9","Блоги");
INSERT INTO
fo_pod
VALUES("44","9","Фото-галереи");
INSERT
INTO fo_pod
VALUES("45","9","Хостеру");
INSERT
INTO fo_pod VALUES("46","9","Знакомства
и соц.сети");
INSERT INTO fo_pod
VALUES("47","9","Библиотеки");
INSERT
INTO fo_pod
VALUES("48","9","Реклама");
INSERT
INTO fo_pod VALUES("49","9","Партнерки и
баннерки");
INSERT INTO fo_pod
VALUES("50","9","Форумы");
INSERT INTO
fo_pod VALUES("51","9","Чаты");
INSERT
INTO fo_pod VALUES("52","9","Гостевые
книги");
INSERT INTO fo_pod
VALUES("53","9","Загрузки");
INSERT
INTO fo_pod
VALUES("54","9","Wap-мастеру");
INSERT
INTO fo_pod
VALUES("55","9","Каталоги");
INSERT
INTO fo_pod
VALUES("56","9","Топы");
INSERT INTO
fo_pod
VALUES("57","9","Голосования");
INSERT
INTO fo_pod VALUES("58","9","Движки и
мoдули");
INSERT INTO fo_pod
VALUES("59","9","Клик-клубы");
INSERT
INTO fo_pod VALUES("60","9","Витрины и
магазины");
INSERT INTO fo_pod
VALUES("61","9","Онлайн
игры");
INSERT INTO fo_pod
VALUES("62","9","Защита");
INSERT INTO
fo_pod
VALUES("63","9","Информеры");
INSERT
INTO fo_pod
VALUES("64","9","Грабберы");
INSERT
INTO fo_pod
VALUES("65","9","Сервисы");
INSERT
INTO fo_pod
VALUES("66","9","Рaзвлeчeния");
INSERT
INTO fo_pod
VALUES("67","9","Paзнoe");
INSERT INTO
fo_pod VALUES("68","9","phpBB-WAP");
INSERT
INTO fo_pod
VALUES("69","9","Новости");
INSERT
INTO fo_pod
VALUES("70","9","Фейки");
INSERT INTO
fo_pod VALUES("71","10","Для
движков");
INSERT INTO fo_pod
VALUES("73","10","Для phpbb");
INSERT INTO
fo_pod VALUES("76","10","Авторские
шаблоны сайтов");
INSERT INTO fo_pod
VALUES("77","10","WEB Дизaйны");
INSERT
INTO fo_pod
VALUES("78","10","Разное");
INSERT INTO
fo_pod VALUES("79","11","Apache");
INSERT
INTO fo_pod VALUES("81","11","php");
INSERT
INTO fo_pod VALUES("82","11","html");
INSERT
INTO fo_pod
VALUES("83","11","JavaScript");
INSERT INTO
fo_pod VALUES("84","11","C,C++,C#");
INSERT
INTO fo_pod
VALUES("85","11","Разное");
INSERT INTO
fo_pod VALUES("86","11","MySQL");
INSERT INTO
fo_pod VALUES("87","11","Java,Ajax");
INSERT
INTO fo_pod VALUES("88","11","Flash");
INSERT
INTO fo_pod VALUES("89","11","CSS");
INSERT
INTO fo_pod VALUES("90","11","xhtml");
INSERT
INTO fo_pod
VALUES("91","11","Wml-xml");
INSERT INTO
fo_pod VALUES("92","11","Dhtml");
INSERT INTO
fo_pod VALUES("93","11","Python");
INSERT
INTO fo_pod VALUES("94","11","Perl");
INSERT
INTO fo_pod VALUES("95","12","Время и
дата");
INSERT INTO fo_pod
VALUES("96","12","Случaйный
элeмeнт");
INSERT INTO fo_pod
VALUES("97","12","Перexoд нa
url");
INSERT INTO fo_pod
VALUES("98","12","Информaция");
INSERT
INTO fo_pod
VALUES("99","12","Дизaйн");
INSERT INTO
fo_pod VALUES("100","12","Paзнoe");
INSERT
INTO fo_pod VALUES("101","12","Курсoр
мышки");
INSERT INTO fo_pod
VALUES("102","12","Сeрвисы");
INSERT
INTO fo_pod
VALUES("103","12","Онлaйн-игры");
INSERT
INTO fo_pod
VALUES("104","12","Эффeкты");
INSERT
INTO fo_pod
VALUES("105","12","Изображения");
INSERT
INTO fo_pod
VALUES("106","13","Картинки");
INSERT
INTO fo_pod
VALUES("107","13","Темы");
INSERT INTO
fo_pod VALUES("108","13","Флэш");
INSERT
INTO fo_pod
VALUES("109","13","Игры");
INSERT INTO
fo_pod
VALUES("110","13","Иконки");
INSERT
INTO fo_pod
VALUES("111","13","Смайлы");
INSERT
INTO fo_pod
VALUES("112","14","Декоративные");
INSERT
INTO fo_pod
VALUES("113","14","Западные");
INSERT
INTO fo_pod
VALUES("114","14","Кириллические");
INSERT
INTO fo_pod VALUES("115","15","Грабберы
на html");
INSERT INTO fo_pod
VALUES("116","15","Движки на
html");
INSERT INTO fo_pod
VALUES("117","16","Для
телефона");
INSERT INTO fo_pod
VALUES("118","16","Для
компьютера");
INSERT INTO fo_pod
VALUES("119","61","Колхоз / Для
него");
INSERT INTO fo_pod
VALUES("120","18","Движки");
INSERT
INTO fo_pod VALUES("121","18","Онлайн
игры");
INSERT INTO fo_pod
VALUES("122","19","Картинки");
INSERT
INTO fo_pod
VALUES("123","19","Дизайны");
DROP
TABLE IF EXISTS `friends`;
CREATE TABLE `friends` (
`id` int(11) NOT
NULL AUTO_INCREMENT,
`user` int(11) NOT NULL DEFAULT '0',
`who` int(11)
NOT NULL DEFAULT '0',
`zajavka` smallint(2) NOT NULL DEFAULT '0',
`group` char(15) NOT NULL,
`friendtext` char(50) NOT NULL,
PRIMARY KEY
(`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
DROP
TABLE IF EXISTS `gazeta_article`;
CREATE TABLE `gazeta_article` (
`id`
int(11) NOT NULL AUTO_INCREMENT,
`uid` int(11) NOT NULL DEFAULT '0',
`content` text NOT NULL,
`path` char(50) NOT NULL,
`date` int(11) NOT
NULL DEFAULT '0',
`author` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY
(`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS
`gazeta_comm`;
CREATE TABLE `gazeta_comm` (
`id` int(11) NOT NULL
AUTO_INCREMENT,
`user` int(11) NOT NULL DEFAULT '0',
`id_new` int(11)
NOT NULL DEFAULT '0',
`date` int(11) NOT NULL,
`msg` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
DROP TABLE IF
EXISTS `gazeta_razdel`;
CREATE TABLE `gazeta_razdel` (
`id` int(11) NOT
NULL AUTO_INCREMENT,
`name` char(50) NOT NULL,
PRIMARY KEY (`id`)
)
ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
DROP TABLE IF
EXISTS `guests`;
CREATE TABLE `guests` (
`ip` bigint(20) NOT NULL,
`ua` char(32) NOT NULL,
`date_aut` int(11) NOT NULL,
`date_last`
int(11) NOT NULL,
`url` char(64) NOT NULL,
`pereh` int(11) NOT NULL
DEFAULT '0',
KEY `ip_2` (`ip`,`ua`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8;
INSERT INTO guests
VALUES("3648410101","Mozilla/5.0","1417279481","1417283634","vbitveonline.keo.su","13");
INSERT
INTO guests
VALUES("528572975","Mozilla/5.0","1417289301","1417289301","vbitveonline.keo.su","0");
INSERT
INTO guests
VALUES("1603915303","Mozilla/5.0","1417342989","1417342989","vbitveonline.keo.su","0");
INSERT
INTO guests
VALUES("1603911582","Mozilla/5.0","1417454449","1417454449","bloodlands.pw","0");
INSERT
INTO guests
VALUES("1385290904","Nokia300/5.0","1417454738","1417454738","bloodlands.pw","0");
INSERT
INTO guests
VALUES("3105535078","SAMSUNG-GT-C3312/1.0","1417455165","1417457830","bloodlands.pw","1");
INSERT
INTO guests
VALUES("1385290814","Nokia311/5.0","1417455855","1417455855","bloodlands.pw","0");
INSERT
INTO guests
VALUES("528573405","Mozilla/5.0","1417456169","1417456169","bloodlands.pw","0");
INSERT
INTO guests
VALUES("2834023260","Mozilla/5.0","1417456384","1417456384","bloodlands.pw","0");
INSERT
INTO guests
VALUES("3283974913","NokiaX3-02/5.0","1417456420","1417458758","bloodlands.pw","1");
INSERT
INTO guests
VALUES("1385291195","Nokia300/5.0","1417457627","1417457627","bloodlands.pw","0");
INSERT
INTO guests
VALUES("2366160230","Mozilla/5.0","1417457899","1417488850","bloodlands.pw","21");
INSERT
INTO guests
VALUES("1385290973","Mozilla/5.0","1417457970","1417458416","bloodlands.pw","1");
INSERT
INTO guests
VALUES("1402279174","Mozilla/5.0","1417458341","1417458341","serv-https.bloodlands.pw","0");
INSERT
INTO guests
VALUES("2959876091","Mozilla/5.0","1417458976","1417458976","bloodlands.pw","0");
INSERT
INTO guests
VALUES("3250742477","Mozilla/5.0","1417459044","1417459136","bloodlands.pw","28");
INSERT
INTO guests
VALUES("1385291640","Nokia300/5.0","1417459434","1417459434","bloodlands.pw","0");
INSERT
INTO guests
VALUES("3105535049","Nokia300/5.0","1417461238","1417466727","bloodlands.pw","2");
INSERT
INTO guests
VALUES("93017736","Mozilla/5.0","1417461719","1417461719","bloodlands.pw","0");
INSERT
INTO guests
VALUES("1402285896","Mozilla/5.0","1417462809","1417462822","serv-https.bloodlands.pw","1");
INSERT
INTO guests
VALUES("2834023196","Mozilla/5.0","1417463599","1417463599","bloodlands.pw","0");
INSERT
INTO guests
VALUES("3648410103","Mozilla/5.0","1417464227","1417464388","bloodlands.pw","3");
INSERT
INTO guests
VALUES("625592885","Mozilla/5.0","1417465375","1417465375","serv-https.bloodlands.pw","0");
INSERT
INTO guests
VALUES("2365589837","Opera/9.80","1417465483","1417465483","bloodlands.pw","0");
INSERT
INTO guests
VALUES("1385291101","Nokia5228/50.1.001/sw_","1417465890","1417465890","bloodlands.pw","0");
INSERT
INTO guests
VALUES("1385291101","Mozilla/5.0","1417466124","1417466124","bloodlands.pw","0");
INSERT
INTO guests
VALUES("3283974936","Mozilla/5.0","1417467332","1417467340","bloodlands.pw","1");
INSERT
INTO guests
VALUES("3648409185","Mozilla/5.0","1417467363","1417467537","bloodlands.pw","1");
INSERT
INTO guests
VALUES("1385291628","Mozilla/5.0","1417469468","1417469468","bloodlands.pw","0");
INSERT
INTO guests
VALUES("1385291307","Nokia6267","1417469697","1417469697","bloodlands.pw","0");
INSERT
INTO guests
VALUES("1385291314","Nokia300/5.0","1417471737","1417471737","bloodlands.pw","0");
INSERT
INTO guests
VALUES("1385291306","Nokia300/5.0","1417473546","1417477158","bloodlands.pw","1");
INSERT
INTO guests
VALUES("1385290848","Mozilla/5.0","1417474581","1417474581","bloodlands.pw","0");
INSERT
INTO guests
VALUES("2960900915","Mozilla/5.0","1417476443","1417476443","bloodlands.pw","0");
INSERT
INTO guests
VALUES("3105535017","Mozilla/5.0","1417478192","1417478192","bloodlands.pw","0");
INSERT
INTO guests
VALUES("1385291189","Mozilla/5.0","1417480416","1417480416","bloodlands.pw","0");
INSERT
INTO guests
VALUES("1123635677","Mozilla/5.0","1417486136","1417486136","bloodlands.pw","0");
INSERT
INTO guests
VALUES("1603910705","Mozilla/5.0","1417488890","1417488896","bloodlands.pw","1");
DROP
TABLE IF EXISTS `ignor`;
CREATE TABLE `ignor` (
`id` int(11) NOT NULL
AUTO_INCREMENT,
`user_id` int(11) NOT NULL DEFAULT '0',
`ig_id` int(11)
NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8;
DROP TABLE IF EXISTS `inthem`;
CREATE TABLE `inthem` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`who` int(11) NOT NULL DEFAULT
'0',
`uid` int(11) NOT NULL DEFAULT '0',
`time` int(11) NOT NULL
DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=99908864
DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `koms_foto`;
CREATE TABLE
`koms_foto` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user` int(11) NOT
NULL DEFAULT '0',
`uid` int(11) NOT NULL DEFAULT '0',
`komu` int(11)
NOT NULL DEFAULT '0',
`msg` text NOT NULL,
`date` int(11) NOT NULL
DEFAULT '0',
`album` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS
`koms_note`;
CREATE TABLE `koms_note` (
`id` int(11) NOT NULL
AUTO_INCREMENT,
`user` int(11) NOT NULL DEFAULT '0',
`uid` int(11) NOT
NULL DEFAULT '0',
`msg` text NOT NULL,
`date` char(20) NOT NULL,
`komu` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM
DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `lenta`;
CREATE TABLE
`lenta` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user` int(11) NOT NULL
DEFAULT '0',
`text` text NOT NULL,
`type` char(10) NOT NULL,
`date`
int(11) NOT NULL DEFAULT '0',
`read` tinyint(1) NOT NULL DEFAULT '0',
`uid` char(30) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM
AUTO_INCREMENT=55 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS
`letters`;
CREATE TABLE `letters` (
`id` int(11) NOT NULL
AUTO_INCREMENT,
`who` int(11) NOT NULL DEFAULT '0',
`idwho` int(11) NOT
NULL DEFAULT '0',
`message` blob NOT NULL,
`data` char(20) DEFAULT
'0',
`read` smallint(1) DEFAULT '0',
`mod` char(1) NOT NULL DEFAULT
'',
`save` smallint(1) NOT NULL DEFAULT '0',
`file` char(50) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=163 DEFAULT
CHARSET=utf8;
DROP TABLE IF EXISTS `lib_dir`;
CREATE TABLE `lib_dir`
(
`id` int(11) NOT NULL AUTO_INCREMENT,
`num` int(11) NOT NULL DEFAULT
'0',
`name` varchar(64) NOT NULL,
`dir` varchar(512) NOT NULL DEFAULT
'/',
`dir_osn` varchar(512) DEFAULT '/',
PRIMARY KEY (`id`),
KEY
`num` (`num`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
DROP TABLE IF
EXISTS `lib_files`;
CREATE TABLE `lib_files` (
`id` int(11) NOT NULL
AUTO_INCREMENT,
`id_user` int(11) NOT NULL,
`id_dir` int(11) NOT NULL,
`name` varchar(128) NOT NULL,
`time` int(11) NOT NULL,
`time_last`
int(11) NOT NULL,
`size` int(11) DEFAULT NULL,
`k_loads` int(11) NOT
NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3
DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `loads_f`;
CREATE TABLE
`loads_f` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`url` char(100) NOT
NULL,
`time` int(11) NOT NULL,
`clicks` int(11) NOT NULL DEFAULT '0',
`author` int(11) NOT NULL,
`title` char(100) NOT NULL,
`info` text NOT
NULL,
`cat` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS
`loads_komm`;
CREATE TABLE `loads_komm` (
`id` int(11) NOT NULL
AUTO_INCREMENT,
`user` int(11) NOT NULL DEFAULT '0',
`uid` int(11) NOT
NULL DEFAULT '0',
`msg` text NOT NULL,
`date` int(11) NOT NULL DEFAULT
'0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
DROP
TABLE IF EXISTS `loads_r`;
CREATE TABLE `loads_r` (
`id` int(11) NOT
NULL AUTO_INCREMENT,
`name` char(50) NOT NULL DEFAULT '',
PRIMARY KEY
(`id`)
) ENGINE=MyISAM AUTO_INCREMENT=25 DEFAULT CHARSET=utf8;
INSERT INTO
loads_r VALUES("17","PHP скрипты");
INSERT INTO
loads_r VALUES("18","Дизайны");
INSERT INTO
loads_r VALUES("19","Электронные
книги");
INSERT INTO loads_r
VALUES("20","JavaScript");
INSERT INTO loads_r
VALUES("21","Загрузки в
архивах");
INSERT INTO loads_r
VALUES("22","Шрифты");
INSERT INTO loads_r
VALUES("23","Для wen.ru");
INSERT INTO loads_r
VALUES("24","Программы");
DROP TABLE IF
EXISTS `mark`;
CREATE TABLE `mark` (
`id` int(11) NOT NULL
AUTO_INCREMENT,
`user` int(11) NOT NULL DEFAULT '0',
`who` int(11) NOT
NULL DEFAULT '0',
`uid` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY
(`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS
`message`;
CREATE TABLE `message` (
`id` int(11) NOT NULL
AUTO_INCREMENT,
`who` varchar(10) NOT NULL DEFAULT '',
`msg` text NOT
NULL,
`private` smallint(2) NOT NULL DEFAULT '0',
`time` int(11) NOT
NULL DEFAULT '0',
`komu` int(11) NOT NULL DEFAULT '0',
`user`
varchar(15) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 ROW_FORMAT=DYNAMIC;
DROP TABLE IF EXISTS `news`;
CREATE
TABLE `news` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` char(255)
NOT NULL,
`content` text NOT NULL,
`edit` char(20) NOT NULL,
`look`
int(11) NOT NULL DEFAULT '0',
`date` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT
CHARSET=utf8;
DROP TABLE IF EXISTS `newscomm`;
CREATE TABLE `newscomm`
(
`id` int(11) NOT NULL AUTO_INCREMENT,
`user` int(11) NOT NULL DEFAULT
'0',
`id_new` int(11) NOT NULL DEFAULT '0',
`date` char(20) NOT NULL,
`msg` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=31
DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `rating_files`;
CREATE
TABLE `rating_files` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`who`
int(11) NOT NULL DEFAULT '0',
`like` smallint(1) NOT NULL DEFAULT '0',
`dlike` smallint(1) NOT NULL DEFAULT '0',
`uid` int(11) NOT NULL DEFAULT
'0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=40 DEFAULT
CHARSET=utf8;
DROP TABLE IF EXISTS `rating_foto`;
CREATE TABLE
`rating_foto` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user` int(11)
NOT NULL DEFAULT '0',
`good` int(11) NOT NULL DEFAULT '0',
`bad`
int(11) NOT NULL DEFAULT '0',
`uid` int(11) NOT NULL DEFAULT '0',
`komu` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM
DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `rating_gazeta`;
CREATE
TABLE `rating_gazeta` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`who`
int(11) NOT NULL DEFAULT '0',
`like` smallint(1) NOT NULL DEFAULT '0',
`dlike` smallint(1) NOT NULL DEFAULT '0',
`uid` int(11) NOT NULL DEFAULT
'0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
DROP
TABLE IF EXISTS `rating_hist`;
CREATE TABLE `rating_hist` (
`id` int(11)
NOT NULL AUTO_INCREMENT,
`user` int(11) NOT NULL DEFAULT '0',
`msg`
char(255) NOT NULL,
`val` smallint(1) NOT NULL DEFAULT '0',
`date`
int(11) NOT NULL DEFAULT '0',
`who` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT
CHARSET=utf8;
DROP TABLE IF EXISTS `rating_loads`;
CREATE TABLE
`rating_loads` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`who` int(11)
NOT NULL DEFAULT '0',
`like` smallint(1) NOT NULL DEFAULT '0',
`dlike`
smallint(1) NOT NULL DEFAULT '0',
`uid` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
DROP TABLE IF
EXISTS `rating_news`;
CREATE TABLE `rating_news` (
`id` int(11) NOT NULL
AUTO_INCREMENT,
`who` int(11) NOT NULL DEFAULT '0',
`like` smallint(1)
NOT NULL DEFAULT '0',
`dlike` smallint(1) NOT NULL DEFAULT '0',
`uid`
int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM
AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS
`reklama`;
CREATE TABLE `reklama` (
`id` int(11) NOT NULL
AUTO_INCREMENT,
`link` char(100) NOT NULL,
`name` char(250) NOT NULL,
`look` tinyint(1) NOT NULL DEFAULT '0',
`color` char(10) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8
ROW_FORMAT=DYNAMIC;
DROP TABLE IF EXISTS `setting`;
CREATE TABLE
`setting` (
`ids` int(1) NOT NULL DEFAULT '1',
`open_chat` smallint(1)
NOT NULL DEFAULT '1',
`on_rekl` smallint(1) NOT NULL DEFAULT '0',
`text_rekl` char(50) NOT NULL,
`antimat` smallint(2) NOT NULL DEFAULT
'0',
`fo_moder` smallint(2) NOT NULL DEFAULT '0',
`fo_limit` int(11)
NOT NULL DEFAULT '2048',
PRIMARY KEY (`ids`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8;
INSERT INTO setting
VALUES("1","1","1","[Реклама]","1","0","15");
DROP
TABLE IF EXISTS `smiles`;
CREATE TABLE `smiles` (
`id` int(11) NOT NULL
AUTO_INCREMENT,
`name` char(30) NOT NULL DEFAULT '0',
`path` char(30)
NOT NULL DEFAULT '0',
`cat` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY
(`id`)
) ENGINE=MyISAM AUTO_INCREMENT=55 DEFAULT CHARSET=utf8;
INSERT INTO
smiles
VALUES("6",":-)","smiles/1378610441.gif","12");
INSERT
INTO smiles
VALUES("8",";-)","smiles/1378610504.gif","12");
INSERT
INTO smiles
VALUES("7",":-(","smiles/1378610461.gif","12");
INSERT
INTO smiles
VALUES("9",":-p","smiles/1378610522.gif","12");
INSERT
INTO smiles
VALUES("10","8-)","smiles/1378610531.gif","12");
INSERT
INTO smiles
VALUES("11",":d","smiles/1378610554.gif","12");
INSERT
INTO smiles
VALUES("12",":-[","smiles/1378610571.gif","12");
INSERT
INTO smiles
VALUES("13","=-o","smiles/1378610585.gif","12");
INSERT
INTO smiles
VALUES("14",":-*","smiles/1378610601.gif","12");
INSERT
INTO smiles
VALUES("15","0:-)","smiles/1378610619.gif","12");
INSERT
INTO smiles
VALUES("16",":-x","smiles/1378610640.gif","12");
INSERT
INTO smiles
VALUES("17",":-i","smiles/1378610688.gif","12");
INSERT
INTO smiles
VALUES("18",":-/","smiles/1378610700.gif","12");
INSERT
INTO smiles
VALUES("19","*jokingly*","smiles/1378610711.gif","12");
INSERT
INTO smiles
VALUES("20","*kissed*","smiles/1378610752.gif","12");
INSERT
INTO smiles
VALUES("21","*tired*","smiles/1378610771.gif","12");
INSERT
INTO smiles
VALUES("22","*stop*","smiles/1378610780.gif","12");
INSERT
INTO smiles
VALUES("23","*drink*","smiles/1378610836.gif","12");
INSERT
INTO smiles
VALUES("24","*ban*","smiles/1378610863.gif","12");
INSERT
INTO smiles
VALUES("25","@=","smiles/1378610890.gif","12");
INSERT
INTO smiles
VALUES("26","*help*","smiles/1378610901.gif","12");
INSERT
INTO smiles
VALUES("27","%)","smiles/1378610907.gif","12");
INSERT
INTO smiles
VALUES("28","*ok*","smiles/1378610915.gif","12");
INSERT
INTO smiles
VALUES("29","*wassup*","smiles/1378610924.gif","12");
INSERT
INTO smiles
VALUES("30","*sorry*","smiles/1378610947.gif","12");
INSERT
INTO smiles
VALUES("31","*bravo*","smiles/1378610953.gif","12");
INSERT
INTO smiles
VALUES("32","*rofl*","smiles/1378610965.gif","12");
INSERT
INTO smiles
VALUES("33","*pardon*","smiles/1378610974.gif","12");
INSERT
INTO smiles
VALUES("34","*no*","smiles/1378610982.gif","12");
INSERT
INTO smiles
VALUES("35","*crazy*","smiles/1378610991.gif","12");
INSERT
INTO smiles
VALUES("36","*dance*","smiles/1378611017.gif","12");
INSERT
INTO smiles
VALUES("37","*yahoo*","smiles/1378611047.gif","12");
INSERT
INTO smiles
VALUES("38","*new-pack*","smiles/1378611096.gif","12");
INSERT
INTO smiles
VALUES("39","*tease*","smiles/1378611106.gif","12");
INSERT
INTO smiles
VALUES("40","*saliva*","smiles/1378611111.gif","12");
INSERT
INTO smiles
VALUES("41","*dash*","smiles/1378611123.gif","12");
INSERT
INTO smiles
VALUES("42","*wild*","smiles/1378611134.gif","12");
INSERT
INTO smiles
VALUES("43","*training*","smiles/1378611151.gif","12");
INSERT
INTO smiles
VALUES("44","*focus*","smiles/1378611162.gif","12");
INSERT
INTO smiles
VALUES("45","*hang*","smiles/1378611182.gif","12");
INSERT
INTO smiles
VALUES("46","*danc*","smiles/1378611217.gif","12");
INSERT
INTO smiles
VALUES("47","*dance2*","smiles/1378611237.gif","12");
INSERT
INTO smiles
VALUES("48","*nose*","smiles/1378611274.gif","12");
INSERT
INTO smiles
VALUES("49","*yu*","smiles/1378611285.gif","12");
INSERT
INTO smiles
VALUES("50","*closed*","smiles/1378611291.gif","12");
INSERT
INTO smiles
VALUES("51","*facepalm*","smiles/1378611304.gif","12");
INSERT
INTO smiles
VALUES("52","*flood*","smiles/1378611320.gif","12");
INSERT
INTO smiles
VALUES("53","*гг*","smiles/1378611343.gif","12");
INSERT
INTO smiles
VALUES("54","*morj*","smiles/1378611357.gif","12");
DROP
TABLE IF EXISTS `support`;
CREATE TABLE `support` (
`id` int(11) NOT
NULL AUTO_INCREMENT,
`user` int(11) NOT NULL DEFAULT '0',
`type`
char(10) NOT NULL DEFAULT '',
`name` text NOT NULL,
PRIMARY KEY
(`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS
`support_coms`;
CREATE TABLE `support_coms` (
`id` int(11) NOT NULL
AUTO_INCREMENT,
`user` int(11) NOT NULL DEFAULT '0',
`date` int(11) NOT
NULL DEFAULT '0',
`mes` text NOT NULL,
`uid` int(11) NOT NULL DEFAULT
'0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
DROP
TABLE IF EXISTS `user_group_access`;
CREATE TABLE `user_group_access` (
`id_group` int(10) unsigned NOT NULL,
`id_access` varchar(32) NOT NULL,
KEY `id_group` (`id_group`,`id_access`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8;
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user` char(20) NOT NULL DEFAULT
'',
`pass` char(32) DEFAULT NULL,
`name` char(20) DEFAULT NULL,
`sex`
smallint(1) DEFAULT '2',
`birth` char(10) DEFAULT NULL,
`date` char(10)
DEFAULT NULL,
`avr` smallint(3) NOT NULL DEFAULT '300',
`max`
smallint(2) NOT NULL DEFAULT '10',
`kik` int(20) NOT NULL DEFAULT '0',
`whokik` char(20) NOT NULL DEFAULT '',
`whykik` char(50) NOT NULL DEFAULT
'',
`user_ip` char(20) NOT NULL DEFAULT '',
`user_soft` char(200) NOT
NULL DEFAULT '',
`translit` tinyint(1) NOT NULL DEFAULT '0',
`latuser`
char(30) NOT NULL DEFAULT '',
`onl` int(11) NOT NULL DEFAULT '0',
`room` char(10) NOT NULL DEFAULT '',
`level` int(11) NOT NULL DEFAULT
'0',
`sistem_mes` smallint(2) NOT NULL DEFAULT '1',
`refresh` int(11)
NOT NULL DEFAULT '15',
`city` char(20) NOT NULL,
`avka` smallint(2) NOT
NULL DEFAULT '1',
`date_last` int(11) NOT NULL DEFAULT '0',
`on_time`
int(11) NOT NULL DEFAULT '0',
`mod_reg` smallint(2) NOT NULL DEFAULT
'0',
`img` char(50) NOT NULL,
`color` smallint(3) NOT NULL DEFAULT
'0',
`onp_comments` int(11) NOT NULL DEFAULT '5',
`onp_files` int(11)
NOT NULL DEFAULT '10',
`onp_albums` int(11) NOT NULL DEFAULT '5',
`onp_photos` int(11) NOT NULL DEFAULT '5',
`onp_favs` int(11) NOT NULL
DEFAULT '10',
`onp_themes` int(11) NOT NULL DEFAULT '10',
`onp_privats`
int(11) NOT NULL DEFAULT '5',
`onp_prevs` int(11) NOT NULL DEFAULT '80',
`p_mail` smallint(2) NOT NULL DEFAULT '1',
`p_wall` smallint(2) NOT NULL
DEFAULT '1',
`p_r_wall` smallint(2) NOT NULL DEFAULT '1',
`p_date`
smallint(2) NOT NULL DEFAULT '1',
`p_friends` smallint(2) NOT NULL
DEFAULT '1',
`fr_lenta_files` smallint(2) NOT NULL DEFAULT '1',
`fr_lenta_photos` smallint(2) NOT NULL DEFAULT '1',
`fr_lenta_favs`
smallint(2) NOT NULL DEFAULT '1',
`fr_lenta_friends` smallint(2) NOT NULL
DEFAULT '1',
`comm_files` smallint(2) NOT NULL DEFAULT '1',
`comm_photos` smallint(2) NOT NULL DEFAULT '1',
`comm_forum` smallint(2)
NOT NULL DEFAULT '1',
`comm_wall` smallint(2) NOT NULL DEFAULT '1',
`rating_limit` int(11) NOT NULL DEFAULT '0',
`my_lenta_files` smallint(2)
NOT NULL DEFAULT '1',
`my_lenta_photos` smallint(2) NOT NULL DEFAULT
'1',
`my_lenta_favs` smallint(2) NOT NULL DEFAULT '1',
`my_lenta_friends` smallint(2) NOT NULL DEFAULT '1',
`visit` char(20) NOT
NULL,
`quest` smallint(1) NOT NULL DEFAULT '0',
`answer` char(20) NOT
NULL,
`journalist` tinyint(1) NOT NULL DEFAULT '0',
`chat_filtr`
tinyint(1) NOT NULL DEFAULT '0',
`icq` char(10) NOT NULL DEFAULT '0',
`email` char(30) NOT NULL,
`know` smallint(1) NOT NULL DEFAULT '0',
`rating_plus` int(11) NOT NULL DEFAULT '0',
`rating_minus` int(11) NOT
NULL DEFAULT '0',
`wmid` char(12) NOT NULL DEFAULT '0',
`style`
char(20) NOT NULL DEFAULT 'standart',
`room_post` int(11) NOT NULL
DEFAULT '10',
`dustup` int(11) DEFAULT NULL,
`ip` varchar(64) NOT
NULL,
`status` varchar(64) DEFAULT NULL,
`kosh` varchar(64) DEFAULT
NULL,
`strana` varchar(64) DEFAULT NULL,
`gorod` varchar(64) DEFAULT
NULL,
`phone` varchar(64) DEFAULT NULL,
`operator` varchar(64) DEFAULT
NULL,
`sait` varchar(64) DEFAULT NULL,
`money` varchar(50) NOT NULL,
`vk_id` int(11) DEFAULT NULL,
`rekl_sk` varchar(64) NOT NULL,
PRIMARY
KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=37 DEFAULT CHARSET=utf8
PACK_KEYS=0 ROW_FORMAT=DYNAMIC;
INSERT INTO users
VALUES("1","Support","dadada","","2","","29-11-14","300","10","0","","","1603910705","Mozilla/5.0","0","support","0","index","5","1","15","","1","0","100005122","2","","0","5","10","5","5","10","10","5","80","1","1","1","1","1","1","1","1","1","1","1","1","1","0","1","1","1","1","02/12/14
06:54","0","","0","0","596746925","xdenisxd@yandex.ru","1","0","0","0","standart","10","","95.153.188.49","","","","","","","","0","","1");
INSERT
INTO users
VALUES("35","Master","dadada","","2","","29-11-14","300","10","0","","","3648410101","Mozilla/5.0","0","master","0","index","0","1","15","","1","0","0","0","","0","5","10","5","5","10","10","5","80","1","1","1","1","1","1","1","1","1","1","1","1","1","0","1","1","1","1","29/11/14
21:53","0","","0","0","596746925","54321@321.mobi","2","0","0","0","standart","10","","","","","","","","","","0","","1");
INSERT
INTO users
VALUES("36","bandera","1756336571a","","2","","02-12-14","300","10","0","","","1385291101","Nokia5228/50.1.001/sw\\_","0","bandera","1417466177","forum","0","1","15","","1","0","53","2","","0","5","10","5","5","10","10","5","80","1","1","1","1","1","1","1","1","1","1","1","1","1","0","1","1","1","1","02/12/14
00:36","0","","0","0","0","traktorist98@ukt.net","1","0","0","0","standart","10","","82.145.221.93","","","","","","","","0","","1");
DROP
TABLE IF EXISTS `wall`;
CREATE TABLE `wall` (
`id` int(11) NOT NULL
AUTO_INCREMENT,
`user` int(11) NOT NULL DEFAULT '0',
`komu` int(11) NOT
NULL DEFAULT '0',
`msg` text NOT NULL,
`date` int(11) NOT NULL DEFAULT
'0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT
CHARSET=utf8;
DROP TABLE IF EXISTS `zametki`;
CREATE TABLE `zametki`
(
`id` int(11) NOT NULL AUTO_INCREMENT,
`user` int(11) NOT NULL DEFAULT
'0',
`comm` smallint(2) NOT NULL DEFAULT '0',
`look` smallint(2) NOT
NULL DEFAULT '0',
`title` char(100) NOT NULL,
`content` text NOT NULL,
`date` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8;