TRUNCATE ppl2grp;
TRUNCATE ppl;
TRUNCATE ppl2agenda;
TRUNCATE ppl2lgrp;
INSERT INTO ppl (naam1, naam2, naam0, login, password, email, type) SELECT roepnaam naam1, tussenvoegsel naam2, achternaam naam0, id login, password, email, 'leerling' type FROM lln;
INSERT INTO ppl (naam1, naam0, login, password, email, oldid, type) SELECT voorletters_tussenvoegsel naam1, achternaam naam0, afkorting, password, email, id oldid, 'leraar' type FROM doc;
INSERT INTO ppl2grp (ppl_id, grp_id) SELECT ppl_id, grp_id FROM ppl JOIN lln2grp ON lln2grp.lln_id = ppl.login;
INSERT INTO ppl2agenda (ppl_id, agenda_id) SELECT ppl_id, agenda_id FROM ppl JOIN lln2agenda ON lln2agenda.lln_id = ppl.login;
INSERT INTO ppl2agenda (ppl_id, agenda_id) SELECT ppl_id, agenda_id FROM ppl JOIN doc ON doc.afkorting = ppl.login JOIN doc2agenda ON doc2agenda.doc_id = doc.id;
INSERT INTO ppl2lgrp (ppl_id, lgrp_id) SELECT ppl_id, grp2vak_id lgrp_id FROM ppl JOIN doc ON doc.afkorting = ppl.login JOIN doc2grp2vak ON doc.id = doc2grp2vak.doc_id;
UPDATE log, ppl SET log.ppl_id = ppl.ppl_id WHERE log.type = 'leerling' AND log.user_id = ppl.login AND ppl.active IS NOT NULL;
UPDATE log, ppl, doc SET log.ppl_id = ppl.ppl_id WHERE log.type = 'leraar' AND log.user_id = doc.id AND doc.afkorting = ppl.login AND ppl.active IS NOT NULL;