aboutsummaryrefslogtreecommitdiffstats
path: root/mayor-orig/update/orev001367-1-intezmeny.sql
diff options
context:
space:
mode:
authorM.Gergo2018-07-06 11:14:41 +0200
committerM.Gergo2018-07-06 11:14:41 +0200
commit43de9af71f7f4ca5731b94a06d688ae8412ba427 (patch)
tree54835de1dfcda504c02da261f0dc26885aed2e89 /mayor-orig/update/orev001367-1-intezmeny.sql
parent50310b0e4513ee3fcce67351ae61e8fff851130e (diff)
downloadmayor-43de9af71f7f4ca5731b94a06d688ae8412ba427.tar.gz
mayor-43de9af71f7f4ca5731b94a06d688ae8412ba427.zip
2018/Feb/28 -i állapot hozzáadva, mint a módosítások kiindulási állapota
Diffstat (limited to 'mayor-orig/update/orev001367-1-intezmeny.sql')
-rw-r--r--mayor-orig/update/orev001367-1-intezmeny.sql71
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;
+