SQL

CREATE TABLE `access_token`  (
  `id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  `uid` INTEGER NULL,
  `name` TEXT NULL,
  `token_hash` TEXT NULL,
  `token_salt` TEXT NULL,
  `token_last_eight` TEXT NULL,
  `scope` TEXT NULL,
  `created_unix` INTEGER NULL,
  `updated_unix` INTEGER NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
uid INTEGER ✓ Rename | Drop
name TEXT ✓ Rename | Drop
token_hash TEXT ✓ Rename | Drop
token_salt TEXT ✓ Rename | Drop
token_last_eight TEXT ✓ Rename | Drop
scope TEXT ✓ Rename | Drop
created_unix INTEGER ✓ Rename | Drop
updated_unix INTEGER ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_access_token_created_unix created_unix SQL 
CREATE INDEX `IDX_access_token_created_unix`
ON `access_token` (`created_unix`)
Drop
IDX_access_token_token_last_eight token_last_eight SQL 
CREATE INDEX `IDX_access_token_token_last_eight`
ON `access_token` (`token_last_eight`)
Drop
IDX_access_token_uid uid SQL 
CREATE INDEX `IDX_access_token_uid`
ON `access_token` (`uid`)
Drop
IDX_access_token_updated_unix updated_unix SQL 
CREATE INDEX `IDX_access_token_updated_unix`
ON `access_token` (`updated_unix`)
Drop
UQE_access_token_token_hash token_hash ✓ SQL 
CREATE UNIQUE INDEX `UQE_access_token_token_hash`
ON `access_token` (`token_hash`)
Drop