qd5hSiKJ

1CREATE UNIQUE INDEX CONCURRENTLY IF NOT EXISTS tmp_mobile_push_tokens_pkey ON mobile_push_tokens USING btree (user_id,id);
2
3ALTER TABLE mobile_push_tokens DROP CONSTRAINT mobile_push_tokens_pkey;
4
5ALTER INDEX tmp_mobile_push_tokens_pkey RENAME TO mobile_push_tokens_pkey;
6
7ALTER TABLE mobile_push_tokens ADD PRIMARY KEY USING INDEX mobile_push_tokens_pkey;
8
9CREATE UNIQUE INDEX CONCURRENTLY IF NOT EXISTS old_mobile_push_tokens_pkey ON mobile_push_tokens USING btree (old_user_id,id);