CREATE DATABASE `mydb` /*!40100 COLLATE 'utf8_general_ci' */

CREATE TABLE `em_region` (
	`em_regionId` TINYINT(3) UNSIGNED NOT NULL AUTO_INCREMENT,
	`em_regionName` VARCHAR(50) NOT NULL DEFAULT '',
	`em_regionType` ENUM('gfz','rpb','kri','sob','aob','aok','art') NOT NULL DEFAULT 'sob',
	PRIMARY KEY (`em_regionId`),
	UNIQUE INDEX `u_regionName` (`em_regionName`)
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB
AUTO_INCREMENT=85;

character_set_client utf8 | utf8
character_set_connection utf8 | utf8
character_set_database utf8 | utf8
character_set_results utf8 | utf8
character_set_server utf8 | utf8
character_set_system utf8 | utf8
collation_connection utf8_general_ci | utf8_general_ci
collation_database utf8_general_ci | utf8_general_ci
collation_server utf8_general_ci | utf8_general_ci