SQL

CREATE TABLE `auth_token`  (
  `id` TEXT PRIMARY KEY NOT NULL,
  `token_hash` TEXT NULL,
  `user_id` INTEGER NULL,
  `expires_unix` INTEGER NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id TEXT ✓ Rename | Drop
token_hash TEXT ✓ Rename | Drop
user_id INTEGER ✓ Rename | Drop
expires_unix INTEGER ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_auth_token_expires_unix expires_unix SQL 
CREATE INDEX `IDX_auth_token_expires_unix`
ON `auth_token` (`expires_unix`)
Drop
IDX_auth_token_user_id user_id SQL 
CREATE INDEX `IDX_auth_token_user_id`
ON `auth_token` (`user_id`)
Drop
sqlite_autoindex_auth_token_1 id ✓ SQL
-- no sql found --
 Drop