Query

auth.db — sessions

SQL

CREATE TABLE `sessions`  (
  `session_id_hash` text PRIMARY KEY NOT NULL,
  `user_id` integer NOT NULL,
  `created_at` text NOT NULL,
  `last_seen_at` text NOT NULL,
  `expires_at` text NOT NULL,
  `ip_address` text,
  `user_agent` text,
  FOREIGN KEY (`user_id`) REFERENCES `users`(`id`) ON UPDATE no action ON DELETE cascade
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
session_id_hash TEXT ✓ Rename | Drop
user_id INTEGER Rename | Drop
created_at TEXT Rename | Drop
last_seen_at TEXT Rename | Drop
expires_at TEXT Rename | Drop
ip_address TEXT ✓ Rename | Drop
user_agent TEXT ✓ Rename | Drop

Foreign Keys

Column Destination
user_id users.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_sessions_expires_at expires_at SQL 
CREATE INDEX `idx_sessions_expires_at`
ON `sessions` (`expires_at`)
Drop
idx_sessions_user_id user_id SQL 
CREATE INDEX `idx_sessions_user_id`
ON `sessions` (`user_id`)
Drop
sqlite_autoindex_sessions_1 session_id_hash ✓ SQL
-- no sql found --
 Drop