| /[alx-svn]/alx-src/branches/alx-web-070/scripts/sql-schema/include/update_to_database_schema_version_2.sh |
Annotation of /alx-src/branches/alx-web-070/scripts/sql-schema/include/update_to_database_schema_version_2.sh
Parent Directory
| 
Revision Log
Revision 8486 -
(hide annotations)
(download)
(as text)
Fri Feb 5 12:28:33 2016 UTC (8 years, 3 months ago) by niro
File MIME type: application/x-sh
File size: 738 byte(s)
Fri Feb 5 12:28:33 2016 UTC (8 years, 3 months ago) by niro
File MIME type: application/x-sh
File size: 738 byte(s)
-added update_to_database_schema_version_2 script
| 1 | niro | 8486 | update_to_database_schema_version_2() |
| 2 | { | ||
| 3 | TABLE_DEFINITION=( | ||
| 4 | "cfg_scm_egk" | ||
| 5 | "serial int(11) NOT NULL PRIMARY KEY" | ||
| 6 | "facility tinyint(1) NOT NULL DEFAULT '1'" | ||
| 7 | ) | ||
| 8 | sql_create_table | ||
| 9 | |||
| 10 | TABLE_DEFINITION=( | ||
| 11 | "cfg_sessions_rdesktop" | ||
| 12 | "id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT" | ||
| 13 | "serial int(11) NOT NULL" | ||
| 14 | "name varchar(255) NOT NULL" | ||
| 15 | "server varchar(255) NOT NULL" | ||
| 16 | "filename varchar(255) DEFAULT NULL" | ||
| 17 | "username varchar(255) DEFAULT NULL" | ||
| 18 | "password varchar(255) DEFAULT NULL" | ||
| 19 | "domain varchar(255) DEFAULT NULL" | ||
| 20 | "shell varchar(255) DEFAULT NULL" | ||
| 21 | "autostart tinyint(1) NOT NULL DEFAULT '0'" | ||
| 22 | "enabled tinyint(1) NOT NULL DEFAULT '1'" | ||
| 23 | "flg_modified tinyint(1) NOT NULL DEFAULT '0'" | ||
| 24 | ) | ||
| 25 | sql_create_table | ||
| 26 | } |