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

Timestamp:

03/16/12 15:02:14 (12 years ago)

Author:

natan

Message:

Ticket #2434 - Desenvolvimento do backend de suporte a excessoes nas repeticoes

File:

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

trunk/expressoCalendar/setup/tables_update.inc.php

@@ -70 +70 @@
                 );
 
-                $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;");      
+                $oProc->query("ALTER TABLE calendar_participant ADD COLUMN receive_notification smallint not null DEFAULT 1 "); 
 
                 $GLOBALS['setup_info']['expressoCalendar']['currentver'] = '1.002';
         return $GLOBALS['setup_info']['expressoCalendar']['currentver'];
         }
+
+        $test[] = '1.002';
+        function expressoCalendar_upgrade1_002() {
+
+                $oProc = $GLOBALS['phpgw_setup']->oProc;
+
+                $oProc->query("ALTER TABLE calendar_repeat_occurrence ADD COLUMN exception smallint DEFAULT 0;");
+
+                $GLOBALS['setup_info']['expressoCalendar']['currentver'] = '1.003';
+        return $GLOBALS['setup_info']['expressoCalendar']['currentver'];
+        }
 ?>