class CreateRolesUsersJoin < ActiveRecord::Migration
  def self.up
    create_table :roles_users, :id => false do |t|
      t.integer :role_id, :null => false
      t.integer :user_id, :null => false
    end

    logger.info 'Calling User.create...'

    admin_user = User.create(:login => 'Admin',
                             :email => 'admin@admin.com',
                             :password => 'admin',
                             :password_confirmation => 'admin',
                             :city => 'Anytown',
                             :state_id => 1,
                             :postal_code => '90210',
                             :body_type_id => 1,
                             :drink_id => 1,
                             :ethnicity_id => 1,
                             :eye_color_id => 1,
                             :hair_color_id => 1,
                             :have_children_id => 1,
                             :height_id => 1,
                             :looking_for_id => 1,
                             :marital_status_id => 1,
                             :religion_id => 1,
                             :smoke_id => 1,
                             :want_children_id => 1,
                             :headline => 'This is my headline',
                             :country => 'United States',
                             :gender => 'M',
                             :seeking_a => 'F',
                             :description => 'This is my description',
                             :first_date => 'This is my first date',
                             :first_name => 'System',
                             :last_name => 'Administrator',
                             :born_on => '1973-12-07T22:30:00-05:00',
                             :interests => 'these, are, my, interests',
                             :occupation => 'unemployed',
                             :yahoo_im => 'my_yahoo_im',
                             :aol_im => 'my_aol_im',
                             :msn_im => 'my_msn_im@hotmail.com',
                             :gtalk_im => 'my_gtalk_im@gmail.com',
                             :languages => 'english, spanish, esperanto, klingon',
                             :status => 'active')

    logger.info 'Calling admin_user.save!...'

    admin_user.save!

    admin_role = Role.find_by_name('Administrator')
    admin_user.roles << admin_role
  end

  def self.down
    drop_table :roles_users
    User.find_by_login('Admin').destroy
  end
end



# Logfile created on Mon Jan 07 14:32:43 -0500 2008  SQL (0.000000)   select sqlite_version(*)
  SQL (0.000000)   SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer)
  SQL (0.000000)   SELECT version FROM schema_info
  SQL (0.000000)   SELECT version FROM schema_info
  SQL (0.000000)   SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer)
  SQL (0.000000)   SELECT version FROM schema_info
Migrating to CreateRolesUsersJoin (18)
  SQL (0.000000)   SQLite3::SQLException: no such table: roles_users: DROP TABLE roles_users
  SQL (0.000000)   select sqlite_version(*)
  SQL (0.000000)   SQLite3::SQLException: table schema_info already exists: CREATE TABLE schema_info (version integer)
  SQL (0.000000)   SELECT version FROM schema_info
  SQL (0.000000)   SELECT version FROM schema_info
  SQL (0.000000)   SELECT version FROM schema_info
  SQL (0.000000)   SELECT * FROM schema_info
  SQL (0.000000)    SELECT name
 FROM sqlite_master
 WHERE type = 'table' AND NOT name = 'sqlite_sequence'

  SQL (0.000000)   PRAGMA index_list(body_types)
  SQL (0.000000)   PRAGMA index_list(drinks)
  SQL (0.000000)   PRAGMA index_list(ethnicities)
  SQL (0.000000)   PRAGMA index_list(eye_colors)
  SQL (0.015000)   PRAGMA index_list(hair_colors)
  SQL (0.000000)   PRAGMA index_list(have_childrens)
  SQL (0.000000)   PRAGMA index_list(heights)
  SQL (0.000000)   PRAGMA index_list(looking_fors)
  SQL (0.000000)   PRAGMA index_list(marital_statuses)
  SQL (0.000000)   PRAGMA index_list(photos)
  SQL (0.000000)   PRAGMA index_list(religions)
  SQL (0.000000)   PRAGMA index_list(roles)
  SQL (0.000000)   PRAGMA index_list(smokes)
  SQL (0.000000)   PRAGMA index_list(states)
  SQL (0.000000)   PRAGMA index_list(users)
  SQL (0.000000)   PRAGMA index_info('index_users_on_login')
  SQL (0.000000)   PRAGMA index_list(want_childrens)