--- alx-src/branches/alx-web-070/scripts/sql-schema/include/schema.sh 2020/07/15 07:53:50 14431 +++ alx-src/branches/alx-web-070/scripts/sql-schema/include/schema.sh 2020/07/15 09:14:42 14432 @@ -15,8 +15,8 @@ TABLE_DEFINITION=( "cfg_citrix_serverlist" "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" - "serial int(11) NOT NULL" - "host varchar(255) NOT NULL" + "serial int(11) DEFAULT NULL" + "host varchar(255) DEFAULT NULL" "enabled tinyint(1) NOT NULL DEFAULT '1'" ) sql_create_table @@ -33,8 +33,8 @@ "cfg_fluxbox_autostart" "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" "serial int(11) NOT NULL" - "name varchar(255) NOT NULL" - "exec varchar(255) NOT NULL" + "name varchar(255) DEFAULT NULL" + "exec varchar(255) DEFAULT NULL" "comment varchar(255) DEFAULT NULL" "enabled tinyint(1) NOT NULL DEFAULT '1'" ) @@ -44,8 +44,8 @@ "cfg_fluxbox_menuitem" "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" "serial int(11) NOT NULL" - "name varchar(255) NOT NULL" - "exec varchar(255) NOT NULL" + "name varchar(255) DEFAULT NULL" + "exec varchar(255) DEFAULT NULL" "workdir varchar(255) DEFAULT NULL" "icon varchar(255) DEFAULT NULL" "enabled tinyint(1) NOT NULL DEFAULT '1'" @@ -56,7 +56,7 @@ "cfg_fluxbox_theme" "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" "serial int(11) NOT NULL" - "theme varchar(255) NOT NULL" + "theme varchar(255) DEFAULT NULL" ) sql_create_table @@ -76,15 +76,15 @@ "cfg_idesk_icon" "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" "serial int(11) NOT NULL" - "name varchar(255) NOT NULL" - "command varchar(255) NOT NULL" - "icon varchar(255) NOT NULL" - "filename varchar(255) NOT NULL" - "xpos varchar(255) NOT NULL" - "ypos varchar(255) NOT NULL" - "width varchar(255) NOT NULL" - "height varchar(255) NOT NULL" - "default_icon varchar(255) NOT NULL" + "name varchar(255) DEFAULT NULL" + "command varchar(255) DEFAULT NULL" + "icon varchar(255) DEFAULT NULL" + "filename varchar(255) DEFAULT NULL" + "xpos varchar(255) DEFAULT NULL" + "ypos varchar(255) DEFAULT NULL" + "width varchar(255) DEFAULT NULL" + "height varchar(255) DEFAULT NULL" + "default_icon varchar(255) DEFAULT NULL" "enabled tinyint(1) NOT NULL DEFAULT '1'" ) sql_create_table @@ -135,8 +135,8 @@ "cfg_printers" "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" "serial int(11) NOT NULL" - "printer_name varchar(255) NOT NULL" - "port varchar(255) NOT NULL" + "printer_name varchar(255) DEFAULT NULL" + "port varchar(255) DEFAULT NULL" "enabled tinyint(1) NOT NULL DEFAULT '1'" ) sql_create_table @@ -151,7 +151,7 @@ TABLE_DEFINITION=( "cfg_screensaver" "serial int(11) NOT NULL PRIMARY KEY" - "screensaver varchar(255) NOT NULL" + "screensaver varchar(255) DEFAULT NULL" "timeout int(11) DEFAULT '10'" "password varchar(255) DEFAULT NULL" "dpms tinyint(1) NOT NULL DEFAULT '1'" @@ -162,13 +162,13 @@ "cfg_sessions_citrix" "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" "serial int(11) NOT NULL" - "name varchar(255) NOT NULL" - "session varchar(255) NOT NULL" + "name varchar(255) DEFAULT NULL" + "session varchar(255) DEFAULT NULL" "filename varchar(255) DEFAULT NULL" "username varchar(255) DEFAULT NULL" "domain varchar(255) DEFAULT NULL" "password varchar(255) DEFAULT NULL" - "serverlist varchar(255) NOT NULL" + "serverlist varchar(255) DEFAULT NULL" "autostart tinyint(1) NOT NULL DEFAULT '1'" "enabled tinyint(1) NOT NULL DEFAULT '1'" "flg_modified tinyint(1) NOT NULL DEFAULT '0'" @@ -179,8 +179,8 @@ "cfg_sessions_rdesktop" "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" "serial int(11) NOT NULL" - "name varchar(255) NOT NULL" - "server varchar(255) NOT NULL" + "name varchar(255) DEFAULT NULL" + "server varchar(255) DEFAULT NULL" "filename varchar(255) DEFAULT NULL" "username varchar(255) DEFAULT NULL" "password varchar(255) DEFAULT NULL" @@ -196,13 +196,13 @@ "cfg_sessions_storefront" "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" "serial int(11) NOT NULL" - "name varchar(255) NOT NULL" - "session varchar(255) NOT NULL" + "name varchar(255) DEFAULT NULL" + "session varchar(255) DEFAULT NULL" "filename varchar(255) DEFAULT NULL" "username varchar(255) DEFAULT NULL" "domain varchar(255) DEFAULT NULL" "password varchar(255) DEFAULT NULL" - "store varchar(255) NOT NULL" + "store varchar(255) DEFAULT NULL" "autostart tinyint(1) NOT NULL DEFAULT '1'" "enabled tinyint(1) NOT NULL DEFAULT '1'" "flg_modified tinyint(1) NOT NULL DEFAULT '0'" @@ -213,7 +213,7 @@ "cfg_storefront_store" "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" "serial int(11) NOT NULL" - "store varchar(255) NOT NULL" + "store varchar(255) DEFAULT NULL" "enabled tinyint(1) NOT NULL DEFAULT '1'" ) sql_create_table @@ -237,18 +237,18 @@ TABLE_DEFINITION=( "client_locations" "location varchar(255) NOT NULL PRIMARY KEY" - "bootserver varchar(255) NOT NULL" - "controlserver varchar(255) NOT NULL" - "pxe_default_entry varchar(255) NOT NULL" - "pxe_prompt tinyint(1) NOT NULL" - "pxe_timeout smallint(1) NOT NULL" - "updateserver varchar(255) NOT NULL" - "username varchar(255) NOT NULL" - "password varchar(255) NOT NULL" - "rsync varchar(255) NOT NULL" - "repository varchar(255) NOT NULL" - "helpdesk_unit varchar(255) NOT NULL" - "helpdesk_phone varchar(255) NOT NULL" + "bootserver varchar(255) DEFAULT NULL" + "controlserver varchar(255) DEFAULT NULL" + "pxe_default_entry varchar(255) DEFAULT NULL" + "pxe_prompt tinyint(1) NOT NULL DEFAULT '0'" + "pxe_timeout smallint(1) NOT NULL DEFAULT '300'" + "updateserver varchar(255) DEFAULT NULL" + "username varchar(255) DEFAULT NULL" + "password varchar(255) DEFAULT NULL" + "rsync varchar(255) DEFAULT NULL" + "repository varchar(255) DEFAULT NULL" + "helpdesk_unit varchar(255) DEFAULT NULL" + "helpdesk_phone varchar(255) DEFAULT NULL" "set_default tinyint(1) NOT NULL DEFAULT '0'" "enabled tinyint(1) NOT NULL DEFAULT '1'" ) @@ -288,8 +288,8 @@ TABLE_DEFINITION=( "values_storefront_store" "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" - "name varchar(255) NOT NULL" - "store varchar(255) NOT NULL" + "name varchar(255) DEFAULT NULL" + "store varchar(255) DEFAULT NULL" "user varchar(255) DEFAULT NULL" "password varchar(255) DEFAULT NULL" "domain varchar(255) DEFAULT NULL" @@ -300,7 +300,7 @@ TABLE_DEFINITION=( "values_citrix_session" "id int(255) NOT NULL PRIMARY KEY AUTO_INCREMENT" - "session varchar(255) NOT NULL" + "session varchar(255) DEFAULT NULL" "description varchar(255) DEFAULT NULL" "enabled tinyint(1) NOT NULL DEFAULT '1'" ) @@ -309,7 +309,7 @@ TABLE_DEFINITION=( "values_graphic_depth" "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" - "value varchar(255) NOT NULL" + "value varchar(255) DEFAULT NULL" "enabled tinyint(1) NOT NULL DEFAULT '1'" ) sql_create_table @@ -317,7 +317,7 @@ TABLE_DEFINITION=( "values_graphic_module" "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" - "value varchar(255) NOT NULL" + "value varchar(255) DEFAULT NULL" "enabled tinyint(1) NOT NULL DEFAULT '1'" ) sql_create_table @@ -325,7 +325,7 @@ TABLE_DEFINITION=( "values_graphic_refresh_rate" "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" - "value varchar(255) NOT NULL" + "value varchar(255) DEFAULT NULL" "enabled tinyint(1) NOT NULL DEFAULT '1'" ) sql_create_table @@ -333,7 +333,7 @@ TABLE_DEFINITION=( "values_graphic_resolution" "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" - "value varchar(255) NOT NULL" + "value varchar(255) DEFAULT NULL" "enabled tinyint(1) NOT NULL DEFAULT '1'" ) sql_create_table @@ -341,7 +341,7 @@ TABLE_DEFINITION=( "values_input_keymap" "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" - "value varchar(255) NOT NULL" + "value varchar(255) DEFAULT NULL" "enabled tinyint(1) NOT NULL DEFAULT '1'" ) sql_create_table @@ -349,7 +349,7 @@ TABLE_DEFINITION=( "values_network_module" "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" - "value varchar(255) NOT NULL" + "value varchar(255) DEFAULT NULL" "enabled tinyint(1) NOT NULL DEFAULT '1'" "description varchar(255) DEFAULT NULL" ) @@ -358,7 +358,7 @@ TABLE_DEFINITION=( "values_network_wireless_auth_mode" "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" - "value varchar(255) NOT NULL" + "value varchar(255) DEFAULT NULL" "enabled tinyint(1) NOT NULL DEFAULT '1'" ) sql_create_table @@ -366,7 +366,7 @@ TABLE_DEFINITION=( "values_network_wireless_bitrate" "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" - "value varchar(255) NOT NULL" + "value varchar(255) DEFAULT NULL" "enabled tinyint(1) NOT NULL DEFAULT '1'" ) sql_create_table @@ -374,7 +374,7 @@ TABLE_DEFINITION=( "values_network_wireless_channel" "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" - "value varchar(255) NOT NULL" + "value varchar(255) DEFAULT NULL" "enabled tinyint(1) NOT NULL DEFAULT '1'" ) sql_create_table @@ -382,7 +382,7 @@ TABLE_DEFINITION=( "values_network_wireless_frequency" "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" - "value varchar(255) NOT NULL" + "value varchar(255) DEFAULT NULL" "enabled tinyint(1) NOT NULL DEFAULT '1'" ) sql_create_table @@ -390,7 +390,7 @@ TABLE_DEFINITION=( "values_network_wireless_key_length" "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" - "value varchar(255) NOT NULL" + "value varchar(255) DEFAULT NULL" "enabled tinyint(1) NOT NULL DEFAULT '1'" ) sql_create_table @@ -398,7 +398,7 @@ TABLE_DEFINITION=( "values_network_wireless_mode" "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" - "value varchar(255) NOT NULL" + "value varchar(255) DEFAULT NULL" "enabled tinyint(1) NOT NULL DEFAULT '1'" ) sql_create_table @@ -406,7 +406,7 @@ TABLE_DEFINITION=( "values_printers_port" "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" - "value varchar(255) NOT NULL" + "value varchar(255) DEFAULT NULL" "enabled tinyint(1) NOT NULL DEFAULT '1'" ) sql_create_table @@ -414,7 +414,7 @@ TABLE_DEFINITION=( "values_screensaver_screensaver" "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" - "value varchar(255) NOT NULL" + "value varchar(255) DEFAULT NULL" "enabled tinyint(1) NOT NULL DEFAULT '1'" ) sql_create_table @@ -422,9 +422,9 @@ TABLE_DEFINITION=( "values_storefront_session" "id int(255) NOT NULL PRIMARY KEY AUTO_INCREMENT" - "session varchar(255) NOT NULL" + "session varchar(255) DEFAULT NULL" "description varchar(255) DEFAULT NULL" - "store varchar(255) NOT NULL" + "store varchar(255) DEFAULT NULL" "enabled tinyint(1) NOT NULL DEFAULT '1'" ) sql_create_table