Versions Compared

Old Version 1

changes.mady.by.user Francesco Chicchiriccò

Saved on

compared with

New Version 2

changes.mady.by.user Francesco Chicchiriccò

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • 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);