ALTER TABLE `zh_project` ADD `office_share` VARCHAR(1000) NULL COMMENT '办事处共享(office id列表)' AFTER `office`; ALTER TABLE `zh_project` ADD `manager_office` TINYINT(3) NULL DEFAULT NULL COMMENT '负责人办事处' AFTER `manager_id`; UPDATE `zh_project` SET `manager_office`=`office`; UPDATE `zh_project` as a, `zh_manager` as b SET a.`creator`= b.`id` WHERE a.`creator` LIKE '%付青青%' AND b.`username` = '付青青'; UPDATE `zh_project` as a, `zh_manager` as b SET a.`creator`= b.`id` WHERE a.`creator` LIKE '%梁琪波%' AND b.`username` = '梁琪波'; UPDATE `zh_project` as a, `zh_manager` as b SET a.`creator`= b.`id` WHERE a.`creator` LIKE '%曾沛文%' AND b.`username` = '曾沛文'; UPDATE `zh_project` as a, `zh_manager` as b SET a.`creator`= b.`id` WHERE a.`creator` LIKE '%周洪波%' AND b.`username` = '周洪波'; UPDATE `zh_project` as a, `zh_manager` as b SET a.`creator`= b.`id` WHERE a.`creator` LIKE '%王星植%' AND b.`username` = '王星植'; INSERT INTO `zh_permission`(`id`, `name`, `controller`, `action`, `pid`, `icon_class`, `create_time`, `isshow`) VALUES (70, '办事处共享', 'project', 'office', 38, '', null, 1); -- 2020-05-27 更新uat/prod