alter table org_cognizance add `record_time` DATETIME NULL COMMENT '高企申请时间' AFTER `year`; alter table patent_info add `record_time` DATETIME NULL COMMENT '专利申请时间' AFTER `confirm_state`; alter table organization_identity MODIFY COLUMN `listed` INT(1) NULL COMMENT '是否上市' , MODIFY COLUMN `listed_type` INT(1) NULL COMMENT '上市类型'; alter table patent_info MODIFY COLUMN `principal` VARCHAR(36) NULL COMMENT '负责人'; alter table patent_log MODIFY COLUMN `principal` VARCHAR(36) NULL COMMENT '负责人' , MODIFY COLUMN `operator` VARCHAR(36) NULL COMMENT '操作人'; alter table org_cognizance MODIFY COLUMN `consultant` VARCHAR(36) NULL COMMENT '咨询师'; alter table org_cognizance_log MODIFY COLUMN `principal` VARCHAR(36) NULL COMMENT '负责人' , MODIFY COLUMN `operator` VARCHAR(36) NULL COMMENT '操作人'; update org_cognizance set contacts = '1' where contacts <> '1'; alter table org_cognizance MODIFY COLUMN `contacts` INT(1) NULL COMMENT '联系人及联系方式' ;