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)  );  | 
