[Users] Presence server with MySQL >=5.0.26

Bogdan-Andrei Iancu bogdan at voice-system.ro
Thu Nov 16 13:05:48 CET 2006


Hi Nicolas,

I think the solution will be to have a primary key a simple unsigned int 
outincrement field in the table and move the primary key as unique.

I will ask Anca to do this change as most probably it will be a good 
idea to do it for the rest of the tables also.

regards,
Bogdan

Nicolas Palix wrote:

>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
>  
>





More information about the Users mailing list