29 lines
912 B
Plaintext
29 lines
912 B
Plaintext
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`; |