2017-05-24.sql 751 B

123456789101112131415161718192021
  1. CREATE TABLE `demand_keyword` (
  2. `id` VARCHAR(36) NOT NULL,
  3. `demand_id` VARCHAR(36) NOT NULL COMMENT '科技需求ID',
  4. `keyword` VARCHAR(16) NOT NULL COMMENT '关键词',
  5. PRIMARY KEY (`id`))
  6. ENGINE = InnoDB
  7. COMMENT = '科技需求关键词';
  8. CREATE TABLE `achievement_keyword` (
  9. `id` VARCHAR(36) NOT NULL,
  10. `achievement_id` VARCHAR(36) NOT NULL COMMENT '科技成果ID',
  11. `keyword` VARCHAR(36) NOT NULL COMMENT '科技成果关键词',
  12. PRIMARY KEY (`id`))
  13. ENGINE = InnoDB
  14. COMMENT = '科技成果关键词';
  15. alter table `achievement`
  16. modify column `contacts` int(1) NULL comment '联系人及方式';
  17. alter table `achievement_keyword`
  18. modify column `keyword` VARCHAR(16) NOT NULL COMMENT '科技成果关键词';