SQLAI.ai

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