From 78d4c90716008073d654b7c8d311f67367ee3c88 Mon Sep 17 00:00:00 2001 From: M.Gergo Date: Thu, 4 Apr 2019 13:04:51 +0200 Subject: Rev: 4506 --- mayor-orig/mayor-naplo/install/module-naplo/mysql/tanev.sql | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) (limited to 'mayor-orig/mayor-naplo/install/module-naplo/mysql') diff --git a/mayor-orig/mayor-naplo/install/module-naplo/mysql/tanev.sql b/mayor-orig/mayor-naplo/install/module-naplo/mysql/tanev.sql index 23507fda..eaf74280 100644 --- a/mayor-orig/mayor-naplo/install/module-naplo/mysql/tanev.sql +++ b/mayor-orig/mayor-naplo/install/module-naplo/mysql/tanev.sql @@ -489,9 +489,9 @@ CREATE TABLE `hianyzasKreta` ( KEY `hianyzasKreta_oId` (`oId`), KEY `hianyzasKreta_diakId` (`diakId`), KEY `hianyzasKreta_tankorId` (`tankorId`), - CONSTRAINT `hk_ibfk_1` FOREIGN KEY (`oId`) REFERENCES `intezmeny_vmg`.`diak` (`oId`) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT `hk_ibfk_2` FOREIGN KEY (`diakId`) REFERENCES `intezmeny_vmg`.`diak` (`diakId`) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT `hk_ibfk_3` FOREIGN KEY (`tankorId`) REFERENCES `intezmeny_vmg`.`tankor` (`tankorId`) ON DELETE CASCADE ON UPDATE CASCADE + CONSTRAINT `hk_ibfk_1` FOREIGN KEY (`oId`) REFERENCES `%DB%`.`diak` (`oId`) ON DELETE CASCADE ON UPDATE CASCADE, + CONSTRAINT `hk_ibfk_2` FOREIGN KEY (`diakId`) REFERENCES `%DB%`.`diak` (`diakId`) ON DELETE CASCADE ON UPDATE CASCADE, + CONSTRAINT `hk_ibfk_3` FOREIGN KEY (`tankorId`) REFERENCES `%DB%`.`tankor` (`tankorId`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_hungarian_ci; CREATE TABLE `koszi` ( -- cgit v1.2.3