SQL

CREATE TABLE `oauth2_grant`  (
  `id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  `user_id` INTEGER NULL,
  `application_id` INTEGER NULL,
  `counter` INTEGER DEFAULT 1 NOT NULL,
  `scope` TEXT NULL,
  `nonce` 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
user_id INTEGER ✓ Rename | Drop
application_id INTEGER ✓ Rename | Drop
counter INTEGER Rename | Drop
scope TEXT ✓ Rename | Drop
nonce TEXT ✓ Rename | Drop
created_unix INTEGER ✓ Rename | Drop
updated_unix INTEGER ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_oauth2_grant_application_id application_id SQL 
CREATE INDEX `IDX_oauth2_grant_application_id`
ON `oauth2_grant` (`application_id`)
Drop
IDX_oauth2_grant_user_id user_id SQL 
CREATE INDEX `IDX_oauth2_grant_user_id`
ON `oauth2_grant` (`user_id`)
Drop
UQE_oauth2_grant_user_application
  • user_id
  • application_id
 ✓ SQL 
CREATE UNIQUE INDEX `UQE_oauth2_grant_user_application`
ON `oauth2_grant` (`user_id`,`application_id`)
Drop