mayor-orig/mayor-naplo/update/pre002492-2-naplo.sql


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`);