Changeset 5514 for trunk/expressoCalendar

Timestamp:

02/14/12 16:52:04 (12 years ago)

Author:

acoutinho

Message:

Ticket #2434 - Implementacao anexos, acls e delegacao de participantes

Location:

trunk/expressoCalendar/setup

Files:

• default_records.inc.php (modified) (2 diffs)
• tables_current.inc.php (modified) (3 diffs)

trunk/expressoCalendar/setup/default_records.inc.php

@@ -28 +28 @@
                 $oProc->query("ALTER TABLE calendar_signature ADD CONSTRAINT fk_calendar_signature_calendar_espec FOREIGN KEY (calendar_id) REFERENCES calendar (id) MATCH SIMPLE ON UPDATE CASCADE ON DELETE CASCADE;");
                 
-                //calendar_signature_alarm
+        //calendar_signature_alarm
                 $oProc->query("ALTER TABLE calendar_signature_alarm ADD CONSTRAINT fk_calendar_signature_alarm_calendar_signature FOREIGN KEY (calendar_signature_id) REFERENCES calendar_signature (id) MATCH SIMPLE ON UPDATE CASCADE ON DELETE CASCADE;");
                 
@@ -37 +37 @@
                 $oProc->query("INSERT INTO calendar_object_type( \"id\", \"name\") VALUES ('1','VEVENT');");
                 $oProc->query("INSERT INTO calendar_class( \"id\", \"name\") VALUES ('1','Public'),('2','Private'),('3','Confidential');");
-                $oProc->query("INSERT INTO calendar_participant_status( \"id\", \"name\") VALUES ('1','CONFIRMED'),('2','TENTATIVE'),('3','CANCELLED'),('4','UNANSWERED');");
+                $oProc->query("INSERT INTO calendar_participant_status( \"id\", \"name\") VALUES ('1','CONFIRMED'),('2','TENTATIVE'),('3','CANCELLED'),('4','UNANSWERED'),('5', 'DELEGATED');");
                 
 ?>

trunk/expressoCalendar/setup/tables_current.inc.php

@@ -31 +31 @@
                                 'type' => array('type' => 'varchar','precision' => '50','nullable' => False),
                                 'name' => array('type' => 'varchar','precision' => '255','nullable' => False),
-                                'size' => array('type' => 'varchar','precision' => '255','nullable' => False)
+                                'size' => array('type' => 'varchar','precision' => '255','nullable' => False),
+                                'owner' => array('type' => 'int', 'precision' => '8','nullable' => True)
                         ),
                         'pk' => array('id'),
@@ -38 +39 @@
                         'uc' => array()
                 ),
-                
-        
-                
+                                
                 'calendar' => array(
             'fd' => array(
@@ -136 +135 @@
                 'user_info_id' => array(  'type' => 'int', 'precision' => '8', 'nullable' => False),
                 'object_id' => array(  'type' => 'int', 'precision' => '8', 'nullable' => True),
-                'delegated_to' => array( 'type' => 'int', 'precision' => '8','default' => 0, 'nullable' => False),
+                'delegated_from' => array( 'type' => 'int', 'precision' => '8','default' => 0, 'nullable' => False),
                 'is_organizer' => array( 'type' => 'int', 'precision' => '2', 'default' => 0, 'nullable' => False),
                 'is_external' => array( 'type' => 'int', 'precision' => '2', 'default' => 0, 'nullable' => False),
-                'participant_status_id' => array( 'type' => 'int', 'precision' => '8', 'nullable' => false , 'default' => 4)
+                'participant_status_id' => array( 'type' => 'int', 'precision' => '8', 'nullable' => false , 'default' => 4),
+                                'acl' => array('type' => 'varchar', 'precision' => '10' ,'default' => 'r', 'nullable' => False),
+                                'receive_notification' => array( 'type' => 'int', 'precision' => '2', 'default' => 1, 'nullable' => False)
             ),
             'pk' => array('id'),