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

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

Revision: 4448
          http://web-erp.svn.sourceforge.net/web-erp/?rev=4448&view=rev
Author:   tim_schofield
Date:     2010-12-26 12:28:47 +0000 (Sun, 26 Dec 2010)

Log Message:
-----------
Add new database upgrade. Removes constraint from debtortrans

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

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

Modified: trunk/includes/session.inc
===================================================================
--- trunk/includes/session.inc	2010-12-26 08:33:29 UTC (rev 4447)
+++ trunk/includes/session.inc	2010-12-26 12:28:47 UTC (rev 4448)
@@ -13,7 +13,7 @@
 	header('Location:' . $rootpath . '/install/index.php');
 }
 include($PathPrefix . 'config.php');
-$DBVersion=52;
+$DBVersion=53;
 if (isset($SessionSavePath)){
 	session_save_path($SessionSavePath);
 }
@@ -118,7 +118,7 @@
 if (isset($_SESSION[basename($_SERVER['SCRIPT_NAME'])])) {
 	$PageSecurity = $_SESSION[basename($_SERVER['SCRIPT_NAME'])];
 }
-	
+
 if (($DBVersion>$_SESSION['DBUpdateNumber']) and (basename($_SERVER['SCRIPT_NAME'])!='UpgradeDatabase.php')) {
 	header("Location: UpgradeDatabase.php");
 }
@@ -286,7 +286,7 @@
 					</tr>
 					</table>
 					</td>';
-			
+
 		include($PathPrefix . 'includes/footer.inc');
 		exit;
 	}

Added: trunk/sql/mysql/updates/53.php
===================================================================
--- trunk/sql/mysql/updates/53.php	                        (rev 0)
+++ trunk/sql/mysql/updates/53.php	2010-12-26 12:28:47 UTC (rev 4448)
@@ -0,0 +1,10 @@
+<?php
+
+/* Remove foreign key from debtortrans table
+ */
+
+DropConstraint('debtortrans', 'debtortrans_ibfk_1', $db);
+
+UpdateDBNo(53, $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.