[Web-erp-svn] SF.net SVN: web-erp:[7309] trunk/sql/mysql/upgrade4.12.2-4.12.3.sql

[<rc...@us...>]

Revision: 7309
          http://sourceforge.net/p/web-erp/reponame/7309
Author:   rchacon
Date:     2015-05-21 13:09:09 +0000 (Thu, 21 May 2015)
Log Message:
-----------
Clean up SQL code file.

Modified Paths:
--------------
    trunk/sql/mysql/upgrade4.12.2-4.12.3.sql

Modified: trunk/sql/mysql/upgrade4.12.2-4.12.3.sql
===================================================================
--- trunk/sql/mysql/upgrade4.12.2-4.12.3.sql	2015-05-19 14:13:54 UTC (rev 7308)
+++ trunk/sql/mysql/upgrade4.12.2-4.12.3.sql	2015-05-21 13:09:09 UTC (rev 7309)
@@ -1,12 +1,12 @@
-INSERT INTO `scripts` (`script`, `pagesecurity`, `description`) VALUES ('CustomerAccount.php', '1', 'Shows customer account/statement on screen rather than PDF');
-INSERT INTO `scripts` (`script`, `pagesecurity`, `description`) VALUES ('StockCategorySalesInquiry.php', '2', 'Sales inquiry by stock category showing top items');
-INSERT INTO `scripts` (`script`, `pagesecurity`, `description`) VALUES ('PcAnalysis.php', '15', 'Creates an Excel with details of PC expnese for 24 months');
+INSERT INTO `scripts` (`script`, `pagesecurity`, `description`) VALUES 
+	('CustomerAccount.php', '1', 'Shows customer account/statement on screen rather than PDF'),
+	('PcAnalysis.php', '15', 'Creates an Excel with details of PC expense for 24 months'),
+	('StockCategorySalesInquiry.php', '2', 'Sales inquiry by stock category showing top items');
 
 -- Add field to store location's GL account code:
 ALTER TABLE `locations` ADD `glaccountcode` VARCHAR(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT 'GL account of the location';
 -- Add field to allow or deny the invoicing of items in this location:
 ALTER TABLE `locations` ADD `allowinvoicing` TINYINT(1) NOT NULL DEFAULT '1' COMMENT 'Allow invoicing of items at this location';
----- QUESTION: Existing locations are (always) set to 1? ***********************
 
 -- Update version number:
 UPDATE config SET confvalue='4.12.3' WHERE confname='VersionNumber';