Changeset 5715 for trunk/expressoCalendar/setup/tables_update.inc.php

Timestamp:

03/13/12 18:23:02 (12 years ago)

Author:

natan

Message:

Ticket #2434 - Implementacao da repeticao de eventos na agenda e adicao de suporte a relacionamentos 1x1 na API

File:

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

trunk/expressoCalendar/setup/tables_update.inc.php

@@ -33 +33 @@
         return $GLOBALS['setup_info']['expressoCalendar']['currentver'];
         }
+
+        $test[] = '1.001';
+        function expressoCalendar_upgrade1_001() {
+
+                $oProc = $GLOBALS['phpgw_setup']->oProc;
+
+                $oProc->query("ALTER TABLE calendar_repeat ADD COLUMN dtstart bigint");
+                $oProc->query('ALTER TABLE calendar_repeat ALTER COLUMN until DROP NOT NULL');
+
+                $oProc->CreateTable('calendar_repeat_occurrence', array(
+                                'fd' => array(
+                                    'id' => array( 'type' => 'auto', 'nullable' => False),
+                                    'occurrence' => array(  'type' => 'bigint','precision' => '16', 'nullable' => False),
+                                    'repeat_id' => array(  'type' => 'int', 'precision' => '8', 'nullable' => False)
+                                ),
+
+                                'pk' => array('id'),
+                                'fk' => array('repeat_id'),
+                                'ix' => array(),
+                                'uc' => array()
+                                )
+                );
+
+                $oProc->CreateTable('calendar_repeat_ranges', array(
+                                'fd' => array(
+                                    'id' => array( 'type' => 'auto', 'nullable' => False),
+                                    'range_start' => array(  'type' => 'bigint','precision' => '16', 'nullable' => False),
+                                    'range_end' => array(  'type' => 'bigint', 'precision' => '16', 'nullable' => False),
+                                    'user_info_id' => array(  'type' => 'bigint', 'precision' => '16', 'nullable' => False)
+                                ),
+                                'pk' => array('id'),
+                                'fk' => array(),
+                                'ix' => array(),
+                                'uc' => array()
+                                    )
+                );
+
+                $oProc->query("ALTER TABLE calendar_repeat_occurrence ADD CONSTRAINT fk_calendar_repeat_to_calendar_repeat_occurrence FOREIGN KEY (repeat_id) REFERENCES calendar_repeat (id) MATCH SIMPLE ON UPDATE CASCADE ON DELETE CASCADE;");      
+
+                $GLOBALS['setup_info']['expressoCalendar']['currentver'] = '1.002';
+        return $GLOBALS['setup_info']['expressoCalendar']['currentver'];
+        }
 ?>