gmessages/database/upgrades/02-all-own-ids.sql

4 lines
170 B
MySQL
Raw Permalink Normal View History

-- v2: Store all self-participant IDs
ALTER TABLE "user" RENAME COLUMN phone TO phone_id;
ALTER TABLE "user" ADD COLUMN self_participant_ids jsonb NOT NULL DEFAULT '[]';