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

