ROLE column - Wrong Type Used

[app-generator]

Hello @FullStackkDev

The Role column should use integer type for values.

Impacted tables:

USER: user_role -> integer, default value 2 (user type)

CREATE TABLE "user" ("id" varchar PRIMARY KEY NOT NULL, "username" text NOT NULL, "email" text, "password" text, "user_role" varchar, "date" datetime NOT NULL DEFAULT (CURRENT_TIMESTAMP))

ROLE: ID column -> integer (now is varchar)

"role" ("id" varchar PRIMARY KEY NOT NULL, "name" text NOT NULL, "date" datetime NOT NULL DEFAULT (CURRENT_TIMESTAMP))

Please take a look. Ty!