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