# 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: 20220103094709) do

  create_table "authorizations", force: :cascade do |t|
    t.integer  "permission_label_id",     limit: 4
    t.integer  "title_provider_group_id", limit: 4
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  add_index "authorizations", ["permission_label_id", "title_provider_group_id"], name: "index_unique_provider_group_authorization", unique: true, using: :btree

  create_table "authorized_countries", force: :cascade do |t|
    t.integer  "provider_id", limit: 4
    t.integer  "country_id",  limit: 4
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  create_table "billing_informations", force: :cascade do |t|
    t.integer  "user_id",            limit: 4,   null: false
    t.string   "billing_company",    limit: 255
    t.string   "billing_address",    limit: 255
    t.string   "billing_zip_code",   limit: 255
    t.string   "billing_city",       limit: 255
    t.integer  "billing_country_id", limit: 4
    t.string   "billing_email",      limit: 255
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  create_table "communication_in_jobs", force: :cascade do |t|
    t.string   "job_source",        limit: 255
    t.integer  "job_source_job_id", limit: 4
    t.string   "type",              limit: 255
    t.text     "params",            limit: 65535
    t.integer  "done",              limit: 4
    t.string   "result",            limit: 255
    t.datetime "created_at",                      null: false
    t.datetime "updated_at",                      null: false
  end

  create_table "communication_out_jobs", force: :cascade do |t|
    t.string   "type",       limit: 255
    t.text     "params",     limit: 65535
    t.integer  "done",       limit: 4
    t.string   "result",     limit: 255
    t.datetime "created_at",               null: false
    t.datetime "updated_at",               null: false
  end

  create_table "countries", force: :cascade do |t|
    t.string   "name",       limit: 255
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  create_table "delayed_jobs", force: :cascade do |t|
    t.integer  "priority",   limit: 4,     default: 0
    t.integer  "attempts",   limit: 4,     default: 0
    t.text     "handler",    limit: 65535
    t.text     "last_error", limit: 65535
    t.datetime "run_at"
    t.datetime "locked_at"
    t.datetime "failed_at"
    t.string   "locked_by",  limit: 255
    t.datetime "created_at"
    t.datetime "updated_at"
    t.string   "queue",      limit: 255
  end

  create_table "images", force: :cascade do |t|
    t.string   "title",                  limit: 255
    t.string   "subject_code",           limit: 708
    t.text     "subject",                limit: 65535
    t.string   "instructions",           limit: 768
    t.string   "creator",                limit: 96
    t.string   "city",                   limit: 96
    t.string   "location",               limit: 96
    t.string   "state",                  limit: 96
    t.string   "country",                limit: 192
    t.string   "headline",               limit: 768
    t.string   "credit",                 limit: 96
    t.string   "source",                 limit: 96
    t.text     "description",            limit: 65535
    t.string   "reportage",              limit: 255
    t.string   "normalized_credit",      limit: 192
    t.integer  "max_avail_width",        limit: 4
    t.integer  "max_avail_height",       limit: 4
    t.string   "original_filename",      limit: 255
    t.text     "provider_comment",       limit: 65535
    t.datetime "date_created"
    t.datetime "reception_date"
    t.string   "thumb_location",         limit: 255
    t.string   "medium_location",        limit: 255
    t.string   "hires_location",         limit: 1000
    t.string   "restrictions",           limit: 512,   default: "ANY"
    t.integer  "provider_id",            limit: 4
    t.datetime "created_at"
    t.datetime "updated_at"
    t.string   "rights",                 limit: 384
    t.string   "category",               limit: 20
    t.string   "supplemental_category",  limit: 96
    t.integer  "urgency",                limit: 3
    t.string   "authors_position",       limit: 96
    t.string   "transmission_reference", limit: 96
    t.string   "caption_writer",         limit: 96
    t.boolean  "delta",                                default: true,  null: false
    t.float    "ratio",                  limit: 24
    t.boolean  "erasable",                             default: false
    t.string   "ms_picture_id",          limit: 255
    t.string   "ms_id",                  limit: 255
    t.boolean  "private_image",                        default: false
    t.string   "file_name",              limit: 255
    t.boolean  "content_error",                        default: false, null: false
    t.integer  "ms_image_id",            limit: 8
    t.integer  "fonds",                  limit: 4,     default: 0
    t.string   "page_ref",               limit: 100
    t.integer  "hr_size",                limit: 4,     default: 0
    t.integer  "black_and_white",        limit: 1,     default: 0
    t.integer  "flow",                   limit: 1,     default: 0
    t.string   "id20min",                limit: 255
    t.integer  "pp_category_id",         limit: 1,     default: 0
    t.boolean  "marked",                               default: false
    t.boolean  "usco_done",                            default: false
  end

  add_index "images", ["black_and_white"], name: "black_and_white", using: :btree
  add_index "images", ["content_error"], name: "index_images_on_content_error", using: :btree
  add_index "images", ["created_at"], name: "index_images_on_created_at", using: :btree
  add_index "images", ["date_created"], name: "index_images_on_date_created", using: :btree
  add_index "images", ["delta"], name: "index_images_on_delta", using: :btree
  add_index "images", ["file_name"], name: "index_images_on_file_name", using: :btree
  add_index "images", ["fonds"], name: "index_images_on_fonds", using: :btree
  add_index "images", ["marked"], name: "index_images_on_marked", using: :btree
  add_index "images", ["ms_image_id"], name: "index_images_on_ms_image_id", unique: true, using: :btree
  add_index "images", ["original_filename", "provider_id"], name: "index_images_on_original_filename_and_provider_id", unique: true, using: :btree
  add_index "images", ["pp_category_id"], name: "index_images_on_pp_category", using: :btree
  add_index "images", ["private_image"], name: "index_images_on_private_image", using: :btree
  add_index "images", ["provider_id"], name: "index_images_on_provider_id", using: :btree
  add_index "images", ["ratio"], name: "index_images_on_ratio", using: :btree
  add_index "images", ["reception_date"], name: "index_images_on_reception_date", using: :btree
  add_index "images", ["reportage"], name: "index_images_on_reportage", using: :btree
  add_index "images", ["updated_at"], name: "index_images_on_updated_at", using: :btree
  add_index "images", ["usco_done"], name: "index_images_on_usco_done", using: :btree

  create_table "iptc_countries", force: :cascade do |t|
    t.string "code", limit: 255
    t.string "en",   limit: 255
    t.string "fr",   limit: 255
  end

  create_table "light_box_images", force: :cascade do |t|
    t.string   "annotation",   limit: 255
    t.integer  "light_box_id", limit: 4
    t.integer  "image_id",     limit: 4
    t.integer  "position",     limit: 4
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  add_index "light_box_images", ["image_id"], name: "index_light_box_images_on_image_id", using: :btree
  add_index "light_box_images", ["light_box_id"], name: "index_light_box_images_on_light_box_id", using: :btree

  create_table "light_boxes", force: :cascade do |t|
    t.boolean  "order_by_agency",             default: false
    t.string   "name",            limit: 255
    t.integer  "user_id",         limit: 4
    t.integer  "title_id",        limit: 4
    t.string   "hash_code",       limit: 255
    t.integer  "items_count",     limit: 4,   default: 0
    t.datetime "created_at"
    t.datetime "updated_at"
    t.integer  "permission",      limit: 1,   default: 0
  end

  add_index "light_boxes", ["name"], name: "index_light_boxes_on_name", using: :btree
  add_index "light_boxes", ["user_id"], name: "index_light_boxes_on_user_id", using: :btree

  create_table "metadata_conversions", force: :cascade do |t|
    t.string "image",    limit: 255
    t.string "iptc",     limit: 255
    t.string "eightbim", limit: 255
    t.string "xmp",      limit: 255
  end

  create_table "net_messages", force: :cascade do |t|
    t.text     "message",     limit: 65535,                 null: false
    t.text     "answer",      limit: 65535
    t.datetime "answered_at"
    t.boolean  "skipable",                  default: false, null: false
    t.integer  "server_id",   limit: 4
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  create_table "operation_labels", force: :cascade do |t|
    t.string   "label",      limit: 255
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  create_table "paniers", force: :cascade do |t|
    t.integer "reportage_id", limit: 4, null: false
    t.integer "user_id",      limit: 4, null: false
  end

  add_index "paniers", ["reportage_id"], name: "index_paniers_on_reportage_id", using: :btree
  add_index "paniers", ["user_id"], name: "index_paniers_on_user_id", using: :btree

  create_table "paper_matching_image_tokens", force: :cascade do |t|
    t.string   "ms_picture_id",        limit: 255
    t.integer  "ms_image_id",          limit: 4
    t.string   "file_name",            limit: 255
    t.string   "access_token",         limit: 255
    t.integer  "matching_image_count", limit: 4,   default: 0, null: false
    t.integer  "image_id",             limit: 4,               null: false
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  create_table "permission_labels", force: :cascade do |t|
    t.string   "label",      limit: 255
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  create_table "photos", force: :cascade do |t|
    t.string   "photo",       limit: 255
    t.integer  "user_id",     limit: 4
    t.string   "description", limit: 255
    t.string   "credit",      limit: 255
    t.string   "city",        limit: 255
    t.date     "date_photo"
    t.string   "reportage",   limit: 255
    t.string   "keywords",    limit: 255
    t.datetime "created_at"
    t.datetime "updated_at"
    t.string   "up_country",  limit: 255, default: ""
    t.string   "source",      limit: 255, default: ""
  end

  add_index "photos", ["user_id"], name: "index_photos_on_user_id", using: :btree

  create_table "pixlogs", force: :cascade do |t|
    t.string "username", limit: 40
    t.string "company",  limit: 20
  end

  add_index "pixlogs", ["username"], name: "index_pixlogs_on_username", unique: true, using: :btree

  create_table "pixtech_params", force: :cascade do |t|
    t.string   "name",       limit: 255
    t.text     "value",      limit: 65535
    t.integer  "pixtech_id", limit: 4
    t.datetime "created_at",               null: false
    t.datetime "updated_at",               null: false
  end

  add_index "pixtech_params", ["pixtech_id"], name: "index_pixtech_params_on_pixtech_id", using: :btree

  create_table "pixteches", force: :cascade do |t|
    t.string   "name",       limit: 255
    t.datetime "created_at",             null: false
    t.datetime "updated_at",             null: false
  end

  add_index "pixteches", ["name"], name: "index_pixteches_on_name", unique: true, using: :btree

  create_table "pp_categories", force: :cascade do |t|
    t.string   "label",      limit: 20
    t.datetime "created_at",            null: false
    t.datetime "updated_at",            null: false
  end

  create_table "provider_contacts", force: :cascade do |t|
    t.boolean  "main"
    t.string   "first_name",       limit: 255
    t.string   "last_name",        limit: 255
    t.string   "email",            limit: 100
    t.string   "fax",              limit: 255
    t.string   "phone",            limit: 255
    t.boolean  "receive_requests"
    t.integer  "provider_id",      limit: 4
    t.datetime "created_at"
    t.datetime "updated_at"
    t.string   "portable",         limit: 255
    t.boolean  "receive_stat"
    t.boolean  "receive_errors",               default: false
    t.boolean  "receive_demand",               default: false
    t.integer  "receive_alert",    limit: 1,   default: 0
  end

  create_table "provider_for_search_stats", force: :cascade do |t|
    t.integer "search_stat_id", limit: 4,     default: 0
    t.text    "provs",          limit: 65535
    t.integer "provider_id",    limit: 4,     default: 0
    t.integer "result",         limit: 4,     default: 0
  end

  add_index "provider_for_search_stats", ["search_stat_id"], name: "index_provider_for_search_stats_on_search_stat_id", using: :btree

  create_table "provider_response_to_requests", force: :cascade do |t|
    t.integer  "request_to_provider_id", limit: 4
    t.integer  "image_id",               limit: 4
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  add_index "provider_response_to_requests", ["request_to_provider_id"], name: "index_provider_response_to_requests_on_request_to_provider_id", using: :btree

  create_table "provider_types", force: :cascade do |t|
    t.string "name", limit: 255
  end

  create_table "providers", force: :cascade do |t|
    t.string   "string_key",            limit: 255
    t.string   "name",                  limit: 255
    t.string   "logo",                  limit: 255
    t.string   "description",           limit: 750
    t.string   "site",                  limit: 255
    t.string   "address",               limit: 255
    t.boolean  "local",                             default: false
    t.string   "copyright_rule",        limit: 255
    t.datetime "created_at"
    t.datetime "updated_at"
    t.integer  "days_keep",             limit: 4
    t.boolean  "days_keep_per_picture",             default: false
    t.boolean  "form_per_session",                  default: false
    t.string   "provider_conditions",   limit: 255
    t.string   "input_dir",             limit: 255
    t.string   "city",                  limit: 255
    t.string   "country",               limit: 255
    t.string   "zip_code",              limit: 255
    t.string   "text_prices_url",       limit: 255
    t.boolean  "actif",                             default: true
    t.integer  "toomany_limit",         limit: 4,   default: 0
    t.string   "pdf",                   limit: 255
    t.string   "formu",                 limit: 255
    t.string   "name_order",            limit: 255
    t.string   "cgv",                   limit: 255, default: ""
    t.boolean  "in_pixtrakk",                       default: true
    t.string   "pp_name",               limit: 255
    t.boolean  "exhaustivity",                      default: false
    t.string   "pp_string_key",         limit: 255
    t.integer  "provider_type_id",      limit: 4,   default: 1
    t.integer  "pixtech_id",            limit: 4
    t.integer  "days_keep_alert",       limit: 4
    t.integer  "toomany_limit_alert",   limit: 4,   default: 0
    t.boolean  "copyright_symbol",                  default: true
  end

  add_index "providers", ["pixtech_id"], name: "index_providers_on_pixtech_id", using: :btree

  create_table "providersBUG", force: :cascade do |t|
    t.string   "name",                  limit: 255
    t.string   "logo",                  limit: 255
    t.string   "description",           limit: 750
    t.string   "site",                  limit: 255
    t.string   "address",               limit: 255
    t.boolean  "local",                             default: false
    t.string   "copyright_rule",        limit: 255
    t.string   "string_key",            limit: 255
    t.datetime "created_at"
    t.datetime "updated_at"
    t.integer  "days_keep",             limit: 4
    t.boolean  "days_keep_per_picture",             default: false
    t.boolean  "form_per_session",                  default: false
    t.string   "provider_conditions",   limit: 255
    t.string   "input_dir",             limit: 255
    t.string   "city",                  limit: 255
    t.string   "country",               limit: 255
    t.string   "zip_code",              limit: 255
    t.string   "text_prices_url",       limit: 255
    t.boolean  "actif",                             default: true
    t.integer  "toomany_limit",         limit: 4,   default: 0
    t.string   "pdf",                   limit: 255
    t.string   "formu",                 limit: 255
    t.string   "name_order",            limit: 255
    t.string   "cgv",                   limit: 255, default: ""
    t.boolean  "in_pixtrakk",                       default: true
    t.string   "pp_name",               limit: 255
    t.boolean  "exhaustivity",                      default: false
    t.integer  "provider_type_id",      limit: 4,   default: 1
  end

  create_table "providersPA", force: :cascade do |t|
    t.string   "name",                  limit: 255
    t.string   "logo",                  limit: 255
    t.string   "description",           limit: 750
    t.string   "site",                  limit: 255
    t.string   "address",               limit: 255
    t.boolean  "local",                             default: false
    t.string   "copyright_rule",        limit: 255
    t.string   "string_key",            limit: 255
    t.datetime "created_at"
    t.datetime "updated_at"
    t.integer  "days_keep",             limit: 4
    t.boolean  "days_keep_per_picture",             default: false
    t.boolean  "form_per_session",                  default: false
    t.string   "provider_conditions",   limit: 255
    t.string   "input_dir",             limit: 255
    t.string   "city",                  limit: 255
    t.string   "country",               limit: 255
    t.string   "zip_code",              limit: 255
    t.string   "text_prices_url",       limit: 255
    t.boolean  "actif",                             default: true
    t.integer  "toomany_limit",         limit: 4,   default: 0
    t.boolean  "in_pixtrakk",                       default: true
    t.string   "pp_name",               limit: 255
    t.string   "pdf",                   limit: 255
    t.string   "formu",                 limit: 255
    t.string   "name_order",            limit: 255
    t.string   "cgv",                   limit: 255, default: ""
  end

  add_index "providersPA", ["pp_name"], name: "index_providers_on_pp_name", using: :btree

  create_table "refresh_providers", force: :cascade do |t|
    t.integer  "provider_id",  limit: 4
    t.integer  "total_update", limit: 4, default: 0
    t.integer  "nb_updated",   limit: 4, default: 0
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  add_index "refresh_providers", ["provider_id"], name: "index_refresh_providers_on_provider_id", using: :btree

  create_table "reportage_photos", force: :cascade do |t|
    t.integer "reportage_id", limit: 4
    t.integer "photo_ms_id",  limit: 8
    t.integer "rang",         limit: 4, default: 0
  end

  add_index "reportage_photos", ["photo_ms_id"], name: "index_reportage_photos_on_photo_ms_id", using: :btree
  add_index "reportage_photos", ["reportage_id"], name: "index_reportage_photos_on_reportage_id", using: :btree

  create_table "reportages", force: :cascade do |t|
    t.string   "no_reportage", limit: 255
    t.string   "string_key",   limit: 70
    t.integer  "nb_photos",    limit: 4,        default: 0
    t.integer  "prem_photo",   limit: 8,                       null: false
    t.string   "rep_titre",    limit: 192
    t.text     "rep_texte",    limit: 16777215
    t.date     "rep_date"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.string   "signatur",     limit: 192
    t.boolean  "offre"
    t.boolean  "visible",                       default: true
  end

  add_index "reportages", ["nb_photos"], name: "index_reportages_on_nb_photos", using: :btree
  add_index "reportages", ["no_reportage"], name: "index_reportages_on_no_reportage", using: :btree
  add_index "reportages", ["offre"], name: "index_reportages_on_offre", using: :btree
  add_index "reportages", ["rep_date"], name: "index_reportages_on_rep_date", using: :btree
  add_index "reportages", ["rep_titre"], name: "index_reportages_on_rep_titre", using: :btree
  add_index "reportages", ["signatur"], name: "index_reportages_on_signatur", using: :btree
  add_index "reportages", ["string_key"], name: "index_reportages_on_string_key", using: :btree
  add_index "reportages", ["visible"], name: "index_reportages_on_visible", using: :btree

  create_table "reqphotos", force: :cascade do |t|
    t.string   "reqphoto_file_name",     limit: 255
    t.string   "reqphoto_content_type",  limit: 255
    t.integer  "reqphoto_file_size",     limit: 4
    t.datetime "reqphoto_updated_at"
    t.integer  "request_to_provider_id", limit: 4
    t.datetime "created_at",                         null: false
    t.datetime "updated_at",                         null: false
  end

  add_index "reqphotos", ["request_to_provider_id"], name: "index_reqphotos_on_request_to_provider_id", using: :btree

  create_table "request_to_providers", force: :cascade do |t|
    t.string   "text",            limit: 255
    t.date     "view_date"
    t.string   "status",          limit: 255
    t.string   "subject",         limit: 255
    t.integer  "responses_count", limit: 4,   default: 0
    t.integer  "user_id",         limit: 4
    t.datetime "created_at"
    t.datetime "updated_at"
    t.string   "serial",          limit: 255
  end

  add_index "request_to_providers", ["user_id"], name: "index_request_to_providers_on_user_id", using: :btree

  create_table "roles", force: :cascade do |t|
    t.string   "name",        limit: 255
    t.text     "permissions", limit: 65535
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  create_table "saved_searches", force: :cascade do |t|
    t.integer  "user_id",          limit: 4
    t.string   "name",             limit: 255
    t.datetime "date"
    t.datetime "date_last_search"
    t.integer  "photos_count",     limit: 4
    t.text     "criteria",         limit: 65535
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  create_table "search_image_fields", force: :cascade do |t|
    t.integer "search_stat_id", limit: 4,     default: 0
    t.text    "iptc",           limit: 65535
    t.string  "field_name",     limit: 50,    default: ""
    t.string  "field_content",  limit: 100,   default: ""
  end

  add_index "search_image_fields", ["search_stat_id"], name: "index_search_image_fields_on_search_stat_id", using: :btree

  create_table "search_provider_group_names", force: :cascade do |t|
    t.string   "name",       limit: 255, null: false
    t.integer  "user_id",    limit: 4
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  add_index "search_provider_group_names", ["name", "user_id"], name: "index_search_provider_group_names_on_name_and_user_id", unique: true, using: :btree

  create_table "search_provider_groups", force: :cascade do |t|
    t.integer  "provider_id",                   limit: 4
    t.integer  "search_provider_group_name_id", limit: 4
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  create_table "search_stats", force: :cascade do |t|
    t.string   "keyword",         limit: 255
    t.string   "since",           limit: 50
    t.string   "tri",             limit: 50
    t.date     "date_pp_from"
    t.date     "date_pp_to"
    t.date     "date_photo_from"
    t.date     "date_photo_to"
    t.integer  "format",          limit: 4
    t.integer  "result",          limit: 4,   default: 0
    t.integer  "user_id",         limit: 4
    t.datetime "created_at"
    t.string   "serv_name",       limit: 255
    t.integer  "cs_stat_id",      limit: 4
    t.date     "cs_created"
    t.string   "translation",     limit: 255
    t.string   "pp_categories",   limit: 255
  end

  add_index "search_stats", ["result"], name: "index_search_stats_on_result", using: :btree
  add_index "search_stats", ["user_id"], name: "index_search_stats_on_user_id", using: :btree

  create_table "selected_providers_for_requests", force: :cascade do |t|
    t.integer  "request_to_provider_id", limit: 4
    t.integer  "provider_id",            limit: 4
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  create_table "servers", force: :cascade do |t|
    t.string   "status",         limit: 255
    t.string   "host",           limit: 255
    t.string   "name",           limit: 255
    t.datetime "created_at"
    t.datetime "updated_at"
    t.string   "which_type",     limit: 255
    t.boolean  "is_self",                    default: false,        null: false
    t.string   "api_key",        limit: 255
    t.string   "api_port",       limit: 255, default: "5671",       null: false
    t.string   "srv_type",       limit: 255, default: "production"
    t.string   "public_url",     limit: 255
    t.string   "internal_url",   limit: 255
    t.string   "backoffice_url", limit: 255
  end

  create_table "sessions", force: :cascade do |t|
    t.string   "session_id", limit: 255,   null: false
    t.text     "data",       limit: 65535
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  add_index "sessions", ["session_id"], name: "index_sessions_on_session_id", unique: true, using: :btree
  add_index "sessions", ["updated_at"], name: "index_sessions_on_updated_at", using: :btree

  create_table "settings", force: :cascade do |t|
    t.string   "language",              limit: 255
    t.text     "preferential_corpus",   limit: 65535
    t.text     "display_params",        limit: 65535
    t.text     "border_color_provider", limit: 65535
    t.integer  "user_id",               limit: 4
    t.datetime "created_at"
    t.datetime "updated_at"
    t.string   "time_zone",             limit: 255
    t.integer  "default_per_page",      limit: 4,     default: 0,                   null: false
    t.string   "default_since",         limit: 255,   default: "all",               null: false
    t.string   "default_sort",          limit: 255,   default: "reception_date",    null: false
    t.string   "default_media",         limit: 255,   default: "all"
    t.integer  "reload_pref",           limit: 4,     default: 0
    t.boolean  "pagination",                          default: true
    t.string   "under_my_thumb",        limit: 255,   default: "normalized_credit"
    t.integer  "translation",           limit: 1,     default: 1
  end

  add_index "settings", ["user_id"], name: "index_settings_on_user_id", using: :btree

  create_table "shortened_urls", force: :cascade do |t|
    t.integer  "owner_id",   limit: 4
    t.string   "owner_type", limit: 20
    t.text     "url",        limit: 65535,             null: false
    t.string   "unique_key", limit: 10,                null: false
    t.string   "category",   limit: 255
    t.integer  "use_count",  limit: 4,     default: 0, null: false
    t.datetime "expires_at"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  add_index "shortened_urls", ["category"], name: "index_shortened_urls_on_category", using: :btree
  add_index "shortened_urls", ["owner_id", "owner_type"], name: "index_shortened_urls_on_owner_id_and_owner_type", using: :btree
  add_index "shortened_urls", ["unique_key"], name: "index_shortened_urls_on_unique_key", unique: true, using: :btree
  add_index "shortened_urls", ["url"], name: "index_shortened_urls_on_url", length: {"url"=>2083}, using: :btree

  create_table "statistics", force: :cascade do |t|
    t.integer  "user_id",            limit: 4
    t.integer  "image_id",           limit: 4
    t.datetime "created_at"
    t.datetime "updated_at"
    t.boolean  "delta",                          default: true
    t.integer  "operation_label_id", limit: 4
    t.string   "id20min",            limit: 255
  end

  add_index "statistics", ["image_id"], name: "index_statistics_on_image_id", using: :btree
  add_index "statistics", ["user_id"], name: "index_statistics_on_user_id", using: :btree

  create_table "table_pk_images", force: :cascade do |t|
    t.datetime "Date_transfer_crawling"
    t.string   "medium_location",        limit: 255
    t.string   "image_filename",         limit: 255
    t.string   "source_name",            limit: 255
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  create_table "title_provider_group_names", force: :cascade do |t|
    t.string   "name",       limit: 255
    t.integer  "country_id", limit: 4
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  add_index "title_provider_group_names", ["name", "country_id"], name: "index_title_provider_group_names_on_name_and_country_id", unique: true, using: :btree

  create_table "title_provider_groups", force: :cascade do |t|
    t.integer  "title_provider_group_name_id", limit: 4
    t.integer  "provider_id",                  limit: 4
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  create_table "titles", force: :cascade do |t|
    t.string   "name",                         limit: 255
    t.boolean  "hide_unauthorized_providers",              default: true
    t.integer  "dpi",                          limit: 4,   default: 75
    t.string   "flow_path",                    limit: 255
    t.integer  "title_provider_group_name_id", limit: 4
    t.integer  "server_id",                    limit: 4
    t.integer  "country_id",                   limit: 4
    t.datetime "created_at"
    t.datetime "updated_at"
    t.string   "first_name",                   limit: 100, default: ""
    t.string   "last_name",                    limit: 100, default: ""
    t.string   "address",                      limit: 150, default: ""
    t.string   "zip_code",                     limit: 10,  default: ""
    t.string   "city",                         limit: 150, default: ""
    t.string   "phone",                        limit: 20,  default: ""
    t.string   "email",                        limit: 100, default: ""
    t.string   "comment",                      limit: 500, default: ""
    t.integer  "visible",                      limit: 4,   default: 0
    t.string   "group",                        limit: 100, default: ""
    t.string   "title_type",                   limit: 100, default: ""
    t.string   "visible_name",                 limit: 100, default: ""
    t.string   "ojd_link",                     limit: 150, default: ""
    t.string   "status",                       limit: 255, default: "active", null: false
  end

  create_table "updated_list_providers", force: :cascade do |t|
    t.integer  "refresh_provider_id", limit: 4
    t.integer  "nb_photos",           limit: 4,   default: 0
    t.datetime "action_date"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.string   "visionneuse",         limit: 255, default: ""
  end

  add_index "updated_list_providers", ["refresh_provider_id"], name: "index_updated_list_providers_on_refresh_provider_id", using: :btree

  create_table "users", force: :cascade do |t|
    t.string   "login",                     limit: 100
    t.string   "first_name",                limit: 100,   default: ""
    t.string   "last_name",                 limit: 100,   default: ""
    t.string   "email",                     limit: 100
    t.string   "crypted_password",          limit: 128,   default: "",       null: false
    t.string   "salt",                      limit: 128,   default: "",       null: false
    t.datetime "remember_token_expires_at"
    t.datetime "activated_at"
    t.string   "phone",                     limit: 255,   default: "0"
    t.integer  "fax",                       limit: 4,     default: 0
    t.integer  "numero_tva",                limit: 4,     default: 0
    t.string   "company",                   limit: 40
    t.string   "job",                       limit: 40
    t.string   "activity_sector",           limit: 60
    t.string   "service",                   limit: 40
    t.string   "billing_address",           limit: 255
    t.string   "billing_company",           limit: 255
    t.string   "city",                      limit: 255
    t.string   "password_reset_code",       limit: 255
    t.integer  "zip_code",                  limit: 4
    t.text     "permissions",               limit: 65535
    t.integer  "title_id",                  limit: 4
    t.integer  "role_id",                   limit: 4
    t.integer  "country_id",                limit: 4
    t.datetime "created_at"
    t.datetime "updated_at"
    t.string   "login_key",                 limit: 255
    t.string   "persistence_token",         limit: 255,                      null: false
    t.string   "perishable_token",          limit: 255,                      null: false
    t.integer  "login_count",               limit: 4
    t.integer  "failed_login_count",        limit: 4
    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.date     "deactivation_at"
    t.date     "password_updated_at"
    t.integer  "roles_mask",                limit: 4,     default: 4
    t.string   "authentication_token",      limit: 255
    t.string   "address",                   limit: 255
    t.string   "status",                    limit: 255,   default: "active", null: false
    t.integer  "max_daily_downloads",       limit: 4,     default: 0,        null: false
    t.string   "civility",                  limit: 255
    t.string   "job_title",                 limit: 255
  end

  add_index "users", ["email", "title_id"], name: "index_users_on_email_and_title_id", unique: true, using: :btree
  add_index "users", ["login"], name: "index_users_on_login", unique: true, using: :btree
  add_index "users", ["login_key"], name: "index_users_on_login_key", unique: true, using: :btree

  add_foreign_key "pixtech_params", "pixteches"
end