Missing "on delete" directive on oic_sessions foreign key

[rmdir]

Hi,
With postgres, when deleting a user added via OIC, I get an error

update or delete on table "users" violates foreign key constraint "fk_rails_fb3c08edd2" on table "oic_sessions"

An on delete casacde on the foreign key fix the issue

alter table oic_sessions drop constraint fk_rails_fb3c08edd2;
alter table oic_sessions add constraint fk_rails_fb3c08edd2 FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE;

---

Many thanks
Joris

Redmine version 4.2.4.stable
Ruby version 2.7.5-p203 (2021-11-24) [x86_64-linux]
Rails version 5.2.6.2
Database adapter PostgreSQL
redmine_openid_connect 0.9.4

[rmdir]

This patch does the job

diff --git a/db/migrate/001_create_oic_sessions.rb b/db/migrate/001_create_oic_sessions.rb
index 286402d..a509e8a 100644
--- a/db/migrate/001_create_oic_sessions.rb
+++ b/db/migrate/001_create_oic_sessions.rb
@@ -1,7 +1,7 @@
 class CreateOicSessions < ActiveRecord::Migration[4.2]
   def self.up
     create_table :oic_sessions do |t|
-      t.references :user, foreign_key: true
+      t.references :user, foreign_key: {on_delete: :cascade}
       t.text :code
       t.string :state
       t.string :nonce