Changeset 8232 for branches/2.5/phpgwapi/setup/tables_update.inc.php

Timestamp:

10/08/13 16:20:46 (11 years ago)

Author:

douglas

Message:

Ticket #0000 - Copiadas as alterações do Trunk. Versão final 2.5.1.

File:

• branches/2.5/phpgwapi/setup/tables_update.inc.php (modified) (3 diffs)

branches/2.5/phpgwapi/setup/tables_update.inc.php

@@ -20 +20 @@
                 $GLOBALS['setup_info']['phpgwapi']['currentver'] = '1.0.0.008';
                 return $GLOBALS['setup_info']['phpgwapi']['currentver'];
-
         }
         
@@ -28 +27 @@
                 $GLOBALS['setup_info']['phpgwapi']['currentver'] = '2.0.0.pre-alpha';
                 return $GLOBALS['setup_info']['phpgwapi']['currentver'];
-
         }
 
@@ -176 +174 @@
                 return $GLOBALS['setup_info']['phpgwapi']['currentver'];
         }
-    $test[] = '2.4.2'; 
-    function phpgwapi_upgrade2_4_2() 
-    { 
-            $GLOBALS['setup_info']['phpgwapi']['currentver'] = '2.5.0'; 
-            return $GLOBALS['setup_info']['phpgwapi']['currentver']; 
-    } 
- 
-    $test[] = '2.5.0'; 
-        function phpgwapi_upgrade2_5_0() 
-        { 
-                $GLOBALS['setup_info']['phpgwapi']['currentver'] = '2.5.1'; 
-                global $setup_info,$phpgw_setup; 
-                $phpgw_setup->oProc->query("ALTER TABLE phpgw_access_log ALTER COLUMN ip TYPE character varying(255) "); 
- 
-                return $GLOBALS['setup_info']['phpgwapi']['currentver']; 
-        } 
-     
-
+    $test[] = '2.4.2';
+    function phpgwapi_upgrade2_4_2()
+    {
+        $GLOBALS['setup_info']['phpgwapi']['currentver'] = '2.5.0';
+        return $GLOBALS['setup_info']['phpgwapi']['currentver'];
+    }
+
+    $test[] = '2.5.0';
+        function phpgwapi_upgrade2_5_0()
+        {
+        $GLOBALS['setup_info']['phpgwapi']['currentver'] = '2.5.1';
+        global $setup_info,$phpgw_setup;
+        $phpgw_setup->oProc->query("ALTER TABLE phpgw_access_log ALTER COLUMN ip TYPE character varying(255) ");
+
+        return $GLOBALS['setup_info']['phpgwapi']['currentver'];
+        }
+
+    $test[] = '2.5.1';
+    function phpgwapi_upgrade2_5_1()
+    {
+        global $phpgw_setup;
+
+        $phpgw_setup->oProc->query( 'select * from information_schema.tables where table_name= \'phpgw_vfs\'');
+        if( !$phpgw_setup->oProc->next_record() )
+        {
+            $phpgw_setup->oProc->CreateTable('phpgw_vfs', array(
+                'fd' => array(
+                    'file_id' => array('type' => 'auto','nullable' => False),
+                    'owner_id' => array('type' => 'int','precision' => '4','nullable' => False),
+                    'createdby_id' => array('type' => 'int','precision' => '4'),
+                    'modifiedby_id' => array('type' => 'int','precision' => '4'),
+                    'created' => array('type' => 'timestamp','nullable' => False,'default' => '1970-01-01'),
+                    'modified' => array('type' => 'timestamp'),
+                    'size' => array('type' => 'int','precision' => '4'),
+                    'mime_type' => array('type' => 'varchar','precision' => '64'),
+                    'deleteable' => array('type' => 'char','precision' => '1','default' => 'Y'),
+                    'comment' => array('type' => 'varchar','precision' => '255'),
+                    'app' => array('type' => 'varchar','precision' => '25'),
+                    'directory' => array('type' => 'varchar','precision' => '255'),
+                    'name' => array('type' => 'varchar','precision' => '128','nullable' => False),
+                    'link_directory' => array('type' => 'varchar','precision' => '255'),
+                    'link_name' => array('type' => 'varchar','precision' => '128'),
+                    'version' => array('type' => 'varchar','precision' => '30','nullable' => False,'default' => '0.0.0.0'),
+                    'content' => array('type' => 'longtext')
+                )
+            ));
+        }
+
+        $GLOBALS['setup_info']['phpgwapi']['currentver'] = '2.5.1.0';
+        return $GLOBALS['setup_info']['phpgwapi']['currentver'];
+    }
 ?>