[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