<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 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 to check this file into your version control system.

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

  create_table "contents", :force => true do |t|
    t.string   "title"
    t.text     "description"
    t.text     "body"
    t.string   "type"
    t.string   "state"
    t.integer  "owner_id"
    t.datetime "published_at"
    t.integer  "position"
    t.integer  "parent_id"
    t.integer  "lft"
    t.integer  "rgt"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  create_table "grids", :force => true do |t|
    t.integer  "parent_id"
    t.integer  "lft"
    t.integer  "rgt"
    t.string   "yui"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.string   "title"
  end

  create_table "groups", :force => true do |t|
    t.string   "name"
    t.integer  "group_id"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  create_table "groups_roles", :id => false, :force => true do |t|
    t.integer "group_id"
    t.integer "role_id"
  end

  create_table "groups_users", :id => false, :force => true do |t|
    t.integer "group_id"
    t.integer "user_id"
  end

  create_table "images", :force => true do |t|
    t.string   "image_file_name"
    t.string   "image_content_type"
    t.integer  "image_file_size"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.string   "title"
  end

  create_table "pages", :force => true do |t|
    t.string   "title"
    t.string   "url"
    t.integer  "parent_id"
    t.integer  "lft"
    t.integer  "rgt"
    t.integer  "layout_id"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.string   "yui",        :limit => 10
  end

  create_table "parts", :force => true do |t|
    t.string   "name"
    t.string   "filename"
    t.text     "options"
    t.text     "preferred_types"
    t.integer  "subpart_id"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.text     "defined_options"
  end

  create_table "permissions", :force => true do |t|
    t.string   "app_controller"
    t.string   "app_method"
    t.boolean  "processed"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  create_table "permissions_roles", :id => false, :force => true do |t|
    t.integer "role_id"
    t.integer "permission_id"
  end

  create_table "picturizations", :force => true do |t|
    t.integer  "image_id"
    t.integer  "pictureable_id"
    t.string   "pictureable_type"
    t.integer  "position"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  create_table "plugin_schema_info", :id => false, :force => true do |t|
    t.string  "plugin_name"
    t.integer "version"
  end

  create_table "renderings", :force => true do |t|
    t.integer  "page_id"
    t.integer  "content_id"
    t.integer  "part_id"
    t.integer  "grid_id"
    t.integer  "position"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.string   "content_type"
    t.text     "options"
  end

  create_table "roles", :force => true do |t|
    t.string   "name"
    t.string   "short_name"
    t.boolean  "is_public"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  create_table "settings", :force => true do |t|
    t.string   "var",        :null => false
    t.text     "value"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  create_table "user_roles", :id => false, :force => true do |t|
    t.integer  "user_id"
    t.integer  "role_id"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  create_table "users", :force => true do |t|
    t.string   "login"
    t.string   "email"
    t.string   "remember_token"
    t.string   "crypted_password",          :limit => 40
    t.string   "password_reset_code",       :limit => 40
    t.string   "salt",                      :limit => 40
    t.string   "activation_code",           :limit => 40
    t.datetime "remember_token_expires_at"
    t.datetime "activated_at"
    t.datetime "deleted_at"
    t.string   "state",                                   :default => "passive"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.boolean  "is_admin"
  end

  create_table "videos", :force => true do |t|
    t.string   "title"
    t.integer  "artist_id"
    t.string   "artist_name"
    t.string   "image_url"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.string   "url"
  end

