aboutsummaryrefslogtreecommitdiffstats
path: root/mayor-orig/update
diff options
context:
space:
mode:
Diffstat (limited to 'mayor-orig/update')
-rw-r--r--mayor-orig/update/pre004375-1-intezmeny.sql15
-rw-r--r--mayor-orig/update/pre004388-1-mayor_login.sql12
-rw-r--r--mayor-orig/update/processUpdateScripts.sh2
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