sql-schema/include/update_to_database_schema_version_2.sh

update_to_database_schema_version_2()
{
	TABLE_DEFINITION=(
		"cfg_scm_egk"
			"serial int(255) NOT NULL PRIMARY KEY"
			"facility tinyint(1) NOT NULL DEFAULT '1'"
	)
	sql_create_table

	TABLE_DEFINITION=(
		"cfg_sessions_rdesktop"
			"id int(255) NOT NULL PRIMARY KEY AUTO_INCREMENT"
			"serial int(255) NOT NULL"
			"name varchar(255) NOT NULL"
			"server varchar(255) NOT NULL"
			"filename varchar(255) DEFAULT NULL"
			"username varchar(255) DEFAULT NULL"
			"password varchar(255) DEFAULT NULL"
			"domain varchar(255) DEFAULT NULL"
			"shell varchar(255) DEFAULT NULL"
			"autostart tinyint(1) NOT NULL DEFAULT '0'"
			"enabled tinyint(1) NOT NULL DEFAULT '1'"
			"flg_modified tinyint(1) NOT NULL DEFAULT '0'"
	)
	sql_create_table
}
1	niro	8486	update_to_database_schema_version_2()
2			{
3			TABLE_DEFINITION=(
4			"cfg_scm_egk"
5	niro	8491	"serial int(255) NOT NULL PRIMARY KEY"
6	niro	8486	"facility tinyint(1) NOT NULL DEFAULT '1'"
7			)
8			sql_create_table
9
10			TABLE_DEFINITION=(
11			"cfg_sessions_rdesktop"
12	niro	8491	"id int(255) NOT NULL PRIMARY KEY AUTO_INCREMENT"
13			"serial int(255) NOT NULL"
14	niro	8486	"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			}