summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorpennae <github@quasiparticle.net>2022-07-13 16:21:18 +0200
committerpennae <github@quasiparticle.net>2022-07-13 16:21:18 +0200
commitd62d1be05ca16a4836ad66440fda477f4ed6817a (patch)
tree50678ff8f6955af08865a897aa91e1748189f5ed
parent91f28bf586cc8e9adc5671462918770c752f686f (diff)
downloadminor-skulk-d62d1be05ca16a4836ad66440fda477f4ed6817a.tar.gz
minor-skulk-d62d1be05ca16a4836ad66440fda477f4ed6817a.tar.xz
minor-skulk-d62d1be05ca16a4836ad66440fda477f4ed6817a.zip
add downgrade migration for first schema version
-rw-r--r--migrations/20220626163140_init.down.sql45
1 files changed, 44 insertions, 1 deletions
diff --git a/migrations/20220626163140_init.down.sql b/migrations/20220626163140_init.down.sql
index 8b13789..17d2564 100644
--- a/migrations/20220626163140_init.down.sql
+++ b/migrations/20220626163140_init.down.sql
@@ -1 +1,44 @@
-
+drop procedure prune_expired_verify_codes;
+drop procedure prune_expired_tokens;
+drop table invite_codes;
+drop procedure reset_user_auth;
+drop table account_reset_tokens;
+drop table password_change_tokens;
+drop index oauth_authorization__expires_at__idx;
+drop table oauth_authorization;
+drop trigger device__cascade_ on device;
+drop function cascade_device_delete;
+drop trigger oauth_token__cascade_session on oauth_token;
+drop function cascade_oauth_delete;
+drop index oauth_token__expires_at__idx;
+drop table oauth_token;
+drop index key_fetch__expires_at__idx;
+drop table key_fetch;
+drop index device_command__expires__idx;
+drop index device_command__device_id__idx;
+drop table device_commands;
+drop table verify_codes;
+drop trigger user_session__cascade_device on user_session;
+drop function cascade_session_delete;
+drop table user_session;
+drop function insert_or_update_device;
+drop table device;
+drop table user_avatars;
+drop index user__email__idx;
+drop table users;
+drop type device_push_info;
+drop type device_command;
+drop type oauth_access_type;
+drop type oauth_token_kind;
+drop domain avatar_id;
+drop domain account_reset_id;
+drop domain password_change_id;
+drop domain verify_hash;
+drop domain secret_key;
+drop domain oauth_auth_id;
+drop domain oauth_token_id;
+drop domain key_fetch_id;
+drop domain device_id;
+drop domain hawk_key;
+drop domain user_id;
+drop domain session_id;