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.
66.
67.
68.
69.
70.
71.
72.
73.
74.
75.
76.
CREATE TABLE `campaigns` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`geo` varchar(4) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`is_active` enum('T','F','D','M','H','V','R','W','C','A','S','K','I') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`link` longtext COLLATE utf8mb4_unicode_ci,
`daily_limit` int(11) NOT NULL DEFAULT '0',
`installed_today` int(11) NOT NULL DEFAULT '0',
`clicked_today` int(11) NOT NULL DEFAULT '0',
`comment` longtext COLLATE utf8mb4_unicode_ci,
`install_start_time` datetime DEFAULT NULL,
`geofactor` double NOT NULL DEFAULT '1',
`fail_detection_app_count` int(11) NOT NULL DEFAULT '0',
`fail_detection_fail_count` int(11) NOT NULL DEFAULT '0',
`continue_on_fail` enum('T','F') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'F',
`disbable_cr_notice` enum('T','F') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'F',
`appnet` int(11) DEFAULT NULL,
`sub_aff_grp` int(11) NOT NULL DEFAULT '0',
`install_payout` double(5,2) DEFAULT NULL,
`consecutive_fails` int(11) NOT NULL DEFAULT '0',
`consecutive_install_fails` int(11) NOT NULL DEFAULT '0',
`failed_today` int(11) NOT NULL DEFAULT '0',
`failed_installs_today` int(11) NOT NULL DEFAULT '0',
`consecutive_fails_limit` int(11) NOT NULL DEFAULT '0',
`daily_cr_factor` float NOT NULL DEFAULT '1',
`identifier` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`store_ver` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`store_ver_update_date` date DEFAULT NULL,
`appinfo_id` int(11) DEFAULT NULL,
`campaign_appnet_id` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`is_incent` enum('T','F') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'F',
`min_daily_cr` float DEFAULT NULL,
`max_daily_cr` float DEFAULT NULL,
`panic_daily_cr` float DEFAULT NULL,
`min_daily_pay` float DEFAULT NULL,
`max_daily_pay` float DEFAULT NULL,
`ip_repeat_failure` int(11) NOT NULL DEFAULT '0',
`paused_until` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
`campaign_preset` int(11) DEFAULT NULL,
`cr_fix_factor` float NOT NULL DEFAULT '1',
`cr_fix_too_big` enum('F','T') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'F',
`target_fix_too_big` enum('F','T') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'F',
`cr` double(4,4) NOT NULL DEFAULT '0.0000',
`day_of_week_factor` double NOT NULL DEFAULT '1',
`failed_active_campaign_tests` int(11) NOT NULL DEFAULT '0',
`installs_target_fix_factor` double NOT NULL DEFAULT '1',
`targeted_cr` double(4,4) DEFAULT NULL,
`targeted_daily_limit` double DEFAULT NULL,
`last_is_active_change` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
`dont_stop_until` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
`auto_insert_debug_info` mediumtext COLLATE utf8mb4_unicode_ci,
`latest_install_date` datetime DEFAULT NULL,
`appnet_notes` longtext COLLATE utf8mb4_unicode_ci,
`insert_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`update_date` datetime DEFAULT NULL,
`just_auto_added` enum('T','F') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'F',
`auto_insert_comment` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`is_new_offers_insert` enum('F','T') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'F',
`is_do_not_disabled_by_counterpart` enum('T','F') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'F',
`target_clicks_fix_factor` double NOT NULL DEFAULT '1',
`target_installs_fix_factor` double NOT NULL DEFAULT '1',
`retry_counter` int(11) NOT NULL DEFAULT '0',
`last_factor_fix_datetime` datetime NOT NULL DEFAULT '1978-01-01 00:00:00',
`is_cr_panic` enum('T','F','H') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'F',
PRIMARY KEY (`id`),
UNIQUE KEY `appnet` (`appnet`,`appinfo_id`),
KEY `geo` (`geo`),
KEY `is_active` (`is_active`),
KEY `install_start_time` (`install_start_time`),
KEY `appnet_key` (`appnet`),
KEY `appinfo` (`appinfo_id`),
KEY `appinfo_id` (`appinfo_id`),
KEY `identifier` (`identifier`),
KEY `campaign_appnet_id` (`campaign_appnet_id`),
KEY `campaign_appnet_id_2` (`campaign_appnet_id`,`identifier`),
KEY `geo_2` (`geo`)
) ENGINE=MyISAM AUTO_INCREMENT=204292 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci |
