summaryrefslogtreecommitdiff
path: root/db/migrate/20211011140930_create_ci_namespace_mirrors.rb
blob: b9a708c5d7ba34ce14b4c2d4b6edb670e6589417 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
# frozen_string_literal: true

class CreateCiNamespaceMirrors < Gitlab::Database::Migration[1.0]
  TABLE_NAME = :ci_namespace_mirrors
  INDEX_NAME = "index_gin_#{TABLE_NAME}_on_traversal_ids"

  def change
    create_table TABLE_NAME do |t|
      t.integer :namespace_id, null: false, index: { unique: true }
      t.integer :traversal_ids, array: true, default: [], null: false

      t.index :traversal_ids, name: INDEX_NAME, using: :gin
    end
  end
end