1 files changed, 38 insertions, 0 deletions
diff --git a/db/migrate/20221206211814_add_authorized_scopes_to_slack_integration.rb b/db/migrate/20221206211814_add_authorized_scopes_to_slack_integration.rb
new file mode 100644
index 00000000000..40abf087dfe
--- /dev/null
+++ b/db/migrate/20221206211814_add_authorized_scopes_to_slack_integration.rb
@@ -0,0 +1,38 @@
+# frozen_string_literal: true
+
+class AddAuthorizedScopesToSlackIntegration < Gitlab::Database::Migration[2.1]
+  def up
+    create_table :slack_api_scopes do |t|
+      t.text :name, null: false, limit: 100
+
+      t.index :name, name: 'index_slack_api_scopes_on_name', unique: true
+    end
+
+    create_table :slack_integrations_scopes do |t|
+      references :slack_api_scope,
+        null: false,
+        index: false, # See composite index
+        foreign_key: {
+          to_table: :slack_api_scopes,
+          on_delete: :cascade
+        }
+
+      references :slack_integration,
+        null: false,
+        index: false, # see composite index
+        foreign_key: {
+          to_table: :slack_integrations,
+          on_delete: :cascade
+        }
+
+      t.index [:slack_integration_id, :slack_api_scope_id],
+        unique: true,
+        name: 'index_slack_api_scopes_on_name_and_integration'
+    end
+  end
+
+  def down
+    drop_table :slack_integrations_scopes, if_exists: true
+    drop_table :slack_api_scopes, if_exists: true
+  end
+end