From e37b0a1313ac1c9a62f27724f6180108bf8921de Mon Sep 17 00:00:00 2001 From: Janusz Dobrowolski Date: Mon, 12 Nov 2012 19:41:49 +0100 Subject: [PATCH] Changed TYPE keyword to ENGINE in alter2.4.sql for future compatibility. --- sql/alter2.4.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/sql/alter2.4.sql b/sql/alter2.4.sql index 727621cd..ee77647a 100644 --- a/sql/alter2.4.sql +++ b/sql/alter2.4.sql @@ -19,7 +19,7 @@ CREATE TABLE `0_wo_costing` ( `trans_no` int(11) NOT NULL default '0', `factor` double NOT NULL default '1', PRIMARY KEY (`id`) -) TYPE=InnoDB; +) ENGINE=InnoDB; UPDATE `0_gl_trans` gl LEFT JOIN `0_cust_branch` br ON br.receivables_account=gl.account AND br.debtor_no=gl.person_id AND gl.person_type_id=2 -- 2.30.2