[Devel] Presence: xcap_xml database table

Mircea Amarascu mircea at ag-projects.com
Mon Dec 18 11:44:50 CET 2006


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`).







More information about the Devel mailing list