<commit_before># This file is auto-generated from the current state of the database. Instead of editing this file, 
# please use the migrations feature of ActiveRecord 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 to check this file into your version control system.

ActiveRecord::Schema.define(:version => 52) do

  create_table "article_versions", :force => true do |t|
    t.integer  "article_id"
    t.integer  "version"
    t.string   "name"
    t.string   "slug"
    t.text     "path"
    t.integer  "parent_id"
    t.text     "body"
    t.text     "abstract"
    t.integer  "profile_id"
    t.datetime "updated_at"
    t.datetime "created_at"
    t.integer  "last_changed_by_id"
    t.integer  "size"
    t.string   "content_type"
    t.string   "filename"
    t.integer  "height"
    t.integer  "width"
    t.string   "versioned_type"
    t.integer  "comments_count"
    t.boolean  "advertise",          :default => true
    t.boolean  "published",          :default => true
    t.date     "start_date"
    t.date     "end_date"
    t.integer  "children_count",     :default => 0
    t.boolean  "public_article",     :default => true
    t.boolean  "accept_comments",    :default => true
  end

  create_table "articles", :force => true do |t|
    t.string   "name"
    t.string   "slug"
    t.text     "path"
    t.integer  "parent_id"
    t.text     "body"
    t.text     "abstract"
    t.integer  "profile_id"
    t.datetime "updated_at"
    t.datetime "created_at"
    t.integer  "last_changed_by_id"
    t.integer  "version"
    t.integer  "lock_version"
    t.string   "type"
    t.integer  "size"
    t.string   "content_type"
    t.string   "filename"
    t.integer  "height"
    t.integer  "width"
    t.integer  "comments_count",     :default => 0
    t.boolean  "advertise",          :default => true
    t.boolean  "published",          :default => true
    t.date     "start_date"
    t.date     "end_date"
    t.integer  "children_count",     :default => 0
    t.boolean  "public_article",     :default => true
    t.boolean  "accept_comments",    :default => true
  end

  create_table "articles_categories", :id => false, :force => true do |t|
    t.integer "article_id"
    t.integer "category_id"
    t.boolean "virtual",     :default => false
  end

  add_index "articles_categories", ["category_id"], :name => "index_articles_categories_on_category_id"
  add_index "articles_categories", ["article_id"], :name => "index_articles_categories_on_article_id"

  create_table "blocks", :force => true do |t|
    t.string  "title"
    t.integer "box_id"
    t.string  "type"
    t.text    "settings"
    t.integer "position"
  end

  add_index "blocks", ["box_id"], :name => "index_blocks_on_box_id"

  create_table "boxes", :force => true do |t|
    t.string  "owner_type"
    t.integer "owner_id"
    t.integer "position"
  end

  add_index "boxes", ["owner_type", "owner_id"], :name => "index_boxes_on_owner_type_and_owner_id"

  create_table "categories", :force => true do |t|
    t.string  "name"
    t.string  "slug"
    t.text    "path"
    t.integer "display_color"
    t.integer "environment_id"
    t.integer "parent_id"
    t.string  "type"
    t.float   "lat"
    t.float   "lng"
    t.boolean "display_in_menu", :default => false
    t.integer "children_count",  :default => 0
  end

  create_table "categories_profiles", :id => false, :force => true do |t|
    t.integer "profile_id"
    t.integer "category_id"
    t.boolean "virtual",     :default => false
  end

  add_index "categories_profiles", ["category_id"], :name => "index_categories_profiles_on_category_id"
  add_index "categories_profiles", ["profile_id"], :name => "index_categories_profiles_on_profile_id"

  create_table "comments", :force => true do |t|
    t.string   "title"
    t.text     "body"
    t.integer  "article_id"
    t.integer  "author_id"
    t.string   "name"
    t.string   "email"
    t.datetime "created_at"
  end

  create_table "consumptions", :force => true do |t|
    t.integer "product_category_id"
    t.integer "profile_id"
    t.text    "aditional_specifications"
  end

  create_table "domains", :force => true do |t|
    t.string  "name"
    t.string  "owner_type"
    t.integer "owner_id"
  end

  create_table "environments", :force => true do |t|
    t.string  "name"
    t.string  "contact_email"
    t.boolean "is_default"
    t.text    "settings"
    t.text    "design_data"
    t.text    "custom_header"
    t.text    "custom_footer"
    t.string  "theme"
  end

  create_table "favorite_enteprises_people", :id => false, :force => true do |t|
    t.integer "person_id"
    t.integer "enterprise_id"
  end

  create_table "friendships", :force => true do |t|
    t.integer  "person_id"
    t.integer  "friend_id"
    t.datetime "created_at"
    t.string   "group"
  end

  create_table "images", :force => true do |t|
    t.string  "owner_type"
    t.integer "owner_id"
    t.integer "parent_id"
    t.string  "content_type"
    t.string  "filename"
    t.string  "thumbnail"
    t.integer "size"
    t.integer "width"
    t.integer "height"
  end

  create_table "product_categorizations", :force => true do |t|
    t.integer  "category_id"
    t.integer  "product_id"
    t.boolean  "virtual",     :default => false
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  add_index "product_categorizations", ["category_id"], :name => "index_product_categorizations_on_category_id"
  add_index "product_categorizations", ["product_id"], :name => "index_product_categorizations_on_product_id"

  create_table "products", :force => true do |t|
    t.integer  "enterprise_id"
    t.integer  "product_category_id"
    t.string   "name"
    t.integer  "price",               :limit => 10, :precision => 10, :scale => 0
    t.text     "description"
    t.string   "image"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.float    "lat"
    t.float    "lng"
  end

  add_index "products", ["enterprise_id"], :name => "index_products_on_enterprise_id"

  create_table "profiles", :force => true do |t|
    t.string   "name"
    t.string   "type"
    t.string   "identifier"
    t.integer  "environment_id"
    t.boolean  "active",                          :default => true
    t.string   "address"
    t.string   "contact_phone"
    t.integer  "home_page_id"
    t.integer  "user_id"<commit_msg>ActionItem629: fixing db schema from mysql bad behavior<commit_after># This file is auto-generated from the current state of the database. Instead of editing this file, 
