diff options
Diffstat (limited to '')
-rw-r--r-- | src/db/migrations/0000.sql | 24 |
1 files changed, 0 insertions, 24 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; |