Don't forget to lycansubscribe
1class AddImportCollections < ActiveRecord::Migration[7.2]
2 def change
3 add_column :imports, :collection, :string, limit: 20, null: true
4
5 reversible do |dir|
6 dir.up do
7 execute "UPDATE imports SET collection = 'likes'"
8 end
9 end
10
11 change_column_null :imports, :collection, false
12
13 remove_index :imports, :user_id, unique: true
14 add_index :imports, [:user_id, :collection], unique: true
15
16 reversible do |dir|
17 dir.down do
18 execute "DELETE FROM imports WHERE collection != 'likes'"
19 end
20 end
21 end
22end