Contents

class CreateTables < ActiveRecord::Migration
  def self.up

    create_table :cars do |t|
      t.string :name
      t.timestamps
    end

    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

6 entries across 6 versions & 1 rubygems

Version	Path
admin_data-1.2.1	test/rails_root/db/migrate/20091030202259_create_tables.rb
admin_data-1.2.0	test/rails_root/db/migrate/20091030202259_create_tables.rb
admin_data-1.1.16	test/rails_root/db/migrate/20091030202259_create_tables.rb
admin_data-1.1.15	test/rails_root/db/migrate/20091030202259_create_tables.rb
admin_data-1.1.14	test/rails_root/db/migrate/20091030202259_create_tables.rb
admin_data-1.1.13	test/rails_root/db/migrate/20091030202259_create_tables.rb