Files

 master

/

migrations

/

Copy path

Directory actions

More options

Directory actions

More options

Latest commit

olirice

fix: Revert "fix: revert fallback on btree indexes when hash is unava…

Dec 6, 2024

9fe5b1e · Dec 6, 2024

History

History

/

migrations

/

Top

Folders and files

Name		Name	Last commit message	Last commit date
parent directory ..
00_init_auth_schema.up.sql		00_init_auth_schema.up.sql	fix: #1218 fixes existing migrations to allow namespaces!="auth" (#1279)	Oct 20, 2023
20210710035447_alter_users.up.sql		20210710035447_alter_users.up.sql	refactor: remove auth schema prefix (#669)	Sep 12, 2022
20210722035447_adds_confirmed_at.up.sql		20210722035447_adds_confirmed_at.up.sql	refactor: remove auth schema prefix (#669)	Sep 12, 2022
20210730183235_add_email_change_confirmed.up.sql		20210730183235_add_email_change_confirmed.up.sql	refactor: remove auth schema prefix (#669)	Sep 12, 2022
20210909172000_create_identities_table.up.sql		20210909172000_create_identities_table.up.sql	refactor: remove auth schema prefix (#669)	Sep 12, 2022
20210927181326_add_refresh_token_parent.up.sql		20210927181326_add_refresh_token_parent.up.sql	fix: add missing namespace prefix to index targets (#892)	Feb 17, 2023
20211122151130_create_user_id_idx.up.sql		20211122151130_create_user_id_idx.up.sql	fix: add missing namespace prefix to index targets (#892)	Feb 17, 2023
20211124214934_update_auth_functions.up.sql		20211124214934_update_auth_functions.up.sql	chore: replace tabs in migration with spaces (#843)	Dec 2, 2022
20211202183645_update_auth_uid.up.sql		20211202183645_update_auth_uid.up.sql	refactor: remove auth schema prefix (#669)	Sep 12, 2022
20220114185221_update_user_idx.up.sql		20220114185221_update_user_idx.up.sql	fix: add missing namespace prefix to index targets (#892)	Feb 17, 2023
20220114185340_add_banned_until.up.sql		20220114185340_add_banned_until.up.sql	refactor: remove auth schema prefix (#669)	Sep 12, 2022
20220224000811_update_auth_functions.up.sql		20220224000811_update_auth_functions.up.sql	chore: replace tabs in migration with spaces (#843)	Dec 2, 2022
20220323170000_add_user_reauthentication.up.sql		20220323170000_add_user_reauthentication.up.sql	refactor: remove auth schema prefix (#669)	Sep 12, 2022
20220429102000_add_unique_idx.up.sql		20220429102000_add_unique_idx.up.sql	refactor: remove auth schema prefix (#669)	Sep 12, 2022
20220531120530_add_auth_jwt_function.up.sql		20220531120530_add_auth_jwt_function.up.sql	refactor: remove auth schema prefix (#669)	Sep 12, 2022
20220614074223_add_ip_address_to_audit_log.postgres.up.sql		20220614074223_add_ip_address_to_audit_log.postgres.up.sql	refactor: remove auth schema prefix (#669)	Sep 12, 2022
20220811173540_add_sessions_table.up.sql		20220811173540_add_sessions_table.up.sql	refactor: remove auth schema prefix (#669)	Sep 12, 2022
20221003041349_add_mfa_schema.up.sql		20221003041349_add_mfa_schema.up.sql	fix: #1218 fixes existing migrations to allow namespaces!="auth" (#1279)	Oct 20, 2023
20221003041400_add_aal_and_factor_id_to_sessions.up.sql		20221003041400_add_aal_and_factor_id_to_sessions.up.sql	fix: add mfa migrations (#722)	Oct 3, 2022
20221011041400_add_mfa_indexes.up.sql		20221011041400_add_mfa_indexes.up.sql	fix: make migration idempotent (#923)	Feb 1, 2023
20221020193600_add_sessions_user_id_index.up.sql		20221020193600_add_sessions_user_id_index.up.sql	fix: add missing index on user_id under sessions (#763)	Oct 21, 2022
20221021073300_add_refresh_tokens_session_id_revoked_index.up.sql		20221021073300_add_refresh_tokens_session_id_revoked_index.up.sql	fix: add index on (session_id, revoked) in refresh_tokens (#765)	Oct 21, 2022
20221021082433_add_saml.up.sql		20221021082433_add_saml.up.sql	refactor: use template schema in SAML migration (#772)	Oct 25, 2022
20221027105023_add_identities_user_id_idx.up.sql		20221027105023_add_identities_user_id_idx.up.sql	fix: add index on identities.user_id (#781)	Oct 28, 2022
20221114143122_add_session_not_after_column.up.sql		20221114143122_add_session_not_after_column.up.sql	feat(saml): add not_after column to sessions table (not used) (#810)	Nov 15, 2022
20221114143410_remove_parent_foreign_key_refresh_tokens.up.sql		20221114143410_remove_parent_foreign_key_refresh_tokens.up.sql	fix: remove foreign key constraint on refresh_tokens.parent	Nov 15, 2022
20221125140132_backfill_email_identity.up.sql		20221125140132_backfill_email_identity.up.sql	feat: use DO blocks around SQL statements in migrations (#1335)	Jan 15, 2024
20221208132122_backfill_email_last_sign_in_at.up.sql		20221208132122_backfill_email_last_sign_in_at.up.sql	feat: use DO blocks around SQL statements in migrations (#1335)	Jan 15, 2024
20221215195500_modify_users_email_unique_index.up.sql		20221215195500_modify_users_email_unique_index.up.sql	feat: make dropping users_email_key backward compatible (#995)	Mar 20, 2023
20221215195800_add_identities_email_column.up.sql		20221215195800_add_identities_email_column.up.sql	feat: use DO blocks around SQL statements in migrations (#1335)	Jan 15, 2024
20221215195900_remove_sso_sessions.up.sql		20221215195900_remove_sso_sessions.up.sql	feat: remove duplicate add_identities_email_column migrations, reor…	Dec 15, 2022
20230116124310_alter_phone_type.up.sql		20230116124310_alter_phone_type.up.sql	feat: make phone data type alter backward compatible (#994)	Mar 20, 2023
20230116124412_add_deleted_at.up.sql		20230116124412_add_deleted_at.up.sql	feat: add soft delete option to admin delete endpoint (#489)	Jan 16, 2023
20230131181311_backfill_invite_identities.up.sql		20230131181311_backfill_invite_identities.up.sql	feat: use DO blocks around SQL statements in migrations (#1335)	Jan 15, 2024
20230322519590_add_flow_state_table.up.sql		20230322519590_add_flow_state_table.up.sql	fix: make flow_state migrations idempotent, add index (#1086)	Apr 18, 2023
20230402418590_add_authentication_method_to_flow_state_table.up.sql		20230402418590_add_authentication_method_to_flow_state_table.up.sql	fix: make flow_state migrations idempotent, add index (#1086)	Apr 18, 2023
20230411005111_remove_duplicate_idx.up.sql		20230411005111_remove_duplicate_idx.up.sql	fix: make migration idempotent (#1079)	May 6, 2023
20230508135423_add_cleanup_indexes.up.sql		20230508135423_add_cleanup_indexes.up.sql	feat: add database cleanup logic, runs after each request (#875)	May 9, 2023
20230523124323_add_mfa_challenge_cleanup_index.up.sql		20230523124323_add_mfa_challenge_cleanup_index.up.sql	feat: add mfa cleanup (#1105)	May 23, 2023
20230818113222_add_flow_state_to_relay_state.up.sql		20230818113222_add_flow_state_to_relay_state.up.sql	feat: add sso pkce (#1137)	Aug 23, 2023
20230914180801_add_mfa_factors_user_id_idx.up.sql		20230914180801_add_mfa_factors_user_id_idx.up.sql	feat: add index on user_id of mfa_factors (#1247)	Sep 15, 2023
20231027141322_add_session_refresh_columns.up.sql		20231027141322_add_session_refresh_columns.up.sql	feat: add inactivity-timeout to sessions (#1288)	Nov 6, 2023
20231114161723_add_sessions_tag.up.sql		20231114161723_add_sessions_tag.up.sql	feat: add single session per user with tags support (#1297)	Nov 15, 2023
20231117164230_add_id_pkey_identities.up.sql		20231117164230_add_id_pkey_identities.up.sql	feat: update primary key for identities table (#1311)	Nov 20, 2023
20240115144230_remove_ip_address_from_saml_relay_state.up.sql		20240115144230_remove_ip_address_from_saml_relay_state.up.sql	fix: update file name so migration to Drop IP Address is applied (#1447)	Feb 22, 2024
20240214120130_add_is_anonymous_column.up.sql		20240214120130_add_is_anonymous_column.up.sql	feat: anonymous sign-ins (#1460)	Mar 3, 2024
20240306115329_add_issued_at_to_flow_state.up.sql		20240306115329_add_issued_at_to_flow_state.up.sql	fix: impose expiry on auth code instead of magic link (#1440)	Mar 13, 2024
20240314092811_add_saml_name_id_format.up.sql		20240314092811_add_saml_name_id_format.up.sql	feat: configurable NameID format for SAML provider (#1481)	Mar 14, 2024
20240427152123_add_one_time_tokens_table.up.sql		20240427152123_add_one_time_tokens_table.up.sql	fix: Revert "fix: revert fallback on btree indexes when hash is unava…	Dec 6, 2024
20240612123726_enable_rls_update_grants.up.sql		20240612123726_enable_rls_update_grants.up.sql	fix: enable rls & update grants for auth tables (#1617)	Jun 12, 2024
20240729123726_add_mfa_phone_config.up.sql		20240729123726_add_mfa_phone_config.up.sql	fix: add last_challenged_at field to mfa factors (#1705)	Aug 5, 2024
20240802193726_add_mfa_factors_column_last_challenged_at.up.sql		20240802193726_add_mfa_factors_column_last_challenged_at.up.sql	fix: add last_challenged_at field to mfa factors (#1705)	Aug 5, 2024
20240806073726_drop_uniqueness_constraint_on_phone.up.sql		20240806073726_drop_uniqueness_constraint_on_phone.up.sql	fix: make drop_uniqueness_constraint_on_phone idempotent (#1817)	Oct 28, 2024
20241009103726_add_web_authn.up.sql		20241009103726_add_web_authn.up.sql	feat: add MFA for WebAuthn (#1775)	Oct 11, 2024
View all files