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

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

Revision: 8198
          http://weberp.svn.sourceforge.net/weberp/?rev=8198&view=rev
Author:   tim_schofield
Date:     2011-09-26 20:31:10 +0000 (Mon, 26 Sep 2011)
Log Message:
-----------
New table for stockorderitemproperties

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

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

Modified: trunk/includes/session.inc
===================================================================
--- trunk/includes/session.inc	2011-09-26 20:30:58 UTC (rev 8197)
+++ trunk/includes/session.inc	2011-09-26 20:31:10 UTC (rev 8198)
@@ -13,7 +13,7 @@
 	header('Location:' . $rootpath . '/install/index.php');
 }
 include($PathPrefix . 'config.php');
-$DBVersion=93;
+$DBVersion=94;
 if (isset($SessionSavePath)){
 	session_save_path($SessionSavePath);
 }

Added: trunk/sql/mysql/updates/94.php
===================================================================
--- trunk/sql/mysql/updates/94.php	                        (rev 0)
+++ trunk/sql/mysql/updates/94.php	2011-09-26 20:31:10 UTC (rev 8198)
@@ -0,0 +1,20 @@
+<?php
+
+CreateTable('stockorderitemproperties', "CREATE TABLE `stockorderitemproperties` (
+`stockid` varchar(20) NOT NULL,
+`orderno` int(11) NOT NULL,
+`orderlineno` int(11) NOT NULL,
+`stkcatpropid` int(11) NOT NULL,
+`value` varchar(50) NOT NULL,
+PRIMARY KEY (`stockid`,`orderno`,`orderlineno`,`stkcatpropid`),
+KEY `stockid` (`stockid`),
+KEY `orderno` (`orderno`),
+KEY `stkcatpropid` (`stkcatpropid`),
+KEY `value` (`value`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;", $db);
+
+
+
+UpdateDBNo(94, $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.