SQL

CREATE TABLE `badge`  (
  `id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  `slug` TEXT NULL,
  `description` TEXT NULL,
  `image_url` TEXT NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
slug TEXT ✓ Rename | Drop
description TEXT ✓ Rename | Drop
image_url TEXT ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
UQE_badge_slug slug ✓ SQL 
CREATE UNIQUE INDEX `UQE_badge_slug`
ON `badge` (`slug`)
Drop