xdmy/doc/sql/yh.sql

update  apisql set sqlname='getNoMesList_bk' where  sqlname ='getNoMesList';
update  apisql set sqlname='getNoMesCount_bk' where  sqlname ='getNoMesCount';

alter table buydetail  modify column contractId  bigint(50) ;
alter table part_repertory  modify column contractId  bigint(50) ;
alter table checkpart  modify column contractId  bigint(50) ;
alter table partuse   modify column contractId  bigint(50) ;

alter table  part_repertory  drop index partcode
alter table  part_repertory  add unique index (locationId ,providerId ,price,partCode,contractId)

locationId ,
providerId ,
price      ,
partCode   ,
contractId,