Index: ssts-web/src/main/webapp/dataUpdater/4.0升级4.1脚本/服务器启动之后执行的脚本.txt =================================================================== diff -u -r13239 -r13427 --- ssts-web/src/main/webapp/dataUpdater/4.0升级4.1脚本/服务器启动之后执行的脚本.txt (.../服务器启动之后执行的脚本.txt) (revision 13239) +++ ssts-web/src/main/webapp/dataUpdater/4.0升级4.1脚本/服务器启动之后执行的脚本.txt (.../服务器启动之后执行的脚本.txt) (revision 13427) @@ -3,7 +3,7 @@ /* һ������Ʒ��� */ /* ��Ҫ���ö�Ӧ�IJֿ⣬Ȼ��'��Ժ��Ӧ�Ҳֿ�'�滻Ϊ���õIJֿ��� */ -delete from IdentificationOfDisposableGoods; +delete from DisposableGoodsIdentification; delete from DisposableGoodsBatchStock; delete from DisposableGoodsStock; delete from DisposableGoodsBatch; @@ -34,16 +34,16 @@ update DisposableGoodsBatchStock set warehouseID=(select id from WareHouse where name='��Ժ��Ӧ�Ҳֿ�'); update DisposableGoodsBatchStock set warehouseName='��Ժ��Ӧ�Ҳֿ�'; -/* IdentificationOfDiposableGoods ����Ϊ IdentificationOfDisposableGoods */ -delete from IdentificationOfDisposableGoods; -set identity_insert IdentificationOfDisposableGoods on -insert into IdentificationOfDisposableGoods (id,amount,conclusion,entryDate,identification,price,batch_id) (select id,amount,conclusion,entryDate,identification,price,batch_id from IdentificationOfDiposableGoods) -set identity_insert IdentificationOfDisposableGoods off -update IdentificationOfDisposableGoods set disposableGoodsID=(select TOP 1 diposablegoods_id from DiposableGoodBatchStock where id=batch_id); -update IdentificationOfDisposableGoods set disposableGoodsStockID=batch_id; -update IdentificationOfDisposableGoods set disposableGoodsBatchID=batch_id; -update IdentificationOfDisposableGoods set warehouseID=(select id from WareHouse where name='��Ժ��Ӧ�Ҳֿ�'); -update IdentificationOfDisposableGoods set warehouseName='��Ժ��Ӧ�Ҳֿ�'; +/* IdentificationOfDiposableGoods ����Ϊ DisposableGoodsIdentification */ +delete from DisposableGoodsIdentification; +set identity_insert DisposableGoodsIdentification on +insert into DisposableGoodsIdentification (id,amount,conclusion,entryDate,identification,price,batch_id) (select id,amount,conclusion,entryDate,identification,price,batch_id from IdentificationOfDiposableGoods) +set identity_insert DisposableGoodsIdentification off +update DisposableGoodsIdentification set disposableGoodsID=(select TOP 1 diposablegoods_id from DiposableGoodBatchStock where id=batch_id); +update DisposableGoodsIdentification set disposableGoodsStockID=batch_id; +update DisposableGoodsIdentification set disposableGoodsBatchID=batch_id; +update DisposableGoodsIdentification set warehouseID=(select id from WareHouse where name='��Ժ��Ӧ�Ҳֿ�'); +update DisposableGoodsIdentification set warehouseName='��Ժ��Ӧ�Ҳֿ�'; /* ������ⵥ�IJֿ���Ϣ */ update GodownEntry set wareHouseId=(select id from WareHouse where name='��Ժ��Ӧ�Ҳֿ�');