Changeset 6945 for sandbox/2.4.2-expresso1/expressoCalendar/setup

Timestamp:

08/06/12 10:03:03 (12 years ago)

Author:

acoutinho

Message:

Ticket #2966 - Criacao de atividades com suporte a alarmes e anexos

Location:

sandbox/2.4.2-expresso1/expressoCalendar/setup

Files:

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

sandbox/2.4.2-expresso1/expressoCalendar/setup/setup.inc.php

@@ -33 +33 @@
         $setup_info['expressoCalendar']['tables'][]             =  'calendar_permission';
         $setup_info['expressoCalendar']['tables'][]             =  'module_preference';
-        $setup_info['expressoCalendar']['tables'][]             =  'calendar_repeat_ranges';
+    $setup_info['expressoCalendar']['tables'][]     =  'calendar_repeat_ranges';
+        $setup_info['expressoCalendar']['tables'][]             =  'calendar_task_to_activity_object';
 
         $setup_info['expressoCalendar']['enable']               = 1;

sandbox/2.4.2-expresso1/expressoCalendar/setup/tables_current.inc.php

@@ -101 +101 @@
             'uc' => array()
                 ),
+
+       'calendar_task_to_activity_object' => array(
+            'fd' => array(
+                'id' => array( 'type' => 'auto', 'nullable' => False),
+                'calendar_object_activity_id' => array(  'type' => 'int', 'precision' => '8', 'nullable' => False),
+                'calendar_object_task_id' => array(  'type' => 'int', 'precision' => '8', 'nullable' => False),
+                'owner' => array(  'type' => 'int', 'precision' => '8', 'nullable' => False),
+            ),
+            'pk' => array('id'),
+            'fk' => array(),
+            'ix' => array(),
+            'uc' => array()
+        ),
             
             

sandbox/2.4.2-expresso1/expressoCalendar/setup/tables_update.inc.php

@@ -135 +135 @@
         $oProc->query("INSERT INTO calendar_object_type(id, name) VALUES ('2', 'TODO');");
 
+        $oProc->query("CREATE TABLE calendar_task_to_activity_object(id serial not null, calendar_object_activity_id integer not null, calendar_object_task_id integer not null, owner integer not null);");
+
         $GLOBALS['setup_info']['expressoCalendar']['currentver'] = '1.008';
         return $GLOBALS['setup_info']['expressoCalendar']['currentver'];