diff options
Diffstat (limited to 'golang/sql')
-rw-r--r-- | golang/sql/dummy-data.sql | 56 | ||||
-rw-r--r-- | golang/sql/fatcat-schema.sql | 2 |
2 files changed, 29 insertions, 29 deletions
diff --git a/golang/sql/dummy-data.sql b/golang/sql/dummy-data.sql index 9e01fae8..d553b9f1 100644 --- a/golang/sql/dummy-data.sql +++ b/golang/sql/dummy-data.sql @@ -3,29 +3,29 @@ BEGIN; -INSERT INTO editor (id, username, is_admin) VALUES - (1, 'admin', true), - (2, 'claire', true), - (3, 'doug', false); - -INSERT INTO editgroup (id, editor_id, description) VALUES - (1, 1, 'first edit ever!'), - (2, 1, 'another one!'), - (3, 3, 'user edit'), - (4, 2, 'uncommited edit'); - -INSERT INTO editor (id, username, is_admin, active_editgroup_id) VALUES - (4, 'bnewbold', true, 4); - -INSERT INTO changelog (id, editgroup_id) VALUES - (1, 1), - (2, 2), - (3, 3); - -INSERT INTO creator_rev (id, name, orcid) VALUES - (1, 'Grace Hopper', null), - (2, 'Emily Noethe', null), - (3, 'Christine Moran', '0000-0003-2088-7465'); +INSERT INTO editor (username, is_admin) VALUES + ('admin', true), + ('claire', true), + ('doug', false); + +INSERT INTO editgroup (editor_id, description) VALUES + (1, 'first edit ever!'), + (1, 'another one!'), + (3, 'user edit'), + (2, 'uncommited edit'); + +INSERT INTO editor (username, is_admin, active_editgroup_id) VALUES + ('bnewbold', true, 4); + +INSERT INTO changelog (editgroup_id) VALUES + (1), + (2), + (3); + +INSERT INTO creator_rev (name, orcid) VALUES + ('Grace Hopper', null), + ('Emily Noethe', null), + ('Christine Moran', '0000-0003-2088-7465'); INSERT INTO creator_ident (id, is_live, rev_id, redirect_id) VALUES ('f1f046a3-45c9-4b99-adce-000000000001', true, 1, null), @@ -33,10 +33,10 @@ INSERT INTO creator_ident (id, is_live, rev_id, redirect_id) VALUES ('f1f046a3-45c9-4b99-adce-000000000003', true, 3, null), ('f1f046a3-45c9-4b99-adce-000000000004', false, 2, null); -INSERT INTO creator_edit (id, ident_id, rev_id, redirect_id, editgroup_id) VALUES - (1, 'f1f046a3-45c9-4b99-adce-000000000001', 1, null, 1), - (2, 'f1f046a3-45c9-4b99-adce-000000000002', 2, null, 2), - (3, 'f1f046a3-45c9-4b99-adce-000000000003', 3, null, 3), - (4, 'f1f046a3-45c9-4b99-adce-000000000004', 2, null, 4); +INSERT INTO creator_edit (ident_id, rev_id, redirect_id, editgroup_id) VALUES + ('f1f046a3-45c9-4b99-adce-000000000001', 1, null, 1), + ('f1f046a3-45c9-4b99-adce-000000000002', 2, null, 2), + ('f1f046a3-45c9-4b99-adce-000000000003', 3, null, 3), + ('f1f046a3-45c9-4b99-adce-000000000004', 2, null, 4); COMMIT; diff --git a/golang/sql/fatcat-schema.sql b/golang/sql/fatcat-schema.sql index f5983371..fe07390f 100644 --- a/golang/sql/fatcat-schema.sql +++ b/golang/sql/fatcat-schema.sql @@ -53,7 +53,7 @@ CREATE INDEX creator_rev_orcid_idx ON creator_rev(orcid) WHERE orcid IS NOT NULL CREATE TABLE creator_ident ( id UUID PRIMARY KEY DEFAULT uuid_generate_v4(), - is_live BOOL NOT NULL, + is_live BOOL NOT NULL DEFAULT false, rev_id BIGINT REFERENCES creator_rev(id), redirect_id UUID REFERENCES creator_ident(id) ); |