# please use the migrations feature of ActiveRecord 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 to check this file into your version control system.

ActiveRecord::Schema.define(:version => 53) do

  create_table "article_versions", :force => true do |t|
    t.integer  "article_id"
    t.integer  "version"
    t.string   "name"
    t.string   "slug"
    t.text     "path",               :default => ""
    t.integer  "parent_id"
    t.text     "body"
    t.text     "abstract"
    t.integer  "profile_id"
    t.datetime "updated_at"
    t.datetime "created_at"
    t.integer  "last_changed_by_id"
    t.integer  "size"
    t.string   "content_type"
    t.string   "filename"
    t.integer  "height"
    t.integer  "width"
    t.string   "versioned_type"
    t.integer  "comments_count"
    t.boolean  "advertise",          :default => true
    t.boolean  "published",          :default => true
    t.date     "start_date"
    t.date     "end_date"
    t.integer  "children_count",     :default => 0
    t.boolean  "public_article",     :default => true
    t.boolean  "accept_comments",    :default => true
  end

  create_table "articles", :force => true do |t|
    t.string   "name"
    t.string   "slug"
    t.text     "path",               :default => ""
    t.integer  "parent_id"
    t.text     "body"
    t.text     "abstract"
    t.integer  "profile_id"
    t.datetime "updated_at"
    t.datetime "created_at"
    t.integer  "last_changed_by_id"
    t.integer  "version"
    t.integer  "lock_version"
    t.string   "type"
    t.integer  "size"
    t.string   "content_type"
    t.string   "filename"
    t.integer  "height"
    t.integer  "width"
    t.integer  "comments_count",     :default => 0
    t.boolean  "advertise",          :default => true
    t.boolean  "published",          :default => true
    t.date     "start_date"
    t.date     "end_date"
    t.integer  "children_count",     :default => 0
    t.boolean  "public_article",     :default => true
    t.boolean  "accept_comments",    :default => true
  end

  create_table "articles_categories", :id => false, :force => true do |t|
    t.integer "article_id"
    t.integer "category_id"
    t.boolean "virtual",     :default => false
  end

  add_index "articles_categories", ["category_id"], :name => "index_articles_categories_on_category_id"
  add_index "articles_categories", ["article_id"], :name => "index_articles_categories_on_article_id"

  create_table "blocks", :force => true do |t|
    t.string  "title"
    t.integer "box_id"
    t.string  "type"
    t.text    "settings"
    t.integer "position"
  end

  add_index "blocks", ["box_id"], :name => "index_blocks_on_box_id"

  create_table "boxes", :force => true do |t|
    t.string  "owner_type"
    t.integer "owner_id"
    t.integer "position"
  end

  add_index "boxes", ["owner_type", "owner_id"], :name => "index_boxes_on_owner_type_and_owner_id"

  create_table "categories", :force => true do |t|
    t.string  "name"
    t.string  "slug"
    t.text    "path",            :default => ""
    t.integer "display_color"
    t.integer "environment_id"
    t.integer "parent_id"
    t.string  "type"
    t.float   "lat"
    t.float   "lng"
    t.boolean "display_in_menu", :default => false
    t.integer "children_count",  :default => 0
  end

  create_table "categories_profiles", :id => false, :force => true do |t|
    t.integer "profile_id"
    t.integer "category_id"
    t.boolean "virtual",     :default => false
  end

  add_index "categories_profiles", ["category_id"], :name => "index_categories_profiles_on_category_id"
  add_index "categories_profiles", ["profile_id"], :name => "index_categories_profiles_on_profile_id"

  create_table "comments", :force => true do |t|
    t.string   "title"
    t.text     "body"
    t.integer  "article_id"
    t.integer  "author_id"
    t.string   "name"
    t.string   "email"
    t.datetime "created_at"
  end

  create_table "consumptions", :force => true do |t|
    t.integer "product_category_id"
    t.integer "profile_id"
    t.text    "aditional_specifications"
  end

  create_table "domains", :force => true do |t|
    t.string  "name"
    t.string  "owner_type"
    t.integer "owner_id"
  end

  create_table "environments", :force => true do |t|
    t.string  "name"
    t.string  "contact_email"
    t.boolean "is_default"
    t.text    "settings"
    t.text    "design_data"
    t.text    "custom_header"
    t.text    "custom_footer"
    t.string  "theme"
  end

  create_table "favorite_enteprises_people", :id => false, :force => true do |t|
    t.integer "person_id"
    t.integer "enterprise_id"
  end

  create_table "friendships", :force => true do |t|
    t.integer  "person_id"
    t.integer  "friend_id"
    t.datetime "created_at"
    t.string   "group"
  end

  create_table "images", :force => true do |t|
    t.string  "owner_type"
    t.integer "owner_id"
    t.integer "parent_id"
    t.string  "content_type"
    t.string  "filename"
    t.string  "thumbnail"
    t.integer "size"
    t.integer "width"
    t.integer "height"
  end

  create_table "product_categorizations", :force => true do |t|
    t.integer  "category_id"
    t.integer  "product_id"
    t.boolean  "virtual",     :default => false
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  add_index "product_categorizations", ["category_id"], :name => "index_product_categorizations_on_category_id"
  add_index "product_categorizations", ["product_id"], :name => "index_product_categorizations_on_product_id"

  create_table "products", :force => true do |t|
    t.integer  "enterprise_id"
    t.integer  "product_category_id"
    t.string   "name"
    t.decimal  "price"
    t.text     "description"
    t.string   "image"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.float    "lat"
    t.float    "lng"
  end

  add_index "products", ["enterprise_id"], :name => "index_products_on_enterprise_id"

  create_table "profiles", :force => true do |t|
    t.string   "name"
    t.string   "type"
    t.string   "identifier"
    t.integer  "environment_id"
    t.boolean  "active",                          :default => true
    t.string   "address"
    t.string   "contact_phone"
    t.integer  "home_page_id"
    t.integer  "user_id"
{'fraction_non_alphanumeric': 0.1172992700729927, 'fraction_numerical': 0.00145985401459854, 'mean_word_length': 2.8868085106382977, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 103, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '2790479', 'n_tokens_mistral': 4696, 'n_tokens_neox': 4624, 'n_words': 1189}