-
Notifications
You must be signed in to change notification settings - Fork 21
/
campaign_schedule.sql
executable file
·41 lines (41 loc) · 8.09 KB
/
campaign_schedule.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
CREATE TABLE 'campaign_schedule' ('id' INTEGER NOT NULL, 'campaign_category' INTEGER NOT NULL, 'value' REAL NOT NULL, 'system_id' INTEGER NOT NULL, 'icon_image' INTEGER NOT NULL, 'start_time' TEXT NOT NULL, 'end_time' TEXT NOT NULL, PRIMARY KEY('id'));
INSERT INTO `campaign_schedule` VALUES (/*id*/1, /*campaign_category*/34, /*value*/2000.0, /*system_id*/103, /*icon_image*/30, /*start_time*/"2018/03/06 05:00:00", /*end_time*/"2018/03/13 04:59:59");
INSERT INTO `campaign_schedule` VALUES (/*id*/2, /*campaign_category*/44, /*value*/2000.0, /*system_id*/103, /*icon_image*/40, /*start_time*/"2018/03/06 05:00:00", /*end_time*/"2018/03/13 04:59:59");
INSERT INTO `campaign_schedule` VALUES (/*id*/3, /*campaign_category*/45, /*value*/2000.0, /*system_id*/104, /*icon_image*/40, /*start_time*/"2018/03/13 05:00:00", /*end_time*/"2018/03/20 04:59:59");
INSERT INTO `campaign_schedule` VALUES (/*id*/4, /*campaign_category*/31, /*value*/2000.0, /*system_id*/101, /*icon_image*/30, /*start_time*/"2018/03/20 05:00:00", /*end_time*/"2018/03/26 04:59:59");
INSERT INTO `campaign_schedule` VALUES (/*id*/5, /*campaign_category*/41, /*value*/2000.0, /*system_id*/101, /*icon_image*/40, /*start_time*/"2018/03/20 05:00:00", /*end_time*/"2018/03/26 04:59:59");
INSERT INTO `campaign_schedule` VALUES (/*id*/6, /*campaign_category*/32, /*value*/2000.0, /*system_id*/102, /*icon_image*/30, /*start_time*/"2018/03/26 05:00:00", /*end_time*/"2018/03/31 04:59:59");
INSERT INTO `campaign_schedule` VALUES (/*id*/7, /*campaign_category*/42, /*value*/2000.0, /*system_id*/102, /*icon_image*/40, /*start_time*/"2018/03/26 05:00:00", /*end_time*/"2018/03/31 04:59:59");
INSERT INTO `campaign_schedule` VALUES (/*id*/8, /*campaign_category*/34, /*value*/2000.0, /*system_id*/103, /*icon_image*/30, /*start_time*/"2018/03/31 05:00:00", /*end_time*/"2018/04/10 04:59:59");
INSERT INTO `campaign_schedule` VALUES (/*id*/9, /*campaign_category*/44, /*value*/2000.0, /*system_id*/103, /*icon_image*/40, /*start_time*/"2018/03/31 05:00:00", /*end_time*/"2018/04/10 04:59:59");
INSERT INTO `campaign_schedule` VALUES (/*id*/10, /*campaign_category*/45, /*value*/2000.0, /*system_id*/104, /*icon_image*/40, /*start_time*/"2018/04/10 05:00:00", /*end_time*/"2018/04/20 04:59:59");
INSERT INTO `campaign_schedule` VALUES (/*id*/11, /*campaign_category*/31, /*value*/2000.0, /*system_id*/101, /*icon_image*/30, /*start_time*/"2018/04/20 05:00:00", /*end_time*/"2018/04/25 04:59:59");
INSERT INTO `campaign_schedule` VALUES (/*id*/12, /*campaign_category*/41, /*value*/2000.0, /*system_id*/101, /*icon_image*/40, /*start_time*/"2018/04/20 05:00:00", /*end_time*/"2018/04/25 04:59:59");
INSERT INTO `campaign_schedule` VALUES (/*id*/13, /*campaign_category*/32, /*value*/2000.0, /*system_id*/102, /*icon_image*/30, /*start_time*/"2018/04/25 05:00:00", /*end_time*/"2018/04/30 04:59:59");
INSERT INTO `campaign_schedule` VALUES (/*id*/14, /*campaign_category*/42, /*value*/2000.0, /*system_id*/102, /*icon_image*/40, /*start_time*/"2018/04/25 05:00:00", /*end_time*/"2018/04/30 04:59:59");
INSERT INTO `campaign_schedule` VALUES (/*id*/15, /*campaign_category*/34, /*value*/2000.0, /*system_id*/103, /*icon_image*/30, /*start_time*/"2018/04/30 05:00:00", /*end_time*/"2018/05/11 04:59:59");
INSERT INTO `campaign_schedule` VALUES (/*id*/16, /*campaign_category*/44, /*value*/2000.0, /*system_id*/103, /*icon_image*/40, /*start_time*/"2018/04/30 05:00:00", /*end_time*/"2018/05/11 04:59:59");
INSERT INTO `campaign_schedule` VALUES (/*id*/17, /*campaign_category*/45, /*value*/2000.0, /*system_id*/104, /*icon_image*/40, /*start_time*/"2018/05/11 05:00:00", /*end_time*/"2018/05/22 04:59:59");
INSERT INTO `campaign_schedule` VALUES (/*id*/18, /*campaign_category*/31, /*value*/2000.0, /*system_id*/101, /*icon_image*/30, /*start_time*/"2018/05/22 05:00:00", /*end_time*/"2018/05/28 04:59:59");
INSERT INTO `campaign_schedule` VALUES (/*id*/19, /*campaign_category*/41, /*value*/2000.0, /*system_id*/101, /*icon_image*/40, /*start_time*/"2018/05/22 05:00:00", /*end_time*/"2018/05/28 04:59:59");
INSERT INTO `campaign_schedule` VALUES (/*id*/20, /*campaign_category*/32, /*value*/2000.0, /*system_id*/102, /*icon_image*/30, /*start_time*/"2018/05/28 05:00:00", /*end_time*/"2018/05/31 04:59:59");
INSERT INTO `campaign_schedule` VALUES (/*id*/21, /*campaign_category*/42, /*value*/2000.0, /*system_id*/102, /*icon_image*/40, /*start_time*/"2018/05/28 05:00:00", /*end_time*/"2018/05/31 04:59:59");
INSERT INTO `campaign_schedule` VALUES (/*id*/22, /*campaign_category*/34, /*value*/2000.0, /*system_id*/103, /*icon_image*/30, /*start_time*/"2018/05/31 05:00:00", /*end_time*/"2018/06/10 04:59:59");
INSERT INTO `campaign_schedule` VALUES (/*id*/23, /*campaign_category*/44, /*value*/2000.0, /*system_id*/103, /*icon_image*/40, /*start_time*/"2018/05/31 05:00:00", /*end_time*/"2018/06/10 04:59:59");
INSERT INTO `campaign_schedule` VALUES (/*id*/24, /*campaign_category*/45, /*value*/2000.0, /*system_id*/104, /*icon_image*/40, /*start_time*/"2018/06/10 05:00:00", /*end_time*/"2018/06/20 04:59:59");
INSERT INTO `campaign_schedule` VALUES (/*id*/25, /*campaign_category*/31, /*value*/2000.0, /*system_id*/101, /*icon_image*/30, /*start_time*/"2018/06/20 05:00:00", /*end_time*/"2018/06/25 04:59:59");
INSERT INTO `campaign_schedule` VALUES (/*id*/26, /*campaign_category*/41, /*value*/2000.0, /*system_id*/101, /*icon_image*/40, /*start_time*/"2018/06/20 05:00:00", /*end_time*/"2018/06/25 04:59:59");
INSERT INTO `campaign_schedule` VALUES (/*id*/27, /*campaign_category*/32, /*value*/2000.0, /*system_id*/102, /*icon_image*/30, /*start_time*/"2018/06/25 05:00:00", /*end_time*/"2018/06/30 04:59:59");
INSERT INTO `campaign_schedule` VALUES (/*id*/28, /*campaign_category*/42, /*value*/2000.0, /*system_id*/102, /*icon_image*/40, /*start_time*/"2018/06/25 05:00:00", /*end_time*/"2018/06/30 04:59:59");
INSERT INTO `campaign_schedule` VALUES (/*id*/29, /*campaign_category*/34, /*value*/2000.0, /*system_id*/103, /*icon_image*/30, /*start_time*/"2018/06/30 05:00:00", /*end_time*/"2018/07/10 04:59:59");
INSERT INTO `campaign_schedule` VALUES (/*id*/30, /*campaign_category*/44, /*value*/2000.0, /*system_id*/103, /*icon_image*/40, /*start_time*/"2018/06/30 05:00:00", /*end_time*/"2018/07/10 04:59:59");
INSERT INTO `campaign_schedule` VALUES (/*id*/31, /*campaign_category*/45, /*value*/2000.0, /*system_id*/104, /*icon_image*/40, /*start_time*/"2018/07/10 05:00:00", /*end_time*/"2018/07/20 04:59:59");
INSERT INTO `campaign_schedule` VALUES (/*id*/32, /*campaign_category*/31, /*value*/2000.0, /*system_id*/101, /*icon_image*/30, /*start_time*/"2018/07/20 05:00:00", /*end_time*/"2018/07/25 04:59:59");
INSERT INTO `campaign_schedule` VALUES (/*id*/33, /*campaign_category*/41, /*value*/2000.0, /*system_id*/101, /*icon_image*/40, /*start_time*/"2018/07/20 05:00:00", /*end_time*/"2018/07/25 04:59:59");
INSERT INTO `campaign_schedule` VALUES (/*id*/34, /*campaign_category*/32, /*value*/2000.0, /*system_id*/102, /*icon_image*/30, /*start_time*/"2018/07/25 05:00:00", /*end_time*/"2018/07/31 04:59:59");
INSERT INTO `campaign_schedule` VALUES (/*id*/35, /*campaign_category*/42, /*value*/2000.0, /*system_id*/102, /*icon_image*/40, /*start_time*/"2018/07/25 05:00:00", /*end_time*/"2018/07/31 04:59:59");
INSERT INTO `campaign_schedule` VALUES (/*id*/36, /*campaign_category*/34, /*value*/2000.0, /*system_id*/103, /*icon_image*/30, /*start_time*/"2018/07/31 05:00:00", /*end_time*/"2018/08/10 04:59:59");
INSERT INTO `campaign_schedule` VALUES (/*id*/37, /*campaign_category*/44, /*value*/2000.0, /*system_id*/103, /*icon_image*/40, /*start_time*/"2018/07/31 05:00:00", /*end_time*/"2018/08/10 04:59:59");
INSERT INTO `campaign_schedule` VALUES (/*id*/38, /*campaign_category*/45, /*value*/2000.0, /*system_id*/104, /*icon_image*/40, /*start_time*/"2018/08/10 05:00:00", /*end_time*/"2018/08/21 04:59:59");
INSERT INTO `campaign_schedule` VALUES (/*id*/39, /*campaign_category*/34, /*value*/3000.0, /*system_id*/103, /*icon_image*/30, /*start_time*/"2018/08/15 05:00:00", /*end_time*/"2018/08/21 04:59:59");
INSERT INTO `campaign_schedule` VALUES (/*id*/40, /*campaign_category*/44, /*value*/3000.0, /*system_id*/103, /*icon_image*/40, /*start_time*/"2018/08/15 05:00:00", /*end_time*/"2018/08/21 04:59:59");