mayor-orig/mayor-naplo/update/orev001587-2-intezmeny.sql


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;