[Devel] Storage of XCAP profiles

[Adrian Georgescu]

Hi Daniel,

I took a look the current storage design needed for presence  
functionality. While trying to port my existing xcap data to the  
proposed table I run into the following problem.

Per user I already have to store several xcap documents:

presence_rules.xml
resource-list.xml
rls-services.xml

The current mysql schema

CREATE TABLE `xcap_xml` (
   `user` varchar(64) NOT NULL,
   `domain` varchar(128) NOT NULL,
   `xcap` text NOT NULL,
   PRIMARY KEY  (`user`,`domain`)
);

does not allow to store multiple documents, the only data I could  
store is the presence-rules document.

Can we change this to a format that can accomodate multiple xcap  
documents per user like:

CREATE TABLE `xcap_xml` (
   `username` varchar(64) NOT NULL,
   `domain` varchar(128) NOT NULL,
   `document` varachar(255) not NULL,
   `content` text NOT NULL,
   PRIMARY KEY  (`username`,`domain`)
);


Adrian




-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://openser.org/pipermail/devel/attachments/20061007/89ad5b6f/attachment.html