ALTER TABLE `security_company`
ADD COLUMN `parentId`  varchar(20) NULL COMMENT '上级总公司id' AFTER `seq`,
ADD COLUMN `local`  bit NULL DEFAULT true COMMENT '是否本地公司' AFTER `parentId`;

ALTER TABLE `security_company`
ADD COLUMN `trainContent` varchar(1000) NULL COMMENT '培训内容' AFTER `seq`;

UPDATE `sys_dict` SET `label`='中国保安协会' WHERE codeType='securityAssociation' and codeValue='1';
UPDATE `sys_dict` SET `label`='市保安协会' WHERE codeType='securityAssociation' and codeValue='3';
update sys_dict set label='集体经济' where codeType ='economicType' and codeValue='2';

UPDATE security_company set security_Association= REPLACE(security_Association,'1','4');
UPDATE security_company set security_Association= REPLACE(security_Association,'3','1');
UPDATE security_company set security_Association= REPLACE(security_Association,'4','3');