Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save chicks/11149452 to your computer and use it in GitHub Desktop.
Save chicks/11149452 to your computer and use it in GitHub Desktop.
Bypass DB2 FTS Requirement
<?php
//sugarcrm/custom/Extension/modules/KBContents/Ext/Vardefs/vardefs.php
$dictionary['KBContent']['indices'] = array(
array('name' => 'kbcontentspk', 'type' => 'primary', 'fields' => array('id')),
array('name' => 'fts_unique_idx', 'type' => 'unique', 'fields' => array('kb_index')),
//array('name' => '', 'type' => 'fulltext', 'fields' => array('kbdocument_body'), 'db' => 'mysql'),
//array('name' => 'kbcontentsftk', 'type' => 'fulltext', 'fields' => array('kbdocument_body'), 'db' => 'ibm_db2', 'options' => 'UPDATE FREQUENCY D(*) H(*) M(0, 5, 10, 15, 20, 25, 30, 35, 40, 45, 50, 55) UPDATE MINIMUM 1', 'message_locale' => 'en_US'), // Update the TS index every 5 minutes if only 1 record was updated
//array('name' => 'kbcontentsftk', 'type' => 'fulltext', 'fields' => array('kbdocument_body'), 'db' => 'oci8', 'indextype' => 'CTXSYS.CONTEXT', 'parameters' => 'sync (on commit)'),
//array('name' => 'kbcontentsftk', 'type' => 'fulltext', 'fields' => array('kbdocument_body'), 'db' => 'mssql', 'key_index' => 'fts_unique_idx', 'change_tracking' => 'AUTO', 'language' => 1033, 'catalog' => 'default'),
);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment