Modify pubsub tables so that all supported databases may correctly run the database scripts

Description

The pubsubNode table is holding some n relationships by encoding strings in big fields. This is generating some problems in old versions of MySQL or hitting some limits of SqlServer. We can move the n relationships (e.g. contacts, roster groups, reply rooms, etc.) to a new table thus reducing the size of pubsubNode. Also make sure that primary keys and indexes are not reaching any db limit.

Environment

None

Activity

Show:
Fixed

Details

Assignee

Reporter

Components

Fix versions

Affects versions

Priority

Created April 13, 2006 at 5:59 AM
Updated April 13, 2006 at 6:55 AM
Resolved April 13, 2006 at 6:55 AM