14 lines
598 B
SQL
14 lines
598 B
SQL
-- Schritt 1: Hash-Spalte hinzufügen (additiv, kein Breaking Change)
|
|
ALTER TABLE suppression_list ADD COLUMN IF NOT EXISTS email_hash TEXT;
|
|
|
|
CREATE INDEX IF NOT EXISTS idx_suppression_list_email_hash ON suppression_list(email_hash);
|
|
|
|
-- Schritt 2: Bestehende Einträge hashen (PostgreSQL-native SHA256)
|
|
UPDATE suppression_list
|
|
SET email_hash = encode(sha256(lower(trim(email))::bytea), 'hex')
|
|
WHERE email_hash IS NULL;
|
|
|
|
-- Schritt 3 (nach Validierung separat ausführen):
|
|
-- ALTER TABLE suppression_list ALTER COLUMN email_hash SET NOT NULL;
|
|
-- ALTER TABLE suppression_list DROP COLUMN email;
|