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 8518 - (hide annotations) (download) (as text)
Mon Feb 8 09:41:29 2016 UTC (8 years, 3 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     }