SQL

CREATE TABLE `draft_tokens`  (
  `id` integer PRIMARY KEY AUTOINCREMENT NOT NULL,
  `draft_id` integer NOT NULL,
  `manager_id` integer NOT NULL,
  `round` integer DEFAULT 1 NOT NULL,
  `token` text NOT NULL,
  `expires_at` text,
  `created_at` text DEFAULT (datetime('now')),
  FOREIGN KEY (`draft_id`) REFERENCES `drafts`(`id`) ON UPDATE no action ON DELETE no action,
  FOREIGN KEY (`manager_id`) REFERENCES `managers`(`id`) ON UPDATE no action ON DELETE no action
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
draft_id INTEGER Rename | Drop
manager_id INTEGER Rename | Drop
round INTEGER Rename | Drop
token TEXT Rename | Drop
expires_at TEXT ✓ Rename | Drop
created_at TEXT ✓ Rename | Drop

Foreign Keys

Column Destination
manager_id managers.id
draft_id drafts.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
draft_tokens_token_unique token ✓ SQL 
CREATE UNIQUE INDEX `draft_tokens_token_unique`
ON `draft_tokens` (`token`)
Drop
idx_token token SQL 
CREATE INDEX `idx_token`
ON `draft_tokens` (`token`)
Drop
idx_token_draft_manager
  • draft_id
  • manager_id
  • round
 SQL 
CREATE INDEX `idx_token_draft_manager`
ON `draft_tokens` (`draft_id`,`manager_id`,`round`)
Drop