aboutsummaryrefslogtreecommitdiffstats
path: root/mayor-orig/update/orev001782-1-naplo.sql
diff options
context:
space:
mode:
Diffstat (limited to 'mayor-orig/update/orev001782-1-naplo.sql')
-rw-r--r--mayor-orig/update/orev001782-1-naplo.sql28
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;