aboutsummaryrefslogtreecommitdiffstats
path: root/mayor-orig/update/pre002492-2-naplo.sql
blob: 24cb43c8bc77291afbfb4440ece444505d7740d6 (plain)
1
2
3
4
INSERT INTO munkaterv (munkatervId,munkatervNev) VALUES (1,'alapértelmezett');
UPDATE nap SET munkatervId=1 WHERE munkatervId IS NULL;
 alter table ora drop foreign key `ora_ibfk_5`;
 alter table nap drop primary key, add primary key (`munkatervId`,`dt`);