blob: 42f235ff45c2e4a543dc65968fd733e10443f20b (
plain)
1
2
3
4
5
6
|
alter table `osztaly` drop foreign key `osztaly_ibfk_1`;
alter table `osztaly` change `kirOsztalyJellegId` `osztalyJellegId` tinyint(3) unsigned DEFAULT NULL;
alter table `osztaly` add
CONSTRAINT `osztaly_ibfk_1` FOREIGN KEY (`osztalyJellegId`) REFERENCES `mayor_naplo`.`osztalyJelleg` (`osztalyJellegId`) ON DELETE SET NULL ON UPDATE CASCADE;
ALTER TABLE osztaly MODIFY vegzoTanev smallint(5) unsigned DEFAULT NULL;
|
