SQL

CREATE TABLE `team_invite`  (
  `id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  `token` TEXT DEFAULT '' NOT NULL,
  `inviter_id` INTEGER DEFAULT 0 NOT NULL,
  `org_id` INTEGER DEFAULT 0 NOT NULL,
  `team_id` INTEGER DEFAULT 0 NOT NULL,
  `email` TEXT DEFAULT '' 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
token TEXT Rename | Drop
inviter_id INTEGER Rename | Drop
org_id INTEGER Rename | Drop
team_id INTEGER Rename | Drop
email TEXT Rename | Drop
created_unix INTEGER ✓ Rename | Drop
updated_unix INTEGER ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_team_invite_created_unix created_unix SQL 
CREATE INDEX `IDX_team_invite_created_unix`
ON `team_invite` (`created_unix`)
Drop
IDX_team_invite_org_id org_id SQL 
CREATE INDEX `IDX_team_invite_org_id`
ON `team_invite` (`org_id`)
Drop
IDX_team_invite_team_id team_id SQL 
CREATE INDEX `IDX_team_invite_team_id`
ON `team_invite` (`team_id`)
Drop
IDX_team_invite_token token SQL 
CREATE INDEX `IDX_team_invite_token`
ON `team_invite` (`token`)
Drop
IDX_team_invite_updated_unix updated_unix SQL 
CREATE INDEX `IDX_team_invite_updated_unix`
ON `team_invite` (`updated_unix`)
Drop
UQE_team_invite_team_mail
  • team_id
  • email
 ✓ SQL 
CREATE UNIQUE INDEX `UQE_team_invite_team_mail`
ON `team_invite` (`team_id`,`email`)
Drop