Changeset 7594 for branches/2.4/expressoCalendar
- Timestamp:
- 12/03/12 17:01:59 (11 years ago)
- Location:
- branches/2.4/expressoCalendar/setup
- Files:
-
- 3 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/2.4/expressoCalendar/setup/setup.inc.php
r7228 r7594 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.0 09';15 $setup_info['expressoCalendar']['version'] = '1.011'; 16 16 $setup_info['expressoCalendar']['app_order'] = 10; 17 17 -
branches/2.4/expressoCalendar/setup/tables_current.inc.php
r7383 r7594 321 321 322 322 323 'module_preference' => array(323 'module_preference' => array( 324 324 'fd' => array( 325 325 'id' => array( 'type' => 'auto', 'nullable' => False), … … 334 334 'uc' => array() 335 335 ), 336 336 337 'calendar_timezones' => array( 338 'fd' => array( 339 'id' => array( 'type' => 'auto', 'nullable' => False), 340 'timezone' => array( 'type' => 'varchar','precision' => '150', 'nullable' => False), 341 342 'standard_frequency' => array( 'type' => 'varchar','precision' => '20', 'nullable' => False), 343 'standard_dtstart' => array( 'type' => 'varchar','precision' => '20', 'nullable' => True), 344 'standard_byday' => array( 'type' => 'varchar','precision' => '50', 'nullable' => True), 345 'standard_bymonth' => array( 'type' => 'varchar','precision' => '50', 'nullable' => True), 346 'standard_from' => array( 'type' => 'varchar','precision' => '10', 'nullable' => True), 347 'standard_to' => array( 'type' => 'varchar','precision' => '10', 'nullable' => True), 348 349 'daylight_frequency' => array( 'type' => 'varchar','precision' => '20', 'nullable' => False), 350 'daylight_dtstart' => array( 'type' => 'varchar','precision' => '20', 'nullable' => True), 351 'daylight_byday' => array( 'type' => 'varchar','precision' => '50', 'nullable' => True), 352 'daylight_bymonth' => array( 'type' => 'varchar','precision' => '50', 'nullable' => True), 353 'daylight_from' => array( 'type' => 'varchar','precision' => '10', 'nullable' => True), 354 'daylight_to' => array( 'type' => 'varchar','precision' => '10', 'nullable' => True), 355 356 'dtstamp' => array( 'type' => 'bigint', 'precision' => '16', 'precision' => '16', 'nullable' => False) 357 ), 358 'pk' => array('id'), 359 'fk' => array(), 360 'ix' => array(), 361 'uc' => array() 362 ), 363 337 364 ); 338 365 ?> -
branches/2.4/expressoCalendar/setup/tables_update.inc.php
r7383 r7594 190 190 $GLOBALS['setup_info']['expressoCalendar']['currentver'] = '1.010'; 191 191 return $GLOBALS['setup_info']['expressoCalendar']['currentver']; 192 }; 192 }; 193 194 $test[] = '1.010'; 195 function expressoCalendar_upgrade1_010() { 196 $oProc = $GLOBALS['phpgw_setup']->oProc; 197 $oProc->CreateTable('calendar_timezones', array( 198 'fd' => array( 199 'id' => array( 'type' => 'auto', 'nullable' => False), 200 'timezone' => array( 'type' => 'varchar','precision' => '150', 'nullable' => False), 201 202 'standard_frequency' => array( 'type' => 'varchar','precision' => '20', 'nullable' => False), 203 'standard_dtstart' => array( 'type' => 'varchar','precision' => '20', 'nullable' => True), 204 'standard_byday' => array( 'type' => 'varchar','precision' => '50', 'nullable' => True), 205 'standard_bymonth' => array( 'type' => 'varchar','precision' => '50', 'nullable' => True), 206 'standard_from' => array( 'type' => 'varchar','precision' => '10', 'nullable' => True), 207 'standard_to' => array( 'type' => 'varchar','precision' => '10', 'nullable' => True), 208 209 'daylight_frequency' => array( 'type' => 'varchar','precision' => '20', 'nullable' => False), 210 'daylight_dtstart' => array( 'type' => 'varchar','precision' => '20', 'nullable' => True), 211 'daylight_byday' => array( 'type' => 'varchar','precision' => '50', 'nullable' => True), 212 'daylight_bymonth' => array( 'type' => 'varchar','precision' => '50', 'nullable' => True), 213 'daylight_from' => array( 'type' => 'varchar','precision' => '10', 'nullable' => True), 214 'daylight_to' => array( 'type' => 'varchar','precision' => '10', 'nullable' => True), 215 216 'dtstamp' => array( 'type' => 'bigint', 'precision' => '16', 'precision' => '16', 'nullable' => False) 217 ), 218 'pk' => array('id'), 219 'fk' => array(), 220 'ix' => array(), 221 'uc' => array() 222 ) 223 ); 224 225 $oProc->query("INSERT INTO calendar_timezones(timezone, standard_frequency, standard_dtstart, standard_byday, 226 standard_bymonth, standard_from, standard_to, daylight_frequency, daylight_dtstart, daylight_byday, 227 daylight_bymonth, daylight_from, daylight_to, dtstamp) VALUES ('America/Sao_Paulo', 'YEARLY', '23:59', 228 '4SA', '2', '-0200','-0300', 'YEARLY', '23:59', '3SA', '10', '-0300','-0200', '". time() ."');"); 229 230 $GLOBALS['setup_info']['expressoCalendar']['currentver'] = '1.011'; 231 return $GLOBALS['setup_info']['expressoCalendar']['currentver']; 232 }; 193 233 194 234 ?>
Note: See TracChangeset
for help on using the changeset viewer.