/config/migrations/017_create_fulltext_indexes.rb

https://bitbucket.org/thrabal/smartlib · Ruby · 12 lines · 10 code · 2 blank · 0 comment · 0 complexity · a4c92fabaeeba84b8c3c60300674fe19 MD5 · raw file 

    

  1. Sequel.migration do
    2. 

  2. 

  3. 	up do
    4. 

  4. 		add_index :books_search,   :search_title, :type => :full_text
    5. 

  5. 		add_index :authors_search, :search_name, :type => :full_text
    6. 

  6. 	end
    7. 

  7. 

  8. 	down do
    9. 

  9. 		drop_index :authors_search, :search_name
    10. 

  10. 		drop_index :books_search,   :search_title
    11. 

  11. 	end
    12. 

  12. end
    13.