SQL

CREATE TABLE `notification`  (
  `id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  `user_id` INTEGER NOT NULL,
  `repo_id` INTEGER NOT NULL,
  `status` INTEGER NOT NULL,
  `source` INTEGER NOT NULL,
  `issue_id` INTEGER NOT NULL,
  `commit_id` TEXT NULL,
  `comment_id` INTEGER NULL,
  `updated_by` INTEGER NOT NULL,
  `created_unix` INTEGER NOT NULL,
  `updated_unix` INTEGER NOT NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
user_id INTEGER Rename | Drop
repo_id INTEGER Rename | Drop
status INTEGER Rename | Drop
source INTEGER Rename | Drop
issue_id INTEGER Rename | Drop
commit_id TEXT ✓ Rename | Drop
comment_id INTEGER ✓ Rename | Drop
updated_by INTEGER Rename | Drop
created_unix INTEGER Rename | Drop
updated_unix INTEGER Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_notification_commit_id commit_id SQL 
CREATE INDEX `IDX_notification_commit_id`
ON `notification` (`commit_id`)
Drop
IDX_notification_issue_id issue_id SQL 
CREATE INDEX `IDX_notification_issue_id`
ON `notification` (`issue_id`)
Drop
IDX_notification_repo_id repo_id SQL 
CREATE INDEX `IDX_notification_repo_id`
ON `notification` (`repo_id`)
Drop
IDX_notification_source source SQL 
CREATE INDEX `IDX_notification_source`
ON `notification` (`source`)
Drop
IDX_notification_status status SQL 
CREATE INDEX `IDX_notification_status`
ON `notification` (`status`)
Drop
IDX_notification_u_s_uu
  • user_id
  • status
  • updated_unix
 SQL 
CREATE INDEX `IDX_notification_u_s_uu`
ON `notification` (`user_id`,`status`,`updated_unix`)
Drop
IDX_notification_updated_by updated_by SQL 
CREATE INDEX `IDX_notification_updated_by`
ON `notification` (`updated_by`)
Drop
IDX_notification_user_id user_id SQL 
CREATE INDEX `IDX_notification_user_id`
ON `notification` (`user_id`)
Drop