Magellan Linux

Annotation of /alx-src/branches/alx-web-070/scripts/sql-schema/include/schema.sh

Parent Directory Parent Directory | Revision Log 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)
-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 }