From 095e5987eadbe3786be5e12ef385bda9640155b0 Mon Sep 17 00:00:00 2001
From: M.Gergo
Date: Fri, 6 Jul 2018 11:34:04 +0200
Subject: checkupdate.sh + portal 2018/Feb kiinduló

---
 mayor-orig/update/pre002213-1.sh               | 15 +++++++++++++++
 mayor-orig/update/pre004232-1-mayor_portal.sql | 16 ++++++++++++++++
 mayor-orig/update/rev001935-1.sh               | 15 +++++++++++++++
 mayor-orig/update/rev002019-1-mayor_portal.sql |  3 +++
 mayor-orig/update/rev003307-1-mayor_portal.sql |  1 +
 5 files changed, 50 insertions(+)
 create mode 100644 mayor-orig/update/pre002213-1.sh
 create mode 100644 mayor-orig/update/pre004232-1-mayor_portal.sql
 create mode 100644 mayor-orig/update/rev001935-1.sh
 create mode 100644 mayor-orig/update/rev002019-1-mayor_portal.sql
 create mode 100644 mayor-orig/update/rev003307-1-mayor_portal.sql

(limited to 'mayor-orig/update')

diff --git a/mayor-orig/update/pre002213-1.sh b/mayor-orig/update/pre002213-1.sh
new file mode 100644
index 00000000..ea163249
--- /dev/null
+++ b/mayor-orig/update/pre002213-1.sh
@@ -0,0 +1,15 @@
+#!/bin/bash
+
+FILES="install/module-portal/mysql/hirek.sql"
+
+echo -e "\n          * Felesleges állományok törlése:"
+  for FILE in $FILES
+  do
+    echo -n "            $BASEDIR/$FILE ... "
+    if [ -e "$BASEDIR/$FILE" ]; then
+        rm -f "$BASEDIR/$FILE"
+        echo "törölve."
+    else
+        echo "nincs."
+    fi
+  done
diff --git a/mayor-orig/update/pre004232-1-mayor_portal.sql b/mayor-orig/update/pre004232-1-mayor_portal.sql
new file mode 100644
index 00000000..60a37f94
--- /dev/null
+++ b/mayor-orig/update/pre004232-1-mayor_portal.sql
@@ -0,0 +1,16 @@
+DELIMITER $$
+DROP PROCEDURE IF EXISTS upgrade_database_4232 $$
+CREATE PROCEDURE upgrade_database_4232()
+BEGIN
+
+SET NAMES utf8 COLLATE utf8_hungarian_ci;
+
+IF EXISTS (
+    SELECT * FROM information_schema.TABLES WHERE TABLE_SCHEMA=DATABASE() and TABLE_NAME='nevnap'
+) THEN
+    update nevnap set nevnap='Gyöngyi' where honap=10 and nap=23;
+END IF;
+
+END $$
+DELIMITER ;
+CALL upgrade_database_4232();
diff --git a/mayor-orig/update/rev001935-1.sh b/mayor-orig/update/rev001935-1.sh
new file mode 100644
index 00000000..ac899c9d
--- /dev/null
+++ b/mayor-orig/update/rev001935-1.sh
@@ -0,0 +1,15 @@
+#!/bin/bash
+
+FILES="www/include/modules/portal/share/sql.php"
+
+echo -e "\n          Elavult állományok törlése:\n"
+for FILE in $FILES; do
+    echo -n "          $BASEDIR/$FILE ... "
+    if [ -e $BASEDIR/$FILE ]; then
+        rm -f $BASEDIR/$FILE
+        echo "törölve."
+    else
+        echo "nincs."
+    fi
+done
+
diff --git a/mayor-orig/update/rev002019-1-mayor_portal.sql b/mayor-orig/update/rev002019-1-mayor_portal.sql
new file mode 100644
index 00000000..cc90243f
--- /dev/null
+++ b/mayor-orig/update/rev002019-1-mayor_portal.sql
@@ -0,0 +1,3 @@
+create table `kerdoivSzavazott` (`kerdoivId` int unsigned not null, `policy` ENUM('private','parent'), `userAccount` varchar(60))
+ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_hungarian_ci;
+alter table `kerdesek` add `policy` set('private','parent','public') DEFAULT 'public';
diff --git a/mayor-orig/update/rev003307-1-mayor_portal.sql b/mayor-orig/update/rev003307-1-mayor_portal.sql
new file mode 100644
index 00000000..a9c899b1
--- /dev/null
+++ b/mayor-orig/update/rev003307-1-mayor_portal.sql
@@ -0,0 +1 @@
+ALTER TABLE hirek MODIFY pic varchar(256) NULL;
-- 
cgit v1.2.3