aboutsummaryrefslogtreecommitdiffstats
path: root/db/migrate/042_unique_user_urls.rb
blob: 39a7a484902bf428642f61fd088ef3eba8921fe9 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
# -*- encoding : utf-8 -*-
class UniqueUserUrls < ActiveRecord::Migration
    def self.up
        # do last registered ones first, so the last ones get rubbish URLs
        User.find(:all, :order => "id desc").each do |user|
            user.update_url_name
            user.save!
        end
        # MySQL cannot index text blobs like this
        if ActiveRecord::Base.connection.adapter_name != "MySQL"
            remove_index :users, :url_name
            add_index :users, :url_name, :unique => true
        end
    end

    def self.down
        # MySQL cannot index text blobs like this
        if ActiveRecord::Base.connection.adapter_name != "MySQL"
            remove_index :users, :url_name
            add_index :users, :url_name, :unique => false
        end
    end

end