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

Timestamp:

09/04/12 17:09:47 (12 years ago)

Author:

acoutinho

Message:

Ticket #3062 - Incluir o uid do dono de uma agenda ao pesquisa-la

File:

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

trunk/expressoCalendar/setup/tables_update.inc.php

@@ -171 +171 @@
             return $GLOBALS['setup_info']['expressoCalendar']['currentver'];
         };
+
+    $test[] = '1.008';
+    function expressoCalendar_upgrade1_008() {
+        $oProc = $GLOBALS['phpgw_setup']->oProc;
+
+        $oProc->query("ALTER TABLE calendar_permission ADD COLUMN owner bigint;");
+        $oProc->query("UPDATE calendar_permission SET owner = sig.user_uidnumber FROM calendar_signature as sig WHERE (sig.calendar_id = object_id AND sig.is_owner = '1');");
+
+        $GLOBALS['setup_info']['expressoCalendar']['currentver'] = '1.009';
+        return $GLOBALS['setup_info']['expressoCalendar']['currentver'];
+    };
         
 ?>