summaryrefslogtreecommitdiff
path: root/db/migrate/20220401110511_add_runtime_data_columns_to_vsa_aggregations.rb
diff options
context:
space:
mode:
Diffstat (limited to 'db/migrate/20220401110511_add_runtime_data_columns_to_vsa_aggregations.rb')
-rw-r--r--db/migrate/20220401110511_add_runtime_data_columns_to_vsa_aggregations.rb23
1 files changed, 23 insertions, 0 deletions
diff --git a/db/migrate/20220401110511_add_runtime_data_columns_to_vsa_aggregations.rb b/db/migrate/20220401110511_add_runtime_data_columns_to_vsa_aggregations.rb
new file mode 100644
index 00000000000..09960c7add6
--- /dev/null
+++ b/db/migrate/20220401110511_add_runtime_data_columns_to_vsa_aggregations.rb
@@ -0,0 +1,23 @@
+# frozen_string_literal: true
+
+class AddRuntimeDataColumnsToVsaAggregations < Gitlab::Database::Migration[1.0]
+ def up
+ change_table(:analytics_cycle_analytics_aggregations, bulk: true) do |t|
+ t.integer :full_runtimes_in_seconds, array: true, default: [], null: false
+ t.integer :full_processed_records, array: true, default: [], null: false
+ t.column :last_full_merge_requests_updated_at, :datetime_with_timezone
+ t.column :last_full_issues_updated_at, :datetime_with_timezone
+ t.integer :last_full_issues_id
+ t.integer :last_full_merge_requests_id
+ end
+ end
+
+ def down
+ remove_column :analytics_cycle_analytics_aggregations, :full_runtimes_in_seconds
+ remove_column :analytics_cycle_analytics_aggregations, :full_processed_records
+ remove_column :analytics_cycle_analytics_aggregations, :last_full_merge_requests_updated_at
+ remove_column :analytics_cycle_analytics_aggregations, :last_full_issues_updated_at
+ remove_column :analytics_cycle_analytics_aggregations, :last_full_issues_id
+ remove_column :analytics_cycle_analytics_aggregations, :last_full_merge_requests_id
+ end
+end