Файл: baza.sql
Строк: 181
DROP TABLE IF EXISTS `files_dir`;
CREATE TABLE `files_dir` (
`id`
int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(64) NOT NULL,
`dir`
varchar(1024) NOT NULL DEFAULT '/',
`dirs` varchar(1024) DEFAULT '/',
`positions` int(11) DEFAULT '0',
`incert` int(11) NOT NULL DEFAULT '0',
`upload` set('1','0') NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY
`num` (`positions`),
KEY `dir` (`dir`(333))
) ENGINE=MyISAM
AUTO_INCREMENT=37 DEFAULT CHARSET=utf8;
INSERT INTO files_dir
VALUES("1","Порно
Видео","/Porno_Video/","/","0","1","0");
INSERT
INTO files_dir VALUES("2","Большая
жопа","/Porno_Video/Bolshaja_zhopa/","/Porno_Video/","0","1","1");
INSERT
INTO files_dir
VALUES("3","Жены","/Porno_Video/ZHeny/","/Porno_Video/","0","1","1");
INSERT
INTO files_dir
VALUES("4","Жены","/Porno_Video/ZHeny/","/Porno_Video/","0","1","1");
INSERT
INTO files_dir
VALUES("5","Зрелые","/Porno_Video/Zrelye/","/Porno_Video/","0","1","1");
INSERT
INTO files_dir VALUES("6","Русское
порно","/Porno_Video/Russkoe_porno/","/Porno_Video/","0","1","1");
INSERT
INTO files_dir
VALUES("7","Порнофильмы","/Porno_Video/Pornofilmy/","/Porno_Video/","0","1","1");
INSERT
INTO files_dir VALUES("8","Порно
Фото","/Porno_Foto/","/","0","8","0");
INSERT
INTO files_dir
VALUES("9","Азиатки","/Porno_Foto/Aziatki/","/Porno_Foto/","0","8","1");
INSERT
INTO files_dir
VALUES("10","Бикини","/Porno_Foto/Bikini/","/Porno_Foto/","0","8","1");
INSERT
INTO files_dir VALUES("11","Большая
грудь","/Porno_Foto/Bolshaja_grud/","/Porno_Foto/","0","8","1");
INSERT
INTO files_dir VALUES("12","В
бане","/Porno_Foto/V_bane/","/Porno_Foto/","0","8","1");
INSERT
INTO files_dir VALUES("13","В
душе","/Porno_Foto/V_dushe/","/Porno_Foto/","0","8","1");
INSERT
INTO files_dir VALUES("14","В
чулках","/Porno_Foto/V_chulkah/","/Porno_Foto/","0","8","1");
INSERT
INTO files_dir
VALUES("15","Гермафродиты","/Porno_Foto/Germafrodity/","/Porno_Foto/","0","8","1");
INSERT
INTO files_dir VALUES("16","Голые
мулатки","/Porno_Foto/Golye_mulatki/","/Porno_Foto/","0","8","1");
INSERT
INTO files_dir VALUES("17","Голые
парни","/Porno_Foto/Golye_parni/","/Porno_Foto/","0","8","1");
INSERT
INTO files_dir
VALUES("18","Групповуха","/Porno_Foto/Gruppovuha/","/Porno_Foto/","0","8","1");
INSERT
INTO files_dir VALUES("19","Двойное
проникновение","/Porno_Foto/Dvojnoe_proniknovenie/","/Porno_Foto/","0","8","1");
INSERT
INTO files_dir VALUES("20","Девушки 18
лет","/Porno_Foto/Devushki_18_let/","/Porno_Foto/","0","8","1");
INSERT
INTO files_dir VALUES("21","Жесткий
секс","/Porno_Foto/ZHestkij_seks/","/Porno_Foto/","0","8","1");
INSERT
INTO files_dir
VALUES("22","Знаменитости","/Porno_Foto/Znamenitosti/","/Porno_Foto/","0","8","1");
INSERT
INTO files_dir
VALUES("23","Извращения","/Porno_Foto/Izvraschenija/","/Porno_Foto/","0","8","1");
INSERT
INTO files_dir
VALUES("24","Кунилингус","/Porno_Foto/Kunilingus/","/Porno_Foto/","0","8","1");
INSERT
INTO files_dir
VALUES("25","Лесбиянки","/Porno_Foto/Lesbijanki/","/Porno_Foto/","0","8","1");
INSERT
INTO files_dir VALUES("26","Мойщицы
машин","/Porno_Foto/Mojschicy_mashin/","/Porno_Foto/","0","8","1");
INSERT
INTO files_dir
VALUES("27","Нудисты","/Porno_Foto/Nudisty/","/Porno_Foto/","0","8","1");
INSERT
INTO files_dir VALUES("28","Огромные
члены","/Porno_Foto/Ogromnye_chleny/","/Porno_Foto/","0","8","1");
INSERT
INTO files_dir
VALUES("29","Писи","/Porno_Foto/Pisi/","/Porno_Foto/","0","8","1");
INSERT
INTO files_dir
VALUES("30","Писсинг","/Porno_Foto/Pissing/","/Porno_Foto/","0","8","1");
INSERT
INTO files_dir VALUES("31","Приватные
фото","/Porno_Foto/Privatnye_foto/","/Porno_Foto/","0","8","1");
INSERT
INTO files_dir
VALUES("32","Рыжие","/Porno_Foto/Ryzhie/","/Porno_Foto/","0","8","1");
INSERT
INTO files_dir
VALUES("33","Секретарши","/Porno_Foto/Sekretarshi/","/Porno_Foto/","0","8","1");
INSERT
INTO files_dir VALUES("34","Секс
игрушки","/Porno_Foto/Seks_igrushki/","/Porno_Foto/","0","8","1");
INSERT
INTO files_dir VALUES("35","Сосут
член","/Porno_Foto/Sosut_chlen/","/Porno_Foto/","0","8","1");
INSERT
INTO files_dir VALUES("36","Узбекское порно
","/Porno_Video/Uzbekskoe_porno_/","/Porno_Video/","0","1","1");
DROP
TABLE IF EXISTS `files_file`;
CREATE TABLE `files_file` (
`id` int(11)
NOT NULL AUTO_INCREMENT,
`id_user` int(11) NOT NULL,
`id_dir` int(11)
NOT NULL,
`name` varchar(128) NOT NULL,
`file` varchar(100) NOT NULL,
`type` varchar(64) NOT NULL,
`time` int(11) NOT NULL,
`time_last`
int(11) NOT NULL,
`size` int(11) NOT NULL,
`dir_index` int(11) DEFAULT
NULL,
`loads` int(11) DEFAULT '0',
`opis` text NOT NULL,
`screen`
varchar(100) DEFAULT NULL,
`incert` int(11) DEFAULT '0',
`moder`
int(11) DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5
DEFAULT CHARSET=utf8;
INSERT INTO files_file
VALUES("1","1","7","бухой","1.3gp","3gp","1487838774","0","5316939","","0","залил
с головы до
ног","","1","1");
INSERT INTO
files_file
VALUES("2","1","29","Атена","1.jpg","jpg","1487839572","0","20003","0","1","атена","1.jpg","8","1");
INSERT
INTO files_file
VALUES("3","1","29","Атена1","1-1.jpg","jpg","1487839606","0","17417","0","1","атена1","1-1.jpg","8","1");
INSERT
INTO files_file
VALUES("4","1","36","Узбечка","Qanju.ru_uzbechka_sost_huy.mp4","mp4","1487842103","0","1637692","","1","Молодая
узбечка сосет член своего
друга","","1","1");
DROP TABLE
IF EXISTS `guest`;
CREATE TABLE `guest` (
`ip` varchar(50) NOT NULL,
`date_last` int(11) NOT NULL,
KEY `ip_2` (`ip`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8;
INSERT INTO guest
VALUES("141.0.14.41","1487854382");
INSERT INTO guest
VALUES("","1487852217");
INSERT INTO guest
VALUES("69.30.198.186","1487843709");
INSERT INTO guest
VALUES("141.0.15.96","1487860858");
INSERT INTO guest
VALUES("130.193.51.21","1487872137");
INSERT INTO guest
VALUES("141.8.142.147","1487872141");
INSERT INTO guest
VALUES("130.193.51.72","1487872284");
INSERT INTO guest
VALUES("93.158.152.28","1487872289");
INSERT INTO guest
VALUES("91.121.97.49","1487875166");
INSERT INTO guest
VALUES("141.0.14.237","1487877276");
DROP TABLE IF
EXISTS `mchat`;
CREATE TABLE `mchat` (
`id` int(11) NOT NULL
AUTO_INCREMENT,
`id_user` int(11) NOT NULL DEFAULT '0',
`time` int(11)
NOT NULL,
`msg` varchar(1024) CHARACTER SET utf8 COLLATE utf8_unicode_ci
DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `time` (`time`)
) ENGINE=MyISAM
AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
INSERT INTO mchat
VALUES("1","1","1487857230","test");
INSERT
INTO mchat
VALUES("2","1","1487857281","testt");
DROP
TABLE IF EXISTS `news`;
CREATE TABLE `news` (
`id` int(11) NOT NULL
AUTO_INCREMENT,
`title` varchar(255) NOT NULL,
`text` text NOT NULL,
`time` int(11) NOT NULL DEFAULT '0',
`times` int(11) NOT NULL DEFAULT
'0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT
CHARSET=utf8;
INSERT INTO news
VALUES("1","new","new new
new","1487847764","1487934164");
DROP TABLE IF
EXISTS `settings`;
CREATE TABLE `settings` (
`name` varchar(60) NOT
NULL,
`value` varchar(10000) NOT NULL
) ENGINE=MyISAM DEFAULT
CHARSET=utf8;
INSERT INTO settings
VALUES("title","ARHILES");
INSERT INTO settings
VALUES("upload_size","20969999");
INSERT INTO settings
VALUES("upload_format","\"jpg\",
\"jpeg\", \"gif\", \"png\",
\"webp\", \"zip\", \"rar\",
\"tar\", \"mp3\", \"flac\",
\"mp4\", \"3gp\", \"avi\", \"mvk\",
\"apk\", \"jar\", \"jad\"");
INSERT INTO
settings VALUES("upload_moder","1");
INSERT INTO
settings VALUES("page_str","50");
INSERT INTO settings
VALUES("max_name","20");
INSERT INTO settings
VALUES("max_opis","500");
INSERT INTO settings
VALUES("title","ARHILES");
INSERT INTO settings
VALUES("upload_size","20969999");
INSERT INTO settings
VALUES("upload_format","\"jpg\",
\"jpeg\", \"gif\", \"png\",
\"webp\", \"zip\", \"rar\",
\"tar\", \"mp3\", \"flac\",
\"mp4\", \"3gp\", \"avi\", \"mvk\",
\"apk\", \"jar\", \"jad\"");
INSERT INTO
settings VALUES("upload_moder","1");
INSERT INTO
settings VALUES("page_str","50");
INSERT INTO settings
VALUES("max_name","20");
INSERT INTO settings
VALUES("max_opis","500");
DROP TABLE IF EXISTS
`users`;
CREATE TABLE `users` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`login` varchar(255) NOT NULL,
`pass` varchar(255) NOT NULL,
`sex`
int(1) NOT NULL DEFAULT '0',
`access` int(1) NOT NULL DEFAULT '0',
`date_last` int(11) NOT NULL DEFAULT '0',
`data_reg` int(11) NOT NULL
DEFAULT '0',
`info` varchar(1200) DEFAULT NULL,
`email` varchar(50)
DEFAULT NULL,
`icq` varchar(11) DEFAULT NULL,
`name` varchar(50)
DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT
CHARSET=utf8;
INSERT INTO users
VALUES("1","ARHILES","123456","0","2","1487877356","0","","","","");
DROP
TABLE IF EXISTS `worldkassa`;
CREATE TABLE `worldkassa` (
`id` int(11)
unsigned NOT NULL AUTO_INCREMENT COMMENT 'Внутренний ID
платежа',
`id_bill` int(11) unsigned NOT NULL COMMENT 'ID
платежа в Worldkassa',
`init` timestamp NOT NULL DEFAULT
CURRENT_TIMESTAMP COMMENT 'Время инициализации
платежа',
`payment` datetime NOT NULL COMMENT 'Время
оплаты',
`summa` decimal(11,2) NOT NULL DEFAULT '0.00' COMMENT
'Сумма',
`days` int(11) NOT NULL DEFAULT '0' COMMENT
'Количество дней',
`expire` datetime NOT NULL COMMENT
'Истекает',
`url` varchar(50) NOT NULL COMMENT 'Адрес
сайта',
`name` varchar(32) NOT NULL COMMENT 'Название
ссылки',
`color` varchar(20) NOT NULL COMMENT 'Цвет
ссылки',
`bold` tinyint(1) NOT NULL DEFAULT '0' COMMENT
'Жирный',
`italic` tinyint(1) NOT NULL DEFAULT '0' COMMENT
'Курсивный',
PRIMARY KEY (`id`),
KEY `time_expire`
(`expire`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8
COMMENT='Статистика платежей через
WorldKassa';
INSERT INTO worldkassa
VALUES("1","746954","2017-04-10
08:01:56","2017-03-10
08:02:01","700.00","70","2017-03-21
08:02:01","http://arhiles.top","ARHILES.TOP
Рейтинг
сайтов!","indigo","1","0");