end
<commit_msg>schema got :limit on foreign keys. looks nice, we keep it<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 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 to check this file into your version control system.

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

  create_table "contents", :force => true do |t|
    t.string   "title"
    t.text     "description"
    t.text     "body"
    t.string   "type"
    t.string   "state"
    t.integer  "owner_id",     :limit => 11
    t.datetime "published_at"
    t.integer  "position",     :limit => 11
    t.integer  "parent_id",    :limit => 11
    t.integer  "lft",          :limit => 11
    t.integer  "rgt",          :limit => 11
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  create_table "grids", :force => true do |t|
    t.integer  "parent_id",  :limit => 11
    t.integer  "lft",        :limit => 11
    t.integer  "rgt",        :limit => 11
    t.string   "yui"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.string   "title"
  end

  create_table "groups", :force => true do |t|
    t.string   "name"
    t.integer  "group_id",   :limit => 11
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  create_table "groups_roles", :id => false, :force => true do |t|
    t.integer "group_id", :limit => 11
    t.integer "role_id",  :limit => 11
  end

  create_table "groups_users", :id => false, :force => true do |t|
    t.integer "group_id", :limit => 11
    t.integer "user_id",  :limit => 11
  end

  create_table "images", :force => true do |t|
    t.string   "image_file_name"
    t.string   "image_content_type"
    t.integer  "image_file_size",    :limit => 11
    t.datetime "created_at"
    t.datetime "updated_at"
    t.string   "title"
  end

  create_table "pages", :force => true do |t|
    t.string   "title"
    t.string   "url"
    t.integer  "parent_id",  :limit => 11
    t.integer  "lft",        :limit => 11
    t.integer  "rgt",        :limit => 11
    t.integer  "layout_id",  :limit => 11
    t.datetime "created_at"
    t.datetime "updated_at"
    t.string   "yui",        :limit => 10
  end

  create_table "parts", :force => true do |t|
    t.string   "name"
    t.string   "filename"
    t.text     "options"
    t.text     "preferred_types"
    t.integer  "subpart_id",      :limit => 11
    t.datetime "created_at"
    t.datetime "updated_at"
    t.text     "defined_options"
  end

  create_table "permissions", :force => true do |t|
    t.string   "app_controller"
    t.string   "app_method"
    t.boolean  "processed"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  create_table "permissions_roles", :id => false, :force => true do |t|
    t.integer "role_id",       :limit => 11
    t.integer "permission_id", :limit => 11
  end

  create_table "picturizations", :force => true do |t|
    t.integer  "image_id",         :limit => 11
    t.integer  "pictureable_id",   :limit => 11
    t.string   "pictureable_type"
    t.integer  "position",         :limit => 11
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  create_table "plugin_schema_info", :id => false, :force => true do |t|
    t.string  "plugin_name"
    t.integer "version",     :limit => 11
  end

  create_table "renderings", :force => true do |t|
    t.integer  "page_id",      :limit => 11
    t.integer  "content_id",   :limit => 11
    t.integer  "part_id",      :limit => 11
    t.integer  "grid_id",      :limit => 11
    t.integer  "position",     :limit => 11
    t.datetime "created_at"
    t.datetime "updated_at"
    t.string   "content_type"
    t.text     "options"
  end

  create_table "roles", :force => true do |t|
    t.string   "name"
    t.string   "short_name"
    t.boolean  "is_public"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  create_table "settings", :force => true do |t|
    t.string   "var",        :null => false
    t.text     "value"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  create_table "user_roles", :id => false, :force => true do |t|
    t.integer  "user_id",    :limit => 11
    t.integer  "role_id",    :limit => 11
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  create_table "users", :force => true do |t|
    t.string   "login"
    t.string   "email"
    t.string   "remember_token"
    t.string   "crypted_password",          :limit => 40
    t.string   "password_reset_code",       :limit => 40
    t.string   "salt",                      :limit => 40
    t.string   "activation_code",           :limit => 40
    t.datetime "remember_token_expires_at"
    t.datetime "activated_at"
    t.datetime "deleted_at"
    t.string   "state",                                   :default => "passive"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.boolean  "is_admin"
  end

  create_table "videos", :force => true do |t|
    t.string   "title"
    t.integer  "artist_id",   :limit => 11
    t.string   "artist_name"
    t.string   "image_url"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.string   "url"
  end

end

{'fraction_non_alphanumeric': 0.1179391100702576, 'fraction_numerical': 0.010679156908665105, 'mean_word_length': 2.5492021276595747, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 98, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 2, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '1941406', 'n_tokens_mistral': 3806, 'n_tokens_neox': 3643, 'n_words': 1034}