upgrade0727.sql 1.4 KB

1234567891011121314151617181920
  1. create unique index jetplasma_alteration_apply_no_uindex on jetplasma_alteration_apply (no);
  2. create unique index jetplasma_ecn_no_uindex on jetplasma_ecn (ecn_no);
  3. alter table jetplasma_alteration_apply modify no varchar(20) not null comment '申请编号';
  4. alter table jetplasma_eco modify alteration_id bigint not null comment '变更申请ID';
  5. alter table jetplasma_eco modify alteration_no varchar(20) not null comment '申请编号';
  6. alter table jetplasma_ecn modify alteration_id bigint not null comment '变更申请ID';
  7. alter table jetplasma_ecn modify alteration_no varchar(20) not null comment '变更申请编号';
  8. alter table jetplasma_ecn modify eco_id bigint not null comment 'ECO编号';
  9. alter table jetplasma_ecn modify ecn_no varchar(20) not null comment 'ECN单号';
  10. alter table jetplasma_ecn_meta modify ecn_id bigint not null comment 'ECN编号';
  11. alter table jetplasma_ecn_progress modify ecn_id bigint not null comment '关联ECN ID';
  12. alter table jetplasma_ecn_spread modify ecn_id bigint not null comment '所属ECN编号';
  13. alter table jetplasma_ecn_spread modify alteration_no varchar(20) not null comment '变更申请编号';
  14. alter table jetplasma_eco modify level varchar(60) null comment '重要程度';
  15. alter table jetplasma_alteration_apply
  16. modify item_type longtext not null comment '变更项目';;
  17. alter table jetplasma_alteration_apply
  18. modify attachment longtext null comment '附件';