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

Timestamp:

05/04/12 18:38:56 (12 years ago)

Author:

natan

Message:

Ticket #2141 - Eventos com repeticao nao dispara notificacao nos alarmes - implementação final

File:

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

trunk/expressoCalendar/setup/tables_update.inc.php

@@ -107 +107 @@
         };
         
-        
+        $test[] = '1.005';
+        function expressoCalendar_upgrade1_005() {
+            $oProc = $GLOBALS['phpgw_setup']->oProc;
+            $oProc->query("ALTER TABLE calendar_alarm ADD COLUMN alarm_offset bigint;");
+            $oProc->query("UPDATE calendar_alarm SET alarm_offset = obj.range_start - calendar_alarm.range_start FROM calendar_object as obj WHERE obj.id = object_id;");
+            $oProc->query("ALTER TABLE calendar_alarm DROP COLUMN range_start;");
+            $oProc->query("ALTER TABLE calendar_alarm DROP COLUMN range_end;");
+            $GLOBALS['setup_info']['expressoCalendar']['currentver'] = '1.006';
+            return $GLOBALS['setup_info']['expressoCalendar']['currentver'];
+        };
         
 ?>