ActiveRecord::Schema.define do
  self.verbose = false

  create_table :users, force: true do |t|
    t.string :email
    t.timestamps null: false
  end

  create_table :admins, force: true, inherits: :users do |t|
    t.integer :god_powers, index: :btree
  end

  create_table 'admin/hackers', force: true, inherits: :admins do |t|
    t.integer :god_powers
  end

  create_table :posts, force: true do |t|
    t.integer :user_id
    t.string :title
    t.timestamps null: false
  end

  create_table :comments, force: true do |t|
    t.integer :user_id
    t.integer :post_id
    t.timestamps null: false
  end

  #################################
  ### Custom Inheritance Column ###
  #################################

  create_table :vehicles, force: true do |t|
    t.string :color
    t.string :type # Inheritance column
    t.timestamps null: false
  end

  create_table "vehicles/trucks", force: true, inherits: :vehicles do |t|
    t.integer :bed_size
  end
end

ActiveRecord::Schema.define do
  self.verbose = false

  create_table :users, force: true do |t|
    t.string :email, index: :btree
    t.timestamps null: false
  end

  create_table :admins, force: true, inherits: :users do |t|
    t.integer :god_powers
  end

  create_table 'admin/hackers', force: true, inherits: :admins do |t|
    t.integer :god_powers
  end

  create_table :posts, force: true do |t|
    t.integer :user_id
    t.string :title
    t.timestamps null: false
  end

  create_table :comments, force: true do |t|
    t.integer :user_id
    t.integer :post_id
    t.timestamps null: false
  end

  #################################
  ### Custom Inheritance Column ###
  #################################

  create_table :vehicles, force: true do |t|
    t.string :color
    t.string :type # Inheritance column
    t.timestamps null: false
  end

  create_table "vehicles/trucks", force: true, inherits: :vehicles do |t|
    t.integer :bed_size
  end
end

Move index to be used on parent for testing
Move index to be used on parent for testing
