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/update/pre004362-1-intezmeny.sql | 30 +++++++++++++++++++++++++++++
 mayor-orig/update/pre004364-1-intezmeny.sql | 30 +++++++++++++++++++++++++++++
 2 files changed, 60 insertions(+)
 create mode 100644 mayor-orig/update/pre004362-1-intezmeny.sql
 create mode 100644 mayor-orig/update/pre004364-1-intezmeny.sql

(limited to 'mayor-orig/update')

diff --git a/mayor-orig/update/pre004362-1-intezmeny.sql b/mayor-orig/update/pre004362-1-intezmeny.sql
new file mode 100644
index 00000000..b2312cba
--- /dev/null
+++ b/mayor-orig/update/pre004362-1-intezmeny.sql
@@ -0,0 +1,30 @@
+DELIMITER $$
+DROP PROCEDURE IF EXISTS upgrade_database_4362 $$
+
+CREATE PROCEDURE upgrade_database_4362()
+BEGIN
+SET NAMES utf8 COLLATE utf8_hungarian_ci;
+
+IF NOT EXISTS (SELECT * FROM information_schema.TABLES WHERE TABLE_SCHEMA=DATABASE() and TABLE_NAME='diakNyelvvizsga') THEN
+CREATE TABLE `diakNyelvvizsga` (
+  `nyelvvizsgaId` int(10) unsigned NOT NULL AUTO_INCREMENT,
+  `diakId` int(10) unsigned NOT NULL,
+  `idegenNyelv` varchar(64) 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)') DEFAULT NULL,
+  `vizsgaTipus` ENUM ('szóbeli', 'írásbeli', 'komplex') DEFAULT 'komplex',
+  `vizsgaDt` DATE DEFAULT NULL,
+  `vizsgaIntezmeny` varchar(64) NOT NULL,
+  `vizsgaBizonyitvanySzam` varchar(32) 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;
+
+END IF;
+
+END $$
+DELIMITER ;
+CALL upgrade_database_4362();
diff --git a/mayor-orig/update/pre004364-1-intezmeny.sql b/mayor-orig/update/pre004364-1-intezmeny.sql
new file mode 100644
index 00000000..7b572449
--- /dev/null
+++ b/mayor-orig/update/pre004364-1-intezmeny.sql
@@ -0,0 +1,30 @@
+DELIMITER $$
+DROP PROCEDURE IF EXISTS upgrade_database_4364 $$
+
+CREATE PROCEDURE upgrade_database_4364()
+BEGIN
+SET NAMES utf8 COLLATE utf8_hungarian_ci;
+
+IF NOT EXISTS (SELECT * FROM information_schema.TABLES WHERE TABLE_SCHEMA=DATABASE() and TABLE_NAME='diakNyelvvizsga') THEN
+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;
+
+END IF;
+
+END $$
+DELIMITER ;
+CALL upgrade_database_4364();
-- 
cgit v1.2.3