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