-- -------------------------------------

CREATE TABLE PLZ_LANGUAGES (
	code TINYINT UNSIGNED NOT NULL ,
	language VARCHAR( 15 ) NOT NULL ,
--
	PRIMARY KEY ( code )
) ENGINE = InnoDB CHARACTER SET latin1 COLLATE latin1_general_ci ;

-- -------------------------------------

CREATE TABLE STY_STREETS (
	id SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT ,
	no SMALLINT UNSIGNED NOT NULL ,
	postcode_base SMALLINT UNSIGNED NOT NULL ,
	language_code TINYINT UNSIGNED NULL ,
	name_upcase VARCHAR ( 25 ) NOT NULL ,
	postcode_addressing SMALLINT UNSIGNED NOT NULL ,
	splitting_code TINYINT UNSIGNED NOT NULL ,
	house_nr SMALLINT UNSIGNED NULL ,
	house_nr2 VARCHAR ( 2 ) NULL ,
	house_nr3 SMALLINT UNSIGNED NULL ,
	house_nr4 VARCHAR ( 2 ) NULL ,
	name VARCHAR ( 25 ) NOT NULL ,
	name_root VARCHAR ( 10 ) NOT NULL ,
	street_type CHAR ( 2 ) NOT NULL ,
	prefix_code CHAR ( 2 ) NOT NULL ,
--
	PRIMARY KEY ( id ) ,
	KEY language_code ( language_code ) ,
	KEY street_type ( street_type ) ,
	KEY prefix_code ( prefix_code )
) ENGINE = InnoDB CHARACTER SET latin1 COLLATE latin1_general_ci ;

-- -------------------------------------

INSERT INTO PLZ_LANGUAGES (code, language) VALUES(1, 'deutsch');
INSERT INTO PLZ_LANGUAGES (code, language) VALUES(2, 'französisch');
INSERT INTO PLZ_LANGUAGES (code, language) VALUES(3, 'italienisch');