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