Repository navigation
Make the database scheme friendly for ndb (instead of innoDB only) #182
Description
Because of the combination of ON DELETE CASCADE and TEXT and BLOB fields in the default schema, simplesaml-module-oidc cannot be used on ndbcluster. This is easily fixed be converting some of the TEXT fields to varchar like i did in the attached schema.
Activity
pradtke commentedon May 20, 2022
Thanks @tommy2d For the user table did you also need to change type of
claims? I see you havemediumtextin your schema. Wastextnot supported?tommy2d commentedon May 31, 2022
I did not need to update claims, probably because it was not directly hit by the ON DELETE CASCADE. TEXT was too small so I used MEDIUMTEXT. This has to do with the profile picture that was there.