SQL

CREATE TABLE `managers`  (
  `id` integer PRIMARY KEY AUTOINCREMENT NOT NULL,
  `discord_id` text NOT NULL,
  `username` text NOT NULL,
  `is_active` integer DEFAULT true NOT NULL,
  `created_at` text DEFAULT (datetime('now'))
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
discord_id TEXT Rename | Drop
username TEXT Rename | Drop
is_active INTEGER Rename | Drop
created_at TEXT ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
managers_discord_id_unique discord_id ✓ SQL 
CREATE UNIQUE INDEX `managers_discord_id_unique`
ON `managers` (`discord_id`)
Drop