Contents

class CreateUsers < ActiveRecord::Migration
  def self.up
    create_table :users do |t|
      t.string :first_name
      t.string :last_name
      t.integer :age
      t.text :data
      t.boolean :active, :default => false
      t.text    :description
      t.datetime :born_at
      t.timestamps
    end

    create_table :phone_numbers do |t|
      t.string :number
      t.integer :user_id
      t.timestamps
    end

    create_table :websites do |t|
      t.string :url
      t.integer :user_id
      t.string :dns_provider, :default => 'yahoo'
      t.timestamps
    end

    create_table :cities do |t|
      t.string :name
      t.text :data
      t.timestamps
    end

    create_table :clubs do |t|
      t.string :name
    end
    create_table :clubs_users, :id => false do |t|
      t.integer :user_id, :null => false
      t.integer :club_id, :null => false
    end

    # primary_key is not id. It is paper_id .
    # model name is Newspaper
    # set :id => false if the primary_key is string
    # set :id => false if you do not want autoincremental id
    create_table :papers, :id => false, :force => true, :primary_key => 'paper_id' do |t|
      t.string :paper_id, :null => false
      t.string  :name
    end

  end

  def self.down
    drop_table :users
  end
end

Version data entries

13 entries across 13 versions & 1 rubygems

Version	Path
admin_data-1.1.12	test/rails_root/db/migrate/20091030202259_create_users.rb
admin_data-1.1.11	test/rails_root/db/migrate/20091030202259_create_users.rb
admin_data-1.1.10	test/rails_root/db/migrate/20091030202259_create_users.rb
admin_data-1.1.9	test/rails_root/db/migrate/20091030202259_create_users.rb
admin_data-1.1.8	test/rails_root/db/migrate/20091030202259_create_users.rb
admin_data-1.1.7	test/rails_root/db/migrate/20091030202259_create_users.rb
admin_data-1.1.6	test/rails_root/db/migrate/20091030202259_create_users.rb
admin_data-1.1.5	test/rails_root/db/migrate/20091030202259_create_users.rb
admin_data-1.1.4	test/rails_root/db/migrate/20091030202259_create_users.rb
admin_data-1.1.3	test/rails_root/db/migrate/20091030202259_create_users.rb
admin_data-1.1.2	test/rails_root/db/migrate/20091030202259_create_users.rb
admin_data-1.1.1	test/rails_root/db/migrate/20091030202259_create_users.rb
admin_data-1.1.0	test/rails_root/db/migrate/20091030202259_create_users.rb