create unique index jetplasma_alteration_apply_no_uindex on jetplasma_alteration_apply (no); create unique index jetplasma_ecn_no_uindex on jetplasma_ecn (ecn_no); alter table jetplasma_alteration_apply modify no varchar(20) not null comment '申请编号'; alter table jetplasma_eco modify alteration_id bigint not null comment '变更申请ID'; alter table jetplasma_eco modify alteration_no varchar(20) not null comment '申请编号'; alter table jetplasma_ecn modify alteration_id bigint not null comment '变更申请ID'; alter table jetplasma_ecn modify alteration_no varchar(20) not null comment '变更申请编号'; alter table jetplasma_ecn modify eco_id bigint not null comment 'ECO编号'; alter table jetplasma_ecn modify ecn_no varchar(20) not null comment 'ECN单号'; alter table jetplasma_ecn_meta modify ecn_id bigint not null comment 'ECN编号'; alter table jetplasma_ecn_progress modify ecn_id bigint not null comment '关联ECN ID'; alter table jetplasma_ecn_spread modify ecn_id bigint not null comment '所属ECN编号'; alter table jetplasma_ecn_spread modify alteration_no varchar(20) not null comment '变更申请编号'; alter table jetplasma_eco modify level varchar(60) null comment '重要程度'; alter table jetplasma_alteration_apply modify item_type longtext not null comment '变更项目';; alter table jetplasma_alteration_apply modify attachment longtext null comment '附件';