diff options
| author | Freya Murphy <freya@freyacat.org> | 2024-04-01 11:09:25 -0400 |
|---|---|---|
| committer | Freya Murphy <freya@freyacat.org> | 2024-04-01 11:09:25 -0400 |
| commit | 3a82baec9d793edf81ac2b151b0f4d4159641375 (patch) | |
| tree | f9d50c296b078ac48c2a2391c172c3ccf37edb3f /src/db/migrations/0001.sql | |
| parent | refactor asset dir, refactor oberver in lib (diff) | |
| download | xssbook2-3a82baec9d793edf81ac2b151b0f4d4159641375.tar.gz xssbook2-3a82baec9d793edf81ac2b151b0f4d4159641375.tar.bz2 xssbook2-3a82baec9d793edf81ac2b151b0f4d4159641375.zip | |
login and register, liking on homepage
Diffstat (limited to 'src/db/migrations/0001.sql')
| -rw-r--r-- | src/db/migrations/0001.sql | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/src/db/migrations/0001.sql b/src/db/migrations/0001.sql new file mode 100644 index 0000000..d20d895 --- /dev/null +++ b/src/db/migrations/0001.sql @@ -0,0 +1,17 @@ +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; +GRANT rest_user TO authenticator; +-- Migration End; + +-- Set Current Revision +UPDATE sys.database_info SET curr_revision = 2 WHERE name = current_database(); + +COMMIT TRANSACTION; |