From fb24a50c54d5776468e49def08aea44c4077eb47 Mon Sep 17 00:00:00 2001
From: M.Gergo
Date: Wed, 20 Jan 2021 14:00:03 +0100
Subject: Rev: 4716

---
 mayor-orig/mayor-base/log/mayor-base.rev           |  2 +-
 mayor-orig/mayor-felveteli/log/mayor-felveteli.rev |  2 +-
 mayor-orig/mayor-fenntarto/log/mayor-fenntarto.rev |  2 +-
 .../mayor-installer-orig/log/mayor-installer.rev   |  2 +-
 .../log/mayor-installer-sulix.rev                  |  2 +-
 mayor-orig/mayor-jatek/log/mayor-jatek.rev         |  2 +-
 .../log/mayor-locales-de_DE.rev                    |  2 +-
 .../log/mayor-locales-en_US.rev                    |  2 +-
 .../log/mayor-locales-jp_JP.rev                    |  2 +-
 mayor-orig/mayor-naplo/log/mayor-naplo.rev         |  2 +-
 .../mayor-naplo/update/pre004715-1-intezmeny.sql   | 12 ++++++++++
 mayor-orig/mayor-portal/log/mayor-portal.rev       |  2 +-
 mayor-orig/mayor-wiki/log/mayor-wiki.rev           |  2 +-
 mayor-orig/md5sum                                  | 26 +++++++++++-----------
 mayor-orig/rev.txt                                 |  2 +-
 rev.txt                                            |  2 +-
 16 files changed, 39 insertions(+), 27 deletions(-)
 create mode 100644 mayor-orig/mayor-naplo/update/pre004715-1-intezmeny.sql

