SQL

CREATE TABLE `hook_task`  (
  `id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  `hook_id` INTEGER NULL,
  `uuid` TEXT NULL,
  `payload_content` TEXT NULL,
  `payload_version` INTEGER DEFAULT 1 NULL,
  `event_type` TEXT NULL,
  `is_delivered` INTEGER NULL,
  `delivered` INTEGER NULL,
  `is_succeed` INTEGER NULL,
  `request_content` TEXT NULL,
  `response_content` TEXT NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
hook_id INTEGER ✓ Rename | Drop
uuid TEXT ✓ Rename | Drop
payload_content TEXT ✓ Rename | Drop
payload_version INTEGER ✓ Rename | Drop
event_type TEXT ✓ Rename | Drop
is_delivered INTEGER ✓ Rename | Drop
delivered INTEGER ✓ Rename | Drop
is_succeed INTEGER ✓ Rename | Drop
request_content TEXT ✓ Rename | Drop
response_content TEXT ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_hook_task_hook_id hook_id SQL 
CREATE INDEX `IDX_hook_task_hook_id`
ON `hook_task` (`hook_id`)
Drop
UQE_hook_task_uuid uuid ✓ SQL 
CREATE UNIQUE INDEX `UQE_hook_task_uuid`
ON `hook_task` (`uuid`)
Drop