[Devel] Presence: xcap_xml database table

Anca-Maria Vamanu anca at voice-system.ro
Mon Dec 18 10:35:09 CET 2006


Hi,

Thanks for reporting. It is now fixed.

Anca Vamanu


Mircea Amarascu wrote:

> Hello,
>
> In the last version of the Presence module, the xcap_xml table is
> defined like this:
>
> CREATE TABLE `xcap_xml` (
> `user` varchar(64) NOT NULL,
> `domain` varchar(128) NOT NULL,
> `xcap` text NOT NULL,
> `doc_type` int(11) NOT NULL,
> PRIMARY KEY (`user`,`domain`)
> ) ENGINE=MyISAM;
>
> where  doc_type can have one of the following values:
>
> 1 - presence_rules;
> 2 - resource-list;
> 3 - rls-services;
>
> So if I'd try to store both a presence-rules and a resource-lists
> documents for one user, a (MySQL) Duplicate entry error would be raised.
>
> The primary key should be extended to (`user`,`domain`, `doc_type`).
>
>
>
>
>
> _______________________________________________
> Devel mailing list
> Devel at openser.org
> http://openser.org/cgi-bin/mailman/listinfo/devel
>




More information about the Devel mailing list