Schritte zur Umstellung der SQL-Datenbank

• Erzeuge neues Feld key

    alter table personal_www add column key 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 last_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;