From 20361aa31c7749c47416ea9b76fde393fa28cec6 Mon Sep 17 00:00:00 2001 From: M.Gergo Date: Mon, 10 Sep 2018 17:41:41 +0200 Subject: Rev: 4365 --- mayor-orig/install/module-naplo/mysql/intezmeny.sql | 17 +++++++++++++++++ 1 file changed, 17 insertions(+) (limited to 'mayor-orig/install/module-naplo/mysql/intezmeny.sql') diff --git a/mayor-orig/install/module-naplo/mysql/intezmeny.sql b/mayor-orig/install/module-naplo/mysql/intezmeny.sql index c0abb189..78b8949c 100644 --- a/mayor-orig/install/module-naplo/mysql/intezmeny.sql +++ b/mayor-orig/install/module-naplo/mysql/intezmeny.sql @@ -946,6 +946,23 @@ CREATE TABLE `hirnokFeliratkozas` ( KEY `K_hf_up` (`userAccount`,`policy`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_hungarian_ci; +CREATE TABLE `diakNyelvvizsga` ( + `nyelvvizsgaId` int(10) unsigned NOT NULL AUTO_INCREMENT, + `diakId` int(10) unsigned NOT NULL, + `idegenNyelv` varchar(64) COLLATE utf8_hungarian_ci NOT NULL, + `targyId` smallint(5) unsigned NOT NULL, + `vizsgaSzint` enum('A2 szint (belépő)','B1 szint (alapfok)','B2 szint (középfok)','C1 szint (felsőfok)') COLLATE utf8_hungarian_ci DEFAULT NULL, + `vizsgaTipus` enum('szóbeli','írásbeli','komplex') COLLATE utf8_hungarian_ci DEFAULT 'komplex', + `vizsgaDt` date DEFAULT NULL, + `vizsgaIntezmeny` varchar(64) COLLATE utf8_hungarian_ci NOT NULL, + `vizsgaBizonyitvanySzam` varchar(32) COLLATE utf8_hungarian_ci NOT NULL, + PRIMARY KEY (`nyelvvizsgaId`), + KEY `diakNyelvvizsga_ibfk_1` (`diakId`), + KEY `diakNyelvvizsga_ibfk_2` (`targyId`), + CONSTRAINT `diakNyelvvizsga_ibfk_1` FOREIGN KEY (`diakId`) REFERENCES `diak` (`diakId`) ON DELETE CASCADE ON UPDATE CASCADE, + CONSTRAINT `diakNyelvvizsga_ibfk_2` FOREIGN KEY (`targyId`) REFERENCES `targy` (`targyId`) ON DELETE CASCADE ON UPDATE CASCADE +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_hungarian_ci; + DELIMITER // DROP FUNCTION IF EXISTS diakNaploSorszam // CREATE function diakNaploSorszam ( thisDiakId INT, thisTanev INT, thisOsztalyId INT ) returns INT -- cgit v1.2.3