# encoding: UTF-8
# This file is auto-generated from the current state of the database. Instead
# of editing this file, please use the migrations feature of Active Record to
# incrementally modify your database, and then regenerate this schema definition.
#
# Note that this schema.rb definition is the authoritative source for your
# database schema. If you need to create the application database on another
# system, you should be using db:schema:load, not running all the migrations
# from scratch. The latter is a flawed and unsustainable approach (the more migrations
# you'll amass, the slower it'll run and the greater likelihood for issues).
#
# It's strongly recommended that you check this file into your version control system.

ActiveRecord::Schema.define(version: 20160324062743) do

  create_table "friendly_id_slugs", force: :cascade do |t|
    t.string   "slug",                      null: false
    t.integer  "sluggable_id",              null: false
    t.string   "sluggable_type", limit: 50
    t.string   "scope"
    t.datetime "created_at"
  end

  add_index "friendly_id_slugs", ["slug", "sluggable_type", "scope"], name: "index_friendly_id_slugs_on_slug_and_sluggable_type_and_scope", unique: true
  add_index "friendly_id_slugs", ["slug", "sluggable_type"], name: "index_friendly_id_slugs_on_slug_and_sluggable_type"
  add_index "friendly_id_slugs", ["sluggable_id"], name: "index_friendly_id_slugs_on_sluggable_id"
  add_index "friendly_id_slugs", ["sluggable_type"], name: "index_friendly_id_slugs_on_sluggable_type"

  create_table "kawara_article_images", force: :cascade do |t|
    t.integer  "article_id",        null: false
    t.string   "file_id",           null: false
    t.string   "file_filename"
    t.integer  "file_size"
    t.string   "file_content_type"
    t.datetime "created_at",        null: false
    t.datetime "updated_at",        null: false
  end

  add_index "kawara_article_images", ["article_id"], name: "index_kawara_article_images_on_article_id"

  create_table "kawara_articles", force: :cascade do |t|
    t.integer  "category_id"
    t.string   "slug"
    t.string   "title"
    t.string   "subtitle"
    t.text     "content"
    t.integer  "status",      default: 0, null: false
    t.datetime "created_at",              null: false
    t.datetime "updated_at",              null: false
  end

  add_index "kawara_articles", ["category_id", "status"], name: "index_kawara_articles_on_category_id_and_status"
  add_index "kawara_articles", ["category_id"], name: "index_kawara_articles_on_category_id"
  add_index "kawara_articles", ["slug"], name: "index_kawara_articles_on_slug", unique: true
  add_index "kawara_articles", ["status", "id"], name: "index_kawara_articles_on_status_and_id"
  add_index "kawara_articles", ["status", "slug"], name: "index_kawara_articles_on_status_and_slug"

  create_table "kawara_articles_meta_tags", force: :cascade do |t|
    t.integer  "article_id",  null: false
    t.integer  "meta_tag_id", null: false
    t.datetime "created_at",  null: false
    t.datetime "updated_at",  null: false
  end

  add_index "kawara_articles_meta_tags", ["article_id", "meta_tag_id"], name: "index_kawara_articles_meta_tags_on_article_id_and_meta_tag_id"
  add_index "kawara_articles_meta_tags", ["meta_tag_id", "article_id"], name: "index_kawara_articles_meta_tags_on_meta_tag_id_and_article_id"

  create_table "kawara_articles_tags", force: :cascade do |t|
    t.integer  "article_id", null: false
    t.integer  "tag_id",     null: false
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
  end

  add_index "kawara_articles_tags", ["article_id", "tag_id"], name: "index_kawara_articles_tags_on_article_id_and_tag_id"
  add_index "kawara_articles_tags", ["tag_id", "article_id"], name: "index_kawara_articles_tags_on_tag_id_and_article_id"

  create_table "kawara_categories", force: :cascade do |t|
    t.string   "slug"
    t.string   "name",                       null: false
    t.integer  "parent_id"
    t.integer  "lft",                        null: false
    t.integer  "rgt",                        null: false
    t.integer  "depth",          default: 0, null: false
    t.integer  "children_count", default: 0, null: false
    t.datetime "created_at",                 null: false
    t.datetime "updated_at",                 null: false
  end

  add_index "kawara_categories", ["lft"], name: "index_kawara_categories_on_lft"
  add_index "kawara_categories", ["parent_id"], name: "index_kawara_categories_on_parent_id"
  add_index "kawara_categories", ["rgt"], name: "index_kawara_categories_on_rgt"
  add_index "kawara_categories", ["slug"], name: "index_kawara_categories_on_slug", unique: true

  create_table "kawara_meta_tags", force: :cascade do |t|
    t.string   "name",           null: false
    t.integer  "articles_count"
    t.datetime "created_at",     null: false
    t.datetime "updated_at",     null: false
  end

  add_index "kawara_meta_tags", ["name"], name: "index_kawara_meta_tags_on_name", unique: true

  create_table "kawara_tags", force: :cascade do |t|
    t.string   "slug"
    t.string   "name",           null: false
    t.integer  "articles_count"
    t.datetime "created_at",     null: false
    t.datetime "updated_at",     null: false
  end

  add_index "kawara_tags", ["name"], name: "index_kawara_tags_on_name", unique: true
  add_index "kawara_tags", ["slug"], name: "index_kawara_tags_on_slug", unique: true

end