aboutsummaryrefslogtreecommitdiffstats
path: root/rust/migrations/2018-05-12-001226_init
diff options
context:
space:
mode:
authorBryan Newbold <bnewbold@robocracy.org>2018-09-22 17:26:23 -0700
committerBryan Newbold <bnewbold@robocracy.org>2018-09-22 17:26:23 -0700
commit7c53a08666d28f2a2f4c9572f63ae09a362b017b (patch)
treef26ebf92f393f71aff39654ad2611b1bed414011 /rust/migrations/2018-05-12-001226_init
parente9d7d73339df14ef2fe35815e693f0dbd7d1d244 (diff)
downloadfatcat-7c53a08666d28f2a2f4c9572f63ae09a362b017b.tar.gz
fatcat-7c53a08666d28f2a2f4c9572f63ae09a362b017b.zip
container_name (not title), and shrink some BIGINTs
Diffstat (limited to 'rust/migrations/2018-05-12-001226_init')
-rw-r--r--rust/migrations/2018-05-12-001226_init/up.sql8
1 files changed, 4 insertions, 4 deletions
diff --git a/rust/migrations/2018-05-12-001226_init/up.sql b/rust/migrations/2018-05-12-001226_init/up.sql
index d94e9b71..e0b0eefa 100644
--- a/rust/migrations/2018-05-12-001226_init/up.sql
+++ b/rust/migrations/2018-05-12-001226_init/up.sql
@@ -288,7 +288,7 @@ CREATE TABLE release_contrib (
creator_ident_id UUID REFERENCES creator_ident(id),
raw_name TEXT,
role TEXT, -- TODO: enum?
- index_val BIGINT,
+ index_val INTEGER,
extra_json JSONB
);
@@ -299,11 +299,11 @@ CREATE TABLE release_ref (
id BIGSERIAL PRIMARY KEY,
release_rev UUID REFERENCES release_rev(id) NOT NULL,
target_release_ident_id UUID REFERENCES release_ident(id), -- or work?
- index_val BIGINT,
+ index_val INTEGER,
key TEXT,
extra_json JSONB, -- title, year, container_title, locator (aka, page), oci_id
- container_title TEXT,
- year BIGINT,
+ container_name TEXT,
+ year INTEGER,
title TEXT,
locator TEXT
-- TODO: oci_id (TEXT)