SQL

CREATE TABLE `project_board`  (
  `id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  `title` TEXT NULL,
  `default` INTEGER DEFAULT 0 NOT NULL,
  `sorting` INTEGER DEFAULT 0 NOT NULL,
  `color` TEXT NULL,
  `project_id` INTEGER NOT NULL,
  `creator_id` INTEGER NOT NULL,
  `created_unix` INTEGER NULL,
  `updated_unix` INTEGER NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
title TEXT ✓ Rename | Drop
default INTEGER Rename | Drop
sorting INTEGER Rename | Drop
color TEXT ✓ Rename | Drop
project_id INTEGER Rename | Drop
creator_id INTEGER Rename | Drop
created_unix INTEGER ✓ Rename | Drop
updated_unix INTEGER ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_project_board_created_unix created_unix SQL 
CREATE INDEX `IDX_project_board_created_unix`
ON `project_board` (`created_unix`)
Drop
IDX_project_board_project_id project_id SQL 
CREATE INDEX `IDX_project_board_project_id`
ON `project_board` (`project_id`)
Drop
IDX_project_board_updated_unix updated_unix SQL 
CREATE INDEX `IDX_project_board_updated_unix`
ON `project_board` (`updated_unix`)
Drop