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 /db/rest/rest.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 'db/rest/rest.sql')
-rw-r--r-- | db/rest/rest.sql | 50 |
1 files changed, 0 insertions, 50 deletions
diff --git a/db/rest/rest.sql b/db/rest/rest.sql deleted file mode 100644 index 54f5118..0000000 --- a/db/rest/rest.sql +++ /dev/null @@ -1,50 +0,0 @@ -BEGIN TRANSACTION; -SET search_path = public; - -DROP SCHEMA IF EXISTS api CASCADE; -CREATE SCHEMA api; - -DROP SCHEMA IF EXISTS _api CASCADE; -CREATE SCHEMA _api; - -GRANT USAGE ON SCHEMA admin TO rest_anon, rest_user; -GRANT USAGE ON SCHEMA sys TO rest_anon, rest_user; - -GRANT USAGE ON SCHEMA api TO rest_anon, rest_user; -GRANT USAGE ON SCHEMA _api TO rest_anon, rest_user; - --- util -\i /db/rest/util/_api_trim.sql; -\i /db/rest/util/_api_serve_media.sql; -\i /db/rest/util/_api_raise.sql; -\i /db/rest/util/_api_raise_null.sql; -\i /db/rest/util/_api_raise_unique.sql; -\i /db/rest/util/_api_validate_text.sql; -\i /db/rest/util/_api_get_user_id.sql; - --- user -\i /db/rest/user/api_user.sql; -\i /db/rest/user/api_user_insert.sql; -\i /db/rest/user/api_user_update.sql; -\i /db/rest/user/api_user_delete.sql; -\i /db/rest/user/api_avatar.sql; - --- post -\i /db/rest/post/api_post.sql; -\i /db/rest/post/api_post_insert.sql; -\i /db/rest/post/api_post_update.sql; -\i /db/rest/post/api_post_delete.sql; - --- comment -\i /db/rest/comment/api_comment.sql; -\i /db/rest/comment/api_comment_insert.sql; -\i /db/rest/comment/api_comment_update.sql; -\i /db/rest/comment/api_comment_delete.sql; - --- login -\i /db/rest/login/_api_sign_jwt.sql; -\i /db/rest/login/_api_verify_jwt.sql; -\i /db/rest/login/_api_validate_role.sql; -\i /db/rest/login/api_login.sql; - -COMMIT TRANSACTION; |