SQL

CREATE TABLE `branch`  (
  `id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  `repo_id` INTEGER NULL,
  `name` TEXT NOT NULL,
  `commit_id` TEXT NULL,
  `commit_message` TEXT NULL,
  `pusher_id` INTEGER NULL,
  `is_deleted` INTEGER NULL,
  `deleted_by_id` INTEGER NULL,
  `deleted_unix` INTEGER NULL,
  `commit_time` INTEGER NULL,
  `created_unix` INTEGER NULL,
  `updated_unix` INTEGER NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
repo_id INTEGER ✓ Rename | Drop
name TEXT Rename | Drop
commit_id TEXT ✓ Rename | Drop
commit_message TEXT ✓ Rename | Drop
pusher_id INTEGER ✓ Rename | Drop
is_deleted INTEGER ✓ Rename | Drop
deleted_by_id INTEGER ✓ Rename | Drop
deleted_unix INTEGER ✓ Rename | Drop
commit_time INTEGER ✓ Rename | Drop
created_unix INTEGER ✓ Rename | Drop
updated_unix INTEGER ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_branch_deleted_unix deleted_unix SQL 
CREATE INDEX `IDX_branch_deleted_unix`
ON `branch` (`deleted_unix`)
Drop
IDX_branch_is_deleted is_deleted SQL 
CREATE INDEX `IDX_branch_is_deleted`
ON `branch` (`is_deleted`)
Drop
UQE_branch_s
  • repo_id
  • name
 ✓ SQL 
CREATE UNIQUE INDEX `UQE_branch_s`
ON `branch` (`repo_id`,`name`)
Drop