Skip to content

Commit a085d87

Browse files
alnrory-bot
alnr
authored and
ory-bot
committed
fix: add missing indices on identity_id
GitOrigin-RevId: 0e9820c93111db7f89f85325a40081737e89978f
1 parent 46f56e7 commit a085d87

8 files changed

Lines changed: 16 additions & 0 deletions

‎persistence/sql/migrations/sql/20251105000000000004_identity_id_not_null_fks.cockroach.down.sql‎

Lines changed: 2 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,2 @@
1+
DROP INDEX IF EXISTS identity_credential_identifiers@identity_credential_identifiers_identities_id_fk_idx;
2+
DROP INDEX IF EXISTS session_devices@session_devices_identities_id_fk_idx;

‎persistence/sql/migrations/sql/20251105000000000004_identity_id_not_null_fks.cockroach.up.sql‎

Lines changed: 2 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,2 @@
1+
CREATE INDEX IF NOT EXISTS identity_credential_identifiers_identities_id_fk_idx ON identity_credential_identifiers (identity_id);
2+
CREATE INDEX IF NOT EXISTS session_devices_identities_id_fk_idx ON session_devices (identity_id);

‎persistence/sql/migrations/sql/20251105000000000004_identity_id_not_null_fks.mysql.down.sql‎

Lines changed: 4 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,4 @@
1+
-- Cannot drop index '...': needed in a foreign key constraint
2+
3+
-- DROP INDEX identity_credential_identifiers_identity_id_fk_idx ON identity_credential_identifiers;
4+
-- DROP INDEX session_devices_identity_id_fk_idx ON session_devices;

‎persistence/sql/migrations/sql/20251105000000000004_identity_id_not_null_fks.mysql.up.sql‎

Lines changed: 2 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,2 @@
1+
CREATE INDEX identity_credential_identifiers_identity_id_fk_idx ON identity_credential_identifiers (identity_id);
2+
CREATE INDEX session_devices_identity_id_fk_idx ON session_devices (identity_id);

‎persistence/sql/migrations/sql/20251105000000000004_identity_id_not_null_fks.postgres.down.sql‎

Lines changed: 2 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,2 @@
1+
DROP INDEX IF EXISTS identity_credential_identifiers_identities_id_fk_idx;
2+
DROP INDEX IF EXISTS session_devices_identities_id_fk_idx;

‎persistence/sql/migrations/sql/20251105000000000004_identity_id_not_null_fks.postgres.up.sql‎

Lines changed: 2 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,2 @@
1+
CREATE INDEX IF NOT EXISTS identity_credential_identifiers_identities_id_fk_idx ON identity_credential_identifiers (identity_id);
2+
CREATE INDEX IF NOT EXISTS session_devices_identities_id_fk_idx ON session_devices (identity_id);

‎persistence/sql/migrations/sql/20251105000000000004_identity_id_not_null_fks.sqlite.down.sql‎

Lines changed: 1 addition & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1 @@
1+
-- Nothing, all done in 20251104000000000000_identifiers_devices_identity_id.sqlite.down.sql

‎persistence/sql/migrations/sql/20251105000000000004_identity_id_not_null_fks.sqlite.up.sql‎

Lines changed: 1 addition & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1 @@
1+
-- Nothing, all done in 20251104000000000000_identifiers_devices_identity_id.sqlite.up.sql

0 commit comments

Comments
 (0)