SQL

CREATE TABLE `comment`  (
  `id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  `type` INTEGER NULL,
  `poster_id` INTEGER NULL,
  `original_author` TEXT NULL,
  `original_author_id` INTEGER NULL,
  `issue_id` INTEGER NULL,
  `label_id` INTEGER NULL,
  `old_project_id` INTEGER NULL,
  `project_id` INTEGER NULL,
  `old_milestone_id` INTEGER NULL,
  `milestone_id` INTEGER NULL,
  `time_id` INTEGER NULL,
  `assignee_id` INTEGER NULL,
  `removed_assignee` INTEGER NULL,
  `assignee_team_id` INTEGER DEFAULT 0 NOT NULL,
  `resolve_doer_id` INTEGER NULL,
  `old_title` TEXT NULL,
  `new_title` TEXT NULL,
  `old_ref` TEXT NULL,
  `new_ref` TEXT NULL,
  `dependent_issue_id` INTEGER NULL,
  `commit_id` INTEGER NULL,
  `line` INTEGER NULL,
  `tree_path` TEXT NULL,
  `content` TEXT NULL,
  `patch` TEXT NULL,
  `created_unix` INTEGER NULL,
  `updated_unix` INTEGER NULL,
  `commit_sha` TEXT NULL,
  `review_id` INTEGER NULL,
  `invalidated` INTEGER NULL,
  `ref_repo_id` INTEGER NULL,
  `ref_issue_id` INTEGER NULL,
  `ref_comment_id` INTEGER NULL,
  `ref_action` INTEGER NULL,
  `ref_is_pull` INTEGER NULL,
  `content_version` INTEGER DEFAULT 0 NOT NULL,
  `comment_meta_data` TEXT NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
type INTEGER ✓ Rename | Drop
poster_id INTEGER ✓ Rename | Drop
original_author TEXT ✓ Rename | Drop
original_author_id INTEGER ✓ Rename | Drop
issue_id INTEGER ✓ Rename | Drop
label_id INTEGER ✓ Rename | Drop
old_project_id INTEGER ✓ Rename | Drop
project_id INTEGER ✓ Rename | Drop
old_milestone_id INTEGER ✓ Rename | Drop
milestone_id INTEGER ✓ Rename | Drop
time_id INTEGER ✓ Rename | Drop
assignee_id INTEGER ✓ Rename | Drop
removed_assignee INTEGER ✓ Rename | Drop
assignee_team_id INTEGER Rename | Drop
resolve_doer_id INTEGER ✓ Rename | Drop
old_title TEXT ✓ Rename | Drop
new_title TEXT ✓ Rename | Drop
old_ref TEXT ✓ Rename | Drop
new_ref TEXT ✓ Rename | Drop
dependent_issue_id INTEGER ✓ Rename | Drop
commit_id INTEGER ✓ Rename | Drop
line INTEGER ✓ Rename | Drop
tree_path TEXT ✓ Rename | Drop
content TEXT ✓ Rename | Drop
patch TEXT ✓ Rename | Drop
created_unix INTEGER ✓ Rename | Drop
updated_unix INTEGER ✓ Rename | Drop
commit_sha TEXT ✓ Rename | Drop
review_id INTEGER ✓ Rename | Drop
invalidated INTEGER ✓ Rename | Drop
ref_repo_id INTEGER ✓ Rename | Drop
ref_issue_id INTEGER ✓ Rename | Drop
ref_comment_id INTEGER ✓ Rename | Drop
ref_action INTEGER ✓ Rename | Drop
ref_is_pull INTEGER ✓ Rename | Drop
content_version INTEGER Rename | Drop
comment_meta_data TEXT ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_comment_created_unix created_unix SQL 
CREATE INDEX `IDX_comment_created_unix`
ON `comment` (`created_unix`)
Drop
IDX_comment_dependent_issue_id dependent_issue_id SQL 
CREATE INDEX `IDX_comment_dependent_issue_id`
ON `comment` (`dependent_issue_id`)
Drop
IDX_comment_issue_id issue_id SQL 
CREATE INDEX `IDX_comment_issue_id`
ON `comment` (`issue_id`)
Drop
IDX_comment_poster_id poster_id SQL 
CREATE INDEX `IDX_comment_poster_id`
ON `comment` (`poster_id`)
Drop
IDX_comment_ref_comment_id ref_comment_id SQL 
CREATE INDEX `IDX_comment_ref_comment_id`
ON `comment` (`ref_comment_id`)
Drop
IDX_comment_ref_issue_id ref_issue_id SQL 
CREATE INDEX `IDX_comment_ref_issue_id`
ON `comment` (`ref_issue_id`)
Drop
IDX_comment_ref_repo_id ref_repo_id SQL 
CREATE INDEX `IDX_comment_ref_repo_id`
ON `comment` (`ref_repo_id`)
Drop
IDX_comment_review_id review_id SQL 
CREATE INDEX `IDX_comment_review_id`
ON `comment` (`review_id`)
Drop
IDX_comment_type type SQL 
CREATE INDEX `IDX_comment_type`
ON `comment` (`type`)
Drop
IDX_comment_updated_unix updated_unix SQL 
CREATE INDEX `IDX_comment_updated_unix`
ON `comment` (`updated_unix`)
Drop