[Weberp-cvs] SF.net SVN: web-erp:[3703] trunk

[<tim...@us...>]

Revision: 3703
          http://web-erp.svn.sourceforge.net/web-erp/?rev=3703&view=rev
Author:   tim_schofield
Date:     2010-09-05 09:32:08 +0000 (Sun, 05 Sep 2010)

Log Message:
-----------
Database changes required for report writer

Modified Paths:
--------------
    trunk/doc/Change.log.html
    trunk/sql/mysql/upgrade3.11.1-3.12.sql

Modified: trunk/doc/Change.log.html
===================================================================
--- trunk/doc/Change.log.html	2010-08-31 07:49:50 UTC (rev 3702)
+++ trunk/doc/Change.log.html	2010-09-05 09:32:08 UTC (rev 3703)
@@ -1,5 +1,6 @@
 <p><font SIZE=4 COLOR=BLUE><b>webERP Change Log</b></font></p>
 <p></p>
+<p>31/08/10 Ricard: upgrade3.11.1-3.12.sql - Database changes required for changes to report writer.</p>
 <p>31/08/10 Tim: StockLocTransfer.php - Change quantity input field to have more than 5 digits</p>
 <p>28/08/10 Marcos Garcia Trejo: Fix ConfirmDispatchInvoice.php assembly components new qty on hand </p>
 <p>27/08/10 Tim: Add in rfequisition number into purchase order prints.</p>

Modified: trunk/sql/mysql/upgrade3.11.1-3.12.sql
===================================================================
--- trunk/sql/mysql/upgrade3.11.1-3.12.sql	2010-08-31 07:49:50 UTC (rev 3702)
+++ trunk/sql/mysql/upgrade3.11.1-3.12.sql	2010-09-05 09:32:08 UTC (rev 3703)
@@ -301,3 +301,29 @@
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 
 INSERT INTO `systypes` (`typeid`, `typename`, `typeno`) VALUES ('32', 'Contract Close', '1');
+
+ALTER TABLE `reports` ADD `col9width` INT( 3 ) NOT NULL DEFAULT '25' AFTER `col8width` ;
+
+ALTER TABLE `reports` ADD `col10width` INT( 3 ) NOT NULL DEFAULT '25' AFTER `col9width` ;
+
+ALTER TABLE `reports` ADD `col11width` INT( 3 ) NOT NULL DEFAULT '25' AFTER `col10width` ;
+
+ALTER TABLE `reports` ADD `col12width` INT( 3 ) NOT NULL DEFAULT '25' AFTER `col11width` ;
+
+ALTER TABLE `reports` ADD `col13width` INT( 3 ) NOT NULL DEFAULT '25' AFTER `col12width` ;
+
+ALTER TABLE `reports` ADD `col14width` INT( 3 ) NOT NULL DEFAULT '25' AFTER `col13width` ;
+
+ALTER TABLE `reports` ADD `col15width` INT( 3 ) NOT NULL DEFAULT '25' AFTER `col14width` ;
+
+ALTER TABLE `reports` ADD `col16width` INT( 3 ) NOT NULL DEFAULT '25' AFTER `col15width` ;
+
+ALTER TABLE `reports` ADD `col17width` INT( 3 ) NOT NULL DEFAULT '25' AFTER `col16width` ;
+
+ALTER TABLE `reports` ADD `col18width` INT( 3 ) NOT NULL DEFAULT '25' AFTER `col17width` ;
+
+ALTER TABLE `reports` ADD `col19width` INT( 3 ) NOT NULL DEFAULT '25' AFTER `col18width` ;
+
+ALTER TABLE `reports` ADD `col20width` INT( 3 ) NOT NULL DEFAULT '25' AFTER `col19width` ;
+
+ALTER TABLE `reportfields` CHANGE `fieldname` `fieldname` VARCHAR( 80) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '';


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