1 -- @tag: contact_titles_own_table
2 -- @description: Eigene Tabelle für Titel bei Ansprechpersonen
3 -- @depends: release_3_5_5
5 CREATE TABLE contact_titles (
7 description TEXT NOT NULL,
12 UPDATE contacts SET cp_title = trim(cp_title) WHERE cp_title NOT LIKE trim(cp_title);
14 INSERT INTO contact_titles (description)
15 SELECT DISTINCT cp_title FROM contacts WHERE cp_title IS NOT NULL AND cp_title NOT LIKE '' ORDER BY cp_title;