RBAC : user_id as VARCHAR ?

Yii 2.0 General Discussions
1

Hi,

I’m trying to activate RBAC component in Yii2 advanced template.

In advanced template, there is a user table where "id" is INT(11).

RBAC component create an auth_assignment table with "user_id" as VARCHAR(64).

Why this difference ?

I would like to add a foreign key between the two tables, but I can’t due to this type mismatch.

Any advice ? Can I change VARCHAR(64) for INT(11) without drawbacks ?

Best regards.

2

yes u have to modify by int. u must have to keep same datatype.

ref link