Contents

class CreateUsers < ActiveRecord::Migration
  def self.up
    create_table :users, force: true do |t|
      t.string :uuid,             limit: 36
      t.string :username,         null: false, default: "", limit: 32
      t.string :email,            null: false, default: "", limit: 64
      t.string :first_name,       limit: 32
      t.string :last_name,        limit: 32
      t.string :title,            limit: 64
      t.string :company,          limit: 64
      t.string :alt_email,        limit: 64
      t.string :phone,            limit: 32
      t.string :mobile,           limit: 32
      t.string :aim,              limit: 32
      t.string :yahoo,            limit: 32
      t.string :google,           limit: 32
      t.string :skype,            limit: 32
      # >>> The following fields are required and maintained by [authlogic] plugin.
      t.string :password_hash,    null: false, default: ""
      t.string :password_salt,    null: false, default: ""
      t.string :remember_token,   null: false, default: ""
      t.string :perishable_token, null: false, default: ""
      t.string :openid_identifier
      t.datetime :last_request_at
      t.datetime :last_login_at
      t.datetime :current_login_at
      t.string :last_login_ip
      t.string :current_login_ip
      t.integer :login_count,      null: false, default: 0
      # >>> End of [authlogic] maintained fields.
      t.datetime :deleted_at
      t.timestamps
    end

    add_index :users, [:username, :deleted_at], unique: true
    add_index :users, :email
    add_index :users, :last_request_at
    add_index :users, :remember_token
    add_index :users, :perishable_token
  end

  def self.down
    drop_table :users
  end
end

Version data entries

7 entries across 7 versions & 2 rubygems

Version	Path
fat_free_crm-0.14.2	db/migrate/20100928030599_create_users.rb
fat_free_crm-0.14.1	db/migrate/20100928030599_create_users.rb
fat_free_crm-0.15.0.beta.2	db/migrate/20100928030599_create_users.rb
fat_free_crm-0.15.0.beta	db/migrate/20100928030599_create_users.rb
fat_free_crm-0.14.0	db/migrate/20100928030599_create_users.rb
reduced_fat_crm-0.15.0.beta	db/migrate/20100928030599_create_users.rb
reduced_fat_crm-0.14.0	db/migrate/20100928030599_create_users.rb