v2.1.0, refactor w/ crimson

4 files changed, 0 insertions, 55 deletions

diff --git a/src/db/ext.sql b/src/db/ext.sql
deleted file mode 100644
index 2f3376f..0000000
--- a/src/db/ext.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-BEGIN TRANSACTION;
-SET search_path = public;
-
-CREATE EXTENSION IF NOT EXISTS pgcrypto;
-CREATE EXTENSION IF NOT EXISTS pgjwt;
-
-COMMIT TRANSACTION;
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;
diff --git a/src/db/rev.sql b/src/db/rev.sql
deleted file mode 100644
index dff1cfe..0000000
--- a/src/db/rev.sql
+++ /dev/null
@@ -1,21 +0,0 @@
-CREATE OR REPLACE FUNCTION curr_revision()
-RETURNS INTEGER
-LANGUAGE plpgsql VOLATILE
-AS $BODY$
-DECLARE
-	_revision INTEGER;
-BEGIN
-	BEGIN
-		SELECT curr_revision INTO _revision
-			FROM sys.database_info
-			WHERE name = current_database();
-		RETURN _revision;
-	EXCEPTION WHEN OTHERS THEN
-		RETURN 0;
-	END;
-END
-$BODY$;
-
-GRANT EXECUTE ON FUNCTION curr_revision() TO xssbook;
-
-SELECT curr_revision();