3 class AddUuidToApiClientAuthorization < ActiveRecord::Migration
4 extend HasUuid::ClassMethods
7 add_column :api_client_authorizations, :uuid, :string
8 add_index :api_client_authorizations, :uuid, :unique => true
10 prefix = Server::Application.config.uuid_prefix + '-' +
11 Digest::MD5.hexdigest('ApiClientAuthorization'.to_s).to_i(16).to_s(36)[-5..-1] + '-'
14 update api_client_authorizations set uuid = (select concat('#{prefix}', substring(api_token, length(api_token)-4), array_to_string(ARRAY (SELECT substring('0123456789abcdefghijklmnopqrstuvwxyz' FROM (ceil(random()*36))::int FOR 1) FROM generate_series(1, 10)), '')));
17 change_column_null :api_client_authorizations, :uuid, false
21 if column_exists?(:api_client_authorizations, :uuid)
22 remove_index :api_client_authorizations, :uuid
23 remove_column :api_client_authorizations, :uuid