2017-04-12.sql 769 B

123456789101112131415161718192021
  1. alter table `org_standard`
  2. add COLUMN `year` INT(4) NULL COMMENT '标准制定年份' after `create_time`,
  3. add COLUMN `enclosure_url` VARCHAR(255) NULL COMMENT '附件URL' after `year`;
  4. alter table `org_cognizance`
  5. add COLUMN `large_order` INT(1) NULL COMMENT '是否为大额订单 ' after `record_time`;
  6. alter table `org_finance`
  7. add COLUMN `research_cost` DECIMAL(8,2) NULL COMMENT '研发费用' after `finance_url`;
  8. alter table `org_honor_datum`
  9. add COLUMN `year` INT(4) NULL COMMENT '荣誉及其他证明材料获取年份' after `enclosure_url`;
  10. alter table `org_intellectual_property`
  11. add COLUMN `type` INT(1) NULL COMMENT '知识产权类型(0--非系统申请知识产权,1--专利,2--软著)' after `property_right_url`;