Changeset 5741 for trunk/expressoCalendar

Timestamp:

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

Author:

natan

Message:

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

Location:

trunk/expressoCalendar/setup

Files:

• setup.inc.php (modified) (1 diff)
• tables_current.inc.php (modified) (2 diffs)
• tables_update.inc.php (modified) (1 diff)

trunk/expressoCalendar/setup/setup.inc.php

@@ -13 +13 @@
         $setup_info['expressoCalendar']['title']        = 'Expresso Calendar';
         /* Ao incrementar versão, não esquecer de declarar função do tables_update.inc.php*/
-        $setup_info['expressoCalendar']['version']      = '1.002';
+        $setup_info['expressoCalendar']['version']      = '1.003';
         $setup_info['expressoCalendar']['app_order']    = 10;
         

trunk/expressoCalendar/setup/tables_current.inc.php

@@ -229 +229 @@
                 'bysetpos' => array(  'type' => 'varchar','precision' => '50', 'nullable' => True),
                 'wkst' => array(  'type' => 'varchar','precision' => '50', 'nullable' => True),
+                'exceptions' => array(  'type' => 'varchar','precision' => '50', 'nullable' => True),
                 'interval' => array(  'type' => 'int', 'precision' => '8', 'nullable' => True)
             ),
@@ -254 +255 @@
                 'id' => array( 'type' => 'auto', 'nullable' => False),
                 'occurrence' => array(  'type' => 'bigint','precision' => '16', 'nullable' => False),
-                'repeat_id' => array(  'type' => 'int', 'precision' => '8', 'nullable' => False)
+                'exception' => array(  'type' => 'smallint','precision' => '1', 'nullable' => False),
+                'repeat_id' => array(  'type' => 'int', 'precision' => '8', 'nullable' => False)
             ),
 

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'];
+        }
 ?>