diff options
author | M.Gergo | 2020-09-02 21:02:17 +0200 |
---|---|---|
committer | M.Gergo | 2020-09-02 21:02:17 +0200 |
commit | cf6a58003f47139501a2907f8a4bc400b23fda66 (patch) | |
tree | fb7f9e17b609143987ca2f324e27c610886284a9 /mayor-orig/mayor-naplo/update/pre004671-1-intezmeny.sql | |
parent | 9bfbb60898b55ba4e1bd50c052c7ec4aaafc1ff8 (diff) | |
parent | 9044c44af70eff76d875137de553d5904e475f6d (diff) | |
download | mayor-cf6a58003f47139501a2907f8a4bc400b23fda66.tar.gz mayor-cf6a58003f47139501a2907f8a4bc400b23fda66.zip |
Merge branch 'MaYor-dev'
Diffstat (limited to 'mayor-orig/mayor-naplo/update/pre004671-1-intezmeny.sql')
-rw-r--r-- | mayor-orig/mayor-naplo/update/pre004671-1-intezmeny.sql | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/mayor-orig/mayor-naplo/update/pre004671-1-intezmeny.sql b/mayor-orig/mayor-naplo/update/pre004671-1-intezmeny.sql new file mode 100644 index 00000000..6fc53da7 --- /dev/null +++ b/mayor-orig/mayor-naplo/update/pre004671-1-intezmeny.sql @@ -0,0 +1,14 @@ +DELIMITER $$ +DROP PROCEDURE IF EXISTS upgrade_database_4671 $$ + +CREATE PROCEDURE upgrade_database_4671() +BEGIN +SET NAMES utf8 COLLATE utf8_hungarian_ci; + +IF EXISTS (SELECT * FROM information_schema.COLUMNS WHERE TABLE_SCHEMA=DATABASE() and TABLE_NAME='tanar' and COLUMN_NAME='viseltNevElotag') THEN + ALTER TABLE `tanar` MODIFY `viseltNevElotag` varchar(8) COLLATE utf8_hungarian_ci DEFAULT NULL; +END IF; + +END $$ +DELIMITER ; +CALL upgrade_database_4671(); |