[Web-erp-svn] SF.net SVN: web-erp:[4600] trunk/sql/mysql/upgrade4.04-4.04.1.sql

[<dai...@us...>]

Revision: 4600
          http://web-erp.svn.sourceforge.net/web-erp/?rev=4600&view=rev
Author:   daintree
Date:     2011-06-18 07:05:12 +0000 (Sat, 18 Jun 2011)

Log Message:
-----------
sql script amended

Modified Paths:
--------------
    trunk/sql/mysql/upgrade4.04-4.04.1.sql

Modified: trunk/sql/mysql/upgrade4.04-4.04.1.sql
===================================================================
--- trunk/sql/mysql/upgrade4.04-4.04.1.sql	2011-06-18 05:13:36 UTC (rev 4599)
+++ trunk/sql/mysql/upgrade4.04-4.04.1.sql	2011-06-18 07:05:12 UTC (rev 4600)
@@ -1,6 +1,3 @@
-INSERT INTO scripts (script, pagesecurity, description) VALUES ('SalesTopItemsInquiry.php', 2, 'Shows top selling items either by quantity or sales value by user selectable period range');
-INSERT INTO scripts (script, pagesecurity, description) VALUES ('SalesCategoryPeriodInquiry.php', 2, 'Shows sales by caetgory for a user selectable period range');
-INSERT INTO scripts (script, pagesecurity, description) VALUES ('SalesByTypePeriodInquiry.php', 2, 'Shows sales value by sales type by user selectable period range');
 ALTER TABLE `scripts` CHANGE `pagesecurity` `pagesecurity` INT( 11 ) NOT NULL DEFAULT '1';
 ALTER TABLE  `pctabs` ADD  `assigner` VARCHAR( 20 ) NOT NULL COMMENT  'Cash assigner for the tab' AFTER  `tablimit`;
 UPDATE pctabs SET assigner = authorizer;


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.