create_database_schema()
{
	TABLE_DEFINITION=(
		"meta"
			"version int(11) NOT NULL PRIMARY KEY"
	)
	sql_create_table

	TABLE_DEFINITION=(
		"cfg_autostart"
			"id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
			"serial int(11) NOT NULL"
			"name varchar(255) NOT NULL"
			"exec varchar(255) DEFAULT NULL"
			"enabled tinyint(1) NOT NULL DEFAULT '1'"
			"flg_modified tinyint(1) NOT NULL DEFAULT '0'"
	)
	sql_create_table

	TABLE_DEFINITION=(
		"cfg_citrix_serverlist"
			"id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
			"serial int(11) NOT NULL"
			"host varchar(255) NOT NULL"
			"enabled tinyint(1) NOT NULL DEFAULT '1'"
	)
	sql_create_table

	TABLE_DEFINITION=(
		"cfg_comments"
			"id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
			"serial int(11) NOT NULL"
			"txt text"
	)
	sql_create_table

	TABLE_DEFINITION=(
		"cfg_fluxbox_autostart"
			"id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
			"serial int(11) NOT NULL"
			"name varchar(255) NOT NULL"
			"exec varchar(255) NOT NULL"
			"comment varchar(255) DEFAULT NULL"
	)
	sql_create_table

	TABLE_DEFINITION=(
		"cfg_fluxbox_menuitem"
			"id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
			"serial int(11) NOT NULL"
			"name varchar(255) NOT NULL"
			"exec varchar(255) NOT NULL"
			"workdir varchar(255) DEFAULT NULL"
			"icon varchar(255) DEFAULT NULL"
			"enabled tinyint(1) NOT NULL DEFAULT '1'"
	)
	sql_create_table

	TABLE_DEFINITION=(
		"cfg_fluxbox_theme"
			"id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
			"serial int(11) NOT NULL"
			"theme varchar(255) NOT NULL"
	)
	sql_create_table

	TABLE_DEFINITION=(
		"cfg_graphic"
			"serial int(11) NOT NULL PRIMARY KEY"
			"resolution varchar(255) DEFAULT NULL"
			"depth varchar(288) DEFAULT NULL"
			"monitorid int(11) DEFAULT NULL"
			"refresh_rate int(3) NOT NULL DEFAULT '60'"
			"module varchar(255) DEFAULT NULL"
			"hdmi varchar(10) NOT NULL DEFAULT 'disable'"
	)
	sql_create_table

	TABLE_DEFINITION=(
		"cfg_idesk_icon"
			"id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
			"serial int(11) NOT NULL"
			"name varchar(255) NOT NULL"
			"command varchar(255) NOT NULL"
			"icon varchar(255) NOT NULL"
			"filename varchar(255) NOT NULL"
			"xpos varchar(255) NOT NULL"
			"ypos varchar(255) NOT NULL"
			"width varchar(255) NOT NULL"
			"height varchar(255) NOT NULL"
			"default_icon varchar(255) NOT NULL"
			"enabled tinyint(1) NOT NULL DEFAULT '1'"
	)
	sql_create_table

	TABLE_DEFINITION=(
		"cfg_input"
			"serial int(11) NOT NULL PRIMARY KEY"
			"keymap varchar(255) DEFAULT NULL"
	)
	sql_create_table

	TABLE_DEFINITION=(
		"cfg_modules"
			"id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
			"serial int(11) NOT NULL"
			"module varchar(255) DEFAULT NULL"
			"arg varchar(255) DEFAULT NULL"
	)
	sql_create_table

	TABLE_DEFINITION=(
		"cfg_network"
			"serial int(11) NOT NULL PRIMARY KEY"
			"hostname varchar(255) DEFAULT NULL"
			"domain varchar(255) DEFAULT NULL"
			"networking varchar(255) DEFAULT NULL"
			"netmask varchar(255) DEFAULT NULL"
			"dns varchar(255) DEFAULT NULL"
			"gateway varchar(255) DEFAULT NULL"
			"broadcast varchar(255) DEFAULT NULL"
			"ip varchar(255) DEFAULT NULL"
			"module varchar(255) DEFAULT NULL"
			"forcemacto varchar(17) DEFAULT NULL"
			"wireless_bitrate varchar(5) DEFAULT NULL"
			"wireless_channel varchar(10) DEFAULT NULL"
			"wireless_essid varchar(255) DEFAULT NULL"
			"wireless_frequency varchar(255) DEFAULT NULL"
			"wireless_mode varchar(255) DEFAULT NULL"
			"wireless_nick varchar(255) DEFAULT NULL"
			"wireless_auth_mode varchar(255) DEFAULT NULL"
			"wireless_key_length varchar(255) DEFAULT NULL"
			"wireless_key text"
			"wireless_key_ascii text"
	)
	sql_create_table

	TABLE_DEFINITION=(
		"cfg_other_menuitems"
			"id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
			"serial int(11) NOT NULL"
			"name varchar(255) DEFAULT NULL"
			"exec varchar(255) DEFAULT NULL"
			"workdir varchar(255) DEFAULT NULL"
			"icon varchar(255) DEFAULT NULL"
	)
	sql_create_table

	TABLE_DEFINITION=(
		"cfg_printers"
			"id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
			"serial int(11) NOT NULL"
			"printer_name varchar(255) NOT NULL"
			"port varchar(255) NOT NULL"
			"enabled tinyint(1) NOT NULL DEFAULT '1'"
	)
	sql_create_table

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

	TABLE_DEFINITION=(
		"cfg_screensaver"
			"serial int(11) NOT NULL PRIMARY KEY"
			"screensaver varchar(255) NOT NULL"
			"timeout int(11) DEFAULT '10'"
			"password varchar(255) DEFAULT NULL"
	)
	sql_create_table

	TABLE_DEFINITION=(
		"cfg_sessions_citrix"
			"id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
			"serial int(11) NOT NULL"
			"name varchar(255) NOT NULL"
			"session varchar(255) NOT NULL"
			"filename varchar(255) DEFAULT NULL"
			"username varchar(255) DEFAULT NULL"
			"domain varchar(255) DEFAULT NULL"
			"password varchar(255) DEFAULT NULL"
			"serverlist varchar(255) NOT 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

	TABLE_DEFINITION=(
		"cfg_sessions_rdesktop"
			"id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
			"serial int(11) 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

	TABLE_DEFINITION=(
		"cfg_sessions_storefront"
			"id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
			"serial int(11) NOT NULL"
			"name varchar(255) NOT NULL"
			"session varchar(255) NOT NULL"
			"filename varchar(255) DEFAULT NULL"
			"username varchar(255) DEFAULT NULL"
			"domain varchar(255) DEFAULT NULL"
			"password varchar(255) DEFAULT NULL"
			"store varchar(255) NOT 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

	TABLE_DEFINITION=(
		"cfg_storefront_store"
			"id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
			"serial int(11) NOT NULL"
			"store varchar(255) NOT NULL"
			"enabled tinyint(1) NOT NULL DEFAULT '1'"
	)
	sql_create_table

	TABLE_DEFINITION=(
		"cfg_vnc"
			"serial int(11) NOT NULL PRIMARY KEY"
			"service tinyint(1) NOT NULL DEFAULT '1'"
	)
	sql_create_table

	TABLE_DEFINITION=(
		"client_auth"
			"serial int(11) NOT NULL PRIMARY KEY"
			"user varchar(255) DEFAULT NULL"
			"root varchar(255) DEFAULT NULL"
			"vnc varchar(255) DEFAULT NULL"
	)
	sql_create_table

	TABLE_DEFINITION=(
		"client_location"
			"location varchar(255) NOT NULL PRIMARY KEY"
			"controlserver varchar(255) NOT NULL"
			"pxe_default_entry varchar(255) NOT NULL"
			"pxe_prompt tinyint(1) NOT NULL"
			"pxe_timeout smallint(1) NOT NULL"
			"updateserver varchar(255) NOT NULL"
			"username varchar(255) NOT NULL"
			"password varchar(255) NOT NULL"
			"rsync varchar(255) NOT NULL"
			"repository varchar(255) NOT NULL"
			"helpdesk_unit varchar(255) NOT NULL"
			"helpdesk_phone varchar(255) NOT NULL"
			"set_default tinyint(1) NOT NULL DEFAULT '0'"
			"enabled tinyint(1) NOT NULL DEFAULT '1'"
	)
	sql_create_table

	TABLE_DEFINITION=(
		"client_serials"
			"serial int(11) NOT NULL PRIMARY KEY"
			"location varchar(255) NOT NULL"
			"mtime int(11) DEFAULT NULL"
			"mac varchar(17) NOT NULL"
			"hwdetected tinyint(1) NOT NULL DEFAULT '0'"
			"enabled tinyint(1) NOT NULL DEFAULT '1'"
	)
	sql_create_table

	TABLE_DEFINITION=(
		"client_version"
			"serial int(11) NOT NULL PRIMARY KEY"
			"os varchar(50) NOT NULL"
			"utils varchar(50) NOT NULL"
	)
	sql_create_table

	TABLE_DEFINITION=(
		"state_connected"
			"id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
			"mtime int(11) DEFAULT NULL"
			"serial int(11) NOT NULL"
			"ip varchar(255) DEFAULT NULL"
			"mac varchar(255) DEFAULT NULL"
			"netboot tinyint(1) NOT NULL DEFAULT '0'"
	)
	sql_create_table

	TABLE_DEFINITION=(
		"values_storefront_store"
			"id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
			"name varchar(255) NOT NULL"
			"store varchar(255) NOT NULL"
			"user varchar(255) DEFAULT NULL"
			"password varchar(255) DEFAULT NULL"
			"domain varchar(255) DEFAULT NULL"
			"enabled tinyint(1) NOT NULL DEFAULT '1'"
	)
	sql_create_table

	TABLE_DEFINITION=(
		"values_citrix_session"
			"id int(255) NOT NULL PRIMARY KEY AUTO_INCREMENT"
			"session varchar(255) NOT NULL"
			"description varchar(255) DEFAULT NULL"
			"enabled tinyint(1) NOT NULL DEFAULT '1'"
	)
	sql_create_table

	TABLE_DEFINITION=(
		"values_graphic_depth"
			"id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
			"value varchar(255) NOT NULL"
			"enabled tinyint(1) NOT NULL DEFAULT '1'"
	)
	sql_create_table

	TABLE_DEFINITION=(
		"values_graphic_module"
			"id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
			"value varchar(255) NOT NULL"
			"enabled tinyint(1) NOT NULL DEFAULT '1'"
	)
	sql_create_table

	TABLE_DEFINITION=(
		"values_graphic_refresh_rate"
			"id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
			"value varchar(255) NOT NULL"
			"enabled tinyint(1) NOT NULL DEFAULT '1'"
	)
	sql_create_table

	TABLE_DEFINITION=(
		"values_graphic_resolution"
			"id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
			"value varchar(255) NOT NULL"
			"enabled tinyint(1) NOT NULL DEFAULT '1'"
	)
	sql_create_table

	TABLE_DEFINITION=(
		"values_input_keymap"
			"id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
			"value varchar(255) NOT NULL"
			"enabled tinyint(1) NOT NULL DEFAULT '1'"
	)
	sql_create_table

	TABLE_DEFINITION=(
		"values_network_module"
			"id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
			"value varchar(255) NOT NULL"
			"enabled tinyint(1) NOT NULL DEFAULT '1'"
	)
	sql_create_table

	TABLE_DEFINITION=(
		"values_printers_port"
			"id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
			"value varchar(255) NOT NULL"
			"enabled tinyint(1) NOT NULL DEFAULT '1'"
	)
	sql_create_table

	TABLE_DEFINITION=(
		"values_screensaver_screensaver"
			"id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT"
			"value varchar(255) NOT NULL"
			"enabled tinyint(1) NOT NULL DEFAULT '1'"
	)
	sql_create_table

	TABLE_DEFINITION=(
		"values_storefront_session"
			"id int(255) NOT NULL PRIMARY KEY AUTO_INCREMENT"
			"session varchar(255) NOT NULL"
			"description varchar(255) DEFAULT NULL"
			"store varchar(255) NOT NULL"
			"enabled tinyint(1) NOT NULL DEFAULT '1'"
	)
	sql_create_table
}