[Weberp-svn] SF.net SVN: weberp:[8281] trunk

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

Revision: 8281
          http://weberp.svn.sourceforge.net/weberp/?rev=8281&view=rev
Author:   tim_schofield
Date:     2011-10-13 17:53:35 +0000 (Thu, 13 Oct 2011)
Log Message:
-----------
Updates to the database for internal material requests

Modified Paths:
--------------
    trunk/includes/session.inc

Added Paths:
-----------
    trunk/sql/mysql/updates/97.php

Modified: trunk/includes/session.inc
===================================================================
--- trunk/includes/session.inc	2011-10-13 17:53:24 UTC (rev 8280)
+++ trunk/includes/session.inc	2011-10-13 17:53:35 UTC (rev 8281)
@@ -13,7 +13,7 @@
 	header('Location:' . $rootpath . '/install/index.php');
 }
 include($PathPrefix . 'config.php');
-$DBVersion=96;
+$DBVersion=97;
 if (isset($SessionSavePath)){
 	session_save_path($SessionSavePath);
 }

Added: trunk/sql/mysql/updates/97.php
===================================================================
--- trunk/sql/mysql/updates/97.php	                        (rev 0)
+++ trunk/sql/mysql/updates/97.php	2011-10-13 17:53:35 UTC (rev 8281)
@@ -0,0 +1,20 @@
+<?php
+
+/* Include the new script for printing quotations in Portrait
+ */
+
+InsertRecord('pagesecurity', array('script', 'security'), array('doc/Manual/ManualContents.php',1), array('script', 'security'), array('doc/Manual/ManualContents.php',1), $db);
+
+RenameTable('dispatch', 'stockrequest', $db);
+RenameTable('dispatchitems', 'stockrequestitems', $db);
+
+AddColumn('decimalplaces', 'stockrequestitems', 'int', 'not null', 0, 'quantity', $db);
+AddColumn('uom', 'stockrequestitems', 'varchar(20)', 'not null', '', 'decimalplaces', $db);
+
+ChangeColumnType('dispatchid', 'stockrequest', 'INT (11)', 'NOT NULL', 0, $db);
+
+InsertRecord('systypes', array('typeid'), array('38'), array('typeid', 'typename', 'typeno'), array('38', 'Stock Requests', '0'), $db);
+
+UpdateDBNo(97, $db);
+
+?>
\ No newline at end of file

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