migrations/2021-01-07-122618_dedicated-releases-table/up.sql


1
2
3
4
5
6
7
8
9
10
11
12
13

-- Your SQL goes here
ALTER TABLE
    artifacts
DROP COLUMN
    released;

CREATE TABLE releases (
    id SERIAL PRIMARY KEY NOT NULL,
    artifact_id INTEGER REFERENCES artifacts(id) NOT NULL,
    release_date TIMESTAMP WITH TIME ZONE NOT NULL,

    CONSTRAINT UC_art_release_unique UNIQUE (artifact_id, release_date)
);