CREATE TABLE "user" ( "username" varchar(255) PRIMARY KEY ); CREATE TABLE "oauth_connection" ( "username" varchar(255) FOREIGN KEY("username") REFERENCES "user" ("username"), "rank" int, "provider_id" int FOREIGN KEY("provider_id") REFERENCES "oauth_provider" ("id"), "provider_user_id" varchar(255), "display_name" varchar(255), "access_token" varchar(255), "expires_at" datetime ); CREATE TABLE "oauth_provider" ( "id" int PRIMARY KEY, "name" varchar(255) );