Changeset 6968 for sandbox/2.4.2-expresso1/expressoCalendar

Timestamp:

08/08/12 18:02:13 (12 years ago)

Author:

acoutinho

Message:

Ticket #2966 - Criado suporte a historico em atividades

Location:

sandbox/2.4.2-expresso1/expressoCalendar/setup

Files:

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

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

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

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

@@ -148 +148 @@
                 
             
-            'calendar_participant' => array(
+        'calendar_participant' => array(
             'fd' => array(
                 'id' => array( 'type' => 'auto', 'nullable' => False),
@@ -183 +183 @@
             'uc' => array()
                 ),
-                
-                
-            'calendar_signature_alarm' => array(
+
+        'calendar_historic' => array(
+            'fd' => array(
+                'id' => array( 'type' => 'auto', 'nullable' => False),
+                'object_id' => array('type' => 'int', 'precision' => '8','nullable' => True),
+                'user_uidnumber' => array( 'type' => 'int', 'precision' => '8', 'nullable' => False),
+                'dtstamp' => array( 'type' => 'bigint', 'precision' => '16', 'nullable' => False),
+                'attribute' => array('type' => 'varchar','precision' => '50','nullable' => True),
+                'before_value' => array( 'type' => 'varchar', 'precision' => '255', 'nullable' => True),              
+                'after_value' => array( 'type' => 'varchar', 'precision' => '255', 'nullable' => True)            
+            ),
+            'pk' => array('id'),
+            'fk' => array(),
+            'ix' => array(),
+            'uc' => array()
+        ),      
+                
+        'calendar_signature_alarm' => array(
             'fd' => array(
                 'id' => array( 'type' => 'auto', 'nullable' => False),

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

@@ -137 +137 @@
         $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);");
 
+        $oProc->CreateTable('calendar_historic', array(
+            'fd' => array(
+                'id' => array( 'type' => 'auto', 'nullable' => False),
+                'object_id' => array('type' => 'int', 'precision' => '8','nullable' => True),
+                'user_uidnumber' => array( 'type' => 'int', 'precision' => '8', 'nullable' => False),
+                'dtstamp' => array( 'type' => 'bigint', 'precision' => '16', 'nullable' => False),
+                'attribute' => array('type' => 'varchar','precision' => '50','nullable' => True),
+                'before_value' => array( 'type' => 'varchar', 'precision' => '255', 'nullable' => True),              
+                'after_value' => array( 'type' => 'varchar', 'precision' => '255', 'nullable' => True)            
+            ),
+            'pk' => array('id'),
+            'fk' => array(),
+            'ix' => array(),
+            'uc' => array()
+            )
+        );
+
+        $oProc->CreateTable('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()
+            )
+        );
+
         $GLOBALS['setup_info']['expressoCalendar']['currentver'] = '1.008';
         return $GLOBALS['setup_info']['expressoCalendar']['currentver'];