Index: ssts-web/src/main/webapp/dataUpdater/sqls/4.0.4_4.0.5_sqlserver.sql
===================================================================
diff -u -r12331 -r13187
--- ssts-web/src/main/webapp/dataUpdater/sqls/4.0.4_4.0.5_sqlserver.sql	(.../4.0.4_4.0.5_sqlserver.sql)	(revision 12331)
+++ ssts-web/src/main/webapp/dataUpdater/sqls/4.0.4_4.0.5_sqlserver.sql	(.../4.0.4_4.0.5_sqlserver.sql)	(revision 13187)
@@ -1 +1 @@
-update TousseInstance set signedUser = invoice.receiptor,signedDate = invoice.receiptingTime from Invoice invoice inner join TousseInstance ti on ti.invoice_id = invoice.id where ti.signedUser is null
\ No newline at end of file
+update TousseInstance set signedUser = invoice.receiptor,signedDate = invoice.receiptingTime from Invoice invoice inner join TousseInstance ti on ti.invoice_id = invoice.id where ti.signedUser is null;
\ No newline at end of file
Index: ssts-web/src/main/webapp/dataUpdater/sqls/3.3.8_3.3.9.sql
===================================================================
diff -u -r12331 -r13187
--- ssts-web/src/main/webapp/dataUpdater/sqls/3.3.8_3.3.9.sql	(.../3.3.8_3.3.9.sql)	(revision 12331)
+++ ssts-web/src/main/webapp/dataUpdater/sqls/3.3.8_3.3.9.sql	(.../3.3.8_3.3.9.sql)	(revision 13187)
@@ -5,4 +5,4 @@
 	WHEN specification is null   THEN name
 	ELSE name + '['+specification+']' END
   FROM DiposableGoods where id= diposableGoodsID)
-   WHERE goodsName is null and diposableGoodsID is not null
\ No newline at end of file
+   WHERE goodsName is null and diposableGoodsID is not null;
\ No newline at end of file
Index: ssts-web/src/main/webapp/dataUpdater/sqls/4.0.2_4.0.3.sql
===================================================================
diff -u -r12331 -r13187
--- ssts-web/src/main/webapp/dataUpdater/sqls/4.0.2_4.0.3.sql	(.../4.0.2_4.0.3.sql)	(revision 12331)
+++ ssts-web/src/main/webapp/dataUpdater/sqls/4.0.2_4.0.3.sql	(.../4.0.2_4.0.3.sql)	(revision 13187)
@@ -1 +1 @@
-update SS_USERATTRIBUTE set newMsgPromptSound = 0
\ No newline at end of file
+update SS_USERATTRIBUTE set newMsgPromptSound = 0;
\ No newline at end of file
Index: ssts-web/src/main/webapp/dataUpdater/sqls/4.0.4_4.0.5_oracle.sql
===================================================================
diff -u -r12331 -r13187
--- ssts-web/src/main/webapp/dataUpdater/sqls/4.0.4_4.0.5_oracle.sql	(.../4.0.4_4.0.5_oracle.sql)	(revision 12331)
+++ ssts-web/src/main/webapp/dataUpdater/sqls/4.0.4_4.0.5_oracle.sql	(.../4.0.4_4.0.5_oracle.sql)	(revision 13187)
@@ -1 +1 @@
-UPDATE (select ti.id,ti.signedUser tisigner,ti.signedDate tidate,i.receiptor isigner,i.receiptingTime idate from TousseInstance ti inner join Invoice i on ti.invoice_id = i.id where ti.signeduser is null and i.receiptor is not null) SET tisigner=isigner,tidate=idate
\ No newline at end of file
+UPDATE (select ti.id,ti.signedUser tisigner,ti.signedDate tidate,i.receiptor isigner,i.receiptingTime idate from TousseInstance ti inner join Invoice i on ti.invoice_id = i.id where ti.signeduser is null and i.receiptor is not null) SET tisigner=isigner,tidate=idate;
\ No newline at end of file
Index: ssts-web/src/main/webapp/dataUpdater/sqls/3.8.0_3.9.0.sql
===================================================================
diff -u -r12331 -r13187
--- ssts-web/src/main/webapp/dataUpdater/sqls/3.8.0_3.9.0.sql	(.../3.8.0_3.9.0.sql)	(revision 12331)
+++ ssts-web/src/main/webapp/dataUpdater/sqls/3.8.0_3.9.0.sql	(.../3.8.0_3.9.0.sql)	(revision 13187)
@@ -1 +1 @@
-update invoicePlan set orderByFiled = 8 where orderByFiled = 7
\ No newline at end of file
+update invoicePlan set orderByFiled = 8 where orderByFiled = 7;
\ No newline at end of file
Index: ssts-web/src/main/webapp/dataUpdater/sqls/4.1.0_4.1.1.sql
===================================================================
diff -u -r12918 -r13187
--- ssts-web/src/main/webapp/dataUpdater/sqls/4.1.0_4.1.1.sql	(.../4.1.0_4.1.1.sql)	(revision 12918)
+++ ssts-web/src/main/webapp/dataUpdater/sqls/4.1.0_4.1.1.sql	(.../4.1.0_4.1.1.sql)	(revision 13187)
@@ -1 +1 @@
-update GoodPurchasePlan set orgUnit_id = (select md.oid from (select min(td.orgUnit_id) as oid,td.goodPurchasePlan_id as pid from(select it.id, it.orgUnit_id,it.goodPurchasePlan_id from GoodPurchaseItem it inner join  goodpurchasePlan p on p.id = it.goodPurchasePlan_id) td group by td.goodPurchasePlan_id) md where md.pid = id)
\ No newline at end of file
+update GoodPurchasePlan set orgUnit_id = (select md.oid from (select min(td.orgUnit_id) as oid,td.goodPurchasePlan_id as pid from(select it.id, it.orgUnit_id,it.goodPurchasePlan_id from GoodPurchaseItem it inner join  goodpurchasePlan p on p.id = it.goodPurchasePlan_id) td group by td.goodPurchasePlan_id) md where md.pid = id);
\ No newline at end of file