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