2 -- @description: Feld "Geschlecht" zu Kontaktdaten hinzufuegen, cp_greeting entferne
3 -- @depends: release_2_6_0
5 ALTER TABLE contacts ADD COLUMN cp_gender char(1);
6 UPDATE contacts SET cp_gender = 'm';
7 UPDATE contacts SET cp_gender = 'f'
8 WHERE (cp_greeting ILIKE '%frau%')
9 OR (cp_greeting ILIKE '%mrs.%')
10 OR (cp_greeting ILIKE '%miss%');
12 UPDATE contacts SET cp_title = cp_greeting WHERE NOT (cp_greeting ILIKE '%frau%' OR cp_greeting ILIKE '%herr%' or cp_greeting ILIKE '%mrs.%' or cp_greeting ILIKE '%miss%');
14 ALtER TABLE contacts DROP COLUMN cp_greeting;