valhalla / fw-dalaran

Blame view

alertHistory.txt 4.9 KB
Edit Raw Normal View History Permalink
0fb1c822   王明元   2022年4月14日10:35:2... 
1
2
3
 
  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:上班)';
4dab4d1f   王明元   2022年6月13日11:21:0... 
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
 
  
  
  
  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的唯一索引'
03a950b2   王明元   2022年6月13日18:04:4... 
65
 
  ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='活动主题相关附件';
4dab4d1f   王明元   2022年6月13日11:21:0... 
66
90f9e807   王明元   2022年7月6日11:23:50... 
67
68
69
70
71
72
73
74
75
76
77
78
 
  
  
  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