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.
|
