CREATE TABLE "user" ( "username" varchar(255) PRIMARY KEY ); CREATE TABLE "oauth_connection" ( "username" varchar(255) CONSTRAINT user_username REFERENCES user(username), "rank" int, "provider_id" int CONSTRAINT oauth_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) );