function fusion_apply_update_7001 in Fusion Accelerator 7.2

Reduces key length for indexes module and element. Increases length for unique key theme_module_element_skin, but remains under 333 byte utf8 maximum. See issue #1325542: Specified key was too long; max key length is 1000 bytes.

File

fusion_apply/fusion_apply.install, line 146

Contains install, update, and uninstall functions for Fusion Apply.

Code

function fusion_apply_update_7001() {
  db_drop_index('fusion_apply_skins', 'module');
  db_add_index('fusion_apply_skins', 'module', array(
    array(
      'theme',
      100,
    ),
    array(
      'module',
      100,
    ),
  ));
  db_drop_index('fusion_apply_skins', 'element');
  db_add_index('fusion_apply_skins', 'element', array(
    array(
      'theme',
      100,
    ),
    array(
      'module',
      100,
    ),
    array(
      'element',
      100,
    ),
  ));
  db_drop_unique_key('fusion_apply_skins', 'theme_module_element_skin');
  db_add_unique_key('fusion_apply_skins', 'theme_module_element_skin', array(
    array(
      'theme',
      50,
    ),
    array(
      'module',
      50,
    ),
    array(
      'element',
      100,
    ),
    array(
      'skin',
      100,
    ),
  ));
}