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 13666 - (hide annotations) (download) (as text)
Thu Jul 25 12:55:42 2019 UTC (4 years, 9 months ago) by niro
File MIME type: application/x-sh
File size: 11730 byte(s)
-update database schema to version 13, added column enabled to cfg_fluxbox_autostart
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 niro 13666 "enabled tinyint(1) NOT NULL DEFAULT '1'"
40 niro 8485 )
41     sql_create_table
42    
43     TABLE_DEFINITION=(
44     "cfg_fluxbox_menuitem"
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     "workdir varchar(255) DEFAULT NULL"
50     "icon varchar(255) DEFAULT NULL"
51     "enabled tinyint(1) NOT NULL DEFAULT '1'"
52     )
53     sql_create_table
54    
55     TABLE_DEFINITION=(
56     "cfg_fluxbox_theme"
57     "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
58     "serial int(11) NOT NULL"
59     "theme varchar(255) NOT NULL"
60     )
61     sql_create_table
62    
63     TABLE_DEFINITION=(
64     "cfg_graphic"
65     "serial int(11) NOT NULL PRIMARY KEY"
66     "resolution varchar(255) DEFAULT NULL"
67     "depth varchar(288) DEFAULT NULL"
68     "monitorid int(11) DEFAULT NULL"
69     "refresh_rate int(3) NOT NULL DEFAULT '60'"
70     "module varchar(255) DEFAULT NULL"
71     "hdmi varchar(10) NOT NULL DEFAULT 'disable'"
72     )
73     sql_create_table
74    
75     TABLE_DEFINITION=(
76     "cfg_idesk_icon"
77     "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
78     "serial int(11) NOT NULL"
79     "name varchar(255) NOT NULL"
80     "command varchar(255) NOT NULL"
81     "icon varchar(255) NOT NULL"
82     "filename varchar(255) NOT NULL"
83     "xpos varchar(255) NOT NULL"
84     "ypos varchar(255) NOT NULL"
85     "width varchar(255) NOT NULL"
86     "height varchar(255) NOT NULL"
87     "default_icon varchar(255) NOT NULL"
88     "enabled tinyint(1) NOT NULL DEFAULT '1'"
89     )
90     sql_create_table
91    
92     TABLE_DEFINITION=(
93     "cfg_input"
94     "serial int(11) NOT NULL PRIMARY KEY"
95     "keymap varchar(255) DEFAULT NULL"
96     )
97     sql_create_table
98    
99     TABLE_DEFINITION=(
100     "cfg_modules"
101     "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
102     "serial int(11) NOT NULL"
103     "module varchar(255) DEFAULT NULL"
104     "arg varchar(255) DEFAULT NULL"
105     )
106     sql_create_table
107    
108     TABLE_DEFINITION=(
109     "cfg_network"
110     "serial int(11) NOT NULL PRIMARY KEY"
111     "hostname varchar(255) DEFAULT NULL"
112     "domain varchar(255) DEFAULT NULL"
113     "networking varchar(255) DEFAULT NULL"
114     "netmask varchar(255) DEFAULT NULL"
115     "dns varchar(255) DEFAULT NULL"
116     "gateway varchar(255) DEFAULT NULL"
117     "broadcast varchar(255) DEFAULT NULL"
118     "ip varchar(255) DEFAULT NULL"
119     "module varchar(255) DEFAULT NULL"
120     "forcemacto varchar(17) DEFAULT NULL"
121     "wireless_bitrate varchar(5) DEFAULT NULL"
122     "wireless_channel varchar(10) DEFAULT NULL"
123     "wireless_essid varchar(255) DEFAULT NULL"
124     "wireless_frequency varchar(255) DEFAULT NULL"
125     "wireless_mode varchar(255) DEFAULT NULL"
126     "wireless_nick varchar(255) DEFAULT NULL"
127     "wireless_auth_mode varchar(255) DEFAULT NULL"
128     "wireless_key_length varchar(255) DEFAULT NULL"
129     "wireless_key text"
130     "wireless_key_ascii text"
131     )
132     sql_create_table
133    
134     TABLE_DEFINITION=(
135     "cfg_printers"
136     "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
137     "serial int(11) NOT NULL"
138     "printer_name varchar(255) NOT NULL"
139     "port varchar(255) NOT NULL"
140     "enabled tinyint(1) NOT NULL DEFAULT '1'"
141     )
142     sql_create_table
143    
144     TABLE_DEFINITION=(
145     "cfg_scm_egk"
146     "serial int(11) NOT NULL PRIMARY KEY"
147     "facility tinyint(1) NOT NULL DEFAULT '1'"
148     )
149     sql_create_table
150    
151     TABLE_DEFINITION=(
152     "cfg_screensaver"
153     "serial int(11) NOT NULL PRIMARY KEY"
154     "screensaver varchar(255) NOT NULL"
155     "timeout int(11) DEFAULT '10'"
156     "password varchar(255) DEFAULT NULL"
157     )
158     sql_create_table
159    
160     TABLE_DEFINITION=(
161     "cfg_sessions_citrix"
162     "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
163     "serial int(11) NOT NULL"
164     "name varchar(255) NOT NULL"
165     "session varchar(255) NOT NULL"
166     "filename varchar(255) DEFAULT NULL"
167     "username varchar(255) DEFAULT NULL"
168     "domain varchar(255) DEFAULT NULL"
169     "password varchar(255) DEFAULT NULL"
170     "serverlist varchar(255) NOT NULL"
171 niro 8573 "autostart tinyint(1) NOT NULL DEFAULT '1'"
172 niro 8485 "enabled tinyint(1) NOT NULL DEFAULT '1'"
173     "flg_modified tinyint(1) NOT NULL DEFAULT '0'"
174     )
175     sql_create_table
176    
177     TABLE_DEFINITION=(
178     "cfg_sessions_rdesktop"
179     "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
180     "serial int(11) NOT NULL"
181     "name varchar(255) NOT NULL"
182     "server varchar(255) NOT NULL"
183     "filename varchar(255) DEFAULT NULL"
184     "username varchar(255) DEFAULT NULL"
185     "password varchar(255) DEFAULT NULL"
186     "domain varchar(255) DEFAULT NULL"
187     "shell varchar(255) DEFAULT NULL"
188 niro 8573 "autostart tinyint(1) NOT NULL DEFAULT '1'"
189 niro 8485 "enabled tinyint(1) NOT NULL DEFAULT '1'"
190     "flg_modified tinyint(1) NOT NULL DEFAULT '0'"
191     )
192     sql_create_table
193    
194     TABLE_DEFINITION=(
195     "cfg_sessions_storefront"
196     "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
197     "serial int(11) NOT NULL"
198     "name varchar(255) NOT NULL"
199     "session varchar(255) NOT NULL"
200     "filename varchar(255) DEFAULT NULL"
201     "username varchar(255) DEFAULT NULL"
202     "domain varchar(255) DEFAULT NULL"
203     "password varchar(255) DEFAULT NULL"
204     "store varchar(255) NOT NULL"
205 niro 8573 "autostart tinyint(1) NOT NULL DEFAULT '1'"
206 niro 8485 "enabled tinyint(1) NOT NULL DEFAULT '1'"
207     "flg_modified tinyint(1) NOT NULL DEFAULT '0'"
208     )
209     sql_create_table
210    
211     TABLE_DEFINITION=(
212     "cfg_storefront_store"
213     "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
214     "serial int(11) NOT NULL"
215     "store varchar(255) NOT NULL"
216     "enabled tinyint(1) NOT NULL DEFAULT '1'"
217     )
218     sql_create_table
219    
220     TABLE_DEFINITION=(
221     "cfg_vnc"
222     "serial int(11) NOT NULL PRIMARY KEY"
223     "service tinyint(1) NOT NULL DEFAULT '1'"
224     )
225     sql_create_table
226    
227     TABLE_DEFINITION=(
228     "client_auth"
229     "serial int(11) NOT NULL PRIMARY KEY"
230     "user varchar(255) DEFAULT NULL"
231     "root varchar(255) DEFAULT NULL"
232     "vnc varchar(255) DEFAULT NULL"
233     )
234     sql_create_table
235    
236     TABLE_DEFINITION=(
237 niro 8548 "client_locations"
238 niro 8485 "location varchar(255) NOT NULL PRIMARY KEY"
239 niro 8740 "bootserver varchar(255) NOT NULL"
240 niro 8485 "controlserver varchar(255) NOT NULL"
241     "pxe_default_entry varchar(255) NOT NULL"
242     "pxe_prompt tinyint(1) NOT NULL"
243     "pxe_timeout smallint(1) NOT NULL"
244     "updateserver varchar(255) NOT NULL"
245     "username varchar(255) NOT NULL"
246     "password varchar(255) NOT NULL"
247     "rsync varchar(255) NOT NULL"
248     "repository varchar(255) NOT NULL"
249     "helpdesk_unit varchar(255) NOT NULL"
250     "helpdesk_phone varchar(255) NOT NULL"
251     "set_default tinyint(1) NOT NULL DEFAULT '0'"
252     "enabled tinyint(1) NOT NULL DEFAULT '1'"
253     )
254     sql_create_table
255    
256     TABLE_DEFINITION=(
257     "client_serials"
258 niro 9464 "serial int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
259 niro 8485 "location varchar(255) NOT NULL"
260     "mtime int(11) DEFAULT NULL"
261     "mac varchar(17) NOT NULL"
262     "hwdetected tinyint(1) NOT NULL DEFAULT '0'"
263     "enabled tinyint(1) NOT NULL DEFAULT '1'"
264     )
265     sql_create_table
266    
267     TABLE_DEFINITION=(
268     "client_version"
269     "serial int(11) NOT NULL PRIMARY KEY"
270     "os varchar(50) NOT NULL"
271     "utils varchar(50) NOT NULL"
272 niro 10646 "arch varchar(50) NOT NULL"
273 niro 8485 )
274     sql_create_table
275    
276     TABLE_DEFINITION=(
277     "state_connected"
278     "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
279     "mtime int(11) DEFAULT NULL"
280     "serial int(11) NOT NULL"
281     "ip varchar(255) DEFAULT NULL"
282     "mac varchar(255) DEFAULT NULL"
283     "netboot tinyint(1) NOT NULL DEFAULT '0'"
284     )
285     sql_create_table
286    
287     TABLE_DEFINITION=(
288     "values_storefront_store"
289     "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
290     "name varchar(255) NOT NULL"
291     "store varchar(255) NOT NULL"
292     "user varchar(255) DEFAULT NULL"
293     "password varchar(255) DEFAULT NULL"
294     "domain varchar(255) DEFAULT NULL"
295     "enabled tinyint(1) NOT NULL DEFAULT '1'"
296     )
297     sql_create_table
298    
299     TABLE_DEFINITION=(
300     "values_citrix_session"
301     "id int(255) NOT NULL PRIMARY KEY AUTO_INCREMENT"
302     "session varchar(255) NOT NULL"
303     "description varchar(255) DEFAULT NULL"
304     "enabled tinyint(1) NOT NULL DEFAULT '1'"
305     )
306     sql_create_table
307    
308     TABLE_DEFINITION=(
309     "values_graphic_depth"
310     "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
311     "value varchar(255) NOT NULL"
312     "enabled tinyint(1) NOT NULL DEFAULT '1'"
313     )
314     sql_create_table
315    
316     TABLE_DEFINITION=(
317     "values_graphic_module"
318     "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
319     "value varchar(255) NOT NULL"
320     "enabled tinyint(1) NOT NULL DEFAULT '1'"
321     )
322     sql_create_table
323    
324     TABLE_DEFINITION=(
325     "values_graphic_refresh_rate"
326     "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
327     "value varchar(255) NOT NULL"
328     "enabled tinyint(1) NOT NULL DEFAULT '1'"
329     )
330     sql_create_table
331    
332     TABLE_DEFINITION=(
333     "values_graphic_resolution"
334     "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
335     "value varchar(255) NOT NULL"
336     "enabled tinyint(1) NOT NULL DEFAULT '1'"
337     )
338     sql_create_table
339    
340     TABLE_DEFINITION=(
341     "values_input_keymap"
342     "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
343     "value varchar(255) NOT NULL"
344     "enabled tinyint(1) NOT NULL DEFAULT '1'"
345     )
346     sql_create_table
347    
348     TABLE_DEFINITION=(
349     "values_network_module"
350     "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
351     "value varchar(255) NOT NULL"
352     "enabled tinyint(1) NOT NULL DEFAULT '1'"
353 niro 10646 "description varchar(255) DEFAULT NULL"
354 niro 8485 )
355     sql_create_table
356    
357     TABLE_DEFINITION=(
358 niro 8515 "values_network_wireless_auth_mode"
359     "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
360     "value varchar(255) NOT NULL"
361     "enabled tinyint(1) NOT NULL DEFAULT '1'"
362     )
363     sql_create_table
364    
365     TABLE_DEFINITION=(
366 niro 8521 "values_network_wireless_bitrate"
367     "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
368     "value varchar(255) NOT NULL"
369     "enabled tinyint(1) NOT NULL DEFAULT '1'"
370     )
371     sql_create_table
372    
373     TABLE_DEFINITION=(
374 niro 8518 "values_network_wireless_channel"
375 niro 8515 "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
376     "value varchar(255) NOT NULL"
377     "enabled tinyint(1) NOT NULL DEFAULT '1'"
378     )
379     sql_create_table
380    
381     TABLE_DEFINITION=(
382     "values_network_wireless_frequency"
383     "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
384     "value varchar(255) NOT NULL"
385     "enabled tinyint(1) NOT NULL DEFAULT '1'"
386     )
387     sql_create_table
388    
389     TABLE_DEFINITION=(
390 niro 8518 "values_network_wireless_key_length"
391 niro 8515 "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
392     "value varchar(255) NOT NULL"
393     "enabled tinyint(1) NOT NULL DEFAULT '1'"
394     )
395     sql_create_table
396    
397     TABLE_DEFINITION=(
398     "values_network_wireless_mode"
399     "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
400     "value varchar(255) NOT NULL"
401     "enabled tinyint(1) NOT NULL DEFAULT '1'"
402     )
403     sql_create_table
404    
405     TABLE_DEFINITION=(
406 niro 8485 "values_printers_port"
407     "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
408     "value varchar(255) NOT NULL"
409     "enabled tinyint(1) NOT NULL DEFAULT '1'"
410     )
411     sql_create_table
412    
413     TABLE_DEFINITION=(
414     "values_screensaver_screensaver"
415     "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
416     "value varchar(255) NOT NULL"
417     "enabled tinyint(1) NOT NULL DEFAULT '1'"
418     )
419     sql_create_table
420    
421     TABLE_DEFINITION=(
422     "values_storefront_session"
423     "id int(255) NOT NULL PRIMARY KEY AUTO_INCREMENT"
424     "session varchar(255) NOT NULL"
425     "description varchar(255) DEFAULT NULL"
426     "store varchar(255) NOT NULL"
427     "enabled tinyint(1) NOT NULL DEFAULT '1'"
428     )
429     sql_create_table
430 niro 9463
431     TABLE_DEFINITION=(
432     "client_boot"
433     "serial int(255) NOT NULL PRIMARY KEY"
434     "cmdline varchar(255) DEFAULT NULL"
435     )
436     sql_create_table
437 niro 8485 }