1 files changed, 12 insertions, 0 deletions
diff --git a/mayor-orig/update/orev001530-1-naplo.sql b/mayor-orig/update/orev001530-1-naplo.sql
new file mode 100644
index 00000000..a0e9e024
--- /dev/null
+++ b/mayor-orig/update/orev001530-1-naplo.sql
@@ -0,0 +1,12 @@
+alter table uzeno engine=InnoDB;
+CREATE TABLE `uzenoFlagek` (
+  `mId` int(10) unsigned NOT NULL,
+  `Id` int(10) unsigned NOT NULL,
+  `Tipus` enum('diak','szulo','tanar') default NULL,
+  `flag` tinyint(1) NOT NULL default '0',
+  PRIMARY KEY  (`mId`,`Id`,`Tipus`),
+  FOREIGN KEY(mId)
+    REFERENCES uzeno(mId)
+      ON DELETE CASCADE
+      ON UPDATE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;