diff options
Diffstat (limited to 'mayor-orig/update')
| -rw-r--r-- | mayor-orig/update/pre004375-1-intezmeny.sql | 15 | ||||
| -rw-r--r-- | mayor-orig/update/pre004388-1-mayor_login.sql | 12 | ||||
| -rw-r--r-- | mayor-orig/update/processUpdateScripts.sh | 2 |
3 files changed, 28 insertions, 1 deletions
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 |