SQL

CREATE TABLE `attachment`  (
  `id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  `uuid` UUID NULL,
  `repo_id` INTEGER NULL,
  `issue_id` INTEGER NULL,
  `release_id` INTEGER NULL,
  `uploader_id` INTEGER DEFAULT 0 NULL,
  `comment_id` INTEGER NULL,
  `name` TEXT NULL,
  `download_count` INTEGER DEFAULT 0 NULL,
  `size` INTEGER DEFAULT 0 NULL,
  `created_unix` INTEGER NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
uuid UUID ✓ Rename | Drop
repo_id INTEGER ✓ Rename | Drop
issue_id INTEGER ✓ Rename | Drop
release_id INTEGER ✓ Rename | Drop
uploader_id INTEGER ✓ Rename | Drop
comment_id INTEGER ✓ Rename | Drop
name TEXT ✓ Rename | Drop
download_count INTEGER ✓ Rename | Drop
size INTEGER ✓ Rename | Drop
created_unix INTEGER ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_attachment_comment_id comment_id SQL 
CREATE INDEX `IDX_attachment_comment_id`
ON `attachment` (`comment_id`)
Drop
IDX_attachment_issue_id issue_id SQL 
CREATE INDEX `IDX_attachment_issue_id`
ON `attachment` (`issue_id`)
Drop
IDX_attachment_release_id release_id SQL 
CREATE INDEX `IDX_attachment_release_id`
ON `attachment` (`release_id`)
Drop
IDX_attachment_repo_id repo_id SQL 
CREATE INDEX `IDX_attachment_repo_id`
ON `attachment` (`repo_id`)
Drop
IDX_attachment_uploader_id uploader_id SQL 
CREATE INDEX `IDX_attachment_uploader_id`
ON `attachment` (`uploader_id`)
Drop
UQE_attachment_uuid uuid ✓ SQL 
CREATE UNIQUE INDEX `UQE_attachment_uuid`
ON `attachment` (`uuid`)
Drop