Contents of /alx-src/branches/alx-web-070/scripts/sql-schema/include/schema.sh
Parent Directory | Revision Log
Revision 15316 -
(show annotations)
(download)
(as text)
Fri Aug 14 08:53:06 2020 UTC (3 years, 9 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, 9 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 | 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_citrix_serverlist" |
17 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" |
18 | "serial int(11) DEFAULT NULL" |
19 | "host varchar(255) DEFAULT NULL" |
20 | "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 | "name varchar(255) DEFAULT NULL" |
37 | "exec varchar(255) DEFAULT NULL" |
38 | "comment varchar(255) DEFAULT NULL" |
39 | "enabled tinyint(1) NOT NULL DEFAULT '1'" |
40 | ) |
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 | "name varchar(255) DEFAULT NULL" |
48 | "exec varchar(255) DEFAULT NULL" |
49 | "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 | "theme varchar(255) DEFAULT NULL" |
60 | ) |
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 | "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 | "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 | "printer_name varchar(255) DEFAULT NULL" |
139 | "port varchar(255) DEFAULT NULL" |
140 | "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 | "screensaver varchar(255) DEFAULT NULL" |
155 | "timeout int(11) DEFAULT '10'" |
156 | "password varchar(255) DEFAULT NULL" |
157 | "dpms tinyint(1) NOT NULL DEFAULT '1'" |
158 | ) |
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 | "name varchar(255) DEFAULT NULL" |
166 | "session varchar(255) DEFAULT NULL" |
167 | "filename varchar(255) DEFAULT NULL" |
168 | "username varchar(255) DEFAULT NULL" |
169 | "domain varchar(255) DEFAULT NULL" |
170 | "password varchar(255) DEFAULT NULL" |
171 | "serverlist varchar(255) DEFAULT NULL" |
172 | "autostart tinyint(1) NOT NULL DEFAULT '1'" |
173 | "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 | "name varchar(255) DEFAULT NULL" |
183 | "server varchar(255) DEFAULT NULL" |
184 | "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 | "autostart tinyint(1) NOT NULL DEFAULT '1'" |
190 | "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 | "name varchar(255) DEFAULT NULL" |
200 | "session varchar(255) DEFAULT NULL" |
201 | "filename varchar(255) DEFAULT NULL" |
202 | "username varchar(255) DEFAULT NULL" |
203 | "domain varchar(255) DEFAULT NULL" |
204 | "password varchar(255) DEFAULT NULL" |
205 | "store varchar(255) DEFAULT NULL" |
206 | "autostart tinyint(1) NOT NULL DEFAULT '1'" |
207 | "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 | "store varchar(255) DEFAULT NULL" |
217 | "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 | "client_locations" |
239 | "location varchar(255) NOT NULL PRIMARY KEY" |
240 | "bootserver varchar(255) DEFAULT NULL" |
241 | "bootsubdir varchar(255) DEFAULT NULL" |
242 | "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 | "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 | "serial int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" |
261 | "location varchar(255) DEFAULT NULL" |
262 | "mtime int(11) DEFAULT NULL" |
263 | "mac varchar(17) DEFAULT NULL" |
264 | "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 | "os varchar(50) DEFAULT NULL" |
273 | "utils varchar(50) DEFAULT NULL" |
274 | "arch varchar(50) NOT NULL" |
275 | ) |
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 | "name varchar(255) DEFAULT NULL" |
293 | "store varchar(255) DEFAULT NULL" |
294 | "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 | "session varchar(255) DEFAULT NULL" |
305 | "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 | "value varchar(255) DEFAULT NULL" |
314 | "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 | "value varchar(255) DEFAULT NULL" |
322 | "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 | "value varchar(255) DEFAULT NULL" |
330 | "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 | "value varchar(255) DEFAULT NULL" |
338 | "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 | "value varchar(255) DEFAULT NULL" |
346 | "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 | "value varchar(255) DEFAULT NULL" |
354 | "enabled tinyint(1) NOT NULL DEFAULT '1'" |
355 | "description varchar(255) DEFAULT NULL" |
356 | ) |
357 | sql_create_table |
358 | |
359 | TABLE_DEFINITION=( |
360 | "values_network_wireless_auth_mode" |
361 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" |
362 | "value varchar(255) DEFAULT NULL" |
363 | "enabled tinyint(1) NOT NULL DEFAULT '1'" |
364 | ) |
365 | sql_create_table |
366 | |
367 | TABLE_DEFINITION=( |
368 | "values_network_wireless_bitrate" |
369 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" |
370 | "value varchar(255) DEFAULT NULL" |
371 | "enabled tinyint(1) NOT NULL DEFAULT '1'" |
372 | ) |
373 | sql_create_table |
374 | |
375 | TABLE_DEFINITION=( |
376 | "values_network_wireless_channel" |
377 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" |
378 | "value varchar(255) DEFAULT NULL" |
379 | "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 | "value varchar(255) DEFAULT NULL" |
387 | "enabled tinyint(1) NOT NULL DEFAULT '1'" |
388 | ) |
389 | sql_create_table |
390 | |
391 | TABLE_DEFINITION=( |
392 | "values_network_wireless_key_length" |
393 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" |
394 | "value varchar(255) DEFAULT NULL" |
395 | "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 | "value varchar(255) DEFAULT NULL" |
403 | "enabled tinyint(1) NOT NULL DEFAULT '1'" |
404 | ) |
405 | sql_create_table |
406 | |
407 | TABLE_DEFINITION=( |
408 | "values_printers_port" |
409 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" |
410 | "value varchar(255) DEFAULT NULL" |
411 | "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 | "value varchar(255) DEFAULT NULL" |
419 | "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 | "session varchar(255) DEFAULT NULL" |
427 | "description varchar(255) DEFAULT NULL" |
428 | "store varchar(255) DEFAULT NULL" |
429 | "enabled tinyint(1) NOT NULL DEFAULT '1'" |
430 | ) |
431 | sql_create_table |
432 | |
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 | } |