mirror of
https://github.com/mautrix/signal.git
synced 2026-05-15 21:56:53 -04:00
4 lines
310 B
SQL
4 lines
310 B
SQL
-- v5: Fix profile key column type on postgres
|
|
-- only: postgres
|
|
ALTER TABLE signalmeow_contacts ALTER COLUMN profile_key TYPE bytea USING profile_key::bytea;
|
|
UPDATE signalmeow_contacts SET profile_key=key FROM signalmeow_profile_keys WHERE signalmeow_contacts.aci_uuid=signalmeow_profile_keys.their_aci_uuid;
|