Файл: obmennik/flowap.sql
Строк: 79
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=2 DEFAULT CHARSET=utf8;
INSERT INTO load_dir
VALUES("1","0","0","ауау","","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,
`flo` varchar(17) NOT NULL,
`imp` int(1) NOT NULL DEFAULT '0',
`pass` varchar(10) NOT NULL,
`size`
varchar(20) NOT NULL DEFAULT '0',
`loads` int(5) NOT NULL DEFAULT '0',
`flo2` varchar(17) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM
AUTO_INCREMENT=130 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS
`load_ka4`;
CREATE TABLE `load_ka4` (
`id` int(11) NOT NULL
AUTO_INCREMENT,
`load` int(11) DEFAULT NULL,
`time` int(11) DEFAULT
NULL,
`ip` varchar(50) DEFAULT NULL,
`browser` varchar(500) DEFAULT
NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=53 DEFAULT
CHARSET=utf8;
INSERT INTO load_ka4
VALUES("1","122","1418302904","5.142.112.88","Mozilla/5.0
(Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/39.0.2171.71
Safari/537.36");
INSERT INTO load_ka4
VALUES("2","122","1418302952","5.142.112.88","Mozilla/5.0
(Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/39.0.2171.71
Safari/537.36");
INSERT INTO load_ka4
VALUES("3","120","1418305040","94.22.125.164","Mozilla/5.0
(compatible; MJ12bot/v1.4.5;
http://www.majestic12.co.uk/bot.php?+)");
INSERT INTO load_ka4
VALUES("4","118","1418308370","188.162.229.208","Mozilla/5.0
(Windows NT 6.3; WOW64) AppleWebKit/537.36 (KHTML, like Gecko)
Chrome/39.0.2171.71 Safari/537.36");
INSERT INTO load_ka4
VALUES("5","120","1418315087","66.249.69.14","DoCoMo/2.0
N905i(c100;TB;W24H16) (compatible; Googlebot-Mobile/2.1;
+http://www.google.com/bot.html)");
INSERT INTO load_ka4
VALUES("6","121","1418315156","66.249.69.18","DoCoMo/2.0
N905i(c100;TB;W24H16) (compatible; Googlebot-Mobile/2.1;
+http://www.google.com/bot.html)");
INSERT INTO load_ka4
VALUES("7","120","1418328164","91.122.253.96","Mozilla/5.0
(Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/39.0.2171.71
Safari/537.36");
INSERT INTO load_ka4
VALUES("8","120","1418328167","91.122.253.96","Mozilla/5.0
(Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/39.0.2171.71
Safari/537.36");
INSERT INTO load_ka4
VALUES("9","121","1418328307","91.122.253.96","Mozilla/5.0
(Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/39.0.2171.71
Safari/537.36");
INSERT INTO load_ka4
VALUES("10","119","1418328353","91.122.253.96","Mozilla/5.0
(Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/39.0.2171.71
Safari/537.36");
INSERT INTO load_ka4
VALUES("11","119","1418328405","91.122.253.96","Mozilla/5.0
(Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/39.0.2171.71
Safari/537.36");
INSERT INTO load_ka4
VALUES("12","121","1418328723","91.122.253.96","Mozilla/5.0
(Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/39.0.2171.71
Safari/537.36");
INSERT INTO load_ka4
VALUES("13","118","1418334721","136.243.5.215","Mozilla/5.0
(compatible; MJ12bot/v1.4.5;
http://www.majestic12.co.uk/bot.php?+)");
INSERT INTO load_ka4
VALUES("14","119","1418334731","136.243.5.215","Mozilla/5.0
(compatible; MJ12bot/v1.4.5;
http://www.majestic12.co.uk/bot.php?+)");
INSERT INTO load_ka4
VALUES("15","120","1418345626","66.249.69.18","SAMSUNG-SGH-E250/1.0
Profile/MIDP-2.0 Configuration/CLDC-1.1 UP.Browser/6.2.3.3.c.1.101 (GUI)
MMP/2.0 (compatible; Googlebot-Mobile/2.1;
+http://www.google.com/bot.html)");
INSERT INTO load_ka4
VALUES("16","121","1418345878","66.249.69.14","SAMSUNG-SGH-E250/1.0
Profile/MIDP-2.0 Configuration/CLDC-1.1 UP.Browser/6.2.3.3.c.1.101 (GUI)
MMP/2.0 (compatible; Googlebot-Mobile/2.1;
+http://www.google.com/bot.html)");
INSERT INTO load_ka4
VALUES("17","121","1418361394","178.186.135.161","Mozilla/5.0
(Windows NT 6.2; WOW64) AppleWebKit/537.36 (KHTML, like Gecko)
Chrome/39.0.2171.95 Safari/537.36");
INSERT INTO load_ka4
VALUES("18","124","1418369384","82.145.221.46","Opera/9.80
(SpreadTrum; Opera Mini/4.4.31492/35.6172; U; ru) Presto/2.8.119
Version/11.10");
INSERT INTO load_ka4
VALUES("19","124","1418369400","82.145.221.46","Opera/9.80
(SpreadTrum; Opera Mini/4.4.31492/35.6172; U; ru) Presto/2.8.119
Version/11.10");
INSERT INTO load_ka4
VALUES("20","124","1418369418","82.145.221.46","Opera/9.80
(SpreadTrum; Opera Mini/4.4.31492/35.6172; U; ru) Presto/2.8.119
Version/11.10");
INSERT INTO load_ka4
VALUES("21","124","1418369424","82.145.221.46","Opera/9.80
(SpreadTrum; Opera Mini/4.4.31492/35.6172; U; ru) Presto/2.8.119
Version/11.10");
INSERT INTO load_ka4
VALUES("22","82","1418385616","188.165.15.95","Mozilla/5.0
(compatible; AhrefsBot/5.0; +http://ahrefs.com/robot/)");
INSERT INTO
load_ka4
VALUES("23","124","1418388962","83.149.19.163","Mozilla/5.0
(Linux; U; Android 2.2.2; ru-ru; Desire_A8181 Build/FRG83G)
AppleWebKit/533.1 (KHTML, like Gecko) Version/4.0 Mobile
Safari/533.1");
INSERT INTO load_ka4
VALUES("24","121","1418388999","83.149.19.163","Mozilla/5.0
(Linux; U; Android 2.2.2; ru-ru; Desire_A8181 Build/FRG83G)
AppleWebKit/533.1 (KHTML, like Gecko) Version/4.0 Mobile
Safari/533.1");
INSERT INTO load_ka4
VALUES("25","80","1418410722","188.165.15.169","Mozilla/5.0
(compatible; AhrefsBot/5.0; +http://ahrefs.com/robot/)");
INSERT INTO
load_ka4
VALUES("26","85","1418424156","188.165.15.231","Mozilla/5.0
(compatible; AhrefsBot/5.0; +http://ahrefs.com/robot/)");
INSERT INTO
load_ka4
VALUES("27","121","1418436096","195.189.123.174","Nokia7230/5.0
(06.90) Profile/MIDP-2.1 Configuration/CLDC-1.1 UCWEB/2.0 (Java; U;
MIDP-2.0; ru; Nokia7230) U2/1.0.0 UCBrowser/9.4.1.377 U2/1.0.0
Mobile");
INSERT INTO load_ka4
VALUES("28","121","1418452643","85.113.51.121","Mozilla/5.0
(iPhone; CPU iPhone OS 8_1_1 like Mac OS X) AppleWebKit/600.1.4 (KHTML,
like Gecko) Mobile/12B435");
INSERT INTO load_ka4
VALUES("29","121","1418474019","136.243.5.219","Mozilla/5.0
(compatible; MJ12bot/v1.4.5;
http://www.majestic12.co.uk/bot.php?+)");
INSERT INTO load_ka4
VALUES("30","122","1418474022","136.243.5.219","Mozilla/5.0
(compatible; MJ12bot/v1.4.5;
http://www.majestic12.co.uk/bot.php?+)");
INSERT INTO load_ka4
VALUES("31","123","1418474026","136.243.5.219","Mozilla/5.0
(compatible; MJ12bot/v1.4.5;
http://www.majestic12.co.uk/bot.php?+)");
INSERT INTO load_ka4
VALUES("32","124","1418474033","136.243.5.219","Mozilla/5.0
(compatible; MJ12bot/v1.4.5;
http://www.majestic12.co.uk/bot.php?+)");
INSERT INTO load_ka4
VALUES("33","120","1418474054","136.243.5.219","Mozilla/5.0
(compatible; MJ12bot/v1.4.5;
http://www.majestic12.co.uk/bot.php?+)");
INSERT INTO load_ka4
VALUES("34","121","1418474058","136.243.5.219","Mozilla/5.0
(compatible; MJ12bot/v1.4.5;
http://www.majestic12.co.uk/bot.php?+)");
INSERT INTO load_ka4
VALUES("35","122","1418474074","136.243.5.219","Mozilla/5.0
(compatible; MJ12bot/v1.4.5;
http://www.majestic12.co.uk/bot.php?+)");
INSERT INTO load_ka4
VALUES("36","123","1418474080","136.243.5.219","Mozilla/5.0
(compatible; MJ12bot/v1.4.5;
http://www.majestic12.co.uk/bot.php?+)");
INSERT INTO load_ka4
VALUES("37","124","1418474085","136.243.5.219","Mozilla/5.0
(compatible; MJ12bot/v1.4.5;
http://www.majestic12.co.uk/bot.php?+)");
INSERT INTO load_ka4
VALUES("38","128","1418501057","82.145.220.138","Opera/9.80
(Series 60; Opera Mini/7.1.32444/35.6172; U; ru) Presto/2.8.119
Version/11.10");
INSERT INTO load_ka4
VALUES("39","122","1418511754","66.249.78.168","Mozilla/5.0
(compatible; Googlebot/2.1; +http://www.google.com/bot.html)");
INSERT
INTO load_ka4
VALUES("40","119","1418512375","66.249.78.168","Mozilla/5.0
(compatible; Googlebot/2.1; +http://www.google.com/bot.html)");
INSERT
INTO load_ka4
VALUES("41","123","1418512377","66.249.78.175","Mozilla/5.0
(compatible; Googlebot/2.1; +http://www.google.com/bot.html)");
INSERT
INTO load_ka4
VALUES("42","120","1418512382","66.249.78.175","Mozilla/5.0
(compatible; Googlebot/2.1; +http://www.google.com/bot.html)");
INSERT
INTO load_ka4
VALUES("43","121","1418512384","66.249.78.175","Mozilla/5.0
(compatible; Googlebot/2.1; +http://www.google.com/bot.html)");
INSERT
INTO load_ka4
VALUES("44","127","1418512385","66.249.78.161","Mozilla/5.0
(compatible; Googlebot/2.1; +http://www.google.com/bot.html)");
INSERT
INTO load_ka4
VALUES("45","125","1418512390","66.249.78.168","Mozilla/5.0
(compatible; Googlebot/2.1; +http://www.google.com/bot.html)");
INSERT
INTO load_ka4
VALUES("46","124","1418512455","66.249.78.175","Mozilla/5.0
(compatible; Googlebot/2.1; +http://www.google.com/bot.html)");
INSERT
INTO load_ka4
VALUES("47","126","1418512456","66.249.78.168","Mozilla/5.0
(compatible; Googlebot/2.1; +http://www.google.com/bot.html)");
INSERT
INTO load_ka4
VALUES("48","121","1418513479","178.197.225.24","Mozilla/5.0
(iPhone; U; CPU iPhone OS 4_1 like Mac OS X; de-de) AppleWebKit/532.9
(KHTML, like Gecko) Version/4.0.5 Mobile/8B117
Safari/6531.22.7");
INSERT INTO load_ka4
VALUES("49","121","1418522800","2.148.148.145","Mozilla/5.0
(Linux; U; Android 4.1.2; nb-no; LG-E430 Build/JZO54K) AppleWebKit/534.30
(KHTML, like Gecko) Version/4.0 Mobile Safari/534.30");
INSERT INTO
load_ka4
VALUES("50","128","1418528343","185.26.180.13","Opera/9.80
(J2ME/MIDP; Opera Mini/4.2.13337/35.6172; U; ru) Presto/2.8.119
Version/11.10");
INSERT INTO load_ka4
VALUES("51","121","1418528390","185.26.180.13","Opera/9.80
(J2ME/MIDP; Opera Mini/4.2.13337/35.6172; U; ru) Presto/2.8.119
Version/11.10");
INSERT INTO load_ka4
VALUES("52","129","1418548366","95.53.97.36","Mozilla/5.0
(Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/39.0.2171.95
Safari/537.36");
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","StrongCMS.RU","StrongCMS.RU","StrongCMS.RU");
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,
`email` varchar(40) 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,
`max` int(30) NOT
NULL DEFAULT '10',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=39
DEFAULT CHARSET=utf8;