24 lines
1.0 KiB
Plaintext
24 lines
1.0 KiB
Plaintext
ALTER TABLE `organisation`
|
|
ADD COLUMN `HausanschriftAddressOid` BIGINT NULL DEFAULT NULL AFTER `CostBearerOid`,
|
|
ADD COLUMN `PostfachanschriftAddressOid` BIGINT NULL DEFAULT NULL AFTER `HausanschriftAddressOid`,
|
|
ADD COLUMN `GrosskundenanschriftAddressOid` BIGINT NULL DEFAULT NULL AFTER `PostfachanschriftAddressOid`,
|
|
ADD INDEX `FK_ORGANISA_HAUSADD_idx` (`HausanschriftAddressOid` ASC) VISIBLE,
|
|
ADD INDEX `FK_ORGANISA_POSTADD_idx` (`PostfachanschriftAddressOid` ASC) VISIBLE,
|
|
ADD INDEX `FK_ORGANISA_GROSADD_idx` (`GrosskundenanschriftAddressOid` ASC) VISIBLE;
|
|
;
|
|
ALTER TABLE `organisation`
|
|
ADD CONSTRAINT `FK_ORGANISA_HAUSADD`
|
|
FOREIGN KEY (`HausanschriftAddressOid`)
|
|
REFERENCES `address` (`Oid`)
|
|
ON DELETE CASCADE
|
|
ON UPDATE CASCADE,
|
|
ADD CONSTRAINT `FK_ORGANISA_POSTADD`
|
|
FOREIGN KEY (`PostfachanschriftAddressOid`)
|
|
REFERENCES `address` (`Oid`)
|
|
ON DELETE CASCADE
|
|
ON UPDATE CASCADE,
|
|
ADD CONSTRAINT `FK_ORGANISA_GROSADD`
|
|
FOREIGN KEY (`GrosskundenanschriftAddressOid`)
|
|
REFERENCES `address` (`Oid`)
|
|
ON DELETE CASCADE
|
|
ON UPDATE CASCADE; |