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 9473 - (hide annotations) (download) (as text)
Thu Apr 6 13:57:45 2017 UTC (7 years, 1 month ago) by niro
File MIME type: application/x-sh
File size: 11666 byte(s)
-fixed broken update
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     )
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 niro 9462 "description varchar(255) DEFAULT NULL AFTER value"
352 niro 8485 )
353     sql_create_table
354    
355     TABLE_DEFINITION=(
356 niro 8515 "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 niro 8521 "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 niro 8518 "values_network_wireless_channel"
373 niro 8515 "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 niro 8518 "values_network_wireless_key_length"
389 niro 8515 "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 niro 8485 "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 niro 9463
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 niro 8485 }