SQL

CREATE TABLE `project`  (
  `id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  `title` TEXT NOT NULL,
  `description` TEXT NULL,
  `owner_id` INTEGER NULL,
  `repo_id` INTEGER NULL,
  `creator_id` INTEGER NOT NULL,
  `is_closed` INTEGER NULL,
  `board_type` INTEGER NULL,
  `card_type` INTEGER NULL,
  `type` INTEGER NULL,
  `created_unix` INTEGER NULL,
  `updated_unix` INTEGER NULL,
  `closed_date_unix` INTEGER NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
title TEXT Rename | Drop
description TEXT ✓ Rename | Drop
owner_id INTEGER ✓ Rename | Drop
repo_id INTEGER ✓ Rename | Drop
creator_id INTEGER Rename | Drop
is_closed INTEGER ✓ Rename | Drop
board_type INTEGER ✓ Rename | Drop
card_type INTEGER ✓ Rename | Drop
type INTEGER ✓ Rename | Drop
created_unix INTEGER ✓ Rename | Drop
updated_unix INTEGER ✓ Rename | Drop
closed_date_unix INTEGER ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_project_created_unix created_unix SQL 
CREATE INDEX `IDX_project_created_unix`
ON `project` (`created_unix`)
Drop
IDX_project_is_closed is_closed SQL 
CREATE INDEX `IDX_project_is_closed`
ON `project` (`is_closed`)
Drop
IDX_project_owner_id owner_id SQL 
CREATE INDEX `IDX_project_owner_id`
ON `project` (`owner_id`)
Drop
IDX_project_repo_id repo_id SQL 
CREATE INDEX `IDX_project_repo_id`
ON `project` (`repo_id`)
Drop
IDX_project_title title SQL 
CREATE INDEX `IDX_project_title`
ON `project` (`title`)
Drop
IDX_project_updated_unix updated_unix SQL 
CREATE INDEX `IDX_project_updated_unix`
ON `project` (`updated_unix`)
Drop