SQL

CREATE TABLE `checkins`  (
  `id` integer,
  `license_id` text NOT NULL,
  `machine_id` text NOT NULL,
  `created_at` text NOT NULL,
  `ip_address` text NULL,
  PRIMARY KEY (`id`)
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER Rename | Drop
license_id TEXT Rename | Drop
machine_id TEXT Rename | Drop
created_at TEXT Rename | Drop
ip_address TEXT Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?