[Users] Presence server with MySQL >=5.0.26

[Nicolas Palix]

Hi,


The primary key of the watchers is too long with this version of MySQL:
"Specified key was too long; max key length is 1000 bytes"

Downgrading "[pw]_domain" from 128 to 96. Works.

CREATE TABLE `watchers` (
 `p_user` varchar(64) NOT NULL,
 `p_domain` varchar(96) NOT NULL,
 `w_user` varchar(64) NOT NULL,
 `w_domain` varchar(96) NOT NULL,
 `subs_status` varchar(64) NOT NULL,
 `reason` varchar(64) NOT NULL,
  PRIMARY KEY  (`p_user`,`p_domain`,`w_user`,`w_domain`)
) ENGINE=MyISAM;

Regards
-- 
Nicolas Palix
http://phoenix.labri.fr/people/palix/