← Back to branch summary

~intrahealth+informatics/i2ce/4.0-exp

« back to all changes in this revision

Viewing changes to modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php

  • Committer: carl
  • Date: 2009-12-23 01:53:10 UTC
  • Revision ID: litlfred@zatar-20091223015310-s5as2fxntzpekbmv
set default collation of cached forms to utf8_bin.. some of them were being set to utf8_genendal_xcdff  which was causing the indices not to be used in the joins

Show diffs side-by-side

added added

removed removed

Lines of Context:
modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php
496
496
                $createFields[] = 'INDEX (`' . $field . '`) ';
497
497
            }
498
498
        }
499
 
        $createQuery =  "CREATE TABLE  " . $this->table_name ." ( "  .  implode(',', $createFields) . ")  ENGINE=InnoDB DEFAULT CHARSET=utf8";        
 
499
        $createQuery =  "CREATE TABLE  " . $this->table_name ." ( "  .  implode(',', $createFields) . ")  ENGINE=InnoDB DEFAULT CHARSET=utf8  DEFAULT COLLATE=utf8_bin";        
500
500
        I2CE::raiseError("Creating table for {$this->form} as:\n$createQuery");
501
501
        $db =  MDB2::singleton();
502
502
        $result =$db->query($createQuery);