aboutsummaryrefslogtreecommitdiffstats
path: root/mayor-orig/update
diff options
context:
space:
mode:
authorM.Gergo2018-09-10 17:41:41 +0200
committerM.Gergo2018-09-10 17:41:41 +0200
commit20361aa31c7749c47416ea9b76fde393fa28cec6 (patch)
tree8279eb2f106612d8e217ef5c900f552c3855d4ee /mayor-orig/update
parentc144cdab334ea104187cc80bf730259009e5fe8a (diff)
downloadmayor-20361aa31c7749c47416ea9b76fde393fa28cec6.tar.gz
mayor-20361aa31c7749c47416ea9b76fde393fa28cec6.zip
Rev: 4365
Diffstat (limited to 'mayor-orig/update')
-rw-r--r--mayor-orig/update/pre004362-1-intezmeny.sql30
-rw-r--r--mayor-orig/update/pre004364-1-intezmeny.sql30
2 files changed, 60 insertions, 0 deletions
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();