-
Notifications
You must be signed in to change notification settings - Fork 2
/
falling-sky-chart.sql
65 lines (61 loc) · 3.27 KB
/
falling-sky-chart.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
DROP TABLE IF EXISTS `stats`;
DROP TABLE IF EXISTS `survey`;
CREATE TABLE `survey` (
`cookie` char(80) character set latin1 default NULL,
`ip` char(40) character set latin1 NOT NULL,
`ip4` char(40) character set latin1 default NULL,
`ip6` char(40) character set latin1 default NULL,
`status_a` enum('ok','slow','bad','timeout','skipped','undef','unknown') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
`status_aaaa` enum('ok','slow','bad','timeout','skipped','undef','unknown') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
`status_ds4` enum('ok','slow','bad','timeout','skipped','undef','unknown') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
`status_ds6` enum('ok','slow','bad','timeout','skipped','undef','unknown') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
`status_ipv4` enum('ok','slow','bad','timeout','skipped','undef','unknown') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
`status_ipv6` enum('ok','slow','bad','timeout','skipped','undef','unknown') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
`status_v6ns` enum('ok','slow','bad','timeout','skipped','undef','unknown') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
`status_v6mtu` enum('ok','slow','bad','timeout','skipped','undef','unknown') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
`status_dsmtu` enum('ok','slow','bad','timeout','unknown','skipped','undef') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
`time_a` mediumint DEFAULT NULL,
`time_aaaa` mediumint DEFAULT NULL,
`time_ds4` mediumint DEFAULT NULL,
`time_ds6` mediumint DEFAULT NULL,
`time_ipv4` mediumint DEFAULT NULL,
`time_ipv6` mediumint DEFAULT NULL,
`time_v6ns` mediumint DEFAULT NULL,
`time_v6mtu` mediumint DEFAULT NULL,
`time_dsmtu` mediumint DEFAULT NULL,
`tokens` char(200) character set latin1 default NULL,
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
`ua_id` int(11) default NULL,
`ix` bigint(20) unsigned NOT NULL auto_increment,
PRIMARY KEY (`ix`),
KEY `status_a` (`status_a`),
KEY `status_aaaa` (`status_aaaa`),
KEY `status_ds4` (`status_ds4`),
KEY `status_ds6` (`status_ds6`),
KEY `status_ipv4` (`status_ipv4`),
KEY `status_ipv6` (`status_ipv6`),
KEY `timestamp` (`timestamp`),
KEY `status_v6mtu` (`status_v6mtu`)
) ENGINE=MyISAM AUTO_INCREMENT=220869 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `user_agent`;
DROP TABLE IF EXISTS `user_agents`;
CREATE TABLE `user_agents` (
`id` int(11) NOT NULL auto_increment,
`user_agent` varchar(255) character set latin1 NOT NULL,
UNIQUE KEY `user_agent` (`user_agent`),
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=23798 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `daily_summary`;
CREATE TABLE `daily_summary` (
`datestamp` date NOT NULL,
`total` int(10) unsigned default NULL,
`tokens` char(200) character set latin1 default NULL,
KEY `datestamp` (`datestamp`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `monthly_summary`;
CREATE TABLE `monthly_summary` (
`datestamp` date NOT NULL,
`total` int(10) unsigned default NULL,
`tokens` char(200) character set latin1 default NULL,
KEY `datestamp` (`datestamp`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;