Version 9 (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.