| /[alx-svn]/alx-src/branches/alx-web-070/scripts/sql-schema/include/update_to_database_schema_version_3.sh |
Contents of /alx-src/branches/alx-web-070/scripts/sql-schema/include/update_to_database_schema_version_3.sh
Parent Directory
| 
Revision Log
Revision 8492 -
(show annotations)
(download)
(as text)
Fri Feb 5 13:17:28 2016 UTC (8 years, 3 months ago) by niro
File MIME type: application/x-sh
File size: 1646 byte(s)
Fri Feb 5 13:17:28 2016 UTC (8 years, 3 months ago) by niro
File MIME type: application/x-sh
File size: 1646 byte(s)
-added update_to_database_schema_version_3 script
| 1 | update_to_database_schema_version_3() |
| 2 | { |
| 3 | TABLE_DEFINITION=( |
| 4 | "cfg_citrix_serverlist" |
| 5 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" |
| 6 | "serial int(11) NOT NULL" |
| 7 | ) |
| 8 | sql_modify_column |
| 9 | |
| 10 | TABLE_DEFINITION=( |
| 11 | "cfg_comments" |
| 12 | "txt text" |
| 13 | ) |
| 14 | sql_modify_column |
| 15 | |
| 16 | TABLE_DEFINITION=( |
| 17 | "cfg_fluxbox_autostart" |
| 18 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" |
| 19 | "serial int(11) NOT NULL" |
| 20 | "comment varchar(255) DEFAULT NULL" |
| 21 | ) |
| 22 | sql_modify_column |
| 23 | |
| 24 | TABLE_DEFINITION=( |
| 25 | "cfg_fluxbox_menuitem" |
| 26 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" |
| 27 | "serial int(11) NOT NULL" |
| 28 | "workdir varchar(255) DEFAULT NULL" |
| 29 | "icon varchar(255) DEFAULT NULL" |
| 30 | ) |
| 31 | sql_modify_column |
| 32 | |
| 33 | TABLE_DEFINITION=( |
| 34 | "cfg_fluxbox_theme" |
| 35 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" |
| 36 | "serial int(11) NOT NULL" |
| 37 | ) |
| 38 | sql_modify_column |
| 39 | |
| 40 | TABLE_DEFINITION=( |
| 41 | "cfg_idesk_icon" |
| 42 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" |
| 43 | "serial int(11) NOT NULL" |
| 44 | ) |
| 45 | sql_modify_column |
| 46 | |
| 47 | TABLE_DEFINITION=( |
| 48 | "cfg_scm_egk" |
| 49 | "serial int(11) NOT NULL PRIMARY KEY" |
| 50 | ) |
| 51 | sql_modify_column |
| 52 | |
| 53 | TABLE_DEFINITION=( |
| 54 | "cfg_sessions_rdesktop" |
| 55 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" |
| 56 | "serial int(11) NOT NULL" |
| 57 | ) |
| 58 | sql_modify_column |
| 59 | |
| 60 | TABLE_DEFINITION=( |
| 61 | "cfg_storefront_store" |
| 62 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" |
| 63 | "serial int(11) NOT NULL" |
| 64 | ) |
| 65 | sql_modify_column |
| 66 | |
| 67 | TABLE_DEFINITION=( |
| 68 | "cfg_vnc" |
| 69 | "serial int(11) NOT NULL PRIMARY KEY" |
| 70 | ) |
| 71 | sql_modify_column |
| 72 | |
| 73 | TABLE_DEFINITION=( |
| 74 | "client_serials" |
| 75 | "mac varchar(17) NOT NULL" |
| 76 | ) |
| 77 | sql_modify_column |
| 78 | |
| 79 | TABLE_DEFINITION=( |
| 80 | "state_connected" |
| 81 | "serial int(11) NOT NULL" |
| 82 | ) |
| 83 | sql_modify_column |
| 84 | } |