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

  create_table :topics, force: true do |t|
    t.string :title
    t.string :description
    t.timestamps null: true
  end

  create_table :posts, force: true do |t|
    t.integer :topic_id
    t.integer :owner_id
    t.integer :author_id
    t.string :title
    t.string :contents
    t.timestamps null: true
  end

  create_table :products, force: true do |t|
    t.string :type
    t.string :title
    t.decimal :price
    t.decimal :weight
    t.decimal :cost
    t.decimal :sleeve
    t.decimal :collar
    t.decimal :length
    t.string :metal
  end

  create_table :products_sections, force: true do |t|
    t.integer :section_id
    t.integer :product_id
  end

  create_table :sections, force: true do |t|
    t.string :name
    t.integer :num_employees
    t.decimal :total_sales
  end

  create_table :images, force: true do |t|
    t.string :filename
    t.integer :product_id
  end

  create_table :employees, force: true do |t|
    t.string :name
    t.string :ssn
    t.decimal :salary
  end

  create_table :customers, force: true do |t|
    t.string :email
    t.string :password
    t.decimal :balance
  end

  create_table :addresses, force: true do |t|
    t.integer :addressable_id
    t.string :addressable_type

    t.string :street
    t.string :unit
    t.string :city
    t.string :state
    t.string :zip
  end

  create_table :post_configs, force: true do |t|
    t.integer :post_id
    t.integer :is_visible
    t.integer :is_open
    t.string :password
    t.timestamps null: true
  end

  create_table :comments, force: true do |t|
    t.integer :post_id
    t.string :contents
    t.timestamps null: true
  end

  create_table :custom_things, force: true do |t|
    t.integer :post_id
    t.string :value
    t.timestamps null: true
  end

  create_table :comments, force: true do |t|
    t.integer :post_id
    t.string :contents
    t.string :nerf
    t.timestamps null: true
  end

  create_table :ratings, force: true do |t|
    t.integer :comment_id
    t.string :num_stars
    t.timestamps null: true
  end

  create_table :tags, force: true do |t|
    t.string :value
    t.timestamps null: true
  end

  create_table :users, force: true do |t|
    t.integer :post_id
    t.string :name
    t.string :email
    t.timestamps null: true
  end

  create_table :authors, force: true do |t|
    t.string :full_name
    t.string :nickname
    t.timestamps null: true
  end

  create_table :posts_tags, force: true do |t|
    t.integer :post_id
    t.integer :tag_id
  end

  create_table :notes, force: true do |t|
    t.string :value
    t.timestamps null: true
  end

  create_table :notes_posts, force: true do |t|
    t.integer :post_id
    t.integer :note_id
  end

  create_table :widgets, force: true do |t|
    t.string :value
  end

  create_table :post_widgets, force: true do |t|
    t.integer :post_id
    t.integer :widget_id
  end

  create_table :categories, force: true do |t|
    t.string :title
    t.string :description
  end

  create_table :supercats, force: true do |t|
    t.integer :post_id
    t.integer :category_id
    t.string :ramblings
    t.string :other_ramblings
    t.timestamps null: true
  end

  create_table :superkittens, force: true do |t|
    t.integer :supercat_id
    t.string :value
    t.timestamps null: true
  end

  create_table :accounts, force: true do |t|
    t.integer :post_id
    t.string :title
    t.timestamps null: true
  end

  create_table :histories, force: true do |t|
    t.integer :account_id
    t.string :some_stuff
    t.timestamps null: true
  end

  create_table :metal_objects, force: true do |t|
    t.string :type
    t.integer :parent_id
    t.timestamps null: true
  end

  create_table :super_admins, force: true do |t|
    t.string :email
    t.string :password
    t.boolean :active, null: false, default: true
    t.timestamps null: true
  end

  create_table :boxes, force: true do |t|
    t.string   :title
    t.timestamps null: true
  end

  create_table :box_products, force: true do |t|
    t.string   :type
    t.integer  :box_id
    t.integer  :box_sub_product_id
    t.string   :title
    t.timestamps null: true
  end

end