SQL

CREATE TABLE `issue_content_history`  (
  `id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  `poster_id` INTEGER NULL,
  `issue_id` INTEGER NULL,
  `comment_id` INTEGER NULL,
  `edited_unix` INTEGER NULL,
  `content_text` TEXT NULL,
  `is_first_created` INTEGER NULL,
  `is_deleted` INTEGER NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
poster_id INTEGER ✓ Rename | Drop
issue_id INTEGER ✓ Rename | Drop
comment_id INTEGER ✓ Rename | Drop
edited_unix INTEGER ✓ Rename | Drop
content_text TEXT ✓ Rename | Drop
is_first_created INTEGER ✓ Rename | Drop
is_deleted INTEGER ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_issue_content_history_comment_id comment_id SQL 
CREATE INDEX `IDX_issue_content_history_comment_id`
ON `issue_content_history` (`comment_id`)
Drop
IDX_issue_content_history_edited_unix edited_unix SQL 
CREATE INDEX `IDX_issue_content_history_edited_unix`
ON `issue_content_history` (`edited_unix`)
Drop
IDX_issue_content_history_issue_id issue_id SQL 
CREATE INDEX `IDX_issue_content_history_issue_id`
ON `issue_content_history` (`issue_id`)
Drop