about summary refs log tree commit diff
path: root/db/migrate
diff options
context:
space:
mode:
authorunarist <m.unarist@gmail.com>2017-07-14 02:31:33 +0900
committerEugen Rochko <eugen@zeonfederated.com>2017-07-13 19:31:33 +0200
commitc2753fdfb471209fe7f2cdb8844e049207af8ba3 (patch)
tree398ed4b8eca9fa5c608e214b4b5badf0dedada24 /db/migrate
parentc29c20ab3cda3d4b752c67868925c1fe99d0ac71 (diff)
Make tag search case insensitive again (#4184)
Diffstat (limited to 'db/migrate')
-rw-r--r--db/migrate/20170713112503_make_tag_search_case_insensitive.rb11
1 files changed, 11 insertions, 0 deletions
diff --git a/db/migrate/20170713112503_make_tag_search_case_insensitive.rb b/db/migrate/20170713112503_make_tag_search_case_insensitive.rb
new file mode 100644
index 000000000..33ed6c005
--- /dev/null
+++ b/db/migrate/20170713112503_make_tag_search_case_insensitive.rb
@@ -0,0 +1,11 @@
+class MakeTagSearchCaseInsensitive < ActiveRecord::Migration[5.1]
+  def up
+    remove_index :tags, name: :hashtag_search_index
+    execute 'CREATE INDEX hashtag_search_index ON tags (lower(name) text_pattern_ops);'
+  end
+
+  def down
+    remove_index :tags, name: :hashtag_search_index
+    execute 'CREATE INDEX hashtag_search_index ON tags (name text_pattern_ops);'
+  end
+end