ALTER TABLE `police`
ADD COLUMN `isexport`  bit(1) NULL DEFAULT NULL COMMENT '是否导出' AFTER `updateflag`;

ALTER TABLE `sys_approval`
ADD COLUMN `outreason`  varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '对外意见' AFTER `info_rar`;

ALTER TABLE `sys_approval`
ADD COLUMN `outinfo_rar`  varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '对外意见附件' AFTER `outreason`;

ALTER TABLE `sys_approvallog`
ADD COLUMN `type`  varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '审批日志类型001代表对内意见 002代表对外意见' AFTER `approvalid`;


ALTER TABLE `module`
ADD COLUMN `p_id`  int(11) NULL DEFAULT NULL COMMENT '上级模块id' AFTER `moduletype`;



alter table sb_traincompanyapply add company_house_area varchar(20) COMMENT '公司用房面积' ;
--  保安培训单位，去悼：组织机构代码，新增：公司用房面积，与房权归属一起显示
update sys_approval set outreason=approvalreason where approvalreason IS NOT NULL;
 