| /[alx-svn]/alx-src/branches/alx-web-070/scripts/sql-schema/include/update_to_database_schema_version_3.sh |
Annotation of /alx-src/branches/alx-web-070/scripts/sql-schema/include/update_to_database_schema_version_3.sh
Parent Directory
| 
Revision Log
Revision 8492 -
(hide 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 | niro | 8492 | 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 | } |