[OpenSIPS-Devel] rls_presentity table can not be created in MySQL 4.1.22

[Andrew Pogrebennyk]

Thanks Anca,
That works.

Anca Vamanu wrote:
> Hi Andrew,
> 
> It seems that MySQL 1.4.22 does not accept a key component with length 
> greater than 255 unless it is clearly specified in the index definition (
> 
> CONSTRAINT rls_presentity_idx UNIQUE (rlsubs_did(512), resource_uri)).
> 
> While looking at this I saw that the current length for the rlsubs_did ( 
> 512) is in fact too big. It is constructed out of 3 strings that have a 
> maximum length of 64 separated by one character delimiter. Therefore, I 
> will change the length of the filed to 255 and so fix the problem with 
> MySQL 1.4.22.
> 
> Thanks and regards,
> Anca Vamanu

-- 
Sincerely,
Andrew Pogrebennyk