title: Error: Specified key was too long; max key length is 1000 bytes
body: <p>Error:</p>
  
  <blockquote>
    <p>1071 - Specified key was too long; max key length is 1000 bytes </p>
  </blockquote>
  
  <pre><code>CREATE TABLE `phppos_modules_actions` (
    `action_id` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,
    `module_id` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,
    `action_name_key` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,
    `sort` INT NOT NULL ,
    PRIMARY KEY ( `action_id` , `module_id` )
  ) ENGINE = INNODB CHARACTER SET utf8 COLLATE utf8_unicode_ci;
  </code></pre>
  
  <p>I know the error occurs because of 255x2x3 (3 bytes per character)</p>
  
  <p>This doesn't happen on all installations. What setting can I change?</p>