...
- change parent/version from 3.0.3 to 3.0.4
- change properties/syncope.version from 3.0.3 to 3.0.4
Internal Storage
Index update
First remove the index with
Code Block |
---|
|
DROP INDEX AnyObject_name; |
or (if on MySQL / MariaDB)
Code Block |
---|
|
ALTER TABLE AnyObject DROP INDEX AnyObject_name; |
then create the new index with
Code Block |
---|
|
CREATE UNIQUE INDEX AnyObject_name ON AnyObject(type_id,name); |
Table rename
Code Block |
---|
|
ALTER TABLE TicketExpiration RENAME TO TicketExpirationPolicy; |
or (if on Oracle)
Code Block |
---|
|
ALTER TABLE [SCHEMA_NAME.]TICKETEXPIRATION rename to TICKETEXPIRATIONPOLICY |