diff options
Diffstat (limited to 'mayor-orig/update/orev001782-1-naplo.sql')
-rw-r--r-- | mayor-orig/update/orev001782-1-naplo.sql | 28 |
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; |