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
)