diff options
Diffstat (limited to 'db/schema.rb')
| -rw-r--r-- | db/schema.rb | 133 |
1 files changed, 70 insertions, 63 deletions
diff --git a/db/schema.rb b/db/schema.rb index 3632942d1..dccf6924c 100644 --- a/db/schema.rb +++ b/db/schema.rb @@ -1,98 +1,105 @@ -# This file is autogenerated. Instead of editing this file, please use the -# migrations feature of ActiveRecord to incrementally modify your database, and +# This file is auto-generated from the current state of the database. Instead of editing this file, +# please use the migrations feature of ActiveRecord 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 => 25) do create_table "incoming_messages", :force => true do |t| - t.column "info_request_id", :integer - t.column "raw_data", :text - t.column "created_at", :datetime - t.column "updated_at", :datetime - t.column "user_classified", :boolean, :default => false - t.column "contains_information", :boolean - t.column "is_bounce", :boolean, :default => false + t.integer "info_request_id" + t.text "raw_data" + t.datetime "created_at" + t.datetime "updated_at" + t.boolean "user_classified", :default => false + t.boolean "contains_information" + t.boolean "is_bounce", :default => false end create_table "info_request_events", :force => true do |t| - t.column "info_request_id", :integer - t.column "event_type", :text - t.column "params_yaml", :text - t.column "created_at", :datetime + t.integer "info_request_id" + t.text "event_type" + t.text "params_yaml" + t.datetime "created_at" end create_table "info_requests", :force => true do |t| - t.column "title", :text - t.column "user_id", :integer - t.column "public_body_id", :integer - t.column "created_at", :datetime - t.column "updated_at", :datetime + t.text "title" + t.integer "user_id" + t.integer "public_body_id" + t.datetime "created_at" + t.datetime "updated_at" end create_table "outgoing_messages", :force => true do |t| - t.column "info_request_id", :integer - t.column "body", :text - t.column "status", :string - t.column "message_type", :string - t.column "created_at", :datetime - t.column "updated_at", :datetime - t.column "last_sent_at", :datetime - t.column "incoming_message_followup_id", :integer + t.integer "info_request_id" + t.text "body" + t.string "status" + t.string "message_type" + t.datetime "created_at" + t.datetime "updated_at" + t.datetime "last_sent_at" + t.integer "incoming_message_followup_id" end create_table "post_redirects", :force => true do |t| - t.column "token", :text - t.column "uri", :text - t.column "post_params_yaml", :text - t.column "created_at", :datetime - t.column "updated_at", :datetime - t.column "email_token", :text - t.column "reason_params_yaml", :text - t.column "user_id", :integer + t.text "token" + t.text "uri" + t.text "post_params_yaml" + t.datetime "created_at" + t.datetime "updated_at" + t.text "email_token" + t.text "reason_params_yaml" + t.integer "user_id" end create_table "public_bodies", :force => true do |t| - t.column "name", :text - t.column "short_name", :text - t.column "request_email", :text - t.column "complaint_email", :text - t.column "version", :integer - t.column "last_edit_editor", :string - t.column "last_edit_comment", :string - t.column "created_at", :datetime - t.column "updated_at", :datetime + t.text "name" + t.text "short_name" + t.text "request_email" + t.text "complaint_email" + t.integer "version" + t.string "last_edit_editor" + t.string "last_edit_comment" + t.datetime "created_at" + t.datetime "updated_at" end create_table "public_body_versions", :force => true do |t| - t.column "public_body_id", :integer - t.column "version", :integer - t.column "name", :text - t.column "short_name", :text - t.column "request_email", :text - t.column "complaint_email", :text - t.column "updated_at", :datetime - t.column "last_edit_editor", :string - t.column "last_edit_comment", :string + t.integer "public_body_id" + t.integer "version" + t.text "name" + t.text "short_name" + t.text "request_email" + t.text "complaint_email" + t.datetime "updated_at" + t.string "last_edit_editor" + t.string "last_edit_comment" end create_table "sessions", :force => true do |t| - t.column "session_id", :string - t.column "data", :text - t.column "updated_at", :datetime - t.column "created_at", :datetime + t.string "session_id" + t.text "data" + t.datetime "updated_at" + t.datetime "created_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 "users", :force => true do |t| - t.column "email", :string - t.column "name", :string - t.column "hashed_password", :string - t.column "salt", :string - t.column "created_at", :datetime - t.column "updated_at", :datetime - t.column "email_confirmed", :boolean, :default => false + t.string "email", :default => "ook" + t.string "name" + t.string "hashed_password" + t.string "salt" + t.datetime "created_at" + t.datetime "updated_at" + t.boolean "email_confirmed", :default => false end end |