Magellan Linux

Diff of /alx-src/branches/alx-web-070/scripts/sql-schema/include/schema.sh

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 14431 by niro, Wed Jul 15 07:23:38 2020 UTC revision 14432 by niro, Wed Jul 15 09:14:42 2020 UTC
# Line 15  create_database_schema() Line 15  create_database_schema()
15   TABLE_DEFINITION=(   TABLE_DEFINITION=(
16   "cfg_citrix_serverlist"   "cfg_citrix_serverlist"
17   "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"   "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
18   "serial int(11) NOT NULL"   "serial int(11) DEFAULT NULL"
19   "host varchar(255) NOT NULL"   "host varchar(255) DEFAULT NULL"
20   "enabled tinyint(1) NOT NULL DEFAULT '1'"   "enabled tinyint(1) NOT NULL DEFAULT '1'"
21   )   )
22   sql_create_table   sql_create_table
# Line 33  create_database_schema() Line 33  create_database_schema()
33   "cfg_fluxbox_autostart"   "cfg_fluxbox_autostart"
34   "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"   "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
35   "serial int(11) NOT NULL"   "serial int(11) NOT NULL"
36   "name varchar(255) NOT NULL"   "name varchar(255) DEFAULT NULL"
37   "exec varchar(255) NOT NULL"   "exec varchar(255) DEFAULT NULL"
38   "comment varchar(255) DEFAULT NULL"   "comment varchar(255) DEFAULT NULL"
39   "enabled tinyint(1) NOT NULL DEFAULT '1'"   "enabled tinyint(1) NOT NULL DEFAULT '1'"
40   )   )
# Line 44  create_database_schema() Line 44  create_database_schema()
44   "cfg_fluxbox_menuitem"   "cfg_fluxbox_menuitem"
45   "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"   "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
46   "serial int(11) NOT NULL"   "serial int(11) NOT NULL"
47   "name varchar(255) NOT NULL"   "name varchar(255) DEFAULT NULL"
48   "exec varchar(255) NOT NULL"   "exec varchar(255) DEFAULT NULL"
49   "workdir varchar(255) DEFAULT NULL"   "workdir varchar(255) DEFAULT NULL"
50   "icon varchar(255) DEFAULT NULL"   "icon varchar(255) DEFAULT NULL"
51   "enabled tinyint(1) NOT NULL DEFAULT '1'"   "enabled tinyint(1) NOT NULL DEFAULT '1'"
# Line 56  create_database_schema() Line 56  create_database_schema()
56   "cfg_fluxbox_theme"   "cfg_fluxbox_theme"
57   "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"   "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
58   "serial int(11) NOT NULL"   "serial int(11) NOT NULL"
59   "theme varchar(255) NOT NULL"   "theme varchar(255) DEFAULT NULL"
60   )   )
61   sql_create_table   sql_create_table
62    
# Line 76  create_database_schema() Line 76  create_database_schema()
76   "cfg_idesk_icon"   "cfg_idesk_icon"
77   "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"   "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
78   "serial int(11) NOT NULL"   "serial int(11) NOT NULL"
79   "name varchar(255) NOT NULL"   "name varchar(255) DEFAULT NULL"
80   "command varchar(255) NOT NULL"   "command varchar(255) DEFAULT NULL"
81   "icon varchar(255) NOT NULL"   "icon varchar(255) DEFAULT NULL"
82   "filename varchar(255) NOT NULL"   "filename varchar(255) DEFAULT NULL"
83   "xpos varchar(255) NOT NULL"   "xpos varchar(255) DEFAULT NULL"
84   "ypos varchar(255) NOT NULL"   "ypos varchar(255) DEFAULT NULL"
85   "width varchar(255) NOT NULL"   "width varchar(255) DEFAULT NULL"
86   "height varchar(255) NOT NULL"   "height varchar(255) DEFAULT NULL"
87   "default_icon varchar(255) NOT NULL"   "default_icon varchar(255) DEFAULT NULL"
88   "enabled tinyint(1) NOT NULL DEFAULT '1'"   "enabled tinyint(1) NOT NULL DEFAULT '1'"
89   )   )
90   sql_create_table   sql_create_table
# Line 135  create_database_schema() Line 135  create_database_schema()
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"
138   "printer_name varchar(255) NOT NULL"   "printer_name varchar(255) DEFAULT NULL"
139   "port varchar(255) NOT NULL"   "port varchar(255) DEFAULT NULL"
140   "enabled tinyint(1) NOT NULL DEFAULT '1'"   "enabled tinyint(1) NOT NULL DEFAULT '1'"
141   )   )
142   sql_create_table   sql_create_table
# Line 151  create_database_schema() Line 151  create_database_schema()
151   TABLE_DEFINITION=(   TABLE_DEFINITION=(
152   "cfg_screensaver"   "cfg_screensaver"
153   "serial int(11) NOT NULL PRIMARY KEY"   "serial int(11) NOT NULL PRIMARY KEY"
154   "screensaver varchar(255) NOT NULL"   "screensaver varchar(255) DEFAULT 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'"   "dpms tinyint(1) NOT NULL DEFAULT '1'"
# Line 162  create_database_schema() Line 162  create_database_schema()
162   "cfg_sessions_citrix"   "cfg_sessions_citrix"
163   "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"   "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
164   "serial int(11) NOT NULL"   "serial int(11) NOT NULL"
165   "name varchar(255) NOT NULL"   "name varchar(255) DEFAULT NULL"
166   "session varchar(255) NOT NULL"   "session varchar(255) DEFAULT NULL"
167   "filename varchar(255) DEFAULT NULL"   "filename varchar(255) DEFAULT NULL"
168   "username varchar(255) DEFAULT NULL"   "username varchar(255) DEFAULT NULL"
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) DEFAULT NULL"
172   "autostart tinyint(1) NOT NULL DEFAULT '1'"   "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'"
# Line 179  create_database_schema() Line 179  create_database_schema()
179   "cfg_sessions_rdesktop"   "cfg_sessions_rdesktop"
180   "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"   "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
181   "serial int(11) NOT NULL"   "serial int(11) NOT NULL"
182   "name varchar(255) NOT NULL"   "name varchar(255) DEFAULT NULL"
183   "server varchar(255) NOT NULL"   "server varchar(255) DEFAULT NULL"
184   "filename varchar(255) DEFAULT NULL"   "filename varchar(255) DEFAULT NULL"
185   "username varchar(255) DEFAULT NULL"   "username varchar(255) DEFAULT NULL"
186   "password varchar(255) DEFAULT NULL"   "password varchar(255) DEFAULT NULL"
# Line 196  create_database_schema() Line 196  create_database_schema()
196   "cfg_sessions_storefront"   "cfg_sessions_storefront"
197   "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"   "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
198   "serial int(11) NOT NULL"   "serial int(11) NOT NULL"
199   "name varchar(255) NOT NULL"   "name varchar(255) DEFAULT NULL"
200   "session varchar(255) NOT NULL"   "session varchar(255) DEFAULT NULL"
201   "filename varchar(255) DEFAULT NULL"   "filename varchar(255) DEFAULT NULL"
202   "username varchar(255) DEFAULT NULL"   "username varchar(255) DEFAULT NULL"
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) DEFAULT NULL"
206   "autostart tinyint(1) NOT NULL DEFAULT '1'"   "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'"
# Line 213  create_database_schema() Line 213  create_database_schema()
213   "cfg_storefront_store"   "cfg_storefront_store"
214   "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"   "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
215   "serial int(11) NOT NULL"   "serial int(11) NOT NULL"
216   "store varchar(255) NOT NULL"   "store varchar(255) DEFAULT NULL"
217   "enabled tinyint(1) NOT NULL DEFAULT '1'"   "enabled tinyint(1) NOT NULL DEFAULT '1'"
218   )   )
219   sql_create_table   sql_create_table
# Line 237  create_database_schema() Line 237  create_database_schema()
237   TABLE_DEFINITION=(   TABLE_DEFINITION=(
238   "client_locations"   "client_locations"
239   "location varchar(255) NOT NULL PRIMARY KEY"   "location varchar(255) NOT NULL PRIMARY KEY"
240   "bootserver varchar(255) NOT NULL"   "bootserver varchar(255) DEFAULT NULL"
241   "controlserver varchar(255) NOT NULL"   "controlserver varchar(255) DEFAULT NULL"
242   "pxe_default_entry varchar(255) NOT NULL"   "pxe_default_entry varchar(255) DEFAULT NULL"
243   "pxe_prompt tinyint(1) NOT NULL"   "pxe_prompt tinyint(1) NOT NULL DEFAULT '0'"
244   "pxe_timeout smallint(1) NOT NULL"   "pxe_timeout smallint(1) NOT NULL DEFAULT '300'"
245   "updateserver varchar(255) NOT NULL"   "updateserver varchar(255) DEFAULT NULL"
246   "username varchar(255) NOT NULL"   "username varchar(255) DEFAULT NULL"
247   "password varchar(255) NOT NULL"   "password varchar(255) DEFAULT NULL"
248   "rsync varchar(255) NOT NULL"   "rsync varchar(255) DEFAULT NULL"
249   "repository varchar(255) NOT NULL"   "repository varchar(255) DEFAULT NULL"
250   "helpdesk_unit varchar(255) NOT NULL"   "helpdesk_unit varchar(255) DEFAULT NULL"
251   "helpdesk_phone varchar(255) NOT NULL"   "helpdesk_phone varchar(255) DEFAULT NULL"
252   "set_default tinyint(1) NOT NULL DEFAULT '0'"   "set_default tinyint(1) NOT NULL DEFAULT '0'"
253   "enabled tinyint(1) NOT NULL DEFAULT '1'"   "enabled tinyint(1) NOT NULL DEFAULT '1'"
254   )   )
# Line 288  create_database_schema() Line 288  create_database_schema()
288   TABLE_DEFINITION=(   TABLE_DEFINITION=(
289   "values_storefront_store"   "values_storefront_store"
290   "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"   "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
291   "name varchar(255) NOT NULL"   "name varchar(255) DEFAULT NULL"
292   "store varchar(255) NOT NULL"   "store varchar(255) DEFAULT NULL"
293   "user varchar(255) DEFAULT NULL"   "user varchar(255) DEFAULT NULL"
294   "password varchar(255) DEFAULT NULL"   "password varchar(255) DEFAULT NULL"
295   "domain varchar(255) DEFAULT NULL"   "domain varchar(255) DEFAULT NULL"
# Line 300  create_database_schema() Line 300  create_database_schema()
300   TABLE_DEFINITION=(   TABLE_DEFINITION=(
301   "values_citrix_session"   "values_citrix_session"
302   "id int(255) NOT NULL PRIMARY KEY AUTO_INCREMENT"   "id int(255) NOT NULL PRIMARY KEY AUTO_INCREMENT"
303   "session varchar(255) NOT NULL"   "session varchar(255) DEFAULT NULL"
304   "description varchar(255) DEFAULT NULL"   "description varchar(255) DEFAULT NULL"
305   "enabled tinyint(1) NOT NULL DEFAULT '1'"   "enabled tinyint(1) NOT NULL DEFAULT '1'"
306   )   )
# Line 309  create_database_schema() Line 309  create_database_schema()
309   TABLE_DEFINITION=(   TABLE_DEFINITION=(
310   "values_graphic_depth"   "values_graphic_depth"
311   "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"   "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
312   "value varchar(255) NOT NULL"   "value varchar(255) DEFAULT NULL"
313   "enabled tinyint(1) NOT NULL DEFAULT '1'"   "enabled tinyint(1) NOT NULL DEFAULT '1'"
314   )   )
315   sql_create_table   sql_create_table
# Line 317  create_database_schema() Line 317  create_database_schema()
317   TABLE_DEFINITION=(   TABLE_DEFINITION=(
318   "values_graphic_module"   "values_graphic_module"
319   "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"   "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
320   "value varchar(255) NOT NULL"   "value varchar(255) DEFAULT NULL"
321   "enabled tinyint(1) NOT NULL DEFAULT '1'"   "enabled tinyint(1) NOT NULL DEFAULT '1'"
322   )   )
323   sql_create_table   sql_create_table
# Line 325  create_database_schema() Line 325  create_database_schema()
325   TABLE_DEFINITION=(   TABLE_DEFINITION=(
326   "values_graphic_refresh_rate"   "values_graphic_refresh_rate"
327   "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"   "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
328   "value varchar(255) NOT NULL"   "value varchar(255) DEFAULT NULL"
329   "enabled tinyint(1) NOT NULL DEFAULT '1'"   "enabled tinyint(1) NOT NULL DEFAULT '1'"
330   )   )
331   sql_create_table   sql_create_table
# Line 333  create_database_schema() Line 333  create_database_schema()
333   TABLE_DEFINITION=(   TABLE_DEFINITION=(
334   "values_graphic_resolution"   "values_graphic_resolution"
335   "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"   "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
336   "value varchar(255) NOT NULL"   "value varchar(255) DEFAULT NULL"
337   "enabled tinyint(1) NOT NULL DEFAULT '1'"   "enabled tinyint(1) NOT NULL DEFAULT '1'"
338   )   )
339   sql_create_table   sql_create_table
# Line 341  create_database_schema() Line 341  create_database_schema()
341   TABLE_DEFINITION=(   TABLE_DEFINITION=(
342   "values_input_keymap"   "values_input_keymap"
343   "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"   "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
344   "value varchar(255) NOT NULL"   "value varchar(255) DEFAULT NULL"
345   "enabled tinyint(1) NOT NULL DEFAULT '1'"   "enabled tinyint(1) NOT NULL DEFAULT '1'"
346   )   )
347   sql_create_table   sql_create_table
# Line 349  create_database_schema() Line 349  create_database_schema()
349   TABLE_DEFINITION=(   TABLE_DEFINITION=(
350   "values_network_module"   "values_network_module"
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) DEFAULT NULL"
353   "enabled tinyint(1) NOT NULL DEFAULT '1'"   "enabled tinyint(1) NOT NULL DEFAULT '1'"
354   "description varchar(255) DEFAULT NULL"   "description varchar(255) DEFAULT NULL"
355   )   )
# Line 358  create_database_schema() Line 358  create_database_schema()
358   TABLE_DEFINITION=(   TABLE_DEFINITION=(
359   "values_network_wireless_auth_mode"   "values_network_wireless_auth_mode"
360   "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"   "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
361   "value varchar(255) NOT NULL"   "value varchar(255) DEFAULT NULL"
362   "enabled tinyint(1) NOT NULL DEFAULT '1'"   "enabled tinyint(1) NOT NULL DEFAULT '1'"
363   )   )
364   sql_create_table   sql_create_table
# Line 366  create_database_schema() Line 366  create_database_schema()
366   TABLE_DEFINITION=(   TABLE_DEFINITION=(
367   "values_network_wireless_bitrate"   "values_network_wireless_bitrate"
368   "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"   "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
369   "value varchar(255) NOT NULL"   "value varchar(255) DEFAULT NULL"
370   "enabled tinyint(1) NOT NULL DEFAULT '1'"   "enabled tinyint(1) NOT NULL DEFAULT '1'"
371   )   )
372   sql_create_table   sql_create_table
# Line 374  create_database_schema() Line 374  create_database_schema()
374   TABLE_DEFINITION=(   TABLE_DEFINITION=(
375   "values_network_wireless_channel"   "values_network_wireless_channel"
376   "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"   "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
377   "value varchar(255) NOT NULL"   "value varchar(255) DEFAULT NULL"
378   "enabled tinyint(1) NOT NULL DEFAULT '1'"   "enabled tinyint(1) NOT NULL DEFAULT '1'"
379   )   )
380   sql_create_table   sql_create_table
# Line 382  create_database_schema() Line 382  create_database_schema()
382   TABLE_DEFINITION=(   TABLE_DEFINITION=(
383   "values_network_wireless_frequency"   "values_network_wireless_frequency"
384   "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"   "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
385   "value varchar(255) NOT NULL"   "value varchar(255) DEFAULT NULL"
386   "enabled tinyint(1) NOT NULL DEFAULT '1'"   "enabled tinyint(1) NOT NULL DEFAULT '1'"
387   )   )
388   sql_create_table   sql_create_table
# Line 390  create_database_schema() Line 390  create_database_schema()
390   TABLE_DEFINITION=(   TABLE_DEFINITION=(
391   "values_network_wireless_key_length"   "values_network_wireless_key_length"
392   "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"   "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
393   "value varchar(255) NOT NULL"   "value varchar(255) DEFAULT NULL"
394   "enabled tinyint(1) NOT NULL DEFAULT '1'"   "enabled tinyint(1) NOT NULL DEFAULT '1'"
395   )   )
396   sql_create_table   sql_create_table
# Line 398  create_database_schema() Line 398  create_database_schema()
398   TABLE_DEFINITION=(   TABLE_DEFINITION=(
399   "values_network_wireless_mode"   "values_network_wireless_mode"
400   "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"   "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
401   "value varchar(255) NOT NULL"   "value varchar(255) DEFAULT NULL"
402   "enabled tinyint(1) NOT NULL DEFAULT '1'"   "enabled tinyint(1) NOT NULL DEFAULT '1'"
403   )   )
404   sql_create_table   sql_create_table
# Line 406  create_database_schema() Line 406  create_database_schema()
406   TABLE_DEFINITION=(   TABLE_DEFINITION=(
407   "values_printers_port"   "values_printers_port"
408   "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"   "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
409   "value varchar(255) NOT NULL"   "value varchar(255) DEFAULT NULL"
410   "enabled tinyint(1) NOT NULL DEFAULT '1'"   "enabled tinyint(1) NOT NULL DEFAULT '1'"
411   )   )
412   sql_create_table   sql_create_table
# Line 414  create_database_schema() Line 414  create_database_schema()
414   TABLE_DEFINITION=(   TABLE_DEFINITION=(
415   "values_screensaver_screensaver"   "values_screensaver_screensaver"
416   "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"   "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
417   "value varchar(255) NOT NULL"   "value varchar(255) DEFAULT NULL"
418   "enabled tinyint(1) NOT NULL DEFAULT '1'"   "enabled tinyint(1) NOT NULL DEFAULT '1'"
419   )   )
420   sql_create_table   sql_create_table
# Line 422  create_database_schema() Line 422  create_database_schema()
422   TABLE_DEFINITION=(   TABLE_DEFINITION=(
423   "values_storefront_session"   "values_storefront_session"
424   "id int(255) NOT NULL PRIMARY KEY AUTO_INCREMENT"   "id int(255) NOT NULL PRIMARY KEY AUTO_INCREMENT"
425   "session varchar(255) NOT NULL"   "session varchar(255) DEFAULT NULL"
426   "description varchar(255) DEFAULT NULL"   "description varchar(255) DEFAULT NULL"
427   "store varchar(255) NOT NULL"   "store varchar(255) DEFAULT NULL"
428   "enabled tinyint(1) NOT NULL DEFAULT '1'"   "enabled tinyint(1) NOT NULL DEFAULT '1'"
429   )   )
430   sql_create_table   sql_create_table

Legend:
Removed from v.14431  
changed lines
  Added in v.14432