BeWoPlaner/Model/Alt/changes 15-10-27.sql

CREATE TABLE `behinderungsart2customer` (
	`Oid` BIGINT(19) NOT NULL AUTO_INCREMENT,
	`Behinderungsart` TINYINT(4) DEFAULT NULL,
	`CustomerOid` BIGINT(19) DEFAULT NULL,
	PRIMARY KEY (`Oid`),
	KEY `BEHINDERUNGSART_CUSTOMER_FK` (`CustomerOid`),
	CONSTRAINT `FK_BEHINDERUNGSART_CUSTOMER` FOREIGN KEY (`CustomerOid`) REFERENCES `Customer` (`Oid`) ON DELETE NO ACTION ON UPDATE NO ACTION
)ENGINE=InnoDB
AUTO_INCREMENT=1 CHARACTER SET 'latin1' COLLATE 'latin1_swedish_ci';

CREATE TABLE `merkzeichen2customer` (
	`Oid` BIGINT(19) NOT NULL AUTO_INCREMENT,
	`Merkzeichen` TINYINT(4) DEFAULT NULL,
	`CustomerOid` BIGINT(19) DEFAULT NULL,
	PRIMARY KEY (`Oid`),
	KEY `MERKZEICHEN_CUSTOMER_FK` (`CustomerOid`),
	CONSTRAINT `FK_MERKZEICHEN_CUSTOMER` FOREIGN KEY (`CustomerOid`) REFERENCES `Customer` (`Oid`) ON DELETE NO ACTION ON UPDATE NO ACTION
)ENGINE=InnoDB
AUTO_INCREMENT=1 CHARACTER SET 'latin1' COLLATE 'latin1_swedish_ci';

ALTER TABLE customer ADD COLUMN `AusstVersAmt` VARCHAR(1024) DEFAULT NULL;
ALTER TABLE customer ADD COLUMN `AusweisGueltigVon` DATETIME DEFAULT NULL;
ALTER TABLE customer ADD COLUMN `AusweisGueltigBis` DATETIME DEFAULT NULL;
ALTER TABLE customer ADD COLUMN `AusweisUnbefristetGueltig` TINYINT(1) DEFAULT NULL;
ALTER TABLE customer ADD COLUMN `BeiblattGueltigBis` DATETIME DEFAULT NULL;
ALTER TABLE customer ADD COLUMN `GradDerBehinderung` VARCHAR(1024) DEFAULT NULL;