summaryrefslogtreecommitdiff
path: root/db/post_migrate/20200706154619_drop_ci_daily_report_results_table.rb
blob: c6ce52012d615a41b48fc24e345e65fe9f7364ed (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
# frozen_string_literal: true

class DropCiDailyReportResultsTable < ActiveRecord::Migration[6.0]
  DOWNTIME = false

  def up
    drop_table :ci_daily_report_results
  end

  def down
    create_table :ci_daily_report_results do |t|
      t.date :date, null: false
      t.bigint :project_id, null: false
      t.bigint :last_pipeline_id, null: false
      t.float :value, null: false
      t.integer :param_type, limit: 8, null: false
      t.string :ref_path, null: false
      t.string :title, null: false

      t.index :last_pipeline_id
      t.index [:project_id, :ref_path, :param_type, :date, :title], name: 'index_daily_report_results_unique_columns', unique: true
    end
  end
end