[Fmsystem-commits] [10174] Logistic: New implementation of database

[Torstein]

Revision: 10174
          http://svn.sv.gnu.org/viewvc/?view=rev&root=fmsystem&revision=10174
Author:   vator
Date:     2012-10-09 11:50:27 +0000 (Tue, 09 Oct 2012)
Log Message:
-----------
Logistic: New implementation of database

Modified Paths:
--------------
    trunk/logistic/setup/tables_update.inc.php

Modified: trunk/logistic/setup/tables_update.inc.php
===================================================================
--- trunk/logistic/setup/tables_update.inc.php  2012-10-09 11:47:18 UTC (rev 
10173)
+++ trunk/logistic/setup/tables_update.inc.php  2012-10-09 11:50:27 UTC (rev 
10174)
@@ -1,108 +1,2 @@
 <?php
-        /* Update Logistic from v 0.0.1 to 0.0.2
-         * Add column 'description' to table activity
-         */
-
-       $test[] = '0.0.1';
-       function logistic_upgrade0_0_1()
-       {
-               
$GLOBALS['phpgw_setup']->oProc->AddColumn('lg_activity','description',array(
-                       'type' => 'text',
-                       'nullable' => True
-               ));
-
-               $GLOBALS['setup_info']['logistic']['currentver'] = '0.0.2';
-               return $GLOBALS['setup_info']['logistic']['currentver'];
-       }
-
-       /* Update Logistic from v 0.0.2 to 0.0.3
-       * Add locations
-       */
-
-       $test[] = '0.0.2';
-       function logistic_upgrade0_0_2()
-       {
-               $GLOBALS['phpgw']->locations->add('.', 'Topp', 'logistic');
-               $GLOBALS['phpgw']->locations->add('.project', 'Prosjekt', 
'logistic');
-               $GLOBALS['phpgw']->locations->add('.activity', 'Aktivitet', 
'logistic');
-
-               $GLOBALS['setup_info']['logistic']['currentver'] = '0.0.3';
-               return $GLOBALS['setup_info']['logistic']['currentver'];
-       }
-
-       /*
-        * Update Logistic from v 0.0.3 to 0.0.4
-        * Add columns for custom attribute id and location id to 
lg_requirement_value
-        * Alter lg_bim_item_type_requirement: add cust_attribute_id column, 
remove attribute-colums
-        */
-
-       $test[] = '0.0.3';
-       function logistic_upgrade0_0_3()
-       {
-               
$GLOBALS['phpgw_setup']->oProc->AddColumn('lg_requirement_value','location_id',array(
-                       'type' => 'int',
-                       'precision' => 4,
-                       'nullable' => True
-               ));
-
-               
$GLOBALS['phpgw_setup']->oProc->AddColumn('lg_requirement_value','cust_attribute_id',array(
-                       'type' => 'int',
-                       'precision' => 4,
-                       'nullable' => True
-               ));
-
-               
$GLOBALS['phpgw_setup']->oProc->DropColumn('lg_bim_item_type_requirement', 
array(), 'attribute_name');
-               
$GLOBALS['phpgw_setup']->oProc->DropColumn('lg_bim_item_type_requirement', 
array(), 'attribute_type');
-
-               
$GLOBALS['phpgw_setup']->oProc->AddColumn('lg_bim_item_type_requirement','cust_attribute_id_id',array(
-                       'type' => 'varchar',
-                       'precision' => '255',
-                       'nullable' => True
-               ));
-
-               $GLOBALS['setup_info']['logistic']['currentver'] = '0.0.4';
-               return $GLOBALS['setup_info']['logistic']['currentver'];
-       }
-
-       $test[] = '0.0.4';
-       function logistic_upgrade0_0_4()
-       {
-               
$GLOBALS['phpgw_setup']->oProc->AddColumn('lg_requirement_value','requirement_id',array(
-                       'type' => 'int',
-                       'precision' => 4,
-                       'nullable' => True
-               ));
-
-               $GLOBALS['setup_info']['logistic']['currentver'] = '0.0.5';
-               return $GLOBALS['setup_info']['logistic']['currentver'];
-       }
-
-       $test[] = '0.0.5';
-       function logistic_upgrade0_0_5()
-       {
-               
$GLOBALS['phpgw_setup']->oProc->DropColumn('lg_bim_item_type_requirement', 
array(), 'cust_attribute_id_id');
-
-               
$GLOBALS['phpgw_setup']->oProc->AddColumn('lg_bim_item_type_requirement','cust_attribute_id',array(
-                       'type' => 'varchar',
-                       'precision' => '255',
-                       'nullable' => True
-               ));
-
-               $GLOBALS['setup_info']['logistic']['currentver'] = '0.0.6';
-               return $GLOBALS['setup_info']['logistic']['currentver'];
-       }
-
-       $test[] = '0.0.6';
-       function logistic_upgrade0_0_6()
-       {
-               
$GLOBALS['phpgw_setup']->oProc->RenameColumn('lg_bim_item_type_requirement','location_id','entity_id');
-
-               
$GLOBALS['phpgw_setup']->oProc->AddColumn('lg_bim_item_type_requirement','category_id',array(
-                       'type' => 'varchar',
-                       'precision' => '255',
-                       'nullable' => True
-               ));
-
-               $GLOBALS['setup_info']['logistic']['currentver'] = '0.0.7';
-               return $GLOBALS['setup_info']['logistic']['currentver'];
-       }
\ No newline at end of file
+        
\ No newline at end of file