2018/Feb/28 -i állapot hozzáadva, mint a módosítások kiindulási állapota

1 files changed, 71 insertions, 0 deletions

diff --git a/mayor-orig/update/orev001367-1-intezmeny.sql b/mayor-orig/update/orev001367-1-intezmeny.sql
new file mode 100644
index 00000000..af8f4a06
--- /dev/null
+++ b/mayor-orig/update/orev001367-1-intezmeny.sql
@@ -0,0 +1,71 @@
+alter database collate utf8_hungarian_ci;
+
+ALTER TABLE munkakozosseg CONVERT TO character set utf8 collate utf8_hungarian_ci;
+ALTER TABLE osztaly CONVERT TO character set utf8 COLLATE utf8_hungarian_ci;
+ALTER TABLE tanar CONVERT TO character set utf8 COLLATE utf8_hungarian_ci;
+ALTER TABLE terem CONVERT TO CHARSET utf8 COLLATE utf8_hungarian_ci;
+
+ALTER TABLE szemeszter CONVERT TO CHARSET utf8 COLLATE utf8_hungarian_ci;
+
+ALTER TABLE idoszak 
+CONVERT TO CHARSET utf8 COLLATE utf8_hungarian_ci;
+
+ALTER TABLE targy 
+CONVERT TO CHARSET utf8 COLLATE utf8_hungarian_ci;
+
+ALTER TABLE szulo 
+CONVERT TO CHARSET utf8 COLLATE utf8_hungarian_ci;
+
+ALTER TABLE diak 
+CONVERT TO CHARSET utf8 COLLATE utf8_hungarian_ci;
+
+ALTER TABLE mkTanar
+CONVERT TO CHARSET utf8 COLLATE utf8_hungarian_ci;
+
+ALTER TABLE osztalyDiak 
+CONVERT TO CHARSET utf8 COLLATE utf8_hungarian_ci;
+
+ALTER TABLE osztalyTanar
+CONVERT TO CHARSET utf8 COLLATE utf8_hungarian_ci;
+
+ALTER TABLE zaroJegy 
+CONVERT TO CHARSET utf8 COLLATE utf8_hungarian_ci;
+
+ALTER TABLE hianyzasOsszesites
+CONVERT TO CHARSET utf8 COLLATE utf8_hungarian_ci;
+
+ALTER TABLE tankor 
+CONVERT TO CHARSET utf8 COLLATE utf8_hungarian_ci;
+
+ALTER TABLE tankorDiak
+CONVERT TO CHARSET utf8 COLLATE utf8_hungarian_ci;
+
+ALTER TABLE tankorSzemeszter
+CONVERT TO CHARSET utf8 COLLATE utf8_hungarian_ci;
+
+ALTER TABLE tankorOsztaly 
+CONVERT TO CHARSET utf8 COLLATE utf8_hungarian_ci;
+
+ALTER TABLE tankorTanar 
+CONVERT TO CHARSET utf8 COLLATE utf8_hungarian_ci;
+
+ALTER TABLE uzenet
+CONVERT TO CHARSET utf8 COLLATE utf8_hungarian_ci;
+
+ALTER TABLE uzen 
+CONVERT TO CHARSET utf8 COLLATE utf8_hungarian_ci;
+
+ALTER TABLE kepzes 
+CONVERT TO CHARSET utf8 COLLATE utf8_hungarian_ci;
+
+ALTER TABLE kepzesDiak 
+CONVERT TO CHARSET utf8 COLLATE utf8_hungarian_ci;
+
+ALTER TABLE kepzesOsztaly
+CONVERT TO CHARSET utf8 COLLATE utf8_hungarian_ci;
+
+ALTER TABLE kepzesTargyOraszam 
+CONVERT TO CHARSET utf8 COLLATE utf8_hungarian_ci;
+
+ALTER TABLE kepzesOraszam CONVERT TO CHARSET utf8 COLLATE utf8_hungarian_ci;
+