SQL

CREATE TABLE session  (
  id TEXT PRIMARY KEY,
  expiresAt INTEGER NOT NULL,
  token TEXT NOT NULL UNIQUE,
  createdAt INTEGER NOT NULL,
  updatedAt INTEGER NOT NULL,
  ipAddress TEXT,
  userAgent TEXT,
  userId TEXT 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
expiresAt INTEGER Rename | Drop
token TEXT Rename | Drop
createdAt INTEGER Rename | Drop
updatedAt INTEGER Rename | Drop
ipAddress TEXT ✓ Rename | Drop
userAgent TEXT ✓ Rename | Drop
userId TEXT Rename | Drop

Foreign Keys

Column Destination
userId user.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_auth_session_user userId SQL 
CREATE INDEX idx_auth_session_user
ON session(userId)
Drop
sqlite_autoindex_session_1 id ✓ SQL
-- no sql found --
 Drop
sqlite_autoindex_session_2 token ✓ SQL
-- no sql found --
 Drop