summaryrefslogtreecommitdiffstats
path: root/rust/migrations/2018-05-12-001226_init/up.sql
diff options
context:
space:
mode:
authorBryan Newbold <bnewbold@robocracy.org>2018-07-20 22:03:49 -0700
committerBryan Newbold <bnewbold@robocracy.org>2018-07-20 22:04:22 -0700
commit6f9fb12f93d9ab628cbef781a2480f0483b8f470 (patch)
treefc14fb39e34df30c99aebcf6b9f2c507afd8be89 /rust/migrations/2018-05-12-001226_init/up.sql
parent285eddcf04950ecbcf2de9d8b9c54dd0d4afb00c (diff)
downloadfatcat-6f9fb12f93d9ab628cbef781a2480f0483b8f470.tar.gz
fatcat-6f9fb12f93d9ab628cbef781a2480f0483b8f470.zip
sql: work really an empty stub
Diffstat (limited to 'rust/migrations/2018-05-12-001226_init/up.sql')
-rw-r--r--rust/migrations/2018-05-12-001226_init/up.sql12
1 files changed, 4 insertions, 8 deletions
diff --git a/rust/migrations/2018-05-12-001226_init/up.sql b/rust/migrations/2018-05-12-001226_init/up.sql
index 57938534..eb83d6c6 100644
--- a/rust/migrations/2018-05-12-001226_init/up.sql
+++ b/rust/migrations/2018-05-12-001226_init/up.sql
@@ -192,10 +192,6 @@ CREATE INDEX release_edit_idx ON release_edit(editgroup_id);
CREATE TABLE work_rev (
id UUID PRIMARY KEY DEFAULT uuid_generate_v4(),
extra_json JSON,
-
- -- not even a work, for now
- work_type TEXT, -- TODO: enum?
- primary_release_id UUID REFERENCES release_ident(id)
);
CREATE TABLE work_ident (
@@ -342,10 +338,10 @@ INSERT INTO file_edit (ident_id, rev_id, redirect_id, editgroup_id) VALUES
('00000000-0000-0000-3333-000000000002', '00000000-0000-0000-3333-FFF000000002', null, '00000000-0000-0000-BBBB-000000000004'),
('00000000-0000-0000-3333-000000000003', '00000000-0000-0000-3333-FFF000000003', null, '00000000-0000-0000-BBBB-000000000005');
-INSERT INTO work_rev (id, work_type, primary_release_id) VALUES
- ('00000000-0000-0000-5555-FFF000000001', null, null),
- ('00000000-0000-0000-5555-FFF000000002', 'pre-print', null),
- ('00000000-0000-0000-5555-FFF000000003', 'journal-article', null);
+INSERT INTO work_rev (id) VALUES
+ ('00000000-0000-0000-5555-FFF000000001'),
+ ('00000000-0000-0000-5555-FFF000000002'),
+ ('00000000-0000-0000-5555-FFF000000003');
INSERT INTO work_ident (id, is_live, rev_id, redirect_id) VALUES
('00000000-0000-0000-5555-000000000001', true, '00000000-0000-0000-5555-FFF000000001', null), -- aaaaaaaaaaaaavkvaaaaaaaaae