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