aboutsummaryrefslogtreecommitdiffstats
path: root/mayor-orig/mayor-naplo/update/orev001836-1-intezmeny.sql
blob: 4c15bb3ba8dbbae1b8c7792666afee4682bf8c82 (plain)
1
2
3
4
5
6
7
8
CREATE TEMPORARY TABLE _tmpDj SELECT CONCAT_WS(':', `diakId`, `dt`, MIN(0+`statusz`)) AS kulcs FROM diakJogviszony GROUP BY diakId, dt HAVING COUNT(*) > 1;

UPDATE diakJogviszony SET dt=dt-INTERVAL 1 DAY WHERE CONCAT_WS(':', `diakId`, `dt`, (0+`statusz`)) IN (SELECT kulcs FROM _tmpDj);

ALTER TABLE diakJogviszony DROP PRIMARY KEY;
ALTER TABLE diakJogviszony ADD PRIMARY KEY (`diakId`, `dt`);