[Fmsystem-commits] [6982] property: fix update script

[Sigurd Nes]

Revision: 6982
          http://svn.sv.gnu.org/viewvc/?view=rev&root=fmsystem&revision=6982
Author:   sigurdne
Date:     2011-02-14 20:01:17 +0000 (Mon, 14 Feb 2011)
Log Message:
-----------
property: fix update script

Modified Paths:
--------------
    branches/dev-bim2/property/setup/setup.inc.php
    branches/dev-bim2/property/setup/tables_update.inc.php

Modified: branches/dev-bim2/property/setup/setup.inc.php
===================================================================
--- branches/dev-bim2/property/setup/setup.inc.php      2011-02-14 12:36:59 UTC 
(rev 6981)
+++ branches/dev-bim2/property/setup/setup.inc.php      2011-02-14 20:01:17 UTC 
(rev 6982)
@@ -12,7 +12,7 @@
        */
 
        $setup_info['property']['name']                 = 'property';
-       $setup_info['property']['version']              = '0.9.17.601';
+       $setup_info['property']['version']              = '0.9.17.602';
        $setup_info['property']['app_order']    = 8;
        $setup_info['property']['enable']               = 1;
        $setup_info['property']['app_group']    = 'office';

Modified: branches/dev-bim2/property/setup/tables_update.inc.php
===================================================================
--- branches/dev-bim2/property/setup/tables_update.inc.php      2011-02-14 
12:36:59 UTC (rev 6981)
+++ branches/dev-bim2/property/setup/tables_update.inc.php      2011-02-14 
20:01:17 UTC (rev 6982)
@@ -4938,7 +4938,7 @@
                $GLOBALS['phpgw_setup']->oProc->CreateTable(
                        'fm_bim_type', array(
                                'fd' => array(
-                                       'id' => array('type' => 'auto', 
'nullable' => False),
+                                       'id' => array('type' => 'auto', 
'precision' => 4, 'nullable' => False),
                                        'name' => array('type' => 'varchar', 
'precision' => 64,'nullable' => False),
                                        'description' => array('type' => 
'varchar', 'precision' => 512,'nullable' => True)
                                ),
@@ -4952,10 +4952,10 @@
                $GLOBALS['phpgw_setup']->oProc->CreateTable(
                        'fm_bim_model', array(
                                'fd' => array(
-                                       'id' => array('type' => 
'auto','nullable' => True),
+                                       'id' => array('type' => 'auto', 
'precision' => 4,'nullable' => True),
                                        'name' => array('type' => 'varchar', 
'precision' => 128,'nullable' => False),
-                                       'vfs_file_id' => array('type' => 'int', 
'nullable' => False),
-                                       'authorization_value' => array('type' 
=> 'varchar', 'precision' => 200,'nullable' => False),
+                                       'vfs_file_id' => array('type' => 'int', 
'precision' => 4, 'nullable' => False),
+                                       'authorization_value' => array('type' 
=> 'varchar', 'precision' => 200,'nullable' => true),
                                        'author' => array('type' => 'varchar', 
'precision' => 256,'nullable' => True),
                                        'changedate' => array('type' => 
'timestamp','nullable' => True),
                                        'description' => array('type' => 
'varchar', 'precision' => 512,'nullable' => True),
@@ -4968,18 +4968,18 @@
                                'pk' => array('id'),
                                'fk' => array('phpgw_vfs' => 
array('vfs_file_id' => 'file_id')),
                                'ix' => array(),
-                               'uc' => array('')
+                               'uc' => array()
                        )
                );
                
                $GLOBALS['phpgw_setup']->oProc->CreateTable(
                        'fm_bim_item', array(
                                'fd' => array(
-                                       'id' => array('type' => 'auto', 
'nullable' => False),
-                                       'type' => array('type' => 
'int','nullable' => False),
+                                       'id' => array('type' => 'auto', 
'precision' => 4, 'nullable' => False),
+                                       'type' => array('type' => 'int', 
'precision' => 4,'nullable' => False),
                                        'guid' => array('type' => 'varchar', 
'precision' => 24,'nullable' => False),
                                        'xml_representation' => array('type' => 
'xml','nullable' => False),
-                                       'model' => array('type' => 
'int','nullable' => False),
+                                       'model' => array('type' => 'int', 
'precision' => 4,'nullable' => False),
                                ),
                                'pk' => array('id'),
                                'fk' => array('fm_bim_model' => array('model' 
=> 'id'),
@@ -4991,10 +4991,7 @@
 
                if($GLOBALS['phpgw_setup']->oProc->m_odb->transaction_commit())
                {
-                       $GLOBALS['setup_info']['property']['currentver'] = 
'0.9.17.601';
+                       $GLOBALS['setup_info']['property']['currentver'] = 
'0.9.17.602';
                        return $GLOBALS['setup_info']['property']['currentver'];
                }
        }
-       
-       
-