Files
BeWoPlaner/Model/Changes_2021_02_02_CustomerOid zu ConfirmationReceiptSignature.txt

3 lines
329 B
Plaintext
Raw Permalink Normal View History

ALTER TABLE confirmationreceiptsignature ADD COLUMN CustomerOid BIGINT(19);
ALTER TABLE confirmationreceiptsignature ADD KEY CONFIRMATIONRECEIPTSIGNATURE_CUSTOMER_FK (CustomerOid);
ALTER TABLE confirmationreceiptsignature ADD CONSTRAINT FK_CONFIRMATIONRECEIPTSIGNATURE2CUSTOMER FOREIGN KEY (CustomerOid) REFERENCES Customer(Oid);