create table PLPDF_DEMO_PRODUCT_INFO (
	PRODUCT_ID INT,
	PRODUCT_NAME VARCHAR(13),
	PRODUCT_IMAGE BLOB,
	PRODUCT_AVAIL VARCHAR(50),
	LIST_PRICE INT
);
insert into PLPDF_DEMO_PRODUCT_INFO (PRODUCT_ID, PRODUCT_NAME, PRODUCT_IMAGE, PRODUCT_AVAIL, LIST_PRICE) values (1, 'Apple', null, 'N', 60);
insert into PLPDF_DEMO_PRODUCT_INFO (PRODUCT_ID, PRODUCT_NAME, PRODUCT_IMAGE, PRODUCT_AVAIL, LIST_PRICE) values (2, 'Newspaper', null, 'Y', 146);
insert into PLPDF_DEMO_PRODUCT_INFO (PRODUCT_ID, PRODUCT_NAME, PRODUCT_IMAGE, PRODUCT_AVAIL, LIST_PRICE) values (3, 'Bananas', null, 'Y', 94);
insert into PLPDF_DEMO_PRODUCT_INFO (PRODUCT_ID, PRODUCT_NAME, PRODUCT_IMAGE, PRODUCT_AVAIL, LIST_PRICE) values (4, 'Paper', null, 'N', 126);
insert into PLPDF_DEMO_PRODUCT_INFO (PRODUCT_ID, PRODUCT_NAME, PRODUCT_IMAGE, PRODUCT_AVAIL, LIST_PRICE) values (5, 'Floor', null, 'Y', 71);
insert into PLPDF_DEMO_PRODUCT_INFO (PRODUCT_ID, PRODUCT_NAME, PRODUCT_IMAGE, PRODUCT_AVAIL, LIST_PRICE) values (6, 'Toothbrush', null, 'Y', 126);
insert into PLPDF_DEMO_PRODUCT_INFO (PRODUCT_ID, PRODUCT_NAME, PRODUCT_IMAGE, PRODUCT_AVAIL, LIST_PRICE) values (7, 'Sharpie', null, 'N', 78);
insert into PLPDF_DEMO_PRODUCT_INFO (PRODUCT_ID, PRODUCT_NAME, PRODUCT_IMAGE, PRODUCT_AVAIL, LIST_PRICE) values (8, 'Cup', null, 'Y', 175);
insert into PLPDF_DEMO_PRODUCT_INFO (PRODUCT_ID, PRODUCT_NAME, PRODUCT_IMAGE, PRODUCT_AVAIL, LIST_PRICE) values (9, 'Kusanagi', null, 'N', 145);
insert into PLPDF_DEMO_PRODUCT_INFO (PRODUCT_ID, PRODUCT_NAME, PRODUCT_IMAGE, PRODUCT_AVAIL, LIST_PRICE) values (10, 'Pool stick', null, 'N', 88);
insert into PLPDF_DEMO_PRODUCT_INFO (PRODUCT_ID, PRODUCT_NAME, PRODUCT_IMAGE, PRODUCT_AVAIL, LIST_PRICE) values (11, 'Video games', null, 'Y', 189);
insert into PLPDF_DEMO_PRODUCT_INFO (PRODUCT_ID, PRODUCT_NAME, PRODUCT_IMAGE, PRODUCT_AVAIL, LIST_PRICE) values (12, 'Helmet', null, 'N', 89);
insert into PLPDF_DEMO_PRODUCT_INFO (PRODUCT_ID, PRODUCT_NAME, PRODUCT_IMAGE, PRODUCT_AVAIL, LIST_PRICE) values (13, 'Glass', null, 'Y', 140);
insert into PLPDF_DEMO_PRODUCT_INFO (PRODUCT_ID, PRODUCT_NAME, PRODUCT_IMAGE, PRODUCT_AVAIL, LIST_PRICE) values (14, 'Charger', null, 'N', 99);
insert into PLPDF_DEMO_PRODUCT_INFO (PRODUCT_ID, PRODUCT_NAME, PRODUCT_IMAGE, PRODUCT_AVAIL, LIST_PRICE) values (15, 'Magic carpet', null, 'Y', 195);
insert into PLPDF_DEMO_PRODUCT_INFO (PRODUCT_ID, PRODUCT_NAME, PRODUCT_IMAGE, PRODUCT_AVAIL, LIST_PRICE) values (16, 'Controller', null, 'N', 116);
insert into PLPDF_DEMO_PRODUCT_INFO (PRODUCT_ID, PRODUCT_NAME, PRODUCT_IMAGE, PRODUCT_AVAIL, LIST_PRICE) values (17, 'Chocolate', null, 'N', 78);
insert into PLPDF_DEMO_PRODUCT_INFO (PRODUCT_ID, PRODUCT_NAME, PRODUCT_IMAGE, PRODUCT_AVAIL, LIST_PRICE) values (18, 'Sand paper', null, 'N', 58);
insert into PLPDF_DEMO_PRODUCT_INFO (PRODUCT_ID, PRODUCT_NAME, PRODUCT_IMAGE, PRODUCT_AVAIL, LIST_PRICE) values (19, 'Bed', null, 'Y', 53);
insert into PLPDF_DEMO_PRODUCT_INFO (PRODUCT_ID, PRODUCT_NAME, PRODUCT_IMAGE, PRODUCT_AVAIL, LIST_PRICE) values (20, 'Doll', null, 'Y', 178);
insert into PLPDF_DEMO_PRODUCT_INFO (PRODUCT_ID, PRODUCT_NAME, PRODUCT_IMAGE, PRODUCT_AVAIL, LIST_PRICE) values (21, 'Rusty nail', null, 'N', 68);
insert into PLPDF_DEMO_PRODUCT_INFO (PRODUCT_ID, PRODUCT_NAME, PRODUCT_IMAGE, PRODUCT_AVAIL, LIST_PRICE) values (22, 'Thread', null, 'Y', 181);
insert into PLPDF_DEMO_PRODUCT_INFO (PRODUCT_ID, PRODUCT_NAME, PRODUCT_IMAGE, PRODUCT_AVAIL, LIST_PRICE) values (23, 'Soda can', null, 'Y', 184);
insert into PLPDF_DEMO_PRODUCT_INFO (PRODUCT_ID, PRODUCT_NAME, PRODUCT_IMAGE, PRODUCT_AVAIL, LIST_PRICE) values (24, 'Cat', null, 'N', 112);
insert into PLPDF_DEMO_PRODUCT_INFO (PRODUCT_ID, PRODUCT_NAME, PRODUCT_IMAGE, PRODUCT_AVAIL, LIST_PRICE) values (25, 'Mjolnir', null, 'N', 199);
insert into PLPDF_DEMO_PRODUCT_INFO (PRODUCT_ID, PRODUCT_NAME, PRODUCT_IMAGE, PRODUCT_AVAIL, LIST_PRICE) values (26, 'Toilet', null, 'Y', 132);
insert into PLPDF_DEMO_PRODUCT_INFO (PRODUCT_ID, PRODUCT_NAME, PRODUCT_IMAGE, PRODUCT_AVAIL, LIST_PRICE) values (27, 'Nail clippers', null, 'N', 55);
insert into PLPDF_DEMO_PRODUCT_INFO (PRODUCT_ID, PRODUCT_NAME, PRODUCT_IMAGE, PRODUCT_AVAIL, LIST_PRICE) values (28, 'Magnet', null, 'N', 55);
insert into PLPDF_DEMO_PRODUCT_INFO (PRODUCT_ID, PRODUCT_NAME, PRODUCT_IMAGE, PRODUCT_AVAIL, LIST_PRICE) values (29, 'Lamp', null, 'N', 163);
insert into PLPDF_DEMO_PRODUCT_INFO (PRODUCT_ID, PRODUCT_NAME, PRODUCT_IMAGE, PRODUCT_AVAIL, LIST_PRICE) values (30, 'Tree', null, 'N', 174);
insert into PLPDF_DEMO_PRODUCT_INFO (PRODUCT_ID, PRODUCT_NAME, PRODUCT_IMAGE, PRODUCT_AVAIL, LIST_PRICE) values (31, 'Sticky note', null, 'Y', 89);
insert into PLPDF_DEMO_PRODUCT_INFO (PRODUCT_ID, PRODUCT_NAME, PRODUCT_IMAGE, PRODUCT_AVAIL, LIST_PRICE) values (32, 'Shoe lace', null, 'N', 177);
insert into PLPDF_DEMO_PRODUCT_INFO (PRODUCT_ID, PRODUCT_NAME, PRODUCT_IMAGE, PRODUCT_AVAIL, LIST_PRICE) values (33, 'Hanger', null, 'N', 92);
insert into PLPDF_DEMO_PRODUCT_INFO (PRODUCT_ID, PRODUCT_NAME, PRODUCT_IMAGE, PRODUCT_AVAIL, LIST_PRICE) values (34, 'Shirt', null, 'Y', 152);
insert into PLPDF_DEMO_PRODUCT_INFO (PRODUCT_ID, PRODUCT_NAME, PRODUCT_IMAGE, PRODUCT_AVAIL, LIST_PRICE) values (35, 'Vase', null, 'Y', 82);
insert into PLPDF_DEMO_PRODUCT_INFO (PRODUCT_ID, PRODUCT_NAME, PRODUCT_IMAGE, PRODUCT_AVAIL, LIST_PRICE) values (36, 'Food', null, 'Y', 197);
insert into PLPDF_DEMO_PRODUCT_INFO (PRODUCT_ID, PRODUCT_NAME, PRODUCT_IMAGE, PRODUCT_AVAIL, LIST_PRICE) values (37, 'Excalibur', null, 'N', 197);
insert into PLPDF_DEMO_PRODUCT_INFO (PRODUCT_ID, PRODUCT_NAME, PRODUCT_IMAGE, PRODUCT_AVAIL, LIST_PRICE) values (38, 'Button', null, 'Y', 114);
insert into PLPDF_DEMO_PRODUCT_INFO (PRODUCT_ID, PRODUCT_NAME, PRODUCT_IMAGE, PRODUCT_AVAIL, LIST_PRICE) values (39, 'Tv', null, 'Y', 124);
insert into PLPDF_DEMO_PRODUCT_INFO (PRODUCT_ID, PRODUCT_NAME, PRODUCT_IMAGE, PRODUCT_AVAIL, LIST_PRICE) values (40, 'Pen', null, 'N', 65);

alter table PLPDF_DEMO_PRODUCT_INFO add constraint PLPDF_DEMO_PRODUCT_INFO_PK primary key (PRODUCT_ID);
