summaryrefslogtreecommitdiff
path: root/db/migrate/20141121161704_add_identity_table.rb
blob: 7d019c65ee13e335bc67500cd4bc6613d5e908fe (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
class AddIdentityTable < ActiveRecord::Migration
  def up
    create_table :identities do |t|
      t.string :extern_uid
      t.string :provider
      t.references :user
    end

    add_index :identities, :user_id

    User.where("provider is not NULL").find_each do |user|
      execute "INSERT INTO identities(provider, extern_uid, user_id) VALUES('#{user.provider}', '#{user.extern_uid}', '#{user.id}')"
    end

    #TODO remove user's columns extern_uid and provider
  end

  def down
#TODO
  end
end