2 files changed, 0 insertions, 110 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;
diff --git a/golang/sql/fatcat-schema.sql b/golang/sql/fatcat-schema.sql
deleted file mode 100644
index fe07390f..00000000
--- a/golang/sql/fatcat-schema.sql
+++ /dev/null
@@ -1,68 +0,0 @@
-
--- written for Postgres 9.6 with OSSP extension for UUIDs
-
-CREATE EXTENSION IF NOT EXISTS "uuid-ossp";
-
-DROP TABLE IF EXISTS editor CASCADE;
-DROP TABLE IF EXISTS editgroup CASCADE;
-DROP TABLE IF EXISTS changelog CASCADE;
-DROP TABLE IF EXISTS creator_rev CASCADE;
-DROP TABLE IF EXISTS creator_ident CASCADE;
-DROP TABLE IF EXISTS creator_edit CASCADE;
-
--- uuid_generate_v1mc: timestamp ordered, random MAC address
--- uuid_generate_v4:   totally random
-
--- NB: could use LIKE clause, or "composite types"
-
-CREATE TABLE editor (
-    id                  BIGSERIAL PRIMARY KEY,
-    username            TEXT NOT NULL,
-    is_admin            BOOLEAN NOT NULL DEFAULT false,
-    active_editgroup_id BIGINT -- REFERENCES( editgroup(id) via ALTER below
-);
-
-CREATE TABLE editgroup (
-    id                  BIGSERIAL PRIMARY KEY,
-    extra_json          JSON,
-    editor_id           BIGSERIAL REFERENCES editor(id) NOT NULL,
-    description         TEXT
-);
-
-ALTER TABLE editor
-    ADD CONSTRAINT editor_editgroupid_fkey FOREIGN KEY (active_editgroup_id)
-        REFERENCES editgroup(id);
-
-CREATE TABLE changelog (
-    id                  BIGSERIAL PRIMARY KEY,
-    editgroup_id        BIGINT REFERENCES editgroup(id) NOT NULL,
-    timestamp           TIMESTAMP WITHOUT TIME ZONE DEFAULT now()
-);
-
-CREATE TABLE creator_rev (
-    id                  BIGSERIAL PRIMARY KEY,
-    extra_json          JSON,
-
-    name                TEXT,
-    orcid               TEXT
-);
-
--- Could denormalize a "is_live" flag into revision tables, to make indices
--- more efficient
-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 DEFAULT false,
-    rev_id              BIGINT REFERENCES creator_rev(id),
-    redirect_id         UUID REFERENCES creator_ident(id)
-);
-
-CREATE TABLE creator_edit (
-    id                  BIGSERIAL PRIMARY KEY,
-    extra_json          JSON,
-    ident_id            UUID REFERENCES creator_ident(id) NOT NULL,
-    rev_id              BIGINT REFERENCES creator_rev(id),
-    redirect_id         UUID REFERENCES creator_ident(id),
-    editgroup_id        BIGINT REFERENCES editgroup(id) NOT NULL
-);