pZKPpvev

1-- Adminer 4.2.4 MySQL dump
2
3SET NAMES utf8;
4SET time_zone = '+00:00';
5
6DROP TABLE IF EXISTS `autosurf_jobs`;
7CREATE TABLE `autosurf_jobs` (
8  `id` int(11) NOT NULL AUTO_INCREMENT,
9  `restartTime` int(11) NOT NULL,
10  `url` varchar(255) NOT NULL,
11  `country` varchar(5) NOT NULL,
12  `script` text NOT NULL,
13  `useScript` tinyint(1) NOT NULL,
14  PRIMARY KEY (`id`)
15) ENGINE=InnoDB DEFAULT CHARSET=latin1;
16
17
18DROP TABLE IF EXISTS `jobs`;
19CREATE TABLE `jobs` (
20  `id` int(11) NOT NULL AUTO_INCREMENT,
21  `name` varchar(100) NOT NULL,
22  `prio` tinyint(1) NOT NULL,
23  `url` varchar(255) NOT NULL,
24  `referer` varchar(255) NOT NULL,
25  `visits` int(11) NOT NULL,
26  `visits_left` int(11) NOT NULL,
27  `reloadlock` int(11) NOT NULL,
28  `visitors_time` int(11) NOT NULL,
29  `visitors_country` varchar(6) NOT NULL,
30  `blockDACH` tinyint(1) NOT NULL,
31  `mining_per_hour` int(11) NOT NULL,
32  `custom_javascript` varchar(2555) NOT NULL,
33  PRIMARY KEY (`id`)
34) ENGINE=InnoDB DEFAULT CHARSET=latin1;
35
36
37DROP TABLE IF EXISTS `protocol`;
38CREATE TABLE `protocol` (
39  `jobid` int(11) NOT NULL,
40  `time` int(50) NOT NULL,
41  KEY `jobid` (`jobid`)
42) ENGINE=InnoDB DEFAULT CHARSET=latin1;
43
44
45DROP TABLE IF EXISTS `proxies`;
46CREATE TABLE `proxies` (
47  `ip` varchar(15) NOT NULL,
48  `geoiptool` varchar(2) NOT NULL,
49  `ip2c` varchar(2) NOT NULL,
50  `port` int(6) NOT NULL,
51  `lastPing` int(40) NOT NULL,
52  PRIMARY KEY (`ip`)
53) ENGINE=InnoDB DEFAULT CHARSET=latin1;
54
55
56DROP TABLE IF EXISTS `reloadlock`;
57CREATE TABLE `reloadlock` (
58  `uniqueid` varchar(36) NOT NULL DEFAULT '',
59  `jobid` int(11) NOT NULL,
60  `ip` varchar(16) NOT NULL,
61  `lastvisit` int(50) NOT NULL,
62  KEY `jobid_ip` (`jobid`,`ip`)
63) ENGINE=InnoDB DEFAULT CHARSET=latin1;
64
65
66DELIMITER ;;
67
68CREATE TRIGGER `reloadlock_ai` AFTER INSERT ON `reloadlock` FOR EACH ROW
69INSERT INTO protocol (jobid, time) VALUES (NEW.jobid, NEW.lastvisit);;
70
71DELIMITER ;
72
73-- 2016-04-07 18:43:12