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

  create_table "articles", :force => true do |t|
    t.column "title", :string, :default => "", :null => false
    t.column "description", :text, :default => "", :null => false
    t.column "lastupdate", :date
  end

  create_table "engine_schema_info", :id => false, :force => true do |t|
    t.column "engine_name", :string
    t.column "version", :integer
  end

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

  create_table "globalize_countries", :force => true do |t|
    t.column "code", :string, :limit => 2
    t.column "english_name", :string
    t.column "date_format", :string
    t.column "currency_format", :string
    t.column "currency_code", :string, :limit => 3
    t.column "thousands_sep", :string, :limit => 2
    t.column "decimal_sep", :string, :limit => 2
    t.column "currency_decimal_sep", :string, :limit => 2
    t.column "number_grouping_scheme", :string
  end

  add_index "globalize_countries", ["code"], :name => "globalize_countries_code_index"

  create_table "globalize_languages", :force => true do |t|
    t.column "iso_639_1", :string, :limit => 2
    t.column "iso_639_2", :string, :limit => 3
    t.column "iso_639_3", :string, :limit => 3
    t.column "rfc_3066", :string
    t.column "english_name", :string
    t.column "english_name_locale", :string
    t.column "english_name_modifier", :string
    t.column "native_name", :string
    t.column "native_name_locale", :string
    t.column "native_name_modifier", :string
    t.column "macro_language", :boolean
    t.column "direction", :string
    t.column "pluralization", :string
    t.column "scope", :string, :limit => 1
  end

  add_index "globalize_languages", ["iso_639_1"], :name => "globalize_languages_iso_639_1_index"
  add_index "globalize_languages", ["iso_639_2"], :name => "globalize_languages_iso_639_2_index"
  add_index "globalize_languages", ["iso_639_3"], :name => "globalize_languages_iso_639_3_index"
  add_index "globalize_languages", ["rfc_3066"], :name => "globalize_languages_rfc_3066_index"

  create_table "globalize_translations", :force => true do |t|
    t.column "type", :string
    t.column "tr_key", :string
    t.column "table_name", :string
    t.column "item_id", :integer
    t.column "facet", :string
    t.column "language_id", :integer
    t.column "pluralization_index", :integer
    t.column "text", :text
  end

  add_index "globalize_translations", ["tr_key", "language_id"], :name => "globalize_translations_tr_key_index"
  add_index "globalize_translations", ["table_name", "item_id", "language_id"], :name => "globalize_translations_table_name_index"

  create_table "users", :force => true do |t|
    t.column "login", :string, :limit => 80, :default => "", :null => false
    t.column "salted_password", :string, :limit => 40, :default => "", :null => false
    t.column "email", :string, :limit => 60, :default => "", :null => false
    t.column "firstname", :string, :limit => 40
    t.column "lastname", :string, :limit => 40
    t.column "salt", :string, :limit => 40, :default => "", :null => false
    t.column "verified", :integer, :default => 0
    t.column "role", :string, :limit => 40
    t.column "security_token", :string, :limit => 40
    t.column "token_expiry", :datetime
    t.column "created_at", :datetime
    t.column "updated_at", :datetime
    t.column "logged_in_at", :datetime
    t.column "deleted", :integer, :default => 0
    t.column "delete_after", :datetime
  end

end