| 12345678910111213141516 |
- 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,
|
