
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 '联系人及联系方式' ;


