xdmy/doc/sql/yh.sql

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

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)


{"name":"updateMenu","params":["35","备件退库","备件退库","Retreat","custom/retreat/index","备件退库","","10","menu",1,"127"]}


select * from menu where name ='备件退库'