Zusammenfassung

DROP DATABASE IF EXISTS `db_test`;

CREATE DATABASE IF NOT EXISTS
db_test
CHARACTER SET latin1
COLLATE latin1_swedish_ci;

USE db_test;

CREATE TABLE IF NOT EXISTS
person (
	`PersonID` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
	`Name` VARCHAR(50) NOT NULL,
	PRIMARY KEY (`PersonID`)
)
COLLATE='latin1_german1_ci'
ENGINE=InnoDB;

CREATE TABLE IF NOT EXISTS
orte (
	`OrtID` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
	`OrtName` VARCHAR(50) NOT NULL,
	PRIMARY KEY (`OrtID`)
)
COLLATE='latin1_german1_ci'
ENGINE=InnoDB;

ALTER TABLE 
`person`
	ADD COLUMN `OrtID` INT UNSIGNED NOT NULL,
	ADD CONSTRAINT `FK_person_orte` FOREIGN KEY (`OrtID`) REFERENCES `orte` (`OrtID`);