[Web-erp-svn] SF.net SVN: web-erp:[7460] trunk/sql/mysql/upgrade4.12.3-4.13.sql

[<ex...@us...>]

Revision: 7460
          http://sourceforge.net/p/web-erp/reponame/7460
Author:   exsonqu
Date:     2016-02-20 08:00:32 +0000 (Sat, 20 Feb 2016)
Log Message:
-----------
20/02/16 Janb,Tim Fixed typo in the upgrade4.12.3-4.13.sql.

Modified Paths:
--------------
    trunk/sql/mysql/upgrade4.12.3-4.13.sql

Modified: trunk/sql/mysql/upgrade4.12.3-4.13.sql
===================================================================
--- trunk/sql/mysql/upgrade4.12.3-4.13.sql	2016-02-19 10:43:20 UTC (rev 7459)
+++ trunk/sql/mysql/upgrade4.12.3-4.13.sql	2016-02-20 08:00:32 UTC (rev 7460)
@@ -14,7 +14,7 @@
 	('EmailCustStatements.php','3','Email customer statement to customer'),
 	('GLAccountUsers.php', '15', 'Maintenance of users allowed to a GL Account'),
 	('SupplierGRNAndInvoiceInquiry.php',5,'Supplier\'s delivery note and grn relationship inquiry'),
-	('UserBankAccounts.php', '15', 'Maintains table bankaccountusers (Authorized users to work with a bank account in webERP)')
+	('UserBankAccounts.php', '15', 'Maintains table bankaccountusers (Authorized users to work with a bank account in webERP)'),
 	('UserGLAccounts.php', '15', 'Maintenance of GL Accounts allowed for a user');
 
 CREATE TABLE IF NOT EXISTS `suppinvstogrn` (
@@ -49,7 +49,7 @@
 ALTER table stockrequest DROP FOREIGN KEY `stockrequest_ibfk_3`;
 ALTER table stockrequest DROP FOREIGN KEY `stockrequest_ibfk_4`;
 INSERT INTO scripts VALUES('CollectiveWorkOrderCost.php',2,'Multiple work orders cost review');
-ALTER table BOM ADD remark varchar(500) NOT NULL DEFAULT '';
+ALTER table bom ADD remark varchar(500) NOT NULL DEFAULT '';
 INSERT INTO scripts VALUES ('SuppWhereAlloc.php',3,'Suppliers Where allocated');