Version 12 (modified by 17 years ago) (diff) | ,
---|
Schritte zur Umstellung der SQL-Datenbank
- Erzeuge neues Feld key und web_object_created
alter table personal_www add column key text; alter table personal_www add column web_object_created text;
- Belege das Key Feld
update personal_www set key = trim(both ' ' from vorname)||'_'||trim(both ' ' from name)
- Umbenennen
alter table personal_www rename vorname to first_name; alter table personal_www rename name to last_name; alter table personal_www rename position to status; alter table personal_www rename abteilung to department; alter table personal_www rename heimat_inst to home_inst; alter table personal_www rename stay_at_mpiwg to date_stay_at_mpiwg;
- 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.key_main);