Annotation of /alx-src/branches/alx-web-070/scripts/sql-schema/include/schema.sh
Parent Directory | Revision Log
Revision 8497 -
(hide annotations)
(download)
(as text)
Fri Feb 5 13:48:23 2016 UTC (8 years, 4 months ago) by niro
File MIME type: application/x-sh
File size: 10664 byte(s)
Fri Feb 5 13:48:23 2016 UTC (8 years, 4 months ago) by niro
File MIME type: application/x-sh
File size: 10664 byte(s)
-renamed all version instances to schema_version
1 | niro | 8485 | create_database_schema() |
2 | { | ||
3 | TABLE_DEFINITION=( | ||
4 | "meta" | ||
5 | niro | 8497 | "schema_version int(11) NOT NULL PRIMARY KEY" |
6 | niro | 8485 | ) |
7 | sql_create_table | ||
8 | |||
9 | TABLE_DEFINITION=( | ||
10 | "cfg_autostart" | ||
11 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" | ||
12 | "serial int(11) NOT NULL" | ||
13 | "name varchar(255) NOT NULL" | ||
14 | "exec varchar(255) DEFAULT NULL" | ||
15 | "enabled tinyint(1) NOT NULL DEFAULT '1'" | ||
16 | "flg_modified tinyint(1) NOT NULL DEFAULT '0'" | ||
17 | ) | ||
18 | sql_create_table | ||
19 | |||
20 | TABLE_DEFINITION=( | ||
21 | "cfg_citrix_serverlist" | ||
22 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" | ||
23 | "serial int(11) NOT NULL" | ||
24 | "host varchar(255) NOT NULL" | ||
25 | "enabled tinyint(1) NOT NULL DEFAULT '1'" | ||
26 | ) | ||
27 | sql_create_table | ||
28 | |||
29 | TABLE_DEFINITION=( | ||
30 | "cfg_comments" | ||
31 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" | ||
32 | "serial int(11) NOT NULL" | ||
33 | "txt text" | ||
34 | ) | ||
35 | sql_create_table | ||
36 | |||
37 | TABLE_DEFINITION=( | ||
38 | "cfg_fluxbox_autostart" | ||
39 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" | ||
40 | "serial int(11) NOT NULL" | ||
41 | "name varchar(255) NOT NULL" | ||
42 | "exec varchar(255) NOT NULL" | ||
43 | "comment varchar(255) DEFAULT NULL" | ||
44 | ) | ||
45 | sql_create_table | ||
46 | |||
47 | TABLE_DEFINITION=( | ||
48 | "cfg_fluxbox_menuitem" | ||
49 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" | ||
50 | "serial int(11) NOT NULL" | ||
51 | "name varchar(255) NOT NULL" | ||
52 | "exec varchar(255) NOT NULL" | ||
53 | "workdir varchar(255) DEFAULT NULL" | ||
54 | "icon varchar(255) DEFAULT NULL" | ||
55 | "enabled tinyint(1) NOT NULL DEFAULT '1'" | ||
56 | ) | ||
57 | sql_create_table | ||
58 | |||
59 | TABLE_DEFINITION=( | ||
60 | "cfg_fluxbox_theme" | ||
61 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" | ||
62 | "serial int(11) NOT NULL" | ||
63 | "theme varchar(255) NOT NULL" | ||
64 | ) | ||
65 | sql_create_table | ||
66 | |||
67 | TABLE_DEFINITION=( | ||
68 | "cfg_graphic" | ||
69 | "serial int(11) NOT NULL PRIMARY KEY" | ||
70 | "resolution varchar(255) DEFAULT NULL" | ||
71 | "depth varchar(288) DEFAULT NULL" | ||
72 | "monitorid int(11) DEFAULT NULL" | ||
73 | "refresh_rate int(3) NOT NULL DEFAULT '60'" | ||
74 | "module varchar(255) DEFAULT NULL" | ||
75 | "hdmi varchar(10) NOT NULL DEFAULT 'disable'" | ||
76 | ) | ||
77 | sql_create_table | ||
78 | |||
79 | TABLE_DEFINITION=( | ||
80 | "cfg_idesk_icon" | ||
81 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" | ||
82 | "serial int(11) NOT NULL" | ||
83 | "name varchar(255) NOT NULL" | ||
84 | "command varchar(255) NOT NULL" | ||
85 | "icon varchar(255) NOT NULL" | ||
86 | "filename varchar(255) NOT NULL" | ||
87 | "xpos varchar(255) NOT NULL" | ||
88 | "ypos varchar(255) NOT NULL" | ||
89 | "width varchar(255) NOT NULL" | ||
90 | "height varchar(255) NOT NULL" | ||
91 | "default_icon varchar(255) NOT NULL" | ||
92 | "enabled tinyint(1) NOT NULL DEFAULT '1'" | ||
93 | ) | ||
94 | sql_create_table | ||
95 | |||
96 | TABLE_DEFINITION=( | ||
97 | "cfg_input" | ||
98 | "serial int(11) NOT NULL PRIMARY KEY" | ||
99 | "keymap varchar(255) DEFAULT NULL" | ||
100 | ) | ||
101 | sql_create_table | ||
102 | |||
103 | TABLE_DEFINITION=( | ||
104 | "cfg_modules" | ||
105 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" | ||
106 | "serial int(11) NOT NULL" | ||
107 | "module varchar(255) DEFAULT NULL" | ||
108 | "arg varchar(255) DEFAULT NULL" | ||
109 | ) | ||
110 | sql_create_table | ||
111 | |||
112 | TABLE_DEFINITION=( | ||
113 | "cfg_network" | ||
114 | "serial int(11) NOT NULL PRIMARY KEY" | ||
115 | "hostname varchar(255) DEFAULT NULL" | ||
116 | "domain varchar(255) DEFAULT NULL" | ||
117 | "networking varchar(255) DEFAULT NULL" | ||
118 | "netmask varchar(255) DEFAULT NULL" | ||
119 | "dns varchar(255) DEFAULT NULL" | ||
120 | "gateway varchar(255) DEFAULT NULL" | ||
121 | "broadcast varchar(255) DEFAULT NULL" | ||
122 | "ip varchar(255) DEFAULT NULL" | ||
123 | "module varchar(255) DEFAULT NULL" | ||
124 | "forcemacto varchar(17) DEFAULT NULL" | ||
125 | "wireless_bitrate varchar(5) DEFAULT NULL" | ||
126 | "wireless_channel varchar(10) DEFAULT NULL" | ||
127 | "wireless_essid varchar(255) DEFAULT NULL" | ||
128 | "wireless_frequency varchar(255) DEFAULT NULL" | ||
129 | "wireless_mode varchar(255) DEFAULT NULL" | ||
130 | "wireless_nick varchar(255) DEFAULT NULL" | ||
131 | "wireless_auth_mode varchar(255) DEFAULT NULL" | ||
132 | "wireless_key_length varchar(255) DEFAULT NULL" | ||
133 | "wireless_key text" | ||
134 | "wireless_key_ascii text" | ||
135 | ) | ||
136 | sql_create_table | ||
137 | |||
138 | TABLE_DEFINITION=( | ||
139 | "cfg_other_menuitems" | ||
140 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" | ||
141 | "serial int(11) NOT NULL" | ||
142 | "name varchar(255) DEFAULT NULL" | ||
143 | "exec varchar(255) DEFAULT NULL" | ||
144 | "workdir varchar(255) DEFAULT NULL" | ||
145 | "icon varchar(255) DEFAULT NULL" | ||
146 | ) | ||
147 | sql_create_table | ||
148 | |||
149 | TABLE_DEFINITION=( | ||
150 | "cfg_printers" | ||
151 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" | ||
152 | "serial int(11) NOT NULL" | ||
153 | "printer_name varchar(255) NOT NULL" | ||
154 | "port varchar(255) NOT NULL" | ||
155 | "enabled tinyint(1) NOT NULL DEFAULT '1'" | ||
156 | ) | ||
157 | sql_create_table | ||
158 | |||
159 | TABLE_DEFINITION=( | ||
160 | "cfg_scm_egk" | ||
161 | "serial int(11) NOT NULL PRIMARY KEY" | ||
162 | "facility tinyint(1) NOT NULL DEFAULT '1'" | ||
163 | ) | ||
164 | sql_create_table | ||
165 | |||
166 | TABLE_DEFINITION=( | ||
167 | "cfg_screensaver" | ||
168 | "serial int(11) NOT NULL PRIMARY KEY" | ||
169 | "screensaver varchar(255) NOT NULL" | ||
170 | "timeout int(11) DEFAULT '10'" | ||
171 | "password varchar(255) DEFAULT NULL" | ||
172 | ) | ||
173 | sql_create_table | ||
174 | |||
175 | TABLE_DEFINITION=( | ||
176 | "cfg_sessions_citrix" | ||
177 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" | ||
178 | "serial int(11) NOT NULL" | ||
179 | "name varchar(255) NOT NULL" | ||
180 | "session varchar(255) NOT NULL" | ||
181 | "filename varchar(255) DEFAULT NULL" | ||
182 | "username varchar(255) DEFAULT NULL" | ||
183 | "domain varchar(255) DEFAULT NULL" | ||
184 | "password varchar(255) DEFAULT NULL" | ||
185 | "serverlist varchar(255) NOT NULL" | ||
186 | "autostart tinyint(1) NOT NULL DEFAULT '0'" | ||
187 | "enabled tinyint(1) NOT NULL DEFAULT '1'" | ||
188 | "flg_modified tinyint(1) NOT NULL DEFAULT '0'" | ||
189 | ) | ||
190 | sql_create_table | ||
191 | |||
192 | TABLE_DEFINITION=( | ||
193 | "cfg_sessions_rdesktop" | ||
194 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" | ||
195 | "serial int(11) NOT NULL" | ||
196 | "name varchar(255) NOT NULL" | ||
197 | "server varchar(255) NOT NULL" | ||
198 | "filename varchar(255) DEFAULT NULL" | ||
199 | "username varchar(255) DEFAULT NULL" | ||
200 | "password varchar(255) DEFAULT NULL" | ||
201 | "domain varchar(255) DEFAULT NULL" | ||
202 | "shell varchar(255) DEFAULT NULL" | ||
203 | "autostart tinyint(1) NOT NULL DEFAULT '0'" | ||
204 | "enabled tinyint(1) NOT NULL DEFAULT '1'" | ||
205 | "flg_modified tinyint(1) NOT NULL DEFAULT '0'" | ||
206 | ) | ||
207 | sql_create_table | ||
208 | |||
209 | TABLE_DEFINITION=( | ||
210 | "cfg_sessions_storefront" | ||
211 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" | ||
212 | "serial int(11) NOT NULL" | ||
213 | "name varchar(255) NOT NULL" | ||
214 | "session varchar(255) NOT NULL" | ||
215 | "filename varchar(255) DEFAULT NULL" | ||
216 | "username varchar(255) DEFAULT NULL" | ||
217 | "domain varchar(255) DEFAULT NULL" | ||
218 | "password varchar(255) DEFAULT NULL" | ||
219 | "store varchar(255) NOT NULL" | ||
220 | "autostart tinyint(1) NOT NULL DEFAULT '0'" | ||
221 | "enabled tinyint(1) NOT NULL DEFAULT '1'" | ||
222 | "flg_modified tinyint(1) NOT NULL DEFAULT '0'" | ||
223 | ) | ||
224 | sql_create_table | ||
225 | |||
226 | TABLE_DEFINITION=( | ||
227 | "cfg_storefront_store" | ||
228 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" | ||
229 | "serial int(11) NOT NULL" | ||
230 | "store varchar(255) NOT NULL" | ||
231 | "enabled tinyint(1) NOT NULL DEFAULT '1'" | ||
232 | ) | ||
233 | sql_create_table | ||
234 | |||
235 | TABLE_DEFINITION=( | ||
236 | "cfg_vnc" | ||
237 | "serial int(11) NOT NULL PRIMARY KEY" | ||
238 | "service tinyint(1) NOT NULL DEFAULT '1'" | ||
239 | ) | ||
240 | sql_create_table | ||
241 | |||
242 | TABLE_DEFINITION=( | ||
243 | "client_auth" | ||
244 | "serial int(11) NOT NULL PRIMARY KEY" | ||
245 | "user varchar(255) DEFAULT NULL" | ||
246 | "root varchar(255) DEFAULT NULL" | ||
247 | "vnc varchar(255) DEFAULT NULL" | ||
248 | ) | ||
249 | sql_create_table | ||
250 | |||
251 | TABLE_DEFINITION=( | ||
252 | "client_location" | ||
253 | "location varchar(255) NOT NULL PRIMARY KEY" | ||
254 | "controlserver varchar(255) NOT NULL" | ||
255 | "pxe_default_entry varchar(255) NOT NULL" | ||
256 | "pxe_prompt tinyint(1) NOT NULL" | ||
257 | "pxe_timeout smallint(1) NOT NULL" | ||
258 | "updateserver varchar(255) NOT NULL" | ||
259 | "username varchar(255) NOT NULL" | ||
260 | "password varchar(255) NOT NULL" | ||
261 | "rsync varchar(255) NOT NULL" | ||
262 | "repository varchar(255) NOT NULL" | ||
263 | "helpdesk_unit varchar(255) NOT NULL" | ||
264 | "helpdesk_phone varchar(255) NOT NULL" | ||
265 | "set_default tinyint(1) NOT NULL DEFAULT '0'" | ||
266 | "enabled tinyint(1) NOT NULL DEFAULT '1'" | ||
267 | ) | ||
268 | sql_create_table | ||
269 | |||
270 | TABLE_DEFINITION=( | ||
271 | "client_serials" | ||
272 | "serial int(11) NOT NULL PRIMARY KEY" | ||
273 | "location varchar(255) NOT NULL" | ||
274 | "mtime int(11) DEFAULT NULL" | ||
275 | "mac varchar(17) NOT NULL" | ||
276 | "hwdetected tinyint(1) NOT NULL DEFAULT '0'" | ||
277 | "enabled tinyint(1) NOT NULL DEFAULT '1'" | ||
278 | ) | ||
279 | sql_create_table | ||
280 | |||
281 | TABLE_DEFINITION=( | ||
282 | "client_version" | ||
283 | "serial int(11) NOT NULL PRIMARY KEY" | ||
284 | "os varchar(50) NOT NULL" | ||
285 | "utils varchar(50) NOT NULL" | ||
286 | ) | ||
287 | sql_create_table | ||
288 | |||
289 | TABLE_DEFINITION=( | ||
290 | "state_connected" | ||
291 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" | ||
292 | "mtime int(11) DEFAULT NULL" | ||
293 | "serial int(11) NOT NULL" | ||
294 | "ip varchar(255) DEFAULT NULL" | ||
295 | "mac varchar(255) DEFAULT NULL" | ||
296 | "netboot tinyint(1) NOT NULL DEFAULT '0'" | ||
297 | ) | ||
298 | sql_create_table | ||
299 | |||
300 | TABLE_DEFINITION=( | ||
301 | "values_storefront_store" | ||
302 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" | ||
303 | "name varchar(255) NOT NULL" | ||
304 | "store varchar(255) NOT NULL" | ||
305 | "user varchar(255) DEFAULT NULL" | ||
306 | "password varchar(255) DEFAULT NULL" | ||
307 | "domain varchar(255) DEFAULT NULL" | ||
308 | "enabled tinyint(1) NOT NULL DEFAULT '1'" | ||
309 | ) | ||
310 | sql_create_table | ||
311 | |||
312 | TABLE_DEFINITION=( | ||
313 | "values_citrix_session" | ||
314 | "id int(255) NOT NULL PRIMARY KEY AUTO_INCREMENT" | ||
315 | "session varchar(255) NOT NULL" | ||
316 | "description varchar(255) DEFAULT NULL" | ||
317 | "enabled tinyint(1) NOT NULL DEFAULT '1'" | ||
318 | ) | ||
319 | sql_create_table | ||
320 | |||
321 | TABLE_DEFINITION=( | ||
322 | "values_graphic_depth" | ||
323 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" | ||
324 | "value varchar(255) NOT NULL" | ||
325 | "enabled tinyint(1) NOT NULL DEFAULT '1'" | ||
326 | ) | ||
327 | sql_create_table | ||
328 | |||
329 | TABLE_DEFINITION=( | ||
330 | "values_graphic_module" | ||
331 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" | ||
332 | "value varchar(255) NOT NULL" | ||
333 | "enabled tinyint(1) NOT NULL DEFAULT '1'" | ||
334 | ) | ||
335 | sql_create_table | ||
336 | |||
337 | TABLE_DEFINITION=( | ||
338 | "values_graphic_refresh_rate" | ||
339 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" | ||
340 | "value varchar(255) NOT NULL" | ||
341 | "enabled tinyint(1) NOT NULL DEFAULT '1'" | ||
342 | ) | ||
343 | sql_create_table | ||
344 | |||
345 | TABLE_DEFINITION=( | ||
346 | "values_graphic_resolution" | ||
347 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" | ||
348 | "value varchar(255) NOT NULL" | ||
349 | "enabled tinyint(1) NOT NULL DEFAULT '1'" | ||
350 | ) | ||
351 | sql_create_table | ||
352 | |||
353 | TABLE_DEFINITION=( | ||
354 | "values_input_keymap" | ||
355 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" | ||
356 | "value varchar(255) NOT NULL" | ||
357 | "enabled tinyint(1) NOT NULL DEFAULT '1'" | ||
358 | ) | ||
359 | sql_create_table | ||
360 | |||
361 | TABLE_DEFINITION=( | ||
362 | "values_network_module" | ||
363 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" | ||
364 | "value varchar(255) NOT NULL" | ||
365 | "enabled tinyint(1) NOT NULL DEFAULT '1'" | ||
366 | ) | ||
367 | sql_create_table | ||
368 | |||
369 | TABLE_DEFINITION=( | ||
370 | "values_printers_port" | ||
371 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" | ||
372 | "value varchar(255) NOT NULL" | ||
373 | "enabled tinyint(1) NOT NULL DEFAULT '1'" | ||
374 | ) | ||
375 | sql_create_table | ||
376 | |||
377 | TABLE_DEFINITION=( | ||
378 | "values_screensaver_screensaver" | ||
379 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" | ||
380 | "value varchar(255) NOT NULL" | ||
381 | "enabled tinyint(1) NOT NULL DEFAULT '1'" | ||
382 | ) | ||
383 | sql_create_table | ||
384 | |||
385 | TABLE_DEFINITION=( | ||
386 | "values_storefront_session" | ||
387 | "id int(255) NOT NULL PRIMARY KEY AUTO_INCREMENT" | ||
388 | "session varchar(255) NOT NULL" | ||
389 | "description varchar(255) DEFAULT NULL" | ||
390 | "store varchar(255) NOT NULL" | ||
391 | "enabled tinyint(1) NOT NULL DEFAULT '1'" | ||
392 | ) | ||
393 | sql_create_table | ||
394 | } |