Changeset 5203

Timestamp:

11/23/11 16:20:35 (11 years ago)

Author:

acoutinho

Message:

Ticket #2341 - Verificar scripts de atualizacao de tabelas da versao 2.4

Location:

trunk/calendar/setup

Files:

• setup.inc.php (modified) (1 diff)
• tables_current.inc.php (modified) (1 diff)
• tables_update.inc.php (modified) (1 diff)

trunk/calendar/setup/setup.inc.php

@@ -12 +12 @@
 
         $setup_info['calendar']['name']    = 'calendar';
-        $setup_info['calendar']['version'] = '2.0.008';
+        $setup_info['calendar']['version'] = '2.0.009';
         $setup_info['calendar']['app_order'] = 3;
         $setup_info['calendar']['enable']  = 1;

trunk/calendar/setup/tables_current.inc.php

@@ -30 +30 @@
                                 'reference' => array('type' => 'int','precision' => '8','nullable' => False,'default' => '0'),
                                 'ex_participants' => array('type' => 'text','nullable' => True),
+                                'observations' => array('type' => 'text','nullable' => True),
+                                'attachment' => array('type' => 'text','nullable' => True),
+                                'alter_by' => array('type' => 'varchar','precision' => '160','nullable' => True)
                         ),
                         'pk' => array('cal_id'),

trunk/calendar/setup/tables_update.inc.php

@@ -108 +108 @@
         function calendar_upgrade2_0_007() {
                 $GLOBALS['setup_info']['calendar']['currentver'] = '2.0.008';
-                $GLOBALS['phpgw_setup']->db->query("ALTER TABLE phpgw_cal ADD COLUMN organizer character varying(255);"); 
+                $GLOBALS['phpgw_setup']->db->query("ALTER TABLE phpgw_cal ADD COLUMN organizer character varying(255);");
+            return $GLOBALS['setup_info']['calendar']['currentver'];
+        }
+        
+                $test[] = '2.0.008';
+        function calendar_upgrade2_0_008() {
+                $GLOBALS['setup_info']['calendar']['currentver'] = '2.0.009';
+                $GLOBALS['phpgw_setup']->db->query("ALTER TABLE phpgw_cal ADD COLUMN observations text;");
+                $GLOBALS['phpgw_setup']->db->query("ALTER TABLE phpgw_cal ADD COLUMN attachment text;");
+                $GLOBALS['phpgw_setup']->db->query("ALTER TABLE phpgw_cal ADD COLUMN alter_by character varying(160);");
             return $GLOBALS['setup_info']['calendar']['currentver'];
         }