Add action_participants migration

1 files changed, 13 insertions, 0 deletions

diff --git a/db/migrate/20260723011350_create_action_participants.rb b/db/migrate/20260723011350_create_action_participants.rb
new file mode 100644
index 00000000..493ac502
--- /dev/null
+++ b/db/migrate/20260723011350_create_action_participants.rb
@@ -0,0 +1,13 @@
+class CreateActionParticipants < ActiveRecord::Migration[8.1]
+  def change
+    create_table :action_participants do |t|
+      t.references :node_action, null: false, foreign_key: true, index: false
+      t.references :subject, polymorphic: true, null: false, index: false
+    end
+    add_index :action_participants, [:subject_type, :subject_id, :node_action_id],
+              :name => "index_action_participants_on_subject_and_action"
+    add_index :action_participants, [:node_action_id, :subject_type, :subject_id],
+              :unique => true,
+              :name => "index_action_participants_uniqueness"
+  end
+end