Sha256: 95dddbe26151ef85f91d5563296934eb0500c86a2b6e49bf717aa4a25f8d7270
Contents?: true
Size: 678 Bytes
Versions: 28
Compression:
Stored size: 678 Bytes
Contents
class AddUniqueIndexOnOrganizationOauthUid < ActiveRecord::Migration
def change
# Disconnect accounts linked several times
if ActiveRecord::Base.connection.class.to_s == 'ActiveRecord::ConnectionAdapters::Mysql2Adapter'
execute <<-SQL
UPDATE organizations AS o
INNER JOIN
(SELECT organizations.oauth_uid, min(organizations.id) minid FROM organizations GROUP BY oauth_uid) o1
ON o.oauth_uid = o1.oauth_uid AND o.id != o1.minid
SET o.oauth_uid = null, o.encrypted_oauth_token = null, encrypted_refresh_token= null, sync_enabled = false
SQL
end
add_index :organizations, :oauth_uid, unique: true
end
end
Version data entries
28 entries across 28 versions & 1 rubygems