· 9 years ago · Nov 11, 2016, 07:38 AM
1CREATE TABLE IF NOT EXISTS `keitaro_stats_20161111` (
2 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
3 `campaign_id` int(11) NOT NULL,
4 `stream_id` int(11) NOT NULL DEFAULT '0',
5 `destination` varchar(250) DEFAULT NULL,
6 `ip` bigint(11) DEFAULT NULL,
7 `datetime` datetime NOT NULL,
8 `country` char(2) DEFAULT NULL,
9 `region` varchar(6) DEFAULT NULL,
10 `city` varchar(60) DEFAULT NULL,
11 `user_agent` text,
12 `browser` varchar(150) DEFAULT NULL,
13 `os` varchar(100) DEFAULT NULL,
14 `lang` varchar(2) DEFAULT NULL,
15 `keyword` varchar(250) DEFAULT NULL,
16 `source` varchar(250) DEFAULT NULL,
17 `referrer` varchar(255) DEFAULT NULL,
18 `se` varchar(100) DEFAULT NULL,
19 `processed` tinyint(1) NOT NULL DEFAULT '0',
20 `isp` varchar(100) DEFAULT NULL,
21 `operator` varchar(50) DEFAULT NULL,
22 `connection_type` varchar(10) DEFAULT NULL,
23 `device_type` varchar(30) DEFAULT NULL,
24 `device_model` VARCHAR(200) DEFAULT NULL,
25 `is_bot` tinyint(1) NOT NULL DEFAULT '0',
26 `is_mobile` tinyint(1) NOT NULL DEFAULT '0',
27 `unique_campaign` tinyint(1) NOT NULL DEFAULT '0',
28 `unique_stream` tinyint(1) NOT NULL DEFAULT '0',
29
30 `geo_resolved` tinyint(1) NOT NULL DEFAULT '0',
31 `device_resolved` tinyint(1) NOT NULL DEFAULT '0',
32 `isp_resolved` tinyint(1) NOT NULL DEFAULT '0',
33
34 `revenue` decimal(13,4) unsigned DEFAULT '0.0000',
35 `cost` decimal(13,4) unsigned DEFAULT '0.0000',
36
37 `sub_id` varchar(30) DEFAULT NULL,
38 `sub_id_1` varchar(255) DEFAULT NULL,
39 `sub_id_2` varchar(255) DEFAULT NULL,
40 `sub_id_3` varchar(255) DEFAULT NULL,
41 `sub_id_4` varchar(255) DEFAULT NULL,
42 `extra_param_1` varchar(255) DEFAULT NULL,
43 `extra_param_2` varchar(255) DEFAULT NULL,
44 `extra_param_3` varchar(255) DEFAULT NULL,
45 `extra_param_4` varchar(255) DEFAULT NULL,
46 `extra_param_5` varchar(255) DEFAULT NULL,
47 `extra_param_6` varchar(255) DEFAULT NULL,
48 `extra_param_7` varchar(255) DEFAULT NULL,
49 PRIMARY KEY (`id`),
50 KEY `campaign_id` (`campaign_id`),
51 KEY `sub_id` (`sub_id`),
52 KEY `processed` (`processed`)
53) ENGINE=InnoDB DEFAULT CHARSET=utf8;