alertHistory.txt
4.9 KB
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
77
78
2022年4月14日11:37:29
alter table `account` add `account_type` tinyint(4) DEFAULT '0' COMMENT '账号类型(0:个人账号, 1:门店账号)';
alter table `account` add `account_status` tinyint(4) DEFAULT '1' COMMENT '活动期间账号状态(-1:已离职, 0:未上班, 1:上班)';
alter table activity_theme add config_group_id bigint not null comment '所属配置组id' after group_id;
alter table evl_index add config_group_id bigint not null comment '所属配置组id' after id;
alter table todo_history add extra varchar(32) null comment '额外字段' after data_id;
alter table valid_config_new add config_group_id bigint not null comment '所属配置组id' after id;
CREATE TABLE `config_group` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键id',
`user_id` bigint(20) NOT NULL COMMENT '创建该配置的用户id',
`group_id` bigint(20) NOT NULL COMMENT '集团id',
`shop_ids` text COMMENT '该配置适用门店id集合',
`shop_names` text COMMENT '该配置适用门店名集合',
`evl_video_id` bigint(20) NOT NULL COMMENT '视频占比指标表关联id',
`evl_live_id` bigint(20) NOT NULL COMMENT '视频占比指标表关联id',
`valid_ids` text COMMENT '最低指标关联id',
`config_ids` text COMMENT '配置关联id',
`all_shop` tinyint(4) NOT NULL COMMENT '全部门店(-1:授权范围内, 0:否, 1:是)',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`update_time` datetime DEFAULT NULL COMMENT '更新时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COMMENT='配置组';
CREATE TABLE `global_config` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键id',
`config_group_id` bigint(20) NOT NULL COMMENT '所属配置组id',
`type` int(11) NOT NULL COMMENT '配置项类型(1:封面, 2:话题)',
`rate` double NOT NULL COMMENT '配置项值',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`update_time` datetime DEFAULT NULL COMMENT '更新时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COMMENT='全局配置';
CREATE TABLE `live_check_result` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键id',
`theme_id` bigint(20) NOT NULL COMMENT '主题id',
`user_id` bigint(20) NOT NULL COMMENT '用户id',
`shop_id` bigint(20) NOT NULL COMMENT '门店id',
`live_id` bigint(20) NOT NULL COMMENT '最佳直播id',
`counterfeit` tinyint(4) NOT NULL COMMENT '是否空挂(0:否, 1:是)',
`pay` tinyint(4) NOT NULL COMMENT '是否付费(0:否, 1:是)',
`valid` tinyint(4) NOT NULL COMMENT '是否有效直播(0:否, 1:是)',
`status` tinyint(4) NOT NULL COMMENT '状态(-1:初始化, 0:草稿, 1:完成审计)',
`opinion` varchar(512) DEFAULT NULL COMMENT '审查意见',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COMMENT='直播审计结果';
CREATE TABLE `theme_file` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键id',
`theme_id` bigint(20) NOT NULL COMMENT '主题id',
`file_id` varchar(32) NOT NULL COMMENT '文件id',
`file_name` varchar(256) DEFAULT '0' COMMENT '文件名称',
`file_type` int(2) NOT NULL COMMENT '文件类型',
`type` tinyint(4) DEFAULT NULL COMMENT '文件所属类型(1:封面, 2:直播审计)',
`extra_id` bigint(20) DEFAULT NULL COMMENT '附件归属其他表数据主键id',
`create_time` datetime NOT NULL COMMENT '创建时间',
`update_time` datetime DEFAULT NULL COMMENT '更新时间',
`logic_del` tinyint(2) NOT NULL DEFAULT '0' COMMENT '逻辑删除(0:未删除, 1:已删除)',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE KEY `themeId_fileId_type` (`theme_id`,`file_id`,`type`) COMMENT '主题id和文件id的唯一索引'
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='活动主题相关附件';
39: 630年中冲量 巅峰聚会团购会
video: 247132,247131,247017,247145,246915,246914,247021,247020,247019,247283,247282,247281,247158,247157,247116,247115,247254,247253,247008,247006,247004,246934,246933,247393,247289,247288,247330,247360,247359,247329,247287,247286,247358,247357,247072,247071,247110,247109,247285,247284,247274,247273,247063,247326,247272,247271,247130,247129,247062,247187,247186,247185,247184,247306
live: 7205,7221,7255,7277,7295,7302,7312,7261,7271,7272,7287,7204,7210,7219,7231,7256,7273,7203,7212,7227,7279,7309
38: 630置换专场周
video: 247220,247219,247308,247307,247226,247225,247196,247194,247177,247176,246996,246995,247418,247417,246890,247150,247149,247215,247214,246889,247274,247273,247063,247326,247272,247271,247130,247129,247062,
live: 7216,7217,7222,7223,7224,7237,7281,7298,7299,7307,7296,7218,7234,7245,7254,7276,7308,7311
删除的快手id: 261,97,290,243,184,72,351,342,286,301,335,41,291,357,264,232,185,259,313,11,373,366,148,307,367,364,360,341,257,88,239,186,35,47,365,22,309,69,273,329,258,234,238,281,369,145,370,173,78,328,340,292,125,253,285,59,305,61,102,79,354,191,216,112,255,377,268