Changeset 5715 for trunk/expressoCalendar
- Timestamp:
- 03/13/12 18:23:02 (12 years ago)
- Location:
- trunk/expressoCalendar/setup
- Files:
-
- 4 edited
-
default_records.inc.php (modified) (1 diff)
-
setup.inc.php (modified) (1 diff)
-
tables_current.inc.php (modified) (2 diffs)
-
tables_update.inc.php (modified) (1 diff)
Legend:
- Unmodified
- Added
- Removed
-
trunk/expressoCalendar/setup/default_records.inc.php
r5514 r5715 24 24 //calendar_repeat 25 25 $oProc->query("ALTER TABLE calendar_repeat ADD CONSTRAINT fk_calendar_repeat_calendar_object FOREIGN KEY (object_id) REFERENCES calendar_object (id) MATCH SIMPLE ON UPDATE CASCADE ON DELETE CASCADE;"); 26 26 27 //calendar_repeat_occurrence 28 $oProc->query("ALTER TABLE calendar_repeat_occurrence ADD CONSTRAINT fk_calendar_repeat_to_calendar_repeat_occurrence FOREIGN KEY (repeat_id) REFERENCES calendar_repeat (id) MATCH SIMPLE ON UPDATE CASCADE ON DELETE CASCADE;"); 29 27 30 //calendar_signature 28 31 $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;"); -
trunk/expressoCalendar/setup/setup.inc.php
r5617 r5715 13 13 $setup_info['expressoCalendar']['title'] = 'Expresso Calendar'; 14 14 /* Ao incrementar versão, não esquecer de declarar função do tables_update.inc.php*/ 15 $setup_info['expressoCalendar']['version'] = '1.00 1';15 $setup_info['expressoCalendar']['version'] = '1.002'; 16 16 $setup_info['expressoCalendar']['app_order'] = 10; 17 17 18 $setup_info['expressoCalendar']['tables'][] = 'attachment'; 19 $setup_info['expressoCalendar']['tables'][] = 'calendar_attach'; 20 $setup_info['expressoCalendar']['tables'][] = 'calendar_class'; 21 $setup_info['expressoCalendar']['tables'][] = 'calendar'; 22 $setup_info['expressoCalendar']['tables'][] = 'calendar_alarm'; 23 $setup_info['expressoCalendar']['tables'][] = 'calendar_ex_participant'; 24 $setup_info['expressoCalendar']['tables'][] = 'calendar_object'; 25 $setup_info['expressoCalendar']['tables'][] = 'calendar_object_type'; 26 $setup_info['expressoCalendar']['tables'][] = 'calendar_participant'; 27 $setup_info['expressoCalendar']['tables'][] = 'calendar_participant_status'; 28 $setup_info['expressoCalendar']['tables'][] = 'calendar_permission'; 29 $setup_info['expressoCalendar']['tables'][] = 'calendar_repeat'; 30 $setup_info['expressoCalendar']['tables'][] = 'calendar_signature'; 31 $setup_info['expressoCalendar']['tables'][] = 'calendar_signature_alarm'; 32 $setup_info['expressoCalendar']['tables'][] = 'module_preference'; 33 $setup_info['expressoCalendar']['tables'][] = 'calendar_to_calendar_object'; 34 18 $setup_info['expressoCalendar']['tables'][] = 'attachment'; 19 $setup_info['expressoCalendar']['tables'][] = 'calendar_attach'; 20 $setup_info['expressoCalendar']['tables'][] = 'calendar_class'; 21 $setup_info['expressoCalendar']['tables'][] = 'calendar'; 22 $setup_info['expressoCalendar']['tables'][] = 'calendar_alarm'; 23 $setup_info['expressoCalendar']['tables'][] = 'calendar_ex_participant'; 24 $setup_info['expressoCalendar']['tables'][] = 'calendar_object'; 25 $setup_info['expressoCalendar']['tables'][] = 'calendar_object_type'; 26 $setup_info['expressoCalendar']['tables'][] = 'calendar_participant'; 27 $setup_info['expressoCalendar']['tables'][] = 'calendar_participant_status'; 28 $setup_info['expressoCalendar']['tables'][] = 'calendar_permission'; 29 $setup_info['expressoCalendar']['tables'][] = 'calendar_repeat'; 30 $setup_info['expressoCalendar']['tables'][] = 'calendar_signature'; 31 $setup_info['expressoCalendar']['tables'][] = 'calendar_signature_alarm'; 32 $setup_info['expressoCalendar']['tables'][] = 'module_preference'; 33 $setup_info['expressoCalendar']['tables'][] = 'calendar_to_calendar_object'; 34 $setup_info['expressoCalendar']['tables'][] = 'calendar_repeat_ranges'; 35 $setup_info['expressoCalendar']['tables'][] = 'calendar_repeat_occurrence'; 36 35 37 $setup_info['expressoCalendar']['enable'] = 1; 36 38 -
trunk/expressoCalendar/setup/tables_current.inc.php
r5592 r5715 215 215 'id' => array( 'type' => 'auto', 'nullable' => False), 216 216 'frequency' => array( 'type' => 'varchar','precision' => '20', 'nullable' => False), 217 'until' => array( 'type' => 'int', 'precision' => '8', 'nullable' => False), 217 'until' => array( 'type' => 'int', 'precision' => '8', 'nullable' => True), 218 'dtstart' => array( 'type' => 'bigint','precision' => '16', 'nullable' => True), 218 219 'count' => array( 'type' => 'int', 'precision' => '8', 'nullable' => True), 219 220 'object_id' => array( 'type' => 'int', 'precision' => '8', 'nullable' => False), … … 236 237 ), 237 238 239 'calendar_repeat_ranges' => array( 240 'fd' => array( 241 'id' => array( 'type' => 'auto', 'nullable' => False), 242 'range_start' => array( 'type' => 'bigint','precision' => '16', 'nullable' => False), 243 'range_end' => array( 'type' => 'bigint', 'precision' => '16', 'nullable' => False), 244 'user_info_id' => array( 'type' => 'bigint', 'precision' => '16', 'nullable' => False) 245 ), 246 'pk' => array('id'), 247 'fk' => array(), 248 'ix' => array(), 249 'uc' => array() 250 ), 251 252 'calendar_repeat_occurrence' => array( 253 'fd' => array( 254 'id' => array( 'type' => 'auto', 'nullable' => False), 255 'occurrence' => array( 'type' => 'bigint','precision' => '16', 'nullable' => False), 256 'repeat_id' => array( 'type' => 'int', 'precision' => '8', 'nullable' => False) 257 ), 258 259 'pk' => array('id'), 260 'fk' => array('repeat_id'), 261 'ix' => array(), 262 'uc' => array() 263 ), 264 238 265 'calendar_signature' => array( 239 266 'fd' => array( -
trunk/expressoCalendar/setup/tables_update.inc.php
r5651 r5715 33 33 return $GLOBALS['setup_info']['expressoCalendar']['currentver']; 34 34 } 35 36 $test[] = '1.001'; 37 function expressoCalendar_upgrade1_001() { 38 39 $oProc = $GLOBALS['phpgw_setup']->oProc; 40 41 $oProc->query("ALTER TABLE calendar_repeat ADD COLUMN dtstart bigint"); 42 $oProc->query('ALTER TABLE calendar_repeat ALTER COLUMN until DROP NOT NULL'); 43 44 $oProc->CreateTable('calendar_repeat_occurrence', array( 45 'fd' => array( 46 'id' => array( 'type' => 'auto', 'nullable' => False), 47 'occurrence' => array( 'type' => 'bigint','precision' => '16', 'nullable' => False), 48 'repeat_id' => array( 'type' => 'int', 'precision' => '8', 'nullable' => False) 49 ), 50 51 'pk' => array('id'), 52 'fk' => array('repeat_id'), 53 'ix' => array(), 54 'uc' => array() 55 ) 56 ); 57 58 $oProc->CreateTable('calendar_repeat_ranges', array( 59 'fd' => array( 60 'id' => array( 'type' => 'auto', 'nullable' => False), 61 'range_start' => array( 'type' => 'bigint','precision' => '16', 'nullable' => False), 62 'range_end' => array( 'type' => 'bigint', 'precision' => '16', 'nullable' => False), 63 'user_info_id' => array( 'type' => 'bigint', 'precision' => '16', 'nullable' => False) 64 ), 65 'pk' => array('id'), 66 'fk' => array(), 67 'ix' => array(), 68 'uc' => array() 69 ) 70 ); 71 72 $oProc->query("ALTER TABLE calendar_repeat_occurrence ADD CONSTRAINT fk_calendar_repeat_to_calendar_repeat_occurrence FOREIGN KEY (repeat_id) REFERENCES calendar_repeat (id) MATCH SIMPLE ON UPDATE CASCADE ON DELETE CASCADE;"); 73 74 $GLOBALS['setup_info']['expressoCalendar']['currentver'] = '1.002'; 75 return $GLOBALS['setup_info']['expressoCalendar']['currentver']; 76 } 35 77 ?>
Note: See TracChangeset
for help on using the changeset viewer.
