· 8 years ago · Mar 17, 2018, 08:50 AM
1CREATE TABLE IF NOT EXISTS `keitaro_clicks` (
2 `click_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
3 `visitor_id` bigint(20) unsigned NOT NULL,
4 `sub_id` varchar(255) NOT NULL,
5 `ts_id` int(10) unsigned DEFAULT NULL,
6 `landing_id` int(10) unsigned DEFAULT NULL,
7 `landing_clicked` tinyint(1) unsigned DEFAULT '0',
8 `landing_clicked_datetime` datetime DEFAULT NULL,
9 `offer_id` int(10) unsigned DEFAULT NULL,
10 `affiliate_network_id` int(10) unsigned DEFAULT NULL,
11 `datetime` datetime NOT NULL,
12 `campaign_id` int(10) unsigned NOT NULL,
13 `parent_campaign_id` int(10) unsigned DEFAULT NULL,
14 `stream_id` int(10) unsigned DEFAULT NULL,
15 `is_unique_stream` tinyint(1) unsigned DEFAULT '0',
16 `is_unique_campaign` tinyint(1) unsigned DEFAULT '0',
17 `is_unique_global` int(1) unsigned DEFAULT '0',
18 `is_bot` tinyint(1) unsigned DEFAULT '0',
19 `is_using_proxy` tinyint(1) unsigned DEFAULT '0',
20 `is_empty_referrer` tinyint(1) unsigned DEFAULT '0',
21 `source_id` int(10) unsigned NOT NULL,
22 `referrer_id` int(10) NOT NULL,
23 `search_engine_id` int(10) DEFAULT NULL,
24 `keyword_id` int(10) unsigned DEFAULT NULL,
25 `sub_id_1_id` int(10) unsigned DEFAULT NULL,
26 `sub_id_2_id` int(10) unsigned DEFAULT NULL,
27 `sub_id_3_id` int(10) unsigned DEFAULT NULL,
28 `sub_id_4_id` int(10) unsigned DEFAULT NULL,
29 `sub_id_5_id` int(10) unsigned DEFAULT NULL,
30 `sub_id_6_id` int(10) unsigned DEFAULT NULL,
31 `sub_id_7_id` int(10) unsigned DEFAULT NULL,
32 `sub_id_8_id` int(10) unsigned DEFAULT NULL,
33 `sub_id_9_id` int(10) unsigned DEFAULT NULL,
34 `sub_id_10_id` int(10) unsigned DEFAULT NULL,
35 `sub_id_11_id` int(10) unsigned DEFAULT NULL,
36 `sub_id_12_id` int(10) unsigned DEFAULT NULL,
37 `sub_id_13_id` int(10) unsigned DEFAULT NULL,
38 `sub_id_14_id` int(10) unsigned DEFAULT NULL,
39 `sub_id_15_id` int(10) unsigned DEFAULT NULL,
40 `extra_param_1` varchar(255) DEFAULT NULL,
41 `extra_param_2` varchar(255) DEFAULT NULL,
42 `extra_param_3` varchar(255) DEFAULT NULL,
43 `extra_param_4` varchar(255) DEFAULT NULL,
44 `extra_param_5` varchar(255) DEFAULT NULL,
45 `extra_param_6` varchar(255) DEFAULT NULL,
46 `extra_param_7` varchar(255) DEFAULT NULL,
47 `extra_param_8` varchar(255) DEFAULT NULL,
48 `extra_param_9` varchar(255) DEFAULT NULL,
49 `extra_param_10` varchar(255) DEFAULT NULL,
50 `lead_revenue` decimal(13,4) NOT NULL DEFAULT '0.0000',
51 `rejected_revenue` decimal(13,4) NOT NULL DEFAULT '0.0000',
52 `sale_revenue` decimal(13,4) NOT NULL DEFAULT '0.0000',
53 `cost` decimal(13,6) NOT NULL DEFAULT '0.000000',
54 `is_lead` tinyint(1) unsigned DEFAULT '0',
55 `is_sale` tinyint(1) unsigned DEFAULT '0',
56 `is_rejected` tinyint(1) unsigned DEFAULT '0',
57 `rebills` int(10) unsigned NOT NULL DEFAULT '0',
58 `destination_id` bigint(20) unsigned DEFAULT NULL,
59 `creative_id_id` int(10) unsigned DEFAULT NULL,
60 `external_id_id` int(10) unsigned DEFAULT NULL,
61 `goal_1` tinyint(1) unsigned DEFAULT '0',
62 `goal_1_datetime` datetime DEFAULT NULL,
63 `goal_2` tinyint(1) unsigned DEFAULT '0',
64 `goal_2_datetime` datetime DEFAULT NULL,
65 `goal_3` tinyint(1) unsigned DEFAULT '0',
66 `goal_3_datetime` datetime DEFAULT NULL,
67 `goal_4` tinyint(1) unsigned DEFAULT '0',
68 `goal_4_datetime` datetime DEFAULT NULL,
69 `ad_campaign_id_id` int(10) unsigned DEFAULT NULL,
70 PRIMARY KEY (`click_id`),
71 UNIQUE KEY `sub_id` (`sub_id`),
72 KEY `datetime` (`datetime`),
73 KEY `creative_id` (`creative_id_id`),
74 KEY `external_id` (`external_id_id`),
75 KEY `landing_id` (`landing_id`),
76 KEY `offer_id` (`offer_id`),
77 KEY `stream_id` (`stream_id`),
78 KEY `keyword_id` (`keyword_id`),
79 KEY `referrer_id` (`referrer_id`),
80 KEY `ts_id` (`ts_id`),
81 KEY `sub_id_1_id` (`sub_id_1_id`),
82 KEY `sub_id_2_id` (`sub_id_2_id`),
83 KEY `sub_id_3_id` (`sub_id_3_id`),
84 KEY `sub_id_4_id` (`sub_id_4_id`),
85 KEY `sub_id_5_id` (`sub_id_5_id`),
86 KEY `sub_id_6_id` (`sub_id_6_id`),
87 KEY `sub_id_7_id` (`sub_id_7_id`),
88 KEY `sub_id_8_id` (`sub_id_8_id`),
89 KEY `sub_id_9_id` (`sub_id_9_id`),
90 KEY `sub_id_10_id` (`sub_id_10_id`),
91 KEY `destination_id` (`destination_id`),
92 KEY `campaign_id` (`campaign_id`),
93 KEY `visitor_id` (`visitor_id`),
94 KEY `source_id` (`source_id`),
95 KEY `parent_campaign_id` (`parent_campaign_id`),
96 KEY `search_engine_id` (`search_engine_id`),
97 KEY `ad_campaign_id_id` (`ad_campaign_id_id`),
98 KEY `campaign_id_datetime` (`campaign_id`,`datetime`),
99 KEY `stream_id_datetime` (`stream_id`,`datetime`),
100 KEY `ts_id_datetime` (`ts_id`,`datetime`),
101 KEY `landing_id_datetime` (`landing_id`,`datetime`),
102 KEY `offer_id_datetime` (`offer_id`,`datetime`),
103 KEY `affiliate_network_id` (`affiliate_network_id`),
104 KEY `sub_id_11_id` (`sub_id_11_id`),
105 KEY `sub_id_12_id` (`sub_id_12_id`),
106 KEY `sub_id_13_id` (`sub_id_13_id`),
107 KEY `sub_id_14_id` (`sub_id_14_id`),
108 KEY `sub_id_15_id` (`sub_id_15_id`)
109) ENGINE=InnoDB DEFAULT CHARSET=utf8;