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