diff options
Diffstat (limited to 'mayor-orig/update/pre003422-1-mayor_naplo.sql')
-rw-r--r-- | mayor-orig/update/pre003422-1-mayor_naplo.sql | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/mayor-orig/update/pre003422-1-mayor_naplo.sql b/mayor-orig/update/pre003422-1-mayor_naplo.sql new file mode 100644 index 00000000..9af5fa6a --- /dev/null +++ b/mayor-orig/update/pre003422-1-mayor_naplo.sql @@ -0,0 +1,13 @@ +DELIMITER $$ +DROP PROCEDURE IF EXISTS upgrade_database_3422 $$ +CREATE PROCEDURE upgrade_database_3422() +BEGIN +IF NOT EXISTS ( + SELECT * FROM information_schema.COLUMNS WHERE TABLE_SCHEMA='mayor_naplo' and TABLE_NAME='osztalyJelleg' AND COLUMN_NAME='osztalyJellegEles' +) THEN + alter table osztalyJelleg add column osztalyJellegEles tinyint unsigned default 1; +END IF; +END $$ +CALL upgrade_database_3422(); +UPDATE osztalyJelleg SET osztalyJellegEles=1 WHERE osztalyJellegId>=21; +UPDATE osztalyJelleg SET osztalyJellegEles=0 WHERE osztalyJellegId<21; |