2018/Feb/28 -i állapot hozzáadva, mint a módosítások kiindulási állapota

1 files changed, 19 insertions, 0 deletions

diff --git a/mayor-orig/update/orev001723-1-naplo.sql b/mayor-orig/update/orev001723-1-naplo.sql
new file mode 100644
index 00000000..4f378068
--- /dev/null
+++ b/mayor-orig/update/orev001723-1-naplo.sql
@@ -0,0 +1,19 @@
+
+CREATE TABLE IF NOT EXISTS `hetes` (
+    `osztalyId` INT(10) UNSIGNED NOT NULL,
+    `dt` DATE,
+    `sorszam` SMALLINT UNSIGNED NOT NULL DEFAULT 1,
+    `diakId` INT(10) UNSIGNED NOT NULL,
+  PRIMARY KEY(`osztalyId`,`dt`,`sorszam`),
+  INDEX het_FKindex1(`osztalyId`),
+  INDEX het_FKindex2(`diakId`),
+  FOREIGN KEY(`osztalyId`)
+    REFERENCES %INTEZMENYDB%.`osztaly`(`osztalyId`)
+      ON DELETE CASCADE
+      ON UPDATE CASCADE,
+  FOREIGN KEY(`diakId`)
+    REFERENCES %INTEZMENYDB%.`diak`(`diakId`)
+      ON DELETE CASCADE
+      ON UPDATE CASCADE
+)
+ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_hungarian_ci;