mysql创设和删除唯一约束_mysql

show keys from tb_receipt_status;

show keys from tb_receipt_transaction;

— 入库状态表

alter table tb_receipt_status add unique key `unique_key`(asnno, source, asnstatus);

— 交易事务（收货明细） 

alter table tb_receipt_transaction add unique key `unique_key`(transactionid, source);

— 上架任务

alter table tb_tsk_tasklists add unique key `unique_key`(taskid, source, taskid_sequence);

— 出库状态

alter table tb_order_status add unique key `unique_key`(orderno, source, sostatus);

— 分配明细

alter table tb_act_allocation_details add unique key `unique_key`(allocationdetailsid, source);

— 入库状态表

alter table tb_receipt_status drop key `unique_key`;

— 交易事务（收货明细） 

alter table tb_receipt_transaction drop key `unique_key`;

— 上架任务

alter table tb_tsk_tasklists drop key `unique_key`;

— 出库状态

alter table tb_order_status drop key `unique_key`;

— 分配明细

alter table tb_act_allocation_details drop key `unique_key`;