aboutsummaryrefslogtreecommitdiffstats
path: root/mayor-orig/update/pre002573-1-intezmeny.sql
diff options
context:
space:
mode:
Diffstat (limited to 'mayor-orig/update/pre002573-1-intezmeny.sql')
-rw-r--r--mayor-orig/update/pre002573-1-intezmeny.sql7
1 files changed, 0 insertions, 7 deletions
diff --git a/mayor-orig/update/pre002573-1-intezmeny.sql b/mayor-orig/update/pre002573-1-intezmeny.sql
deleted file mode 100644
index 3ff7880f..00000000
--- a/mayor-orig/update/pre002573-1-intezmeny.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-
-alter table tanmenet add column `statusz` enum('új','kész','jóváhagyott','publikus','elavult') default 'új';
-
-update tanmenet set statusz='jóváhagyott' where jovahagyva > 0;
-update tanmenet set statusz='kész' where statusz='új' and oraszam=(select sum(oraszam) from tanmenetTankor where tanmenetTankor.tanmenetId=tanmenet.tanmenetId);
-
-alter table tanmenet drop column jovahagyva; \ No newline at end of file