kivitendo/sql/Pg-upgrade2/gender.sql @ 40ad4ed6
| e09347c8 | Geoffrey Richardson | -- @tag: gender
|
|
-- @description: Feld "Geschlecht" zu Kontaktdaten hinzufuegen, cp_greeting entferne
|
|||
-- @depends: release_2_6_0
|
|||
ALTER TABLE contacts ADD COLUMN cp_gender char(1);
|
|||
UPDATE contacts SET cp_gender = 'm';
|
|||
UPDATE contacts SET cp_gender = 'f'
|
|||
WHERE (cp_greeting ILIKE '%frau%')
|
|||
OR (cp_greeting ILIKE '%mrs.%')
|
|||
OR (cp_greeting ILIKE '%miss%');
|
|||
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%');
|
|||
ALtER TABLE contacts DROP COLUMN cp_greeting;
|