SQL

CREATE TABLE `tracked_time`  (
  `id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  `issue_id` INTEGER NULL,
  `user_id` INTEGER NULL,
  `created_unix` INTEGER NULL,
  `time` INTEGER NOT NULL,
  `deleted` INTEGER DEFAULT 0 NOT NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
issue_id INTEGER ✓ Rename | Drop
user_id INTEGER ✓ Rename | Drop
created_unix INTEGER ✓ Rename | Drop
time INTEGER Rename | Drop
deleted INTEGER Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_tracked_time_issue_id issue_id SQL 
CREATE INDEX `IDX_tracked_time_issue_id`
ON `tracked_time` (`issue_id`)
Drop
IDX_tracked_time_user_id user_id SQL 
CREATE INDEX `IDX_tracked_time_user_id`
ON `tracked_time` (`user_id`)
Drop