Annotation of /alx-src/branches/alx-web-070/scripts/sql-schema/include/schema.sh
Parent Directory | Revision Log
Revision 13666 -
(hide annotations)
(download)
(as text)
Thu Jul 25 12:55:42 2019 UTC (5 years, 2 months ago) by niro
File MIME type: application/x-sh
File size: 11730 byte(s)
Thu Jul 25 12:55:42 2019 UTC (5 years, 2 months ago) by niro
File MIME type: application/x-sh
File size: 11730 byte(s)
-update database schema to version 13, added column enabled to cfg_fluxbox_autostart
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 | "serial int(11) NOT NULL" | ||
19 | "host varchar(255) NOT 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) NOT NULL" | ||
37 | "exec varchar(255) NOT NULL" | ||
38 | "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 | "name varchar(255) NOT NULL" | ||
48 | "exec varchar(255) NOT 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) NOT 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) NOT NULL" | ||
80 | "command varchar(255) NOT NULL" | ||
81 | "icon varchar(255) NOT NULL" | ||
82 | "filename varchar(255) NOT NULL" | ||
83 | "xpos varchar(255) NOT NULL" | ||
84 | "ypos varchar(255) NOT NULL" | ||
85 | "width varchar(255) NOT NULL" | ||
86 | "height varchar(255) NOT NULL" | ||
87 | "default_icon varchar(255) NOT 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) NOT NULL" | ||
139 | "port varchar(255) NOT 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) NOT NULL" | ||
155 | "timeout int(11) DEFAULT '10'" | ||
156 | "password varchar(255) DEFAULT NULL" | ||
157 | ) | ||
158 | sql_create_table | ||
159 | |||
160 | TABLE_DEFINITION=( | ||
161 | "cfg_sessions_citrix" | ||
162 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" | ||
163 | "serial int(11) NOT NULL" | ||
164 | "name varchar(255) NOT NULL" | ||
165 | "session varchar(255) NOT NULL" | ||
166 | "filename varchar(255) DEFAULT NULL" | ||
167 | "username varchar(255) DEFAULT NULL" | ||
168 | "domain varchar(255) DEFAULT NULL" | ||
169 | "password varchar(255) DEFAULT NULL" | ||
170 | "serverlist varchar(255) NOT NULL" | ||
171 | niro | 8573 | "autostart tinyint(1) NOT NULL DEFAULT '1'" |
172 | niro | 8485 | "enabled tinyint(1) NOT NULL DEFAULT '1'" |
173 | "flg_modified tinyint(1) NOT NULL DEFAULT '0'" | ||
174 | ) | ||
175 | sql_create_table | ||
176 | |||
177 | TABLE_DEFINITION=( | ||
178 | "cfg_sessions_rdesktop" | ||
179 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" | ||
180 | "serial int(11) NOT NULL" | ||
181 | "name varchar(255) NOT NULL" | ||
182 | "server varchar(255) NOT NULL" | ||
183 | "filename varchar(255) DEFAULT NULL" | ||
184 | "username varchar(255) DEFAULT NULL" | ||
185 | "password varchar(255) DEFAULT NULL" | ||
186 | "domain varchar(255) DEFAULT NULL" | ||
187 | "shell varchar(255) DEFAULT NULL" | ||
188 | niro | 8573 | "autostart tinyint(1) NOT NULL DEFAULT '1'" |
189 | niro | 8485 | "enabled tinyint(1) NOT NULL DEFAULT '1'" |
190 | "flg_modified tinyint(1) NOT NULL DEFAULT '0'" | ||
191 | ) | ||
192 | sql_create_table | ||
193 | |||
194 | TABLE_DEFINITION=( | ||
195 | "cfg_sessions_storefront" | ||
196 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" | ||
197 | "serial int(11) NOT NULL" | ||
198 | "name varchar(255) NOT NULL" | ||
199 | "session varchar(255) NOT NULL" | ||
200 | "filename varchar(255) DEFAULT NULL" | ||
201 | "username varchar(255) DEFAULT NULL" | ||
202 | "domain varchar(255) DEFAULT NULL" | ||
203 | "password varchar(255) DEFAULT NULL" | ||
204 | "store varchar(255) NOT NULL" | ||
205 | niro | 8573 | "autostart tinyint(1) NOT NULL DEFAULT '1'" |
206 | niro | 8485 | "enabled tinyint(1) NOT NULL DEFAULT '1'" |
207 | "flg_modified tinyint(1) NOT NULL DEFAULT '0'" | ||
208 | ) | ||
209 | sql_create_table | ||
210 | |||
211 | TABLE_DEFINITION=( | ||
212 | "cfg_storefront_store" | ||
213 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" | ||
214 | "serial int(11) NOT NULL" | ||
215 | "store varchar(255) NOT NULL" | ||
216 | "enabled tinyint(1) NOT NULL DEFAULT '1'" | ||
217 | ) | ||
218 | sql_create_table | ||
219 | |||
220 | TABLE_DEFINITION=( | ||
221 | "cfg_vnc" | ||
222 | "serial int(11) NOT NULL PRIMARY KEY" | ||
223 | "service tinyint(1) NOT NULL DEFAULT '1'" | ||
224 | ) | ||
225 | sql_create_table | ||
226 | |||
227 | TABLE_DEFINITION=( | ||
228 | "client_auth" | ||
229 | "serial int(11) NOT NULL PRIMARY KEY" | ||
230 | "user varchar(255) DEFAULT NULL" | ||
231 | "root varchar(255) DEFAULT NULL" | ||
232 | "vnc varchar(255) DEFAULT NULL" | ||
233 | ) | ||
234 | sql_create_table | ||
235 | |||
236 | TABLE_DEFINITION=( | ||
237 | niro | 8548 | "client_locations" |
238 | niro | 8485 | "location varchar(255) NOT NULL PRIMARY KEY" |
239 | niro | 8740 | "bootserver varchar(255) NOT NULL" |
240 | niro | 8485 | "controlserver varchar(255) NOT NULL" |
241 | "pxe_default_entry varchar(255) NOT NULL" | ||
242 | "pxe_prompt tinyint(1) NOT NULL" | ||
243 | "pxe_timeout smallint(1) NOT NULL" | ||
244 | "updateserver varchar(255) NOT NULL" | ||
245 | "username varchar(255) NOT NULL" | ||
246 | "password varchar(255) NOT NULL" | ||
247 | "rsync varchar(255) NOT NULL" | ||
248 | "repository varchar(255) NOT NULL" | ||
249 | "helpdesk_unit varchar(255) NOT NULL" | ||
250 | "helpdesk_phone varchar(255) NOT NULL" | ||
251 | "set_default tinyint(1) NOT NULL DEFAULT '0'" | ||
252 | "enabled tinyint(1) NOT NULL DEFAULT '1'" | ||
253 | ) | ||
254 | sql_create_table | ||
255 | |||
256 | TABLE_DEFINITION=( | ||
257 | "client_serials" | ||
258 | niro | 9464 | "serial int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" |
259 | niro | 8485 | "location varchar(255) NOT NULL" |
260 | "mtime int(11) DEFAULT NULL" | ||
261 | "mac varchar(17) NOT NULL" | ||
262 | "hwdetected tinyint(1) NOT NULL DEFAULT '0'" | ||
263 | "enabled tinyint(1) NOT NULL DEFAULT '1'" | ||
264 | ) | ||
265 | sql_create_table | ||
266 | |||
267 | TABLE_DEFINITION=( | ||
268 | "client_version" | ||
269 | "serial int(11) NOT NULL PRIMARY KEY" | ||
270 | "os varchar(50) NOT NULL" | ||
271 | "utils varchar(50) NOT NULL" | ||
272 | niro | 10646 | "arch varchar(50) NOT NULL" |
273 | niro | 8485 | ) |
274 | sql_create_table | ||
275 | |||
276 | TABLE_DEFINITION=( | ||
277 | "state_connected" | ||
278 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" | ||
279 | "mtime int(11) DEFAULT NULL" | ||
280 | "serial int(11) NOT NULL" | ||
281 | "ip varchar(255) DEFAULT NULL" | ||
282 | "mac varchar(255) DEFAULT NULL" | ||
283 | "netboot tinyint(1) NOT NULL DEFAULT '0'" | ||
284 | ) | ||
285 | sql_create_table | ||
286 | |||
287 | TABLE_DEFINITION=( | ||
288 | "values_storefront_store" | ||
289 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" | ||
290 | "name varchar(255) NOT NULL" | ||
291 | "store varchar(255) NOT NULL" | ||
292 | "user varchar(255) DEFAULT NULL" | ||
293 | "password varchar(255) DEFAULT NULL" | ||
294 | "domain varchar(255) DEFAULT NULL" | ||
295 | "enabled tinyint(1) NOT NULL DEFAULT '1'" | ||
296 | ) | ||
297 | sql_create_table | ||
298 | |||
299 | TABLE_DEFINITION=( | ||
300 | "values_citrix_session" | ||
301 | "id int(255) NOT NULL PRIMARY KEY AUTO_INCREMENT" | ||
302 | "session varchar(255) NOT NULL" | ||
303 | "description varchar(255) DEFAULT NULL" | ||
304 | "enabled tinyint(1) NOT NULL DEFAULT '1'" | ||
305 | ) | ||
306 | sql_create_table | ||
307 | |||
308 | TABLE_DEFINITION=( | ||
309 | "values_graphic_depth" | ||
310 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" | ||
311 | "value varchar(255) NOT NULL" | ||
312 | "enabled tinyint(1) NOT NULL DEFAULT '1'" | ||
313 | ) | ||
314 | sql_create_table | ||
315 | |||
316 | TABLE_DEFINITION=( | ||
317 | "values_graphic_module" | ||
318 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" | ||
319 | "value varchar(255) NOT NULL" | ||
320 | "enabled tinyint(1) NOT NULL DEFAULT '1'" | ||
321 | ) | ||
322 | sql_create_table | ||
323 | |||
324 | TABLE_DEFINITION=( | ||
325 | "values_graphic_refresh_rate" | ||
326 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" | ||
327 | "value varchar(255) NOT NULL" | ||
328 | "enabled tinyint(1) NOT NULL DEFAULT '1'" | ||
329 | ) | ||
330 | sql_create_table | ||
331 | |||
332 | TABLE_DEFINITION=( | ||
333 | "values_graphic_resolution" | ||
334 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" | ||
335 | "value varchar(255) NOT NULL" | ||
336 | "enabled tinyint(1) NOT NULL DEFAULT '1'" | ||
337 | ) | ||
338 | sql_create_table | ||
339 | |||
340 | TABLE_DEFINITION=( | ||
341 | "values_input_keymap" | ||
342 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" | ||
343 | "value varchar(255) NOT NULL" | ||
344 | "enabled tinyint(1) NOT NULL DEFAULT '1'" | ||
345 | ) | ||
346 | sql_create_table | ||
347 | |||
348 | TABLE_DEFINITION=( | ||
349 | "values_network_module" | ||
350 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" | ||
351 | "value varchar(255) NOT NULL" | ||
352 | "enabled tinyint(1) NOT NULL DEFAULT '1'" | ||
353 | niro | 10646 | "description varchar(255) DEFAULT NULL" |
354 | niro | 8485 | ) |
355 | sql_create_table | ||
356 | |||
357 | TABLE_DEFINITION=( | ||
358 | niro | 8515 | "values_network_wireless_auth_mode" |
359 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" | ||
360 | "value varchar(255) NOT NULL" | ||
361 | "enabled tinyint(1) NOT NULL DEFAULT '1'" | ||
362 | ) | ||
363 | sql_create_table | ||
364 | |||
365 | TABLE_DEFINITION=( | ||
366 | niro | 8521 | "values_network_wireless_bitrate" |
367 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" | ||
368 | "value varchar(255) NOT NULL" | ||
369 | "enabled tinyint(1) NOT NULL DEFAULT '1'" | ||
370 | ) | ||
371 | sql_create_table | ||
372 | |||
373 | TABLE_DEFINITION=( | ||
374 | niro | 8518 | "values_network_wireless_channel" |
375 | niro | 8515 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" |
376 | "value varchar(255) NOT NULL" | ||
377 | "enabled tinyint(1) NOT NULL DEFAULT '1'" | ||
378 | ) | ||
379 | sql_create_table | ||
380 | |||
381 | TABLE_DEFINITION=( | ||
382 | "values_network_wireless_frequency" | ||
383 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" | ||
384 | "value varchar(255) NOT NULL" | ||
385 | "enabled tinyint(1) NOT NULL DEFAULT '1'" | ||
386 | ) | ||
387 | sql_create_table | ||
388 | |||
389 | TABLE_DEFINITION=( | ||
390 | niro | 8518 | "values_network_wireless_key_length" |
391 | niro | 8515 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" |
392 | "value varchar(255) NOT NULL" | ||
393 | "enabled tinyint(1) NOT NULL DEFAULT '1'" | ||
394 | ) | ||
395 | sql_create_table | ||
396 | |||
397 | TABLE_DEFINITION=( | ||
398 | "values_network_wireless_mode" | ||
399 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" | ||
400 | "value varchar(255) NOT NULL" | ||
401 | "enabled tinyint(1) NOT NULL DEFAULT '1'" | ||
402 | ) | ||
403 | sql_create_table | ||
404 | |||
405 | TABLE_DEFINITION=( | ||
406 | niro | 8485 | "values_printers_port" |
407 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" | ||
408 | "value varchar(255) NOT NULL" | ||
409 | "enabled tinyint(1) NOT NULL DEFAULT '1'" | ||
410 | ) | ||
411 | sql_create_table | ||
412 | |||
413 | TABLE_DEFINITION=( | ||
414 | "values_screensaver_screensaver" | ||
415 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" | ||
416 | "value varchar(255) NOT NULL" | ||
417 | "enabled tinyint(1) NOT NULL DEFAULT '1'" | ||
418 | ) | ||
419 | sql_create_table | ||
420 | |||
421 | TABLE_DEFINITION=( | ||
422 | "values_storefront_session" | ||
423 | "id int(255) NOT NULL PRIMARY KEY AUTO_INCREMENT" | ||
424 | "session varchar(255) NOT NULL" | ||
425 | "description varchar(255) DEFAULT NULL" | ||
426 | "store varchar(255) NOT NULL" | ||
427 | "enabled tinyint(1) NOT NULL DEFAULT '1'" | ||
428 | ) | ||
429 | sql_create_table | ||
430 | niro | 9463 | |
431 | TABLE_DEFINITION=( | ||
432 | "client_boot" | ||
433 | "serial int(255) NOT NULL PRIMARY KEY" | ||
434 | "cmdline varchar(255) DEFAULT NULL" | ||
435 | ) | ||
436 | sql_create_table | ||
437 | niro | 8485 | } |