blob: 2ccb1995683f9a48d0cf3227b59901d824600f2f (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
|
-- SQL utasítások a tanév adatbázisban --
alter table ora drop foreign key ora_ibfk_4;
alter table ora add constraint ora_ibfk_4 foreign key (teremId)
references %INTEZMENYDB%.terem(teremId) on delete set null on update cascade;
alter table orarendiOra drop foreign key orarendiOra_ibfk_2;
alter table orarendiOra add constraint orarendiOra_ibfk_2 foreign key (teremId)
references %INTEZMENYDB%.terem(teremId) on delete set null on update cascade;
alter table fogadoOra drop foreign key fogadoOra_ibfk_2;
alter table fogadoOra add constraint fogadoOra_ibfk_2 foreign key (teremId)
references %INTEZMENYDB%.terem(teremId) on delete set null on update cascade;
|
