SQL

CREATE TABLE `action_schedule_spec`  (
  `id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  `repo_id` INTEGER NULL,
  `schedule_id` INTEGER NULL,
  `next` INTEGER NULL,
  `prev` INTEGER NULL,
  `spec` TEXT NULL,
  `created` INTEGER NULL,
  `updated` INTEGER NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
repo_id INTEGER ✓ Rename | Drop
schedule_id INTEGER ✓ Rename | Drop
next INTEGER ✓ Rename | Drop
prev INTEGER ✓ Rename | Drop
spec TEXT ✓ Rename | Drop
created INTEGER ✓ Rename | Drop
updated INTEGER ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_action_schedule_spec_next next SQL 
CREATE INDEX `IDX_action_schedule_spec_next`
ON `action_schedule_spec` (`next`)
Drop
IDX_action_schedule_spec_repo_id repo_id SQL 
CREATE INDEX `IDX_action_schedule_spec_repo_id`
ON `action_schedule_spec` (`repo_id`)
Drop
IDX_action_schedule_spec_schedule_id schedule_id SQL 
CREATE INDEX `IDX_action_schedule_spec_schedule_id`
ON `action_schedule_spec` (`schedule_id`)
Drop