aboutsummaryrefslogtreecommitdiffstats
path: root/db
diff options
context:
space:
mode:
Diffstat (limited to 'db')
-rw-r--r--db/migrate/080_cache_only_clipped_attachment_text.rb10
-rw-r--r--db/schema.rb12
2 files changed, 16 insertions, 6 deletions
diff --git a/db/migrate/080_cache_only_clipped_attachment_text.rb b/db/migrate/080_cache_only_clipped_attachment_text.rb
new file mode 100644
index 000000000..0cd835e49
--- /dev/null
+++ b/db/migrate/080_cache_only_clipped_attachment_text.rb
@@ -0,0 +1,10 @@
+class CacheOnlyClippedAttachmentText < ActiveRecord::Migration
+ def self.up
+ remove_column :incoming_messages, :cached_attachment_text
+ add_column :incoming_messages, :cached_attachment_text_clipped, :text
+ end
+
+ def self.down
+ raise "safer not to have reverse migration scripts, and we never use them"
+ end
+end
diff --git a/db/schema.rb b/db/schema.rb
index 78f0ed992..59d779cd8 100644
--- a/db/schema.rb
+++ b/db/schema.rb
@@ -9,7 +9,7 @@
#
# It's strongly recommended to check this file into your version control system.
-ActiveRecord::Schema.define(:version => 79) do
+ActiveRecord::Schema.define(:version => 80) do
create_table "acts_as_xapian_jobs", :force => true do |t|
t.string "model", :null => false
@@ -69,12 +69,12 @@ ActiveRecord::Schema.define(:version => 79) do
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.text "cached_attachment_text"
+ t.integer "info_request_id", :null => false
+ t.datetime "created_at", :null => false
+ t.datetime "updated_at", :null => false
t.text "cached_main_body_text"
- t.integer "raw_email_id", :null => false
+ t.integer "raw_email_id", :null => false
+ t.text "cached_attachment_text_clipped"
end
create_table "info_request_events", :force => true do |t|