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	update_to_database_schema_version_2()
2	{
3	TABLE_DEFINITION=(
4	"cfg_scm_egk"
5	"serial int(255) 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(255) NOT NULL PRIMARY KEY AUTO_INCREMENT"
13	"serial int(255) 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	}