SQL

CREATE TABLE `release`  (
  `id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  `repo_id` INTEGER NULL,
  `publisher_id` INTEGER NULL,
  `tag_name` TEXT NULL,
  `original_author` TEXT NULL,
  `original_author_id` INTEGER NULL,
  `lower_tag_name` TEXT NULL,
  `target` TEXT NULL,
  `title` TEXT NULL,
  `sha1` TEXT NULL,
  `num_commits` INTEGER NULL,
  `note` TEXT NULL,
  `is_draft` INTEGER DEFAULT 0 NOT NULL,
  `is_prerelease` INTEGER DEFAULT 0 NOT NULL,
  `is_tag` INTEGER DEFAULT 0 NOT NULL,
  `created_unix` INTEGER NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
repo_id INTEGER ✓ Rename | Drop
publisher_id INTEGER ✓ Rename | Drop
tag_name TEXT ✓ Rename | Drop
original_author TEXT ✓ Rename | Drop
original_author_id INTEGER ✓ Rename | Drop
lower_tag_name TEXT ✓ Rename | Drop
target TEXT ✓ Rename | Drop
title TEXT ✓ Rename | Drop
sha1 TEXT ✓ Rename | Drop
num_commits INTEGER ✓ Rename | Drop
note TEXT ✓ Rename | Drop
is_draft INTEGER Rename | Drop
is_prerelease INTEGER Rename | Drop
is_tag INTEGER Rename | Drop
created_unix INTEGER ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_release_created_unix created_unix SQL 
CREATE INDEX `IDX_release_created_unix`
ON `release` (`created_unix`)
Drop
IDX_release_original_author_id original_author_id SQL 
CREATE INDEX `IDX_release_original_author_id`
ON `release` (`original_author_id`)
Drop
IDX_release_publisher_id publisher_id SQL 
CREATE INDEX `IDX_release_publisher_id`
ON `release` (`publisher_id`)
Drop
IDX_release_repo_id repo_id SQL 
CREATE INDEX `IDX_release_repo_id`
ON `release` (`repo_id`)
Drop
IDX_release_sha1 sha1 SQL 
CREATE INDEX `IDX_release_sha1`
ON `release` (`sha1`)
Drop
IDX_release_tag_name tag_name SQL 
CREATE INDEX `IDX_release_tag_name`
ON `release` (`tag_name`)
Drop
UQE_release_n
  • repo_id
  • tag_name
 ✓ SQL 
CREATE UNIQUE INDEX `UQE_release_n`
ON `release` (`repo_id`,`tag_name`)
Drop