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

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

Revision: 4639
          http://weberp.svn.sourceforge.net/weberp/?rev=4639&view=rev
Author:   tim_schofield
Date:     2011-03-01 14:07:19 +0000 (Tue, 01 Mar 2011)

Log Message:
-----------
Add new database field for sales unit of measure

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

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

Modified: trunk/includes/session.inc
===================================================================
--- trunk/includes/session.inc	2011-03-01 12:49:38 UTC (rev 4638)
+++ trunk/includes/session.inc	2011-03-01 14:07:19 UTC (rev 4639)
@@ -13,7 +13,7 @@
 	header('Location:' . $rootpath . '/install/index.php');
 }
 include($PathPrefix . 'config.php');
-$DBVersion=63;
+$DBVersion=64;
 if (isset($SessionSavePath)){
 	session_save_path($SessionSavePath);
 }

Added: trunk/sql/mysql/updates/64.php
===================================================================
--- trunk/sql/mysql/updates/64.php	                        (rev 0)
+++ trunk/sql/mysql/updates/64.php	2011-03-01 14:07:19 UTC (rev 4639)
@@ -0,0 +1,13 @@
+<?php
+
+/* Add extra field into prices table for unit of measure
+ */
+
+AddColumn('units', 'prices', 'varchar(20)', 'NOT NULL', 'each', 'price', $db);
+
+$sql="UPDATE prices SET units=(SELECT units FROM stockmaster WHERE prices.stockid=stockmaster.stockid)";
+$result=DB_query($sql, $db);
+
+UpdateDBNo(64, $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.