SQL

CREATE TABLE `notice`  (
  `id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  `type` INTEGER NULL,
  `description` TEXT NULL,
  `created_unix` INTEGER NULL
)

+ Add column

Columns

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

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_notice_created_unix created_unix SQL 
CREATE INDEX `IDX_notice_created_unix`
ON `notice` (`created_unix`)
Drop