function event_update_6 in Event 5.2

Add keys

File

./event.install, line 299

Code

function event_update_6() {
  $ret = array();
  switch ($GLOBALS['db_type']) {
    case 'pgsql':
      $ret[] = update_sql('CREATE INDEX {event}_event_start_idx ON {event} (event_start)');
      $ret[] = update_sql('CREATE INDEX {event}_event_end_idx ON {event} (event_end)');
      break;
    case 'mysql':
    case 'mysqli':
      $ret[] = update_sql("ALTER TABLE {event} ADD KEY event_start (event_start)");
      $ret[] = update_sql("ALTER TABLE {event} ADD KEY event_end (event_end)");
      break;
  }
  return $ret;
}