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`;