license-server.db — purchase_infos

SQL

CREATE TABLE "purchase_infos"  (
  `id` integer,
  `name` text NOT NULL,
  `first_name` text NOT NULL,
  `last_name` text NOT NULL,
  `email` text NOT NULL,
  `purchase_id` text NOT NULL,
  `product_id` text NOT NULL,
  `custom_fields` text NOT NULL,
  PRIMARY KEY (`id`)
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER Rename | Drop
name TEXT Rename | Drop
first_name TEXT Rename | Drop
last_name TEXT Rename | Drop
email TEXT Rename | Drop
purchase_id TEXT Rename | Drop
product_id TEXT Rename | Drop
custom_fields TEXT Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?