Changeset 6968 for sandbox/2.4.2-expresso1/expressoCalendar/setup/tables_current.inc.php

Timestamp:

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

Author:

acoutinho

Message:

Ticket #2966 - Criado suporte a historico em atividades

File:

• sandbox/2.4.2-expresso1/expressoCalendar/setup/tables_current.inc.php (modified) (2 diffs)

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),