Changeset 2189 for trunk/phpgwapi/setup/tables_update.inc.php

Timestamp:

03/08/10 10:28:09 (14 years ago)

Author:

amuller

Message:

Ticket #597 - atualizando as tabelas que são obrigatorias do fm

File:

• trunk/phpgwapi/setup/tables_update.inc.php (modified) (1 diff)

trunk/phpgwapi/setup/tables_update.inc.php

@@ -1685 +1685 @@
                 return $GLOBALS['setup_info']['phpgwapi']['currentver'];
         }
+        $test[] = '2.1.000';
+        function phpgwapi_upgrade2_1_000()
+        {
+                $GLOBALS['setup_info']['phpgwapi']['currentver'] = '2.2.000';
+                $GLOBALS['phpgw_setup']->oProc->CreateTable(
+                        'phpgw_vfs_quota', array(
+                                'fd' => array(
+                                        'directory'        => array('type' => 'varchar',   'precision' => 100,  'nullable' => False),
+                                        'quota_size'      => array('type' => 'integer', 'nullable' => False)
+                                ),
+                                'pk' => array('directory'),
+                                'fk' => array(),
+                                'ix' => array(),
+                                'uc' => array()
+                        )
+                );
+                $GLOBALS['phpgw_setup']->oProc->AddColumn('phpgw_vfs','type', array ('type' => 'integer', 'nullable' => True));
+                $GLOBALS['phpgw_setup']->oProc->AddColumn('phpgw_vfs','summary', array ('type' => 'bytea', 'nullable' => True));
+                $GLOBALS['phpgw_setup']->oProc->AlterColumn('phpgw_vfs','created', array('type' => 'timestamp'));
+                $GLOBALS['phpgw_setup']->oProc->AlterColumn('phpgw_vfs','modified', array('type' => 'timestamp'));
+                return $GLOBALS['setup_info']['phpgwapi']['currentver'];
+        }
 ?>