create table account with id, user_id (foreign key to user.id), type, provider, provider_account_id, refresh_token, access_token, expires_at (int), token_type, scope, id_token, session_state
CREATE TABLE account (
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
user_id INT NOT NULL,
FOREIGN KEY (user_id) REFERENCES user(id),
type VARCHAR(255) NOT NULL,
provider VARCHAR(255) NOT NULL,
provider_account_id VARCHAR(255) NOT NULL,
refresh_token TEXT,
access_token TEXT,
expires_at INT,
token_type VARCHAR(255),
scope VARCHAR(255),
id_token TEXT,
session_state TEXT
);
- Public
- ·
- Tue, 03 Jan 2023 11:23:48 GMT