aboutsummaryrefslogtreecommitdiffstats
path: root/mayor-orig/update/orev001324-1-naplo.sql
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;