# This file is autogenerated. Instead of editing this file, please use the
# migrations feature of ActiveRecord to incrementally modify your database, and
# then regenerate this schema definition.

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

  create_table "groups", :force => true do |t|
    t.column "created_at", :datetime, :null => false
    t.column "updated_at", :datetime, :null => false
    t.column "title", :string, :limit => nil, :null => false
    t.column "parent_id", :integer
  end

  add_index "groups", ["parent_id"], :name => "groups_parent_index"
  add_index "groups", ["title"], :name => "groups_title_key", :unique => true

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

  add_index "groups_roles", ["group_id", "role_id"], :name => "groups_roles_all_index"
  add_index "groups_roles", ["group_id", "role_id"], :name => "groups_roles_group_id_key", :unique => true

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

  add_index "groups_users", ["group_id", "user_id"], :name => "groups_users_all_index"
  add_index "groups_users", ["group_id", "user_id"], :name => "groups_users_group_id_key", :unique => true

  create_table "patch_versions", :force => true do |t|
    t.column "patch_id", :integer
    t.column "comment", :text
    t.column "for_upstream_version", :string, :limit => 10
    t.column "created_at", :datetime
    t.column "created_by", :string, :limit => 20
    t.column "updated_at", :datetime
    t.column "updated_by", :string, :limit => 20
  end

  create_table "patches", :force => true do |t|
    t.column "program_id", :integer
    t.column "title", :string, :limit => 254, :default => "", :null => false
    t.column "description", :text, :null => false
    t.column "created_at", :datetime
    t.column "created_by", :string, :limit => 20
    t.column "updated_at", :datetime
    t.column "updated_by", :string, :limit => 20
    t.column "applied_since_version", :string, :limit => 20
    t.column "filename", :string, :limit => 80
    t.column "applied_at", :datetime
    t.column "applied_by", :string, :limit => 20
  end

  create_table "programs", :force => true do |t|
    t.column "name", :string, :limit => 254
    t.column "url", :string, :limit => 254
  end

  create_table "roles", :force => true do |t|
    t.column "created_at", :datetime, :null => false
    t.column "updated_at", :datetime, :null => false
    t.column "title", :string, :limit => 100, :null => false
    t.column "parent_id", :integer
  end

  add_index "roles", ["parent_id"], :name => "roles_parent_index"
  add_index "roles", ["title"], :name => "roles_title_key", :unique => true

  create_table "roles_static_permissions", :id => false, :force => true do |t|
    t.column "static_permission_id", :integer, :null => false
    t.column "role_id", :integer, :null => false
    t.column "created_at", :datetime, :null => false
  end

  add_index "roles_static_permissions", ["static_permission_id", "role_id"], :name => "roles_static_permissions_all_index"
  add_index "roles_static_permissions", ["static_permission_id", "role_id"], :name => "roles_static_permissions_static_permission_id_key", :unique => true

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

  add_index "roles_users", ["user_id", "role_id"], :name => "roles_users_all_index"
  add_index "roles_users", ["user_id", "role_id"], :name => "roles_users_user_id_key", :unique => true

  create_table "static_permissions", :force => true do |t|
    t.column "title", :string, :limit => 200, :null => false
    t.column "created_at", :datetime, :null => false
    t.column "updated_at", :datetime, :null => false
  end

  add_index "static_permissions", ["title"], :name => "static_permissions_title_index"
  add_index "static_permissions", ["title"], :name => "static_permissions_title_key", :unique => true

  create_table "user_registrations", :force => true do |t|
    t.column "user_id", :integer, :null => false
    t.column "token", :text, :null => false
    t.column "created_at", :datetime, :null => false
    t.column "expires_at", :datetime, :null => false
  end

  add_index "user_registrations", ["expires_at"], :name => "user_registration_expires_at_index"
  add_index "user_registrations", ["user_id"], :name => "user_registrations_user_id_index"
  add_index "user_registrations", ["user_id"], :name => "user_registrations_user_id_key", :unique => true

  create_table "users", :force => true do |t|
    t.column "created_at", :datetime, :null => false
    t.column "updated_at", :datetime, :null => false
    t.column "last_logged_in_at", :datetime, :null => false
    t.column "login_failure_count", :integer, :null => false
    t.column "login", :string, :limit => 100, :null => false
    t.column "email", :string, :limit => 200, :null => false
    t.column "password", :string, :limit => 100, :null => false
    t.column "password_hash_type", :string, :limit => 20, :null => false
    t.column "password_salt", :string, :limit => 10, :null => false
    t.column "state", :integer, :default => 1, :null => false
  end

  add_index "users", ["login"], :name => "users_login_index"
  add_index "users", ["login"], :name => "users_login_key", :unique => true
  add_index "users", ["password"], :name => "users_password_index"

end