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 ='备件退库'