Changeset 7594 for branches/2.4/expressoCalendar/setup/tables_update.inc.php

Timestamp:

12/03/12 17:01:59 (11 years ago)

Author:

douglas

Message:

Ticket #3143 - problema ao copiar evento ou tarefa no modulo expressocalendar

File:

• branches/2.4/expressoCalendar/setup/tables_update.inc.php (modified) (1 diff)

branches/2.4/expressoCalendar/setup/tables_update.inc.php

@@ -190 +190 @@
         $GLOBALS['setup_info']['expressoCalendar']['currentver'] = '1.010'; 
         return $GLOBALS['setup_info']['expressoCalendar']['currentver']; 
-    };    
+    };
+
+    $test[] = '1.010';
+    function expressoCalendar_upgrade1_010() {
+        $oProc = $GLOBALS['phpgw_setup']->oProc;
+            $oProc->CreateTable('calendar_timezones', array(
+                'fd' => array(
+                    'id' => array( 'type' => 'auto', 'nullable' => False),
+                    'timezone' => array(  'type' => 'varchar','precision' => '150', 'nullable' => False),
+
+                    'standard_frequency' => array(  'type' => 'varchar','precision' => '20', 'nullable' => False),
+                    'standard_dtstart' => array(  'type' => 'varchar','precision' => '20', 'nullable' => True),
+                    'standard_byday' => array(  'type' => 'varchar','precision' => '50', 'nullable' => True),
+                    'standard_bymonth' => array(  'type' => 'varchar','precision' => '50', 'nullable' => True),
+                    'standard_from' => array(  'type' => 'varchar','precision' => '10', 'nullable' => True),
+                    'standard_to' => array(  'type' => 'varchar','precision' => '10', 'nullable' => True),
+
+                    'daylight_frequency' => array(  'type' => 'varchar','precision' => '20', 'nullable' => False),
+                    'daylight_dtstart' => array(  'type' => 'varchar','precision' => '20', 'nullable' => True),
+                    'daylight_byday' => array(  'type' => 'varchar','precision' => '50', 'nullable' => True),
+                    'daylight_bymonth' => array(  'type' => 'varchar','precision' => '50', 'nullable' => True),
+                    'daylight_from' => array(  'type' => 'varchar','precision' => '10', 'nullable' => True),
+                    'daylight_to' => array(  'type' => 'varchar','precision' => '10', 'nullable' => True),
+
+                    'dtstamp' => array( 'type' => 'bigint', 'precision' => '16', 'precision' => '16', 'nullable' => False)
+                ),
+                'pk' => array('id'),
+                'fk' => array(),
+                'ix' => array(),
+                'uc' => array()
+            )
+        );
+
+        $oProc->query("INSERT INTO calendar_timezones(timezone, standard_frequency, standard_dtstart, standard_byday,
+        standard_bymonth, standard_from, standard_to, daylight_frequency, daylight_dtstart, daylight_byday,
+        daylight_bymonth, daylight_from, daylight_to, dtstamp) VALUES ('America/Sao_Paulo', 'YEARLY', '23:59',
+        '4SA', '2', '-0200','-0300', 'YEARLY', '23:59', '3SA', '10', '-0300','-0200', '". time() ."');");
+
+        $GLOBALS['setup_info']['expressoCalendar']['currentver'] = '1.011';
+        return $GLOBALS['setup_info']['expressoCalendar']['currentver'];
+    }; 
 
 ?>