Просмотр архива Каталог сайтов (с гигса)

DROP TABLE IF EXISTS `adm_users`;

CREATE TABLE `adm_users` (
  `id`
int(11) NOT NULL AUTO_INCREMENT,
  `login` text NOT NULL,
  `password`
text NOT NULL,
  `sid` text NOT NULL,
  `ip` text NOT NULL,
  PRIMARY
KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT
CHARSET=utf8;

INSERT INTO adm_users
VALUES("1","admin","1f32aa4c9a1d2ea010adcf2348166a04","09e55425bdb7ae468f02805f719f99e1","88.147.152.121");



DROP
TABLE IF EXISTS `category`;

CREATE TABLE `category` (
  `id` int(11)
NOT NULL AUTO_INCREMENT,
  `name` text NOT NULL,
  `about` text NOT
NULL,
  `translitit` text NOT NULL,
  `description` text NOT NULL,
 
`keywords` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB
AUTO_INCREMENT=26 DEFAULT CHARSET=utf8;

INSERT INTO category
VALUES("16","Стратегии","","strategii","","");
INSERT
INTO category
VALUES("17","Драки","","draki","","");
INSERT
INTO category
VALUES("18","Симуляторы","","simulyatoryi","","");
INSERT
INTO category
VALUES("19","RPG","","RPG","","");
INSERT
INTO category
VALUES("20","Стрелялки","","strelyalki","","");
INSERT
INTO category
VALUES("21","Фермы","","fermyi","","");
INSERT
INTO category
VALUES("22","Гонки","","gonki","","");
INSERT
INTO category
VALUES("23","Экономические","","ekonomicheskie","","");
INSERT
INTO category
VALUES("24","Другие","","drugie","","");
INSERT
INTO category
VALUES("25","Любительские","","lyubitelskie","","");



DROP
TABLE IF EXISTS `comment`;

CREATE TABLE `comment` (
  `id` int(11) NOT
NULL AUTO_INCREMENT,
  `id_site` int(11) NOT NULL,
  `ip` text NOT
NULL,
  `text` text NOT NULL,
  `level` text NOT NULL,
  PRIMARY KEY
(`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8;

INSERT
INTO comment
VALUES("1","5","88.147.152.121","супер
играаааа","2");
INSERT INTO comment
VALUES("2","5","88.147.152.121","супер
игра","2");
INSERT INTO comment
VALUES("3","5","88.147.152.121","супер
игра","2");
INSERT INTO comment
VALUES("4","5","88.147.152.121","супер
игра","2");
INSERT INTO comment
VALUES("5","5","88.147.152.121","супер
игра","2");
INSERT INTO comment
VALUES("6","5","88.147.152.121","супер
игра","2");
INSERT INTO comment
VALUES("7","5","88.147.152.121","супер
игра","2");
INSERT INTO comment
VALUES("8","5","88.147.152.121","супер
игра","2");
INSERT INTO comment
VALUES("9","5","88.147.152.121","yjhv","2");
INSERT
INTO comment
VALUES("10","5","88.147.153.117","супер","2");
INSERT
INTO comment
VALUES("11","5","88.147.153.117","супер","2");
INSERT
INTO comment
VALUES("12","5","88.147.153.117","супер","2");
INSERT
INTO comment
VALUES("13","5","88.147.153.117","говно","2");
INSERT
INTO comment
VALUES("14","5","88.147.153.117","говно","2");
INSERT
INTO comment
VALUES("15","5","88.147.153.117","говно","2");
INSERT
INTO comment
VALUES("16","5","88.147.153.117","говно","2");
INSERT
INTO comment
VALUES("17","5","88.147.153.117","фигня","1");



DROP
TABLE IF EXISTS `complaint`;

CREATE TABLE `complaint` (
  `id` int(11)
NOT NULL AUTO_INCREMENT,
  `id_site` int(11) NOT NULL,
  `text` text NOT
NULL,
  `ip` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT
CHARSET=utf8;




DROP TABLE IF EXISTS `contacts`;

CREATE TABLE
`contacts` (
  `key` text NOT NULL,
  `value` text NOT NULL
)
ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO contacts
VALUES("email","test@test.ru");
INSERT INTO contacts
VALUES("telephone","79144292112");
INSERT INTO
contacts VALUES("skype","test");
INSERT INTO contacts
VALUES("icq","666666");



DROP TABLE IF EXISTS
`news`;

CREATE TABLE `news` (
  `id` int(11) NOT NULL AUTO_INCREMENT,

 `name` text NOT NULL,
  `text` text NOT NULL,
  PRIMARY KEY (`id`)
)
ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

INSERT INTO news
VALUES("1","Версия beta 2","Спасибо
что установили наш движок\r\nАвтор by
RotManS");



DROP TABLE IF EXISTS `rekl`;

CREATE TABLE `rekl`
(
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` text NOT NULL,
 
`url` text NOT NULL,
  `img` text NOT NULL,
  `level` text NOT NULL,
 
`place` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT
CHARSET=utf8;




DROP TABLE IF EXISTS `settings_core`;

CREATE
TABLE `settings_core` (
  `key` text NOT NULL,
  `value` text NOT NULL
)
ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO settings_core
VALUES("description","каталог игр");
INSERT
INTO settings_core VALUES("title","Каталог
игр");
INSERT INTO settings_core
VALUES("keywords","каталог игр");
INSERT
INTO settings_core VALUES("page","7");
INSERT INTO
settings_core VALUES("rules","Пусто");



DROP
TABLE IF EXISTS `site`;

CREATE TABLE `site` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `id_category` int(11) NOT NULL,
  `url` varchar(100)
NOT NULL,
  `name` varchar(100) NOT NULL,
  `about` text NOT NULL,
 
`time` text NOT NULL,
  `translitit` text NOT NULL,
  `description`
varchar(255) NOT NULL,
  `keywords` varchar(255) NOT NULL,
  `mod`
int(11) NOT NULL,
  `ban` int(11) NOT NULL,
  `ban_text` text NOT NULL,

 PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT
CHARSET=utf8;

INSERT INTO site
VALUES("5","16","township.mobi","Моя
деревня","Так увлекательно вести
хозяйство Вам ещё никогда не доводилось!
Такого вы ещё не видели, присоединяйтесь,
это
затягивает!","1430067679","http:__township_mobi_","","","1","0","");



DROP
TABLE IF EXISTS `useronline`;

CREATE TABLE `useronline` (
  `timestamp`
int(15) NOT NULL DEFAULT '0',
  `ip` varchar(40) NOT NULL,
  `file`
varchar(100) NOT NULL,
  PRIMARY KEY (`timestamp`),
  KEY `ip` (`ip`),
 
KEY `file` (`file`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO
useronline
VALUES("1430122887","88.147.153.117","/pages/category.php");
INSERT
INTO useronline
VALUES("1430122877","88.147.153.117","/pages/comments.php");
INSERT
INTO useronline
VALUES("1430122872","88.147.153.117","/pages/complaint.php");
INSERT
INTO useronline
VALUES("1430122864","88.147.153.117","/pages/comments.php");
INSERT
INTO useronline
VALUES("1430122856","88.147.153.117","/pages/add_comment.php");
INSERT
INTO useronline
VALUES("1430122852","88.147.153.117","/pages/add_comment.php");
INSERT
INTO useronline
VALUES("1430122846","88.147.153.117","/pages/add_comment.php");
INSERT
INTO useronline
VALUES("1430122845","88.147.153.117","/pages/add_comment.php");
INSERT
INTO useronline
VALUES("1430122844","88.147.153.117","/pages/add_comment.php");
INSERT
INTO useronline
VALUES("1430122842","88.147.153.117","/pages/add_comment.php");
INSERT
INTO useronline
VALUES("1430122841","88.147.153.117","/pages/add_comment.php");
INSERT
INTO useronline
VALUES("1430122818","88.147.153.117","/pages/add_comment.php");
INSERT
INTO useronline
VALUES("1430122750","88.147.153.117","/pages/add_comment.php");
INSERT
INTO useronline
VALUES("1430122826","88.147.153.117","/pages/add_comment.php");
INSERT
INTO useronline
VALUES("1430122822","88.147.153.117","/pages/add_comment.php");
INSERT
INTO useronline
VALUES("1430122832","88.147.153.117","/pages/add_comment.php");
INSERT
INTO useronline
VALUES("1430122840","88.147.153.117","/pages/add_comment.php");
INSERT
INTO useronline
VALUES("1430122732","88.147.153.117","/pages/category.php");
INSERT
INTO useronline
VALUES("1430122609","88.147.153.117","/pages/add_site.php");
INSERT
INTO useronline
VALUES("1430122746","88.147.153.117","/pages/add_comment.php");
INSERT
INTO useronline
VALUES("1430122744","88.147.153.117","/pages/add_comment.php");
INSERT
INTO useronline
VALUES("1430122743","88.147.153.117","/pages/add_comment.php");



DROP
TABLE IF EXISTS `views`;

CREATE TABLE `views` (
  `ip` text NOT NULL,

 `id_site` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT
CHARSET=utf8;

INSERT INTO views
VALUES("88.147.153.168","1");
INSERT INTO views
VALUES("88.147.152.120","1");
INSERT INTO views
VALUES("88.147.152.120","2");
INSERT INTO views
VALUES("88.147.152.120","3");
INSERT INTO views
VALUES("88.147.152.109","3");
INSERT INTO views
VALUES("88.147.152.109","5");
INSERT INTO views
VALUES("178.219.92.67","5");
INSERT INTO views
VALUES("87.240.182.157","5");
INSERT INTO views
VALUES("88.147.152.121","5");
INSERT INTO views
VALUES("88.147.152.120","5");
INSERT INTO views
VALUES("88.147.153.117","5");