[OpenSER-Devel] SF.net SVN: openser: [2485] trunk

[Juha Heinanen]

Anca Vamanu writes:

 > - added some KEYs to presence tables to improve db query performance
 > - (table version increased)

i have question regarding the new presentity index.  there is now

   <index>
        <name>udee_presentity</name>
        <colref linkend="username"/>
        <colref linkend="domain"/>
        <colref linkend="event"/>
        <colref linkend="etag"/>
        <unique/>
        </index>
        <index>
        <name>ude_presentity</name>
        <colref linkend="username"/>
        <colref linkend="domain"/>
        <colref linkend="event"/>
        <unique/>
    </index>

why is the second index needed, because my understanding is that at
least in mysql the second index is already included in the first?

- juha