blob: 345b749f1a43032514cbd6f271917d758e5dec98 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
|
# frozen_string_literal: true
class SetIssueIdForAllVersions < ActiveRecord::Migration[5.2]
DOWNTIME = false
def up
execute('UPDATE design_management_versions as versions SET issue_id = (
SELECT design_management_designs.issue_id
FROM design_management_designs
INNER JOIN design_management_designs_versions ON design_management_designs.id = design_management_designs_versions.design_id
WHERE design_management_designs_versions.version_id = versions.id
LIMIT 1
)')
end
def down
# no-op
end
end
|