BeWoPlaner/Model/Changes_2024_08_27 Wohneinheit Grundrisse.txt

ALTER TABLE `image` 
DROP FOREIGN KEY `FK_EMPLOYEE`,
DROP FOREIGN KEY `FK_CUSTOMER`;
ALTER TABLE `image` 
DROP COLUMN `EmployeeOid`,
DROP COLUMN `CustomerOid`,
ADD COLUMN `WohneinheitOid` BIGINT NULL DEFAULT NULL AFTER `PersonOid`,
DROP INDEX `KEY_EMPLOYEE` ,
DROP INDEX `KEY_CUSTOMER` ;
;
ALTER TABLE `image` 
ADD INDEX `FK_IMAGE_PERSON_idx` (`PersonOid` ASC) VISIBLE,
ADD INDEX `FK_IMAGE_WOHNEINHEIT_idx` (`WohneinheitOid` ASC) VISIBLE;
;
ALTER TABLE `image` 
ADD CONSTRAINT `FK_IMAGE_PERSON`
  FOREIGN KEY (`PersonOid`)
  REFERENCES `person` (`Oid`)
  ON DELETE CASCADE
  ON UPDATE CASCADE,
ADD CONSTRAINT `FK_IMAGE_WOHNEINHEIT`
  FOREIGN KEY (`WohneinheitOid`)
  REFERENCES `wohneinheit` (`Oid`)
  ON DELETE CASCADE
  ON UPDATE CASCADE;
;
ALTER TABLE `image` 
ADD COLUMN `Filename` VARCHAR(1024) NULL DEFAULT NULL AFTER `SystemEntryID`,
ADD COLUMN `Fullname` VARCHAR(1024) NULL DEFAULT NULL AFTER `Filename`;