Skip to content

Migrate Databus to Multi-Account State #195

Open
@holycrab13

Description

@holycrab13

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

Labels

No labels
No labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions