SQL

CREATE TABLE `secret`  (
  `id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  `owner_id` INTEGER NOT NULL,
  `repo_id` INTEGER DEFAULT 0 NOT NULL,
  `name` TEXT NOT NULL,
  `data` TEXT NULL,
  `created_unix` INTEGER NOT NULL,
  `description` TEXT NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
owner_id INTEGER Rename | Drop
repo_id INTEGER Rename | Drop
name TEXT Rename | Drop
data TEXT ✓ Rename | Drop
created_unix INTEGER Rename | Drop
description TEXT ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_secret_owner_id owner_id SQL 
CREATE INDEX `IDX_secret_owner_id`
ON `secret` (`owner_id`)
Drop
IDX_secret_repo_id repo_id SQL 
CREATE INDEX `IDX_secret_repo_id`
ON `secret` (`repo_id`)
Drop
UQE_secret_owner_repo_name
  • owner_id
  • repo_id
  • name
 ✓ SQL 
CREATE UNIQUE INDEX `UQE_secret_owner_repo_name`
ON `secret` (`owner_id`,`repo_id`,`name`)
Drop