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}',
15 array_to_string(ARRAY (SELECT substring(api_token FROM (ceil(random()*36))::int FOR 1) FROM generate_series(1, 15)), '')
19 change_column_null :api_client_authorizations, :uuid, false
23 if column_exists?(:api_client_authorizations, :uuid)
24 remove_index :api_client_authorizations, :uuid
25 remove_column :api_client_authorizations, :uuid