Changeset 6968 for sandbox/2.4.2-expresso1/expressoCalendar/setup/tables_update.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_update.inc.php (modified) (1 diff)

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'];