Changeset 7579 for trunk/expressoCalendar

Timestamp:

11/29/12 17:12:33 (11 years ago)

Author:

acoutinho

Message:

Ticket #3233 - Problemas na configuracao da hora de um evento.

Location:

trunk/expressoCalendar/setup

Files:

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

trunk/expressoCalendar/setup/setup.inc.php

@@ -13 +13 @@
         $setup_info['expressoCalendar']['title']        = 'Expresso Calendar';
         /* Ao incrementar versão, não esquecer de declarar função do tables_update.inc.php*/
-        $setup_info['expressoCalendar']['version']      = '1.009';
+        $setup_info['expressoCalendar']['version']      = '1.011';
         $setup_info['expressoCalendar']['app_order']    = 10;
 

trunk/expressoCalendar/setup/tables_current.inc.php

@@ -248 +248 @@
                 'frequency' => array(  'type' => 'varchar','precision' => '20', 'nullable' => False),
                 'until' => array(  'type' => 'int', 'precision' => '8', 'nullable' => True),
-                'dtstart' => array(  'type' => 'bigint','precision' => '16', 'nullable' => True),
+                        'dtstart' => array(  'type' => 'bigint','precision' => '16', 'nullable' => True),
                 'count' => array(  'type' => 'int', 'precision' => '8', 'nullable' => True),
                 'object_id' => array(  'type' => 'int', 'precision' => '8', 'nullable' => False),
@@ -261 +261 @@
                 'bysetpos' => array(  'type' => 'varchar','precision' => '50', 'nullable' => True),
                 'wkst' => array(  'type' => 'varchar','precision' => '50', 'nullable' => True),
-                'exceptions' => array(  'type' => 'varchar','precision' => '50', 'nullable' => True),
+                        'exceptions' => array(  'type' => 'varchar','precision' => '50', 'nullable' => True),
                 'interval' => array(  'type' => 'int', 'precision' => '8', 'nullable' => True)
             ),
@@ -334 +334 @@
             'uc' => array()
                 ),
+
+
+        '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()
+        ),
                 
         );

trunk/expressoCalendar/setup/tables_update.inc.php

@@ -191 +191 @@
         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'];
+    };
         
 ?>