Open
Description
The user database schema changed for the new databus multi-account feature.
The current user database contains the tables:
USER (sub [PK], accountName, email)
APIKEYS (keyname, sub [FK], key)
This needs to be migrated to three tables:
USER (sub [PK])
ACCOUNTS (accountName [PK], sub [FK], )
APIKEYS (keyname, accountName [FK], key)
I.e. each user in the old USER table gets an entry in new USER and ACCOUNT table. APIKEYS are then set with accountName as foreign key instead of sub.
The gstore (git and virtuoso) can be kept as is.
Metadata
Metadata
Assignees
Labels
No labels