SQL

CREATE TABLE `oauth2_application`  (
  `id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  `uid` INTEGER NULL,
  `name` TEXT NULL,
  `client_id` TEXT NULL,
  `client_secret` TEXT NULL,
  `confidential_client` INTEGER DEFAULT TRUE NOT NULL,
  `redirect_uris` TEXT NULL,
  `created_unix` INTEGER NULL,
  `updated_unix` INTEGER NULL,
  `skip_secondary_authorization` INTEGER DEFAULT FALSE NOT NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
uid INTEGER ✓ Rename | Drop
name TEXT ✓ Rename | Drop
client_id TEXT ✓ Rename | Drop
client_secret TEXT ✓ Rename | Drop
confidential_client INTEGER Rename | Drop
redirect_uris TEXT ✓ Rename | Drop
created_unix INTEGER ✓ Rename | Drop
updated_unix INTEGER ✓ Rename | Drop
skip_secondary_authorization INTEGER Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_oauth2_application_created_unix created_unix SQL 
CREATE INDEX `IDX_oauth2_application_created_unix`
ON `oauth2_application` (`created_unix`)
Drop
IDX_oauth2_application_uid uid SQL 
CREATE INDEX `IDX_oauth2_application_uid`
ON `oauth2_application` (`uid`)
Drop
IDX_oauth2_application_updated_unix updated_unix SQL 
CREATE INDEX `IDX_oauth2_application_updated_unix`
ON `oauth2_application` (`updated_unix`)
Drop
UQE_oauth2_application_client_id client_id ✓ SQL 
CREATE UNIQUE INDEX `UQE_oauth2_application_client_id`
ON `oauth2_application` (`client_id`)
Drop