SQL

CREATE TABLE `webhook`  (
  `id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  `repo_id` INTEGER NULL,
  `owner_id` INTEGER NULL,
  `is_system_webhook` INTEGER NULL,
  `url` TEXT NULL,
  `http_method` TEXT NULL,
  `content_type` INTEGER NULL,
  `secret` TEXT NULL,
  `events` TEXT NULL,
  `is_active` INTEGER NULL,
  `type` TEXT NULL,
  `meta` TEXT NULL,
  `last_status` INTEGER NULL,
  `header_authorization_encrypted` 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
repo_id INTEGER ✓ Rename | Drop
owner_id INTEGER ✓ Rename | Drop
is_system_webhook INTEGER ✓ Rename | Drop
url TEXT ✓ Rename | Drop
http_method TEXT ✓ Rename | Drop
content_type INTEGER ✓ Rename | Drop
secret TEXT ✓ Rename | Drop
events TEXT ✓ Rename | Drop
is_active INTEGER ✓ Rename | Drop
type TEXT ✓ Rename | Drop
meta TEXT ✓ Rename | Drop
last_status INTEGER ✓ Rename | Drop
header_authorization_encrypted TEXT ✓ Rename | Drop
created_unix INTEGER ✓ Rename | Drop
updated_unix INTEGER ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_webhook_created_unix created_unix SQL 
CREATE INDEX `IDX_webhook_created_unix`
ON `webhook` (`created_unix`)
Drop
IDX_webhook_is_active is_active SQL 
CREATE INDEX `IDX_webhook_is_active`
ON `webhook` (`is_active`)
Drop
IDX_webhook_owner_id owner_id SQL 
CREATE INDEX `IDX_webhook_owner_id`
ON `webhook` (`owner_id`)
Drop
IDX_webhook_repo_id repo_id SQL 
CREATE INDEX `IDX_webhook_repo_id`
ON `webhook` (`repo_id`)
Drop
IDX_webhook_updated_unix updated_unix SQL 
CREATE INDEX `IDX_webhook_updated_unix`
ON `webhook` (`updated_unix`)
Drop