class BortMigration < ActiveRecord::Migration
  def self.up
    # Create Sessions Table
    create_table :sessions do |t|
      t.string :session_id, :null => false
      t.text :data
      t.timestamps
    end

    add_index :sessions, :session_id
    add_index :sessions, :updated_at

    # Create OpenID Tables
    create_table :open_id_authentication_associations, :force => true do |t|
      t.integer :issued, :lifetime
      t.string :handle, :assoc_type
      t.binary :server_url, :secret
    end

    create_table :open_id_authentication_nonces, :force => true do |t|
      t.integer :timestamp, :null => false
      t.string :server_url, :null => true
      t.string :salt, :null => false
    end

    # Create Users Table
    create_table :users do |t|
      t.string :login, :limit => 40
      t.string :identity_url
      t.string :name, :limit => 100, :default => '', :null => true
      t.string :email, :limit => 100
      t.string :crypted_password, :limit => 40
      t.string :salt, :limit => 40
      t.string :remember_token, :limit => 40
      t.string :activation_code, :limit => 40
      t.string :state, :null => :no, :default => 'passive'
      t.datetime :remember_token_expires_at
      t.datetime :activated_at
      t.datetime :deleted_at
      t.timestamps
    end

    add_index :users, :login, :unique => true

    # Create Passwords Table
    create_table :passwords do |t|
      t.integer :user_id
      t.string :reset_code
      t.datetime :expiration_date
      t.timestamps
    end

    # Create Roles Databases
    create_table :roles do |t|
      t.string :name
    end

    create_table :roles_users, :id => false do |t|
      t.belongs_to :role
      t.belongs_to :user
    end

    # Create admin role
    admin_role = Role.create(:name => 'admin')

    # Create default admin user
    user = User.create do |u|
      u.login = 'admin'
      u.password = u.password_confirmation = 'chester'
      u.email = APP_CONFIG[:admin_email]
    end

    # Activate user
    user.register!
    user.activate!

    # Add admin role to admin user
    user.roles << admin_role
  end

  def self.down
    # Drop all Bort tables
    drop_table :sessions
    drop_table :users
    drop_table :passwords
    drop_table :roles
    drop_table :roles_users
    drop_table :open_id_authentication_associations
    drop_table :open_id_authentication_nonces
  end
end



cayce@ubuntu:/var/www/apps/safety-dance/current$ rake db:drop:all RAILS_ENV=production
(in /var/www/apps/safety-dance/releases/20081018034901)
cayce@ubuntu:/var/www/apps/safety-dance/current$ rake db:create:all RAILS_ENV=production
(in /var/www/apps/safety-dance/releases/20081018034901)
cayce@ubuntu:/var/www/apps/safety-dance/current$ rake db:migrate RAILS_ENV=production --trace
(in /var/www/apps/safety-dance/releases/20081018034901)
** Invoke db:migrate (first_time)
** Invoke environment (first_time)
** Execute environment
** Execute db:migrate
== 20080929171348 BortMigration: migrating ====================================
-- create_table(:sessions)
   -> 0.0015s
-- add_index(:sessions, :session_id)
   -> 0.0321s
-- add_index(:sessions, :updated_at)
   -> 0.0415s
-- create_table(:open_id_authentication_associations, {:force=>true})
   -> 0.0350s
-- create_table(:open_id_authentication_nonces, {:force=>true})
   -> 0.0020s
-- create_table(:users)
   -> 0.0355s
-- add_index(:users, :login, {:unique=>true})
   -> 0.0438s
-- create_table(:passwords)
   -> 0.0380s
-- create_table(:roles)
   -> 0.0017s
-- create_table(:roles_users, {:id=>false})
   -> 0.0340s
