SQL

CREATE TABLE `review`  (
  `id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  `type` INTEGER NULL,
  `reviewer_id` INTEGER NULL,
  `reviewer_team_id` INTEGER DEFAULT 0 NOT NULL,
  `original_author` TEXT NULL,
  `original_author_id` INTEGER NULL,
  `issue_id` INTEGER NULL,
  `content` TEXT NULL,
  `official` INTEGER DEFAULT 0 NOT NULL,
  `commit_id` TEXT NULL,
  `stale` INTEGER DEFAULT 0 NOT NULL,
  `dismissed` INTEGER DEFAULT 0 NOT NULL,
  `created_unix` INTEGER NULL,
  `updated_unix` INTEGER NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
type INTEGER ✓ Rename | Drop
reviewer_id INTEGER ✓ Rename | Drop
reviewer_team_id INTEGER Rename | Drop
original_author TEXT ✓ Rename | Drop
original_author_id INTEGER ✓ Rename | Drop
issue_id INTEGER ✓ Rename | Drop
content TEXT ✓ Rename | Drop
official INTEGER Rename | Drop
commit_id TEXT ✓ Rename | Drop
stale INTEGER Rename | Drop
dismissed INTEGER Rename | Drop
created_unix INTEGER ✓ Rename | Drop
updated_unix INTEGER ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_review_created_unix created_unix SQL 
CREATE INDEX `IDX_review_created_unix`
ON `review` (`created_unix`)
Drop
IDX_review_issue_id issue_id SQL 
CREATE INDEX `IDX_review_issue_id`
ON `review` (`issue_id`)
Drop
IDX_review_reviewer_id reviewer_id SQL 
CREATE INDEX `IDX_review_reviewer_id`
ON `review` (`reviewer_id`)
Drop
IDX_review_updated_unix updated_unix SQL 
CREATE INDEX `IDX_review_updated_unix`
ON `review` (`updated_unix`)
Drop