# 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 => 20100715142960) do

  create_table "actions", :id => false, :force => true do |t|
    t.string   "id",         :limit => 36, :null => false
    t.string   "name"
    t.text     "tasks"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  create_table "appsettings", :id => false, :force => true do |t|
    t.string   "id",         :limit => 36,                            :null => false
    t.string   "name"
    t.string   "path"
    t.string   "exe"
    t.text     "params",     :limit => 255
    t.datetime "created_at"
    t.datetime "updated_at"
    t.string   "logpath"
    t.string   "modpath"
    t.string   "type",                      :default => "Appsetting"
    t.boolean  "beta"
    t.boolean  "server"
  end

  create_table "categories", :id => false, :force => true do |t|
    t.string   "id",         :limit => 36, :null => false
    t.string   "name"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  create_table "categories_mods", :id => false, :force => true do |t|
    t.string "category_id", :limit => 36
    t.string "mod_id",      :limit => 36
  end

  create_table "dependentmods", :id => false, :force => true do |t|
    t.string "mod_id",    :limit => 36
    t.string "depmod_id", :limit => 36
  end

  create_table "goldberg_content_pages", :force => true do |t|
    t.string   "title"
    t.string   "name",            :null => false
    t.integer  "markup_style_id"
    t.text     "content"
    t.integer  "permission_id",   :null => false
    t.datetime "created_at"
    t.datetime "updated_at"
    t.text     "content_cache"
    t.string   "markup_style"
  end

  add_index "goldberg_content_pages", ["markup_style_id"], :name => "fk_content_page_markup_style_id"
  add_index "goldberg_content_pages", ["permission_id"], :name => "fk_content_page_permission_id"

  create_table "goldberg_controller_actions", :force => true do |t|
    t.integer "site_controller_id", :null => false
    t.string  "name",               :null => false
    t.integer "permission_id"
    t.string  "url_to_use"
  end

  add_index "goldberg_controller_actions", ["permission_id"], :name => "fk_controller_action_permission_id"
  add_index "goldberg_controller_actions", ["site_controller_id"], :name => "fk_controller_action_site_controller_id"

  create_table "goldberg_menu_items", :force => true do |t|
    t.integer "parent_id"
    t.string  "name",                 :null => false
    t.string  "label",                :null => false
    t.integer "seq"
    t.integer "controller_action_id"
    t.integer "content_page_id"
  end

  add_index "goldberg_menu_items", ["content_page_id"], :name => "fk_menu_item_content_page_id"
  add_index "goldberg_menu_items", ["controller_action_id"], :name => "fk_menu_item_controller_action_id"
  add_index "goldberg_menu_items", ["parent_id"], :name => "fk_menu_item_parent_id"

  create_table "goldberg_permissions", :force => true do |t|
    t.string "name", :default => "", :null => false
  end

  create_table "goldberg_roles", :force => true do |t|
    t.string   "name",                            :null => false
    t.integer  "parent_id"
    t.string   "description",     :default => "", :null => false
    t.integer  "default_page_id"
    t.text     "cache"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.string   "start_path"
  end

  add_index "goldberg_roles", ["default_page_id"], :name => "fk_role_default_page_id"
  add_index "goldberg_roles", ["parent_id"], :name => "fk_role_parent_id"

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

  add_index "goldberg_roles_permissions", ["permission_id"], :name => "fk_roles_permission_permission_id"
  add_index "goldberg_roles_permissions", ["role_id"], :name => "fk_roles_permission_role_id"

  create_table "goldberg_site_controllers", :force => true do |t|
    t.string  "name",                         :null => false
    t.integer "permission_id",                :null => false
    t.integer "builtin",       :default => 0
  end

  add_index "goldberg_site_controllers", ["permission_id"], :name => "fk_site_controller_permission_id"

  create_table "goldberg_system_settings", :force => true do |t|
    t.string  "site_name",                                           :null => false
    t.string  "site_subtitle"
    t.string  "footer_message",                      :default => ""
    t.integer "public_role_id",                                      :null => false
    t.integer "session_timeout",                     :default => 0,  :null => false
    t.integer "site_default_page_id",                                :null => false
    t.integer "not_found_page_id",                                   :null => false
    t.integer "permission_denied_page_id",                           :null => false
    t.integer "session_expired_page_id",                             :null => false
    t.integer "menu_depth",                          :default => 0,  :null => false
    t.string  "start_path"
    t.string  "site_url_prefix"
    t.boolean "self_reg_enabled"
    t.integer "self_reg_role_id"
    t.boolean "self_reg_confirmation_required"
    t.integer "self_reg_confirmation_error_page_id"
    t.boolean "self_reg_send_confirmation_email"
  end

  add_index "goldberg_system_settings", ["not_found_page_id"], :name => "fk_system_settings_not_found_page_id"
  add_index "goldberg_system_settings", ["permission_denied_page_id"], :name => "fk_system_settings_permission_denied_page_id"
  add_index "goldberg_system_settings", ["public_role_id"], :name => "fk_system_settings_public_role_id"
  add_index "goldberg_system_settings", ["session_expired_page_id"], :name => "fk_system_settings_session_expired_page_id"
  add_index "goldberg_system_settings", ["site_default_page_id"], :name => "fk_system_settings_site_default_page_id"

  create_table "goldberg_users", :force => true do |t|
    t.string   "name",                                         :null => false
    t.string   "password",                       :limit => 40, :null => false
    t.integer  "role_id",                                      :null => false
    t.string   "password_salt"
    t.string   "fullname"
    t.string   "email"
    t.string   "start_path"
    t.boolean  "self_reg_confirmation_required"
    t.string   "confirmation_key"
    t.datetime "password_changed_at"
    t.boolean  "password_expired"
  end

  add_index "goldberg_users", ["role_id"], :name => "fk_user_role_id"

  create_table "logs", :force => true do |t|
    t.text     "content"
    t.integer  "logsession_id"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

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

  create_table "mods", :id => false, :force => true do |t|
    t.string   "id",              :limit => 36,                    :null => false
    t.string   "name"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.string   "version"
    t.string   "version_local"
    t.boolean  "skip"
    t.boolean  "disabled"
    t.string   "path"
    t.integer  "priority"
    t.integer  "size",                          :default => 0
    t.integer  "size_wd",                       :default => 0
    t.datetime "updated_version"
    t.string   "type",                          :default => "Mod"
  end

  create_table "mods_networks", :id => false, :force => true do |t|
    t.string "mod_id",     :limit => 36
    t.string "network_id", :limit => 36
  end

  add_index "mods_networks", ["mod_id"], :name => "index_mods_networks_on_mod_id"
  add_index "mods_networks", ["network_id"], :name => "index_mods_networks_on_network_id"

  create_table "mods_queryservers", :id => false, :force => true do |t|
    t.string  "mod_id",         :limit => 36
    t.integer "queryserver_id"
  end

  add_index "mods_queryservers", ["mod_id"], :name => "index_mods_queryservers_on_mod_id"
  add_index "mods_queryservers", ["queryserver_id"], :name => "index_mods_queryservers_on_queryserver_id"

  create_table "mods_servers", :id => false, :force => true do |t|
    t.string "mod_id",    :limit => 36, :null => false
    t.string "server_id", :limit => 36, :null => false
  end

  add_index "mods_servers", ["mod_id"], :name => "index_mods_servers_on_mod_id"
  add_index "mods_servers", ["server_id"], :name => "index_mods_servers_on_server_id"

  create_table "mods_sixconfigs", :id => false, :force => true do |t|
    t.string "mod_id",       :limit => 36, :null => false
    t.string "sixconfig_id", :limit => 36, :null => false
  end

  add_index "mods_sixconfigs", ["mod_id"], :name => "index_mods_sixconfigs_on_mod_id"
  add_index "mods_sixconfigs", ["sixconfig_id"], :name => "index_mods_sixconfigs_on_sixconfig_id"

  create_table "networks", :id => false, :force => true do |t|
    t.string   "id",         :limit => 36, :null => false
    t.string   "name"
    t.string   "homepage"
    t.boolean  "disabled"
    t.integer  "priority"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

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

  create_table "queryservers", :force => true do |t|
    t.string   "name"
    t.string   "ip"
    t.integer  "port"
    t.integer  "failures",                            :default => 0
    t.datetime "created_at"
    t.datetime "updated_at"
    t.text     "mod",              :limit => 1048576
    t.text     "players",          :limit => 1048576
    t.text     "signatures",       :limit => 1048576
    t.integer  "numplayers",                          :default => 0
    t.integer  "gamestate"
    t.integer  "language"
    t.integer  "ping"
    t.integer  "difficulty"
    t.string   "gamever"
    t.string   "gametype"
    t.string   "gamemode"
    t.string   "mission"
    t.string   "mapname"
    t.string   "country"
    t.string   "platform"
    t.boolean  "sv_battleye"
    t.boolean  "verifysignatures"
    t.boolean  "password"
    t.boolean  "dedicated"
    t.boolean  "favorite"
    t.string   "saved_password"
  end

  add_index "queryservers", ["ip", "port"], :name => "index_queryservers_on_ip_and_port"
  add_index "queryservers", ["name"], :name => "index_queryservers_on_name"

  create_table "repositories", :id => false, :force => true do |t|
    t.string   "id",         :limit => 36, :null => false
    t.string   "url"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.boolean  "disabled"
    t.string   "network_id", :limit => 36
    t.integer  "priority"
  end

  create_table "servers", :id => false, :force => true do |t|
    t.string   "id",         :limit => 36, :null => false
    t.string   "name"
    t.string   "address"
    t.integer  "port"
    t.string   "password"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  create_table "sessions", :force => true do |t|
    t.string   "session_id", :null => false
    t.text     "data"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  add_index "sessions", ["session_id"], :name => "index_sessions_on_session_id"
  add_index "sessions", ["updated_at"], :name => "index_sessions_on_updated_at"

  create_table "sixconfigs", :id => false, :force => true do |t|
    t.string   "id",                 :limit => 36, :null => false
    t.string   "name"
    t.integer  "current_setting_id"
    t.integer  "current_server_id"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.string   "appsetting_id",      :limit => 36
    t.string   "server_id",          :limit => 36
    t.string   "action_id",          :limit => 36
  end

  create_table "system_settings", :force => true do |t|
    t.string   "server_username"
    t.string   "server_password"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.datetime "synchronized_at"
    t.boolean  "autoskip",                                :default => true
    t.string   "favorite_preset",           :limit => 36
    t.string   "favorite_server",           :limit => 36
    t.string   "favorite_action",           :limit => 36
    t.string   "favorite_settings_profile", :limit => 36
    t.boolean  "inweb"
    t.datetime "gamespied_at"
    t.boolean  "beta"
  end

end