Changeset 7579 for trunk/expressoCalendar/setup/tables_current.inc.php

Timestamp:

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

Author:

acoutinho

Message:

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

File:

• trunk/expressoCalendar/setup/tables_current.inc.php (modified) (3 diffs)

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()
+        ),
                 
         );