v2.1.0, refactor w/ crimson

2 files changed, 0 insertions, 27 deletions

diff --git a/src/db/migrations/0000.sql b/src/db/migrations/0000.sql
index aa20d2f..e921578 100644
--- a/src/db/migrations/0000.sql
+++ b/src/db/migrations/0000.sql
@@ -3,30 +3,6 @@ SET search_path = public;
 
 -- Migration Start
 
-CREATE SCHEMA sys;
-
-ALTER SCHEMA sys OWNER TO xssbook;
-
-CREATE DOMAIN sys."*/*" AS BYTEA;
-
-CREATE TABLE sys.database_info (
-	name TEXT DEFAULT ''::text NOT NULL,
-	jwt_secret TEXT DEFAULT ''::text NOT NULL,
-	curr_revision INTEGER DEFAULT 0 NOT NULL
-);
-
-ALTER TABLE sys.database_info
-	ADD CONSTRAINT database_info_pkey PRIMARY KEY (name);
-
-ALTER TABLE sys.database_info OWNER TO xssbook;
-
-INSERT INTO sys.database_info
-	(name, curr_revision) VALUES (current_database(), 0);
-
-CREATE TYPE sys.JWT AS (
-	token TEXT
-);
-
 CREATE SCHEMA admin;
 
 ALTER SCHEMA admin OWNER TO xssbook;
diff --git a/src/db/migrations/0001.sql b/src/db/migrations/0001.sql
index d20d895..9f6f312 100644
--- a/src/db/migrations/0001.sql
+++ b/src/db/migrations/0001.sql
@@ -2,9 +2,6 @@ BEGIN TRANSACTION;
 SET search_path = public;
 
 -- Migration Start
-CREATE ROLE authenticator LOGIN NOINHERIT NOCREATEDB NOCREATEROLE NOSUPERUSER;
--- scary, make sure the db is not public!!!
-ALTER ROLE authenticator WITH PASSWORD 'postgrest';
 CREATE ROLE rest_anon NOLOGIN;
 CREATE ROLE rest_user NOLOGIN;
 GRANT rest_anon TO authenticator;