Calculation/sql/update20200527.sql

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