diff options
| author | unarist <m.unarist@gmail.com> | 2017-07-14 02:31:33 +0900 |
|---|---|---|
| committer | Eugen Rochko <eugen@zeonfederated.com> | 2017-07-13 19:31:33 +0200 |
| commit | c2753fdfb471209fe7f2cdb8844e049207af8ba3 (patch) | |
| tree | 398ed4b8eca9fa5c608e214b4b5badf0dedada24 /db/migrate/20170713112503_make_tag_search_case_insensitive.rb | |
| parent | c29c20ab3cda3d4b752c67868925c1fe99d0ac71 (diff) | |
Make tag search case insensitive again (#4184)
Diffstat (limited to 'db/migrate/20170713112503_make_tag_search_case_insensitive.rb')
| -rw-r--r-- | db/migrate/20170713112503_make_tag_search_case_insensitive.rb | 11 |
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 |