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