diff options
| author | Freya Murphy <freya@freyacat.org> | 2024-12-23 11:13:27 -0500 |
|---|---|---|
| committer | Freya Murphy <freya@freyacat.org> | 2024-12-23 11:13:27 -0500 |
| commit | 5a2ba9c2e7605bb788bc406184547d22c6436867 (patch) | |
| tree | cbd988d534e8a8593a31d70571222443f80da0b3 /src/db/migrations/0000.sql | |
| parent | fix about modal (diff) | |
| download | xssbook2-5a2ba9c2e7605bb788bc406184547d22c6436867.tar.gz xssbook2-5a2ba9c2e7605bb788bc406184547d22c6436867.tar.bz2 xssbook2-5a2ba9c2e7605bb788bc406184547d22c6436867.zip | |
v2.1.0, refactor w/ crimson
Diffstat (limited to 'src/db/migrations/0000.sql')
| -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; |