diff options
| author | Bryan Newbold <bnewbold@robocracy.org> | 2018-07-20 22:03:49 -0700 |
|---|---|---|
| committer | Bryan Newbold <bnewbold@robocracy.org> | 2018-07-20 22:04:22 -0700 |
| commit | 6f9fb12f93d9ab628cbef781a2480f0483b8f470 (patch) | |
| tree | fc14fb39e34df30c99aebcf6b9f2c507afd8be89 /rust/migrations/2018-05-12-001226_init | |
| parent | 285eddcf04950ecbcf2de9d8b9c54dd0d4afb00c (diff) | |
| download | fatcat-6f9fb12f93d9ab628cbef781a2480f0483b8f470.tar.gz fatcat-6f9fb12f93d9ab628cbef781a2480f0483b8f470.zip | |
sql: work really an empty stub
Diffstat (limited to 'rust/migrations/2018-05-12-001226_init')
| -rw-r--r-- | rust/migrations/2018-05-12-001226_init/up.sql | 12 |
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 |