Contents

class CreateTables < ActiveRecord::Migration
  def up
    create_table :some_files, :force => true do |t|
      t.string  :name
    end

    create_table :people, :force => true do |t|
      t.string  :name, :null => false
      t.integer :age
    end

    create_table :accounts, :force => true do |t|
      t.string  :name, :null => false
      t.integer :person_id, :null => false
    end

    create_table :addresses, :force => true do |t|
      t.string  :country, :null => false
      t.string  :city, :null => false
      t.string  :street, :null => false
      t.integer :addressable_id, :null => false
      t.string  :addressable_type, :null => false
    end

    create_table :customers, :force => true do |t|
      t.string  :name
      t.date    :created_at
      t.boolean :vip, :null => false
    end

    create_table :orders, :force => true do |t|
      t.string  :name
      t.integer :billing_customer_id
      t.integer :shipping_customer_id
    end

    create_table :posts, :force => true do |t|
      t.string :title
      t.text   :body
    end

    create_table :categories, :force => true do |t|
      t.string :name
    end

    create_table :categories_posts, :id => false, :force => true do |t|
      t.integer :category_id, :null => false
      t.integer :post_id, :null => false
    end

    create_table :composite_pks, :id => false, :force => true do |t|
      t.integer :first_id, :null => false
      t.integer :second_id, :null => false
      t.string  :name
    end
    execute "ALTER TABLE composite_pks ADD PRIMARY KEY (first_id,second_id)"

    create_table :products, :force => true do |t|
      t.string :name
    end

    create_table :product_ins, :force => true do |t|
      t.belongs_to :product
      t.integer    :quantity
      t.integer    :buy_price
    end

    create_table :product_outs, :force => true do |t|
      t.belongs_to :product
      t.integer    :quantity
      t.integer    :sale_price
    end
  end

  def down
  end
end

Version data entries

1 entries across 1 versions & 1 rubygems

Version	Path
visual_query-0.3.0	test/dummy/db/migrate/20130927112446_create_tables.rb