diff options
| -rw-r--r-- | db/schema.rb | 262 |
1 files changed, 0 insertions, 262 deletions
diff --git a/db/schema.rb b/db/schema.rb deleted file mode 100644 index 11eb3ced0..000000000 --- a/db/schema.rb +++ /dev/null @@ -1,262 +0,0 @@ -# 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 => 95) do - - create_table "acts_as_xapian_jobs", :force => true do |t| - t.string "model", :null => false - t.integer "model_id", :null => false - t.string "action", :null => false - end - - add_index "acts_as_xapian_jobs", ["model", "model_id"], :name => "index_acts_as_xapian_jobs_on_model_and_model_id", :unique => true - - create_table "censor_rules", :force => true do |t| - t.integer "info_request_id" - t.integer "user_id" - t.integer "public_body_id" - t.text "text", :null => false - t.text "replacement", :null => false - t.string "last_edit_editor", :null => false - t.text "last_edit_comment", :null => false - t.datetime "created_at", :null => false - t.datetime "updated_at", :null => false - end - - add_index "censor_rules", ["info_request_id"], :name => "index_censor_rules_on_info_request_id" - add_index "censor_rules", ["public_body_id"], :name => "index_censor_rules_on_public_body_id" - add_index "censor_rules", ["user_id"], :name => "index_censor_rules_on_user_id" - - create_table "comments", :force => true do |t| - t.integer "user_id", :null => false - t.string "comment_type", :default => "internal_error", :null => false - t.integer "info_request_id" - t.text "body", :null => false - t.boolean "visible", :default => true, :null => false - t.datetime "created_at", :null => false - t.datetime "updated_at", :null => false - end - - create_table "exim_log_dones", :force => true do |t| - t.text "filename", :null => false - t.datetime "last_stat", :null => false - t.datetime "created_at", :null => false - t.datetime "updated_at", :null => false - end - - add_index "exim_log_dones", ["last_stat"], :name => "index_exim_log_dones_on_last_stat" - - create_table "exim_logs", :force => true do |t| - t.integer "exim_log_done_id" - t.integer "info_request_id" - t.integer "order", :null => false - t.text "line", :null => false - t.datetime "created_at", :null => false - t.datetime "updated_at", :null => false - end - - add_index "exim_logs", ["exim_log_done_id"], :name => "index_exim_logs_on_exim_log_done_id" - - create_table "has_tag_string_tags", :force => true do |t| - t.integer "model_id", :null => false - t.text "name", :null => false - t.datetime "created_at", :null => false - t.text "value" - t.string "model", :null => false - end - - add_index "has_tag_string_tags", ["model", "model_id", "name", "value"], :name => "index_has_tag_string_tags_on_model_and_model_id_and_name_and_va" - add_index "has_tag_string_tags", ["model", "model_id"], :name => "index_has_tag_string_tags_on_model_and_model_id" - add_index "has_tag_string_tags", ["name"], :name => "index_has_tag_string_tags_on_name" - - create_table "holidays", :force => true do |t| - t.date "day" - t.text "description" - end - - add_index "holidays", ["day"], :name => "index_holidays_on_day" - - create_table "incoming_messages", :force => true do |t| - t.integer "info_request_id", :null => false - t.datetime "created_at", :null => false - t.datetime "updated_at", :null => false - t.integer "raw_email_id", :null => false - t.text "cached_attachment_text_clipped" - t.text "cached_main_body_text_folded" - t.text "cached_main_body_text_unfolded" - end - - create_table "info_request_events", :force => true do |t| - t.integer "info_request_id", :null => false - t.text "event_type", :null => false - t.text "params_yaml", :null => false - t.datetime "created_at", :null => false - t.string "described_state" - t.string "calculated_state" - t.datetime "last_described_at" - t.integer "incoming_message_id" - t.integer "outgoing_message_id" - t.integer "comment_id" - t.string "prominence", :default => "normal", :null => false - end - - add_index "info_request_events", ["created_at"], :name => "index_info_request_events_on_created_at" - add_index "info_request_events", ["info_request_id"], :name => "index_info_request_events_on_info_request_id" - - create_table "info_requests", :force => true do |t| - t.text "title", :null => false - t.integer "user_id", :null => false - t.integer "public_body_id", :null => false - t.datetime "created_at", :null => false - t.datetime "updated_at", :null => false - t.string "described_state", :null => false - t.boolean "awaiting_description", :default => false, :null => false - t.string "prominence", :default => "normal", :null => false - t.text "url_title", :null => false - t.string "law_used", :default => "foi", :null => false - t.string "allow_new_responses_from", :default => "anybody", :null => false - t.string "handle_rejected_responses", :default => "bounce", :null => false - end - - add_index "info_requests", ["created_at"], :name => "index_info_requests_on_created_at" - add_index "info_requests", ["title"], :name => "index_info_requests_on_title" - add_index "info_requests", ["url_title"], :name => "index_info_requests_on_url_title", :unique => true - - create_table "outgoing_messages", :force => true do |t| - t.integer "info_request_id", :null => false - t.text "body", :null => false - t.string "status", :null => false - t.string "message_type", :null => false - t.datetime "created_at", :null => false - t.datetime "updated_at", :null => false - t.datetime "last_sent_at" - t.integer "incoming_message_followup_id" - t.string "what_doing", :null => false - end - - add_index "outgoing_messages", ["what_doing"], :name => "index_outgoing_messages_on_what_doing" - - create_table "post_redirects", :force => true do |t| - t.text "token", :null => false - t.text "uri", :null => false - t.text "post_params_yaml" - t.datetime "created_at", :null => false - t.datetime "updated_at", :null => false - t.text "email_token", :null => false - t.text "reason_params_yaml" - t.integer "user_id" - t.text "circumstance", :default => "normal", :null => false - end - - add_index "post_redirects", ["email_token"], :name => "index_post_redirects_on_email_token" - add_index "post_redirects", ["token"], :name => "index_post_redirects_on_token" - add_index "post_redirects", ["updated_at"], :name => "index_post_redirects_on_updated_at" - add_index "post_redirects", ["user_id"], :name => "index_post_redirects_on_user_id" - - create_table "profile_photos", :force => true do |t| - t.binary "data", :null => false - t.integer "user_id" - t.boolean "draft", :default => false, :null => false - end - - create_table "public_bodies", :force => true do |t| - t.text "name", :null => false - t.text "short_name", :null => false - t.text "request_email", :null => false - t.integer "version", :null => false - t.string "last_edit_editor", :null => false - t.text "last_edit_comment", :null => false - t.datetime "created_at", :null => false - t.datetime "updated_at", :null => false - t.text "url_name", :null => false - t.text "home_page", :default => "", :null => false - t.text "notes", :default => "", :null => false - t.string "first_letter", :null => false - t.text "publication_scheme", :default => "", :null => false - end - - add_index "public_bodies", ["first_letter"], :name => "index_public_bodies_on_first_letter" - add_index "public_bodies", ["url_name"], :name => "index_public_bodies_on_url_name", :unique => true - - create_table "public_body_versions", :force => true do |t| - t.integer "public_body_id" - t.integer "version" - t.text "name" - t.text "short_name" - t.text "request_email" - t.datetime "updated_at" - t.string "last_edit_editor" - t.text "last_edit_comment" - t.text "url_name" - t.text "home_page" - t.text "notes" - t.text "publication_scheme", :default => "", :null => false - t.text "charity_number", :default => "", :null => false - end - - create_table "raw_emails", :force => true do |t| - t.text "data_text" - t.binary "data_binary" - end - - create_table "track_things", :force => true do |t| - t.integer "tracking_user_id", :null => false - t.string "track_query", :null => false - t.integer "info_request_id" - t.integer "tracked_user_id" - t.integer "public_body_id" - t.string "track_medium", :null => false - t.string "track_type", :default => "internal_error", :null => false - t.datetime "created_at" - t.datetime "updated_at" - end - - add_index "track_things", ["track_query", "tracking_user_id"], :name => "index_track_things_on_tracking_user_id_and_track_query", :unique => true - - create_table "track_things_sent_emails", :force => true do |t| - t.integer "track_thing_id", :null => false - t.integer "info_request_event_id" - t.integer "user_id" - t.integer "public_body_id" - t.datetime "created_at" - t.datetime "updated_at" - end - - add_index "track_things_sent_emails", ["created_at"], :name => "index_track_things_sent_emails_on_created_at" - add_index "track_things_sent_emails", ["track_thing_id"], :name => "index_track_things_sent_emails_on_track_thing_id" - - create_table "user_info_request_sent_alerts", :force => true do |t| - t.integer "user_id", :null => false - t.integer "info_request_id", :null => false - t.string "alert_type", :null => false - t.integer "info_request_event_id" - end - - add_index "user_info_request_sent_alerts", ["alert_type", "info_request_id", "user_id"], :name => "user_info_request_sent_alerts_unique_index", :unique => true - - create_table "users", :force => true do |t| - t.string "email", :null => false - t.string "name", :null => false - t.string "hashed_password", :null => false - t.string "salt", :null => false - t.datetime "created_at", :null => false - t.datetime "updated_at", :null => false - t.boolean "email_confirmed", :default => false, :null => false - t.text "url_name", :null => false - t.datetime "last_daily_track_email", :default => '2000-01-01 00:00:00' - t.string "admin_level", :default => "none", :null => false - t.text "ban_text", :default => "", :null => false - t.text "about_me", :default => "", :null => false - end - - add_index "users", ["url_name"], :name => "index_users_on_url_name", :unique => true - -end |