summaryrefslogtreecommitdiff
path: root/db/post_migrate/20170913180600_fix_projects_without_project_feature.rb
diff options
context:
space:
mode:
Diffstat (limited to 'db/post_migrate/20170913180600_fix_projects_without_project_feature.rb')
-rw-r--r--db/post_migrate/20170913180600_fix_projects_without_project_feature.rb33
1 files changed, 0 insertions, 33 deletions
diff --git a/db/post_migrate/20170913180600_fix_projects_without_project_feature.rb b/db/post_migrate/20170913180600_fix_projects_without_project_feature.rb
deleted file mode 100644
index bbc624ac7c0..00000000000
--- a/db/post_migrate/20170913180600_fix_projects_without_project_feature.rb
+++ /dev/null
@@ -1,33 +0,0 @@
-class FixProjectsWithoutProjectFeature < ActiveRecord::Migration[4.2]
- DOWNTIME = false
-
- def up
- # Deletes corrupted project features
- sql = "DELETE FROM project_features WHERE project_id IS NULL"
- execute(sql)
-
- # Creates missing project features with private visibility
- sql =
- %Q{
- INSERT INTO project_features(project_id, repository_access_level, issues_access_level, merge_requests_access_level, wiki_access_level,
- builds_access_level, snippets_access_level, created_at, updated_at)
- SELECT projects.id as project_id,
- 10 as repository_access_level,
- 10 as issues_access_level,
- 10 as merge_requests_access_level,
- 10 as wiki_access_level,
- 10 as builds_access_level ,
- 10 as snippets_access_level,
- projects.created_at,
- projects.updated_at
- FROM projects
- LEFT OUTER JOIN project_features ON project_features.project_id = projects.id
- WHERE (project_features.id IS NULL)
- }
-
- execute(sql)
- end
-
- def down
- end
-end