| 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 |
_______________________________________________ Devel mailing list [email protected] http://openser.org/cgi-bin/mailman/listinfo/devel
