Context Navigation

source: trunk/phpgwapi/setup/tables_update_0_9_9.inc.php @ 2

Revision 2, 47.6 KB checked in by niltonneto, 17 years ago (diff)
Removida todas as tags usadas pelo CVS ($Id, $Source). Primeira versão no CVS externo.
Property svn:eol-style set to `native` Property svn:executable set to ``*

Line
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	?>

Note: See TracBrowser for help on using the repository browser.

Download in other formats: