summaryrefslogtreecommitdiff
path: root/db/migrate/20170522210610_add_search_indexes.rb
diff options
context:
space:
mode:
Diffstat (limited to 'db/migrate/20170522210610_add_search_indexes.rb')
-rw-r--r--db/migrate/20170522210610_add_search_indexes.rb8
1 files changed, 8 insertions, 0 deletions
diff --git a/db/migrate/20170522210610_add_search_indexes.rb b/db/migrate/20170522210610_add_search_indexes.rb
new file mode 100644
index 0000000..2225d7b
--- /dev/null
+++ b/db/migrate/20170522210610_add_search_indexes.rb
@@ -0,0 +1,8 @@
+class AddSearchIndexes < ActiveRecord::Migration
+ def change
+ add_index :forumthreads, [:title, :content], type: :fulltext
+ add_index :forumthreads, :title, type: :fulltext
+ add_index :forumthreads, :content, type: :fulltext
+ add_index :threadreplies, :content, type: :fulltext
+ end
+end