#####日期:2020-04-21 #####提交人:向淳宇 #####sql解决问题:删除联合索引,添加审核字段 #####sql语句 ALTER TABLE `member_org` DROP INDEX `orguser`; ALTER TABLE `org_structure` MODIFY COLUMN `createUserId` varchar(255) NULL DEFAULT NULL COMMENT '创造组织用户的id' AFTER `parentId`, ADD COLUMN `createUserType` bigint(11) NULL DEFAULT NULL COMMENT '1:b端用户;2:c端用户' AFTER `createUserId`; ALTER TABLE `member_org` ADD COLUMN `userStatus` bigint(11) NULL DEFAULT NULL COMMENT '是否审核(1:已审核;2未审核)' AFTER `addTime`, ADD COLUMN `ofMainGroup` bigint(11) NULL DEFAULT NULL COMMENT '预留字段(是否属于主组织下的成员)' AFTER `userStatus`; ALTER TABLE `member_org` MODIFY COLUMN `userStatus` bigint(11) NULL DEFAULT NULL COMMENT '是否审核(1:已通过;2:未通过;3:未审核)' AFTER `addTime`, ADD COLUMN `ofParty` bigint(11) NULL DEFAULT NULL COMMENT '是否是党员' AFTER `ofMainGroup`, ADD COLUMN `realName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '真实姓名' AFTER `ofParty`; CREATE TABLE `org_oprate_record` ( `id` bigint(11) NOT NULL AUTO_INCREMENT, `userId` varchar(255) DEFAULT NULL COMMENT '操作人Id', `userName` varchar(255) DEFAULT NULL COMMENT '用户昵称', `memberOrgId` bigint(11) DEFAULT NULL COMMENT '组织用户关联id', `oprationType` bigint(11) DEFAULT NULL COMMENT '操作类型类型(1:代表申请审核;2代表审核通过;3代表审核不通过)', `oprationTime` datetime DEFAULT NULL COMMENT '操作时间', `revered` varchar(255) DEFAULT NULL COMMENT '预留字段', `userOrigin` bigint(11) DEFAULT NULL COMMENT '用户来源(1:b端用户;2:c端用户)', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; ALTER TABLE `member_org` ADD COLUMN `userOrigin` bigint(11) NULL DEFAULT NULL COMMENT '用户来源:1:b端加入用户;2:c端加入用户' AFTER `ofParty`; ALTER TABLE `member_org` ADD COLUMN `mobile` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户联系的手机号' AFTER `userOrigin`; INSERT INTO `member_version` (`version`, `update_time`) VALUES ('3.0.3.1', NOW()); #####日期:2020-04-26 #####提交人:黄怀平 #####sql新增背景图字段 #####sql语句 ALTER TABLE `member_member` ADD COLUMN `backgroundImage` varchar(255) DEFAULT NULL COMMENT '会员背景图' AFTER `avatar`; INSERT INTO `member_version` (`version`, `update_time`) VALUES ('3.0.3.2', NOW()); #####日期:2020-04-28 #####提交人:黄怀平 #####sql新增地区id、名字字段 #####sql语句 ALTER TABLE `member_member` ADD COLUMN `areaId` bigint(11) DEFAULT 100000 COMMENT '地区id' AFTER `mobile`; ALTER TABLE `member_member` ADD COLUMN `mergerName` varchar(255) DEFAULT NULL COMMENT '地区名字' AFTER `mobile`; INSERT INTO `member_version` (`version`, `update_time`) VALUES ('3.0.3.3', NOW()); #####日期:2020-04-28 #####提交人:黄怀平 #####sql新增省、市id #####sql语句 ALTER TABLE `member_member` DROP COLUMN `areaId`; ALTER TABLE `member_member` ADD COLUMN `areaId` bigint(11) DEFAULT NULL COMMENT '地区id' AFTER `mobile`; ALTER TABLE `member_member` ADD COLUMN `areaCityId` bigint(11) DEFAULT NULL COMMENT '市id' AFTER `mobile`; ALTER TABLE `member_member` ADD COLUMN `areaProvinceId` bigint(11) DEFAULT NULL COMMENT '省id' AFTER `mobile`; INSERT INTO `member_version` (`version`, `update_time`) VALUES ('3.0.3.4', NOW()); #####日期:2020-04-29 #####提交人:向淳宇 #####sql新增 新增层级关系,修改表名 #####sql语句 ALTER TABLE `org_structure` ADD COLUMN `level` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '展示层级关系(以 - 隔开)' AFTER `parentId`; ALTER TABLE `member_org` ADD COLUMN `level` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '组织的层级' AFTER `orgId`; ALTER TABLE `org_structure` RENAME `member_structure`; INSERT INTO `member_version` (`version`, `update_time`) VALUES ('3.0.3.5', NOW());