1. 27 Jul, 2017 2 commits
  2. 06 Jun, 2016 1 commit
  3. 07 Mar, 2016 1 commit
  4. 19 Feb, 2016 3 commits
  5. 01 Dec, 2015 1 commit
  6. 08 Nov, 2014 1 commit
    • use fulltext search in title and description. · d47df833
      * to quickly setup catalog_full_text table, you can use the following SQL.
      
        REPLACE INTO catalog_full_text SELECT uid, title, description FROM catalog;
      
      * non fulltext queries like '=abc', '>abc', '%abc%' are supported.
      
      * now erp5_full_text_mroonga_catalog is used for unit tests thus I recommend using it instead of erp5_full_text_myisam_catalog.
      
      * to migrate existing MyISAM full_text table into Mroonga, you can use the following SQL.
      
        ALTER TABLE full_text DROP KEY SearchableText,
          ENGINE = mroonga,
          ADD FULLTEXT KEY SearchableText (`SearchableText`) COMMENT 'parser "TokenBigramSplitSymbolAlpha"';
      
      * fulltext search score is no longer provided as (column_name) but now provided as (column_name)__score__.
      
      * (category)_title, like source_title, related keys are automatically generated. (category)_description keys as well.
      Kazuhiko Shiozaki committed
  7. 11 Sep, 2014 1 commit
  8. 10 Sep, 2013 3 commits
  9. 21 Jun, 2013 1 commit
  10. 15 Mar, 2013 1 commit
  11. 15 May, 2012 1 commit
  12. 07 Nov, 2011 1 commit
  13. 26 Oct, 2011 3 commits
  14. 25 Oct, 2011 2 commits
  15. 24 Oct, 2011 6 commits
  16. 21 Oct, 2011 7 commits
  17. 13 Oct, 2011 2 commits
  18. 12 Oct, 2011 1 commit
  19. 11 Oct, 2011 2 commits