1 | <?php |
---|
2 | /**************************************************************************\ |
---|
3 | * phpGroupWare - Setup * |
---|
4 | * http://www.phpgroupware.org * |
---|
5 | * -------------------------------------------- * |
---|
6 | * This program is free software; you can redistribute it and/or modify it * |
---|
7 | * under the terms of the GNU General Public License as published by the * |
---|
8 | * Free Software Foundation; either version 2 of the License, or (at your * |
---|
9 | * option) any later version. * |
---|
10 | \**************************************************************************/ |
---|
11 | |
---|
12 | |
---|
13 | $test[] = '0.9.1'; |
---|
14 | function phpgwapi_upgrade0_9_1() |
---|
15 | { |
---|
16 | global $phpgw_info, $setup_info, $phpgw_setup; |
---|
17 | |
---|
18 | $phpgw_setup->oProc->AlterColumn('access_log', 'lo', array('type' => 'varchar', 'precision' => 255)); |
---|
19 | |
---|
20 | $phpgw_setup->oProc->query("update lang set lang='da' where lang='dk'"); |
---|
21 | $phpgw_setup->oProc->query("update lang set lang='ko' where lang='kr'"); |
---|
22 | |
---|
23 | $phpgw_setup->oProc->AddColumn('addressbook', 'ab_company_id', array('type' => 'int', 'precision' => 4)); |
---|
24 | $phpgw_setup->oProc->AddColumn('addressbook', 'ab_title', array('type' => 'varchar', 'precision' => 60)); |
---|
25 | $phpgw_setup->oProc->AddColumn('addressbook', 'ab_address2', array('type' => 'varchar', 'precision' => 60)); |
---|
26 | |
---|
27 | $phpgw_setup->oProc->query("update preferences set preference_name='da' where preference_name='dk'"); |
---|
28 | $phpgw_setup->oProc->query("update preferences set preference_name='ko' where preference_name='kr'"); |
---|
29 | |
---|
30 | //install weather support |
---|
31 | $phpgw_setup->oProc->query("insert into applications (app_name, app_title, app_enabled, app_order, app_tables, app_version) values ('weather', 'Weather', 1, 12, NULL, '".$phpgw_info['server']['version']."')"); |
---|
32 | $phpgw_setup->oProc->query("INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'weather','Weather','en','weather')"); |
---|
33 | |
---|
34 | $setup_info['phpgwapi']['currentver'] = '0.9.2'; |
---|
35 | return $setup_info['phpgwapi']['currentver']; |
---|
36 | //return True; |
---|
37 | } |
---|
38 | |
---|
39 | function phpgwapi_v0_9_2to0_9_3update_owner($table, $field) |
---|
40 | { |
---|
41 | global $phpgw_setup; |
---|
42 | |
---|
43 | $phpgw_setup->oProc->query("select distinct($field) from $table"); |
---|
44 | if ($phpgw_setup->oProc->num_rows()) { |
---|
45 | while ($phpgw_setup->oProc->next_record()) |
---|
46 | { |
---|
47 | $owner[count($owner)] = $phpgw_setup->oProc->f($field); |
---|
48 | } |
---|
49 | for($i=0;$i<count($owner);$i++) |
---|
50 | { |
---|
51 | $phpgw_setup->oProc->query("select account_id from accounts where account_lid='".$owner[$i]."'"); |
---|
52 | $phpgw_setup->oProc->next_record(); |
---|
53 | $phpgw_setup->oProc->query("update $table set $field=".$phpgw_setup->oProc->f("account_id")." where $field='".$owner[$i]."'"); |
---|
54 | } |
---|
55 | } |
---|
56 | |
---|
57 | $phpgw_setup->oProc->AlterColumn($table, $field, array('type' => 'int', 'precision' => 4, 'nullable' => false, 'default' => 0)); |
---|
58 | } |
---|
59 | |
---|
60 | $test[] = '0.9.2'; |
---|
61 | function phpgwapi_upgrade0_9_2() |
---|
62 | { |
---|
63 | global $setup_info; |
---|
64 | |
---|
65 | $setup_info['phpgwapi']['currentver'] = '0.9.3pre1'; |
---|
66 | return $setup_info['phpgwapi']['currentver']; |
---|
67 | //return True; |
---|
68 | } |
---|
69 | $test[] = '0.9.3pre1'; |
---|
70 | function phpgwapi_upgrade0_9_3pre1() |
---|
71 | { |
---|
72 | global $setup_info; |
---|
73 | |
---|
74 | $setup_info['phpgwapi']['currentver'] = '0.9.3pre2'; |
---|
75 | return $setup_info['phpgwapi']['currentver']; |
---|
76 | //return True; |
---|
77 | } |
---|
78 | |
---|
79 | $test[] = '0.9.3pre2'; |
---|
80 | function phpgwapi_upgrade0_9_3pre2() |
---|
81 | { |
---|
82 | global $setup_info; |
---|
83 | |
---|
84 | $setup_info['phpgwapi']['currentver'] = '0.9.3pre3'; |
---|
85 | return $setup_info['phpgwapi']['currentver']; |
---|
86 | //return True; |
---|
87 | } |
---|
88 | |
---|
89 | $test[] = '0.9.3pre3'; |
---|
90 | function phpgwapi_upgrade0_9_3pre3() |
---|
91 | { |
---|
92 | global $setup_info; |
---|
93 | |
---|
94 | $setup_info['phpgwapi']['currentver'] = '0.9.3pre4'; |
---|
95 | return $setup_info['phpgwapi']['currentver']; |
---|
96 | //return True; |
---|
97 | } |
---|
98 | |
---|
99 | $test[] = '0.9.3pre4'; |
---|
100 | function phpgwapi_upgrade0_9_3pre4() |
---|
101 | { |
---|
102 | global $setup_info, $phpgw_setup; |
---|
103 | |
---|
104 | $phpgw_setup->oProc->AlterColumn("config", "config_name", array("type" => "varchar", "precision" => 255, "nullable" => false)); |
---|
105 | |
---|
106 | $setup_info['phpgwapi']['currentver'] = '0.9.3pre5'; |
---|
107 | return $setup_info['phpgwapi']['currentver']; |
---|
108 | //return True; |
---|
109 | } |
---|
110 | |
---|
111 | $test[] = '0.9.3pre5'; |
---|
112 | function phpgwapi_upgrade0_9_3pre5() |
---|
113 | { |
---|
114 | global $setup_info, $phpgw_setup; |
---|
115 | |
---|
116 | $phpgw_setup->oProc->CreateTable( |
---|
117 | 'categories', array( |
---|
118 | 'fd' => array( |
---|
119 | 'cat_id' => array('type' => 'auto', 'nullable' => false), |
---|
120 | 'account_id' => array('type' => 'int', 'precision' => 4, 'nullable' => false, 'default' => 0), |
---|
121 | 'app_name' => array('type' => 'varchar', 'precision' => 25, 'nullable' => false), |
---|
122 | 'cat_name' => array('type' => 'varchar', 'precision' => 150, 'nullable' => false), |
---|
123 | 'cat_description' => array('type' => 'text', 'nullable' => false) |
---|
124 | ), |
---|
125 | 'pk' => array('cat_id'), |
---|
126 | 'ix' => array(), |
---|
127 | 'fk' => array(), |
---|
128 | 'uc' => array() |
---|
129 | ) |
---|
130 | ); |
---|
131 | |
---|
132 | $setup_info['phpgwapi']['currentver'] = '0.9.3pre6'; |
---|
133 | return $setup_info['phpgwapi']['currentver']; |
---|
134 | //return True; |
---|
135 | } |
---|
136 | |
---|
137 | $test[] = '0.9.3pre6'; |
---|
138 | function phpgwapi_upgrade0_9_3pre6() |
---|
139 | { |
---|
140 | global $setup_info, $phpgw_setup; |
---|
141 | |
---|
142 | $phpgw_setup->oProc->query("insert into applications (app_name, app_title, app_enabled, app_order, app_tables, app_version) values ('transy', 'Translation Management', 0, 13, NULL, '".$setup_info['phpgwapi']['version']."')"); |
---|
143 | |
---|
144 | $phpgw_setup->oProc->AddColumn('addressbook', 'ab_url', array('type' => 'varchar', 'precision' => 255)); |
---|
145 | |
---|
146 | $setup_info['phpgwapi']['currentver'] = '0.9.3pre7'; |
---|
147 | return $setup_info['phpgwapi']['currentver']; |
---|
148 | //return True; |
---|
149 | } |
---|
150 | |
---|
151 | $test[] = '0.9.3pre7'; |
---|
152 | function phpgwapi_upgrade0_9_3pre7() |
---|
153 | { |
---|
154 | global $setup_info, $phpgw_setup; |
---|
155 | |
---|
156 | $phpgw_setup->oProc->CreateTable('languages', array( |
---|
157 | 'fd' => array( |
---|
158 | 'lang_id' => array('type' => 'varchar', 'precision' => 2, 'nullable' => false), |
---|
159 | 'lang_name' => array('type' => 'varchar', 'precision' => 50, 'nullable' => false), |
---|
160 | 'available' => array('type' => 'char', 'precision' => 3, 'nullable' => false, 'default' => 'No') |
---|
161 | ), |
---|
162 | 'pk' => array('lang_id'), |
---|
163 | 'ix' => array(), |
---|
164 | 'fk' => array(), |
---|
165 | 'uc' => array() |
---|
166 | ) |
---|
167 | ); |
---|
168 | |
---|
169 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('AA','Afar','No')"); |
---|
170 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('AB','Abkhazian','No')"); |
---|
171 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('AF','Afrikaans','No')"); |
---|
172 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('AM','Amharic','No')"); |
---|
173 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('AR','Arabic','No')"); |
---|
174 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('AS','Assamese','No')"); |
---|
175 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('AY','Aymara','No')"); |
---|
176 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('AZ','Azerbaijani','No')"); |
---|
177 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('BA','Bashkir','No')"); |
---|
178 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('BE','Byelorussian','No')"); |
---|
179 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('BG','Bulgarian','No')"); |
---|
180 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('BH','Bihari','No')"); |
---|
181 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('BI','Bislama','No')"); |
---|
182 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('BN','Bengali / Bangla','No')"); |
---|
183 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('BO','Tibetan','No')"); |
---|
184 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('BR','Breton','No')"); |
---|
185 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('CA','Catalan','No')"); |
---|
186 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('CO','Corsican','No')"); |
---|
187 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('CS','Czech','No')"); |
---|
188 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('CY','Welsh','No')"); |
---|
189 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('DA','Danish','Yes')"); |
---|
190 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('DE','German','Yes')"); |
---|
191 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('DZ','Bhutani','No')"); |
---|
192 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('EL','Greek','No')"); |
---|
193 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('EN','English / US','Yes')"); |
---|
194 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('EO','Esperanto','No')"); |
---|
195 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('ES','Spanish','Yes')"); |
---|
196 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('ET','Estonian','No')"); |
---|
197 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('EU','Basque','No')"); |
---|
198 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('FA','Persian','No')"); |
---|
199 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('FI','Finnish','No')"); |
---|
200 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('FJ','Fiji','No')"); |
---|
201 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('FO','Faeroese','No')"); |
---|
202 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('FR','French','Yes')"); |
---|
203 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('FY','Frisian','No')"); |
---|
204 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('GA','Irish','No')"); |
---|
205 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('GD','Gaelic / Scots Gaelic','No')"); |
---|
206 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('GL','Galician','No')"); |
---|
207 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('GN','Guarani','No')"); |
---|
208 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('GU','Gujarati','No')"); |
---|
209 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('HA','Hausa','No')"); |
---|
210 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('HI','Hindi','No')"); |
---|
211 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('HR','Croatian','No')"); |
---|
212 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('HU','Hungarian','No')"); |
---|
213 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('HY','Armenian','No')"); |
---|
214 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('IA','Interlingua','No')"); |
---|
215 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('IE','Interlingue','No')"); |
---|
216 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('IK','Inupiak','No')"); |
---|
217 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('IN','Indonesian','No')"); |
---|
218 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('IS','Icelandic','No')"); |
---|
219 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('IT','Italian','Yes')"); |
---|
220 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('IW','Hebrew','No')"); |
---|
221 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('JA','Japanese','No')"); |
---|
222 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('JI','Yiddish','No')"); |
---|
223 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('JW','Javanese','No')"); |
---|
224 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('KA','Georgian','No')"); |
---|
225 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('KK','Kazakh','No')"); |
---|
226 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('KL','Greenlandic','No')"); |
---|
227 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('KM','Cambodian','No')"); |
---|
228 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('KN','Kannada','No')"); |
---|
229 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('KO','Korean','Yes')"); |
---|
230 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('KS','Kashmiri','No')"); |
---|
231 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('KU','Kurdish','No')"); |
---|
232 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('KY','Kirghiz','No')"); |
---|
233 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('LA','Latin','No')"); |
---|
234 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('LN','Lingala','No')"); |
---|
235 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('LO','Laothian','No')"); |
---|
236 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('LT','Lithuanian','No')"); |
---|
237 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('LV','Latvian / Lettish','No')"); |
---|
238 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('MG','Malagasy','No')"); |
---|
239 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('MI','Maori','No')"); |
---|
240 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('MK','Macedonian','No')"); |
---|
241 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('ML','Malayalam','No')"); |
---|
242 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('MN','Mongolian','No')"); |
---|
243 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('MO','Moldavian','No')"); |
---|
244 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('MR','Marathi','No')"); |
---|
245 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('MS','Malay','No')"); |
---|
246 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('MT','Maltese','No')"); |
---|
247 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('MY','Burmese','No')"); |
---|
248 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('NA','Nauru','No')"); |
---|
249 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('NE','Nepali','No')"); |
---|
250 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('NL','Dutch','Yes')"); |
---|
251 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('NO','Norwegian','Yes')"); |
---|
252 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('OC','Occitan','No')"); |
---|
253 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('OM','Oromo / Afan','No')"); |
---|
254 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('OR','Oriya','No')"); |
---|
255 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('PA','Punjabi','No')"); |
---|
256 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('PL','Polish','No')"); |
---|
257 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('PS','Pashto / Pushto','No')"); |
---|
258 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('PT','Portuguese','Yes')"); |
---|
259 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('QU','Quechua','No')"); |
---|
260 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('RM','Rhaeto-Romance','No')"); |
---|
261 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('RN','Kirundi','No')"); |
---|
262 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('RO','Romanian','No')"); |
---|
263 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('RU','Russian','No')"); |
---|
264 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('RW','Kinyarwanda','No')"); |
---|
265 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('SA','Sanskrit','No')"); |
---|
266 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('SD','Sindhi','No')"); |
---|
267 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('SG','Sangro','No')"); |
---|
268 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('SH','Serbo-Croatian','No')"); |
---|
269 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('SI','Singhalese','No')"); |
---|
270 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('SK','Slovak','No')"); |
---|
271 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('SL','Slovenian','No')"); |
---|
272 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('SM','Samoan','No')"); |
---|
273 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('SN','Shona','No')"); |
---|
274 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('SO','Somali','No')"); |
---|
275 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('SQ','Albanian','No')"); |
---|
276 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('SR','Serbian','No')"); |
---|
277 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('SS','Siswati','No')"); |
---|
278 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('ST','Sesotho','No')"); |
---|
279 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('SU','Sudanese','No')"); |
---|
280 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('SV','Swedish','Yes')"); |
---|
281 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('SW','Swahili','No')"); |
---|
282 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('TA','Tamil','No')"); |
---|
283 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('TE','Tegulu','No')"); |
---|
284 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('TG','Tajik','No')"); |
---|
285 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('TH','Thai','No')"); |
---|
286 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('TI','Tigrinya','No')"); |
---|
287 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('TK','Turkmen','No')"); |
---|
288 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('TL','Tagalog','No')"); |
---|
289 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('TN','Setswana','No')"); |
---|
290 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('TO','Tonga','No')"); |
---|
291 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('TR','Turkish','No')"); |
---|
292 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('TS','Tsonga','No')"); |
---|
293 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('TT','Tatar','No')"); |
---|
294 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('TW','Twi','No')"); |
---|
295 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('UK','Ukrainian','No')"); |
---|
296 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('UR','Urdu','No')"); |
---|
297 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('UZ','Uzbek','No')"); |
---|
298 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('VI','Vietnamese','No')"); |
---|
299 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('VO','Volapuk','No')"); |
---|
300 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('WO','Wolof','No')"); |
---|
301 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('XH','Xhosa','No')"); |
---|
302 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('YO','Yoruba','No')"); |
---|
303 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('ZH','Chinese','No')"); |
---|
304 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('ZU','Zulu','No')"); |
---|
305 | |
---|
306 | $setup_info['phpgwapi']['currentver'] = '0.9.3pre8'; |
---|
307 | return $setup_info['phpgwapi']['currentver']; |
---|
308 | //return True; |
---|
309 | } |
---|
310 | |
---|
311 | $test[] = '0.9.3pre8'; |
---|
312 | function phpgwapi_upgrade0_9_3pre8() |
---|
313 | { |
---|
314 | global $setup_info, $phpgw_setup; |
---|
315 | $setup_info['phpgwapi']['currentver'] = '0.9.3pre9'; |
---|
316 | return $setup_info['phpgwapi']['currentver']; |
---|
317 | //return True; |
---|
318 | } |
---|
319 | $test[] = '0.9.3pre9'; |
---|
320 | function phpgwapi_upgrade0_9_3pre9() |
---|
321 | { |
---|
322 | global $setup_info, $phpgw_setup; |
---|
323 | $setup_info['phpgwapi']['currentver'] = '0.9.3pre10'; |
---|
324 | return $setup_info['phpgwapi']['currentver']; |
---|
325 | //return True; |
---|
326 | } |
---|
327 | $test[] = '0.9.3pre10'; |
---|
328 | function phpgwapi_upgrade0_9_3pre10() |
---|
329 | { |
---|
330 | global $setup_info, $phpgw_setup; |
---|
331 | $setup_info['phpgwapi']['currentver'] = '0.9.3'; |
---|
332 | return $setup_info['phpgwapi']['currentver']; |
---|
333 | //return True; |
---|
334 | } |
---|
335 | $test[] = '0.9.3'; |
---|
336 | function phpgwapi_upgrade0_9_3() |
---|
337 | { |
---|
338 | global $setup_info, $phpgw_setup; |
---|
339 | $setup_info['phpgwapi']['currentver'] = '0.9.4pre1'; |
---|
340 | return $setup_info['phpgwapi']['currentver']; |
---|
341 | //return True; |
---|
342 | } |
---|
343 | $test[] = '0.9.4pre1'; |
---|
344 | function phpgwapi_upgrade0_9_4pre1() |
---|
345 | { |
---|
346 | global $setup_info, $phpgw_setup; |
---|
347 | $setup_info['phpgwapi']['currentver'] = '0.9.4pre2'; |
---|
348 | return $setup_info['phpgwapi']['currentver']; |
---|
349 | //return True; |
---|
350 | } |
---|
351 | $test[] = '0.9.4pre2'; |
---|
352 | function phpgwapi_upgrade0_9_4pre2() |
---|
353 | { |
---|
354 | global $setup_info, $phpgw_setup; |
---|
355 | $setup_info['phpgwapi']['currentver'] = '0.9.4pre3'; |
---|
356 | return $setup_info['phpgwapi']['currentver']; |
---|
357 | //return True; |
---|
358 | } |
---|
359 | $test[] = '0.9.4pre3'; |
---|
360 | function phpgwapi_upgrade0_9_4pre3() |
---|
361 | { |
---|
362 | global $setup_info, $phpgw_setup; |
---|
363 | $setup_info['phpgwapi']['currentver'] = '0.9.4pre4'; |
---|
364 | return $setup_info['phpgwapi']['currentver']; |
---|
365 | //return True; |
---|
366 | } |
---|
367 | |
---|
368 | $test[] = '0.9.4pre4'; |
---|
369 | function phpgwapi_upgrade0_9_4pre4() |
---|
370 | { |
---|
371 | global $setup_info, $phpgw_setup; |
---|
372 | |
---|
373 | $phpgw_setup->oProc->AlterColumn('sessions', 'session_lid', array('type' => 'varchar', 'precision' => 255)); |
---|
374 | |
---|
375 | $setup_info['phpgwapi']['currentver'] = '0.9.4pre5'; |
---|
376 | return $setup_info['phpgwapi']['currentver']; |
---|
377 | //return True; |
---|
378 | } |
---|
379 | |
---|
380 | $test[] = '0.9.4pre5'; |
---|
381 | function phpgwapi_upgrade0_9_4pre5() |
---|
382 | { |
---|
383 | global $setup_info, $phpgw_setup; |
---|
384 | $setup_info['phpgwapi']['currentver'] = '0.9.4'; |
---|
385 | return $setup_info['phpgwapi']['currentver']; |
---|
386 | //return True; |
---|
387 | } |
---|
388 | |
---|
389 | $test[] = '0.9.4'; |
---|
390 | function phpgwapi_upgrade0_9_4() |
---|
391 | { |
---|
392 | global $setup_info, $phpgw_setup; |
---|
393 | |
---|
394 | $phpgw_setup->oProc->query('delete from languages'); |
---|
395 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('aa','Afar','No')"); |
---|
396 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('ab','Abkhazian','No')"); |
---|
397 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('af','Afrikaans','No')"); |
---|
398 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('am','Amharic','No')"); |
---|
399 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('ar','Arabic','No')"); |
---|
400 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('as','Assamese','No')"); |
---|
401 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('ay','Aymara','No')"); |
---|
402 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('az','Azerbaijani','No')"); |
---|
403 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('ba','Bashkir','No')"); |
---|
404 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('be','Byelorussian','No')"); |
---|
405 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('bg','Bulgarian','No')"); |
---|
406 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('bh','Bihari','No')"); |
---|
407 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('bi','Bislama','No')"); |
---|
408 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('bn','Bengali / Bangla','No')"); |
---|
409 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('bo','Tibetan','No')"); |
---|
410 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('br','Breton','No')"); |
---|
411 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('ca','Catalan','No')"); |
---|
412 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('co','Corsican','No')"); |
---|
413 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('cs','Czech','No')"); |
---|
414 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('cy','Welsh','No')"); |
---|
415 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('da','Danish','Yes')"); |
---|
416 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('de','German','Yes')"); |
---|
417 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('dz','Bhutani','No')"); |
---|
418 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('el','Greek','No')"); |
---|
419 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('en','English / US','Yes')"); |
---|
420 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('eo','Esperanto','No')"); |
---|
421 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('es','Spanish','Yes')"); |
---|
422 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('et','Estonian','No')"); |
---|
423 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('eu','Basque','No')"); |
---|
424 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('fa','Persian','No')"); |
---|
425 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('fi','Finnish','No')"); |
---|
426 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('fj','Fiji','No')"); |
---|
427 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('fo','Faeroese','No')"); |
---|
428 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('fr','French','Yes')"); |
---|
429 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('fy','Frisian','No')"); |
---|
430 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('ga','Irish','No')"); |
---|
431 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('gd','Gaelic / Scots Gaelic','No')"); |
---|
432 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('gl','Galician','No')"); |
---|
433 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('gn','Guarani','No')"); |
---|
434 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('gu','Gujarati','No')"); |
---|
435 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('ha','Hausa','No')"); |
---|
436 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('hi','Hindi','No')"); |
---|
437 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('hr','Croatian','No')"); |
---|
438 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('hu','Hungarian','No')"); |
---|
439 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('hy','Armenian','No')"); |
---|
440 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('ia','Interlingua','No')"); |
---|
441 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('ie','Interlingue','No')"); |
---|
442 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('ik','Inupiak','No')"); |
---|
443 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('in','Indonesian','No')"); |
---|
444 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('is','Icelandic','No')"); |
---|
445 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('it','Italian','Yes')"); |
---|
446 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('iw','Hebrew','No')"); |
---|
447 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('ja','Japanese','No')"); |
---|
448 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('ji','Yiddish','No')"); |
---|
449 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('jw','Javanese','No')"); |
---|
450 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('ka','Georgian','No')"); |
---|
451 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('kk','Kazakh','No')"); |
---|
452 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('kl','Greenlandic','No')"); |
---|
453 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('km','Cambodian','No')"); |
---|
454 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('kn','Kannada','No')"); |
---|
455 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('ko','Korean','Yes')"); |
---|
456 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('ks','Kashmiri','No')"); |
---|
457 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('ku','Kurdish','No')"); |
---|
458 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('ky','Kirghiz','No')"); |
---|
459 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('la','Latin','No')"); |
---|
460 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('ln','Lingala','No')"); |
---|
461 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('lo','Laothian','No')"); |
---|
462 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('lt','Lithuanian','No')"); |
---|
463 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('lv','Latvian / Lettish','No')"); |
---|
464 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('mg','Malagasy','No')"); |
---|
465 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('mi','Maori','No')"); |
---|
466 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('mk','Macedonian','No')"); |
---|
467 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('ml','Malayalam','No')"); |
---|
468 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('mn','Mongolian','No')"); |
---|
469 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('mo','Moldavian','No')"); |
---|
470 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('mr','Marathi','No')"); |
---|
471 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('ms','Malay','No')"); |
---|
472 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('mt','Maltese','No')"); |
---|
473 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('my','Burmese','No')"); |
---|
474 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('na','Nauru','No')"); |
---|
475 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('ne','Nepali','No')"); |
---|
476 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('nl','Dutch','Yes')"); |
---|
477 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('no','Norwegian','Yes')"); |
---|
478 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('oc','Occitan','No')"); |
---|
479 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('om','Oromo / Afan','No')"); |
---|
480 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('or','Oriya','No')"); |
---|
481 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('pa','Punjabi','No')"); |
---|
482 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('pl','Polish','No')"); |
---|
483 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('ps','Pashto / Pushto','No')"); |
---|
484 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('pt','Portuguese','Yes')"); |
---|
485 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('qu','Quechua','No')"); |
---|
486 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('rm','Rhaeto-Romance','No')"); |
---|
487 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('rn','Kirundi','No')"); |
---|
488 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('ro','Romanian','No')"); |
---|
489 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('ru','Russian','No')"); |
---|
490 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('rw','Kinyarwanda','No')"); |
---|
491 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('sa','Sanskrit','No')"); |
---|
492 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('sd','Sindhi','No')"); |
---|
493 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('sg','Sangro','No')"); |
---|
494 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('sh','Serbo-Croatian','No')"); |
---|
495 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('si','Singhalese','No')"); |
---|
496 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('sk','Slovak','No')"); |
---|
497 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('sl','Slovenian','No')"); |
---|
498 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('sm','Samoan','No')"); |
---|
499 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('sn','Shona','No')"); |
---|
500 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('so','Somali','No')"); |
---|
501 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('sq','Albanian','No')"); |
---|
502 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('sr','Serbian','No')"); |
---|
503 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('ss','Siswati','No')"); |
---|
504 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('st','Sesotho','No')"); |
---|
505 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('su','Sudanese','No')"); |
---|
506 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('sv','Swedish','Yes')"); |
---|
507 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('sw','Swahili','No')"); |
---|
508 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('ta','Tamil','No')"); |
---|
509 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('te','Tegulu','No')"); |
---|
510 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('tg','Tajik','No')"); |
---|
511 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('th','Thai','No')"); |
---|
512 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('ti','Tigrinya','No')"); |
---|
513 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('tk','Turkmen','No')"); |
---|
514 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('tl','Tagalog','No')"); |
---|
515 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('tn','Setswana','No')"); |
---|
516 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('to','Tonga','No')"); |
---|
517 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('tr','Turkish','No')"); |
---|
518 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('ts','Tsonga','No')"); |
---|
519 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('tt','Tatar','No')"); |
---|
520 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('tw','Twi','No')"); |
---|
521 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('uk','Ukrainian','No')"); |
---|
522 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('ur','Urdu','No')"); |
---|
523 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('uz','Uzbek','No')"); |
---|
524 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('vi','Vietnamese','No')"); |
---|
525 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('vo','Volapuk','No')"); |
---|
526 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('wo','Wolof','No')"); |
---|
527 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('xh','Xhosa','No')"); |
---|
528 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('yo','Yoruba','No')"); |
---|
529 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('zh','Chinese','No')"); |
---|
530 | @$phpgw_setup->oProc->query("INSERT INTO languages (lang_id, lang_name, available) values ('zu','Zulu','No')"); |
---|
531 | |
---|
532 | $setup_info['phpgwapi']['currentver'] = '0.9.5pre1'; |
---|
533 | return $setup_info['phpgwapi']['currentver']; |
---|
534 | //return True; |
---|
535 | } |
---|
536 | |
---|
537 | $test[] = '0.9.5pre1'; |
---|
538 | function phpgwapi_upgrade0_9_5pre1() |
---|
539 | { |
---|
540 | global $phpgw_info, $phpgw_setup; |
---|
541 | |
---|
542 | $phpgw_setup->oProc->DropTable('sessions'); |
---|
543 | $phpgw_setup->oProc->CreateTable('phpgw_sessions', array( |
---|
544 | 'fd' => array( |
---|
545 | 'session_id' => array('type' => 'varchar', 'precision' => 255, 'nullable' => false), |
---|
546 | 'session_lid' => array('type' => 'varchar', 'precision' => 255), |
---|
547 | 'session_pwd' => array('type' => 'varchar', 'precision' => 255), |
---|
548 | 'session_ip' => array('type' => 'varchar', 'precision' => 255), |
---|
549 | 'session_logintime' => array('type' => 'int', 'precision' => 4), |
---|
550 | 'session_dla' => array('type' => 'int', 'precision' => 4) |
---|
551 | ), |
---|
552 | 'pk' => array(), |
---|
553 | 'ix' => array(), |
---|
554 | 'fk' => array(), |
---|
555 | 'uc' => array('session_id') |
---|
556 | )); |
---|
557 | |
---|
558 | $phpgw_setup->oProc->CreateTable('phpgw_acl', array( |
---|
559 | 'fd' => array( |
---|
560 | 'acl_appname' => array('type' => 'varchar', 'precision' => 50), |
---|
561 | 'acl_location' => array('type' => 'varchar', 'precision' => 255), |
---|
562 | 'acl_account' => array('type' => 'int', 'precision' => 4), |
---|
563 | 'acl_account_type' => array('type' => 'char', 'precision' => 1), |
---|
564 | 'acl_rights' => array('type' => 'int', 'precision' => 4) |
---|
565 | ), |
---|
566 | 'pk' => array(), |
---|
567 | 'ix' => array(), |
---|
568 | 'fk' => array(), |
---|
569 | 'uc' => array() |
---|
570 | )); |
---|
571 | |
---|
572 | $phpgw_setup->oProc->DropTable('app_sessions'); |
---|
573 | $phpgw_setup->oProc->CreateTable('phpgw_app_sessions', array( |
---|
574 | 'fd' => array( |
---|
575 | 'sessionid' => array('type' => 'varchar', 'precision' => 255, 'nullable' => false), |
---|
576 | 'loginid' => array('type' => 'varchar', 'precision' => 20), |
---|
577 | 'app' => array('type' => 'varchar', 'precision' => 20), |
---|
578 | 'content' => array('type' => 'text') |
---|
579 | ), |
---|
580 | 'pk' => array(), |
---|
581 | 'ix' => array(), |
---|
582 | 'fk' => array(), |
---|
583 | 'uc' => array() |
---|
584 | )); |
---|
585 | |
---|
586 | $phpgw_setup->oProc->DropTable('access_log'); |
---|
587 | $phpgw_setup->oProc->CreateTable('phpgw_access_log', array( |
---|
588 | 'fd' => array( |
---|
589 | 'sessionid' => array('type' => 'varchar', 'precision' => 255), |
---|
590 | 'loginid' => array('type' => 'varchar', 'precision' => 30), |
---|
591 | 'ip' => array('type' => 'varchar', 'precision' => 30), |
---|
592 | 'li' => array('type' => 'int', 'precision' => 4), |
---|
593 | 'lo' => array('type' => 'varchar', 'precision' => 255) |
---|
594 | ), |
---|
595 | 'pk' => array(), |
---|
596 | 'ix' => array(), |
---|
597 | 'fk' => array(), |
---|
598 | 'uc' => array() |
---|
599 | )); |
---|
600 | |
---|
601 | $setup_info['phpgwapi']['currentver'] = '0.9.5pre2'; |
---|
602 | return $setup_info['phpgwapi']['currentver']; |
---|
603 | //return True; |
---|
604 | } |
---|
605 | |
---|
606 | $test[] = '0.9.5pre2'; |
---|
607 | function phpgwapi_upgrade0_9_5pre2() |
---|
608 | { |
---|
609 | global $setup_info; |
---|
610 | $setup_info['phpgwapi']['currentver'] = '0.9.5'; |
---|
611 | return $setup_info['phpgwapi']['currentver']; |
---|
612 | //return True; |
---|
613 | } |
---|
614 | |
---|
615 | $test[] = '0.9.5'; |
---|
616 | function phpgwapi_upgrade0_9_5() |
---|
617 | { |
---|
618 | global $setup_info; |
---|
619 | $setup_info['phpgwapi']['currentver'] = '0.9.6'; |
---|
620 | return $setup_info['phpgwapi']['currentver']; |
---|
621 | //return True; |
---|
622 | } |
---|
623 | |
---|
624 | $test[] = '0.9.6'; |
---|
625 | function phpgwapi_upgrade0_9_6() |
---|
626 | { |
---|
627 | global $setup_info; |
---|
628 | $setup_info['phpgwapi']['currentver'] = '0.9.7pre1'; |
---|
629 | return $setup_info['phpgwapi']['currentver']; |
---|
630 | //return True; |
---|
631 | } |
---|
632 | |
---|
633 | $test[] = '0.9.7pre1'; |
---|
634 | function phpgwapi_upgrade0_9_7pre1() |
---|
635 | { |
---|
636 | global $setup_info; |
---|
637 | $setup_info['phpgwapi']['currentver'] = '0.9.7pre2'; |
---|
638 | return $setup_info['phpgwapi']['currentver']; |
---|
639 | //return True; |
---|
640 | } |
---|
641 | $test[] = '0.9.7pre2'; |
---|
642 | function phpgwapi_upgrade0_9_7pre2() |
---|
643 | { |
---|
644 | global $setup_info; |
---|
645 | $setup_info['phpgwapi']['currentver'] = '0.9.7pre3'; |
---|
646 | return $setup_info['phpgwapi']['currentver']; |
---|
647 | //return True; |
---|
648 | } |
---|
649 | |
---|
650 | $test[] = '0.9.7pre3'; |
---|
651 | function phpgwapi_upgrade0_9_7pre3() |
---|
652 | { |
---|
653 | global $setup_info; |
---|
654 | $setup_info['phpgwapi']['currentver'] = '0.9.7'; |
---|
655 | return $setup_info['phpgwapi']['currentver']; |
---|
656 | //return True; |
---|
657 | } |
---|
658 | |
---|
659 | $test[] = '0.9.7'; |
---|
660 | function phpgwapi_upgrade0_9_7() |
---|
661 | { |
---|
662 | global $setup_info; |
---|
663 | $setup_info['phpgwapi']['currentver'] = '0.9.8pre1'; |
---|
664 | return $setup_info['phpgwapi']['currentver']; |
---|
665 | //return True; |
---|
666 | } |
---|
667 | |
---|
668 | $test[] = '0.9.8pre1'; |
---|
669 | function phpgwapi_upgrade0_9_8pre1() |
---|
670 | { |
---|
671 | global $setup_info, $phpgw_setup; |
---|
672 | |
---|
673 | $phpgw_setup->oProc->query("SELECT * FROM preferences ORDER BY preference_owner"); |
---|
674 | $t = array(); |
---|
675 | while ($phpgw_setup->oProc->next_record()) |
---|
676 | { |
---|
677 | $t[$phpgw_setup->oProc->f('preference_owner')][$phpgw_setup->oProc->f('preference_appname')][$phpgw_setup->oProc->f('preference_var')] = $phpgw_setup->oProc->f('preference_value'); |
---|
678 | } |
---|
679 | |
---|
680 | $phpgw_setup->oProc->DropTable('preferences'); |
---|
681 | $phpgw_setup->oProc->CreateTable('preferences', array( |
---|
682 | 'fd' => array( |
---|
683 | 'preference_owner' => array('type' => 'int', 'precision' => 4, 'nullable' => false), |
---|
684 | 'preference_value' => array('type' => 'text') |
---|
685 | ), |
---|
686 | 'pk' => array(), |
---|
687 | 'ix' => array(), |
---|
688 | 'fk' => array(), |
---|
689 | 'uc' => array() |
---|
690 | )); |
---|
691 | |
---|
692 | while ($tt = each($t)) |
---|
693 | { |
---|
694 | $phpgw_setup->oProc->query("insert into preferences values ('$tt[0]','" . serialize($tt[1]) . "')"); |
---|
695 | } |
---|
696 | |
---|
697 | $setup_info['phpgwapi']['currentver'] = '0.9.8pre2'; |
---|
698 | return $setup_info['phpgwapi']['currentver']; |
---|
699 | //return True; |
---|
700 | } |
---|
701 | |
---|
702 | $test[] = '0.9.8pre2'; |
---|
703 | function phpgwapi_upgrade0_9_8pre2() |
---|
704 | { |
---|
705 | global $setup_info, $phpgw_setup; |
---|
706 | $setup_info['phpgwapi']['currentver'] = '0.9.8pre3'; |
---|
707 | return $setup_info['phpgwapi']['currentver']; |
---|
708 | //return True; |
---|
709 | } |
---|
710 | |
---|
711 | $test[] = '0.9.8pre3'; |
---|
712 | function phpgwapi_upgrade0_9_8pre3() |
---|
713 | { |
---|
714 | global $setup_info, $phpgw_setup; |
---|
715 | |
---|
716 | $phpgw_setup->oProc->DropTable('phpgw_sessions'); |
---|
717 | $phpgw_setup->oProc->CreateTable( |
---|
718 | 'phpgw_sessions', array( |
---|
719 | 'fd' => array( |
---|
720 | 'session_id' => array('type' => 'varchar', 'precision' => 255, 'nullable' => false), |
---|
721 | 'session_lid' => array('type' => 'varchar', 'precision' => 255), |
---|
722 | 'session_ip' => array('type' => 'varchar', 'precision' => 255), |
---|
723 | 'session_logintime' => array('type' => 'int', 'precision' => 4), |
---|
724 | 'session_dla' => array('type' => 'int', 'precision' => 4), |
---|
725 | 'session_info' => array('type' => 'text') |
---|
726 | ), |
---|
727 | 'pk' => array(), |
---|
728 | 'ix' => array(), |
---|
729 | 'fk' => array(), |
---|
730 | 'uc' => array('session_id') |
---|
731 | ) |
---|
732 | ); |
---|
733 | |
---|
734 | $setup_info['phpgwapi']['currentver'] = '0.9.8pre4'; |
---|
735 | return $setup_info['phpgwapi']['currentver']; |
---|
736 | //return True; |
---|
737 | } |
---|
738 | |
---|
739 | $test[] = '0.9.8pre4'; |
---|
740 | function phpgwapi_upgrade0_9_8pre4() |
---|
741 | { |
---|
742 | global $setup_info, $phpgw_setup; |
---|
743 | |
---|
744 | $phpgw_setup->oProc->CreateTable( |
---|
745 | 'phpgw_hooks', array( |
---|
746 | 'fd' => array( |
---|
747 | 'hook_id' => array('type' => 'auto', 'nullable' => false), |
---|
748 | 'hook_appname' => array('type' => 'varchar', 'precision' => 255), |
---|
749 | 'hook_location' => array('type' => 'varchar', 'precision' => 255), |
---|
750 | 'hook_filename' => array('type' => 'varchar', 'precision' => 255) |
---|
751 | ), |
---|
752 | 'pk' => array("hook_id"), |
---|
753 | 'ix' => array(), |
---|
754 | 'fk' => array(), |
---|
755 | 'uc' => array() |
---|
756 | ) |
---|
757 | ); |
---|
758 | |
---|
759 | $setup_info['phpgwapi']['currentver'] = '0.9.8pre5'; |
---|
760 | return $setup_info['phpgwapi']['currentver']; |
---|
761 | //return True; |
---|
762 | } |
---|
763 | |
---|
764 | $test[] = '0.9.8pre5'; |
---|
765 | function phpgwapi_upgrade0_9_8pre5() |
---|
766 | { |
---|
767 | global $setup_info, $phpgw_setup; |
---|
768 | |
---|
769 | // Since no applications are using it yet. I am gonna drop it and create a new one. |
---|
770 | // This is becuase I never finished the classes |
---|
771 | $phpgw_setup->oProc->DropTable('categories'); |
---|
772 | |
---|
773 | $phpgw_setup->oProc->CreateTable( |
---|
774 | 'phpgw_categories', array( |
---|
775 | 'fd' => array( |
---|
776 | 'cat_id' => array('type' => 'auto', 'nullable' => false), |
---|
777 | 'cat_parent' => array('type' => 'int', 'precision' => 4, 'default' => 0, 'nullable' => false), |
---|
778 | 'cat_owner' => array('type' => 'int', 'precision' => 4, 'default' => 0, 'nullable' => false), |
---|
779 | 'cat_appname' => array('type' => 'varchar', 'precision' => 50, 'nullable' => false), |
---|
780 | 'cat_name' => array('type' => 'varchar', 'precision' => 150, 'nullable' => false), |
---|
781 | 'cat_description' => array('type' => 'varchar', 'precision' => 255, 'nullable' => false), |
---|
782 | 'cat_data' => array('type' => 'text') |
---|
783 | ), |
---|
784 | 'pk' => array('cat_id'), |
---|
785 | 'ix' => array(), |
---|
786 | 'fk' => array(), |
---|
787 | 'uc' => array() |
---|
788 | ) |
---|
789 | ); |
---|
790 | |
---|
791 | $setup_info['phpgwapi']['currentver'] = '0.9.9pre1'; |
---|
792 | return $setup_info['phpgwapi']['currentver']; |
---|
793 | //return True; |
---|
794 | } |
---|
795 | |
---|
796 | $test[] = '0.9.9pre1'; |
---|
797 | function phpgwapi_upgrade0_9_9pre1() |
---|
798 | { |
---|
799 | global $setup_info; |
---|
800 | $setup_info['phpgwapi']['currentver'] = '0.9.9'; |
---|
801 | return $setup_info['phpgwapi']['currentver']; |
---|
802 | //return True; |
---|
803 | } |
---|
804 | ?> |
---|