== 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 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; }}}