diff options
author | Matthias Beyer <matthias.beyer@atos.net> | 2021-02-22 10:34:25 +0100 |
---|---|---|
committer | Matthias Beyer <mail@beyermatthias.de> | 2021-02-25 10:40:16 +0100 |
commit | df1ab6c67de7591f849b14b8bdd94aadfc8fe961 (patch) | |
tree | ebf729871717a6a427ef26d481eed19919eb0cc3 /migrations | |
parent | 88abd90bc6d30c67d7fba883322ed89a13ee81cb (diff) |
Add release stores in database
Signed-off-by: Matthias Beyer <matthias.beyer@atos.net>
Diffstat (limited to 'migrations')
-rw-r--r-- | migrations/2021-02-22-092534_add-release-stores/down.sql | 1 | ||||
-rw-r--r-- | migrations/2021-02-22-092534_add-release-stores/up.sql | 1 |
2 files changed, 2 insertions, 0 deletions
diff --git a/migrations/2021-02-22-092534_add-release-stores/down.sql b/migrations/2021-02-22-092534_add-release-stores/down.sql new file mode 100644 index 0000000..eb8f949 --- /dev/null +++ b/migrations/2021-02-22-092534_add-release-stores/down.sql @@ -0,0 +1 @@ +-- This file should undo anything in `up.sql`
DROP TABLE release_stores;
ALTER TABLE
releases
DROP COLUMN
release_store_id;
\ No newline at end of file diff --git a/migrations/2021-02-22-092534_add-release-stores/up.sql b/migrations/2021-02-22-092534_add-release-stores/up.sql new file mode 100644 index 0000000..fcdceb8 --- /dev/null +++ b/migrations/2021-02-22-092534_add-release-stores/up.sql @@ -0,0 +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;
\ No newline at end of file |