gistfile1.rb

# encoding: UTF-8
# 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 => 20110520101834) do

  create_table "activities", :force => true do |t|
    t.boolean  "is_field_work"
    t.boolean  "is_done_as_troop_leader", :default => true
    t.integer  "troop_size",              :default => 1
    t.text     "description"
    t.datetime "started_on"
    t.datetime "ended_on"
    t.integer  "user_id"
    t.integer  "project_id"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.boolean  "is_done_with_equipment",  :default => false
    t.integer  "km_driven"
    t.string   "equipment_type",          :default => "none"
    t.datetime "date"
    t.float    "duration"
    t.integer  "activity_type_id"
  end

  create_table "activities_activity_days", :id => false, :force => true do |t|
    t.integer "activity_id"
    t.integer "activity_day_id"
  end

  create_table "activities_months", :id => false, :force => true do |t|
    t.integer "activity_id"
    t.integer "month_id"
  end

  create_table "activities_reports", :id => false, :force => true do |t|
    t.integer "activity_id"
    t.integer "report_id"
  end

  create_table "activities_weeks", :id => false, :force => true do |t|
    t.integer "activity_id"
    t.integer "week_id"
  end

  create_table "activities_years", :id => false, :force => true do |t|
    t.integer "activity_id"
    t.integer "year_id"
  end

  create_table "activity_days", :force => true do |t|
    t.datetime "started_on"
    t.datetime "ended_on"
    t.datetime "date"
    t.integer  "user_id"
    t.integer  "activity_week_id"
    t.integer  "activity_month_id"
    t.integer  "activity_year_id"
  end

  create_table "activity_months", :force => true do |t|
    t.datetime "starts_on"
    t.datetime "ends_on"
    t.integer  "user_id"
    t.integer  "activity_year_id"
  end

  create_table "activity_months_activity_weeks", :id => false, :force => true do |t|
    t.integer "activity_month_id"
    t.integer "activity_week_id"
  end

  create_table "activity_months_travels", :id => false, :force => true do |t|
    t.integer "activity_month_id"
    t.integer "travel_id"
  end

  create_table "activity_types", :force => true do |t|
    t.string   "name"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.integer  "creator_id"
    t.integer  "updater_id"
  end

  create_table "activity_types_reports", :id => false, :force => true do |t|
    t.integer "activity_type_id"
    t.integer "report_id"
  end

  create_table "activity_weeks", :force => true do |t|
    t.datetime "starts_on"
    t.datetime "ends_on"
    t.integer  "user_id"
  end

  create_table "activity_weeks_activity_years", :id => false, :force => true do |t|
    t.integer "activity_week_id"
    t.integer "activity_year_id"
  end

  create_table "activity_weeks_reports", :id => false, :force => true do |t|
    t.integer "activity_week_id"
    t.integer "report_id"
  end

  create_table "activity_years", :force => true do |t|
    t.datetime "starts_on"
    t.datetime "ends_on"
    t.integer  "user_id"
  end

  create_table "customers", :force => true do |t|
    t.string   "name"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.integer  "creator_id"
    t.integer  "updater_id"
  end

  create_table "food_allowances", :force => true do |t|
    t.datetime "starts_on"
    t.datetime "ends_on"
    t.integer  "amount"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.integer  "duration"
    t.integer  "creator_id"
    t.integer  "updater_id"
  end

  create_table "holidays", :force => true do |t|
    t.string   "name"
    t.datetime "date"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.integer  "creator_id"
    t.integer  "updater_id"
  end

  create_table "material_items", :force => true do |t|
    t.integer  "amount"
    t.integer  "activity_id"
    t.integer  "material_id"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  create_table "material_units", :force => true do |t|
    t.string   "name"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.integer  "creator_id"
    t.integer  "updater_id"
  end

  create_table "materials", :force => true do |t|
    t.string   "name"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.integer  "material_unit_id"
    t.integer  "creator_id"
    t.integer  "updater_id"
  end

  create_table "mileage_allowances", :force => true do |t|
    t.datetime "valid_from"
    t.integer  "amount"
    t.integer  "creator_id"
    t.integer  "updater_id"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  create_table "project_items", :force => true do |t|
    t.integer "project_id"
    t.integer "travel_id"
  end

  create_table "projects", :force => true do |t|
    t.string   "given_id"
    t.string   "name"
    t.integer  "customer_id"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.integer  "creator_id"
    t.integer  "updater_id"
    t.text     "notes"
  end

  create_table "report_types", :force => true do |t|
    t.string "name"
  end

  create_table "reports", :force => true do |t|
    t.datetime "created_at"
    t.datetime "updated_at"
    t.integer  "report_type_id"
    t.text     "content",             :limit => 2147483647
    t.integer  "creator_id"
    t.integer  "updater_id"
    t.boolean  "is_edited"
    t.integer  "project_id"
    t.integer  "user_id"
    t.datetime "start_date"
    t.datetime "end_date"
    t.boolean  "entire_project"
    t.string   "creation_parameters"
  end

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

  create_table "salary_types", :force => true do |t|
    t.string "name"
  end

  create_table "travels", :force => true do |t|
    t.boolean  "is_done_with_private_car"
    t.text     "cause"
    t.datetime "started_on"
    t.datetime "ended_on"
    t.integer  "amount_spent_for_provisions"
    t.integer  "amount_spent_for_incidentals"
    t.integer  "project_id"
    t.integer  "user_id"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.string   "destination"
    t.string   "routing"
    t.integer  "km_driven"
    t.integer  "mileage_allowance",            :default => 0
  end

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

  create_table "users", :force => true do |t|
    t.string   "username"
    t.string   "email"
    t.string   "password_hash"
    t.string   "family_name"
    t.integer  "contract_hours_per_week"
    t.integer  "vacation_days_per_year"
    t.integer  "user_function_id"
    t.datetime "born_on"
    t.boolean  "is_admin"
    t.boolean  "is_active"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.string   "crypted_password",                            :default => "",    :null => false
    t.string   "password_salt",                               :default => "",    :null => false
    t.string   "persistence_token",                           :default => "",    :null => false
    t.string   "perishable_token",                            :default => "",    :null => false
    t.integer  "login_count",                                 :default => 0,     :null => false
    t.integer  "failed_login_count",                          :default => 0,     :null => false
    t.datetime "last_request_at"
    t.datetime "current_login_at"
    t.datetime "last_login_at"
    t.string   "current_login_ip"
    t.string   "last_login_ip"
    t.integer  "creator_id"
    t.integer  "updater_id"
    t.boolean  "is_trusted",                                  :default => false
    t.integer  "salary_type_id"
    t.integer  "salary_amount"
    t.integer  "deducted_as_user_function_id"
    t.string   "given_name"
    t.datetime "began_on"
    t.datetime "left_on"
    t.string   "encrypted_password",           :limit => 128
    t.datetime "remember_created_at"
    t.integer  "sign_in_count",                               :default => 0
    t.datetime "current_sign_in_at"
    t.datetime "last_sign_in_at"
    t.string   "current_sign_in_ip"
    t.string   "last_sign_in_ip"
    t.integer  "failed_attempts",                             :default => 0
    t.string   "unlock_token"
    t.datetime "locked_at"
  end

end