gitlab-foss/db/migrate/20250324093114_create_analyzer_namespace_statuses.rb

# frozen_string_literal: true

class CreateAnalyzerNamespaceStatuses < Gitlab::Database::Migration[2.2]
  milestone '17.11'

  ANALYZER_TYPE_INDEX_NAME = 'index_analyzer_namespace_statuses_status'
  TRAVERSAL_IDS_INDEX_NAME = 'index_analyzer_namespace_statuses_traversal_ids'

  def up
    create_table :analyzer_namespace_statuses do |t|
      t.timestamps_with_timezone null: false
      t.bigint :namespace_id, null: false
      t.column :analyzer_type, :smallint, null: false
      t.bigint :success, default: 0, null: false
      t.bigint :failure, default: 0, null: false
      t.bigint :traversal_ids, array: true, default: [], null: false
      t.index :traversal_ids, name: TRAVERSAL_IDS_INDEX_NAME
      t.index [:namespace_id, :analyzer_type], unique: true, name: ANALYZER_TYPE_INDEX_NAME
    end
  end

  def down
    drop_table :analyzer_namespace_statuses
  end
end