9HPY0yvH

1-- ---
2-- Globals
3-- ---
4
5-- SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
6-- SET FOREIGN_KEY_CHECKS=0;
7
8-- ---
9-- Table 'proxies'
10-- 
11-- ---
12
13DROP TABLE IF EXISTS `proxies`;
14		
15CREATE TABLE `proxies` (
16  `addr` VARCHAR(21) NOT NULL,
17  `type` TINYINT(1) NOT NULL DEFAULT 0,
18  `anonymity` TINYINT(1) NOT NULL DEFAULT 0,
19  `created` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
20  PRIMARY KEY (`addr`)
21);
22
23-- ---
24-- Table 'checks'
25-- 
26-- ---
27
28DROP TABLE IF EXISTS `checks`;
29		
30CREATE TABLE `checks` (
31  `id` INTEGER NOT NULL AUTO_INCREMENT,
32  `proxy` VARCHAR(21) NOT NULL,
33  `is_online` TINYINT(1) NOT NULL DEFAULT 0,
34  `checked` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
35  `total_hits` SMALLINT NOT NULL DEFAULT 0,
36  `total_fails` SMALLINT NOT NULL DEFAULT 0,
37  PRIMARY KEY (`id`)
38);
39
40-- ---
41-- Foreign Keys 
42-- ---
43
44ALTER TABLE `checks` ADD FOREIGN KEY (proxy) REFERENCES `proxies` (`addr`);
45
46-- ---
47-- Table Properties
48-- ---
49
50-- ALTER TABLE `proxies` ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
51-- ALTER TABLE `checks` ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
52
53-- ---
54-- Test Data
55-- ---
56
57-- INSERT INTO `proxies` (`addr`,`type`,`anonymity`,`created`) VALUES
58-- ('','','','');
59-- INSERT INTO `checks` (`id`,`proxy`,`is_online`,`checked`,`total_hits`,`total_fails`) VALUES
60-- ('','','','','','');