[Devel] SF.net SVN: openser: [2318] trunk/db/schema

[Henning Westerholt]

Revision: 2318
          http://openser.svn.sourceforge.net/openser/?rev=2318&view=rev
Author:   henningw
Date:     2007-05-30 05:14:08 -0700 (Wed, 30 May 2007)

Log Message:
-----------
- update xml database table sources
- use SERIAL PRIMARY KEY for postgresql unique ids
- use binary for xcap_xml and presentity body column
- move primary key definition for mysql to column definition
- update template
- add some missing index names, fix misspellings and double names for indexes

Modified Paths:
--------------
    trunk/db/schema/acc.xml
    trunk/db/schema/address.xml
    trunk/db/schema/aliases.xml
    trunk/db/schema/cpl.xml
    trunk/db/schema/dbaliases.xml
    trunk/db/schema/domain.xml
    trunk/db/schema/domainpolicy.xml
    trunk/db/schema/entities.xml
    trunk/db/schema/grp.xml
    trunk/db/schema/gw.xml
    trunk/db/schema/gw_grp.xml
    trunk/db/schema/imc_members.xml
    trunk/db/schema/imc_rooms.xml
    trunk/db/schema/lcr.xml
    trunk/db/schema/location.xml
    trunk/db/schema/missed_calls.xml
    trunk/db/schema/pdt.xml
    trunk/db/schema/pr_active_watchers.xml
    trunk/db/schema/pr_presentity.xml
    trunk/db/schema/pr_pua.xml
    trunk/db/schema/pr_watchers.xml
    trunk/db/schema/pr_xcap_xml.xml
    trunk/db/schema/re_grp.xml
    trunk/db/schema/silo.xml
    trunk/db/schema/sip_trace.xml
    trunk/db/schema/speed_dial.xml
    trunk/db/schema/subscriber.xml
    trunk/db/schema/sw_active_sessions.xml
    trunk/db/schema/sw_pending.xml
    trunk/db/schema/sw_phonebook.xml
    trunk/db/schema/sw_server_monitoring_agg.xml
    trunk/db/schema/sw_usr_preferences_type.xml
    trunk/db/schema/template.xml
    trunk/db/schema/trusted.xml
    trunk/db/schema/uri.xml
    trunk/db/schema/usr_preferences.xml


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.