summaryrefslogtreecommitdiff
path: root/migrations/20220626163140_init.down.sql
blob: 17d256456ed0d263be6d937617e941b74e7c0a01 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
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;