This release introduce major changes in user group database structures and functions. The tables have been simplified as described in the picture below (see issue #763):
Database changes
This release includes major changes in the database. Databases from previous versions must be repaired once using "flyway repair". Please download flyway for command line and copy the src/main/resources/db to the root folder. Run the following command:
$ ./flyway repair -url=jdbc:sqlite:../data/db.sqlite -locations=filesystem:../db/sqlite,filesystem:../db/predefined
Some authorization scope are deprecated and must be removed from the oauth_access_scope tables:
delete from oauth2_access_scope where id="EDIT_VC";
delete from oauth2_access_scope where id="EDIT_USER_GROUP_MEMBER_ROLE";
What's changed
-
privilege and query_access tables have been removed.
-
user_group, user_group_member, and role tables have been modified.
-
Member invitation and subscription mechanisms have been removed.
-
Soft delete group and group members have been removed.
-
Authorization scope EDIT_VC has been removed and replaced with CREATE_VC.
-
User group services have been updated.
Deprecated services (will be removed completely in the upcoming API v1.1)
- member invitation
- add member roles
- subscribe to group
- unsubscribe from group
New services
- add admin role for a group-member
- delete vc access (roles) from user-group
- admin web service: retrieve hidden group
Other changes
- Introduce filter_by and deprecate authorized_only in OAuth2 client list (#579)
- Added not-timeExceeded to the totalResult constraints.
- Removed
registered_byand restrictregistration_dateproperties to admin/owner only. - Added config for total result cache
- Set default port to 8089
Bug Fix
- Removed admin & owner restriction on client info access.
- Disallow scope all for non super clients.
- Fixed administrative user group retrieval to return groups with empty members.
- Fixed total result cache key hashcode
Full Changelog: v0.74-release...v0.75-release