1 |
create_database_schema() |
create_database_schema() |
2 |
{ |
{ |
3 |
TABLE_DEFINITION=( |
TABLE_DEFINITION=( |
4 |
"meta" |
"meta_schema" |
5 |
"version int(11) NOT NULL PRIMARY KEY" |
"version int(11) NOT NULL PRIMARY KEY" |
6 |
) |
) |
7 |
sql_create_table |
sql_create_table |
8 |
|
|
9 |
TABLE_DEFINITION=( |
TABLE_DEFINITION=( |
10 |
"cfg_autostart" |
"meta_values" |
11 |
"id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" |
"version int(11) NOT NULL PRIMARY KEY" |
|
"serial int(11) NOT NULL" |
|
|
"name varchar(255) NOT NULL" |
|
|
"exec varchar(255) DEFAULT NULL" |
|
|
"enabled tinyint(1) NOT NULL DEFAULT '1'" |
|
|
"flg_modified tinyint(1) NOT NULL DEFAULT '0'" |
|
12 |
) |
) |
13 |
sql_create_table |
sql_create_table |
14 |
|
|
36 |
"name varchar(255) NOT NULL" |
"name varchar(255) NOT NULL" |
37 |
"exec varchar(255) NOT NULL" |
"exec varchar(255) NOT NULL" |
38 |
"comment varchar(255) DEFAULT NULL" |
"comment varchar(255) DEFAULT NULL" |
39 |
|
"enabled tinyint(1) NOT NULL DEFAULT '1'" |
40 |
) |
) |
41 |
sql_create_table |
sql_create_table |
42 |
|
|
132 |
sql_create_table |
sql_create_table |
133 |
|
|
134 |
TABLE_DEFINITION=( |
TABLE_DEFINITION=( |
|
"cfg_other_menuitems" |
|
|
"id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" |
|
|
"serial int(11) NOT NULL" |
|
|
"name varchar(255) DEFAULT NULL" |
|
|
"exec varchar(255) DEFAULT NULL" |
|
|
"workdir varchar(255) DEFAULT NULL" |
|
|
"icon varchar(255) DEFAULT NULL" |
|
|
) |
|
|
sql_create_table |
|
|
|
|
|
TABLE_DEFINITION=( |
|
135 |
"cfg_printers" |
"cfg_printers" |
136 |
"id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" |
"id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" |
137 |
"serial int(11) NOT NULL" |
"serial int(11) NOT NULL" |
154 |
"screensaver varchar(255) NOT NULL" |
"screensaver varchar(255) NOT NULL" |
155 |
"timeout int(11) DEFAULT '10'" |
"timeout int(11) DEFAULT '10'" |
156 |
"password varchar(255) DEFAULT NULL" |
"password varchar(255) DEFAULT NULL" |
157 |
|
"dpms tinyint(1) NOT NULL DEFAULT '1'" |
158 |
) |
) |
159 |
sql_create_table |
sql_create_table |
160 |
|
|
169 |
"domain varchar(255) DEFAULT NULL" |
"domain varchar(255) DEFAULT NULL" |
170 |
"password varchar(255) DEFAULT NULL" |
"password varchar(255) DEFAULT NULL" |
171 |
"serverlist varchar(255) NOT NULL" |
"serverlist varchar(255) NOT NULL" |
172 |
"autostart tinyint(1) NOT NULL DEFAULT '0'" |
"autostart tinyint(1) NOT NULL DEFAULT '1'" |
173 |
"enabled tinyint(1) NOT NULL DEFAULT '1'" |
"enabled tinyint(1) NOT NULL DEFAULT '1'" |
174 |
"flg_modified tinyint(1) NOT NULL DEFAULT '0'" |
"flg_modified tinyint(1) NOT NULL DEFAULT '0'" |
175 |
) |
) |
186 |
"password varchar(255) DEFAULT NULL" |
"password varchar(255) DEFAULT NULL" |
187 |
"domain varchar(255) DEFAULT NULL" |
"domain varchar(255) DEFAULT NULL" |
188 |
"shell varchar(255) DEFAULT NULL" |
"shell varchar(255) DEFAULT NULL" |
189 |
"autostart tinyint(1) NOT NULL DEFAULT '0'" |
"autostart tinyint(1) NOT NULL DEFAULT '1'" |
190 |
"enabled tinyint(1) NOT NULL DEFAULT '1'" |
"enabled tinyint(1) NOT NULL DEFAULT '1'" |
191 |
"flg_modified tinyint(1) NOT NULL DEFAULT '0'" |
"flg_modified tinyint(1) NOT NULL DEFAULT '0'" |
192 |
) |
) |
203 |
"domain varchar(255) DEFAULT NULL" |
"domain varchar(255) DEFAULT NULL" |
204 |
"password varchar(255) DEFAULT NULL" |
"password varchar(255) DEFAULT NULL" |
205 |
"store varchar(255) NOT NULL" |
"store varchar(255) NOT NULL" |
206 |
"autostart tinyint(1) NOT NULL DEFAULT '0'" |
"autostart tinyint(1) NOT NULL DEFAULT '1'" |
207 |
"enabled tinyint(1) NOT NULL DEFAULT '1'" |
"enabled tinyint(1) NOT NULL DEFAULT '1'" |
208 |
"flg_modified tinyint(1) NOT NULL DEFAULT '0'" |
"flg_modified tinyint(1) NOT NULL DEFAULT '0'" |
209 |
) |
) |
235 |
sql_create_table |
sql_create_table |
236 |
|
|
237 |
TABLE_DEFINITION=( |
TABLE_DEFINITION=( |
238 |
"client_location" |
"client_locations" |
239 |
"location varchar(255) NOT NULL PRIMARY KEY" |
"location varchar(255) NOT NULL PRIMARY KEY" |
240 |
|
"bootserver varchar(255) NOT NULL" |
241 |
"controlserver varchar(255) NOT NULL" |
"controlserver varchar(255) NOT NULL" |
242 |
"pxe_default_entry varchar(255) NOT NULL" |
"pxe_default_entry varchar(255) NOT NULL" |
243 |
"pxe_prompt tinyint(1) NOT NULL" |
"pxe_prompt tinyint(1) NOT NULL" |
256 |
|
|
257 |
TABLE_DEFINITION=( |
TABLE_DEFINITION=( |
258 |
"client_serials" |
"client_serials" |
259 |
"serial int(11) NOT NULL PRIMARY KEY" |
"serial int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" |
260 |
"location varchar(255) NOT NULL" |
"location varchar(255) NOT NULL" |
261 |
"mtime int(11) DEFAULT NULL" |
"mtime int(11) DEFAULT NULL" |
262 |
"mac varchar(17) NOT NULL" |
"mac varchar(17) NOT NULL" |
270 |
"serial int(11) NOT NULL PRIMARY KEY" |
"serial int(11) NOT NULL PRIMARY KEY" |
271 |
"os varchar(50) NOT NULL" |
"os varchar(50) NOT NULL" |
272 |
"utils varchar(50) NOT NULL" |
"utils varchar(50) NOT NULL" |
273 |
|
"arch varchar(50) NOT NULL" |
274 |
) |
) |
275 |
sql_create_table |
sql_create_table |
276 |
|
|
351 |
"id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" |
"id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" |
352 |
"value varchar(255) NOT NULL" |
"value varchar(255) NOT NULL" |
353 |
"enabled tinyint(1) NOT NULL DEFAULT '1'" |
"enabled tinyint(1) NOT NULL DEFAULT '1'" |
354 |
|
"description varchar(255) DEFAULT NULL" |
355 |
|
) |
356 |
|
sql_create_table |
357 |
|
|
358 |
|
TABLE_DEFINITION=( |
359 |
|
"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 |
|
"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 |
|
"values_network_wireless_channel" |
376 |
|
"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 |
|
"values_network_wireless_key_length" |
392 |
|
"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 |
sql_create_table |
405 |
|
|
428 |
"enabled tinyint(1) NOT NULL DEFAULT '1'" |
"enabled tinyint(1) NOT NULL DEFAULT '1'" |
429 |
) |
) |
430 |
sql_create_table |
sql_create_table |
431 |
|
|
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 |
} |
} |