/[alx-svn]/alx-src/branches/alx-web-070/scripts/sql-schema/include/update_to_database_schema_version_2.sh |
Contents of /alx-src/branches/alx-web-070/scripts/sql-schema/include/update_to_database_schema_version_2.sh
Parent Directory | Revision Log
Revision 8486 -
(show annotations)
(download)
(as text)
Fri Feb 5 12:28:33 2016 UTC (8 years, 4 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, 4 months ago) by niro
File MIME type: application/x-sh
File size: 738 byte(s)
-added update_to_database_schema_version_2 script
1 | 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 | } |