[CONF] Apache Syncope > Upgrade from 3.0.3 to 3.0.4

Title: Message Title

There's 1 new edit on this page

Francesco Chicchiriccò edited this page

Here's what changed:

...

Internal Storage

First remove the index with

Code Block

language

sql

DROP INDEX AnyObject_name;

or (if on MySQL / MariaDB)

Code Block

language

sql

ALTER TABLE AnyObject DROP INDEX AnyObject_name;

then create the new index with

Code Block

language

sql

CREATE UNIQUE INDEX AnyObject_name ON AnyObject(type_id,name);