I did this, it seems to work:
alter table RESOURCE_SERVER_RESOURCE modify ID varchar(255);
alter table RESOURCE_POLICY modify RESOURCE_ID varchar(255);
alter table RESOURCE_POLICY modify RESOURCE_ID varchar(255);
alter table RESOURCE_ATTRIBUTE modify RESOURCE_ID varchar(255);
alter table RESOURCE_SCOPE modify RESOURCE_ID varchar(255);
alter table RESOURCE_SERVER_PERM_TICKET modify RESOURCE_ID varchar(255);
On Mon, Nov 4, 2019 at 12:11 AM Corentin Dupont <corentin.dupont(a)gmail.com>
wrote:
Hi guys,
I'm creating keycloak protection resources by providing my own ID, in
order to map my resources easily with my own database. The naming schema
is: <prefix>-<DB_ID>
However, I get some errors: Data truncation: Data too long for column 'ID'
at row 1
The DB_ID can be long, we didn't think to limit it. If I understand,
Keycloak IDs are limited to 36 characters or something like that? How to
relax this constraint?
Thanks
Corentin