Quentin Gliech f083ccf333 Add an index on the last_active_at column of the sessions tables

2024-07-19 13:40:27 +02:00

..

20220530084123_jobs_workers.sql

WIP: use apalis to schedule jobs

2023-04-14 10:22:22 +02:00

20221018142001_init.sql

Split the storage trait from the implementation

2023-01-18 10:38:22 +01:00

20221121151402_upstream_oauth.sql

Split the storage trait from the implementation

2023-01-18 10:38:22 +01:00

20221213145242_password_schemes.sql

Split the storage trait from the implementation

2023-01-18 10:38:22 +01:00

20230408234928_add_get_jobs_fn_.sql

Upgrade to apalis-0.4.0-alpha.5

2023-04-14 10:22:22 +02:00

20230616093555_compat_admin_flag.sql

Add a admin flag to the compatibility session

2023-06-16 15:24:38 +02:00

20230621140528_upstream_oauth_claims_imports.sql

Ground work to import upstream OIDC claims on registration.

2023-06-26 17:24:56 +02:00

20230626130338_oauth_clients_static.sql

Sync the OAuth2 clients with CLI and remove redundant CLI tools

2023-06-26 17:24:56 +02:00

20230728154304_user_lock.sql

Add a way to lock users

2023-08-03 14:06:34 +02:00

20230823125247_drop_apalis_push_job.sql

Remove the pgcrypto extension requirement

2023-08-23 18:46:45 +02:00

20230828085439_oauth2_clients_more_fields.sql

Save the application_type and the contacts in the OAuth 2.0 clients

2023-08-28 14:41:49 +02:00

20230828143553_user_session_authentication_source.sql

Save the authentication method on each authorization

2023-08-28 17:14:59 +02:00

20230829092920_oauth2_sessions_user_id_scope_list.sql

Add the user_id directly on oauth2_sessions and make the scope a text list

2023-08-29 12:52:24 +02:00

20230829141928_user_session_user_agent.sql

Store the browser user-agent when starting a browser session

2023-08-29 17:38:01 +02:00

20230904135550_oauth2_client_credentials_grant.sql

Implement the client credentials grant

2023-09-06 09:35:34 +02:00

20230911091636_oauth2_token_expiration.sql

storage: make the access token expiration optional

2023-09-11 12:03:42 +02:00

20230919155444_record_session_last_activity.sql

Save the session activity in the database

2023-09-19 21:57:54 +02:00

20231009142904_user_can_request_admin.sql

"Can request admin" flag on user

2023-10-09 18:52:30 +02:00

20231116104353_upstream_oauth_overrides.sql

Allow endpoints and discovery mode override for upstream oauth2 providers

2023-11-17 16:18:39 +01:00

20231120110559_upstream_oauth_branding.sql

Add upstream OAuth 2.0 providers name and branding

2023-11-20 17:23:02 +01:00

20231207090532_oauth_device_code_grant.sql

Record the user agent and IP in the device code grant

2024-02-02 18:01:51 +01:00

20231208155602_oauth_clients_device_code_grant.sql

Save whether the client supports the device code grant in the database

2024-02-02 18:01:51 +01:00

20240207100003_user_terms.sql

Setup a repository to track user terms agreements

2024-02-07 17:21:22 +01:00

20240220141353_nonunique_compat_device_id.sql

Remove the unique constraint on device IDs on compatibility sessions

2024-02-20 15:50:20 +01:00

20240220150201_compat_sessions_user_sessions_link.sql

Save which user session created a compat session

2024-02-21 11:55:58 +01:00

20240221164945_sessions_user_agent.sql

Record user agents on OAuth 2.0 and compat sessions (#2386)

2024-02-22 10:01:32 +01:00

20240301091201_upstream_oauth_additional_parameters.sql

Additional parameters from upstream OAuth2 providers in the data model

2024-03-01 14:36:37 +01:00

20240402084854_upstream_oauth_disabled_at.sql

Add a soft-deletion column on upstream OAuth 2.0 providers

2024-04-03 09:51:22 +02:00

20240621080509_user_recovery.sql

Data model and repository for the user recovery flow

2024-06-28 15:59:21 +02:00

20240718075125_sessions_active_index.sql

Add an index on the last_active_at column of the sessions tables

2024-07-19 13:40:27 +02:00