schema.rb 3.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596
  1. # encoding: UTF-8
  2. # This file is auto-generated from the current state of the database. Instead
  3. # of editing this file, please use the migrations feature of Active Record to
  4. # incrementally modify your database, and then regenerate this schema definition.
  5. #
  6. # Note that this schema.rb definition is the authoritative source for your
  7. # database schema. If you need to create the application database on another
  8. # system, you should be using db:schema:load, not running all the migrations
  9. # from scratch. The latter is a flawed and unsustainable approach (the more migrations
  10. # you'll amass, the slower it'll run and the greater likelihood for issues).
  11. #
  12. # It's strongly recommended to check this file into your version control system.
  13. ActiveRecord::Schema.define(:version => 20120715234111) do
  14. create_table "active_admin_comments", :force => true do |t|
  15. t.string "resource_id", :null => false
  16. t.string "resource_type", :null => false
  17. t.integer "author_id"
  18. t.string "author_type"
  19. t.text "body"
  20. t.datetime "created_at", :null => false
  21. t.datetime "updated_at", :null => false
  22. t.string "namespace"
  23. end
  24. add_index "active_admin_comments", ["author_type", "author_id"], :name => "index_active_admin_comments_on_author_type_and_author_id"
  25. add_index "active_admin_comments", ["namespace"], :name => "index_active_admin_comments_on_namespace"
  26. add_index "active_admin_comments", ["resource_type", "resource_id"], :name => "index_admin_notes_on_resource_type_and_resource_id"
  27. create_table "admin_users", :force => true do |t|
  28. t.string "email", :default => "", :null => false
  29. t.string "encrypted_password", :default => "", :null => false
  30. t.string "reset_password_token"
  31. t.datetime "reset_password_sent_at"
  32. t.datetime "remember_created_at"
  33. t.integer "sign_in_count", :default => 0
  34. t.datetime "current_sign_in_at"
  35. t.datetime "last_sign_in_at"
  36. t.string "current_sign_in_ip"
  37. t.string "last_sign_in_ip"
  38. t.datetime "created_at", :null => false
  39. t.datetime "updated_at", :null => false
  40. end
  41. add_index "admin_users", ["email"], :name => "index_admin_users_on_email", :unique => true
  42. add_index "admin_users", ["reset_password_token"], :name => "index_admin_users_on_reset_password_token", :unique => true
  43. create_table "bans", :force => true do |t|
  44. t.integer "frequency_id"
  45. t.string "hostmask"
  46. t.string "reason"
  47. t.datetime "valid_from"
  48. t.datetime "valid_to"
  49. t.boolean "activate"
  50. t.datetime "created_at", :null => false
  51. t.datetime "updated_at", :null => false
  52. end
  53. create_table "bots", :force => true do |t|
  54. t.string "botnick"
  55. t.string "owner"
  56. t.boolean "activate"
  57. t.datetime "created_at", :null => false
  58. t.datetime "updated_at", :null => false
  59. end
  60. create_table "channels", :force => true do |t|
  61. t.integer "bot_id"
  62. t.string "name"
  63. t.boolean "activate"
  64. t.datetime "created_at", :null => false
  65. t.datetime "updated_at", :null => false
  66. end
  67. create_table "frequencies", :force => true do |t|
  68. t.string "name"
  69. t.string "prefix"
  70. t.string "helpmsg"
  71. t.string "description"
  72. t.integer "delay"
  73. t.boolean "activate"
  74. t.datetime "created_at", :null => false
  75. t.datetime "updated_at", :null => false
  76. end
  77. create_table "users", :force => true do |t|
  78. t.string "email"
  79. t.string "password"
  80. t.string "name"
  81. t.integer "quota"
  82. t.datetime "created_at", :null => false
  83. t.datetime "updated_at", :null => false
  84. end
  85. end