SQL

CREATE TABLE `repo_hidden_file`  (
  `id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  `repo_id` INTEGER NOT NULL,
  `path` TEXT NOT NULL,
  `is_dir` INTEGER DEFAULT 0 NOT NULL,
  `is_hidden` INTEGER DEFAULT 1 NOT NULL,
  `created_at` INTEGER DEFAULT 0 NULL,
  `updated_at` INTEGER DEFAULT 0 NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
repo_id INTEGER Rename | Drop
path TEXT Rename | Drop
is_dir INTEGER Rename | Drop
is_hidden INTEGER Rename | Drop
created_at INTEGER ✓ Rename | Drop
updated_at INTEGER ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_repo_hidden_file_repo_id repo_id SQL 
CREATE INDEX `IDX_repo_hidden_file_repo_id`
ON `repo_hidden_file` (`repo_id`)
Drop