Contents

class AddAttributionIdToUniqueIndex < Landable::Migration
  def up
    execute <<-SQL
      ALTER TABLE #{Landable.configuration.database_schema_prefix}landable_traffic.referers 
              DROP CONSTRAINT referers_domain_id_path_id_query_string_id_key;
      CREATE UNIQUE INDEX referers_domain_id_path_id_query_string_id_attribution_id 
              ON #{Landable.configuration.database_schema_prefix}landable_traffic.referers(domain_id, path_id, query_string_id, attribution_id);
    SQL
  end
end

Version data entries

16 entries across 16 versions & 1 rubygems

Version	Path
landable-1.13.1	db/migrate/20131121150902_add_attribution_id_to_unique_index.rb
landable-1.12.3	db/migrate/20131121150902_add_attribution_id_to_unique_index.rb
landable-1.12.2	db/migrate/20131121150902_add_attribution_id_to_unique_index.rb
landable-1.12.1	db/migrate/20131121150902_add_attribution_id_to_unique_index.rb
landable-1.11.1	db/migrate/20131121150902_add_attribution_id_to_unique_index.rb
landable-1.11.0	db/migrate/20131121150902_add_attribution_id_to_unique_index.rb
landable-1.10.0.rc2	db/migrate/20131121150902_add_attribution_id_to_unique_index.rb
landable-1.10.0.rc1	db/migrate/20131121150902_add_attribution_id_to_unique_index.rb
landable-1.9.2	db/migrate/20131121150902_add_attribution_id_to_unique_index.rb
landable-1.9.1	db/migrate/20131121150902_add_attribution_id_to_unique_index.rb
landable-1.9.0	db/migrate/20131121150902_add_attribution_id_to_unique_index.rb
landable-1.9.0.rc2	db/migrate/20131121150902_add_attribution_id_to_unique_index.rb
landable-1.9.0.rc1	db/migrate/20131121150902_add_attribution_id_to_unique_index.rb
landable-1.8.0	db/migrate/20131121150902_add_attribution_id_to_unique_index.rb
landable-1.7.1.rc1	db/migrate/20131121150902_add_attribution_id_to_unique_index.rb
landable-1.7.0	db/migrate/20131121150902_add_attribution_id_to_unique_index.rb