diff options
author | M.Gergo | 2018-07-06 11:34:04 +0200 |
---|---|---|
committer | M.Gergo | 2018-07-06 11:34:04 +0200 |
commit | 095e5987eadbe3786be5e12ef385bda9640155b0 (patch) | |
tree | e796dcd1c575094cf43e0b0b7d4c8fb22896e66f /mayor-orig/update | |
parent | 43de9af71f7f4ca5731b94a06d688ae8412ba427 (diff) | |
download | mayor-095e5987eadbe3786be5e12ef385bda9640155b0.tar.gz mayor-095e5987eadbe3786be5e12ef385bda9640155b0.zip |
checkupdate.sh + portal 2018/Feb kiinduló
Diffstat (limited to 'mayor-orig/update')
-rw-r--r-- | mayor-orig/update/pre002213-1.sh | 15 | ||||
-rw-r--r-- | mayor-orig/update/pre004232-1-mayor_portal.sql | 16 | ||||
-rw-r--r-- | mayor-orig/update/rev001935-1.sh | 15 | ||||
-rw-r--r-- | mayor-orig/update/rev002019-1-mayor_portal.sql | 3 | ||||
-rw-r--r-- | mayor-orig/update/rev003307-1-mayor_portal.sql | 1 |
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; |