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 13670 - (hide annotations) (download) (as text)
Thu Jul 25 14:21:41 2019 UTC (4 years, 9 months ago) by niro
File MIME type: application/x-sh
File size: 11772 byte(s)
-update database schema to version 14, added column 'dpms' to cfg_screensaver
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 niro 13670 "dpms tinyint(1) NOT NULL DEFAULT '1'"
158 niro 8485 )
159     sql_create_table
160    
161     TABLE_DEFINITION=(
162     "cfg_sessions_citrix"
163     "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
164     "serial int(11) NOT NULL"
165     "name varchar(255) NOT NULL"
166     "session varchar(255) NOT NULL"
167     "filename varchar(255) DEFAULT NULL"
168     "username varchar(255) DEFAULT NULL"
169     "domain varchar(255) DEFAULT NULL"
170     "password varchar(255) DEFAULT NULL"
171     "serverlist varchar(255) NOT NULL"
172 niro 8573 "autostart tinyint(1) NOT NULL DEFAULT '1'"
173 niro 8485 "enabled tinyint(1) NOT NULL DEFAULT '1'"
174     "flg_modified tinyint(1) NOT NULL DEFAULT '0'"
175     )
176     sql_create_table
177    
178     TABLE_DEFINITION=(
179     "cfg_sessions_rdesktop"
180     "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
181     "serial int(11) NOT NULL"
182     "name varchar(255) NOT NULL"
183     "server varchar(255) NOT NULL"
184     "filename varchar(255) DEFAULT NULL"
185     "username varchar(255) DEFAULT NULL"
186     "password varchar(255) DEFAULT NULL"
187     "domain varchar(255) DEFAULT NULL"
188     "shell varchar(255) DEFAULT NULL"
189 niro 8573 "autostart tinyint(1) NOT NULL DEFAULT '1'"
190 niro 8485 "enabled tinyint(1) NOT NULL DEFAULT '1'"
191     "flg_modified tinyint(1) NOT NULL DEFAULT '0'"
192     )
193     sql_create_table
194    
195     TABLE_DEFINITION=(
196     "cfg_sessions_storefront"
197     "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
198     "serial int(11) NOT NULL"
199     "name varchar(255) NOT NULL"
200     "session varchar(255) NOT NULL"
201     "filename varchar(255) DEFAULT NULL"
202     "username varchar(255) DEFAULT NULL"
203     "domain varchar(255) DEFAULT NULL"
204     "password varchar(255) DEFAULT NULL"
205     "store varchar(255) NOT NULL"
206 niro 8573 "autostart tinyint(1) NOT NULL DEFAULT '1'"
207 niro 8485 "enabled tinyint(1) NOT NULL DEFAULT '1'"
208     "flg_modified tinyint(1) NOT NULL DEFAULT '0'"
209     )
210     sql_create_table
211    
212     TABLE_DEFINITION=(
213     "cfg_storefront_store"
214     "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
215     "serial int(11) NOT NULL"
216     "store varchar(255) NOT NULL"
217     "enabled tinyint(1) NOT NULL DEFAULT '1'"
218     )
219     sql_create_table
220    
221     TABLE_DEFINITION=(
222     "cfg_vnc"
223     "serial int(11) NOT NULL PRIMARY KEY"
224     "service tinyint(1) NOT NULL DEFAULT '1'"
225     )
226     sql_create_table
227    
228     TABLE_DEFINITION=(
229     "client_auth"
230     "serial int(11) NOT NULL PRIMARY KEY"
231     "user varchar(255) DEFAULT NULL"
232     "root varchar(255) DEFAULT NULL"
233     "vnc varchar(255) DEFAULT NULL"
234     )
235     sql_create_table
236    
237     TABLE_DEFINITION=(
238 niro 8548 "client_locations"
239 niro 8485 "location varchar(255) NOT NULL PRIMARY KEY"
240 niro 8740 "bootserver varchar(255) NOT NULL"
241 niro 8485 "controlserver varchar(255) NOT NULL"
242     "pxe_default_entry varchar(255) NOT NULL"
243     "pxe_prompt tinyint(1) NOT NULL"
244     "pxe_timeout smallint(1) NOT NULL"
245     "updateserver varchar(255) NOT NULL"
246     "username varchar(255) NOT NULL"
247     "password varchar(255) NOT NULL"
248     "rsync varchar(255) NOT NULL"
249     "repository varchar(255) NOT NULL"
250     "helpdesk_unit varchar(255) NOT NULL"
251     "helpdesk_phone varchar(255) NOT NULL"
252     "set_default tinyint(1) NOT NULL DEFAULT '0'"
253     "enabled tinyint(1) NOT NULL DEFAULT '1'"
254     )
255     sql_create_table
256    
257     TABLE_DEFINITION=(
258     "client_serials"
259 niro 9464 "serial int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
260 niro 8485 "location varchar(255) NOT NULL"
261     "mtime int(11) DEFAULT NULL"
262     "mac varchar(17) NOT NULL"
263     "hwdetected tinyint(1) NOT NULL DEFAULT '0'"
264     "enabled tinyint(1) NOT NULL DEFAULT '1'"
265     )
266     sql_create_table
267    
268     TABLE_DEFINITION=(
269     "client_version"
270     "serial int(11) NOT NULL PRIMARY KEY"
271     "os varchar(50) NOT NULL"
272     "utils varchar(50) NOT NULL"
273 niro 10646 "arch varchar(50) NOT NULL"
274 niro 8485 )
275     sql_create_table
276    
277     TABLE_DEFINITION=(
278     "state_connected"
279     "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
280     "mtime int(11) DEFAULT NULL"
281     "serial int(11) NOT NULL"
282     "ip varchar(255) DEFAULT NULL"
283     "mac varchar(255) DEFAULT NULL"
284     "netboot tinyint(1) NOT NULL DEFAULT '0'"
285     )
286     sql_create_table
287    
288     TABLE_DEFINITION=(
289     "values_storefront_store"
290     "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
291     "name varchar(255) NOT NULL"
292     "store varchar(255) NOT NULL"
293     "user varchar(255) DEFAULT NULL"
294     "password varchar(255) DEFAULT NULL"
295     "domain varchar(255) DEFAULT NULL"
296     "enabled tinyint(1) NOT NULL DEFAULT '1'"
297     )
298     sql_create_table
299    
300     TABLE_DEFINITION=(
301     "values_citrix_session"
302     "id int(255) NOT NULL PRIMARY KEY AUTO_INCREMENT"
303     "session varchar(255) NOT NULL"
304     "description varchar(255) DEFAULT NULL"
305     "enabled tinyint(1) NOT NULL DEFAULT '1'"
306     )
307     sql_create_table
308    
309     TABLE_DEFINITION=(
310     "values_graphic_depth"
311     "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
312     "value varchar(255) NOT NULL"
313     "enabled tinyint(1) NOT NULL DEFAULT '1'"
314     )
315     sql_create_table
316    
317     TABLE_DEFINITION=(
318     "values_graphic_module"
319     "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
320     "value varchar(255) NOT NULL"
321     "enabled tinyint(1) NOT NULL DEFAULT '1'"
322     )
323     sql_create_table
324    
325     TABLE_DEFINITION=(
326     "values_graphic_refresh_rate"
327     "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
328     "value varchar(255) NOT NULL"
329     "enabled tinyint(1) NOT NULL DEFAULT '1'"
330     )
331     sql_create_table
332    
333     TABLE_DEFINITION=(
334     "values_graphic_resolution"
335     "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
336     "value varchar(255) NOT NULL"
337     "enabled tinyint(1) NOT NULL DEFAULT '1'"
338     )
339     sql_create_table
340    
341     TABLE_DEFINITION=(
342     "values_input_keymap"
343     "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
344     "value varchar(255) NOT NULL"
345     "enabled tinyint(1) NOT NULL DEFAULT '1'"
346     )
347     sql_create_table
348    
349     TABLE_DEFINITION=(
350     "values_network_module"
351     "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
352     "value varchar(255) NOT NULL"
353     "enabled tinyint(1) NOT NULL DEFAULT '1'"
354 niro 10646 "description varchar(255) DEFAULT NULL"
355 niro 8485 )
356     sql_create_table
357    
358     TABLE_DEFINITION=(
359 niro 8515 "values_network_wireless_auth_mode"
360     "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
361     "value varchar(255) NOT NULL"
362     "enabled tinyint(1) NOT NULL DEFAULT '1'"
363     )
364     sql_create_table
365    
366     TABLE_DEFINITION=(
367 niro 8521 "values_network_wireless_bitrate"
368     "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
369     "value varchar(255) NOT NULL"
370     "enabled tinyint(1) NOT NULL DEFAULT '1'"
371     )
372     sql_create_table
373    
374     TABLE_DEFINITION=(
375 niro 8518 "values_network_wireless_channel"
376 niro 8515 "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
377     "value varchar(255) NOT NULL"
378     "enabled tinyint(1) NOT NULL DEFAULT '1'"
379     )
380     sql_create_table
381    
382     TABLE_DEFINITION=(
383     "values_network_wireless_frequency"
384     "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
385     "value varchar(255) NOT NULL"
386     "enabled tinyint(1) NOT NULL DEFAULT '1'"
387     )
388     sql_create_table
389    
390     TABLE_DEFINITION=(
391 niro 8518 "values_network_wireless_key_length"
392 niro 8515 "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
393     "value varchar(255) NOT NULL"
394     "enabled tinyint(1) NOT NULL DEFAULT '1'"
395     )
396     sql_create_table
397    
398     TABLE_DEFINITION=(
399     "values_network_wireless_mode"
400     "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
401     "value varchar(255) NOT NULL"
402     "enabled tinyint(1) NOT NULL DEFAULT '1'"
403     )
404     sql_create_table
405    
406     TABLE_DEFINITION=(
407 niro 8485 "values_printers_port"
408     "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
409     "value varchar(255) NOT NULL"
410     "enabled tinyint(1) NOT NULL DEFAULT '1'"
411     )
412     sql_create_table
413    
414     TABLE_DEFINITION=(
415     "values_screensaver_screensaver"
416     "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
417     "value varchar(255) NOT NULL"
418     "enabled tinyint(1) NOT NULL DEFAULT '1'"
419     )
420     sql_create_table
421    
422     TABLE_DEFINITION=(
423     "values_storefront_session"
424     "id int(255) NOT NULL PRIMARY KEY AUTO_INCREMENT"
425     "session varchar(255) NOT NULL"
426     "description varchar(255) DEFAULT NULL"
427     "store varchar(255) NOT NULL"
428     "enabled tinyint(1) NOT NULL DEFAULT '1'"
429     )
430     sql_create_table
431 niro 9463
432     TABLE_DEFINITION=(
433     "client_boot"
434     "serial int(255) NOT NULL PRIMARY KEY"
435     "cmdline varchar(255) DEFAULT NULL"
436     )
437     sql_create_table
438 niro 8485 }