From e6988247360fa98b85915a38803d018dd353df00 Mon Sep 17 00:00:00 2001
From: M.Gergo
Date: Sun, 16 Dec 2018 16:35:17 +0100
Subject: Rev: 4412

---
 mayor-orig/update/pre004375-1-intezmeny.sql   | 15 +++++++++++++++
 mayor-orig/update/pre004388-1-mayor_login.sql | 12 ++++++++++++
 mayor-orig/update/processUpdateScripts.sh     |  2 +-
 3 files changed, 28 insertions(+), 1 deletion(-)
 create mode 100644 mayor-orig/update/pre004375-1-intezmeny.sql
 create mode 100644 mayor-orig/update/pre004388-1-mayor_login.sql

(limited to 'mayor-orig/update')

diff --git a/mayor-orig/update/pre004375-1-intezmeny.sql b/mayor-orig/update/pre004375-1-intezmeny.sql
new file mode 100644
index 00000000..8f1dc57c
--- /dev/null
+++ b/mayor-orig/update/pre004375-1-intezmeny.sql
@@ -0,0 +1,15 @@
+DELIMITER $$
+DROP PROCEDURE IF EXISTS upgrade_database_4375 $$
+
+CREATE PROCEDURE upgrade_database_4375()
+BEGIN
+SET NAMES utf8 COLLATE utf8_hungarian_ci;
+
+
+IF NOT EXISTS (SELECT * FROM information_schema.COLUMNS WHERE TABLE_SCHEMA=DATABASE() and TABLE_NAME='tanar' and COLUMN_NAME='kretaNev') THEN
+    ALTER TABLE `tanar` ADD `kretaNev` varchar(64) COLLATE utf8_hungarian_ci DEFAULT NULL;
+END IF;
+
+END $$
+DELIMITER ;
+CALL upgrade_database_4375();
diff --git a/mayor-orig/update/pre004388-1-mayor_login.sql b/mayor-orig/update/pre004388-1-mayor_login.sql
new file mode 100644
index 00000000..f0d7b148
--- /dev/null
+++ b/mayor-orig/update/pre004388-1-mayor_login.sql
@@ -0,0 +1,12 @@
+DELIMITER $$
+DROP PROCEDURE IF EXISTS upgrade_database_4388 $$
+CREATE PROCEDURE upgrade_database_4388()
+BEGIN
+    IF NOT EXISTS (
+        SELECT * FROM information_schema.COLUMNS WHERE TABLE_SCHEMA=DATABASE() AND TABLE_NAME='eduroam' AND COLUMN_NAME='eduroamDOMAIN'
+    ) THEN
+ALTER TABLE `eduroam` ADD `eduroamDOMAIN` varchar(128) COLLATE utf8_hungarian_ci NOT NULL;
+END IF;
+END $$
+DELIMITER ; $$
+CALL upgrade_database_4388();
diff --git a/mayor-orig/update/processUpdateScripts.sh b/mayor-orig/update/processUpdateScripts.sh
index 7a96ffef..1a29835f 100644
--- a/mayor-orig/update/processUpdateScripts.sh
+++ b/mayor-orig/update/processUpdateScripts.sh
@@ -180,7 +180,7 @@ if [ "$EXECONLY" != "1" ]; then
     for MODULE in $MODULES; do
 	echo -e "\n     $MODULE... \n"
 	if [ "$HTTP_SERVER" == '' ]; then
-	    $SVN --force --quiet export https://svn.mayor.hu/svn/trunk/$MODULE "$BASEDIR"
+	    $SVN --force --quiet export svn+ssh://svn.mayor.hu/var/svn/trunk/$MODULE "$BASEDIR"
 	    if [ $? != 0 ]; then exit 13; fi
 	else
 	    # Ha rpm csomag futtatja, akkor már ki van csomagolva minden és nincs md5sum
-- 
cgit v1.2.3