SQL

CREATE TABLE `licenses`  (
  `id` integer,
  `key` text NOT NULL,
  `key_type` text NOT NULL,
  `purchase_info_id` integer NOT NULL,
  PRIMARY KEY (`id`)
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER Rename | Drop
key TEXT Rename | Drop
key_type TEXT Rename | Drop
purchase_info_id INTEGER Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?