diff options
Diffstat (limited to 'mayor-orig/mayor-naplo/update')
| -rw-r--r-- | mayor-orig/mayor-naplo/update/pre004791-1-intezmeny.sql | 23 |
1 files changed, 23 insertions, 0 deletions
diff --git a/mayor-orig/mayor-naplo/update/pre004791-1-intezmeny.sql b/mayor-orig/mayor-naplo/update/pre004791-1-intezmeny.sql new file mode 100644 index 00000000..b3786834 --- /dev/null +++ b/mayor-orig/mayor-naplo/update/pre004791-1-intezmeny.sql @@ -0,0 +1,23 @@ +DELIMITER $$ +DROP PROCEDURE IF EXISTS upgrade_database_4791 $$ +CREATE PROCEDURE upgrade_database_4791() +BEGIN + +SET NAMES utf8 COLLATE utf8_hungarian_ci; + +IF EXISTS ( + SELECT * FROM information_schema.COLUMNS WHERE TABLE_SCHEMA=DATABASE() and TABLE_NAME='kepzesOraterv' AND COLUMN_NAME='tipus' +) THEN + + alter table `kepzesOraterv` modify `tipus` + enum('első nyelv','második nyelv','mintatantervi','kötelezően választható 1.','kötelezően választható 2.', + 'szabadon választható 1.','szabadon választható 2.','művészetek','természettudomány') CHARACTER SET utf8 COLLATE utf8_hungarian_ci DEFAULT 'mintatantervi'; + +END IF; + +END $$ +DELIMITER ; +CALL upgrade_database_4791(); + +-- | Warning | 3719 | 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. | +-- | Warning | 3778 | 'utf8_hungarian_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead. |