SQL

CREATE TABLE "issue"  (
  `id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  `repo_id` INTEGER NULL,
  `index` INTEGER NULL,
  `poster_id` INTEGER NULL,
  `original_author` TEXT NULL,
  `original_author_id` INTEGER NULL,
  `name` TEXT NULL,
  `content` TEXT NULL,
  `milestone_id` INTEGER NULL,
  `priority` INTEGER NULL,
  `is_closed` INTEGER NULL,
  `is_pull` INTEGER NULL,
  `num_comments` INTEGER NULL,
  `ref` TEXT NULL,
  `deadline_unix` INTEGER NULL,
  `created_unix` INTEGER NULL,
  `updated_unix` INTEGER NULL,
  `closed_unix` INTEGER NULL,
  `is_locked` INTEGER DEFAULT 0 NOT NULL,
  `content_version` INTEGER DEFAULT 0 NOT NULL,
  `time_estimate` INTEGER DEFAULT 0 NOT NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
repo_id INTEGER ✓ Rename | Drop
index INTEGER ✓ Rename | Drop
poster_id INTEGER ✓ Rename | Drop
original_author TEXT ✓ Rename | Drop
original_author_id INTEGER ✓ Rename | Drop
name TEXT ✓ Rename | Drop
content TEXT ✓ Rename | Drop
milestone_id INTEGER ✓ Rename | Drop
priority INTEGER ✓ Rename | Drop
is_closed INTEGER ✓ Rename | Drop
is_pull INTEGER ✓ Rename | Drop
num_comments INTEGER ✓ Rename | Drop
ref TEXT ✓ Rename | Drop
deadline_unix INTEGER ✓ Rename | Drop
created_unix INTEGER ✓ Rename | Drop
updated_unix INTEGER ✓ Rename | Drop
closed_unix INTEGER ✓ Rename | Drop
is_locked INTEGER Rename | Drop
content_version INTEGER Rename | Drop
time_estimate INTEGER Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_issue_closed_unix closed_unix SQL 
CREATE INDEX `IDX_issue_closed_unix`
ON `issue` (`closed_unix`)
Drop
IDX_issue_created_unix created_unix SQL 
CREATE INDEX `IDX_issue_created_unix`
ON `issue` (`created_unix`)
Drop
IDX_issue_deadline_unix deadline_unix SQL 
CREATE INDEX `IDX_issue_deadline_unix`
ON `issue` (`deadline_unix`)
Drop
IDX_issue_is_closed is_closed SQL 
CREATE INDEX `IDX_issue_is_closed`
ON `issue` (`is_closed`)
Drop
IDX_issue_is_pull is_pull SQL 
CREATE INDEX `IDX_issue_is_pull`
ON `issue` (`is_pull`)
Drop
IDX_issue_milestone_id milestone_id SQL 
CREATE INDEX `IDX_issue_milestone_id`
ON `issue` (`milestone_id`)
Drop
IDX_issue_original_author_id original_author_id SQL 
CREATE INDEX `IDX_issue_original_author_id`
ON `issue` (`original_author_id`)
Drop
IDX_issue_poster_id poster_id SQL 
CREATE INDEX `IDX_issue_poster_id`
ON `issue` (`poster_id`)
Drop
IDX_issue_repo_id repo_id SQL 
CREATE INDEX `IDX_issue_repo_id`
ON `issue` (`repo_id`)
Drop
IDX_issue_updated_unix updated_unix SQL 
CREATE INDEX `IDX_issue_updated_unix`
ON `issue` (`updated_unix`)
Drop
UQE_issue_repo_index
  • repo_id
  • index
 ✓ SQL 
CREATE UNIQUE INDEX `UQE_issue_repo_index`
ON `issue` (`repo_id`,`index`)
Drop