Source changesPOM
In the root pom.xml:
- change parent/version from 2.1.13 to 2.1.14
- change properties/syncope.version from 2.1.13 to 2.1.14
Internal Storage
New indexes shall be created to improve overall performance.
PostgreSQL
CREATE INDEX SyncopeUser_realm_id ON SyncopeUser(realm_id);
CREATE UNIQUE INDEX SyncopeUser_username ON SyncopeUser(username);
CREATE INDEX SyncopeUser_lower_username ON SyncopeUser(LOWER(username));
CREATE INDEX SyncopeGroup_realm_id ON SyncopeGroup(realm_id);
CREATE UNIQUE INDEX SyncopeGroup_name ON SyncopeGroup(name);
CREATE INDEX SyncopeGroup_lower_name ON SyncopeGroup(LOWER(name));
CREATE INDEX AnyObject_realm_id ON AnyObject(realm_id);
CREATE UNIQUE INDEX AnyObject_name ON AnyObject(name);
CREATE INDEX AnyObject_lower_name ON AnyObject(LOWER(name));
|
Oracle | MySQL | MariaDB
CREATE INDEX SyncopeUser_realm_id ON SyncopeUser(realm_id);
CREATE UNIQUE INDEX SyncopeUser_username ON SyncopeUser(username);
CREATE INDEX SyncopeGroup_realm_id ON SyncopeGroup(realm_id);
CREATE UNIQUE INDEXSyncopeGroup_name ON SyncopeGroup(name);
CREATE INDEX AnyObject_realm_id ON AnyObject(realm_id);
CREATE UNIQUE INDEX AnyObject_name ON AnyObject(name); |
