| /[alx-svn]/alx-src/branches/alx-web-070/scripts/sql-schema/include/update_to_database_schema_version_16.sh |
Contents of /alx-src/branches/alx-web-070/scripts/sql-schema/include/update_to_database_schema_version_16.sh
Parent Directory
| 
Revision Log
Revision 14432 -
(show annotations)
(download)
(as text)
Wed Jul 15 09:14:42 2020 UTC (3 years, 10 months ago) by niro
File MIME type: application/x-sh
File size: 4386 byte(s)
Wed Jul 15 09:14:42 2020 UTC (3 years, 10 months ago) by niro
File MIME type: application/x-sh
File size: 4386 byte(s)
-update database schema to version 16, updated serveral default values to satisfy mariadb-10.4.x
| 1 | update_to_database_schema_version_16() |
| 2 | { |
| 3 | TABLE_DEFINITION=( |
| 4 | "cfg_citrix_serverlist" |
| 5 | "serial int(11) DEFAULT NULL" |
| 6 | "host varchar(255) DEFAULT NULL" |
| 7 | ) |
| 8 | sql_modify_column |
| 9 | |
| 10 | TABLE_DEFINITION=( |
| 11 | "cfg_fluxbox_autostart" |
| 12 | "name varchar(255) DEFAULT NULL" |
| 13 | "exec varchar(255) DEFAULT NULL" |
| 14 | ) |
| 15 | sql_modify_column |
| 16 | |
| 17 | TABLE_DEFINITION=( |
| 18 | "cfg_fluxbox_menuitem" |
| 19 | "name varchar(255) DEFAULT NULL" |
| 20 | "exec varchar(255) DEFAULT NULL" |
| 21 | ) |
| 22 | sql_modify_column |
| 23 | |
| 24 | TABLE_DEFINITION=( |
| 25 | "cfg_fluxbox_theme" |
| 26 | "theme varchar(255) DEFAULT NULL" |
| 27 | ) |
| 28 | sql_modify_column |
| 29 | |
| 30 | TABLE_DEFINITION=( |
| 31 | "cfg_idesk_icon" |
| 32 | "name varchar(255) DEFAULT NULL" |
| 33 | "command varchar(255) DEFAULT NULL" |
| 34 | "icon varchar(255) DEFAULT NULL" |
| 35 | "filename varchar(255) DEFAULT NULL" |
| 36 | "xpos varchar(255) DEFAULT NULL" |
| 37 | "ypos varchar(255) DEFAULT NULL" |
| 38 | "width varchar(255) DEFAULT NULL" |
| 39 | "height varchar(255) DEFAULT NULL" |
| 40 | "default_icon varchar(255) DEFAULT NULL" |
| 41 | ) |
| 42 | sql_modify_column |
| 43 | |
| 44 | TABLE_DEFINITION=( |
| 45 | "cfg_printers" |
| 46 | "printer_name varchar(255) DEFAULT NULL" |
| 47 | "port varchar(255) DEFAULT NULL" |
| 48 | ) |
| 49 | sql_modify_column |
| 50 | |
| 51 | TABLE_DEFINITION=( |
| 52 | "cfg_screensaver" |
| 53 | "screensaver varchar(255) DEFAULT NULL" |
| 54 | ) |
| 55 | sql_modify_column |
| 56 | |
| 57 | TABLE_DEFINITION=( |
| 58 | "cfg_sessions_citrix" |
| 59 | "name varchar(255) DEFAULT NULL" |
| 60 | "session varchar(255) DEFAULT NULL" |
| 61 | "serverlist varchar(255) DEFAULT NULL" |
| 62 | ) |
| 63 | sql_modify_column |
| 64 | |
| 65 | TABLE_DEFINITION=( |
| 66 | "cfg_sessions_rdesktop" |
| 67 | "name varchar(255) DEFAULT NULL" |
| 68 | "server varchar(255) DEFAULT NULL" |
| 69 | ) |
| 70 | sql_modify_column |
| 71 | |
| 72 | TABLE_DEFINITION=( |
| 73 | "cfg_sessions_storefront" |
| 74 | "name varchar(255) DEFAULT NULL" |
| 75 | "session varchar(255) DEFAULT NULL" |
| 76 | "store varchar(255) DEFAULT NULL" |
| 77 | ) |
| 78 | sql_modify_column |
| 79 | |
| 80 | TABLE_DEFINITION=( |
| 81 | "cfg_storefront_store" |
| 82 | "store varchar(255) DEFAULT NULL" |
| 83 | ) |
| 84 | sql_modify_column |
| 85 | |
| 86 | TABLE_DEFINITION=( |
| 87 | "client_locations" |
| 88 | "bootserver varchar(255) DEFAULT NULL" |
| 89 | "controlserver varchar(255) DEFAULT NULL" |
| 90 | "pxe_default_entry varchar(255) DEFAULT NULL" |
| 91 | "pxe_prompt tinyint(1) NOT NULL DEFAULT '0'" |
| 92 | "pxe_timeout smallint(1) NOT NULL DEFAULT '300'" |
| 93 | "updateserver varchar(255) DEFAULT NULL" |
| 94 | "username varchar(255) DEFAULT NULL" |
| 95 | "password varchar(255) DEFAULT NULL" |
| 96 | "rsync varchar(255) DEFAULT NULL" |
| 97 | "repository varchar(255) DEFAULT NULL" |
| 98 | "helpdesk_unit varchar(255) DEFAULT NULL" |
| 99 | "helpdesk_phone varchar(255) DEFAULT NULL" |
| 100 | ) |
| 101 | sql_modify_column |
| 102 | |
| 103 | TABLE_DEFINITION=( |
| 104 | "values_storefront_store" |
| 105 | "name varchar(255) DEFAULT NULL" |
| 106 | "store varchar(255) DEFAULT NULL" |
| 107 | ) |
| 108 | sql_modify_column |
| 109 | |
| 110 | TABLE_DEFINITION=( |
| 111 | "values_citrix_session" |
| 112 | "session varchar(255) DEFAULT NULL" |
| 113 | ) |
| 114 | sql_modify_column |
| 115 | |
| 116 | TABLE_DEFINITION=( |
| 117 | "values_graphic_depth" |
| 118 | "value varchar(255) DEFAULT NULL" |
| 119 | ) |
| 120 | sql_modify_column |
| 121 | |
| 122 | TABLE_DEFINITION=( |
| 123 | "values_graphic_module" |
| 124 | "value varchar(255) DEFAULT NULL" |
| 125 | ) |
| 126 | sql_modify_column |
| 127 | |
| 128 | TABLE_DEFINITION=( |
| 129 | "values_graphic_refresh_rate" |
| 130 | "value varchar(255) DEFAULT NULL" |
| 131 | ) |
| 132 | sql_modify_column |
| 133 | |
| 134 | TABLE_DEFINITION=( |
| 135 | "values_graphic_resolution" |
| 136 | "value varchar(255) DEFAULT NULL" |
| 137 | ) |
| 138 | sql_modify_column |
| 139 | |
| 140 | TABLE_DEFINITION=( |
| 141 | "values_input_keymap" |
| 142 | "value varchar(255) DEFAULT NULL" |
| 143 | ) |
| 144 | sql_modify_column |
| 145 | |
| 146 | TABLE_DEFINITION=( |
| 147 | "values_network_module" |
| 148 | "value varchar(255) DEFAULT NULL" |
| 149 | ) |
| 150 | sql_modify_column |
| 151 | |
| 152 | TABLE_DEFINITION=( |
| 153 | "values_network_wireless_auth_mode" |
| 154 | "value varchar(255) DEFAULT NULL" |
| 155 | ) |
| 156 | sql_modify_column |
| 157 | |
| 158 | TABLE_DEFINITION=( |
| 159 | "values_network_wireless_bitrate" |
| 160 | "value varchar(255) DEFAULT NULL" |
| 161 | ) |
| 162 | sql_modify_column |
| 163 | |
| 164 | TABLE_DEFINITION=( |
| 165 | "values_network_wireless_channel" |
| 166 | "value varchar(255) DEFAULT NULL" |
| 167 | ) |
| 168 | sql_modify_column |
| 169 | |
| 170 | TABLE_DEFINITION=( |
| 171 | "values_network_wireless_frequency" |
| 172 | "value varchar(255) DEFAULT NULL" |
| 173 | ) |
| 174 | sql_modify_column |
| 175 | |
| 176 | TABLE_DEFINITION=( |
| 177 | "values_network_wireless_key_length" |
| 178 | "value varchar(255) DEFAULT NULL" |
| 179 | ) |
| 180 | sql_modify_column |
| 181 | |
| 182 | TABLE_DEFINITION=( |
| 183 | "values_network_wireless_mode" |
| 184 | "value varchar(255) DEFAULT NULL" |
| 185 | ) |
| 186 | sql_modify_column |
| 187 | |
| 188 | TABLE_DEFINITION=( |
| 189 | "values_printers_port" |
| 190 | "value varchar(255) DEFAULT NULL" |
| 191 | ) |
| 192 | sql_modify_column |
| 193 | |
| 194 | TABLE_DEFINITION=( |
| 195 | "values_screensaver_screensaver" |
| 196 | "value varchar(255) DEFAULT NULL" |
| 197 | ) |
| 198 | sql_modify_column |
| 199 | |
| 200 | TABLE_DEFINITION=( |
| 201 | "values_storefront_session" |
| 202 | "session varchar(255) DEFAULT NULL" |
| 203 | "store varchar(255) DEFAULT NULL" |
| 204 | ) |
| 205 | sql_modify_column |
| 206 | } |