Schritte zur Umstellung der SQL-Datenbank
- Schalte "nicht null" Eigenschaft von id ab, id darf dazu nicht mehr primär key sein.
Hilfsdatenbanken - current_work
alter table current_work add column key_main text;
update current_work set key_main = (select personal_www.key from personal_www where personal_www.id=current_work.id_main);
alter table research_interest add column key_main text;
update research_interest set key_main = (select personal_www.key from personal_www where personal_www.id=research_interest.id_main);
alter table publications add column key_main text;
update publications set key_main = (select personal_www.key from personal_www where personal_www.id=publications.id_main);
alter table talks add column key_main text;
update talks set key_main = (select personal_www.key from personal_www where personal_www.id=talks.id_main);