[SR-Users] [LCR] Why 'gw_name' column is an UNIQUE index in 'gw' table?

Juha Heinanen jh at tutpro.com
Sat May 8 21:10:29 CEST 2010


Iñaki Baz Castillo writes:

 > Why is it an UNIQUE key? It makes things complex when I want to create
 > another gateway with same IP and port (but belonging to a different
 > grp_id). I still want to name it with the same name (an internal
 > domain for example).

which version? in 3.0:

  UNIQUE KEY `lcr_id_grp_id_gw_name_idx` (`lcr_id`,`grp_id`,`gw_name`),
  UNIQUE KEY `lcr_id_grp_id_ip_addr_hostname_idx`
  (`lcr_id`,`grp_id`,`ip_addr`,`hostname`)

-- juha



More information about the sr-users mailing list