SQL

CREATE TABLE `review_state`  (
  `id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  `user_id` INTEGER NOT NULL,
  `pull_id` INTEGER DEFAULT 0 NOT NULL,
  `commit_sha` TEXT NOT NULL,
  `updated_files` TEXT NOT NULL,
  `updated_unix` INTEGER NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
user_id INTEGER Rename | Drop
pull_id INTEGER Rename | Drop
commit_sha TEXT Rename | Drop
updated_files TEXT Rename | Drop
updated_unix INTEGER ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_review_state_pull_id pull_id SQL 
CREATE INDEX `IDX_review_state_pull_id`
ON `review_state` (`pull_id`)
Drop
UQE_review_state_pull_commit_user
  • user_id
  • pull_id
  • commit_sha
 ✓ SQL 
CREATE UNIQUE INDEX `UQE_review_state_pull_commit_user`
ON `review_state` (`user_id`,`pull_id`,`commit_sha`)
Drop