Contents of /alx-src/branches/alx-web-070/scripts/sql-schema/include/schema.sh
Parent Directory | Revision Log
Revision 9462 -
(show annotations)
(download)
(as text)
Thu Apr 6 12:51:30 2017 UTC (7 years, 2 months ago) by niro
File MIME type: application/x-sh
File size: 12110 byte(s)
Thu Apr 6 12:51:30 2017 UTC (7 years, 2 months ago) by niro
File MIME type: application/x-sh
File size: 12110 byte(s)
-updated schema to version 8
1 | create_database_schema() |
2 | { |
3 | TABLE_DEFINITION=( |
4 | "meta_schema" |
5 | "version int(11) NOT NULL PRIMARY KEY" |
6 | ) |
7 | sql_create_table |
8 | |
9 | TABLE_DEFINITION=( |
10 | "meta_values" |
11 | "version int(11) NOT NULL PRIMARY KEY" |
12 | ) |
13 | sql_create_table |
14 | |
15 | TABLE_DEFINITION=( |
16 | "cfg_autostart" |
17 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" |
18 | "serial int(11) NOT NULL" |
19 | "name varchar(255) NOT NULL" |
20 | "exec varchar(255) DEFAULT NULL" |
21 | "enabled tinyint(1) NOT NULL DEFAULT '1'" |
22 | "flg_modified tinyint(1) NOT NULL DEFAULT '0'" |
23 | ) |
24 | sql_create_table |
25 | |
26 | TABLE_DEFINITION=( |
27 | "cfg_citrix_serverlist" |
28 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" |
29 | "serial int(11) NOT NULL" |
30 | "host varchar(255) NOT NULL" |
31 | "enabled tinyint(1) NOT NULL DEFAULT '1'" |
32 | ) |
33 | sql_create_table |
34 | |
35 | TABLE_DEFINITION=( |
36 | "cfg_comments" |
37 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" |
38 | "serial int(11) NOT NULL" |
39 | "txt text" |
40 | ) |
41 | sql_create_table |
42 | |
43 | TABLE_DEFINITION=( |
44 | "cfg_fluxbox_autostart" |
45 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" |
46 | "serial int(11) NOT NULL" |
47 | "name varchar(255) NOT NULL" |
48 | "exec varchar(255) NOT NULL" |
49 | "comment varchar(255) DEFAULT NULL" |
50 | ) |
51 | sql_create_table |
52 | |
53 | TABLE_DEFINITION=( |
54 | "cfg_fluxbox_menuitem" |
55 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" |
56 | "serial int(11) NOT NULL" |
57 | "name varchar(255) NOT NULL" |
58 | "exec varchar(255) NOT NULL" |
59 | "workdir varchar(255) DEFAULT NULL" |
60 | "icon varchar(255) DEFAULT NULL" |
61 | "enabled tinyint(1) NOT NULL DEFAULT '1'" |
62 | ) |
63 | sql_create_table |
64 | |
65 | TABLE_DEFINITION=( |
66 | "cfg_fluxbox_theme" |
67 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" |
68 | "serial int(11) NOT NULL" |
69 | "theme varchar(255) NOT NULL" |
70 | ) |
71 | sql_create_table |
72 | |
73 | TABLE_DEFINITION=( |
74 | "cfg_graphic" |
75 | "serial int(11) NOT NULL PRIMARY KEY" |
76 | "resolution varchar(255) DEFAULT NULL" |
77 | "depth varchar(288) DEFAULT NULL" |
78 | "monitorid int(11) DEFAULT NULL" |
79 | "refresh_rate int(3) NOT NULL DEFAULT '60'" |
80 | "module varchar(255) DEFAULT NULL" |
81 | "hdmi varchar(10) NOT NULL DEFAULT 'disable'" |
82 | ) |
83 | sql_create_table |
84 | |
85 | TABLE_DEFINITION=( |
86 | "cfg_idesk_icon" |
87 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" |
88 | "serial int(11) NOT NULL" |
89 | "name varchar(255) NOT NULL" |
90 | "command varchar(255) NOT NULL" |
91 | "icon varchar(255) NOT NULL" |
92 | "filename varchar(255) NOT NULL" |
93 | "xpos varchar(255) NOT NULL" |
94 | "ypos varchar(255) NOT NULL" |
95 | "width varchar(255) NOT NULL" |
96 | "height varchar(255) NOT NULL" |
97 | "default_icon varchar(255) NOT NULL" |
98 | "enabled tinyint(1) NOT NULL DEFAULT '1'" |
99 | ) |
100 | sql_create_table |
101 | |
102 | TABLE_DEFINITION=( |
103 | "cfg_input" |
104 | "serial int(11) NOT NULL PRIMARY KEY" |
105 | "keymap varchar(255) DEFAULT NULL" |
106 | ) |
107 | sql_create_table |
108 | |
109 | TABLE_DEFINITION=( |
110 | "cfg_modules" |
111 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" |
112 | "serial int(11) NOT NULL" |
113 | "module varchar(255) DEFAULT NULL" |
114 | "arg varchar(255) DEFAULT NULL" |
115 | ) |
116 | sql_create_table |
117 | |
118 | TABLE_DEFINITION=( |
119 | "cfg_network" |
120 | "serial int(11) NOT NULL PRIMARY KEY" |
121 | "hostname varchar(255) DEFAULT NULL" |
122 | "domain varchar(255) DEFAULT NULL" |
123 | "networking varchar(255) DEFAULT NULL" |
124 | "netmask varchar(255) DEFAULT NULL" |
125 | "dns varchar(255) DEFAULT NULL" |
126 | "gateway varchar(255) DEFAULT NULL" |
127 | "broadcast varchar(255) DEFAULT NULL" |
128 | "ip varchar(255) DEFAULT NULL" |
129 | "module varchar(255) DEFAULT NULL" |
130 | "forcemacto varchar(17) DEFAULT NULL" |
131 | "wireless_bitrate varchar(5) DEFAULT NULL" |
132 | "wireless_channel varchar(10) DEFAULT NULL" |
133 | "wireless_essid varchar(255) DEFAULT NULL" |
134 | "wireless_frequency varchar(255) DEFAULT NULL" |
135 | "wireless_mode varchar(255) DEFAULT NULL" |
136 | "wireless_nick varchar(255) DEFAULT NULL" |
137 | "wireless_auth_mode varchar(255) DEFAULT NULL" |
138 | "wireless_key_length varchar(255) DEFAULT NULL" |
139 | "wireless_key text" |
140 | "wireless_key_ascii text" |
141 | ) |
142 | sql_create_table |
143 | |
144 | TABLE_DEFINITION=( |
145 | "cfg_other_menuitems" |
146 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" |
147 | "serial int(11) NOT NULL" |
148 | "name varchar(255) DEFAULT NULL" |
149 | "exec varchar(255) DEFAULT NULL" |
150 | "workdir varchar(255) DEFAULT NULL" |
151 | "icon varchar(255) DEFAULT NULL" |
152 | ) |
153 | sql_create_table |
154 | |
155 | TABLE_DEFINITION=( |
156 | "cfg_printers" |
157 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" |
158 | "serial int(11) NOT NULL" |
159 | "printer_name varchar(255) NOT NULL" |
160 | "port varchar(255) NOT NULL" |
161 | "enabled tinyint(1) NOT NULL DEFAULT '1'" |
162 | ) |
163 | sql_create_table |
164 | |
165 | TABLE_DEFINITION=( |
166 | "cfg_scm_egk" |
167 | "serial int(11) NOT NULL PRIMARY KEY" |
168 | "facility tinyint(1) NOT NULL DEFAULT '1'" |
169 | ) |
170 | sql_create_table |
171 | |
172 | TABLE_DEFINITION=( |
173 | "cfg_screensaver" |
174 | "serial int(11) NOT NULL PRIMARY KEY" |
175 | "screensaver varchar(255) NOT NULL" |
176 | "timeout int(11) DEFAULT '10'" |
177 | "password varchar(255) DEFAULT NULL" |
178 | ) |
179 | sql_create_table |
180 | |
181 | TABLE_DEFINITION=( |
182 | "cfg_sessions_citrix" |
183 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" |
184 | "serial int(11) NOT NULL" |
185 | "name varchar(255) NOT NULL" |
186 | "session varchar(255) NOT NULL" |
187 | "filename varchar(255) DEFAULT NULL" |
188 | "username varchar(255) DEFAULT NULL" |
189 | "domain varchar(255) DEFAULT NULL" |
190 | "password varchar(255) DEFAULT NULL" |
191 | "serverlist varchar(255) NOT NULL" |
192 | "autostart tinyint(1) NOT NULL DEFAULT '1'" |
193 | "enabled tinyint(1) NOT NULL DEFAULT '1'" |
194 | "flg_modified tinyint(1) NOT NULL DEFAULT '0'" |
195 | ) |
196 | sql_create_table |
197 | |
198 | TABLE_DEFINITION=( |
199 | "cfg_sessions_rdesktop" |
200 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" |
201 | "serial int(11) NOT NULL" |
202 | "name varchar(255) NOT NULL" |
203 | "server varchar(255) NOT NULL" |
204 | "filename varchar(255) DEFAULT NULL" |
205 | "username varchar(255) DEFAULT NULL" |
206 | "password varchar(255) DEFAULT NULL" |
207 | "domain varchar(255) DEFAULT NULL" |
208 | "shell varchar(255) DEFAULT NULL" |
209 | "autostart tinyint(1) NOT NULL DEFAULT '1'" |
210 | "enabled tinyint(1) NOT NULL DEFAULT '1'" |
211 | "flg_modified tinyint(1) NOT NULL DEFAULT '0'" |
212 | ) |
213 | sql_create_table |
214 | |
215 | TABLE_DEFINITION=( |
216 | "cfg_sessions_storefront" |
217 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" |
218 | "serial int(11) NOT NULL" |
219 | "name varchar(255) NOT NULL" |
220 | "session varchar(255) NOT NULL" |
221 | "filename varchar(255) DEFAULT NULL" |
222 | "username varchar(255) DEFAULT NULL" |
223 | "domain varchar(255) DEFAULT NULL" |
224 | "password varchar(255) DEFAULT NULL" |
225 | "store varchar(255) NOT NULL" |
226 | "autostart tinyint(1) NOT NULL DEFAULT '1'" |
227 | "enabled tinyint(1) NOT NULL DEFAULT '1'" |
228 | "flg_modified tinyint(1) NOT NULL DEFAULT '0'" |
229 | ) |
230 | sql_create_table |
231 | |
232 | TABLE_DEFINITION=( |
233 | "cfg_storefront_store" |
234 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" |
235 | "serial int(11) NOT NULL" |
236 | "store varchar(255) NOT NULL" |
237 | "enabled tinyint(1) NOT NULL DEFAULT '1'" |
238 | ) |
239 | sql_create_table |
240 | |
241 | TABLE_DEFINITION=( |
242 | "cfg_vnc" |
243 | "serial int(11) NOT NULL PRIMARY KEY" |
244 | "service tinyint(1) NOT NULL DEFAULT '1'" |
245 | ) |
246 | sql_create_table |
247 | |
248 | TABLE_DEFINITION=( |
249 | "client_auth" |
250 | "serial int(11) NOT NULL PRIMARY KEY" |
251 | "user varchar(255) DEFAULT NULL" |
252 | "root varchar(255) DEFAULT NULL" |
253 | "vnc varchar(255) DEFAULT NULL" |
254 | ) |
255 | sql_create_table |
256 | |
257 | TABLE_DEFINITION=( |
258 | "client_locations" |
259 | "location varchar(255) NOT NULL PRIMARY KEY" |
260 | "bootserver varchar(255) NOT NULL" |
261 | "controlserver varchar(255) NOT NULL" |
262 | "pxe_default_entry varchar(255) NOT NULL" |
263 | "pxe_prompt tinyint(1) NOT NULL" |
264 | "pxe_timeout smallint(1) NOT NULL" |
265 | "updateserver varchar(255) NOT NULL" |
266 | "username varchar(255) NOT NULL" |
267 | "password varchar(255) NOT NULL" |
268 | "rsync varchar(255) NOT NULL" |
269 | "repository varchar(255) NOT NULL" |
270 | "helpdesk_unit varchar(255) NOT NULL" |
271 | "helpdesk_phone varchar(255) NOT NULL" |
272 | "set_default tinyint(1) NOT NULL DEFAULT '0'" |
273 | "enabled tinyint(1) NOT NULL DEFAULT '1'" |
274 | ) |
275 | sql_create_table |
276 | |
277 | TABLE_DEFINITION=( |
278 | "client_serials" |
279 | "serial int(11) NOT NULL PRIMARY KEY" |
280 | "location varchar(255) NOT NULL" |
281 | "mtime int(11) DEFAULT NULL" |
282 | "mac varchar(17) NOT NULL" |
283 | "hwdetected tinyint(1) NOT NULL DEFAULT '0'" |
284 | "enabled tinyint(1) NOT NULL DEFAULT '1'" |
285 | ) |
286 | sql_create_table |
287 | |
288 | TABLE_DEFINITION=( |
289 | "client_version" |
290 | "serial int(11) NOT NULL PRIMARY KEY" |
291 | "os varchar(50) NOT NULL" |
292 | "utils varchar(50) NOT NULL" |
293 | ) |
294 | sql_create_table |
295 | |
296 | TABLE_DEFINITION=( |
297 | "state_connected" |
298 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" |
299 | "mtime int(11) DEFAULT NULL" |
300 | "serial int(11) NOT NULL" |
301 | "ip varchar(255) DEFAULT NULL" |
302 | "mac varchar(255) DEFAULT NULL" |
303 | "netboot tinyint(1) NOT NULL DEFAULT '0'" |
304 | ) |
305 | sql_create_table |
306 | |
307 | TABLE_DEFINITION=( |
308 | "values_storefront_store" |
309 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" |
310 | "name varchar(255) NOT NULL" |
311 | "store varchar(255) NOT NULL" |
312 | "user varchar(255) DEFAULT NULL" |
313 | "password varchar(255) DEFAULT NULL" |
314 | "domain varchar(255) DEFAULT NULL" |
315 | "enabled tinyint(1) NOT NULL DEFAULT '1'" |
316 | ) |
317 | sql_create_table |
318 | |
319 | TABLE_DEFINITION=( |
320 | "values_citrix_session" |
321 | "id int(255) NOT NULL PRIMARY KEY AUTO_INCREMENT" |
322 | "session varchar(255) NOT NULL" |
323 | "description varchar(255) DEFAULT NULL" |
324 | "enabled tinyint(1) NOT NULL DEFAULT '1'" |
325 | ) |
326 | sql_create_table |
327 | |
328 | TABLE_DEFINITION=( |
329 | "values_graphic_depth" |
330 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" |
331 | "value varchar(255) NOT NULL" |
332 | "enabled tinyint(1) NOT NULL DEFAULT '1'" |
333 | ) |
334 | sql_create_table |
335 | |
336 | TABLE_DEFINITION=( |
337 | "values_graphic_module" |
338 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" |
339 | "value varchar(255) NOT NULL" |
340 | "enabled tinyint(1) NOT NULL DEFAULT '1'" |
341 | ) |
342 | sql_create_table |
343 | |
344 | TABLE_DEFINITION=( |
345 | "values_graphic_refresh_rate" |
346 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" |
347 | "value varchar(255) NOT NULL" |
348 | "enabled tinyint(1) NOT NULL DEFAULT '1'" |
349 | ) |
350 | sql_create_table |
351 | |
352 | TABLE_DEFINITION=( |
353 | "values_graphic_resolution" |
354 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" |
355 | "value varchar(255) NOT NULL" |
356 | "enabled tinyint(1) NOT NULL DEFAULT '1'" |
357 | ) |
358 | sql_create_table |
359 | |
360 | TABLE_DEFINITION=( |
361 | "values_input_keymap" |
362 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" |
363 | "value varchar(255) NOT NULL" |
364 | "enabled tinyint(1) NOT NULL DEFAULT '1'" |
365 | ) |
366 | sql_create_table |
367 | |
368 | TABLE_DEFINITION=( |
369 | "values_network_module" |
370 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" |
371 | "value varchar(255) NOT NULL" |
372 | "enabled tinyint(1) NOT NULL DEFAULT '1'" |
373 | "description varchar(255) DEFAULT NULL AFTER value" |
374 | ) |
375 | sql_create_table |
376 | |
377 | TABLE_DEFINITION=( |
378 | "values_network_wireless_auth_mode" |
379 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" |
380 | "value varchar(255) NOT NULL" |
381 | "enabled tinyint(1) NOT NULL DEFAULT '1'" |
382 | ) |
383 | sql_create_table |
384 | |
385 | TABLE_DEFINITION=( |
386 | "values_network_wireless_bitrate" |
387 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" |
388 | "value varchar(255) NOT NULL" |
389 | "enabled tinyint(1) NOT NULL DEFAULT '1'" |
390 | ) |
391 | sql_create_table |
392 | |
393 | TABLE_DEFINITION=( |
394 | "values_network_wireless_channel" |
395 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" |
396 | "value varchar(255) NOT NULL" |
397 | "enabled tinyint(1) NOT NULL DEFAULT '1'" |
398 | ) |
399 | sql_create_table |
400 | |
401 | TABLE_DEFINITION=( |
402 | "values_network_wireless_frequency" |
403 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" |
404 | "value varchar(255) NOT NULL" |
405 | "enabled tinyint(1) NOT NULL DEFAULT '1'" |
406 | ) |
407 | sql_create_table |
408 | |
409 | TABLE_DEFINITION=( |
410 | "values_network_wireless_key_length" |
411 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" |
412 | "value varchar(255) NOT NULL" |
413 | "enabled tinyint(1) NOT NULL DEFAULT '1'" |
414 | ) |
415 | sql_create_table |
416 | |
417 | TABLE_DEFINITION=( |
418 | "values_network_wireless_mode" |
419 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" |
420 | "value varchar(255) NOT NULL" |
421 | "enabled tinyint(1) NOT NULL DEFAULT '1'" |
422 | ) |
423 | sql_create_table |
424 | |
425 | TABLE_DEFINITION=( |
426 | "values_printers_port" |
427 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" |
428 | "value varchar(255) NOT NULL" |
429 | "enabled tinyint(1) NOT NULL DEFAULT '1'" |
430 | ) |
431 | sql_create_table |
432 | |
433 | TABLE_DEFINITION=( |
434 | "values_screensaver_screensaver" |
435 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" |
436 | "value varchar(255) NOT NULL" |
437 | "enabled tinyint(1) NOT NULL DEFAULT '1'" |
438 | ) |
439 | sql_create_table |
440 | |
441 | TABLE_DEFINITION=( |
442 | "values_storefront_session" |
443 | "id int(255) NOT NULL PRIMARY KEY AUTO_INCREMENT" |
444 | "session varchar(255) NOT NULL" |
445 | "description varchar(255) DEFAULT NULL" |
446 | "store varchar(255) NOT NULL" |
447 | "enabled tinyint(1) NOT NULL DEFAULT '1'" |
448 | ) |
449 | sql_create_table |
450 | } |