Migration problem

Hello,

I want to use username so I can log in with username.
So I made this migration file :

class AddDeviseToUsers < ActiveRecord::Migration
def self.up
change_table(:users) do |t|
## Database authenticatable
t.string :username, :null => false, :default => “”
t.string :encrypted_password, :null => false, :default => “”

  ## Recoverable
  t.string   :reset_password_token
  t.datetime :reset_password_sent_at

  ## Rememberable
  t.datetime :remember_created_at

  ## Trackable
  t.integer  :sign_in_count, :default => 0
  t.datetime :current_sign_in_at
  t.datetime :last_sign_in_at
  t.string   :current_sign_in_ip
  t.string   :last_sign_in_ip

  ## Confirmable
  # t.string   :confirmation_token
  # t.datetime :confirmed_at
  # t.datetime :confirmation_sent_at
  # t.string   :unconfirmed_email # Only if using reconfirmable

  ## Lockable
  # t.integer  :failed_attempts, :default => 0 # Only if lock 

strategy
is :failed_attempts
# t.string :unlock_token # Only if unlock strategy is :email or
:both
# t.datetime :locked_at

  ## Token authenticatable
  # t.string :authentication_token


  # Uncomment below if timestamps were not included in your original

model.
# t.timestamps
end

add_index :users, :email
add_index :users, :username,             :unique => true
add_index :users, :reset_password_token, :unique => true
add_index :users, :confirmation_token,   :unique => true
add_index :users, :unlock_token,         :unique => true
add_index :users, :authentication_token, :unique => true

end

def self.down
# By default, we don’t want to make any assumption about how to roll
back a migration when your
# model already existed. Please edit below which fields you would
like
to remove in this migration.
raise ActiveRecord::IrreversibleMigration
end
end

But now I get this error message : SQLite3::SQLException: no such
table:
users: ALTER TABLE “users” ADD “username” varchar(255) DEFAULT ‘’ NOT
NULL

Anyone a idea how to solve this ?
This is a clean install.

Roelof

you need create_table meathod instead change_table.

Matt’s

On 13 November 2012 18:18, Carlos M. [email protected]
wrote:

you need create_table meathod instead change_table.

And since the users table does not already exist you should uncomment
the t.timestamps line.

Colin

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs