1 files changed, 27 insertions, 0 deletions
diff --git a/db/migrate/20220511144946_add_work_item_parent_child_table.rb b/db/migrate/20220511144946_add_work_item_parent_child_table.rb
new file mode 100644
index 00000000000..160dac78160
--- /dev/null
+++ b/db/migrate/20220511144946_add_work_item_parent_child_table.rb
@@ -0,0 +1,27 @@
+# frozen_string_literal: true
+
+class AddWorkItemParentChildTable < Gitlab::Database::Migration[2.0]
+  def up
+    create_table :work_item_parent_links do |t|
+      t.references :work_item,
+                   index: false,
+                   unique: true,
+                   foreign_key: { to_table: :issues, on_delete: :cascade },
+                   null: false
+      t.references :work_item_parent,
+                   index: true,
+                   foreign_key: { to_table: :issues, on_delete: :cascade },
+                   null: false
+      t.integer :relative_position
+      t.timestamps_with_timezone null: false
+
+      t.index [:work_item_id, :work_item_parent_id],
+              unique: true,
+              name: :index_parent_links_on_work_item_id_and_work_item_parent_id
+    end
+  end
+
+  def down
+    drop_table :work_item_parent_links
+  end
+end