további rendrakás

1 files changed, 0 insertions, 28 deletions

diff --git a/mayor-orig/update/orev001782-1-naplo.sql b/mayor-orig/update/orev001782-1-naplo.sql
deleted file mode 100644
index c74d4de0..00000000
--- a/mayor-orig/update/orev001782-1-naplo.sql
+++ /dev/null
@@ -1,28 +0,0 @@
-
-DROP TABLE IF EXISTS oraLatogatas;
-CREATE TABLE oraLatogatas (
-  oraLatogatasId INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
-  megjegyzes TEXT NOT NULL,
-  oraId INT UNSIGNED NULL,
-  PRIMARY KEY(oraLatogatasId),
-  FOREIGN KEY(oraId)
-    REFERENCES ora(oraId)
-      ON DELETE CASCADE
-      ON UPDATE CASCADE
-)
-ENGINE=InnoDB;
-
-CREATE TABLE oraLatogatasTanar (
-  oraLatogatasId INTEGER UNSIGNED NOT NULL,
-  tanarId INT UNSIGNED NULL,
-  PRIMARY KEY(oraLatogatasId, tanarId),
-  FOREIGN KEY(tanarId)
-    REFERENCES %INTEZMENYDB%.tanar(tanarId)
-      ON DELETE CASCADE
-      ON UPDATE CASCADE,
-  FOREIGN KEY(oraLatogatasId)
-    REFERENCES oraLatogatas(oraLatogatasId)
-      ON DELETE CASCADE
-      ON UPDATE CASCADE
-)
-ENGINE=InnoDB;