diff --git a/mayor-orig/mayor-base/log/mayor-base.rev b/mayor-orig/mayor-base/log/mayor-base.rev
index a29b5fa9..7e1fd933 100644
--- a/mayor-orig/mayor-base/log/mayor-base.rev
+++ b/mayor-orig/mayor-base/log/mayor-base.rev
@@ -1 +1 @@
-4715
+4716
diff --git a/mayor-orig/mayor-felveteli/log/mayor-felveteli.rev b/mayor-orig/mayor-felveteli/log/mayor-felveteli.rev
index a29b5fa9..7e1fd933 100644
--- a/mayor-orig/mayor-felveteli/log/mayor-felveteli.rev
+++ b/mayor-orig/mayor-felveteli/log/mayor-felveteli.rev
@@ -1 +1 @@
-4715
+4716
diff --git a/mayor-orig/mayor-fenntarto/log/mayor-fenntarto.rev b/mayor-orig/mayor-fenntarto/log/mayor-fenntarto.rev
index a29b5fa9..7e1fd933 100644
--- a/mayor-orig/mayor-fenntarto/log/mayor-fenntarto.rev
+++ b/mayor-orig/mayor-fenntarto/log/mayor-fenntarto.rev
@@ -1 +1 @@
-4715
+4716
diff --git a/mayor-orig/mayor-installer-orig/log/mayor-installer.rev b/mayor-orig/mayor-installer-orig/log/mayor-installer.rev
index a29b5fa9..7e1fd933 100644
--- a/mayor-orig/mayor-installer-orig/log/mayor-installer.rev
+++ b/mayor-orig/mayor-installer-orig/log/mayor-installer.rev
@@ -1 +1 @@
-4715
+4716
diff --git a/mayor-orig/mayor-installer-sulix/log/mayor-installer-sulix.rev b/mayor-orig/mayor-installer-sulix/log/mayor-installer-sulix.rev
index a29b5fa9..7e1fd933 100644
--- a/mayor-orig/mayor-installer-sulix/log/mayor-installer-sulix.rev
+++ b/mayor-orig/mayor-installer-sulix/log/mayor-installer-sulix.rev
@@ -1 +1 @@
-4715
+4716
diff --git a/mayor-orig/mayor-jatek/log/mayor-jatek.rev b/mayor-orig/mayor-jatek/log/mayor-jatek.rev
index a29b5fa9..7e1fd933 100644
--- a/mayor-orig/mayor-jatek/log/mayor-jatek.rev
+++ b/mayor-orig/mayor-jatek/log/mayor-jatek.rev
@@ -1 +1 @@
-4715
+4716
diff --git a/mayor-orig/mayor-locales-de_DE/log/mayor-locales-de_DE.rev b/mayor-orig/mayor-locales-de_DE/log/mayor-locales-de_DE.rev
index a29b5fa9..7e1fd933 100644
--- a/mayor-orig/mayor-locales-de_DE/log/mayor-locales-de_DE.rev
+++ b/mayor-orig/mayor-locales-de_DE/log/mayor-locales-de_DE.rev
@@ -1 +1 @@
-4715
+4716
diff --git a/mayor-orig/mayor-locales-en_US/log/mayor-locales-en_US.rev b/mayor-orig/mayor-locales-en_US/log/mayor-locales-en_US.rev
index a29b5fa9..7e1fd933 100644
--- a/mayor-orig/mayor-locales-en_US/log/mayor-locales-en_US.rev
+++ b/mayor-orig/mayor-locales-en_US/log/mayor-locales-en_US.rev
@@ -1 +1 @@
-4715
+4716
diff --git a/mayor-orig/mayor-locales-jp_JP/log/mayor-locales-jp_JP.rev b/mayor-orig/mayor-locales-jp_JP/log/mayor-locales-jp_JP.rev
index a29b5fa9..7e1fd933 100644
--- a/mayor-orig/mayor-locales-jp_JP/log/mayor-locales-jp_JP.rev
+++ b/mayor-orig/mayor-locales-jp_JP/log/mayor-locales-jp_JP.rev
@@ -1 +1 @@
-4715
+4716
diff --git a/mayor-orig/mayor-naplo/log/mayor-naplo.rev b/mayor-orig/mayor-naplo/log/mayor-naplo.rev
index a29b5fa9..7e1fd933 100644
--- a/mayor-orig/mayor-naplo/log/mayor-naplo.rev
+++ b/mayor-orig/mayor-naplo/log/mayor-naplo.rev
@@ -1 +1 @@
-4715
+4716
diff --git a/mayor-orig/mayor-naplo/update/pre004715-1-intezmeny.sql b/mayor-orig/mayor-naplo/update/pre004715-1-intezmeny.sql
new file mode 100644
index 00000000..485aab2a
--- /dev/null
+++ b/mayor-orig/mayor-naplo/update/pre004715-1-intezmeny.sql
@@ -0,0 +1,12 @@
+DELIMITER $$
+DROP PROCEDURE IF EXISTS upgrade_database_4715 $$
+
+CREATE PROCEDURE upgrade_database_4715()
+BEGIN
+SET NAMES utf8 COLLATE utf8_hungarian_ci;
+
+ALTER TABLE zaroJegy MODIFY `megjegyzes` enum('dicséret','figyelmeztető','') COLLATE utf8_hungarian_ci DEFAULT NULL;
+
+END $$
+DELIMITER ;
+CALL upgrade_database_4715();
diff --git a/mayor-orig/mayor-portal/log/mayor-portal.rev b/mayor-orig/mayor-portal/log/mayor-portal.rev
index a29b5fa9..7e1fd933 100644
--- a/mayor-orig/mayor-portal/log/mayor-portal.rev
+++ b/mayor-orig/mayor-portal/log/mayor-portal.rev
@@ -1 +1 @@
-4715
+4716
diff --git a/mayor-orig/mayor-wiki/log/mayor-wiki.rev b/mayor-orig/mayor-wiki/log/mayor-wiki.rev
index a29b5fa9..7e1fd933 100644
--- a/mayor-orig/mayor-wiki/log/mayor-wiki.rev
+++ b/mayor-orig/mayor-wiki/log/mayor-wiki.rev
@@ -1 +1 @@
-4715
+4716
diff --git a/mayor-orig/md5sum b/mayor-orig/md5sum
index 0808638e..5531868f 100644
--- a/mayor-orig/md5sum
+++ b/mayor-orig/md5sum
@@ -1,13 +1,13 @@
-Revision 4715
-43fdcbb79107f40fc3120c57db417c4b  mayor-fenntarto-rev4715.tgz
-391093a3387a8ee3b79138fb010fbb7f  mayor-installer-sulix-rev4715.tgz
-122579371c590ad98e90f3407594cfa2  mayor-wiki-rev4715.tgz
-1ff2a02bc1b4b9c2781f98cc59760880  mayor-installer-rev4715.tgz
-a01109b8c8ad5240a9bace962f8f8fc5  mayor-portal-rev4715.tgz
-914440be442874ecc05078524270d735  mayor-felveteli-rev4715.tgz
-fd7d743f8212b7327098231f4bed480e  mayor-jatek-rev4715.tgz
-2fc85c4d675f2cc19007ad334c6e821b  mayor-locales-jp_JP-rev4715.tgz
-9137d63cd72829caadc5e4a0904b45a9  mayor-locales-de_DE-rev4715.tgz
-505bba3d3f63b1eed0e95b04bff71ce1  mayor-locales-en_US-rev4715.tgz
-a094cc484b6c9c2fb391eef4794117fd  mayor-naplo-rev4715.tgz
-65448272b6e696a2f7db451664345822  mayor-base-rev4715.tgz
+Revision 4716
+0f149dad48a74cdfd6db3ce36573b331  mayor-fenntarto-rev4716.tgz
+7e22010b99732f93605b078d36e69081  mayor-installer-sulix-rev4716.tgz
+2d5749d97df238b72eab1bf77ec6a271  mayor-wiki-rev4716.tgz
+afad598f7355efbca1f13c554fb7e964  mayor-installer-rev4716.tgz
+9d6d2711f8e2c8179011790fe573c045  mayor-portal-rev4716.tgz
+b7b2abdc8a6d7d8b38d92b6a28fa6ac4  mayor-felveteli-rev4716.tgz
+42ed1ddcfd864bef749cfa062495c5d3  mayor-jatek-rev4716.tgz
+b3388a5cb6503038338f51c1526e862c  mayor-locales-jp_JP-rev4716.tgz
+91a9afd725673ff17d817f0772341f12  mayor-locales-de_DE-rev4716.tgz
+dfca36e6a631328724b05dc7318e124f  mayor-locales-en_US-rev4716.tgz
+6730ac88c50aa7282647e4e81f0864d9  mayor-naplo-rev4716.tgz
+c184a7209b582c9b97489c9c938fe145  mayor-base-rev4716.tgz
diff --git a/mayor-orig/rev.txt b/mayor-orig/rev.txt
index a29b5fa9..7e1fd933 100644
--- a/mayor-orig/rev.txt
+++ b/mayor-orig/rev.txt
@@ -1 +1 @@
-4715
+4716
diff --git a/rev.txt b/rev.txt
index a29b5fa9..7e1fd933 100644
--- a/rev.txt
+++ b/rev.txt
@@ -1 +1 @@
-4715
+4716
-- 
cgit v1.2.3