Displaying 1 result from an estimated 1 matches for "idx_hostmap".
2010 Aug 04
1
IMAP/POP3 Proxy Redundancy
...MyISAM DEFAULT CHARSET=latin1
CREATE TABLE `hostmap` (
`id` int(11) NOT NULL auto_increment,
`filesystem` varchar(5) NOT NULL COMMENT 'Filesystem identifier',
`ip` int(10) unsigned NOT NULL,
`alive` tinyint(1) NOT NULL default '1',
PRIMARY KEY (`id`),
UNIQUE KEY `idx_hostmap` (`filesystem`,`ip`)
) ENGINE=MyISAM AUTO_INCREMENT=103 DEFAULT CHARSET=latin1
password_query = SELECT user,NULL as password, INET_NTOA(hostmap.ip) as
host, 'Y' AS proxy_maybe from users left join hostmap on
users.filesystem=hostmap.filesystem where hostmap.alive=1 and
users.user='...