create table PLPDF_DEMO_CUSTOMERS (
	CUSTOMER_ID INT,
	CUST_FIRST_NAME VARCHAR(50),
	CUST_LAST_NAME VARCHAR(50),
	CUST_STREET_ADDRESS1 VARCHAR(50),
	CUST_STREET_ADDRESS2 VARCHAR(50),
	CUST_CITY VARCHAR(50),
	CUST_STATE VARCHAR(50),
	CUST_POSTAL_CODE VARCHAR(50),
	PHONE_NUMBER1 VARCHAR(50),
	PHONE_NUMBER2 VARCHAR(50),
	CREDIT_LIMIT INT,
	CUST_EMAIL VARCHAR(50)
);
insert into PLPDF_DEMO_CUSTOMERS (CUSTOMER_ID, CUST_FIRST_NAME, CUST_LAST_NAME, CUST_STREET_ADDRESS1, CUST_STREET_ADDRESS2, CUST_CITY, CUST_STATE, CUST_POSTAL_CODE, PHONE_NUMBER1, PHONE_NUMBER2, CREDIT_LIMIT, CUST_EMAIL) values (1, 'Fred', 'Scott', '517 Nelson Terrace', '1987 Eagan Place', 'Tucson', 'Arizona', '85743', '1-(520)534-0834', '1-(713)280-9218', 2219, 'fscott0@state.tx.us');
insert into PLPDF_DEMO_CUSTOMERS (CUSTOMER_ID, CUST_FIRST_NAME, CUST_LAST_NAME, CUST_STREET_ADDRESS1, CUST_STREET_ADDRESS2, CUST_CITY, CUST_STATE, CUST_POSTAL_CODE, PHONE_NUMBER1, PHONE_NUMBER2, CREDIT_LIMIT, CUST_EMAIL) values (2, 'Jason', 'Brown', '87 Maywood Circle', '378 Calypso Alley', 'Aurora', 'Illinois', '60505', '1-(331)204-6109', '1-(361)867-2565', 2030, 'jbrown1@addthis.com');
insert into PLPDF_DEMO_CUSTOMERS (CUSTOMER_ID, CUST_FIRST_NAME, CUST_LAST_NAME, CUST_STREET_ADDRESS1, CUST_STREET_ADDRESS2, CUST_CITY, CUST_STATE, CUST_POSTAL_CODE, PHONE_NUMBER1, PHONE_NUMBER2, CREDIT_LIMIT, CUST_EMAIL) values (3, 'Bobby', 'Cook', '91 Erie Plaza', '17428 Arkansas Hill', 'Omaha', 'Nebraska', '68164', '1-(402)947-0857', '1-(562)172-1072', 1434, 'bcook2@msn.com');
insert into PLPDF_DEMO_CUSTOMERS (CUSTOMER_ID, CUST_FIRST_NAME, CUST_LAST_NAME, CUST_STREET_ADDRESS1, CUST_STREET_ADDRESS2, CUST_CITY, CUST_STATE, CUST_POSTAL_CODE, PHONE_NUMBER1, PHONE_NUMBER2, CREDIT_LIMIT, CUST_EMAIL) values (4, 'Ernest', 'Snyder', '83 Merrick Alley', '4 Maple Wood Drive', 'Atlanta', 'Georgia', '31196', '1-(404)403-9511', '1-(720)318-7328', 2773, 'esnyder3@plala.or.jp');
insert into PLPDF_DEMO_CUSTOMERS (CUSTOMER_ID, CUST_FIRST_NAME, CUST_LAST_NAME, CUST_STREET_ADDRESS1, CUST_STREET_ADDRESS2, CUST_CITY, CUST_STATE, CUST_POSTAL_CODE, PHONE_NUMBER1, PHONE_NUMBER2, CREDIT_LIMIT, CUST_EMAIL) values (5, 'Walter', 'Weaver', '700 Moose Lane', '27648 Schlimgen Court', 'Riverside', 'California', '92505', '1-(909)330-6817', '1-(918)639-5736', 1665, 'wweaver4@t-online.de');
insert into PLPDF_DEMO_CUSTOMERS (CUSTOMER_ID, CUST_FIRST_NAME, CUST_LAST_NAME, CUST_STREET_ADDRESS1, CUST_STREET_ADDRESS2, CUST_CITY, CUST_STATE, CUST_POSTAL_CODE, PHONE_NUMBER1, PHONE_NUMBER2, CREDIT_LIMIT, CUST_EMAIL) values (6, 'Sara', 'Welch', '0 Morrow Point', '17770 Green Point', 'Washington', 'District of Columbia', '20404', '1-(202)218-8310', '1-(510)691-2312', 1568, 'swelch5@nhs.uk');
insert into PLPDF_DEMO_CUSTOMERS (CUSTOMER_ID, CUST_FIRST_NAME, CUST_LAST_NAME, CUST_STREET_ADDRESS1, CUST_STREET_ADDRESS2, CUST_CITY, CUST_STATE, CUST_POSTAL_CODE, PHONE_NUMBER1, PHONE_NUMBER2, CREDIT_LIMIT, CUST_EMAIL) values (7, 'Ashley', 'Rivera', '98 Cherokee Point', '7 Eliot Trail', 'Atlanta', 'Georgia', '30311', '1-(404)963-7637', '1-(717)988-5396', 1830, 'arivera6@prlog.org');
insert into PLPDF_DEMO_CUSTOMERS (CUSTOMER_ID, CUST_FIRST_NAME, CUST_LAST_NAME, CUST_STREET_ADDRESS1, CUST_STREET_ADDRESS2, CUST_CITY, CUST_STATE, CUST_POSTAL_CODE, PHONE_NUMBER1, PHONE_NUMBER2, CREDIT_LIMIT, CUST_EMAIL) values (8, 'Shirley', 'Fields', '88 Beilfuss Park', '9415 Charing Cross Park', 'Davenport', 'Iowa', '52809', '1-(563)955-9612', '1-(314)528-3675', 2507, 'sfields7@soup.io');
insert into PLPDF_DEMO_CUSTOMERS (CUSTOMER_ID, CUST_FIRST_NAME, CUST_LAST_NAME, CUST_STREET_ADDRESS1, CUST_STREET_ADDRESS2, CUST_CITY, CUST_STATE, CUST_POSTAL_CODE, PHONE_NUMBER1, PHONE_NUMBER2, CREDIT_LIMIT, CUST_EMAIL) values (9, 'Keith', 'Edwards', '7 Raven Hill', '83 1st Hill', 'Little Rock', 'Arkansas', '72222', '1-(501)576-4933', '1-(480)271-2432', 1463, 'kedwards8@shinystat.com');
insert into PLPDF_DEMO_CUSTOMERS (CUSTOMER_ID, CUST_FIRST_NAME, CUST_LAST_NAME, CUST_STREET_ADDRESS1, CUST_STREET_ADDRESS2, CUST_CITY, CUST_STATE, CUST_POSTAL_CODE, PHONE_NUMBER1, PHONE_NUMBER2, CREDIT_LIMIT, CUST_EMAIL) values (10, 'Anna', 'Parker', '34771 Corben Way', '9793 Dapin Road', 'Toledo', 'Ohio', '43666', '1-(419)913-6561', '1-(336)108-8212', 2945, 'aparker9@home.pl');
insert into PLPDF_DEMO_CUSTOMERS (CUSTOMER_ID, CUST_FIRST_NAME, CUST_LAST_NAME, CUST_STREET_ADDRESS1, CUST_STREET_ADDRESS2, CUST_CITY, CUST_STATE, CUST_POSTAL_CODE, PHONE_NUMBER1, PHONE_NUMBER2, CREDIT_LIMIT, CUST_EMAIL) values (11, 'Adam', 'Stewart', '27747 Golf View Circle', '7760 Haas Hill', 'Santa Cruz', 'California', '95064', '1-(831)134-6655', '1-(303)553-1229', 1237, 'astewarta@squidoo.com');
insert into PLPDF_DEMO_CUSTOMERS (CUSTOMER_ID, CUST_FIRST_NAME, CUST_LAST_NAME, CUST_STREET_ADDRESS1, CUST_STREET_ADDRESS2, CUST_CITY, CUST_STATE, CUST_POSTAL_CODE, PHONE_NUMBER1, PHONE_NUMBER2, CREDIT_LIMIT, CUST_EMAIL) values (12, 'Shirley', 'Coleman', '5 Pierstorff Pass', '6 Warbler Street', 'Midland', 'Michigan', '48670', '1-(989)594-3492', '1-(802)390-7015', 2056, 'scolemanb@e-recht24.de');
insert into PLPDF_DEMO_CUSTOMERS (CUSTOMER_ID, CUST_FIRST_NAME, CUST_LAST_NAME, CUST_STREET_ADDRESS1, CUST_STREET_ADDRESS2, CUST_CITY, CUST_STATE, CUST_POSTAL_CODE, PHONE_NUMBER1, PHONE_NUMBER2, CREDIT_LIMIT, CUST_EMAIL) values (13, 'Billy', 'Ruiz', '6644 Eagan Circle', '7 Kingsford Junction', 'Fort Myers', 'Florida', '33906', '1-(239)658-7393', '1-(561)209-3416', 2006, 'bruizc@state.gov');
insert into PLPDF_DEMO_CUSTOMERS (CUSTOMER_ID, CUST_FIRST_NAME, CUST_LAST_NAME, CUST_STREET_ADDRESS1, CUST_STREET_ADDRESS2, CUST_CITY, CUST_STATE, CUST_POSTAL_CODE, PHONE_NUMBER1, PHONE_NUMBER2, CREDIT_LIMIT, CUST_EMAIL) values (14, 'Gloria', 'Lopez', '40614 Autumn Leaf Junction', '5 Lakewood Trail', 'Norwalk', 'Connecticut', '06859', '1-(203)258-3154', '1-(716)584-4202', 1942, 'glopezd@sphinn.com');
insert into PLPDF_DEMO_CUSTOMERS (CUSTOMER_ID, CUST_FIRST_NAME, CUST_LAST_NAME, CUST_STREET_ADDRESS1, CUST_STREET_ADDRESS2, CUST_CITY, CUST_STATE, CUST_POSTAL_CODE, PHONE_NUMBER1, PHONE_NUMBER2, CREDIT_LIMIT, CUST_EMAIL) values (15, 'Benjamin', 'Powell', '1584 Prairieview Parkway', '2 Ridge Oak Terrace', 'Richmond', 'Virginia', '23203', '1-(804)590-9679', '1-(937)894-0849', 2428, 'bpowelle@vistaprint.com');
insert into PLPDF_DEMO_CUSTOMERS (CUSTOMER_ID, CUST_FIRST_NAME, CUST_LAST_NAME, CUST_STREET_ADDRESS1, CUST_STREET_ADDRESS2, CUST_CITY, CUST_STATE, CUST_POSTAL_CODE, PHONE_NUMBER1, PHONE_NUMBER2, CREDIT_LIMIT, CUST_EMAIL) values (16, 'Steven', 'Lynch', '5570 Delaware Trail', '301 Ridgeway Plaza', 'Roanoke', 'Virginia', '24040', '1-(540)790-2351', '1-(502)772-4765', 2806, 'slynchf@abc.net.au');
insert into PLPDF_DEMO_CUSTOMERS (CUSTOMER_ID, CUST_FIRST_NAME, CUST_LAST_NAME, CUST_STREET_ADDRESS1, CUST_STREET_ADDRESS2, CUST_CITY, CUST_STATE, CUST_POSTAL_CODE, PHONE_NUMBER1, PHONE_NUMBER2, CREDIT_LIMIT, CUST_EMAIL) values (17, 'Ryan', 'Rivera', '3413 Steensland Circle', '71 Aberg Place', 'Sacramento', 'California', '95818', '1-(916)443-3476', '1-(215)200-3578', 1021, 'rriverag@ucoz.com');
insert into PLPDF_DEMO_CUSTOMERS (CUSTOMER_ID, CUST_FIRST_NAME, CUST_LAST_NAME, CUST_STREET_ADDRESS1, CUST_STREET_ADDRESS2, CUST_CITY, CUST_STATE, CUST_POSTAL_CODE, PHONE_NUMBER1, PHONE_NUMBER2, CREDIT_LIMIT, CUST_EMAIL) values (18, 'Maria', 'Perez', '4165 Evergreen Lane', '6 Dwight Parkway', 'Houston', 'Texas', '77293', '1-(281)980-7970', '1-(501)582-6707', 1888, 'mperezh@amazon.co.uk');
insert into PLPDF_DEMO_CUSTOMERS (CUSTOMER_ID, CUST_FIRST_NAME, CUST_LAST_NAME, CUST_STREET_ADDRESS1, CUST_STREET_ADDRESS2, CUST_CITY, CUST_STATE, CUST_POSTAL_CODE, PHONE_NUMBER1, PHONE_NUMBER2, CREDIT_LIMIT, CUST_EMAIL) values (19, 'Timothy', 'Woods', '8067 Victoria Avenue', '763 Helena Place', 'Baton Rouge', 'Louisiana', '70836', '1-(225)911-0993', '1-(850)226-0770', 2644, 'twoodsi@fda.gov');
insert into PLPDF_DEMO_CUSTOMERS (CUSTOMER_ID, CUST_FIRST_NAME, CUST_LAST_NAME, CUST_STREET_ADDRESS1, CUST_STREET_ADDRESS2, CUST_CITY, CUST_STATE, CUST_POSTAL_CODE, PHONE_NUMBER1, PHONE_NUMBER2, CREDIT_LIMIT, CUST_EMAIL) values (20, 'Roy', 'Henry', '67341 Melody Lane', '25 Sheridan Junction', 'Irving', 'Texas', '75062', '1-(214)140-9826', '1-(404)301-7466', 2622, 'rhenryj@home.pl');

alter table PLPDF_DEMO_CUSTOMERS add constraint PLPDF_DEMO_CUSTOMERS_PK primary key (CUSTOMER_ID);