SQL

CREATE TABLE `oauth2_authorization_code`  (
  `id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  `grant_id` INTEGER NULL,
  `code` TEXT NULL,
  `code_challenge` TEXT NULL,
  `code_challenge_method` TEXT NULL,
  `redirect_uri` TEXT NULL,
  `valid_until` INTEGER NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
grant_id INTEGER ✓ Rename | Drop
code TEXT ✓ Rename | Drop
code_challenge TEXT ✓ Rename | Drop
code_challenge_method TEXT ✓ Rename | Drop
redirect_uri TEXT ✓ Rename | Drop
valid_until INTEGER ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_oauth2_authorization_code_valid_until valid_until SQL 
CREATE INDEX `IDX_oauth2_authorization_code_valid_until`
ON `oauth2_authorization_code` (`valid_until`)
Drop
UQE_oauth2_authorization_code_code code ✓ SQL 
CREATE UNIQUE INDEX `UQE_oauth2_authorization_code_code`
ON `oauth2_authorization_code` (`code`)
Drop