SQL

CREATE TABLE `reaction`  (
  `id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  `type` TEXT NOT NULL,
  `issue_id` INTEGER NOT NULL,
  `comment_id` INTEGER NULL,
  `user_id` INTEGER NOT NULL,
  `original_author_id` INTEGER DEFAULT 0 NOT NULL,
  `original_author` TEXT NULL,
  `created_unix` INTEGER NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
type TEXT Rename | Drop
issue_id INTEGER Rename | Drop
comment_id INTEGER ✓ Rename | Drop
user_id INTEGER Rename | Drop
original_author_id INTEGER Rename | Drop
original_author TEXT ✓ Rename | Drop
created_unix INTEGER ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_reaction_comment_id comment_id SQL 
CREATE INDEX `IDX_reaction_comment_id`
ON `reaction` (`comment_id`)
Drop
IDX_reaction_created_unix created_unix SQL 
CREATE INDEX `IDX_reaction_created_unix`
ON `reaction` (`created_unix`)
Drop
IDX_reaction_issue_id issue_id SQL 
CREATE INDEX `IDX_reaction_issue_id`
ON `reaction` (`issue_id`)
Drop
IDX_reaction_original_author original_author SQL 
CREATE INDEX `IDX_reaction_original_author`
ON `reaction` (`original_author`)
Drop
IDX_reaction_original_author_id original_author_id SQL 
CREATE INDEX `IDX_reaction_original_author_id`
ON `reaction` (`original_author_id`)
Drop
IDX_reaction_type type SQL 
CREATE INDEX `IDX_reaction_type`
ON `reaction` (`type`)
Drop
IDX_reaction_user_id user_id SQL 
CREATE INDEX `IDX_reaction_user_id`
ON `reaction` (`user_id`)
Drop
UQE_reaction_s
  • type
  • issue_id
  • comment_id
  • user_id
  • original_author_id
  • original_author
 ✓ SQL 
CREATE UNIQUE INDEX `UQE_reaction_s`
ON `reaction` (`type`,`issue_id`,`comment_id`,`user_id`,`original_author_id`,`original_author`)
Drop