CREATE DATABASE EXAMPLE;
USE DATABASE EXAMPLE;
CREATE TABLE orders (
"id" VARCHAR,
"first_name" VARCHAR,
"last_name" VARCHAR,
"email" VARCHAR,
"payment_default" BOOLEAN
);
INSERT INTO orders VALUES
('8e6189fa-8caf-4fd2-b648-07570a3e1a82', 'Jon', 'Smith', 'john.smith@example.com', false),
('a1aa064c-6065-43bd-a834-1a212b2dfb60', 'Robert', 'Smith', 'fraudster@example.com', true),
('8568ee21-e745-4db2-8f17-72e77396a591', 'John', 'Smith', 'john@example.com', false),
('b3c5108c-832e-479f-80d9-c2997ec93797', 'J. Marry', 'Doe', 'jane@example.com', false);
Comments