aboutsummaryrefslogtreecommitdiffstats
path: root/mayor-orig/mayor-naplo/update/pre002090-1-intezmeny.sql
blob: 35831563a544c2bb53767e524500e90bede77c1f (plain)
1
2
3
4
alter table terem drop column `telephely`;
alter table terem add column `telephelyId` tinyint(3) unsigned DEFAULT NULL;
alter table terem add constraint `terem_telephely` FOREIGN KEY (`telephelyId`) REFERENCES `telephely` (`telephelyId`) ON DELETE SET NULL ON UPDATE SET NULL;