Contents of /alx-src/branches/alx-web-070/scripts/sql-schema/include/schema.sh
Parent Directory | Revision Log
Revision 8485 -
(show annotations)
(download)
(as text)
Fri Feb 5 12:06:33 2016 UTC (8 years, 7 months ago) by niro
File MIME type: application/x-sh
File size: 10657 byte(s)
Fri Feb 5 12:06:33 2016 UTC (8 years, 7 months ago) by niro
File MIME type: application/x-sh
File size: 10657 byte(s)
-added initial schema script
1 | create_database_schema() |
2 | { |
3 | TABLE_DEFINITION=( |
4 | "meta" |
5 | "version int(11) NOT NULL PRIMARY KEY" |
6 | ) |
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 | } |