diff options
Diffstat (limited to 'mayor-orig/mayor-portal/update')
5 files changed, 50 insertions, 0 deletions
diff --git a/mayor-orig/mayor-portal/update/pre002213-1.sh b/mayor-orig/mayor-portal/update/pre002213-1.sh new file mode 100644 index 00000000..ea163249 --- /dev/null +++ b/mayor-orig/mayor-portal/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/mayor-portal/update/pre004232-1-mayor_portal.sql b/mayor-orig/mayor-portal/update/pre004232-1-mayor_portal.sql new file mode 100644 index 00000000..60a37f94 --- /dev/null +++ b/mayor-orig/mayor-portal/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/mayor-portal/update/rev001935-1.sh b/mayor-orig/mayor-portal/update/rev001935-1.sh new file mode 100644 index 00000000..ac899c9d --- /dev/null +++ b/mayor-orig/mayor-portal/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/mayor-portal/update/rev002019-1-mayor_portal.sql b/mayor-orig/mayor-portal/update/rev002019-1-mayor_portal.sql new file mode 100644 index 00000000..cc90243f --- /dev/null +++ b/mayor-orig/mayor-portal/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/mayor-portal/update/rev003307-1-mayor_portal.sql b/mayor-orig/mayor-portal/update/rev003307-1-mayor_portal.sql new file mode 100644 index 00000000..a9c899b1 --- /dev/null +++ b/mayor-orig/mayor-portal/update/rev003307-1-mayor_portal.sql @@ -0,0 +1 @@ +ALTER TABLE hirek MODIFY pic varchar(256) NULL; |