[Fmsystem-commits] [8529]

[Erik Holm-Larsen]

Revision: 8529
          http://svn.sv.gnu.org/viewvc/?view=rev&root=fmsystem&revision=8529
Author:   erikhl
Date:     2012-01-09 08:55:05 +0000 (Mon, 09 Jan 2012)
Log Message:
-----------


Modified Paths:
--------------
    trunk/controller/setup/setup.inc.php
    trunk/controller/setup/tables_current.inc.php
    trunk/controller/setup/tables_update.inc.php

Modified: trunk/controller/setup/setup.inc.php
===================================================================
--- trunk/controller/setup/setup.inc.php        2012-01-09 08:25:23 UTC (rev 
8528)
+++ trunk/controller/setup/setup.inc.php        2012-01-09 08:55:05 UTC (rev 
8529)
@@ -1,6 +1,6 @@
 <?php
        $setup_info['controller']['name'] = 'controller';
-       $setup_info['controller']['version'] = '0.1.17';
+       $setup_info['controller']['version'] = '0.1.18';
        $setup_info['controller']['app_order'] = 100;
        $setup_info['controller']['enable'] = 1;
        $setup_info['controller']['app_group']  = 'office';

Modified: trunk/controller/setup/tables_current.inc.php
===================================================================
--- trunk/controller/setup/tables_current.inc.php       2012-01-09 08:25:23 UTC 
(rev 8528)
+++ trunk/controller/setup/tables_current.inc.php       2012-01-09 08:55:05 UTC 
(rev 8529)
@@ -188,15 +188,21 @@
                        'uc' => array()
                ),
                'controller_check_item_case', array(
-                               'fd' => array(
-                                       'id'                    => array('type' 
=> 'auto', 'nullable' => false),
-                                       'check_item_id'         => array('type' 
=> 'int', 'precision' => '4', 'nullable' => false),
-                                       'message_ticket_id' => array('type' => 
'int', 'precision' => '12', 'nullable' => true),
-                                       'measurement'           => array('type' 
=> 'int', 'precision' => '12', 'nullable' => true)
-                               ),
-                               'pk' => array('id'),
-                               'fk' => array(),
-                               'ix' => array(),
-                               'uc' => array()
+                       'fd' => array(
+                               'id'                    => array('type' => 
'auto', 'nullable' => false),
+                               'check_item_id'         => array('type' => 
'int', 'precision' => '4', 'nullable' => false),
+                               'status' => array('type' => 'int', 'precision' 
=> '4', 'nullable' => false),
+                               'location_id' => array('type' => 'int', 
'precision' => '4', 'nullable' => true), // representer meldingsfregisteret
+                    'location_item_id' => array('type' => 'int', 'precision' 
=> '8', 'nullable' => true), //meldings id
+                    'descr' => array('type' => 'text','nullable' => true),
+                    'user_id' => array('type' => 'int','precision' => 
'4','nullable' => true),
+                    'entry_date' => array('type' => 'int', 'precision' => 
4,'nullable' => false),
+                    'modified_date' => array('type' => 'int', 'precision' => 
4,'nullable' => True),
+                    'modified_by' => array('type' => 'int', 'precision' => 
4,'nullable' => True),
+              ),
+                'pk' => array('id'),
+                'fk' => array('controller_check_item' => array('check_item_id' 
=> 'id')),
+                'ix' => array(),
+                'uc' => array()
                )
        );

Modified: trunk/controller/setup/tables_update.inc.php
===================================================================
--- trunk/controller/setup/tables_update.inc.php        2012-01-09 08:25:23 UTC 
(rev 8528)
+++ trunk/controller/setup/tables_update.inc.php        2012-01-09 08:55:05 UTC 
(rev 8529)
@@ -360,4 +360,41 @@
                
                $GLOBALS['setup_info']['controller']['currentver'] = '0.1.17';
                return $GLOBALS['setup_info']['controller']['currentver'];
+       }
+       
+       $test[] = '0.1.17'; 
+       function controller_upgrade0_1_17()
+       {
+               
$GLOBALS['phpgw_setup']->oProc->DropTable('controller_check_item_case');
+               
+               $GLOBALS['phpgw_setup']->oProc->CreateTable(
+                       'controller_check_item_case', array(
+                               'fd' => array(
+                                       'id' => array('type' => 'auto', 
'nullable' => false),
+                                       'check_item_id' => array('type' => 
'int', 'precision' => '4', 'nullable' => false),
+                                       'status' => array('type' => 'int', 
'precision' => '4', 'nullable' => false),
+                                       'location_id' => array('type' => 'int', 
'precision' => '4', 'nullable' => true), // representer meldingsfregisteret
+                                       'location_item_id' => array('type' => 
'int', 'precision' => '8', 'nullable' => true), //meldings id
+                                       'descr' => array('type' => 
'text','nullable' => true),
+                                       'user_id' => array('type' => 
'int','precision' => '4','nullable' => true),
+                                       'entry_date' => array('type' => 'int', 
'precision' => 4,'nullable' => false),
+                                       'modified_date' => array('type' => 
'int', 'precision' => 4,'nullable' => True),
+                                       'modified_by' => array('type' => 'int', 
'precision' => 4,'nullable' => True),
+                     ),
+                       'pk' => array('id'),
+                       'fk' => array('controller_check_item' => 
array('check_item_id' => 'id')),
+                       'ix' => array(),
+                       'uc' => array()
+                       )
+               );
+               
+               
$GLOBALS['phpgw_setup']->oProc->AddColumn('controller_check_item', 
'measurement',array(
+                       'type' => 'int',
+                       'precision' => 8,
+                       'nullable' => true,
+                       'default' => 0
+               ));
+
+               $GLOBALS['setup_info']['controller']['currentver'] = '0.1.18';
+               return $GLOBALS['setup_info']['controller']['currentver'];
        }
\ No newline at end of file