Annotation of /alx-src/branches/alx-web-070/scripts/sql-schema/include/schema.sh
Parent Directory | Revision Log
Revision 13670 -
(hide annotations)
(download)
(as text)
Thu Jul 25 14:21:41 2019 UTC (4 years, 9 months ago) by niro
File MIME type: application/x-sh
File size: 11772 byte(s)
Thu Jul 25 14:21:41 2019 UTC (4 years, 9 months ago) by niro
File MIME type: application/x-sh
File size: 11772 byte(s)
-update database schema to version 14, added column 'dpms' to cfg_screensaver
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 | 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 | "name varchar(255) NOT NULL" | ||
166 | "session varchar(255) NOT 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) NOT 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 | "name varchar(255) NOT NULL" | ||
183 | "server varchar(255) NOT 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 | 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 | "name varchar(255) NOT NULL" | ||
200 | "session varchar(255) NOT 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) NOT 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 | "store varchar(255) NOT 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 | niro | 8548 | "client_locations" |
239 | niro | 8485 | "location varchar(255) NOT NULL PRIMARY KEY" |
240 | niro | 8740 | "bootserver varchar(255) NOT NULL" |
241 | niro | 8485 | "controlserver varchar(255) NOT NULL" |
242 | "pxe_default_entry varchar(255) NOT NULL" | ||
243 | "pxe_prompt tinyint(1) NOT NULL" | ||
244 | "pxe_timeout smallint(1) NOT NULL" | ||
245 | "updateserver varchar(255) NOT NULL" | ||
246 | "username varchar(255) NOT NULL" | ||
247 | "password varchar(255) NOT NULL" | ||
248 | "rsync varchar(255) NOT NULL" | ||
249 | "repository varchar(255) NOT NULL" | ||
250 | "helpdesk_unit varchar(255) NOT NULL" | ||
251 | "helpdesk_phone varchar(255) NOT NULL" | ||
252 | "set_default tinyint(1) NOT NULL DEFAULT '0'" | ||
253 | "enabled tinyint(1) NOT NULL DEFAULT '1'" | ||
254 | ) | ||
255 | sql_create_table | ||
256 | |||
257 | TABLE_DEFINITION=( | ||
258 | "client_serials" | ||
259 | niro | 9464 | "serial int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" |
260 | niro | 8485 | "location varchar(255) NOT NULL" |
261 | "mtime int(11) DEFAULT NULL" | ||
262 | "mac varchar(17) NOT NULL" | ||
263 | "hwdetected tinyint(1) NOT NULL DEFAULT '0'" | ||
264 | "enabled tinyint(1) NOT NULL DEFAULT '1'" | ||
265 | ) | ||
266 | sql_create_table | ||
267 | |||
268 | TABLE_DEFINITION=( | ||
269 | "client_version" | ||
270 | "serial int(11) NOT NULL PRIMARY KEY" | ||
271 | "os varchar(50) NOT NULL" | ||
272 | "utils varchar(50) NOT NULL" | ||
273 | niro | 10646 | "arch varchar(50) NOT NULL" |
274 | niro | 8485 | ) |
275 | sql_create_table | ||
276 | |||
277 | TABLE_DEFINITION=( | ||
278 | "state_connected" | ||
279 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" | ||
280 | "mtime int(11) DEFAULT NULL" | ||
281 | "serial int(11) NOT NULL" | ||
282 | "ip varchar(255) DEFAULT NULL" | ||
283 | "mac varchar(255) DEFAULT NULL" | ||
284 | "netboot tinyint(1) NOT NULL DEFAULT '0'" | ||
285 | ) | ||
286 | sql_create_table | ||
287 | |||
288 | TABLE_DEFINITION=( | ||
289 | "values_storefront_store" | ||
290 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" | ||
291 | "name varchar(255) NOT NULL" | ||
292 | "store varchar(255) NOT NULL" | ||
293 | "user varchar(255) DEFAULT NULL" | ||
294 | "password varchar(255) DEFAULT NULL" | ||
295 | "domain varchar(255) DEFAULT NULL" | ||
296 | "enabled tinyint(1) NOT NULL DEFAULT '1'" | ||
297 | ) | ||
298 | sql_create_table | ||
299 | |||
300 | TABLE_DEFINITION=( | ||
301 | "values_citrix_session" | ||
302 | "id int(255) NOT NULL PRIMARY KEY AUTO_INCREMENT" | ||
303 | "session varchar(255) NOT NULL" | ||
304 | "description varchar(255) DEFAULT NULL" | ||
305 | "enabled tinyint(1) NOT NULL DEFAULT '1'" | ||
306 | ) | ||
307 | sql_create_table | ||
308 | |||
309 | TABLE_DEFINITION=( | ||
310 | "values_graphic_depth" | ||
311 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" | ||
312 | "value varchar(255) NOT NULL" | ||
313 | "enabled tinyint(1) NOT NULL DEFAULT '1'" | ||
314 | ) | ||
315 | sql_create_table | ||
316 | |||
317 | TABLE_DEFINITION=( | ||
318 | "values_graphic_module" | ||
319 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" | ||
320 | "value varchar(255) NOT NULL" | ||
321 | "enabled tinyint(1) NOT NULL DEFAULT '1'" | ||
322 | ) | ||
323 | sql_create_table | ||
324 | |||
325 | TABLE_DEFINITION=( | ||
326 | "values_graphic_refresh_rate" | ||
327 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" | ||
328 | "value varchar(255) NOT NULL" | ||
329 | "enabled tinyint(1) NOT NULL DEFAULT '1'" | ||
330 | ) | ||
331 | sql_create_table | ||
332 | |||
333 | TABLE_DEFINITION=( | ||
334 | "values_graphic_resolution" | ||
335 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" | ||
336 | "value varchar(255) NOT NULL" | ||
337 | "enabled tinyint(1) NOT NULL DEFAULT '1'" | ||
338 | ) | ||
339 | sql_create_table | ||
340 | |||
341 | TABLE_DEFINITION=( | ||
342 | "values_input_keymap" | ||
343 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" | ||
344 | "value varchar(255) NOT NULL" | ||
345 | "enabled tinyint(1) NOT NULL DEFAULT '1'" | ||
346 | ) | ||
347 | sql_create_table | ||
348 | |||
349 | TABLE_DEFINITION=( | ||
350 | "values_network_module" | ||
351 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" | ||
352 | "value varchar(255) NOT NULL" | ||
353 | "enabled tinyint(1) NOT NULL DEFAULT '1'" | ||
354 | niro | 10646 | "description varchar(255) DEFAULT NULL" |
355 | niro | 8485 | ) |
356 | sql_create_table | ||
357 | |||
358 | TABLE_DEFINITION=( | ||
359 | niro | 8515 | "values_network_wireless_auth_mode" |
360 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" | ||
361 | "value varchar(255) NOT NULL" | ||
362 | "enabled tinyint(1) NOT NULL DEFAULT '1'" | ||
363 | ) | ||
364 | sql_create_table | ||
365 | |||
366 | TABLE_DEFINITION=( | ||
367 | niro | 8521 | "values_network_wireless_bitrate" |
368 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" | ||
369 | "value varchar(255) NOT NULL" | ||
370 | "enabled tinyint(1) NOT NULL DEFAULT '1'" | ||
371 | ) | ||
372 | sql_create_table | ||
373 | |||
374 | TABLE_DEFINITION=( | ||
375 | niro | 8518 | "values_network_wireless_channel" |
376 | niro | 8515 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" |
377 | "value varchar(255) NOT NULL" | ||
378 | "enabled tinyint(1) NOT NULL DEFAULT '1'" | ||
379 | ) | ||
380 | sql_create_table | ||
381 | |||
382 | TABLE_DEFINITION=( | ||
383 | "values_network_wireless_frequency" | ||
384 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" | ||
385 | "value varchar(255) NOT NULL" | ||
386 | "enabled tinyint(1) NOT NULL DEFAULT '1'" | ||
387 | ) | ||
388 | sql_create_table | ||
389 | |||
390 | TABLE_DEFINITION=( | ||
391 | niro | 8518 | "values_network_wireless_key_length" |
392 | niro | 8515 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" |
393 | "value varchar(255) NOT NULL" | ||
394 | "enabled tinyint(1) NOT NULL DEFAULT '1'" | ||
395 | ) | ||
396 | sql_create_table | ||
397 | |||
398 | TABLE_DEFINITION=( | ||
399 | "values_network_wireless_mode" | ||
400 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" | ||
401 | "value varchar(255) NOT NULL" | ||
402 | "enabled tinyint(1) NOT NULL DEFAULT '1'" | ||
403 | ) | ||
404 | sql_create_table | ||
405 | |||
406 | TABLE_DEFINITION=( | ||
407 | niro | 8485 | "values_printers_port" |
408 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" | ||
409 | "value varchar(255) NOT NULL" | ||
410 | "enabled tinyint(1) NOT NULL DEFAULT '1'" | ||
411 | ) | ||
412 | sql_create_table | ||
413 | |||
414 | TABLE_DEFINITION=( | ||
415 | "values_screensaver_screensaver" | ||
416 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" | ||
417 | "value varchar(255) NOT NULL" | ||
418 | "enabled tinyint(1) NOT NULL DEFAULT '1'" | ||
419 | ) | ||
420 | sql_create_table | ||
421 | |||
422 | TABLE_DEFINITION=( | ||
423 | "values_storefront_session" | ||
424 | "id int(255) NOT NULL PRIMARY KEY AUTO_INCREMENT" | ||
425 | "session varchar(255) NOT NULL" | ||
426 | "description varchar(255) DEFAULT NULL" | ||
427 | "store varchar(255) NOT NULL" | ||
428 | "enabled tinyint(1) NOT NULL DEFAULT '1'" | ||
429 | ) | ||
430 | sql_create_table | ||
431 | niro | 9463 | |
432 | TABLE_DEFINITION=( | ||
433 | "client_boot" | ||
434 | "serial int(255) NOT NULL PRIMARY KEY" | ||
435 | "cmdline varchar(255) DEFAULT NULL" | ||
436 | ) | ||
437 | sql_create_table | ||
438 | niro | 8485 | } |