aboutsummaryrefslogtreecommitdiffstats
path: root/mayor-orig/update/orev001587-2-intezmeny.sql
blob: aa4dabba72bfbc361fb35cae2e1d3e0f12385a8e (plain)
1
2
3
4
ALTER TABLE kepzesOraterv ADD kepzesId smallint unsigned not null AFTER kepzesOratervId;
ALTER TABLE kepzesOraterv ADD FOREIGN KEY(kepzesId) REFERENCES kepzes(kepzesId) ON DELETE CASCADE ON UPDATE CASCADE;
alter table kepzes ADD kezdoEvfolyam tinyint unsigned null;
alter table kepzes ADD zaroEvfolyam tinyint unsigned null;