- Timestamp:
- 09/17/12 14:30:47 (12 years ago)
- Location:
- branches/2.4
- Files:
-
- 2 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/2.4
- Property svn:mergeinfo changed
-
branches/2.4/expressoCalendar/setup/tables_update.inc.php
r6255 r7228 57 57 58 58 $oProc->CreateTable('calendar_repeat_ranges', array( 59 60 61 62 63 64 65 66 67 68 69 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 70 ); 71 71 … … 79 79 function expressoCalendar_upgrade1_002() { 80 80 81 81 $oProc = $GLOBALS['phpgw_setup']->oProc; 82 82 83 83 $oProc->query("ALTER TABLE calendar_repeat_occurrence ADD COLUMN exception smallint DEFAULT 0"); 84 84 85 86 85 $GLOBALS['setup_info']['expressoCalendar']['currentver'] = '1.003'; 86 return $GLOBALS['setup_info']['expressoCalendar']['currentver']; 87 87 }; 88 88 89 89 $test[] = '1.003'; 90 90 function expressoCalendar_upgrade1_003() { 91 92 91 $GLOBALS['setup_info']['expressoCalendar']['currentver'] = '1.004'; 92 return $GLOBALS['setup_info']['expressoCalendar']['currentver']; 93 93 }; 94 94 95 95 $test[] = '1.004'; 96 96 function expressoCalendar_upgrade1_004() { 97 98 97 $oProc = $GLOBALS['phpgw_setup']->oProc; 98 $oProc->query("ALTER TABLE calendar_repeat_occurrence ALTER COLUMN exception SET default 0"); 99 99 100 101 100 $GLOBALS['setup_info']['expressoCalendar']['currentver'] = '1.005'; 101 return $GLOBALS['setup_info']['expressoCalendar']['currentver']; 102 102 }; 103 103 104 104 $test[] = '1.005'; 105 105 function expressoCalendar_upgrade1_005() { 106 107 106 $oProc = $GLOBALS['phpgw_setup']->oProc; 107 $oProc->query("ALTER TABLE calendar_alarm ADD COLUMN alarm_offset bigint;"); 108 108 $oProc->query("UPDATE calendar_alarm SET alarm_offset = obj.range_start - calendar_alarm.range_start FROM calendar_object as obj WHERE obj.id = object_id;"); 109 109 $oProc->query("ALTER TABLE calendar_alarm DROP COLUMN range_start;"); 110 110 $oProc->query("ALTER TABLE calendar_alarm DROP COLUMN range_end;"); 111 112 111 $GLOBALS['setup_info']['expressoCalendar']['currentver'] = '1.006'; 112 return $GLOBALS['setup_info']['expressoCalendar']['currentver']; 113 113 }; 114 114 … … 120 120 }; 121 121 122 $test[] = '1.007'; 123 function expressoCalendar_upgrade1_007() { 124 $oProc = $GLOBALS['phpgw_setup']->oProc; 125 126 $oProc->query("ALTER TABLE calendar_object ADD COLUMN priority smallint DEFAULT 0;"); 127 $oProc->query("ALTER TABLE calendar_object ADD COLUMN percentage smallint DEFAULT 0;"); 128 $oProc->query("ALTER TABLE calendar_object ADD COLUMN status smallint DEFAULT 0;"); 129 130 $oProc->query("ALTER TABLE calendar_object ADD COLUMN due bigint DEFAULT 0;"); 131 132 $oProc->query("ALTER TABLE calendar ADD COLUMN type smallint DEFAULT 0;"); 133 $oProc->query("ALTER TABLE calendar_signature ADD COLUMN type smallint DEFAULT 0;"); 134 135 $oProc->query("INSERT INTO calendar_object_type(id, name) VALUES ('2', 'TODO');"); 136 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);"); 138 139 $oProc->CreateTable('calendar_historic', array( 140 'fd' => array( 141 'id' => array( 'type' => 'auto', 'nullable' => False), 142 'object_id' => array('type' => 'int', 'precision' => '8','nullable' => True), 143 'user_uidnumber' => array( 'type' => 'int', 'precision' => '8', 'nullable' => False), 144 'dtstamp' => array( 'type' => 'bigint', 'precision' => '16', 'nullable' => False), 145 'attribute' => array('type' => 'varchar','precision' => '50','nullable' => True), 146 'before_value' => array( 'type' => 'varchar', 'precision' => '255', 'nullable' => True), 147 'after_value' => array( 'type' => 'varchar', 'precision' => '255', 'nullable' => True) 148 ), 149 'pk' => array('id'), 150 'fk' => array(), 151 'ix' => array(), 152 'uc' => array() 153 ) 154 ); 155 156 $oProc->CreateTable('calendar_task_to_activity_object', array( 157 'fd' => array( 158 'id' => array( 'type' => 'auto', 'nullable' => False), 159 'calendar_object_activity_id' => array( 'type' => 'int', 'precision' => '8', 'nullable' => False), 160 'calendar_object_task_id' => array( 'type' => 'int', 'precision' => '8', 'nullable' => False), 161 'owner' => array( 'type' => 'int', 'precision' => '8', 'nullable' => False), 162 ), 163 'pk' => array('id'), 164 'fk' => array(), 165 'ix' => array(), 166 'uc' => array() 167 ) 168 ); 169 170 $GLOBALS['setup_info']['expressoCalendar']['currentver'] = '1.008'; 171 return $GLOBALS['setup_info']['expressoCalendar']['currentver']; 172 }; 173 174 $test[] = '1.008'; 175 function expressoCalendar_upgrade1_008() { 176 $oProc = $GLOBALS['phpgw_setup']->oProc; 177 178 $oProc->query("ALTER TABLE calendar_permission ADD COLUMN owner bigint;"); 179 $oProc->query("UPDATE calendar_permission SET owner = sig.user_uidnumber FROM calendar_signature as sig WHERE (sig.calendar_id = object_id AND sig.is_owner = '1');"); 180 181 $GLOBALS['setup_info']['expressoCalendar']['currentver'] = '1.009'; 182 return $GLOBALS['setup_info']['expressoCalendar']['currentver']; 183 }; 184 122 185 ?>
Note: See TracChangeset
for help on using the changeset viewer.