mayor-orig/update/orev001782-1-naplo.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28

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;