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

Timestamp:

05/06/13 18:33:29 (11 years ago)

Author:

acoutinho

Message:

Ticket #3443 - Atualizacao de todos os modulos para versao 2.5.1

File:

• trunk/phpgwapi/setup/tables_update.inc.php (modified) (4 diffs)

trunk/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'];
-
         }
 
@@ -179 +177 @@
     function phpgwapi_upgrade2_4_2()
     {
-            $GLOBALS['setup_info']['phpgwapi']['currentver'] = '2.5.0';
-            return $GLOBALS['setup_info']['phpgwapi']['currentver'];
+        $GLOBALS['setup_info']['phpgwapi']['currentver'] = '2.5.0';
+        return $GLOBALS['setup_info']['phpgwapi']['currentver'];
     }
 
@@ -186 +184 @@
         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'];
-        }
-    
-
+        $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'];
+    }
 ?>