From cf502cf9d94e5341eddd9138cd9896be595ce108 Mon Sep 17 00:00:00 2001 From: Joe Hunt Date: Mon, 15 Feb 2016 12:20:39 +0100 Subject: [PATCH] More missing semicolons. --- sql/alter2.4.sql | 2 +- sql/alter2.4rc1.sql | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/sql/alter2.4.sql b/sql/alter2.4.sql index 936745ba..fed9c845 100644 --- a/sql/alter2.4.sql +++ b/sql/alter2.4.sql @@ -301,6 +301,6 @@ UPDATE `0_wo_issue_items` i, `0_stock_moves` m UPDATE `0_wo_requirements` r, `0_stock_moves` m SET r.unit_cost=m.standard_cost - WHERE r.unit_cost=0 AND r.stock_id=m.stock_id AND m.trans_no=r.workorder_id AND m.`type`=26 AND m.qty=-r.units_issued + WHERE r.unit_cost=0 AND r.stock_id=m.stock_id AND m.trans_no=r.workorder_id AND m.`type`=26 AND m.qty=-r.units_issued; UPDATE `0_bank_trans` SET person_id=trans_no WHERE person_type_id=26; diff --git a/sql/alter2.4rc1.sql b/sql/alter2.4rc1.sql index d49e498a..828e0e06 100644 --- a/sql/alter2.4rc1.sql +++ b/sql/alter2.4rc1.sql @@ -43,6 +43,6 @@ UPDATE `0_wo_issue_items` i, `0_stock_moves` m UPDATE `0_wo_requirements` r, `0_stock_moves` m SET r.unit_cost=m.standard_cost - WHERE r.unit_cost=0 AND r.stock_id=m.stock_id AND m.trans_no=r.workorder_id AND m.`type`=26 AND m.qty=-r.units_issued + WHERE r.unit_cost=0 AND r.stock_id=m.stock_id AND m.trans_no=r.workorder_id AND m.`type`=26 AND m.qty=-r.units_issued; UPDATE `0_bank_trans` SET person_id=trans_no WHERE person_type_id=26; -- 2.30.2