2017-03-13.sql 1.1 KB

1234567891011121314151617181920212223242526272829303132
  1. alter table org_cognizance add
  2. `record_time` DATETIME NULL COMMENT '高企申请时间' AFTER `year`;
  3. alter table patent_info add
  4. `record_time` DATETIME NULL COMMENT '专利申请时间' AFTER `confirm_state`;
  5. alter table organization_identity
  6. MODIFY COLUMN `listed` INT(1) NULL COMMENT '是否上市' ,
  7. MODIFY COLUMN `listed_type` INT(1) NULL COMMENT '上市类型';
  8. alter table patent_info
  9. MODIFY COLUMN `principal` VARCHAR(36) NULL COMMENT '负责人';
  10. alter table patent_log
  11. MODIFY COLUMN `principal` VARCHAR(36) NULL COMMENT '负责人' ,
  12. MODIFY COLUMN `operator` VARCHAR(36) NULL COMMENT '操作人';
  13. alter table org_cognizance
  14. MODIFY COLUMN `consultant` VARCHAR(36) NULL COMMENT '咨询师';
  15. alter table org_cognizance_log
  16. MODIFY COLUMN `principal` VARCHAR(36) NULL COMMENT '负责人' ,
  17. MODIFY COLUMN `operator` VARCHAR(36) NULL COMMENT '操作人';
  18. update org_cognizance set contacts = '1' where contacts <> '1';
  19. alter table org_cognizance
  20. MODIFY COLUMN `contacts` INT(1) NULL COMMENT '联系人及联系方式' ;