summaryrefslogtreecommitdiffstats
path: root/migrations/2021-02-22-092534_add-release-stores/up.sql
blob: fcdceb89a0a2b3c9fd5e873c0b83572536557963 (plain)
1
-- Your SQL goes here

CREATE TABLE release_stores (
    id SERIAL PRIMARY KEY NOT NULL,
     store_name VARCHAR(255) NOT NULL UNIQUE
);

ALTER TABLE
    releases
ADD COLUMN
    release_store_id INTEGER REFERENCES release_stores(id) NOT NULL;