We're updating the issue view to help you get more done. 

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

Acceptance Test - Entry

None

Assignee

MattM

Reporter

Gaston Dombiak

Labels

None

Expected Effort

None

Ignite Forum URL

None

Components

Fix versions

Affects versions

Priority

Major
Configure