aboutsummaryrefslogtreecommitdiff
path: root/sqitch/deploy/change_git_branches_primary_key.sql
blob: af0ff80a7a50212831225e7e2b4ce57f6d16d639 (plain)
1
2
3
4
5
6
7
8
9
-- Deploy guix-data-service:change_git_branches_primary_key to pg

BEGIN;

ALTER TABLE git_branches DROP CONSTRAINT name_commit;

ALTER TABLE git_branches ADD PRIMARY KEY (name, commit, git_repository_id);

COMMIT;