Contents of /alx-src/branches/alx-web-070/scripts/sql-schema/include/schema.sh
Parent Directory | Revision Log
Revision 9473 -
(show annotations)
(download)
(as text)
Thu Apr 6 13:57:45 2017 UTC (7 years, 2 months ago) by niro
File MIME type: application/x-sh
File size: 11666 byte(s)
Thu Apr 6 13:57:45 2017 UTC (7 years, 2 months ago) by niro
File MIME type: application/x-sh
File size: 11666 byte(s)
-fixed broken update
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) 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 | "autostart tinyint(1) NOT NULL DEFAULT '1'" |
171 | "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 | "autostart tinyint(1) NOT NULL DEFAULT '1'" |
188 | "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 | "autostart tinyint(1) NOT NULL DEFAULT '1'" |
205 | "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 | "client_locations" |
237 | "location varchar(255) NOT NULL PRIMARY KEY" |
238 | "bootserver varchar(255) NOT NULL" |
239 | "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 | "serial int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" |
258 | "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 | ) |
272 | sql_create_table |
273 | |
274 | TABLE_DEFINITION=( |
275 | "state_connected" |
276 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" |
277 | "mtime int(11) DEFAULT NULL" |
278 | "serial int(11) NOT NULL" |
279 | "ip varchar(255) DEFAULT NULL" |
280 | "mac varchar(255) DEFAULT NULL" |
281 | "netboot tinyint(1) NOT NULL DEFAULT '0'" |
282 | ) |
283 | sql_create_table |
284 | |
285 | TABLE_DEFINITION=( |
286 | "values_storefront_store" |
287 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" |
288 | "name varchar(255) NOT NULL" |
289 | "store varchar(255) NOT NULL" |
290 | "user varchar(255) DEFAULT NULL" |
291 | "password varchar(255) DEFAULT NULL" |
292 | "domain varchar(255) DEFAULT NULL" |
293 | "enabled tinyint(1) NOT NULL DEFAULT '1'" |
294 | ) |
295 | sql_create_table |
296 | |
297 | TABLE_DEFINITION=( |
298 | "values_citrix_session" |
299 | "id int(255) NOT NULL PRIMARY KEY AUTO_INCREMENT" |
300 | "session varchar(255) NOT NULL" |
301 | "description varchar(255) DEFAULT NULL" |
302 | "enabled tinyint(1) NOT NULL DEFAULT '1'" |
303 | ) |
304 | sql_create_table |
305 | |
306 | TABLE_DEFINITION=( |
307 | "values_graphic_depth" |
308 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" |
309 | "value varchar(255) NOT NULL" |
310 | "enabled tinyint(1) NOT NULL DEFAULT '1'" |
311 | ) |
312 | sql_create_table |
313 | |
314 | TABLE_DEFINITION=( |
315 | "values_graphic_module" |
316 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" |
317 | "value varchar(255) NOT NULL" |
318 | "enabled tinyint(1) NOT NULL DEFAULT '1'" |
319 | ) |
320 | sql_create_table |
321 | |
322 | TABLE_DEFINITION=( |
323 | "values_graphic_refresh_rate" |
324 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" |
325 | "value varchar(255) NOT NULL" |
326 | "enabled tinyint(1) NOT NULL DEFAULT '1'" |
327 | ) |
328 | sql_create_table |
329 | |
330 | TABLE_DEFINITION=( |
331 | "values_graphic_resolution" |
332 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" |
333 | "value varchar(255) NOT NULL" |
334 | "enabled tinyint(1) NOT NULL DEFAULT '1'" |
335 | ) |
336 | sql_create_table |
337 | |
338 | TABLE_DEFINITION=( |
339 | "values_input_keymap" |
340 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" |
341 | "value varchar(255) NOT NULL" |
342 | "enabled tinyint(1) NOT NULL DEFAULT '1'" |
343 | ) |
344 | sql_create_table |
345 | |
346 | TABLE_DEFINITION=( |
347 | "values_network_module" |
348 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" |
349 | "value varchar(255) NOT NULL" |
350 | "enabled tinyint(1) NOT NULL DEFAULT '1'" |
351 | "description varchar(255) DEFAULT NULL AFTER value" |
352 | ) |
353 | sql_create_table |
354 | |
355 | TABLE_DEFINITION=( |
356 | "values_network_wireless_auth_mode" |
357 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" |
358 | "value varchar(255) NOT NULL" |
359 | "enabled tinyint(1) NOT NULL DEFAULT '1'" |
360 | ) |
361 | sql_create_table |
362 | |
363 | TABLE_DEFINITION=( |
364 | "values_network_wireless_bitrate" |
365 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" |
366 | "value varchar(255) NOT NULL" |
367 | "enabled tinyint(1) NOT NULL DEFAULT '1'" |
368 | ) |
369 | sql_create_table |
370 | |
371 | TABLE_DEFINITION=( |
372 | "values_network_wireless_channel" |
373 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" |
374 | "value varchar(255) NOT NULL" |
375 | "enabled tinyint(1) NOT NULL DEFAULT '1'" |
376 | ) |
377 | sql_create_table |
378 | |
379 | TABLE_DEFINITION=( |
380 | "values_network_wireless_frequency" |
381 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" |
382 | "value varchar(255) NOT NULL" |
383 | "enabled tinyint(1) NOT NULL DEFAULT '1'" |
384 | ) |
385 | sql_create_table |
386 | |
387 | TABLE_DEFINITION=( |
388 | "values_network_wireless_key_length" |
389 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" |
390 | "value varchar(255) NOT NULL" |
391 | "enabled tinyint(1) NOT NULL DEFAULT '1'" |
392 | ) |
393 | sql_create_table |
394 | |
395 | TABLE_DEFINITION=( |
396 | "values_network_wireless_mode" |
397 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" |
398 | "value varchar(255) NOT NULL" |
399 | "enabled tinyint(1) NOT NULL DEFAULT '1'" |
400 | ) |
401 | sql_create_table |
402 | |
403 | TABLE_DEFINITION=( |
404 | "values_printers_port" |
405 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" |
406 | "value varchar(255) NOT NULL" |
407 | "enabled tinyint(1) NOT NULL DEFAULT '1'" |
408 | ) |
409 | sql_create_table |
410 | |
411 | TABLE_DEFINITION=( |
412 | "values_screensaver_screensaver" |
413 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" |
414 | "value varchar(255) NOT NULL" |
415 | "enabled tinyint(1) NOT NULL DEFAULT '1'" |
416 | ) |
417 | sql_create_table |
418 | |
419 | TABLE_DEFINITION=( |
420 | "values_storefront_session" |
421 | "id int(255) NOT NULL PRIMARY KEY AUTO_INCREMENT" |
422 | "session varchar(255) NOT NULL" |
423 | "description varchar(255) DEFAULT NULL" |
424 | "store varchar(255) NOT NULL" |
425 | "enabled tinyint(1) NOT NULL DEFAULT '1'" |
426 | ) |
427 | sql_create_table |
428 | |
429 | TABLE_DEFINITION=( |
430 | "client_boot" |
431 | "serial int(255) NOT NULL PRIMARY KEY" |
432 | "cmdline varchar(255) DEFAULT NULL" |
433 | ) |
434 | sql_create_table |
435 | } |