summaryrefslogtreecommitdiff
path: root/db/migrations/20170421143052_fix_duplicates.sql
blob: a0ffbf0645afe09fd500d8c182c9b70463d9a0c6 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15

-- +goose Up
-- SQL in section 'Up' is executed when this migration is applied

-- Peter Yuill has a duplicate entry in the voters table he has ids 17 and 31

UPDATE votes SET voter=17 WHERE voter=31;
UPDATE decisions SET proponent=17 WHERE proponent=31;
DELETE FROM emails WHERE voter=31;
DELETE FROM voters WHERE id=31;

-- +goose Down
-- SQL section 'Down' is executed when this migration is rolled back

-- There is no useful backward migration