1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
|
# frozen_string_literal: true
class ChangeDashboardAnalyticsProjectPointerProjectNull < Gitlab::Database::Migration[2.1]
disable_ddl_transaction!
EXISTENCE_CONSTRAINT = 'chk_analytics_dashboards_pointers_project_or_namespace'
NEW_UNIQ_INDEX = 'idx_uniq_analytics_dashboards_pointers_on_project_id'
OLD_INDEX = 'index_analytics_dashboards_pointers_on_project_id'
def up
add_check_constraint :analytics_dashboards_pointers,
"(project_id IS NULL) <> (namespace_id IS NULL)",
EXISTENCE_CONSTRAINT
change_column_null :analytics_dashboards_pointers, :target_project_id, false
add_concurrent_index :analytics_dashboards_pointers, :project_id, name: NEW_UNIQ_INDEX, unique: true
remove_concurrent_index_by_name :analytics_dashboards_pointers, OLD_INDEX
end
def down
remove_check_constraint :analytics_dashboards_pointers, EXISTENCE_CONSTRAINT
change_column_null :analytics_dashboards_pointers, :target_project_id, true
add_concurrent_index :analytics_dashboards_pointers, :project_id, name: OLD_INDEX
remove_concurrent_index_by_name :analytics_dashboards_pointers, NEW_UNIQ_INDEX
end
end
|