Просмотр архива Бэкап spuff.ru

DROP TABLE IF EXISTS `ad`;

CREATE TABLE `ad` (
  `id` int(3) NOT NULL
AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `link` varchar(100) NOT
NULL,
  `type` int(1) NOT NULL,
  `time` int(10) NOT NULL,
  PRIMARY KEY
(`id`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;




DROP
TABLE IF EXISTS `adminchat`;

CREATE TABLE `adminchat` (
  `id` int(11) NOT
NULL AUTO_INCREMENT,
  `id_user` int(11) NOT NULL,
  `msg` varchar(250) NOT
NULL,
  `time` int(10) NOT NULL,
  `edit_by` int(11) NOT NULL,
 
`edit_time` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM
AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS
`arb`;

CREATE TABLE `arb` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
 
`id_us` int(11) NOT NULL,
  `id_tko` int(11) NOT NULL,
  `text` text NOT
NULL,
  `time` int(11) NOT NULL,
  `type` int(11) NOT NULL,
  PRIMARY KEY
(`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS
`ban`;

CREATE TABLE `ban` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
 
`id_user` int(11) NOT NULL,
  `until` int(10) NOT NULL,
  `reason`
varchar(250) NOT NULL,
  `by` int(11) NOT NULL,
  PRIMARY KEY (`id`)
)
ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

INSERT INTO ban
VALUES("1","12","1382596984","","2");



DROP
TABLE IF EXISTS `blacklist`;

CREATE TABLE `blacklist` (
  `id` int(11) NOT
NULL AUTO_INCREMENT,
  `id_user` int(11) NOT NULL,
  `blacklisted_by`
int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=10
DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS `blag`;

CREATE TABLE `blag`
(
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_us` int(11) NOT NULL,
 
`id_tko` int(11) NOT NULL,
  `text` text NOT NULL,
  `time` int(11) NOT
NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;




DROP
TABLE IF EXISTS `blogs`;

CREATE TABLE `blogs` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `id_cat` int(11) NOT NULL,
  `id_user` int(11) NOT NULL,

 `name` varchar(50) NOT NULL,
  `text` text NOT NULL,
  `time` int(10) NOT
NULL,
  `seen` int(11) NOT NULL,
  `rating` int(11) NOT NULL,
  `opisanie`
text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4
DEFAULT CHARSET=utf8;

INSERT INTO blogs
VALUES("1","11","2","Легкий
граббер","&lt;?\r\n&#36;file=file_get_contents(&#39;http://site.ru/?&#39;.&#36;_SERVER[&#39;QUERY_STRING&#39;]);\r\necho
&#36;file;\r\n?&gt;","1382324435","0","0","Легкий
граббер на php :)");



DROP TABLE IF EXISTS
`blogs_cats`;

CREATE TABLE `blogs_cats` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
)
ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;

INSERT INTO
blogs_cats VALUES("1","Приколы");
INSERT INTO
blogs_cats VALUES("2","Авторский
код");
INSERT INTO blogs_cats
VALUES("3","Работа с файлами");
INSERT
INTO blogs_cats VALUES("4","Работа с
текстом");
INSERT INTO blogs_cats
VALUES("5","Работа с SQL");
INSERT INTO
blogs_cats VALUES("6","Работа с
временем");
INSERT INTO blogs_cats
VALUES("7","Другое");
INSERT INTO blogs_cats
VALUES("8","JavaScript");
INSERT INTO blogs_cats
VALUES("9","Говнокод");
INSERT INTO blogs_cats
VALUES("10","Кодировка");
INSERT INTO
blogs_cats VALUES("11","Парсеры");
INSERT INTO
blogs_cats
VALUES("12","Безопастность");
INSERT INTO
blogs_cats VALUES("13","Графика");
INSERT INTO
blogs_cats
VALUES("14","Мультимедия");



DROP TABLE IF
EXISTS `blogs_comm`;

CREATE TABLE `blogs_comm` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `id_blogs` int(11) NOT NULL,
  `id_user` int(11) NOT
NULL,
  `text` varchar(250) NOT NULL,
  `time` int(10) NOT NULL,
 
`edit_by` int(11) NOT NULL,
  `edit_time` int(10) NOT NULL,
  PRIMARY KEY
(`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

INSERT INTO
blogs_comm
VALUES("1","2","1","ок","1382284361","0","0");



DROP
TABLE IF EXISTS `book`;

CREATE TABLE `book` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `id_user` int(11) NOT NULL,
  `text` varchar(250) NOT
NULL,
  `time` int(10) NOT NULL,
  `edit_by` int(11) NOT NULL,
 
`edit_time` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8;




DROP TABLE IF EXISTS `chat`;

CREATE TABLE `chat` (
 
`id` int(11) NOT NULL AUTO_INCREMENT,
  `id_user` int(11) NOT NULL,
 
`text` varchar(250) NOT NULL,
  `time` int(10) NOT NULL,
  `edit_by`
int(11) NOT NULL,
  `edit_time` int(10) NOT NULL,
  PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS
`config`;

CREATE TABLE `config` (
  `id` int(1) NOT NULL AUTO_INCREMENT,
 
`style` varchar(15) NOT NULL,
  `language` varchar(10) NOT NULL,
  `onpage`
int(2) NOT NULL,
  `antispam` int(3) NOT NULL,
  `edit_time` int(4) NOT
NULL,
  `kick` int(3) NOT NULL,
  `allowed_ext` varchar(200) NOT NULL,
 
`regoff` int(1) NOT NULL,
  `cache_counters` int(5) NOT NULL,
 
`activation` int(1) NOT NULL,
  `duplicate` int(1) NOT NULL,
  `userimport`
int(1) NOT NULL,
  `email_ver` int(1) NOT NULL,
  PRIMARY KEY (`id`)
)
ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

INSERT INTO config
VALUES("1","default","russian","10","5","10","100","zip
jpg gif
png","0","0","0","1","0","1");



DROP
TABLE IF EXISTS `forum_cats`;

CREATE TABLE `forum_cats` (
  `id` int(3)
NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `order` int(11)
NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT
CHARSET=utf8;

INSERT INTO forum_cats
VALUES("7","Мастеру","0");
INSERT INTO
forum_cats
VALUES("2","Общение","0");
INSERT INTO
forum_cats VALUES("5","О
сайте","0");
INSERT INTO forum_cats
VALUES("6","IT
Технологии","0");
INSERT INTO forum_cats
VALUES("10","Фриланс","0");



DROP
TABLE IF EXISTS `forum_msg`;

CREATE TABLE `forum_msg` (
  `id` int(11) NOT
NULL AUTO_INCREMENT,
  `id_cat` int(11) NOT NULL,
  `id_subcat` int(11) NOT
NULL,
  `id_topic` int(5) NOT NULL,
  `id_user` int(11) NOT NULL,
  `text`
text NOT NULL,
  `file` varchar(255) NOT NULL,
  `file_loads` int(11) NOT
NULL DEFAULT '0',
  `time` int(10) NOT NULL,
  `edit_by` int(11) NOT NULL,

 `edit_time` int(10) NOT NULL,
  `rating` int(11) NOT NULL,
  PRIMARY KEY
(`id`)
) ENGINE=MyISAM AUTO_INCREMENT=36 DEFAULT CHARSET=utf8;

INSERT INTO
forum_msg
VALUES("1","5","24","1","1","в
этой теме можно писать мелкие баги и
ошибки сайта
:)","","0","1382273727","0","0","0");
INSERT
INTO forum_msg
VALUES("35","0","0","1","2","[b]johnyboy[/b],
а ты как зарегался
тогда?","","0","1382546876","0","0","0");
INSERT
INTO forum_msg
VALUES("33","0","0","1","11","Зарегаться
нельзя","","0","1382542241","0","0","0");
INSERT
INTO forum_msg
VALUES("34","0","0","1","11","Главная
стр там где вход и рега это не
работает","","0","1382542279","0","0","0");



DROP
TABLE IF EXISTS `forum_subcats`;

CREATE TABLE `forum_subcats` (
  `id`
int(11) NOT NULL AUTO_INCREMENT,
  `id_cat` int(11) NOT NULL,
  `name`
varchar(100) NOT NULL,
  `order` int(11) NOT NULL,
  PRIMARY KEY (`id`)
)
ENGINE=MyISAM AUTO_INCREMENT=44 DEFAULT CHARSET=utf8;

INSERT INTO
forum_subcats VALUES("30","7","Графика /
Дизайн","0");
INSERT INTO forum_subcats
VALUES("3","2","Общение /
Знакомства / Оффтоп","0");
INSERT INTO
forum_subcats VALUES("29","7","SEO
оптимизация, Поисковые
системы","0");
INSERT INTO forum_subcats
VALUES("20","2","Фильмы / Музыка /
Игры","0");
INSERT INTO forum_subcats
VALUES("21","2","Мировые новости /
Опросы","0");
INSERT INTO forum_subcats
VALUES("22","5","О
SPUFF.RU","0");
INSERT INTO forum_subcats
VALUES("23","5","Вопросы /
Предложения","0");
INSERT INTO forum_subcats
VALUES("24","5","Баги / Ошибки /
Обновления","0");
INSERT INTO forum_subcats
VALUES("25","5","Конкурсы","0");
INSERT
INTO forum_subcats
VALUES("26","6","Платежные системы
/ ICQ / Skype","0");
INSERT INTO forum_subcats
VALUES("27","6","Телефоны /
Смартфоны / Связь","0");
INSERT INTO
forum_subcats
VALUES("28","6","Компьютеры /
Ноутбуки / Планшеты","0");
INSERT INTO
forum_subcats VALUES("31","7","Вопросы
новичков","0");
INSERT INTO forum_subcats
VALUES("32","7","Софт / Архивы /
Загрузки","0");
INSERT INTO forum_subcats
VALUES("33","7","Хостинги /
Администрирование","0");
INSERT INTO
forum_subcats VALUES("34","7","Заработок
в сети","0");
INSERT INTO forum_subcats
VALUES("35","7","Реклама /
Обсуждение сайтов","0");
INSERT INTO
forum_subcats
VALUES("36","7","Программирование
/ Хакинг / Безопасность","0");
INSERT INTO
forum_subcats VALUES("37","10","Купля /
Продажа / Платные услуги","0");
INSERT
INTO forum_subcats
VALUES("38","10","Раздача /
Бесплатные услуги / Поиск","0");
INSERT
INTO forum_subcats VALUES("39","10","Кредит
/ Займ","0");
INSERT INTO forum_subcats
VALUES("40","10","Арбитраж","0");
INSERT
INTO forum_subcats VALUES("41","7","Скрипты
/ CMS","0");



DROP TABLE IF EXISTS `forum_topics`;

CREATE
TABLE `forum_topics` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `id_cat`
int(3) NOT NULL,
  `id_subcat` int(11) NOT NULL,
  `title` varchar(50)
DEFAULT NULL,
  `id_user` int(11) NOT NULL,
  `last_time` int(10) NOT
NULL,
  `stuck` int(1) NOT NULL,
  `closed` int(1) NOT NULL,
  PRIMARY KEY
(`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

INSERT INTO
forum_topics
VALUES("1","5","24","мелкие
баги и
ошибки","1","1382546876","1","0");



DROP
TABLE IF EXISTS `loads`;

CREATE TABLE `loads` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `id_cat` int(11) NOT NULL,
  `id_subcat` int(11) NOT
NULL,
  `id_user` int(11) NOT NULL,
  `name` varchar(50) NOT NULL,
  `desc`
text NOT NULL,
  `author` varchar(20) NOT NULL,
  `site` varchar(20) NOT
NULL,
  `file` varchar(50) NOT NULL,
  `screen` varchar(50) NOT NULL,
 
`time` int(10) NOT NULL,
  `ok` int(1) NOT NULL,
  `loaded` int(11) NOT
NULL,
  `seen` int(11) NOT NULL,
  `rating` int(11) NOT NULL,
  PRIMARY KEY
(`id`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;

INSERT INTO
loads
VALUES("10","2","1","2","Тестик","Лала","","","spuff.ru_2_2.jpg","","1382873666","1","0","2","0");
INSERT
INTO loads
VALUES("11","2","1","2","Тест
2","","","","spuff.ru_2_Nissan_Skyline.jpg","","1382874010","1","0","1","0");
INSERT
INTO loads
VALUES("12","2","1","2","testn","","","","main.png","","1382884621","1","0","1","0");



DROP
TABLE IF EXISTS `loads_cats`;

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

INSERT INTO
loads_cats VALUES("3","Скрипты");
INSERT INTO
loads_cats VALUES("2","Дизайны");



DROP TABLE
IF EXISTS `loads_comm`;

CREATE TABLE `loads_comm` (
  `id` int(11) NOT
NULL AUTO_INCREMENT,
  `id_loads` int(11) NOT NULL,
  `id_user` int(11) NOT
NULL,
  `text` varchar(250) NOT NULL,
  `time` int(10) NOT NULL,
 
`edit_by` int(11) NOT NULL,
  `edit_time` int(10) NOT NULL,
  PRIMARY KEY
(`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS
`loads_subcats`;

CREATE TABLE `loads_subcats` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `id_cat` int(11) NOT NULL,
  `name` varchar(50) NOT
NULL,
  `path` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM
AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

INSERT INTO loads_subcats
VALUES("1","2","WAP","Dizayny_WAP");
INSERT
INTO loads_subcats
VALUES("2","2","WEB","Dizayny_WEB");



DROP
TABLE IF EXISTS `my_friends`;

CREATE TABLE `my_friends` (
  `id` int(11)
NOT NULL AUTO_INCREMENT,
  `id_user` int(11) NOT NULL,
  `is_friend_of`
int(11) NOT NULL,
  `ok` int(1) NOT NULL,
  PRIMARY KEY (`id`)
)
ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

INSERT INTO
my_friends
VALUES("1","2","1","0");
INSERT
INTO my_friends
VALUES("5","1","2","0");
INSERT
INTO my_friends
VALUES("6","9","2","0");



DROP
TABLE IF EXISTS `nagr`;

CREATE TABLE `nagr` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `id_us` int(11) NOT NULL,
  `id_kto` int(11) NOT NULL,
 
`img` int(11) NOT NULL,
  `text` text NOT NULL,
  `time` int(11) NOT NULL,

 PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;




DROP TABLE IF
EXISTS `news`;

CREATE TABLE `news` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `text` text,
  `time`
int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2
DEFAULT CHARSET=utf8;

INSERT INTO news VALUES("1","И
работа закипела","Здравствует, тест
новостей","1382275305");



DROP TABLE IF EXISTS
`news_comm`;

CREATE TABLE `news_comm` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `id_news` int(11) NOT NULL,
  `id_user` int(11) NOT
NULL,
  `text` varchar(250) NOT NULL,
  `time` int(10) NOT NULL,
 
`edit_by` int(11) NOT NULL,
  `edit_time` int(10) NOT NULL,
  PRIMARY KEY
(`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

INSERT INTO
news_comm
VALUES("3","1","13","роботает","1382686737","0","0");



DROP
TABLE IF EXISTS `online`;

CREATE TABLE `online` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `id_user` int(11) NOT NULL,
  `ip` varchar(100) NOT
NULL,
  `user_agent` varchar(250) NOT NULL,
  `place` varchar(50) NOT
NULL,
  `time` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM
AUTO_INCREMENT=10151 DEFAULT CHARSET=utf8;

INSERT INTO online
VALUES("10150","0","66.249.75.43","Mozilla/5.0
(compatible; Googlebot/2.1;
+http://www.google.com/bot.html)","ЗЦ","1382935775");



DROP
TABLE IF EXISTS `pm`;

CREATE TABLE `pm` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `id_user` int(11) NOT NULL,
  `id_sender` int(11) NOT
NULL,
  `time` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM
AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

INSERT INTO pm
VALUES("8","2","1","1382599874");
INSERT
INTO pm
VALUES("2","2","9","1382351248");
INSERT
INTO pm
VALUES("3","1","9","1382351517");
INSERT
INTO pm
VALUES("4","2","10","1382353823");
INSERT
INTO pm
VALUES("7","2","-1","1382874046");
INSERT
INTO pm
VALUES("6","1","-1","1382874010");



DROP
TABLE IF EXISTS `pm_msg`;

CREATE TABLE `pm_msg` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `id_pm` int(11) NOT NULL,
  `id_user` int(11) NOT NULL,
 
`id_sender` int(11) NOT NULL,
  `text` varchar(250) NOT NULL,
  `time`
int(10) NOT NULL,
  `read` int(1) NOT NULL,
  PRIMARY KEY (`id`)
)
ENGINE=MyISAM AUTO_INCREMENT=95 DEFAULT CHARSET=utf8;

INSERT INTO pm_msg
VALUES("94","7","2","-1","Ваш
файл <b><a
href=\"../loads/?act=view&amp;id=11\">Тест
2</a></b> был успешно
промодерирован.","1382874046","1");
INSERT
INTO pm_msg
VALUES("93","6","1","-1","Появился
новый файл в ЗЦ. <a
href=\"../loads/?act=mod\">Проверьте</a>.","1382874010","1");
INSERT
INTO pm_msg
VALUES("92","7","2","-1","Появился
новый файл в ЗЦ. <a
href=\"../loads/?act=mod\">Проверьте</a>.","1382874010","1");
INSERT
INTO pm_msg
VALUES("91","7","2","-1","Ваш
файл <b><a
href=\"../loads/?act=view&amp;id=10\">Тестик</a></b>
был успешно
промодерирован.","1382873946","1");
INSERT
INTO pm_msg
VALUES("90","6","1","-1","Появился
новый файл в ЗЦ. <a
href=\"../loads/?act=mod\">Проверьте</a>.","1382873666","1");
INSERT
INTO pm_msg
VALUES("89","7","2","-1","Появился
новый файл в ЗЦ. <a
href=\"../loads/?act=mod\">Проверьте</a>.","1382873666","1");
INSERT
INTO pm_msg
VALUES("88","8","2","1","бла
бла бла","1382599874","1");
INSERT INTO
pm_msg
VALUES("87","8","2","1","..","1382599812","1");
INSERT
INTO pm_msg
VALUES("86","8","1","2","Бля
хочеш я
заскриню?","1382599706","1");
INSERT INTO
pm_msg
VALUES("85","8","2","1","на
профи в лич скрин щас
кину","1382597647","1");
INSERT INTO pm_msg
VALUES("84","8","1","2","Бля
у меня показывает
входящие","1382595958","1");
INSERT INTO
pm_msg
VALUES("83","8","2","1","показывает
только
исходящии","1382595100","1");
INSERT INTO
pm_msg
VALUES("82","8","2","1","не
нехера не показывает Admin [соз]
(0/8)","1382595063","1");
INSERT INTO pm_msg
VALUES("81","8","1","2","Ты
видно тупой :D надо больше десяти
сообщений
написать","1382584419","1");
INSERT INTO
pm_msg
VALUES("80","8","2","1","все
равно не удобно я же не заметил
:-d","1382584330","1");
INSERT INTO pm_msg
VALUES("79","8","1","2","Бля
на счёчики глянь там (1/3) один это ногое
письмо, на профивм
так-же","1382583635","1");
INSERT INTO pm_msg
VALUES("30","2","2","9","все","1382351248","1");
INSERT
INTO pm_msg
VALUES("78","8","2","1","знаешь
чего не хватает Admin [соз] (0/3) +1 ото не ясно
кто написал
:)","1382583385","1");
INSERT INTO pm_msg
VALUES("77","8","1","2","Тест","1382583361","1");
INSERT
INTO pm_msg
VALUES("76","8","1","2","Всё
збс","1382583291","1");
INSERT INTO pm_msg
VALUES("75","8","2","1","шмфмшршршдфа
аьр","1382583190","1");
INSERT INTO pm_msg
VALUES("74","8","2","1","имифимхфшшдишмша
фмфрфдиадиьдимфимдф","1382583177","1");
INSERT
INTO pm_msg
VALUES("73","7","2","-1","Ваш
файл <b><a
href=\"../loads/?act=view&amp;id=8\">mgm</a></b>
был успешно
промодерирован.","1382536135","1");
INSERT
INTO pm_msg
VALUES("72","6","1","-1","Появился
новый файл в ЗЦ. <a
href=\"../loads/?act=mod\">Проверьте</a>.","1382532237","1");
INSERT
INTO pm_msg
VALUES("49","4","2","10","я
те тож че нибудь
дам","1382353823","1");
INSERT INTO pm_msg
VALUES("48","4","10","2","net","1382353740","1");
INSERT
INTO pm_msg
VALUES("47","4","2","10","дай
дизайн этого сайта я его на ВЕБ
ПОПРОБУЮ","1382353669","1");
INSERT INTO
pm_msg
VALUES("51","6","1","-1","Появился
новый файл в ЗЦ. <a
href=\"../loads/?act=mod\">Проверьте</a>.","1382357352","1");
INSERT
INTO pm_msg
VALUES("70","6","1","-1","Вас
плюсанули :)","1382454700","1");
INSERT
INTO pm_msg
VALUES("54","6","1","-1","Появился
новый файл в ЗЦ. <a
href=\"../loads/?act=mod\">Проверьте</a>.","1382358529","1");
INSERT
INTO pm_msg
VALUES("69","7","2","-1","Ваш
файл <b><a
href=\"../loads/?act=view&amp;id=7\">TEST</a></b>
был успешно
промодерирован.","1382453217","1");
INSERT
INTO pm_msg
VALUES("68","6","1","-1","Появился
новый файл в ЗЦ. <a
href=\"../loads/?act=mod\">Проверьте</a>.","1382453202","1");
INSERT
INTO pm_msg
VALUES("57","6","1","-1","Появился
новый файл в ЗЦ. <a
href=\"../loads/?act=mod\">Проверьте</a>.","1382361868","1");
INSERT
INTO pm_msg
VALUES("67","7","2","-1","Появился
новый файл в ЗЦ. <a
href=\"../loads/?act=mod\">Проверьте</a>.","1382453202","1");
INSERT
INTO pm_msg
VALUES("60","6","1","-1","Появился
новый файл в ЗЦ. <a
href=\"../loads/?act=mod\">Проверьте</a>.","1382362134","1");
INSERT
INTO pm_msg
VALUES("71","7","2","-1","Появился
новый файл в ЗЦ. <a
href=\"../loads/?act=mod\">Проверьте</a>.","1382532237","1");
INSERT
INTO pm_msg
VALUES("66","7","2","-1","Ваш
файл <b><a
href=\"../loads/?act=view&amp;id=6\">TEST</a></b>
был успешно
промодерирован.","1382453146","1");
INSERT
INTO pm_msg
VALUES("65","6","1","-1","Появился
новый файл в ЗЦ. <a
href=\"../loads/?act=mod\">Проверьте</a>.","1382453126","1");
INSERT
INTO pm_msg
VALUES("63","6","1","-1","Появился
новый файл в ЗЦ. <a
href=\"../loads/?act=mod\">Проверьте</a>.","1382364153","1");
INSERT
INTO pm_msg
VALUES("64","7","2","-1","Появился
новый файл в ЗЦ. <a
href=\"../loads/?act=mod\">Проверьте</a>.","1382453126","1");



DROP
TABLE IF EXISTS `seen`;

CREATE TABLE `seen` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `type` varchar(10) NOT NULL,
  `id_data` int(11) NOT
NULL,
  `id_user` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM
AUTO_INCREMENT=34 DEFAULT CHARSET=utf8;

INSERT INTO seen
VALUES("1","blog","1","2");
INSERT
INTO seen
VALUES("2","blog","1","0");
INSERT
INTO seen
VALUES("3","blog","1","5");
INSERT
INTO seen
VALUES("4","blog","1","1");
INSERT
INTO seen
VALUES("5","blog","2","2");
INSERT
INTO seen
VALUES("6","blog","3","2");
INSERT
INTO seen
VALUES("7","blog","4","2");
INSERT
INTO seen
VALUES("8","blog","5","2");
INSERT
INTO seen
VALUES("9","blog","6","2");
INSERT
INTO seen
VALUES("10","blog","7","2");
INSERT
INTO seen
VALUES("11","blog","2","0");
INSERT
INTO seen
VALUES("12","blog","8","2");
INSERT
INTO seen
VALUES("13","blog","9","2");
INSERT
INTO seen
VALUES("14","blog","10","2");
INSERT
INTO seen
VALUES("15","blog","11","2");
INSERT
INTO seen
VALUES("16","blog","12","2");
INSERT
INTO seen
VALUES("17","blog","13","2");
INSERT
INTO seen
VALUES("18","blog","14","2");
INSERT
INTO seen
VALUES("19","blog","15","2");
INSERT
INTO seen
VALUES("20","blog","2","1");
INSERT
INTO seen
VALUES("21","blog","15","1");
INSERT
INTO seen
VALUES("22","blog","8","1");
INSERT
INTO seen
VALUES("23","blog","16","2");
INSERT
INTO seen
VALUES("24","blog","17","2");
INSERT
INTO seen
VALUES("25","blog","18","2");
INSERT
INTO seen
VALUES("26","blog","18","0");
INSERT
INTO seen
VALUES("27","loads","6","2");
INSERT
INTO seen
VALUES("28","loads","8","2");
INSERT
INTO seen
VALUES("29","loads","9","1");
INSERT
INTO seen
VALUES("30","loads","11","2");
INSERT
INTO seen
VALUES("31","loads","10","2");
INSERT
INTO seen
VALUES("32","loads","10","1");
INSERT
INTO seen
VALUES("33","loads","12","2");



DROP
TABLE IF EXISTS `smiles`;

CREATE TABLE `smiles` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `code` varchar(50) NOT NULL,
  `path` varchar(50) NOT
NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=38 DEFAULT
CHARSET=utf8;

INSERT INTO smiles
VALUES("1",":)","images/smiles/1.gif");
INSERT
INTO smiles
VALUES("2",":-)","images/smiles/2.gif");
INSERT
INTO smiles
VALUES("4",";/","images/smiles/4.gif");
INSERT
INTO smiles
VALUES("5",".цвирк.","images/smiles/5.gif");
INSERT
INTO smiles
VALUES("6","0_0","images/smiles/6.gif");
INSERT
INTO smiles
VALUES("7",":(","images/smiles/7.gif");
INSERT
INTO smiles
VALUES("8",":-(","images/smiles/8.gif");
INSERT
INTO smiles
VALUES("9",":yy","images/smiles/9.gif");
INSERT
INTO smiles
VALUES("10",":sho","images/smiles/10.gif");
INSERT
INTO smiles
VALUES("11",":o_o","images/smiles/11.gif");
INSERT
INTO smiles
VALUES("12",":crazy","images/smiles/12.gif");
INSERT
INTO smiles
VALUES("13",":d","images/smiles/13.gif");
INSERT
INTO smiles
VALUES("14",":-d","images/smiles/14.gif");
INSERT
INTO smiles
VALUES("15",":peace","images/smiles/15.gif");
INSERT
INTO smiles
VALUES("16",":flud","images/smiles/16.gif");
INSERT
INTO smiles
VALUES("17",":closed","images/smiles/17.gif");
INSERT
INTO smiles
VALUES("18",":angry","images/smiles/18.gif");
INSERT
INTO smiles
VALUES("19",":bravo","images/smiles/19.gif");
INSERT
INTO smiles
VALUES("20",":ban","images/smiles/20.gif");
INSERT
INTO smiles
VALUES("21",":fee","images/smiles/21.gif");
INSERT
INTO smiles
VALUES("22",":welcome","images/smiles/22.gif");
INSERT
INTO smiles
VALUES("23",":good","images/smiles/23.gif");
INSERT
INTO smiles
VALUES("24",":ubanned","images/smiles/24.gif");
INSERT
INTO smiles
VALUES("25",":spam","images/smiles/25.gif");
INSERT
INTO smiles
VALUES("26",":shut","images/smiles/26.gif");
INSERT
INTO smiles
VALUES("27",":shock","images/smiles/27.gif");
INSERT
INTO smiles
VALUES("28",":read","images/smiles/28.gif");
INSERT
INTO smiles
VALUES("29",":overlook","images/smiles/29.gif");
INSERT
INTO smiles
VALUES("30",":oops","images/smiles/30.gif");
INSERT
INTO smiles
VALUES("31",":?","images/smiles/31.gif");
INSERT
INTO smiles
VALUES("32",":@","images/smiles/32.gif");
INSERT
INTO smiles
VALUES("34",":off","images/smiles/34.gif");
INSERT
INTO smiles
VALUES("35",":lol","images/smiles/35.gif");
INSERT
INTO smiles
VALUES("36",":hack","images/smiles/36.gif");
INSERT
INTO smiles
VALUES("37",":sorry","images/smiles/37.gif");



DROP
TABLE IF EXISTS `users`;

CREATE TABLE `users` (
  `id` int(5) NOT NULL
AUTO_INCREMENT,
  `username` varchar(12) DEFAULT NULL,
  `email`
varchar(50) DEFAULT NULL,
  `password` varchar(32) DEFAULT NULL,
  `access`
int(1) NOT NULL,
  `regtime` int(10) DEFAULT NULL,
  `lastvisit` int(10)
NOT NULL,
  `karma` int(11) NOT NULL,
  `name` varchar(20) NOT NULL,
 
`from` varchar(25) NOT NULL,
  `icq` int(9) NOT NULL,
  `site` varchar(20)
NOT NULL,
  `birthday` varchar(10) NOT NULL,
  `gender` int(1) NOT NULL,
 
`about` varchar(150) DEFAULT NULL,
  `style` varchar(50) NOT NULL,
 
`onpage` int(2) NOT NULL,
  `language` varchar(10) NOT NULL,
  `avatar`
varchar(250) NOT NULL,
  `email_ver` varchar(10) NOT NULL,
  `ok` int(1)
NOT NULL,
  `online_site` int(11) NOT NULL,
  `gorod` varchar(50) NOT
NULL,
  `wmid` varchar(12) NOT NULL DEFAULT '0',
  `wmr` varchar(12) NOT
NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=17
DEFAULT CHARSET=utf8;

INSERT INTO users
VALUES("2","Admin","gruzmobi@gmail.com","be027b59ee5c69c6a6f22c942e9e6e6d","4","1382272058","1382935120","2","Тимофей","Россия","10361141","otwap.ru","13.12.1994","1","Это
секретная
информация","default","10","russian","2_Scorpion.jpg","1","1","4817","Райчихинск","982779099382","190413899263");
INSERT
INTO users
VALUES("1","SKING","stepan23232@mail.ru","1fa8a5c10b64d437f4ea18a07b3439ab","4","1382272892","1382933873","9","STEPAN","Россия","0","navape.ru","25.05.1995","1","","default","10","russian","1_vcard.png","1","1","2089","Курган","257699413137","34248697206");
INSERT
INTO users
VALUES("4","Mc_Lari","rluzgin@mail.ru","14e1b600b1fd579f47433b88e8d85291","0","1382274271","1382278257","1","","","0","","","0","","default","10","russian","0","1","1","14","0","0","0");
INSERT
INTO users
VALUES("5","ivrus","bejsser34@mail.ru","69280ec4924e2d0949b3bdfbb6a7e392","0","1382279182","1382279462","0","","","0","","","0","","default","10","russian","0","1","1","7","0","0","0");
INSERT
INTO users
VALUES("6","Ruslan","qwqwqw@mail.ru","b53063843a85f33d9debee5c45473616","0","1382280314","1382280314","0","","","0","","","0","","default","10","russian","0","32hZB9J7xU","1","0","0","0","0");
INSERT
INTO users
VALUES("7","Alekksss","nunaiev@bk.ru","b53063843a85f33d9debee5c45473616","0","1382280376","1382280376","0","","","0","","","0","","default","10","russian","0","2p7hAoLPf0","1","0","0","0","0");
INSERT
INTO users
VALUES("14","Ak47res1","Sergejres1@mail.ru","f265a08a7e70f2bf8406471f811e0215","0","1382729966","1382729966","2","","","0","","","0","","default","10","russian","","xuX3uIt8uB","1","0","","0","0");
INSERT
INTO users
VALUES("10","surfak","surfak1992@mail.ru","7c3d596ed03ab9116c547b0eb678b247","0","1382352806","1382928068","0","","","0","","","0","","default","10","russian","0","1","1","140","0","0","0");
INSERT
INTO users
VALUES("11","johnyboy","zulo00@mail.ru","88b314799e9a9301914cb89cf2b9f549","0","1382540943","1382621261","-1","Максим","","0","clubpro.tk","","1","","default","10","russian","","1","1","51","","","");
INSERT
INTO users
VALUES("13","shunia22","shun_mc@mail.ru","783833353268ebbab1970113ac1e538c","0","1382686476","1382686975","0","Андрей","Украина","176430308","","22.04.2013","1","","default","10","russian","","1","1","12","Запорожье","0","0");
INSERT
INTO users
VALUES("15","Kpss","Fakeges@yandex.ru","3b7600698201e4765bee44a3e0842d35","0","1382806796","1382806796","0","","","0","","","0","","default","10","russian","","NtjfGZRRve","1","0","","0","0");
INSERT
INTO users
VALUES("16","Karakula","Fakeges@yandex.ru","d2b8b451b55fbfdc6329e115320a79bc","0","1382806872","1382850517","0","","","0","","","0","","default","10","russian","","1","1","5","","0","0");



DROP
TABLE IF EXISTS `voting`;

CREATE TABLE `voting` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `type` varchar(10) NOT NULL,
  `id_data` int(11) NOT
NULL,
  `id_user` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM
AUTO_INCREMENT=21 DEFAULT CHARSET=utf8;

INSERT INTO voting
VALUES("1","profile","2","2");
INSERT
INTO voting
VALUES("2","forum_msg","1","2");
INSERT
INTO voting
VALUES("3","profile","2","1");
INSERT
INTO voting
VALUES("4","profile","1","1");
INSERT
INTO voting
VALUES("5","blogs","1","2");
INSERT
INTO voting
VALUES("6","profile","1","2");
INSERT
INTO voting
VALUES("7","blogs","1","1");
INSERT
INTO voting
VALUES("8","blogs","2","1");
INSERT
INTO voting
VALUES("9","forum_msg","1","1");
INSERT
INTO voting
VALUES("10","profile","1","9");
INSERT
INTO voting
VALUES("11","loads","1","2");
INSERT
INTO voting
VALUES("12","photos","1","2");
INSERT
INTO voting
VALUES("13","profile","9","2");
INSERT
INTO voting
VALUES("14","profile","4","2");
INSERT
INTO voting
VALUES("15","forum_msg","1","11");
INSERT
INTO voting
VALUES("16","profile","1","11");
INSERT
INTO voting
VALUES("17","profile","2","11");
INSERT
INTO voting
VALUES("18","profile","11","2");
INSERT
INTO voting
VALUES("19","profile","14","2");
INSERT
INTO voting
VALUES("20","profile","14","10");