[Serusers] LCR question

[Juha Heinanen]

Bjorn Asmul writes:

 > What indexes would you recommend on the LCR table?

the ones that are automatically installed:

CREATE TABLE lcr (
  prefix varchar(16) NOT NULL,
  from_uri varchar(128) NOT NULL DEFAULT '%',
  grp_id INT UNSIGNED NOT NULL,
  priority TINYINT UNSIGNED NOT NULL,
  KEY Key1 (prefix),
  KEY Key2 (from_uri),
  KEY Key3 (grp_id)
) $TABLE_TYPE;

-- juha