Make the database scheme friendly for ndb (instead of innoDB only)

[tommy2d]

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.

oidc_patched_ndb-sql.txt

[pradtke]

Thanks @tommy2d For the user table did you also need to change type of claims ? I see you have mediumtext in your schema. Was text not supported?

[tommy2d]

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.