aboutsummaryrefslogtreecommitdiffstats
path: root/mayor-orig/update/pre002173-1-naplo.sql
diff options
context:
space:
mode:
Diffstat (limited to 'mayor-orig/update/pre002173-1-naplo.sql')
-rw-r--r--mayor-orig/update/pre002173-1-naplo.sql21
1 files changed, 0 insertions, 21 deletions
diff --git a/mayor-orig/update/pre002173-1-naplo.sql b/mayor-orig/update/pre002173-1-naplo.sql
deleted file mode 100644
index 5e8e1b42..00000000
--- a/mayor-orig/update/pre002173-1-naplo.sql
+++ /dev/null
@@ -1,21 +0,0 @@
-drop procedure if exists update2173;
-DELIMITER //
-create procedure update2173()
-BEGIN
- DECLARE done INT DEFAULT 0;
- SELECT count(`table_schema`) AS darab from `information_schema`.`columns` where `table_name`='uzeno' and `column_name`='cimzettTipus'
- and `table_schema` = (SELECT database())
- and `column_type`!="enum('diak','szulo','tanar','tankor','tankorSzulo','munkakozosseg','osztaly','osztalySzulo','osztalyTanar')"
- INTO done;
- IF done = 0 THEN
- SELECT "nothing to do here",database();
- ELSE
- ALTER TABLE `uzeno` MODIFY `cimzettTipus` enum('diak','szulo','tanar','tankor','tankorSzulo','munkakozosseg','osztaly','osztalySzulo','osztalyTanar') NULL;
- UPDATE `uzeno` SET `cimzettTipus` = "osztalyTanar" WHERE `cimzettTipus`='';
- END IF;
- SELECT done;
-END; //
-DELIMITER ; //
-CALL update2173();
--- A script egyébként felesleges bonyolult, későbbi felhasználás tesztje
-drop procedure if exists update2173;