SQL

CREATE TABLE `label`  (
  `id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  `repo_id` INTEGER NULL,
  `org_id` INTEGER NULL,
  `name` TEXT NULL,
  `exclusive` INTEGER NULL,
  `description` TEXT NULL,
  `color` TEXT NULL,
  `num_issues` INTEGER NULL,
  `num_closed_issues` INTEGER NULL,
  `created_unix` INTEGER NULL,
  `updated_unix` INTEGER NULL,
  `archived_unix` INTEGER DEFAULT NULL NULL,
  `exclusive_order` INTEGER DEFAULT 0 NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
repo_id INTEGER ✓ Rename | Drop
org_id INTEGER ✓ Rename | Drop
name TEXT ✓ Rename | Drop
exclusive INTEGER ✓ Rename | Drop
description TEXT ✓ Rename | Drop
color TEXT ✓ Rename | Drop
num_issues INTEGER ✓ Rename | Drop
num_closed_issues INTEGER ✓ Rename | Drop
created_unix INTEGER ✓ Rename | Drop
updated_unix INTEGER ✓ Rename | Drop
archived_unix INTEGER ✓ Rename | Drop
exclusive_order INTEGER ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_label_created_unix created_unix SQL 
CREATE INDEX `IDX_label_created_unix`
ON `label` (`created_unix`)
Drop
IDX_label_org_id org_id SQL 
CREATE INDEX `IDX_label_org_id`
ON `label` (`org_id`)
Drop
IDX_label_repo_id repo_id SQL 
CREATE INDEX `IDX_label_repo_id`
ON `label` (`repo_id`)
Drop
IDX_label_updated_unix updated_unix SQL 
CREATE INDEX `IDX_label_updated_unix`
ON `label` (`updated_unix`)
Drop