diff options
Diffstat (limited to 'golang/sql/dummy-data.sql')
-rw-r--r-- | golang/sql/dummy-data.sql | 42 |
1 files changed, 0 insertions, 42 deletions
diff --git a/golang/sql/dummy-data.sql b/golang/sql/dummy-data.sql deleted file mode 100644 index d553b9f1..00000000 --- a/golang/sql/dummy-data.sql +++ /dev/null @@ -1,42 +0,0 @@ - --- Fake data at the raw SQL level, for early development and testing - -BEGIN; - -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), - ('f1f046a3-45c9-4b99-adce-000000000002', true, 2, null), - ('f1f046a3-45c9-4b99-adce-000000000003', true, 3, null), - ('f1f046a3-45c9-4b99-adce-000000000004', false, 2, null); - -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; |