aboutsummaryrefslogtreecommitdiffstats
path: root/mayor-orig/update
diff options
context:
space:
mode:
Diffstat (limited to 'mayor-orig/update')
-rw-r--r--mayor-orig/update/pre002213-1.sh15
-rw-r--r--mayor-orig/update/pre004232-1-mayor_portal.sql16
-rw-r--r--mayor-orig/update/rev001935-1.sh15
-rw-r--r--mayor-orig/update/rev002019-1-mayor_portal.sql3
-rw-r--r--mayor-orig/update/rev003307-1-mayor_portal.sql1
5 files changed, 50 insertions, 0 deletions
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;