Index: ssts-web/src/main/webapp/dataUpdater/sqls/4.9.21_4.9.22.sql =================================================================== diff -u -r23696 -r23762 --- ssts-web/src/main/webapp/dataUpdater/sqls/4.9.21_4.9.22.sql (.../4.9.21_4.9.22.sql) (revision 23696) +++ ssts-web/src/main/webapp/dataUpdater/sqls/4.9.21_4.9.22.sql (.../4.9.21_4.9.22.sql) (revision 23762) @@ -1,2 +1,3 @@ -alter table RelevancyGoodsAuthorization alter column expensiveGoodsIds varchar(4000) -alter table RelevancyGoodsAuthorization alter column expensiveGoodsName varchar(4000) \ No newline at end of file +update Supplier set isManufacturer = 1 ,isSupplier = 0 where rentTousse = '生产厂家'; +update Supplier set isManufacturer = 0 ,isSupplier = 1 where rentTousse = '供货单位'; +update Supplier set isManufacturer = 0 ,isSupplier = 0 where rentTousse not in ( '供货单位', '生产厂家'); \ No newline at end of file