rake aborted!
Connection refused - connect(2)
/usr/local/lib/ruby/1.8/net/protocol.rb:206:in `initialize'
/usr/local/lib/ruby/1.8/net/protocol.rb:206:in `new'
/usr/local/lib/ruby/1.8/net/protocol.rb:206:in `old_open'
/usr/local/lib/ruby/1.8/timeout.rb:62:in `timeout'
/usr/local/lib/ruby/1.8/timeout.rb:93:in `timeout'
/usr/local/lib/ruby/1.8/net/protocol.rb:206:in `old_open'
/usr/local/lib/ruby/1.8/net/smtp.rb:392:in `do_start'
/usr/local/lib/ruby/1.8/net/smtp.rb:377:in `start'
/usr/local/lib/ruby/1.8/net/smtp.rb:315:in `start'
/var/www/apps/safety-dance/releases/20081018034901/vendor/rails/actionmailer/lib/action_mailer/base.rb:628:in `perform_delivery_smtp'
/var/www/apps/safety-dance/releases/20081018034901/vendor/rails/actionmailer/lib/action_mailer/base.rb:508:in `__send__'
/var/www/apps/safety-dance/releases/20081018034901/vendor/rails/actionmailer/lib/action_mailer/base.rb:508:in `deliver!'
/var/www/apps/safety-dance/releases/20081018034901/vendor/rails/actionmailer/lib/action_mailer/base.rb:383:in `method_missing'
/var/www/apps/safety-dance/releases/20081018034901/app/models/user_observer.rb:3:in `after_create'
/var/www/apps/safety-dance/releases/20081018034901/vendor/rails/activerecord/lib/active_record/observer.rb:171:in `send'
/var/www/apps/safety-dance/releases/20081018034901/vendor/rails/activerecord/lib/active_record/observer.rb:171:in `update'
/usr/local/lib/ruby/1.8/observer.rb:185:in `notify_observers'
/usr/local/lib/ruby/1.8/observer.rb:184:in `each'
/usr/local/lib/ruby/1.8/observer.rb:184:in `notify_observers'
/var/www/apps/safety-dance/releases/20081018034901/vendor/rails/activerecord/lib/active_record/callbacks.rb:309:in `notify'
/var/www/apps/safety-dance/releases/20081018034901/vendor/rails/activerecord/lib/active_record/callbacks.rb:296:in `callback'
/var/www/apps/safety-dance/releases/20081018034901/vendor/rails/activerecord/lib/active_record/callbacks.rb:221:in `create_without_timestamps'
/var/www/apps/safety-dance/releases/20081018034901/vendor/rails/activerecord/lib/active_record/timestamp.rb:29:in `create'
/var/www/apps/safety-dance/releases/20081018034901/vendor/rails/activerecord/lib/active_record/base.rb:2483:in `create_or_update_without_callbacks'
/var/www/apps/safety-dance/releases/20081018034901/vendor/rails/activerecord/lib/active_record/callbacks.rb:207:in `create_or_update'
/var/www/apps/safety-dance/releases/20081018034901/vendor/rails/activerecord/lib/active_record/base.rb:2211:in `save_without_validation'
/var/www/apps/safety-dance/releases/20081018034901/vendor/rails/activerecord/lib/active_record/validations.rb:911:in `save_without_dirty'
/var/www/apps/safety-dance/releases/20081018034901/vendor/rails/activerecord/lib/active_record/dirty.rb:75:in `save_without_transactions'
/var/www/apps/safety-dance/releases/20081018034901/vendor/rails/activerecord/lib/active_record/transactions.rb:106:in `save'
/var/www/apps/safety-dance/releases/20081018034901/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:66:in `transaction'
/var/www/apps/safety-dance/releases/20081018034901/vendor/rails/activerecord/lib/active_record/transactions.rb:79:in `transaction'
/var/www/apps/safety-dance/releases/20081018034901/vendor/rails/activerecord/lib/active_record/transactions.rb:98:in `transaction'
/var/www/apps/safety-dance/releases/20081018034901/vendor/rails/activerecord/lib/active_record/transactions.rb:106:in `save'
/var/www/apps/safety-dance/releases/20081018034901/vendor/rails/activerecord/lib/active_record/transactions.rb:118:in `rollback_active_record_state!'
/var/www/apps/safety-dance/releases/20081018034901/vendor/rails/activerecord/lib/active_record/transactions.rb:106:in `save'
/var/www/apps/safety-dance/releases/20081018034901/vendor/rails/activerecord/lib/active_record/base.rb:644:in `create'
./db/migrate//20080929171348_bort_migration.rb:67:in `up_without_benchmarks'
/var/www/apps/safety-dance/releases/20081018034901/vendor/rails/activerecord/lib/active_record/migration.rb:280:in `send'
/var/www/apps/safety-dance/releases/20081018034901/vendor/rails/activerecord/lib/active_record/migration.rb:280:in `migrate'
/usr/local/lib/ruby/1.8/benchmark.rb:293:in `measure'
/var/www/apps/safety-dance/releases/20081018034901/vendor/rails/activerecord/lib/active_record/migration.rb:280:in `migrate'
/var/www/apps/safety-dance/releases/20081018034901/vendor/rails/activerecord/lib/active_record/migration.rb:455:in `migrate'
/var/www/apps/safety-dance/releases/20081018034901/vendor/rails/activerecord/lib/active_record/migration.rb:445:in `each'
/var/www/apps/safety-dance/releases/20081018034901/vendor/rails/activerecord/lib/active_record/migration.rb:445:in `migrate'
/var/www/apps/safety-dance/releases/20081018034901/vendor/rails/activerecord/lib/active_record/migration.rb:373:in `up'
/var/www/apps/safety-dance/releases/20081018034901/vendor/rails/activerecord/lib/active_record/migration.rb:356:in `migrate'
/var/www/apps/safety-dance/releases/20081018034901/vendor/rails/railties/lib/tasks/databases.rake:99
/usr/local/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:617:in `call'
/usr/local/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:617:in `execute'
/usr/local/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:612:in `each'
/usr/local/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:612:in `execute'
/usr/local/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:578:in `invoke_with_call_chain'
/usr/local/lib/ruby/1.8/monitor.rb:242:in `synchronize'
/usr/local/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:571:in `invoke_with_call_chain'
/usr/local/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:564:in `invoke'
/usr/local/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:2019:in `invoke_task'
/usr/local/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:1997:in `top_level'
/usr/local/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:1997:in `each'
/usr/local/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:1997:in `top_level'
/usr/local/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:2036:in `standard_exception_handling'
/usr/local/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:1991:in `top_level'
/usr/local/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:1970:in `run'
/usr/local/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:2036:in `standard_exception_handling'
/usr/local/lib/ruby/gems/1.8/gems/rake-0.8.3/lib/rake.rb:1967:in `run'
/usr/local/lib/ruby/gems/1.8/gems/rake-0.8.3/bin/rake:31
/usr/local/bin/rake:19:in `load'
/usr/local/bin/rake:19