blob: c74d4de095c93abc69545f8e48f7bdbe65645a0f (
plain)
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;
|
