SQL

CREATE TABLE `team`  (
  `id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  `org_id` INTEGER NULL,
  `lower_name` TEXT NULL,
  `name` TEXT NULL,
  `description` TEXT NULL,
  `authorize` INTEGER NULL,
  `num_repos` INTEGER NULL,
  `num_members` INTEGER NULL,
  `includes_all_repositories` INTEGER DEFAULT 0 NOT NULL,
  `can_create_org_repo` INTEGER DEFAULT 0 NOT NULL,
  `can_sync_deploy` INTEGER DEFAULT 0 NOT NULL,
  `can_view_hidden_files` INTEGER DEFAULT 0 NOT NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
org_id INTEGER ✓ Rename | Drop
lower_name TEXT ✓ Rename | Drop
name TEXT ✓ Rename | Drop
description TEXT ✓ Rename | Drop
authorize INTEGER ✓ Rename | Drop
num_repos INTEGER ✓ Rename | Drop
num_members INTEGER ✓ Rename | Drop
includes_all_repositories INTEGER Rename | Drop
can_create_org_repo INTEGER Rename | Drop
can_sync_deploy INTEGER Rename | Drop
can_view_hidden_files INTEGER Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_team_org_id org_id SQL 
CREATE INDEX `IDX_team_org_id`
ON `team` (`org_id`)
Drop