SQL

CREATE TABLE account  (
  id TEXT PRIMARY KEY,
  accountId TEXT NOT NULL,
  providerId TEXT NOT NULL,
  userId TEXT NOT NULL,
  accessToken TEXT,
  refreshToken TEXT,
  idToken TEXT,
  accessTokenExpiresAt INTEGER,
  refreshTokenExpiresAt INTEGER,
  scope TEXT,
  password TEXT,
  createdAt INTEGER NOT NULL,
  updatedAt INTEGER NOT NULL,
  FOREIGN KEY (userId) REFERENCES user(id) ON DELETE CASCADE
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id TEXT ✓ ✓ Rename | Drop
accountId TEXT Rename | Drop
providerId TEXT Rename | Drop
userId TEXT Rename | Drop
accessToken TEXT ✓ Rename | Drop
refreshToken TEXT ✓ Rename | Drop
idToken TEXT ✓ Rename | Drop
accessTokenExpiresAt INTEGER ✓ Rename | Drop
refreshTokenExpiresAt INTEGER ✓ Rename | Drop
scope TEXT ✓ Rename | Drop
password TEXT ✓ Rename | Drop
createdAt INTEGER Rename | Drop
updatedAt INTEGER Rename | Drop

Foreign Keys

Column Destination
userId user.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_account_provider_account
  • providerId
  • accountId
 ✓ SQL 
CREATE UNIQUE INDEX idx_account_provider_account
ON account(providerId, accountId)
Drop
idx_account_user userId SQL 
CREATE INDEX idx_account_user
ON account(userId)
Drop
sqlite_autoindex_account_1 id ✓ SQL
-- no sql found --
 Drop