   "item_type",          limit: 255
    t.integer  "date_range",         limit: 4,   default: 0
    t.string   "date_range_value",   limit: 255
    t.string   "query_value",        limit: 255
    t.integer  "color_red",          limit: 4
    t.integer  "color_green",        limit: 4
    t.integer  "color_blue",         limit: 4
    t.boolean  "palette",                        default: false
    t.integer  "views_count",        limit: 4,   default: 0
    t.integer  "unique_views_count", limit: 4,   default: 0
    t.datetime "created_at",                                     null: false
    t.datetime "updated_at",                                     null: false
  end

  add_index "color_reports", ["item_id", "item_type", "date_range"], name: "index_color_reports_on_item_id_and_item_type_and_date_range", using: :btree
  add_index "color_reports", ["uuid"], name: "index_color_reports_on_uuid", unique: true, using: :btree

  create_table "settings", force: :cascade do |t|
    t.string   "var",        limit: 255,   null: false
    t.text     "value",      limit: 65535
    t.integer  "thing_id",   limit: 4
    t.string   "thing_type", limit: 30
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  add_index "settings", ["thing_type", "thing_id", "var"], name: "index_settings_on_thing_type_and_thing_id_and_var", unique: true, using: :btree

  create_table "user_authentications", force: :cascade do |t|
    t.integer  "user_id",             limit: 4
    t.string   "uuid",                limit: 255
    t.string   "uid",                 limit: 255
    t.string   "provider",            limit: 255
    t.string   "name",                limit: 255
    t.string   "email",               limit: 255
    t.string   "username",            limit: 255
    t.string   "token",               limit: 255
    t.string   "secret",              limit: 255
    t.string   "refresh_token",       limit: 255
    t.datetime "token_expires_at"
    t.string   "avatar_file_name",    limit: 255
    t.string   "avatar_content_type", limit: 255
    t.integer  "avatar_file_size",    limit: 4,   default: 0
    t.datetime "avatar_updated_at"
    t.string   "profile_url",         limit: 255
    t.string   "profile_image_url",   limit: 255
    t.date     "birthday"
    t.string   "locale",              limit: 255
    t.string   "gender",              limit: 255
    t.integer  "status",              limit: 4,   default: 0
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  add_index "user_authentications", ["uid", "provider"], name: "index_user_authentications_on_uid_and_provider", using: :btree
  add_index "user_authentications", ["uuid"], name: "index_user_authentications_on_uuid", unique: true, using: :btree

  create_table "users", force: :cascade do |t|
    t.string   "uuid",                limit: 255,                 null: false
    t.string   "slug",                limit: 255
    t.string   "name",                limit: 255,                 null: false
    t.string   "email",               limit: 255
    t.string   "login",               limit: 255,                 null: false
    t.string   "avatar_file_name",    limit: 255
    t.string   "avatar_content_type", limit: 255
    t.integer  "avatar_file_size",    limit: 4,   default: 0
    t.datetime "avatar_updated_at"
    t.string   "crypted_password",    limit: 255
    t.string   "password_salt",       limit: 255
    t.string   "persistence_token",   limit: 255,                 null: false
    t.string   "perishable_token",    limit: 255,                 null: false
    t.string   "single_access_token", limit: 255,                 null: false
    t.integer  "login_count",         limit: 4,   default: 0,     null: false
    t.integer  "failed_login_count",  limit: 4,   default: 0,     null: false
    t.datetime "last_request_at"
    t.datetime "current_login_at"
    t.datetime "last_login_at"
    t.string   "current_login_ip",    limit: 255
    t.string   "last_login_ip",       limit: 255
    t.string   "signup_method",       limit: 255
    t.integer  "roles_mask",          limit: 4
    t.boolean  "profile_private",                 default: false
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  add_index "users", ["email"], name: "index_users_on_email", unique: true, using: :btree
  add_index "users", ["last_request_at"], name: "index_users_on_last_request_at", using: :btree
  add_index "users", ["login"], name: "index_users_on_login", unique: true, using: :btree
  add_index "users", ["perishable_token"], name: "index_users_on_perishable_token", using: :btree
  add_index "users", ["persistence_token"], name: "index_users_on_persistence_token", using: :btree
  add_index "users", ["single_access_token"], name: "index_users_on_single_access_token", using: :btree
  add_index "users", ["slug"], name: "index_users_on_slug", unique: true, using: :btree
  add_index "users", ["uuid"], name: "index_users_on_uuid", unique: true, using: :btree

  create_table "web_site_page_colors", force: :cascade do |t|
    t.integer  "web_site_page_id", limit: 4
    t.string   "uuid",             limit: 255
    t.integer  "user_id",          limit: 4
    t.integer  "api_token_id",     limit: 4
    t.boolean  "active",                       default: true
    t.integer  "color_red",        limit: 4
    t.integer  "palette_red",      limit: 4
    t.integer  "palette_green",    limit: 4
    t.integer  "palette_blue",     limit: 4
    t.string   "palette_hex",      limit: 255
    t.integer  "color_green",      limit: 4
    t.integer  "color_blue",       limit: 4
    t.string   "color_hex",        limit: 255
    t.datetime "created_at"
  end

  add_index "web_site_page_colors", ["api_token_id"], name: "index_web_site_page_colors_on_api_token_id", using: :btree
  add_index "web_site_page_colors", ["user_id"], name: "index_web_site_page_colors_on_user_id", using: :btree
  add_index "web_site_page_colors", ["uuid"], name: "index_web_site_page_colors_on_uuid", unique: true, using: :btree

  create_table "web_site_pages", force: :cascade do |t|
    t.integer  "web_site_id",      limit: 4
    t.string   "uuid",             limit: 255
    t.string   "slug",             limit: 255
    t.text     "url",              limit: 65535
    t.text     "uri_path",         limit: 65535