Query

data — ManualParcel

SQL

CREATE TABLE "ManualParcel"  (
  "id" integer PRIMARY KEY,
  "first_name" text NOT NULL,
  "last_name" text NOT NULL,
  "email" text NOT NULL,
  "phone" text,
  "address1" text NOT NULL,
  "address2" text,
  "postal_code" text NOT NULL,
  "city" text NOT NULL,
  "state" text,
  "country" text NOT NULL DEFAULT 'FR',
  "contents" text NOT NULL DEFAULT '',
  "notes" text NOT NULL DEFAULT '',
  "tracking_number" text,
  "labeled" integer NOT NULL DEFAULT FALSE,
  "packed" integer NOT NULL DEFAULT FALSE,
  "sent" integer NOT NULL DEFAULT FALSE,
  "problem" integer NOT NULL DEFAULT FALSE,
  "created_at" text NOT NULL DEFAULT CURRENT_TIMESTAMP
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ ✓ Rename | Drop
first_name TEXT Rename | Drop
last_name TEXT Rename | Drop
email TEXT Rename | Drop
phone TEXT ✓ Rename | Drop
address1 TEXT Rename | Drop
address2 TEXT ✓ Rename | Drop
postal_code TEXT Rename | Drop
city TEXT Rename | Drop
state TEXT ✓ Rename | Drop
country TEXT Rename | Drop
contents TEXT Rename | Drop
notes TEXT Rename | Drop
tracking_number TEXT ✓ Rename | Drop
labeled INTEGER Rename | Drop
packed INTEGER Rename | Drop
sent INTEGER Rename | Drop
problem INTEGER Rename | Drop
created_at TEXT Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?