Forest

正常运行会遇到一些小麻烦，但只要使用前几个例程的解决方法就能解决。这里要讲的是如何把默认的DERBY数据库换成MySQL，为此需要修改几个地方，第一个是web.xml中的数据源配置，如下：

    <data-source>
        <name>java:global/ForestDataSource</name>
        <class-name>com.mysql.jdbc.jdbc2.optional.MysqlDataSource</class-name>
        <server-name>localhost</server-name>
        <port-number>3306</port-number>
        
        <user>root</user>
        <password>admin</password>
        <property>
            <name>connectionAttributes</name>
            <value>;create=true</value>
        </property>
    </data-source>

因为MySQL数据库和DERBY数据库的差异，此处删除了一行设置<database-name>forest</database-name>，其他内容基本上都是照猫画虎。而persistence.xml好像不需要做任何改变，但是需要在MySQL数据库中创建一个forest数据库。注意一点：domains\domain\lib目录里需要包含mysql-connector-java-5.1.23-bin.jar包。接下来要修改那三个sql文件，第一个是drop.sql，如下：

SET FOREIGN_KEY_CHECKS=0;
DROP TABLE PERSON_GROUPS;
DROP TABLE PERSON;
DROP TABLE GROUPS;
DROP TABLE ORDER_DETAIL;
DROP TABLE CUSTOMER_ORDER;
DROP TABLE ORDER_STATUS;
DROP TABLE PRODUCT;
DROP TABLE CATEGORY;

接下来修改create.sql，结果如下：

CREATE SCHEMA IF NOT EXISTS FOREST DEFAULT CHARACTER SET UTF8;
USE FOREST;
set character_set_results='utf8';
set names gbk;
CREATE TABLE CATEGORY(ID int NOT NULL PRIMARY KEY AUTO_INCREMENT, NAME varchar(45) NOT NULL, TAGS varchar(45));
CREATE UNIQUE INDEX SQL_CATEGORY_ID_INDEX ON CATEGORY(ID);
CREATE TABLE PERSON(ID int NOT NULL PRIMARY KEY AUTO_INCREMENT, FIRSTNAME varchar(50) NOT NULL, LASTNAME varchar(100) NOT NULL, EMAIL varchar(45) NOT NULL UNIQUE, ADDRESS varchar(45) NOT NULL, CITY varchar(45) NOT NULL, PASSWORD varchar(100), DTYPE varchar(31));
CREATE UNIQUE INDEX SQL_PERSON_EMAIL_INDEX ON PERSON(EMAIL);
CREATE UNIQUE INDEX SQL_PERSON_ID_INDEX ON PERSON(ID);
CREATE TABLE GROUPS(ID int NOT NULL PRIMARY KEY AUTO_INCREMENT, NAME varchar(50) NOT NULL, DESCRIPTION varchar(300));
CREATE TABLE PERSON_GROUPS(GROUPS_ID int NOT NULL, EMAIL varchar(45) NOT NULL);
ALTER TABLE PERSON_GROUPS ADD CONSTRAINT FK_PERSON_GROUPS_PERSON FOREIGN KEY (EMAIL) REFERENCES PERSON(EMAIL);
ALTER TABLE PERSON_GROUPS ADD CONSTRAINT FK_PERSON_GROUPS_GROUPS FOREIGN KEY (GROUPS_ID) REFERENCES GROUPS(ID);
CREATE INDEX SQL_PERSONGROUPS_EMAIL_INDEX ON PERSON_GROUPS(EMAIL);
CREATE INDEX SQL_PERSONGROUPS_ID_INDEX ON PERSON_GROUPS(GROUPS_ID);
CREATE TABLE ORDER_STATUS(ID int NOT NULL PRIMARY KEY, STATUS varchar(45) NOT NULL, DESCRIPTION varchar(200));
CREATE UNIQUE INDEX SQL_ORDERSTATUS_ID_INDEX ON ORDER_STATUS(ID);
CREATE TABLE CUSTOMER_ORDER(ID int NOT NULL PRIMARY KEY AUTO_INCREMENT, AMOUNT float(52) NOT NULL, DATE_CREATED timestamp DEFAULT CURRENT_TIMESTAMP NOT NULL, CUSTOMER_ID int NOT NULL, STATUS_ID int NOT NULL);
ALTER TABLE CUSTOMER_ORDER ADD CONSTRAINT FK_CUSTOMER_ORDER_ORDER_STATUS1 FOREIGN KEY (STATUS_ID) REFERENCES ORDER_STATUS(ID);
ALTER TABLE CUSTOMER_ORDER ADD CONSTRAINT FK_CUSTOMER_ORDER_CUSTOMER1 FOREIGN KEY (CUSTOMER_ID) REFERENCES PERSON(ID);
CREATE INDEX SQL_ORDER_STATUS_ID_INDEX ON CUSTOMER_ORDER(STATUS_ID);
CREATE INDEX SQL_ORDER_CUSTOMER_ID_INDEX ON CUSTOMER_ORDER(CUSTOMER_ID);
CREATE UNIQUE INDEX SQL_ORDER_ID_INDEX ON CUSTOMER_ORDER(ID);
CREATE TABLE PRODUCT(ID int NOT NULL PRIMARY KEY AUTO_INCREMENT, NAME varchar(45) NOT NULL, PRICE decimal(10,2) NOT NULL, DESCRIPTION varchar(145) NOT NULL, IMG varchar(45), CATEGORY_ID int NOT NULL, IMG_SRC blob(1073741823));
ALTER TABLE PRODUCT ADD CONSTRAINT FK_PRODUCT_CATEGORY FOREIGN KEY (CATEGORY_ID) REFERENCES CATEGORY(ID);
CREATE UNIQUE INDEX SQL_PRODUCT_ID_INDEX ON PRODUCT(ID);
CREATE TABLE ORDER_DETAIL(ORDER_ID int NOT NULL, PRODUCT_ID int NOT NULL, QTY int NOT NULL, CONSTRAINT SQL_ORDER_PRODUCT_PK PRIMARY KEY (ORDER_ID,PRODUCT_ID));
ALTER TABLE ORDER_DETAIL ADD CONSTRAINT FK_ORDER_DETAIL_PRODUCT FOREIGN KEY (PRODUCT_ID) REFERENCES PRODUCT(ID);
ALTER TABLE ORDER_DETAIL ADD CONSTRAINT FK_ORDER_DETAIL_ORDER FOREIGN KEY (ORDER_ID) REFERENCES CUSTOMER_ORDER(ID);
CREATE UNIQUE INDEX SQL_ORDER_DETAIL_INDEX ON ORDER_DETAIL(ORDER_ID, PRODUCT_ID);
CREATE INDEX SQL_ORDER_PRODUCT_ID_INDEX ON ORDER_DETAIL(PRODUCT_ID);
CREATE INDEX SQL_ORDER_DETAIL_ID_INDEX ON ORDER_DETAIL(ORDER_ID);

注意此处需要增加CREATE SCHEMA IF NOT EXISTS FOREST DEFAULT CHARACTER SET UTF8;，因为我们需要彻底重建数据库方案。最后是data.sql，结果如下：

INSERT INTO CATEGORY (NAME,TAGS) VALUES ('Plants','Seeds, trees, flowers ...');
INSERT INTO CATEGORY (NAME,TAGS) VALUES ('Food','Foods, healthy items ...');
INSERT INTO CATEGORY (NAME,TAGS) VALUES ('Services','Fence installation, gardening ...');
INSERT INTO CATEGORY (NAME,TAGS) VALUES ('Tools','Tools for gardeners and landscapers');


INSERT INTO PERSON (FIRSTNAME,LASTNAME,EMAIL,ADDRESS,CITY,PASSWORD,DTYPE) VALUES ('Robert','Exampler','robert@example.com','Example street','San Francisco','81dc9bdb52d04dc20036dbd8313ed055','Customer');
INSERT INTO PERSON (FIRSTNAME,LASTNAME,EMAIL,ADDRESS,CITY,PASSWORD,DTYPE) VALUES ('Admin','Admin','admin@example.com','Example street','Belmont','81dc9bdb52d04dc20036dbd8313ed055','Administrator');
INSERT INTO PERSON (FIRSTNAME,LASTNAME,EMAIL,ADDRESS,CITY,PASSWORD,DTYPE) VALUES ('Jack','Frost','jack@example.com','Example Blvd','San Francisco','81dc9bdb52d04dc20036dbd8313ed055','Customer');
INSERT INTO PERSON (FIRSTNAME,LASTNAME,EMAIL,ADDRESS,CITY,PASSWORD,DTYPE) VALUES ('Payment','User','paymentUser@dukesforest.com','-','-','58175e1df62779046a3a4e2483575937','Customer');


INSERT INTO GROUPS (NAME, DESCRIPTION) VALUES ('USERS', 'Users of the store');
INSERT INTO GROUPS (NAME, DESCRIPTION) VALUES ('ADMINS', 'Administrators of the store');


INSERT INTO PERSON_GROUPS (GROUPS_ID,EMAIL) VALUES (1,'robert@example.com');
INSERT INTO PERSON_GROUPS (GROUPS_ID,EMAIL) VALUES (2,'admin@example.com');
INSERT INTO PERSON_GROUPS (GROUPS_ID,EMAIL) VALUES (1,'jack@example.com');
INSERT INTO PERSON_GROUPS (GROUPS_ID,EMAIL) VALUES (1,'paymentUser@dukesforest.com');


INSERT INTO ORDER_STATUS (ID,STATUS,DESCRIPTION) VALUES (1,'Pending processing','');
INSERT INTO ORDER_STATUS (ID,STATUS,DESCRIPTION) VALUES (2,'Validating payment','');
INSERT INTO ORDER_STATUS (ID,STATUS,DESCRIPTION) VALUES (3,'Ready to ship','Payment approved');INSERT INTO ORDER_STATUS (ID,STATUS,DESCRIPTION) VALUES (4,'Order shipped', '');
INSERT INTO ORDER_STATUS (ID,STATUS,DESCRIPTION) VALUES (5,'Order cancelled','$1000 order limit exceeded');
INSERT INTO ORDER_STATUS (ID,STATUS,DESCRIPTION) VALUES (6,'Order cancelled','Cancelled by administrator');


INSERT INTO PRODUCT (NAME,PRICE,DESCRIPTION,IMG,CATEGORY_ID,IMG_SRC) VALUES ('Shrub',40.00,'Hardy, slow growing evergreen with an easy to maintain shape','shrub.jpg',1, 'ffd8ffe000104a46494600010101006000600000ffe1001645786966000049492a0008000000000000000000ffdb004300080606070605080707070909080a0c140d0c0b0b0c1912130f141d1a1f1e1d1a1c1c20242e2720222c231c1c2837292c30313434341f27393d38323c2e333432ffdb0043010909090c0b0c180d0d1832211c213232323232323232323232323232323232323232323232323232323232323232323232323232323232323232323232323232ffc0001108006d008003012200021101031101ffc4001f0000010501010101010100000000000000000102030405060708090a0bffc400b5100002010303020403050504040000017d01020300041105122131410613516107227114328191a1082342b1c11552d1f02433627282090a161718191a25262728292a3435363738393a434445464748494a535455565758595a636465666768696a737475767778797a838485868788898a92939495969798999aa2a3a4a5a6a7a8a9aab2b3b4b5b6b7b8b9bac2c3c4c5c6c7c8c9cad2d3d4d5d6d7d8d9dae1e2e3e4e5e6e7e8e9eaf1f2f3f4f5f6f7f8f9faffc4001f0100030101010101010101010000000000000102030405060708090a0bffc400b51100020102040403040705040400010277000102031104052131061241510761711322328108144291a1b1c109233352f0156272d10a162434e125f11718191a262728292a35363738393a434445464748494a535455565758595a636465666768696a737475767778797a82838485868788898a92939495969798999aa2a3a4a5a6a7a8a9aab2b3b4b5b6b7b8b9bac2c3c4c5c6c7c8c9cad2d3d4d5d6d7d8d9dae2e3e4e5e6e7e8e9eaf2f3f4f5f6f7f8f9faffda000c03010002110311003f00f7fa28a2800a28ac0f16f89a0f0ae8e750b84f301708b1870a589f4fa75a4da4aec1bb1bd9a896e626242ba92adb08cf46eb8faf35f3a5e7c58f105fc66d0de476f1c995c421964db93fc7d43018e722b988bc57ab5b48c61d42ee0691b78912729961900e738ee7d7eb58fb65d119fb55d0fa9f52d734ed223325f5dc500033866e4fd077ae46e3e2f785a39c4505c4d70588d8cb190af9e4e09c723df15f3bc97f773c6ada84ef3166da198e73c9c9639c93c9eb9a91ed60ba1e589479ea42ec0a155d7a6723f0e3152eabbe843abae87d39a2f8f7c3dae2016fa9431cfb773c32b0564e71c93c7e469f71e39f0fda6a0f63757eb04c8fb18383807b67ebd41e95f284cf3f9f1b48009914ee638c8edd4739c71fe35656f6e6de40b2ef94ec0f9dd9e3f84f20e0d54aacba0fdab3ec7595580c1072323dc7ad381cd7cbda3fc41d7b48b896e1ae669a73b5374ec589507383b81e39e830066bd83c0ff11e2f11e21d405bdadd48c16244727cd6f989da3b000773fd29c6b27a32e3513d0f42a29aac18641c8a756c5851451400534b051934ece2b86f89dac49a6785256b4bf8ed6e4c88012e0330cf20039ec0fe00d4c9f2ab89bb2b90f8e3e245af85ee3ec514467bbc0660ae3e41d4e4673d31f5cf5af0df19f8ef54f175c99a755b78e0dad1c08e76e3a649ce4b127d0718fc70aff53bfbfb8f32691af2425638c3be58e3000f53c63bd559235711cbf3bcbbb0c3192bce78f7c7f5ac2ee5abd8c1c9cbd0bd25c473406260bb18614c6b805b18ea473ef55848f0dd3189362b603315ce3d73fe7b54d1ac9752b4e646cef01500c819e809180723d3d297538cdbda2e1f6248c15e35e7d5810718fc07a566ac9d8cc8a58dee4bef6f3153ab8704803ebd491daa78c48522720cbf2364b0e14f4c7d7e9c8aac11f646cac5d00dc5d1f2cfcff17b8ab1e6fda24891369c3e49600053ff00d7f4a5aad8453bb1247218e17756404489b8e00f41d689a09dc2a8064997ef1572c7eb9efed834ed4dbf788228d0485c97dad939f7e7a52c4d3e1564711ee05f0e70b8ef8e7a9f4ad16d72fa0f30badaab484396380aed96c8ec0753c9ab5a4ea33e99742f6d4cc93c60ac6d1a85009c020f07391907eb54a79e61289db6b2e7070bf2f1d3dfbfb53a180c9c9972c50e237dc021cf5c7d39a96bb88f61f08fc5f6b6b7fb3eb693cd33cbb8cbb97804fdd0a00c63803d726bdae0984a8add32a0e339c57c6513856c92bf28c6e001e9e9fe7d2bd53e1e7c44bc8afec348bd94bda01e483e580c39f97278e72793dc01550a8e2eccd6153a33dfe8a6a1c8a75751b0d6e9cd7cd5f146f2ea0f135eda5edd44227918c50c641dbe8cdd70c70091e9f5afa42f1b65ac8d92308791f4af93fc5e97875f94ea718179bf75c64fcdbd80396fc3f2c62b1ab2b5919d47a1cd476d3dc36f50bf21df18c1c313e9db1c568f911456f2cf26dc11b64f2beec671c63fcfad429711db416db6671b461c28c6f39ed9e9c1eb4ae8b290500dbb4908cdd7a0e09ea339fcab2777a18b06bb58dc1495515d40fdd8da08c756cf1bb8a70b88ae2d31bcb3a38731b0395e3ae73fe73502c492a6df310471a9288cb9e7bfbe7dfdaa4692148d9f3b9d86ccaaf03b60fbfbd4da3b12ec4f0c588a478b771f326e1cafaedc1a7476e6311b8901327ef0bf1839ff000a8219a448be74910b1f92404e79e368ed8ef5085533ef40884a85eb93c75a5caf5b8ac4970b28b9511b29c0c3123e53ee7d0fb5456b1f96591cc512c87e62ed80719c03e9cfa55892583c92f0a852d90d1ca727af18fad221610b2387dcc8176cdd38eb8cff00915717a58a5d8a2d1ac924a7cd3236fda0386248f5c9ad48e189edc3c6abe76d0e58f050671d476e41aa52a87bb522289107544e9566e2e2365119b23b64552ce8c41563dc03d88ed44aef61bd46b32098c318f3228b3b4b8e4f393db91927f4a9ad9ae74fd420b8390eacaebb58ab0039ea3a671d6b3adda78d269da394aa6102b1000c83c9fcb356445744cb24d26d641b4956cede38e3d3d87a52920d8facbc21ae41af6816d7716c562837c6afbbcb247427d6b7ebccfe0fddda8f0f9b0b5b768bca6deeccc0f98ec06e2bec0e4735e995d3097346e74c5dd18de25d55f46d1a5bd5844c130a5338273c71ebce38af96b5d926d675296e66964b97076c729fbcea385cfbed02beb3d474eb5d52c9ed2f22f3607c6e4ce33839eb5f3f7c5bf09c3e1dd460bab0d91dbdeb3ec863e18303b9b27a639007a0e2b2aca574d19d44f73cca24c3168c82889b49ce58839cf07d307f0c55e816d9ee9d5627f26384286c6ee41cf3e99ef4cb4264d45e158a201830577936845c724fa9eb8fad3a3b669199407c04048cedc81ebdb18c544a5d0c591472f91e710bb1db1863c67be01edc7e751cb215915cefd9b7018819cfaf1fceaec852ea758e652c321f7a63e41fd78c7e74db88095f34a104908a921cb6d23391edc7eb5319771221b41f6a4091b2e2307e695be5049ed4341e6dc4a8761653f7bee8f5e2a6b3f252005a224756607846e4e07afbd59859e68669e3556006648d901ffbe6a652698ba99cd1b5adb3cbb1240ff2b2939d87b1a9e69ae8ac6d3464c0002553a03d327b8a956ed6d8fd9d23f2ddd3322b1dcaf9e841aa6d13c6c92162eb245caa3e0a8cf46f615a4757a9488a3bf78bca0f024b0c2fbf6ecc6eed8dd52dbc9e6dcc9b5918291206704924745f6fe5c5472b2fda81b43b611b479523e41ec00ff3c55fb4b413cde42aa4802b15fe10303bb771ff00d6a6f4d87e85430dd2c91cad16c8ce577b721b91c73f41ef535c451b46ad93248ec4944181d08c01dba9a7d94c8d2c6b791930f99b4bbe708debc1ea0532625eea5f2588b61f7982e393d0f3c8e7159bbdc9773d37e096a179fdb9258a401609230f24bd71b472003ea48e7b57bf0e82bcf7e13e8b6767e1b8efd228fed573f3310bca0e0639e7076e7f2af43ae9a29a89d3056881e95e19f1aed61375034304a92b02d2c849db274e07d303f3af73ac6d6fc3d67addb959e35f346024c572c9c83c7e54eac1ca364392bab1f26cd345e495c4b2c924a012ed803d49c77e9cd4976a9728e123b92d192ab9c9053b1c7e19e7d6bbff0011fc3abcf0f5e1bd58bed768232ccc4720ee23a0f450a7ebdab869163f3846cd32c9f310a899e7bf3c73d7f3ae5d63a3473b8d884426ce752aa4c78db2e70c704f39e83d38ab8f247343b1773ca1c6c665c0083aaf1d074fe951c16a8fb2662be497f28fcb95041cf3ea73539bc96ce6291c8410489581f95f3dff000c638f7a873bbb11728cb6aa96c7af92b8de083c313dbda9890bcb0c64cdb21c95089cb67dc7500f18ab28d3c88d2b5b334733953228e153b800f53d0fad451abc93b87caba9d9bdc95ddfddcd352760445014825e50ee2bb4330ea7b81eb49730bbca30a3e75db96e037a8a99d64bc816d2669124b72edb5faab13cfa63f5a90cd71f664b589a42f192550443728e3049ee2a9def74377335ac12dc2b9f346e6c32a8cecf51fcaa4974e786d5a5024db8fbac7a027ae3bf4fa5685bbc77b7eb049e60380ed85ddc6393c7b8cf7ae8a0f0bebfad5a3dce856825b50e44476e1b6e318393c83fce8e695ec3d5b38e805bdb2c693b168e4024623a0cfa7ae2b4f47b29b5ad62d6c2c9157ce94461d8939feef07f3f4ab3a5f83b5af10ceb69069c5b6b9df39cfcb827396ef8e07e15ea9f0fbe1edfe87e24927bf8d963b6887912315605d8f3b463d323db357cadb2d45b67a5e85a3c3a1e93069f0c8d2244080ee064f24f6fad69d201814b5d4958e80a28a2980c78d645daea194f50464571baa7c38d22f1bce811619f6b86631ab6fdc0e7a838ebdba607a576b4526930b1e131fc2cbf37725a41f6a8ac9159edda60aa65718e0ed2428ce48f5c73835cfebde15d5bc336535c5f645b3bed330405495e831e8493d7d2be95db5c8fc4bd37fb47c05a9c4abb9a3412a8ff0074e6b2742266e9c4f989bc402285c46301b3fbb65e338c13c74cd53b7d4ae2321d76960368247207a566483f7983d6a68c6171fad0a115d0cdc6c5bb9d467977bcacccec41dc588e9d338eb4db3bc696f40b9667079de0e181edcfeb5525e6a5d2e16bad5eda051ccb2a20f6c902ab950e27d2fe13f853a25b691a7dc5fc467bc1b662d9c7519da7d4735e8b05b456d1f970449120fe145007e94b6d1f936d147fdc455fc854b56a296c6c9588a18228102451a228cf0a3039a968a298c28a28a0028a28a0028a28a002ab5f5b2de58dc5b38cacb1b21fc462acd1401f0f6a96cf63ab5d5a48a44904cd1b0f4c1c5361209c1c7d2bec2d7fc13e1af13babeb3a35b5d4abd25c1493e9bd486c7b66b262f84de0686dde14d05423fdecdccc4fe65f35362390f94a552a4f1f90adaf0058bea7e3cd1ed234676374aec00e8aa77127db8afa3d7e10780d5f77f6086239f9eee771f917c5751a4681a3e87118f4ad2ecec95861becf0aa16fa90327f1a12050b1a43ad2d14551614514500145145007ffd9');
INSERT INTO PRODUCT (NAME,PRICE,DESCRIPTION,IMG,CATEGORY_ID,IMG_SRC) VALUES ('Rosebush',30.00,'Easy to care for pink roses','rosebush.jpg',1, 'ffd8ffe000104a46494600010101006000600000ffdb004300080606070605080707070909080a0c140d0c0b0b0c1912130f141d1a1f1e1d1a1c1c20242e2720222c231c1c2837292c30313434341f27393d38323c2e333432ffdb0043010909090c0b0c180d0d1832211c213232323232323232323232323232323232323232323232323232323232323232323232323232323232323232323232323232ffc00011080077008003012200021101031101ffc4001f0000010501010101010100000000000000000102030405060708090a0bffc400b5100002010303020403050504040000017d01020300041105122131410613516107227114328191a1082342b1c11552d1f02433627282090a161718191a25262728292a3435363738393a434445464748494a535455565758595a636465666768696a737475767778797a838485868788898a92939495969798999aa2a3a4a5a6a7a8a9aab2b3b4b5b6b7b8b9bac2c3c4c5c6c7c8c9cad2d3d4d5d6d7d8d9dae1e2e3e4e5e6e7e8e9eaf1f2f3f4f5f6f7f8f9faffc4001f0100030101010101010101010000000000000102030405060708090a0bffc400b51100020102040403040705040400010277000102031104052131061241510761711322328108144291a1b1c109233352f0156272d10a162434e125f11718191a262728292a35363738393a434445464748494a535455565758595a636465666768696a737475767778797a82838485868788898a92939495969798999aa2a3a4a5a6a7a8a9aab2b3b4b5b6b7b8b9bac2c3c4c5c6c7c8c9cad2d3d4d5d6d7d8d9dae2e3e4e5e6e7e8e9eaf2f3f4f5f6f7f8f9faffda000c03010002110311003f00f7fa28a2800a29923ac68ceed850324fa5615e788d229984253cb4e199c1ce7d293696e694e94aa3b451d0515ca3f8a9e284b48f129c6e1f29e4633eb5bda7ea969a9c1e65b4cae4005933f32e7b11da8524caa942a5357922d4858292abb9b0703d6b8f87c75024d00ba58cc334e2dc3c59cc6f8e8c0fbe3f03deb17c55e38f10d9f8b1f4ef0fdb5a5e5bdb46a67575cb799f31642db805385e075fad6578b6dad06b169ab69f6d72b1cd2c726a1287578a125b96da3e6c824fcdd319c7b65526d7c2447e16f96e7b08e951b4d1ae773aaed19392062b88f18f8beff4ad1ad6f34dd82686706fa2281f6a0254af51d5f18c1ce391c66bcc2fedf55f166afa8189e37b4899a79af98154110e7247a90090bc9e31db213acaf68ea64deb63e8a1c8a5acad2f57b6bd84e1c2345b55d588c7232083dc100f3ec6b50104641c8ad93bab96d34ecc5a28a298828a28a002a36955080c42e4e067bd494d740ea548041ea08e0d003268c4d0bc6dd1d48af2fd5e2b8d37744d04e1ad9bcb12ff000cc98e0e73956c1c720f4f4aeeb5013691b6f2dee145a06027b698f041ef19fe16ff0067a1e98079a9047a5ebcbe74332cca061bca7c1f60c3a83f5c1a892b9d386af2a32e65b1e452ea52ea5730e9da7dadef9f720aa48fb7e6dabb99501243100649cfff005eff0087b5dd62fe0bbd2bc32639af9995649a41b45ac438dc4b7de249206178c1e3a5765a15be9da7692f637fb47f65ea92a5b33925c1625e3db8e4b14900e3ae48ac799ed749f18ddea5a3c5a543aadeaf94d69757062691b219f9525448495e0f5c67ae6a145277b8f118c9d68f2bd8e4fc297d672bea114d76f25ebcd99277762d23213824127ebef9fc069ddea1263ed3133c4e832ac0e327d71e954f57d023682ef50d1f437d2ee5e32f7915c970d14acec30a705704b0c608c803a0a8754d02283315a697afea774d12f9518df1a2617e690c98f9f7609000ff0001093d99ad1c6aa70e468c6d5bc4315e6873e992e93e4decf74931b8da15d55542edc000927049e99dc4f5acab6b9bad1351bfb461222142b21914a30008232b9ebd383eb57bec7afdfda5c8fec39231a728b99a695364b1260f396da482173dc9db9ed51e9d71736f35a4571a8de0d2279246d4238982ae1bfbe39df91fde1db03b1a86acb53cceb73a9d0268751d3f574bd9e4bd8a5d28c6b0c6ab1ed0920087e63f7b2c3af1f5efde7c3abcd4e6d1a682fd36c76ccb15be5d588551b0a9da4f20a939f7e3815e5696d657d0d8c76fe6dbc913cb136c949671bc6324f4450bc0e7a127b556d3ae6cb4a135c38bbb868e66106f9708814606e553fc4493f45c773514ea38ebd8d56bab67d1915d4134924714d1bbc670eaac0953e87d2a615e39a078c34fd1359884ad248b25b244e21236872c097233ce01faf26bd8948e99cd76426a4ae39a4a564ee2d14515648514561f8b35e97c33e1e9f558ec1af440577c6b204c2938dd9c1e01233c7bf6a009fc41a6beada2dc59c6556472aca5ba655837f4c7e35e4b378475fbd5d4260b7165ae5842935b24136df3d8b10eca47aa8e80fde23d715b3e1bf8c916adabc363a8e97f645b8904714d14a640198e006181c678c8fcaaa78f7c57a94be2586c34949244895b0f64f996407865f977606571823b03e86b09a8c9a92173687150dd49e1b6b4d6af7c3a9751cd19dc2ea4759229417dae573f74f38246085c6410c4d3b7bb37d6c971323cb263e777392edddb9eb5bf7372351492e347f09c13bda2c71621dce63521b22451feb776c209c0efdcd72b7fe239b55fb35b1860b28ed22f236dadb900228c019ce4e063a927deb9e6b9e364431753d516e5e3496f152452c8c19893f8fa006ba4f0af8b6e3c3d6d3a8b9996795d641318d248a503002c8db4c9b40ce369e33c63ad79b49672e5774bf313cb119cfbd5fb192d22819dae543a4be5210480467ef7201e7ae4e3142bd3575a8afd8f40d4fe24dddc26ac6e3ec71c37e8b14fe46e62a806300b1c0c86208c67af00d73534f691df016f0cef6a6406247c33ed072031181938c7a735857a6d23d6becb7976b1c4909759648f780f8caae1477c0193c0ce6a9dadd105ae259dbcbc90a50e73ebf95392728f331b35f51d4ae2d655d3e1958f93c5c3aae4b4872cf827036e4e3df19aa1631792ff0069918b3386da1c72090464ff003fc2a44b732c07c9494c6e7799247cb1079c74cf35d4cfe12d675cd126f12c9a8c41d1c620ba4f23cf24f5572155c96cf1924e3d69422adca84bc8a5a0e93a86b3ab4567a7c6b33315cc7b780b9e5988fe11c679efc57d37a5e9b69a4e9f15959c6b1c318e15542fd4e057043c7b67a37832378ed34bb5d7845b9b498a550aa43609f97207cbf3052738e339a87c0be2af1b78b3568ae6e2d6c61d16366f3a48e129bb8e154b3124e48e831c1e6ba6168fccb5a1ea1451456c505326892689a29235923705591c64303d411dc53e8a00f32d77c07e16f0a595df8820b1bc2d02e63b6865caab92002a0f4c139c93818e9dab91d2fe1ff899ae6c352d18c514722a4f0de2cfb768619e47dee9c1183dc735eed736f0dd5b4b6f3a0921950a3a1e8ca7822b0bc3ba4ddf8737e96b2bdce979dd68ee72f00ef1b7a8f423dc1ed98705725c533ca3c57ae3691e21bfd3a7b28cdb5c3a8bb96c9da094314dce11bfbbbf2e0303c96fef1ae7b56b5d66ca192db5296696cc37fa3bbe64f363392a7cc5e1873901b0c324803903d2fe26f817fb52dae35ab081e7bb014cf6ca47ef157f8973fc4001c77038e7af955969d249a2ddc36da57daefcbc52fdb23948238e50e4e1b19f4ed8cf4ac26f95d989a6ef733649ace1d2eeeca68e38eea5915a3bb6decd120e5822a9c12781823a13c8ac79134f9aec4724971f662e42ced08dd2672012bbbe527209193d28d562d4437d9ee6d9a06071f3c65580f6ef8fa75ac99ae0884c334ce41c70e3dff3a71f212d8eab4cb3f0eda09e5d5775fc81804760d8231d36f0770c77e318c565ebbaae90f73026956325b470b10e51b6ef04f38eb83db3efed59d002a76a3fcf22e0396202fb9f7e98a8534f6f308f3323a73d0d34b5d47d4e8748b8bdb99adb4b8608e6b9936c71104b866238181df3c7a0efd2bd0754f01ebda527daf56b5bbd47494816216d149e7c903f9413cc11a800eddbc1e382339c1af3fd3a0d4833df4127d9d2dd702e4bf97b5b070a8c39c9e46057a6782be295fe9f0a596b17675000e50c8ac26d9ecdfc5f8f5f5a95ca9ea5423cdb1cd5c7803c416b656b041e1bbe9ee674595e7da155011c47b5490a475258e73c6077f44b6f869793e8f677fa799bc37adc716c92dd67f3232c0632195895cf7e4f5e9dcf69a4f88352d6658e4b6d2615b07049b97bc059483f74a05ceec7be3deba31d2b58c23ba0e5b32ae9b0dd5be9b6d15edc7da2e92355965c01bd80e4e2add1456a30a28a2800a0d148680395f1cdf4b6da4476f1360dcc9b58e71f28e48fe55e0dab5d345a8cc8b249137985e34b772aed8e0f1fc5d70463f1ee3e87f14692dab693b23199a26de9efd88ff3e95e07aff87efed6f1f53b38a4b9950e5adc3eddc39cf07af53c579f5f4adef75d8eb8c39e87bbba7a9ccdddcdedd4d2412ea17325b42379865959b60ebf77383d3afe95cededa89126b961b55586d50d9c8ce393ffd615ad7725c5c4f05ddb20f31c14785800cadd1908ef918e3a9cfbd42d0b5c4323dc24c91370902155c9c8e189ce3af1d4fbf7ade3a1c9ecdf42bc178f3c1e4c42d0631f249280cd8f7c633efef5ad144d756988b4f8c2950e5ee581443d893fe354eded0db060ab0da3371b8b96671fec2e3807d7afbf635ef638cc4233712275c236e663d339f4e3db8ab6d5f41b81b1a76bd2cae2db53861bdb742551846a15073f741c01dfa552bebc8f4fb806079a06590b4680e576e7382338247f9c551b23135d39ba1e55bc48c0e393d08007727ff00ae6b7f48f0b4fad6a22fae9244b01860258f6349ec0649dbee6b29b515796c69469394b43d83e1deab326b10c009115dc787523037019071f87eb5eb43a579f780f42905c9d5a68f646aa56dd718ddd8b7d00c81f5f6af421d2af0d7f67a978ae5f6964145145741ce14514500145145002374ae23c4f606dafbcff2d5e19f9c11d1bbff008d771599add91bed3258d46645f9d3dc8ed5cf89a4aa536ba9d185abecaa27d0f29d4b41d1b5307ed51049186d2e410c47a6e1cf7ac393e1f5801b6cefe48d09c901d4e7d79c67f335d7c899ce4647bd5296da063f32107e95e32a938e89d8f765469cb56ae721ff000ad63599645be0ac09663e52e49ec7ef54afe01d3ccfe75cdeb900e400ca36e3a75cd740d696fe9fa1a45b6801c842c7fddaaf6f51fda33faad25aa899d63e1df0f69a41b5b58e4901c872bbce7d416ce3f0ae8b4eb17d4efe2b78d36ef3c93ce07726ab245e8a145765e0fb029e65f38edb23cfea7fa569461ed26afa935e6a9536e3a1d7451a431244830a8a140f614fcd461a9ea0d7b28f058e079a7500515420a28a2800a28a2800a4c014b48464500719e24d2c5b5c0b988011ca4ee1e8d5cf3a9e7231f8577de20b492ef49916252d2210eaa3a9c7503f0ae08c81b39ebdebc6c653509dfb9ee606ab9d3b3dd15d85376f35292298645504d72ab1dacb7a7d835f5e4700f9771e4fa01d4d7a05bc4904090c4b8441800572de10b5967966bc2a445b7cb463fc473ce3f2eb5da471ed1d39af5b094f96177bb3c5c655e69d96c8234f5a940c518a5aec470b6145145310668a28a0028a28a0028a28a004c5656a1e1eb0d458c92446394ffcb48ce09faf63f8d1454ca1192b495ca8ce50778bb190fe07899be5bf9547a1406acdaf82f4d81c34e65b923b4870bf90eb451592c3524eea26b2c55692b391d0c71a451ac71a2a228c055180053e8a2b7300a28a2800a28a2803ffd9' );
INSERT INTO PRODUCT (NAME,PRICE,DESCRIPTION,IMG,CATEGORY_ID,IMG_SRC) VALUES ('Muffins',5.00,'Four delicious muffins served piping hot','muffins.jpg',2, 'ffd8ffe000104a46494600010101006000600000ffe1001645786966000049492a0008000000000000000000ffdb004300080606070605080707070909080a0c140d0c0b0b0c1912130f141d1a1f1e1d1a1c1c20242e2720222c231c1c2837292c30313434341f27393d38323c2e333432ffdb0043010909090c0b0c180d0d1832211c213232323232323232323232323232323232323232323232323232323232323232323232323232323232323232323232323232ffc00011080080008003012200021101031101ffc4001f0000010501010101010100000000000000000102030405060708090a0bffc400b5100002010303020403050504040000017d01020300041105122131410613516107227114328191a1082342b1c11552d1f02433627282090a161718191a25262728292a3435363738393a434445464748494a535455565758595a636465666768696a737475767778797a838485868788898a92939495969798999aa2a3a4a5a6a7a8a9aab2b3b4b5b6b7b8b9bac2c3c4c5c6c7c8c9cad2d3d4d5d6d7d8d9dae1e2e3e4e5e6e7e8e9eaf1f2f3f4f5f6f7f8f9faffc4001f0100030101010101010101010000000000000102030405060708090a0bffc400b51100020102040403040705040400010277000102031104052131061241510761711322328108144291a1b1c109233352f0156272d10a162434e125f11718191a262728292a35363738393a434445464748494a535455565758595a636465666768696a737475767778797a82838485868788898a92939495969798999aa2a3a4a5a6a7a8a9aab2b3b4b5b6b7b8b9bac2c3c4c5c6c7c8c9cad2d3d4d5d6d7d8d9dae2e3e4e5e6e7e8e9eaf2f3f4f5f6f7f8f9faffda000c03010002110311003f00f7fa28a09c50014500e68a0028a43d6aa6a1a8dae976325e5e4cb0c118cb3b7f9e6802e1e94ddd9e9cd797df7c66d36067482185013889ee6e00cfb955c903dbad79e6bbe32f127898f9e9e215b7b78be5f2ace278e327d431209a87346b1a327ab3e92e7d29738ed5f2ec1ac4c2dcc73ddeacf8e58cd7921673ea06ec7e55b7e13f16dd69739bdb2babcba8c82af0dfdc4b22fe193c1a4aa16f0efa33e891d28af35d23e2ee99757515b6ab07d84c87093abef8c9f7e323f1af468e549115d1832b0c865390455a69ec6328ca3ba24a29052d32428a28a0028233451400018a28a28010d785fc57f11dc5e789a1d0e1ba8a3b4808f390be19c9f6af743d457ceff16bc3915bf8d5b52598ccf3c6255833b4ab0e0f41c83f5aceafc26d43e33955d2ece1d40ddac1133b12c8bb7216b50cc248b6bb2ede817230a7d2b0e17672dc3c454e3e7f94a1edd8d5e594dbb8693e64618c972c49ef9038c7d056076e85c6b75653803728ea39c5537d496cc3b4b2bed8977370783e99a90cdf29682609bb8f3221927d8a9e2b3e4b0b8bed53172eab145f312a4e1bd011ebfa53d18ad6d8892f26bf9d25b681e482339dbb771c9e70c00e05777e07f1cdde95ab8437865d2d8ed9ac64399206f55cf38ac08c9f24c707971119e783cf626b3dbfb3f5099ae6794c7347f2c92805449db1ce7a7a8a2f67743e5bab33eaab3bb82f6da3b9b6956586450c8ea72181ab15c6fc36128f09a891f72895c4601c855cf635d9574c5dd5cf3a51e593414514532428a290b6280149c0a4cd55bbd42d6c6d6e2e6e6e12286052d2bb1fb8319e6bcb75af8c137db42f87f4e13d9aab6fb9bb0630cfd0051dc77cd26d22a3172d8f5b26b8ff001d78363f14696de5bac37b1826294afe87dab82bff008c1ab3d97930c36905c1501a55c900f7201ac3d3fe356b5a66a96d1ea245e69ccd898f9789029ee3e9e950e5196868a9ce3ef1cb6a967a968f308efe3911c2f120f995874c8359b0df1972ea3cb788feeddbf5c576d16beaaa16cdd5e29eedb7452a860e8d9e707a552d42e34bd634e9e4bbd36389ede7f26292dbe460bea4743586c757333222d403024b82e7ab1c64fe356e378366ece08ef9e735461d134e7b579ceaf2c6be62c688d0658b13ed5b09a168913b46dabde48f0a169c470756071819ed414a7dcce6952604be4b139393d7ff00aded5a767a75f6be5ad2c21492e8edd836f118eec4fa575363f0fb49bbb64d4a2d5a66b0c12fbd4214c75c9ae97c39e2cf006856d1c3657f16e73b59c2927fe0469a8736e4caad97ba8ee3c39a5ff646896d63904c4a0311dcf73f9d6bd72ebe3ff0ce2e1bfb4e311c3b7739076b13d029ef5a5a7f89348d510b5a5fc2e400594b608cfa835d0ad6b23864a4ddda35a8a6248aea082083d08e869f544899ae07e24f8ed7c27602dad1836a53aee418c945ce338f5f4aef18e00f738af9d3c53a83def89b52bb90fef1a668c6ee4aaa92a07b0e335139591b51873cb53123bfd42e25bb4b9b8795ae76c971199890481c67dfe6a56ce00625c06fe23cfd6aacaff68895d5c0663c374229d119e629fbe8fcaf998391824827e5358a3aec49288fe6dd0ab16e07fb35ccead041a48528ad24d212db89c8c574065592df3f22c838dbbb9e2b9eb917175a8496bb58b6df95dba014d112d8834fd55bf74f9dad0b718eb8f6ae8edb4ed6352b53259e9d75344a37978e3241c77adcf057c36d253426f10f88ae3ceb460c22b68c953b81fe23ebed5d55c78db515b58f4fd1234d3acedd36c647242fad2972a771439da3ca1a1bdb531c7730cd6cc6512949508271d315664d4f6c9210c4390a481df9cf35d75f5e5f6a56d10d5664bc39c2c8f8e9e99ea2b91f106913c41e6d3d4a9518957aedfa54a69bb16e0e2ae3355f11cd0e97240d3c84ce7fd4a310abf8573ad7b22c68f122c11be372a73bf1ea6a18465dcce9bc9382cc7906b5e1d2e069d5104b2ab1c100642935a2e58e8656949dd1a7a75fb5aa4735aca1ade4f965b472390076cf43deb453c411a5dc8f2b450909ba1591704f620b0ef5cf41639bd8edd10855db116c7dee0e5bd8815764d0fc9bd8766fb98dc152eff7a23ebf97f2a4ec68b991ebde02f89505acd168baa0105b9205bccc4ed52dd064f6fe59af6356c8eb9cfa57cb16521b3922b2d4585cdac9fbb8a575e54ff74fb75e6be85f045fc97fe15b5698e6584b42c73d429c29ff00be71574e57d0c6bd34bde46fcb9dbc57897c41f08df5aeb136a3a7dac935bdc132158c6e647ee08f4cf35ee2466a8ea56867b0b858d8a4a50ed75ea0f5aa946e674ea7233e4e69da19228f6957c8f343ae3031e87bd45218a45e64738273f3601cd7a4c9359ebb751d9eba9e75b664dd3c6a1668e445e0823af19183d857357ba0f874d9dadcc336a6893b3a7ce54b061ce71d3a6e18f515ce8ebbf7399335ac6a3f70be83279aafa7c57baa788234b5b6b8b9472a9b621f7867a66bb1b2f01e9d75a843e6ea17325b88c4cdba30b919e1723bd77da1691a75b6b3048b0c3043165e2fde7ceec070001d3f1a77e827b5ce5be2c6ad77a15ce91a3e9f0797642005231ce5f8e0e3bd79dea09ab85f3ae63903be3014e02d743ad6bb36a1addccf740ce6495b04f4419e31e951ca6d65b6dea4acc3fbec4863ed43975b1518f4b9996de2506d63b5b8b52cecc17729fd6b59351637b2a966529180229060499aceba8adedf4c699ac1639d4f0c4f20e7afd2a4304f2cd12bcab265031909c0c1ed814249ea82f28e8ccabf96def09ba8e210c89218dd47434b6a70816194c7203bd083d0fa66b56e745b7b9d1e18229825d2ce5bed529c23291c29f420f7a2d7c03e2454dd1d979f1e71e6432075cfd45326faea6768da83c17935b4e5bce24b6e3fc43b815b8972c85dd0838041c1e9ff00d7a47f86de2892f21b91a739555c655b9561fe39ad68bc1b7f6f76f05f6a1656721f9fc96cbb60f3ce3818539fc6a6454656dccdba83fb415d14b07119d80766c1208f7e2bdf3e1b69977a5781ec21be045d48be648a7a8c80003f80158de06f03e8b008b548e77be9460abc8bb42b63b0fcabd15502f4fad6b4a2d6ace7af514bdd43e98c29f456c731e0de31d34e93e28d5628863cc78ee2003a05652a71f8e6b99b930f931c1bb7a2dc49275e9cb8e3f3afa0bc45e16d3fc4b6c23bc5649507eee78ce1d3f1f4af2fbef83fad43e60b1beb5b952c4832028d8273db8ac1d369e87546aa6acca9e1dc5cf876da4946d049507d00ad9d3369b8b811024ac3210fe5f4c03c66b2468da9786b48b7b1d42348e6cb728f90413c73567481742f234918152dcec9ba83f8564f47a9adee8f25970c59c48aaa5b1d7a9ef510f3363630d11391dc8a9355b18d3529e292352229a45600f7c9e6a38cf0aa085534d5ac3d59a177219f479178122a80dbba6295152dedfccf3378650a7d16a2d924963789b948f2c95239c9a8340bb8afc343392988fa8ee476feb4d6da0dd9bb1ad6eac652258d9e19fe5f2d7a74e3e95a7a76ab73a4e9d05adadccd132de2ee313e036e233fd6b32d525b6bcb54372ce7ca767c1e40ed9a27b5bc93c836f6f733a2807cd8616652c39ec295f507b58e9a5f19f882e5af241a9c88cf23c2be58c040541e07d15a9a93b5cdc5dcb27fcb732471e4f23e751fa2ed1f9d51d3f4cd4e6b968a2d36f9f7397e2dc8c165c77c7bfe75def86be1f5fdc5e25d6a917d96dc024c65b2ef9607f0e828e572279a31573d13c3364b61e1eb18106079418fbe79ad8c536340a8a00c003007a53eba92b2b1c2ddddc28a28a62131cd18a5a28038ef1de8ff006dd3d2ed033341feb154f54ae1207b184812590f3147cb279a467f3e057b4ba0752a402a460823ad79eebbe09bcb7b96bbd0a182e622493653cac9b4faa3038fc0d65385ddd1bd2a892e56790f8ead51b5e37b0f11de4426553b720f46071ef8ae563dc24c7cbc0edfe715eb7abe8bac6bda1dd5b5fe85736375a7b092d84a448b303f782b051dbd49af2d9adcc721053691c6197a560db4ce88b4d685bb12a2606241f28dae064023d6b0dad8e9faaca0460472926325b00ff89fc6af892556531b3b60fce1091c7a7bd3f59486f65b75dca891b02db46769c74e7a9a707ad826b4b9b56b3c4f097645d9b36ee5fbc48ec7ff00ad5f4478374eb7d3bc2b610c166b681e2123443b31e4f5af0bf855e1b7f10f89a29a43bec74df9a424e4331e403d89afa4d0607402b6a71ea615e5f6402e3a52e39a5a2b539c28a28a0028a28a0028a28a00290818e94b450045244b221461f2915e55e3af86b25dbbea1a3c6be613fbc880c6ff00febd7ad526da9941496a5466e2f43e53bcd0b56b09fecd369f751cace170d6af8fa060304d6fda7c21f157885e09a67b4d32d4fef37cb969076c6cc7a7ad7d17b7ea7eb4e0b59c28a4ee6b2aedab2460f84bc2b61e10d021d2ac41654f9a49587cd2b9eac6b7852d15b1805145140051451401ffd9' );
INSERT INTO PRODUCT (NAME,PRICE,DESCRIPTION,IMG,CATEGORY_ID,IMG_SRC) VALUES ('Apples',5.00,'Three crisp apples - your choice of red, green or golden','apples.jpg',2, 'ffd8ffe000104a46494600010101006000600000ffdb004300080606070605080707070909080a0c140d0c0b0b0c1912130f141d1a1f1e1d1a1c1c20242e2720222c231c1c2837292c30313434341f27393d38323c2e333432ffdb0043010909090c0b0c180d0d1832211c213232323232323232323232323232323232323232323232323232323232323232323232323232323232323232323232323232ffc0001108006a008003012200021101031101ffc4001f0000010501010101010100000000000000000102030405060708090a0bffc400b5100002010303020403050504040000017d01020300041105122131410613516107227114328191a1082342b1c11552d1f02433627282090a161718191a25262728292a3435363738393a434445464748494a535455565758595a636465666768696a737475767778797a838485868788898a92939495969798999aa2a3a4a5a6a7a8a9aab2b3b4b5b6b7b8b9bac2c3c4c5c6c7c8c9cad2d3d4d5d6d7d8d9dae1e2e3e4e5e6e7e8e9eaf1f2f3f4f5f6f7f8f9faffc4001f0100030101010101010101010000000000000102030405060708090a0bffc400b51100020102040403040705040400010277000102031104052131061241510761711322328108144291a1b1c109233352f0156272d10a162434e125f11718191a262728292a35363738393a434445464748494a535455565758595a636465666768696a737475767778797a82838485868788898a92939495969798999aa2a3a4a5a6a7a8a9aab2b3b4b5b6b7b8b9bac2c3c4c5c6c7c8c9cad2d3d4d5d6d7d8d9dae2e3e4e5e6e7e8e9eaf2f3f4f5f6f7f8f9faffda000c03010002110311003f00f7fa28a2800a28a427da80168a6798376dc8dde99a7e6800a28a2800a28a2800a28a2800a28a2800a28a2800a28a43c50032699218cbbb60573babde49a959c96d6d792da96e3cc8b1bbe99f7aa3e24d51e4bd369131db1f5c74cd52b18e465dd1824f56af23138ef7fd9c0b5138bb8d2356f098c5a19a6d3d9bcd79a29198a38ebbb938cff7b8cf7addb4f1fcb2dcdbdb5bcf2ccaf196672c095c71823a93d3f3ae824b896ddb254a91e8483507f694858b12dbbd4f26b95e29757634be9668e8ecb53b83007ba014ff0075b86ad4b7bc86e47eedc13dc7a5700f7a4f3ba96d75492d2e52547e8791eb5d34731d5264381e8d45416d70b736e932f4619a25b94847279af5b9e3cbcd7d08b37a227a2b1aef58102e78cfd2b164f16c88e50b20c83b491d4d724f1f460ecd9b430d525b1d3ea97f1697a5dd5fccaed1db44d2b2a75200cf151e8bac5a6bba5c3a8d93968251c161839ee2b84d5fc5cbaa18747950c76d361aee4438611671b71eac78aeef4cb9b096da38ac1e3f2a250ab1af1b00e00c56d4ebc6abf75e82a94274d7bc8d0a28a2b7310a639da8cde8334fa64a3746ca3b82293d80f38972f78f2b725bad6b6973c71385240c9039accb94d92b019eb8a67ccb19693e503a0c64fbd7c8de6aab691d70a529e9146ceb0d1b12e18654edc561b373ed53c57fa4cd9135c5c48ea4ee0180f5e7a7b1a62dde8b7329b749a68e4f7607ea7a51569ceacb4b1bc707557d9667ccc37706abf9d861cd6adc69114a0fd96fe366ec241807f11d2b95d4249ec2ecdbdcc662997f85bb8f51ea3dc538509adc895371dcf4ad2356d9a688d1b739391edebfd2a692667624fcded585a110b62242324a83f856d5b12cb1b91c93f77d2afeb53a9685f445c6928ea47730ac996c1e98da4ff2f7ae135fb2beb4d4a0b88ade69adb7fced1a1631fd71dabd326b6f317728008e9c5637cc6e1972084fe744e2e94aed5cd294aeb4388d2c1beb9baba8e301a77dcfbb388d4708b81dc0e7eac6a4f3afb44bbfb45bde26e5396d90b0cf7c13fe35d8080042bb8852738ac8bab08816fbc0f50d9c9fd6b6a75d2773a14d35691d9f86b5f8b5eb012602ce9812283c67d47b56e5797681732e97e25494645b5c1f2dc7403debd4474af7b0d57dac2e79389a4a9cfddd98535880324e314eae67c77ac9d0fc2975728712c988a3c75cb7ff005b35b49d95cca9c1ce6a2ba9c4f8a75b07559acb4893e666cb4a0e0a64f41e9fceb0e7b1d4ad60675be9836d39c30604fbe0e7f4ac3d0d5a6b96965670a72598e463f1ff000ae92c97edece8e0fd9d172f201b48038f96bc0aafde69687d953a11c3d351874dcc74bd786e62570eaf237921890572c0edcf7ea314e36734da8cb72d0c9345bcfc83a019c67f2cd6c5d786b4a90c66592ec1dca465c750dc1e07ae39ad9d434a5b387ed36646f453f2e4e3ea2b175231d8ca35e6a569753196ed6d225cecf9b85456da4fa76e6a5b9bb1ad5a8b5b9937f97cc5232fce87dff97bd635ec5713c7e7cd1a125ffd62751cff002f6359eb3ccb70448fb829f95c371dbbf6e95a6b28bb334ad46125aee77ba25f795035bb1fde21008f5ffeb62ba5826f9064f3d8d796dcdfb58182f46769212419e707a13f8ff3aed2c7558aee358c4837b2e063bf4ce2bcc9d39537ccb6679f5292d91d5c17fbe1663cf1f2fb8f5aacccaa376064f5acf86603e541c29d9f88eb514f78763b63807007f3ab9d794924ce474acdd89de6fbc3deb2eee608acc4e323155ee6fbcadc1df93e9f966b32e6f4ca1503643123db0334e9a932d5365f5b952e140e92003fa1fcebd653ee0cf5c57936816ada96b30db8eccb231edb4107a57ad0e95f439743969b3831b64d20af3ff8b2ad2786a044ce4ce318fa7ff5ebd02b93f887a73dff0085a568865e0612e3fd9039ff001fc2bb2a2bc598e164a35a2df73c4d6e9e0b7960085709b41e9f36471fafeb5a9a1f88e1b168c5d6e64c80d86f7e2b02ea47855816db87caaf5e7b56489079c58939c6720f43eb5e5c68a7a9f64e6a51b3ea7aadff008834ebc56688b282003d3b1e3f91fceacdbdfcb716c6dfcd52edc827b0e95e570cd26d2e58eedd919e475e7f9d6c691a9ecbeddbcc8cca77027047a573d7a2da6d10e94153d0ea751e2e0c430ec3e53824e4d62490ac5a832ed2b19e406191f4fa56a4b751a48ca0ec2cf8e46722aa5c5e24b1b071928d86603fcf1c0ae6a7cdb1839b48cdd6971613444636e0aae7b6411fcaad785b52f995589520e01cf239a6dbccb77acd8a305655b950c080415ce483ebd0d50d5208f46d69decd8b58bbe50ff73fd927dbb1aedfabb9d1699c35ab72d44bc8f479ae408f707dbbbbfb9aa72cf81e4b4990065ce7927b561dbeabe75ba82c7819e69c27666dcc1033f539e9e95e6aa2d68c134d12df5e96650b08cfae391555e4695561889dcc3076f5c9c00054371293701172c0b05014739fc2bd33c1be108ec638f52bddaf74c018d3a88bff00b2fe55e8e1f0ce6d115eb429c6ecd0f087879b47b379ee4eebcb8c16cff02f65ff001ae9874a368a5af6e115056478739b9c9c9853248d658da370191810c0f7069f455127817c44f0cc9a2ea06458d9ad64cf96e33c75c0fa8cff002af3c6de1cb1c9c704d7d57ae69569ac69ef697918789fbe3953ea3debc07c55e0fbdd06ece50cb6c4feee619c11e87d0fb5734a9f2bba3dbc2e379a3c92dd1c9c772ea9244a4847e0803f2a4b7bb31cecc091db238a64f110e3861ef9aac5487c374c6466a39533b7db3d0e923d65da48dc7c986dc58f241e79e6a8c9a95c389429639ebd39e7ad67f0b102ccc3e6cf4c55cb1b39afcb25bae79c166e8b9f5acd524b6429d54b73534059a4bb6941c8894f23b330c7f2dd5ad2dbc92823920fb75abda669a9636ab6f0e587566c7de3ea6b6ed74b2e73b7f4ad544f1ebd4f692b9cd59e813391e53320f453c56edb785ae998334ec0e3a8515d6e9fa60451f20fcab761b4500703f2a7ec232dd197b79476672da7786d2d30e012ff00de3c9aec34691ed4081cfeecf4cf6352240a3b0a9962e2b68c147446329b96e6a039a2a389b720cf51c5495a1985145140105c1010af7358d7b671dd40d14a8ae8dc1561906b5a6fbe7e9555bad0c69db63cc759f86f6970ed25a33dbb1e768395fcbffaf5ca4df0d6f95b8b81b41ebe5fff005ebdd5c023a0aad22aeefba3a7a567ca8e88e22a2ea78d5b7c3c65c79ccefec3e507fad74965e1516e8a8912a28e81460577bb573f747e54f555c7dd1f951c8852ab296ece66db430a06547e55af6fa6aa7f0d6aa819e82a6502a94519b932b456e1074ab4a98ed4e14f1d29a4436340a917a52528e94c09e139e2a7a821fbd53d023fffd9' );
INSERT INTO PRODUCT (NAME,PRICE,DESCRIPTION,IMG,CATEGORY_ID,IMG_SRC) VALUES ('Fence Installation',450.00,'Install 100 feet of fencing','fence.jpg',3, 'ffd8ffe000104a46494600010101006000600000ffe1007645786966000049492a0008000000010069870400010000001a00000000000000010086920200410000002c0000000000000046696c6520736f757263653a20687474703a2f2f636f6d6d6f6e732e77696b696d656469612e6f72672f77696b692f46696c653a57657374746f776e2e6a70670000ffdb004300080606070605080707070909080a0c140d0c0b0b0c1912130f141d1a1f1e1d1a1c1c20242e2720222c231c1c2837292c30313434341f27393d38323c2e333432ffdb0043010909090c0b0c180d0d1832211c213232323232323232323232323232323232323232323232323232323232323232323232323232323232323232323232323232ffc00011080055008003012200021101031101ffc4001f0000010501010101010100000000000000000102030405060708090a0bffc400b5100002010303020403050504040000017d01020300041105122131410613516107227114328191a1082342b1c11552d1f02433627282090a161718191a25262728292a3435363738393a434445464748494a535455565758595a636465666768696a737475767778797a838485868788898a92939495969798999aa2a3a4a5a6a7a8a9aab2b3b4b5b6b7b8b9bac2c3c4c5c6c7c8c9cad2d3d4d5d6d7d8d9dae1e2e3e4e5e6e7e8e9eaf1f2f3f4f5f6f7f8f9faffc4001f0100030101010101010101010000000000000102030405060708090a0bffc400b51100020102040403040705040400010277000102031104052131061241510761711322328108144291a1b1c109233352f0156272d10a162434e125f11718191a262728292a35363738393a434445464748494a535455565758595a636465666768696a737475767778797a82838485868788898a92939495969798999aa2a3a4a5a6a7a8a9aab2b3b4b5b6b7b8b9bac2c3c4c5c6c7c8c9cad2d3d4d5d6d7d8d9dae2e3e4e5e6e7e8e9eaf2f3f4f5f6f7f8f9faffda000c03010002110311003f00ea95314e095204a705af7398f2ac46aa4734e233ce4e69fb6976d3b8588d547f152e557a669fb2936d201098f1d3351373c0000f6a9765376d52021d950dd2cab6f2186212c98f950f426ad95a4229b77449e3fe2abd6875078dd24b790f589f076700633e9d791eb556d6d2ddac96f67be4c18ddd949394518518f5e735e87aec2b73772f9b6367e5c31abcd737284ee8f3d011d4d79dea8960a6616704ed62c762cf8e14f2c540f738e3d2bc79d35193677c24da4626b12c26490c00aa6728a0f03a11cfe359e91cb20430b316c8e31c96356a6496e206b9da16356001c7ca5bb63daa18e610bfef8b89038398fa0f523f4ac19b2d8b9750c925baa4861c431873c10483ebea7271f8565b2828bb9492718707803dab4d258752ba8d65b8fb36f063925da4aaa0e848f534cb84b586196360ed144a52095010b2367ef1cf6c678f7a12423e94094bb2a403da9715eba670d88b652f9752e050053e61588f60a0a7a54b8f6a4c51cc1ca40632290a54f8a314f985ca562950dcc7235aca2293cb93692ad8ce0d5d2b9a694f4a1cafa028ea78cebba86a5aa5e14bd791225c074da63dc338ddb71d39e2b1a786f162921b618863cb06039618ebd7ad7a8788b49b8bebebafb2d84ae0c60cb7025505883955008c706b8f934bbb37cd6da8c5710cc601b1d5001b89e324903079e7eb5e4d5a724ced8c933845f36554646664887ccaaa4e07738feb4d745ba63b5891d72e703d056d41a5bdb4ecd136038c812828ae84f7cf6c0a8eeade682e9a1b7b58c99543318cef00762bcf4ed53cba5cbb946d614c120e64dfe5962b95191c10477e0f5f4abf7d656d6306ebfb89bcc78d97c955c12c0650fa6d39ce7da922b258ed6e3cc9e6081f75ca244488c8fb993c60f26ba6f0de8b0eb5670da5d5dc12a23ee7b697224f2faee1fcab48413d0994ada9ecb457023e27120f97a545e6703264c807bf6a44f8a45e4292e9b1120e311c9826ba156462a07a08cd1f8570c7e24c44298f497c739dd723a7af4a7c3f11ed24e5f4ab90b9c6e49430fe54fdb2ee1ca76d4571f1fc44d3883e6d85d458ff006837f854f17c40d1669123097819b8ff00540ff5a3db47b8723ec751457307c77a621024b4d41371fdded8836f1eb8cd29f1ee86b1bbb1bc509f7b7418c7b1e68f6d0ee1c8fb1d2e290d7323e207878900cf7032323310ff001a72f8e747964d912dd39f755507f12c29fb78771723ec6adf5b2dd5bc968ca7132156c0e31eb5e7bac786358b7458da66786dd09b331ca4166cf21813c607e95d77fc26ba388b7c9f684e71f32a93ebd9ab335df14e87a9e8f2da2ddceb24982acb1e769f7e7a567524a6ae9970bc5ea666850c53e8f7971a8e9b25e7d9c2aa4524990428c8620f4c9079fcab1745d185eea13f88fcfb6d3d607674b10ddc67039e80e38efed5a9a25f78774886ec5c5edddd4f76af1cac621b369e57827a8c7eb5ceebeda747a7d959e870b4a867325c3cabb59dbf847d304d677564cabeaec4915adf6b13ee78e63717d179a96e5f609ca9383e98efcf5ed5d55a59695e12d3d7509e08a0d625870f1f99bb69e7a0cf4e99fad58d3fc55a458e9d6704f1ce6689493b62076ee2490a73f74671f85721aeea29ab7881eee33fbb72a918718200e39eb8a52ab1846fd49df42413e8974f1c235284c85805d814127d3eed4cd7de1ab4bd3e69b54b88be56dd19393ea7b13f4acc5d4fc1484886ca4697f81963e87b1e7dea9e9bac69965757bf6ed31aee77915a32230db462bcf57f33b7962ba236d354f08c436f989820fdd0fdfe86aea78a7c3421f23ed24c58dbb3c862315521f12461375af82e49076631607f2ab0756f115c026d3c3305bfa798107f3a8d7afe652b17a2f12e84f848dc918ff9f4200fce9e9e22d2651b85adcbe0e014b327a7a11c561de5cf895ad278f519f4e86dcc644902320761c7031d4d50d32fae20d3638dbc66fa7db8c84b68c333a0cf42077a1413d6e3e647651eb7033930e87ab383d592cb1fad3ed75f176d28b5d175395637daecb128008ec727ad7336373644ee9b51f10eae4f19891d47e658557d3ee6c2d9ae9a5d116763704092f2ec47b06070549e4d0a0ba89d5476726bde54e90369b711ccca5c2c9244bc0f7cfd2a16f15309a387ecc3cd60580377115e319ce09c76ae32e2e1af755436bf6289551804b5b5f371edca8c9f7a9952f52ead5e59a76521d53ce22dc2f033f74f1fd69f2450bda9d41f14e518ad886025f25833a9cb7e5c8e6a1b8d7ad7f782e7468243192a59a3565042e78c035cd25a3cb24a4dd4b203701bcb8017c8c0e77ff9e9575b4f4696490c4b1b336434a7736318c1a9f757525d72dbeafa52fef5742b36cb1e50f71ebc7bd3d357d124462fa036e6ef1a965fc7073496b6d6ab92e3cc7e4e76f20d5c49205611b5c45196fef90953cfd88756fd07e85a6d86abadc06eec560b491c20420a6e18ea46723db9a9bc6df0fdf49952f7468e596cc4a1a48f76e3173d477231524577b99ded591d907ca55830c8aef342d63edd636e97192593024e3a8e0ad6f49df4611573c0e0d4f5091cfd97c3d042bddc420607af415069d2eb22eaf8585c411297532bc840c1c76a238fc5178eaf3dc792a7276921723b8c0a82cb4ab4bed4aefce9c948cae51588de4f51468af768572fdc5c6a0a717de2c442782b6e79fd315559b4f9f89750d575161da3c807f3cd6b0d3b4bb14511d8c2589c0795813fa9a9cea76d6d09d8fe5b01f7230173dab2f69fca99376652d9c51c12cb06832c5b5091713ce7727b81dcd4da2c37b2d8c324373676e0962255b7df33f3c924f1fad3c6a3777aedf65891801b4927207a9c9a9ad74bdb084b89be4192235381cf5fe743a8eda85c9a45b60c7fb4356bdb94ea53ced80f3fdd5ff1a8ec5208dae1ed74f8ee55a50d1cd2a021571d093dfad5d8ade084b110a123033b7269c245076839e7385238acfda4bb93763655bab9915a699212a081e4f0541ea33da94416f16d665799fb348e5cfe54d694904b0527ba004d2aca8b9c1da0631b067151762b93c92e14ff000f6c0eb4d04b9cee233d8727151b38555daddba638f7a72b6c5f9f04b1cfcbc629315c970586013c7a9c629b3c6b710b4522ee1fed1feb492c8b18cbb1c9e001dea3f3646e9958f1fc439a3504574d1ad937c8049c750a4e49fa0ab5632eb96b63245a7ea3284b7977f96e572a1bfdee7ae3f3a58ed6091f729911c03860c466a31a74736a5e4c32bc6d2a323067c0624707d7ae2baa849f36a691466c9746c11f607c8624313ce2b01ae5a3967b8b7dd019db2ca8dc0c7eb451453495ec42352cb4b49e159a695d839fba3dfdce6aec56b6d6e1c2409fef30c9efdff000a28aca52632def11c1e6845e0038c7ad355bf75b9405e338f4a28acd6ac48562fe6edde4a91de962504151c7724753fe7145154c436e98c30ab0e549fb9e9938a4640177a965200e87da8a29123ad5d995941c14c73d7ad2dc4aca235e0b3a9258f3d0fff005a8a2a7a8c15963bb384cb720313d39c54d326d05896259813cfbe28a29b2913423f74483df1cf22b2355b6742acd3162c491818db8a28ade8fc48d11fffd9' );
INSERT INTO PRODUCT (NAME,PRICE,DESCRIPTION,IMG,CATEGORY_ID,IMG_SRC) VALUES ('Landscaping Services',150.00,'Yard work - mowing, raking, trimming','landscaping.jpg',3, 'ffd8ffe000104a46494600010101006000600000ffe1001645786966000049492a0008000000000000000000ffdb004300080606070605080707070909080a0c140d0c0b0b0c1912130f141d1a1f1e1d1a1c1c20242e2720222c231c1c2837292c30313434341f27393d38323c2e333432ffdb0043010909090c0b0c180d0d1832211c213232323232323232323232323232323232323232323232323232323232323232323232323232323232323232323232323232ffc00011080069008003012200021101031101ffc4001f0000010501010101010100000000000000000102030405060708090a0bffc400b5100002010303020403050504040000017d01020300041105122131410613516107227114328191a1082342b1c11552d1f02433627282090a161718191a25262728292a3435363738393a434445464748494a535455565758595a636465666768696a737475767778797a838485868788898a92939495969798999aa2a3a4a5a6a7a8a9aab2b3b4b5b6b7b8b9bac2c3c4c5c6c7c8c9cad2d3d4d5d6d7d8d9dae1e2e3e4e5e6e7e8e9eaf1f2f3f4f5f6f7f8f9faffc4001f0100030101010101010101010000000000000102030405060708090a0bffc400b51100020102040403040705040400010277000102031104052131061241510761711322328108144291a1b1c109233352f0156272d10a162434e125f11718191a262728292a35363738393a434445464748494a535455565758595a636465666768696a737475767778797a82838485868788898a92939495969798999aa2a3a4a5a6a7a8a9aab2b3b4b5b6b7b8b9bac2c3c4c5c6c7c8c9cad2d3d4d5d6d7d8d9dae2e3e4e5e6e7e8e9eaf2f3f4f5f6f7f8f9faffda000c03010002110311003f00f3cd3e56d2aee5564fb409ece395814de532a329c8ed803f0a80cf2407cb88830c92893cc3c0dbfdddb9c63db157e3b81ab5a099226fb7db5b66508d869951b1c0fef819ddebc1f5ae6ae67601591e431b1e8fce3dab9e50770bdd177c4173235f7da095f3010ebb102ed03047b76ada20c76a91808f25adccb103228758c0720045ec30738f5e95cbdf79c6d449231dfdbdb278ae886a305d5db908a892c36b23a63196d8aac467d48cd134d4558a44576f2595ddc490c86450818f9a0e19b38276fa7b541a73996eae2212382661261495dcd82704ff00778e82afeb3e536a776106233080a1480723d6b993205919c00842e4b67183ed51185e24ca49336f50d47fd0e73098d242434aea9805bd81ed469972a34992090c9e63488cae7b63e9cfa60525c5ab4ba5b9631abf960aa29ebee73d78aa9a5a32da085f1238259555ba63a1ff00eb54a8c547ddee3d491ece182e4dec97c7ce2498d59b7373ebce7f1a920b77682de6332b6ce83767048e9cf535869304d4c930e2459304d5e13ac76a8fc82b2ed200ea33c554e32d1364bd51b4a167977c8ebe505da123c8e99ed9c0ce4e6a0b2daba8b08d4aa48bb80773b100c0e9d09a96d6e4416d222c4acd1cc46e63dbb71f4a8e3b93737e49904676fca98e08ef8159dba09686b40c52f1d2e2e080cc154c79c283fc43181d78c56d490a8f260880d98cc6719cae703278eca07d063b563e988b3dec1112e327e66238e391c7be0d74a2de285cae24322a3c8cdd477e3f3e7f135d3474a652d59caf8aac1fc89638846cc630c4851f3107b5715710496af146598abaee24a6ce71c807bd7a5ebb13dbc0b32fcd94c60f04b6338c579e5c5e49ab6a16f6ef88630d9cb74048e4d53e6bf9099aba3dcb25cdade2bba4c92ca0484600191807d4f26a5d7f4f89e07d4ec42f9406db9b7618686407ef01dd0fa8e01e2af5ef86b554747fb258bc4a00c5b931ed18e80819c672467b9353593eb3632064b09a78dc149637b9f303277520f2c08f7e0e315ba83d9ec4dfa9ccdea99ec95e2123315271b7b8eb8f5fc292de548e4b32d0e644b71b9f7020f27835b5abe9cef6cb71691cd2da65d23695be6e9ca1efc0eddeb0ade196dee045245fbd44604601e724f5efdeb2946cacca4ee6acf71f6cbd6cc403087e664ee3dffc6b9c9e646188dfe4643c919c7f922ba34998dc46526912468f0db0ed38c7f2f6e9585e4c825474700ef6180769eb8fa7735953b0ec8d797ccb9d2bed2f13fcb18024718cf18c0f5f5e2b2f4491e1129519e483f976f7ad3b2b8926f0f450bb70ad8218f5c138e0fd6b374f95d5e45cedfde0e5401c73e95515eebb8c9248f17f2b844209049ddcfe34d772ba7b1046d0f83c8e39355ef1a79af59a355660323e6ed8ff003de9e1a6f25a36c46ce54a91c12338e0fad4d9bd4562fa4ab225f139565c30008e41f4fcaaac13c2fe208678df2372a286e3b734f8a65450c8141640ca48cf3927f4cf4f7355e37b88ef56e1dde4f2e5e4e33d7fa538c7728eb6c64035d666eb1c91a20c10402e41e3db75776a90db59ddcf266492560a3af24b1ce3b638ed5e5d6b7455a72a80f9730958b229f954a9c0e3a71d2bd6d908b04247325c3cad91b87c9f28eb9f56fd6aa1b584f739cd662692c9240ea5f3928c0679f415e613c0d16b6d02aee7f382841d79edc57b1dfee934c74323487041030a0f7e71fa0af30d574fc6acb288d482c858e00e3201e3bd5cad6b892be87a7e97a9dadc4f01962267520491eeda2518f5ecded5a6c2c3cc79ff00b2d1137606d99b8f72315cbea91f94efa8c40ee0c05d8518c9e8261e993d7df9e86b674bf12c1295b5bc8c34c47cb2af1e60f5fad74ee6649a969d697fe699ada34b39d4f9ab6ca786c7cafc9cee071cf1915e61a9e8d3585f2aa248f1f204bce24ff6b1d57e95ed303c0cd98839cf6dbfceb27c4b7fa3e940477b162e1803b2371b914f467f407b0ea7b54ce1cc86b46790c515cc93445630ed8f94915625b3951d76c0a9283f780de7e6e0f078adabd92dd759162265b65fe196d57cddaffc21fbf3ea302a57d3e78cac52b086571e64d96c74e0e33ea6bcfa9cd4f746d18292d19cf3c16f0c71a231f9bb37500f734e6d3eda06cc25a3752073df23827f3ad79ada47f38bdaef3b4124ae173f51de98d6a58965495805c1cc648073ed511a97412835639abeb50ad9dc086eb918ddcd5eb4496e11e2281510045c9e581edfe38ad03a600a6375f309cb0cf1b4fa11daaac9e5c68843c91ef3d08c923d40a7cf7561fb3bad47790a96a14615003b17f1ce4ff2aca955ca476ec328d286ca9ebdeafc529916658815014a337d3a8cff002f5e6a5d1a38e77896578d0bc8630ce3381d338ab85d13c8d2d486685618eea512972518246a0e43638fd7fa57af89cc22049014f2e2da148e9f312c3ea19c83f4a3c23e07b683cad5644fed078e425020cece700b275cfa6474ad9d6348b9b8d225db66f1344cf2acb29f2fe763b987cdd7249c7d2b45cd1a8a05452749c9b394b9943230601572c09033fa5701ac650dbb1dc773f9608eaa09e38aee7ecd2b47ba570ec572111b1c77ce7bd67ebba3dacba419ae2322260254910fdc6191f31ea3923b57acf2caae2dc9a4702c7538c9245cb8b800f9eaaac4fc8d1b125597a143eddbeb9f4ac47862b2b948373359dc832da484fcc31d509fef29e0fad4171ae5adac2c24955860607049ff002727f115996fe21d32eacaf2d7529a74595964842ae424a0e03a91c8e383d88ae44fa1bb5d4ea21f18c9a4d8cc2258def3223b712005031ce5dcf4daa016c7a819e33577c35e05b8d7c43ae6bf248d0cabe7c31bb61e576e4cd21c77ec3b0c631d2bc9f5a8af16e93c891e6b76188d90923ae31fafeb5ee5f0e3c5675bf0e410dd865b9b65103e4633b4601fcb152deb62ada5ce6fe20f835349d3edafb49924dc8c1fcc276b6eeff30e6934b9351bfd3e3d3ae248ef7529595967686336d121201de49046012738c92715e9d7f696da869b2d83e0a3f4c9e86bc9bc429a7e8b369ba49b3b8b79da773732a4b2224b1ed1b0060dc90c09aa6aeb444a7e67683c1d66f006335b4ecabf3c7f6a0c33d8a8238fceb98d462b5b498a450012018db2cdb40cf5238c37e7542502e9fcbd2aeaf34e9ee24cb34174c911e00e54e7938c93f5e2b9ad4e4d5f4fb9bfb46d51e61063e69489831c0fbac7a039a8f654968e25a551abad8e8124b0964961bd9628d78055a5cf99df9c74c707a55c7d1ae628331b234aed98f05494c0ce460e0715c5daf88f5036526950340eb78ca248deda32dbfa70e54b2e7eb5e95e156379e1c5b1d4b50bc5b94554fb3c44afcca7e5cb7524f1d3b57062e9469a4e06f422e69a7d0c8bcf0e8b3b68bed12db6fb9dc1111b2e08ec41031ea0e79cf1d69de1ef0fdb585c25dcaeaf3a92d1c3c6437424ff00315d3c9612432b4723ec85a363e4c84b10c71c963e84638e7f9565a47a5d893753cd73e7c4e85c345b941edb703a572539c975b9b7b1b6cbf13761d4469d244ac652d2382b2000139fd7d7ff00af54d7558e7964964ba95ae236e23b8c92176aed07249ce39fc7bf5ab09a558dd97d8678e7948310f358461fb01d4e0f3c7e58aaba8e957303bbf9914c005088d184589400a4023aaee1c673d3deba218c77f842541ab952eb54d16e2e67373aadc2ce51498ace367641d8138e33f9d71ba978825babb92c2d61bdfb1a1dfe5ce1b748c01193ea7b0edf357683460147da6de417121002c002a95f538e6a73a620b0bbf32546ba58c8581776e23be7f019fc38c576cf3aad3a7ecd2d0e08e0210a8e723257e15685716f0c892ea30ca537490cb282c9c91e9df191f5ab50fc2df0f5bc3fbd8aee79cb0237dc61428f5c0eb9ae86d6ef51164b2bdacb13cf6c86517590d1eef986ee739fad6acf710e9fa7c57d7e5bcb2426d8141dcd8e837640fad70d175aa7bb276f43a67c91778ec79ecda44fa3eaf6f6d6b1874b898baef6190b81c0278c0c1f98fa56c46a2d2c2d6e34d665b70e6470e01393c1048e847bd59f1eff0067ea5e0e8f5ad3da502198464b2e1a32d94642074ce473ef8ef587e039ef35684da471493987709491f238ce1707d31d41fe95d53a692551ee8d70ff00bd6e9ec9ebe48eae2d51582c8aca78ec6b2b5db8d375684417f0ab95e55f1c83eb49078735bd3eeafdaf2da15b30e0db3a4ea7703d46dea31ef5957d0157cb103073835d9091c328d9d882d74f16b13ac707da1541d92c632c063b8af3bd5e3b9bbd5667586496000392ca533d012338ce38af43d3e736d24f219d92d140f3767df72785541fde27a0ad9bc59afa15b7d434b681e3606313491cac1f0301f6126363e8c06738a537ae88d692872b53934790687b26d62ce09951e679d046ece02ae1bf8fd462bde63d3ecdecae6ec3ae61525de119201380548f4f6ae32183ed8cf3a1d3a368dca93300083e9c29ad2b39750b38fce17b6cf1671b01fe5c8c7d7f4af37133954b4794f729e56a34fda53a8a49f9336359bd06032486e19162df234684471e4e0b331ee483c75a6ff6a1b8b55b16863447895a2f310856c9f5c64d636bdad24f7514a9aac56d12db2c53466425642092c73f8f1c7e359ba4ea57f24533c3ab4ba84508f31cb44c1a24ce0323670c01c6578f519ac68d072567bff5d8c3134274211ab25a3e9aab3f9fe875f690ddcf753c6a6d637b329218ddc8f9030249f738c0c7d2ad5a1966bdbd86e2c52cd22412149e419395ced09ea33f4e6ab695e218757b668b51bab5b596cc012ef7544da3fe5a10486e9cf4f535226b179a91592f61905e2e564b696d8c7f669012a53cd3c48a31c119ce0138cd724a3253969b109f324efa3196aaa81d8bbb0b941b6694ec00e7850c7814cd16f5e2b99a0b88e594a3181a49f81b3049c30e09c671ea33de9f731ea17f2b41728af6f0c9ba496cdddb7fcb9e13690493c63b7b568c5fd817fa3ab584d30b855dad1ce42181bfbb26701589f5edc8e95517ccb514dbbec668b7682ec4935bdaf9579279d33672c1f3f3966e37648fe5eb5775db16d5ed608e1bbb8845aee22df602930ed919e0fd29c6f20beb0c7971cae3baa9c119f4f51fcc1f4a75b6b3f64b49e5d56de69d22c056b65073edf5e9cd28ca5069c5b391be6ed731f53f0f5cc7e04b5d1ec6e165bababa135c302554b16c841c1c64e3af74cf5c550f0e7876e749d3ae1eee0786e27d40b298f6ee58c121727b2f4e057576be27d2248ee2769a7b448006984d036f8d7f8580039ef9f41935b57fa7597d820b82b2aee2446eff00339ddd38fd6b4a98d9ab732f3fbbfe1ca841c746b7386bd95620fe6ce484254b104e08aa17101961dc3cc2a4641da71fe79aeb62ba92c1544b3c4acac566675daac47fb3dc915a297137d9cc5b924898e738f9b19e403fa57447316f451d4ca7452d7a1c2f842c85debb6b1c9b8a25d170093b436ce3f106bb337775717faae89268b1269315a4860bd5624b95c1c93d32493d39a27b6bd8a184e96b135dc872cfb73ceee5b1ebda9facc57d696b6b6f6f6d1cb34ad978e390ac718cfccc7deb49e39df485ca861d3fb4784788ace3bbd5e752b2131b93989572b91d38eded5a5a5fc2abdd6eda19eca5b6b90c9ba58beda16588ff0074aed3cd76763e1cf0fe93addc5ededdcf750deee2bf30da843670587a7ad76769278795e4365a6456d7116e486646272f8eb91d7d6858ba7525eeb354a74a0958f2297e144d63790a25a2c41c111cb7775cefcf4210718183eb5ab61a6dee9e0437f6da75c8b369151ad24772cec3018ee277139c727815d6788bfb44c1bad227b985e21f68915be766271f27fb5ebed557c37a7de4ba7bc322059a350ad84dadb3b67d4f3584f11562b9a3ad8d634a9ce3bd8e32c34ed4e6bfd45e1d2a3b8681842cd3382ab91c8c9539ec718e0d7a269d631477935a3593c05bcb6335a46171c608e72197393bb83cfd30b67fda9a6ea516992ecbcd33cd32cd3a81e605c7083d79da49eb815ba6ea32ff0067804b0792fb4b4a41661bb918eb8ed9f6a8ab294fdeee252847dcdec66dddab5add2a3e4c210051b5db00f52a4bf07d7007e358165aa46fa81de8b1dadb39f2774ce012df2731f21c1ce76e072b935b374da9dfdf15fb43c768d232a2a13bd80e9d296fb4b8e386da59a4dae920dacc9c27d78c64e31f8fbd73d483b295ed6142a6b65adcd3d33438e799651198218198e658cae7927bfbb1eb59dac6a5a4e9e257677b881411e64303f95138e7f78c06003db152fc67ff00927b71ff005f10ff00e8c159c7fe4597ff00ae6dfc8d5559a5656dc9c3d18c95d98ede32d2a75fb25bde25ddcdd46cbb511fe4241041dc07043631cd743a978874dbbf0d7da6e7598a159d150ca2404707194c6782c3195c8e3ad78358ff00c87b4dff00afa83ff460af4eb9ff008f5d4bfcff001356d1a1182b6f734af2bb476fff0008a5c5adadac91dffdb9a4191fbb67dfe983d00f738aa72eb167a1cd25bdd69d32f98e62dd12193c9618cee0b93839180393cfa53b4aff00917af3fdc83ff41ac8d73fe413ad7fd7297ff449aca0e1197bb1b11152924e4ee763e19d62d2ead46a2272d13e5634585d5c11c36e43c839fc2b4adb5bb4918acb6d72af2e4b248aa762fbf3c8efc66b8ad0bfe40da4ff00d70ff1ab5e21ff005da2ff00d74ad6a57951a7eea32b29d571659f16787753f11c16b3681770db5a42306d1e2016739ebb8671ff00ebae43527d6f40baf22eb51b111a32a931c4ee429196c0553f30c1001a5bbff9130ffd7ec9ff00a19ad5d0ff00e41eff00efaffe8558d3c4caa4da68d2ce1a5f42ada69d6d77a54b0e9f712989dfce2d652379a4b60891a36c30279e7a73c135d0e9cb32592421ee1db18f3d90fef540c1e7fc6b9bd1bfe415a4ff00d776fe46bbad53fe42d6ff00ee2ff2ae854dc9ee2946eac6420b18bcd92e6fd2158cbc6ad0a976573cf27a67eb573c352f8767b65ba60897935b2c93f9d210d20e4efe7d49247d6b06dbfe47a87feb98ff00d096a5f187fc7c9ff7ff00f6bb573aa928ccda54631bc15c97fb4d6da1bbb89a45863123ac58561c1f518cf4ee335527d57ed2111a39560f3a181675983a05770531e99600722935bfbd67ff005caae786bfe49f6b5f4b8ffd17514a5ed24e12e86b2a51a518d45d4fffd9' );
INSERT INTO PRODUCT (NAME,PRICE,DESCRIPTION,IMG,CATEGORY_ID,IMG_SRC) VALUES ('Excavation Services',950.00,'Dig holes, flatten hills - daily rate','excavating.jpg',3, 'ffd8ffe000104a46494600010101006000600000ffe1001645786966000049492a0008000000000000000000ffdb004300080606070605080707070909080a0c140d0c0b0b0c1912130f141d1a1f1e1d1a1c1c20242e2720222c231c1c2837292c30313434341f27393d38323c2e333432ffdb0043010909090c0b0c180d0d1832211c213232323232323232323232323232323232323232323232323232323232323232323232323232323232323232323232323232ffc00011080060008003012200021101031101ffc4001f0000010501010101010100000000000000000102030405060708090a0bffc400b5100002010303020403050504040000017d01020300041105122131410613516107227114328191a1082342b1c11552d1f02433627282090a161718191a25262728292a3435363738393a434445464748494a535455565758595a636465666768696a737475767778797a838485868788898a92939495969798999aa2a3a4a5a6a7a8a9aab2b3b4b5b6b7b8b9bac2c3c4c5c6c7c8c9cad2d3d4d5d6d7d8d9dae1e2e3e4e5e6e7e8e9eaf1f2f3f4f5f6f7f8f9faffc4001f0100030101010101010101010000000000000102030405060708090a0bffc400b51100020102040403040705040400010277000102031104052131061241510761711322328108144291a1b1c109233352f0156272d10a162434e125f11718191a262728292a35363738393a434445464748494a535455565758595a636465666768696a737475767778797a82838485868788898a92939495969798999aa2a3a4a5a6a7a8a9aab2b3b4b5b6b7b8b9bac2c3c4c5c6c7c8c9cad2d3d4d5d6d7d8d9dae2e3e4e5e6e7e8e9eaf2f3f4f5f6f7f8f9faffda000c03010002110311003f00dadb4115332d26dafab478c572b4d2a2ac15cd336f3d2a80ae539a4db560af34df2c9385193e8066a6538c5372764349bd8ae57069a579a9894f31a3dcbbd7ef2e795fa8ed49b6942719c54a2ee98a49c5d99095a4db8a94ad26dab11095146da971498a0445b68d952eda4dbed401115a40bcd4db7da8d9ed40cd92b4c22a729cd215ec2a2e0418a6115395e01c5412cf14618125dc1dbe5a1e73d7e63fc0a31924fb01926b2ab888528b9cdd922e9d3954928c511b322bc4acd832bec8c7776f41f803ec2a7b8be934e98db58da472cca373ef942e5b69200c8e40c0c9247b66a95d94fbb72af71793a036f670b796540391231ff96480f4c9c9f463d23b2d29ada4927b9b992eae645285989da80f5dbf5ee4f5c0af96abf5acda4f93dd82fb9f9f99ecc3d8e097bdac8afa75bc115a2ec909ba9732cb2b2e1a463d4f3d476fe58abb93bb05187e39fc4fb7f9357fce26d440ea8c1576ab326768fa0fe959b34cf6f34be75b4b15b86fdd5c443cd8c8e3ae0ee524f6c0c56cf1d89c25a9d5872b5b35aa7ea8cfeaf46b5e7095efba7ba24da0fd29365229728254f2d958e3787cc6df4603e53f51f503ad2c53c33b3a44e0ba1f990fde5fa8fea323debd9c0e694717a45da4b747062309528eaf6ee34a7346ca9f65052bd2b9ca41b28d9536ca365170202b46df6a9f652f974ae334a3595a146950c6e54160463049c77febf5ab96b6c58b6557790c510f56038e07d41fcbdc5717a843a8416d0d96f4bb8846cd1c6b1b2c8aa83716f61c1c91c75c563e9f05ff008896df48b8bebe5768da38cc321c2a13925803929f28c0edf89af98c462ab56a5ece3a37d7c8f568d1a74ea7349e8755e26d66d742d424844b0cb34d1e61b773811c8300872b92031e7a70739c0e6b3ada3b8bebcb96b4282efed28b797ec80c4c224da1557a3b963bb2bc0e371cf155747f861a65a45149a83cb35e65cc8219711e371db8e33f7719f7aec61b486d2d61b681047043188e35f451da8a196d5a9cbf589b715d0aab8ca54efec63693ea54b6b38ed5195773c8e774b2c8773cadeac7bff4a97653e4942b7969b59c0c6d1ce39f41fa7e3e94e42248d2453956190477af7a8ba715c9056b1e549ca4eec84a526183654956f51560a526cf6aba908548b8cd5d3ee11938bbad191c7288a0787022f948568d070c7b95faf3581730416f6e2fafad1a2ba89962375624857cf1e60f6f55c71cd746233cd6478864f2349977ab796c3e69179d87b647a1e99af95c7e490a37af846e3d5a4ff267b386cc2551fb3adaae9ff047db3c86692de5612150248a655c2cb11c00df50783f51ef8b5b2aa8550da3dc468111a3116c4e8aae808e3eb5a1b3d78fad7ab9263a58bc2a94ddda6d3f91c58fc3aa356d15a3d487651b2a7db46daf62e70106ca509536d14bb295c679b6aefabd9dfbc57b74ee17a7f0878c1daa71d31c0e3a557173296884ab899cafef368257827ae320e460115d96ada71d4ed9d1442b28c2c326de85578e7b0247bf5f6ae0b5186e2da5911c982e626dfb4a83dfb76208cf35f250bb7a33d996877b61e24d6974dfb4de69f1dd40833e723ec670790de87a1cf4e41e98ade8357b5bbb137309746da0949908c671d4f4ee2bca6d6fda7b49228e6683732965032187a7d464f3ee456be9fa83da5c9659a48d08c3ec38600e4061f9fe35deb115229a4ce774a9bdd1d4dfce1a401ae3cc5dff0026ec0209f41e878e9e82ae691296f319dc6c639396c90dd39f4ffebd50d2ee1efac905daacb02923793922452307006771cf5f6e739ab2b6cd24b32ace5893b5f6fcd22b1e870dff00d71c718aca1889539f3486e82946d137368a42a2a858aea11900959e0ced385dae87be4938f4eddeacce6e04e891b2150d86054e48c763d0577ff68d3b5ce77849dec2dc3347693491a79922a12899c6e6ec2bcbefef75fd40dddcdddd325a9891cc71337960336c000071c90c79c9c57a26aed2da68771348e0bec62034653b7d7dfd6b891a85acf657fa73fda04f75711c70e1372ed8500c0c71c1c9fc6b9f1389f6d1f71f43a2852f672f78cf9d751b4b46d3ff00b4ee9a680236c789fcbb6db92142e790461b776e95b7a76ada94725b5eddea86ee29144b22792aa368708fd3eb9cfb560decab36a925c4b673fef5a216f6ad1b23ce7695c0c124e4e49fad59b166023d1af2d1a0bf860b98da1913cae5c6e52bbb8e3d09cf03d6bcea5cf46a45c76bebb2dd3fd4eaaaa352324f7b7e4cf4f781a394c641c824600f4a6f96dfdd63f415c1f87347d55bc1cd15a6a96a8da8bbce6530bc6f11c6dc8643cb641e318079c9a84784bc452c92469e2f6dea3e60269f2b9fc6bb1f106122f9652d51cf1caab3578a3d042f7ea3d452edacd1a92e99a6d8a6a3299ae31f679a78d4e1a455e5b9f5500fd41ad7c638ebee2bd1c363a8e261cf4e5747255c3d4a4f966ac72eb289523480a1b411abf6e483d46738e9ce739e718c8a8f58d26db5a1142e5a0113ef8e44019b27aa8edb71d8e7a67b8ae774ebe92c6759542c919c121b18cf4cfb301d3b5757617d0df2b9811b0b90caea7209e14f1c60e3ff00d5c57873a7283ba3d08c9491cbcfe08d4848ad6124370012a3e758d89dc7070dc1e08e87154e7d1f55b39ae2196d9e630b6c9648712203d7ef2fe58ed8af4045bab28a13346369da1dc139ddd59411c67764f380010335a2b0c49676f15baf976cc433f95f2e4e4f53d7af6ef9393d731ede511fb24cf3db0d335996518d3ae9501c97d8405f7e7af6addb7b3d52559e4825713f9c1a4257e60403c9cf507d81c575ee2079b7b302aa401b49e7b9c7e5fa5568a2136c3210a2320aa8c0cf079cf4feb43aee5d0153b18115cf88219c49325c1751e63aa2a2e573d07cbc0fd6ba0844f7b63717172628650d1ba282cbbc1e7b124e3d3be2ab6a33c9690c26188b4fbfe664604f1921403d47bd7316bad5d4728fb5c771049b9da212c4c3729e7904678f6a49f322b637fc452b5c68b3c6986752223f68755594961b803ea076f7ae16d6cb538751f31fec36f6624924411c8bbe26627e607775208078038e82b76f2e6e6eacd6de1bab9b56597cc8e486d86558f3d197183d7a8aa76fab78c3ed2905f5de8dad19e3776826d416da42bd0820ed1c81d3e61ef47bebe0697caffa8d72bf897f5f7158b4f657bf69ba37777347128b3b9d3c42af1321f937296385c1cf1c9efef5350f11ddea2676d4edee6479c86765b50adb800320a9e3a0a6cbe10f0cea76ab35a437da4dd64a3429a8dbdc2071fdc2586f5ff6830efe95e7b732de68baa111dcf98d1b65199720f6fba7233f98a7cb39fc566fd3fe0949d38ed75fd7a1eade14bdb88fc2a6068e733abcab06626da9f74a86c1c9e464e3d78ad282f2fa398b9b7b5566c6e296939246467bfa67f100743c78d1f13ea05c3116ef8409f3c0bd33edfceb7f4cf16dd5f992d8e8d67279a7733c6a11d5b231b49cedc95031d0ee23bd797572a7294a5a6ba9df0c7c6314acfef3d07c477d0c9a512b1dca9fb60652f6ee30369f6f6aeb6d7ce7d06def7ca0c834f49cfccbd043bb38cfb0e2bc9e2d4ed6c58b6a025b39e162e158f9a92153c7dd241e9d08ea476cd6f787ae4eb579f6e4b996325644364cb9c861fc601c6d18cede9f2e08c715d59753a9818b51d99c78cab0c44934ad63227b6b8b352640a093b010780c3f848fe16e8707919c1a7db5db5b48b2c6645f25810579319c8c123f897d7b8ebdaafc32b5cb864bb42e908dee53e66e4f1203f789e9cfafbd50961f22e363fcb246fb090fd31e87bd7acf5d19c1e68eeb4cd5adb5692d84a8cd9022f251ff00779c125fafddc9038c9279c0c62b4d6dd7ce91a176f2593222c8daf8ea54ff003f4e45799e9f7f1c774eb2a4d06d01fcc8783bb1ce57fdace722bd02cf51b5b5b24bcbcbc4b988bac20c68065482428c7fbb8e3ae73deb96ad3b6c6f09dd172352f730e232b857c311c28c72c7d8e78fa54f39100f2c11b09091a003af6c0cfa64f38c63e959369796e3538160b9136997237a85555576639da7f88630719c64e6b6639e2170c542c8eb1e76f042f195009fe223a75c7358b8b4cd2e635f46f3c063304d2b9915834a130006cef396c80319e9e82924d0135a9659751b8ba525fcd40ee06ce3a7b67ae326b72d208ae2d7cb82026de5f99bcc3f32bff11c7ad25ac12ed984f3472244bb15109de08e725bb8a576b6158e6e2d3ed17cc85f5299e4c797192878da786e3938e99e01156d3c3fa55ced8caf9cc030f30025d8b8e7a8c63d3e95b2b66be4ac8cb1f9a0162aac7907ae01ebc75a46836e0468080a368638071efcf4ff00eb51ccd0d44f2bd73c2dace83696f6eb6d2dfa14dc1e0b33228c6540241241c60f4fcfad6ee93f09b4fbc86daffc40f706fa6c3c9641f62a0fee9c64f236f19e39fc3b9d45cdb69e93c76a2ec9902f96d85d80ff001127eb4e1637f60394ca6e2723eea81c907b91db8fe949d49b5a31d95f5385d6be11f8727b60f6315ed9ca8c432c2dbcb13db0e7f202b12f3e16cfa568734ba45cb6a08cca67ca18e54d877361467772a1401924b0f4af5d8af7cd50b221c0f9492a7faff9f7a58ed234985c40c51f382b8ca807036e3dc71531af25a487c89ec789699e17d47c5d77269f751dee9f0c3119a4966b131042140419fe362db7d3e5dc7b56fd8fc38f13e8b7b0be9f7d6530057124c4a0c633f302adc75e0124f3c57a7dcca8232d3a48cbd86093938c7d0e4d355a447f2e17f995f2525c9c8c8cf4ee7f1e7355eda5d04e9c5ee7ffd9' );
INSERT INTO PRODUCT (NAME,PRICE,DESCRIPTION,IMG,CATEGORY_ID,IMG_SRC) VALUES ('Bean Seeds',2.00,'Fast growing tasty beans','seeds.jpg',1, 'ffd8ffe000104a46494600010101006000600000ffe1001645786966000049492a0008000000000000000000ffdb004300080606070605080707070909080a0c140d0c0b0b0c1912130f141d1a1f1e1d1a1c1c20242e2720222c231c1c2837292c30313434341f27393d38323c2e333432ffdb0043010909090c0b0c180d0d1832211c213232323232323232323232323232323232323232323232323232323232323232323232323232323232323232323232323232ffc00011080055008003012200021101031101ffc4001f0000010501010101010100000000000000000102030405060708090a0bffc400b5100002010303020403050504040000017d01020300041105122131410613516107227114328191a1082342b1c11552d1f02433627282090a161718191a25262728292a3435363738393a434445464748494a535455565758595a636465666768696a737475767778797a838485868788898a92939495969798999aa2a3a4a5a6a7a8a9aab2b3b4b5b6b7b8b9bac2c3c4c5c6c7c8c9cad2d3d4d5d6d7d8d9dae1e2e3e4e5e6e7e8e9eaf1f2f3f4f5f6f7f8f9faffc4001f0100030101010101010101010000000000000102030405060708090a0bffc400b51100020102040403040705040400010277000102031104052131061241510761711322328108144291a1b1c109233352f0156272d10a162434e125f11718191a262728292a35363738393a434445464748494a535455565758595a636465666768696a737475767778797a82838485868788898a92939495969798999aa2a3a4a5a6a7a8a9aab2b3b4b5b6b7b8b9bac2c3c4c5c6c7c8c9cad2d3d4d5d6d7d8d9dae2e3e4e5e6e7e8e9eaf2f3f4f5f6f7f8f9faffda000c03010002110311003f00b5e19bcf2aee11312b117dae09e83be4d6378ede4935d824795d800f128ec801cae3bf2a7a9eb4fb397cbb85f94b412361847c953ebf4f6ab5acda36b1a5b4b1625bbb67255c0c1755e8a473ce323f0af160ad50f66ad68528a9c9db55f8bb1cee9926dbb5898e239731487afcac304fe19cd5fbfd696d2d63b6b12a5d19a12cf8f942600207b8c75f7ac3497f7bfba6dde80751eb5afa7e8ab7f6521b8478e5790b46e700a8c019e7a827b7b568ad1bf3158ea54abc60dc79acf6feba19914f0ccf3c97eb793c9b47925260b83dcb1c138e98c558d2dafe59bc8d3230f70ca465577363ebdbdcf15b771e0d5d3a186e2e6e649a19012a635da0e3f5aedfc05a45b5921b88e048de6e01c7217d39f5a39935a096363094a9d34f4ffc057a23c875589e2d51e290be23444cb0c1e07ffaeba0d2ad6da6f0e4b7512e2eed092fdb7c7e87f9fe157fe26e9696fe3091e35db1cf1230f457e72bed9c7f3ae634cd49f4e177048acc93c4d1b28ed918a738e8746125ed68f24b5befe7dcf57f87f0429019860998e4b63a8ed527c51d32cce936ba8b43199e39563de541f90e783fd2b27c157eb61676d6d336d9110021b83d3fcfe549f1375ffb45859e9b6b2a16693cc9095ddb428e01fc4d11695cf2dc3de8f2ec71bb5e1b19ae1ec656b540525f93690bee3aede45374a9cab79369711cb16d578c48dfead09e99c1cfb5741a2df33dea417c8bf659b6ed999b29f74e51c773e9dab275af0d5bd95f87b195da29dc987cb3b59493f771dc67383dab24f46a5fd7fc13b57bb2e55d0d183577b68d9e77c42ac4326ec0751db1dc6483fe7158314a27bf79632be5c8ccd8518dbcf18ff3debd2fc25e06b5b4856ff55c5ddccabc249ca463d31d09f7aa1f1134dd3f4cb9d3aead218e179432c91a2e3728c7cd81e99fd6aa30b26c9f6aa73e48ad4c2d1a796deea2756c796c09e73d2a0f88da2bf881b4e934eb5326a0ece511339da319fa72739a860beb782432f9802019da396cfa62ba5d07c496ed3b48ec91498d89bbef05ff00eb9f4a8836aa268d271fddf3495d6c7396f71633a19f521134810c85e0cab3738c15e9b8f6f5aad04f6fabbccb711bdadac6ca16df76cd8b9e189047cc4e33f80ac5d4b4fbed3648259e3895b064485a41ce31824f41c91815b5a7057b917776b89d6050e88c1be5ddbc9c7d6b79de30d4e2a7470f2afed28bbc7a2bb697476d6dfd6868ebd6e74bbc1025ba0f3de3093e0ee652a4952c7a90467af4352d8a143b9bae3afa554d4b559f519ad41422de2baf311d871ca90067bd5b56258b7dee3040e704ff004ae69b6d267551a50a6e4977d7d7437b50b8966f0cc68bcb4722b28efc119fc7156b4ef12d859206919d4e33e5edf9b3fd39ac3dc63d2a7017cd3bfcc8d49c9df838c7e19fceb122b97953cc61f3c9c3023a1ee0fa74a706f974329ae6aee3a5adf3bdd9b9aa2bf886f67ba9cc189b0ab14b92368e809fccd727ad68f168f35a21b5f2d6562c660ccc840c7caa4ff9e2b5edef76cdb5cb88f19e9f3641a975b99b51f0dfd910a33472f9b02b9da7be40cfb13f8e29c24f9acf60787852fde45beef5d0cbb3366c4661461dcb0e54fad5f9b4a8f50807d8915a556cfd9dce04a07a11f74d73f6b2a43c3e5828f9971865fa8ad8d2af4c77b14b193827a1ef5cb38ca94ee8ee4e352267d8ea5259318d97022728639872a495e5ba1c0c0c81d7ad6cc5740eb7a79765105b798ccea728c586463d0025b03d3eb56fc616b64d6635d92157475ccc84e033a8c8e9f95799e97e20bdbfd661822952daddced8e1c650679c1cf35db462eaae781c7565183b4b73dd65f1cd858d919259bcc751858e33cff80ae4e6bab8f19eb092cabb41c24516fe1133c9cf7cfae3dab969ae12eed542261f78772580116320a927fcf15bfa41b1d32ee0d4a62018e3d826525b0a4f3c0edf375e7ad126ed665c631a7efc772978a6c13c3ef33c32a5c2a29240cfc8c07427b8af35bbbebeb89ffd2ee9a20ffbc11f2abb719181d39af4ef10ded95cc7616166d3bdaf972c8eb20019c37ca3271c1ea7e95c96a5e0cd4eef47f3ed6317315a021155c79ab1f5e477c7b56d879538bb4b726bcabce09df4376082e5ef638101b8b75b733794c338e70473d7b1fa8a73df2d9bb4cf0bac71c78903a15651cfe47a62bbff00879a1c7799d6ae554c4c86de08cf20aa9f998fb93c7e15cd7c6a16d65147636d806665b868d780aa323f527a7b528c39eca473e22bce9567ec926aff007777e7a983178a6e35f792d6d34c33c702872524c48aabdd57a631c6debd6b462bd91ade09962256e0fee5118abb907046d238c11ce78e3ad723f0df501078d2db7f2aeacbb13be4138fcff9d6c5a5eca756bb96498a470dccb1ac0cbf746fddcb6783dab6ad4a3cba2d8c6829427ee3d1b6dff5fd23a15d487db22b59de0b791c657cd27772703681c727d7b7a557d574bd463bc496d66b4632921930c198803a004e4fd3f1aaba230d3ed763cec44ee653704731fca46e19e4f19c71c7bd6ca78a601e4c50dc2b4f180de693bc9407d78ceec73f8d715acf4d8e9f6515273b7bcfadddfd0a90d94d046ad74369db931e060f1eb93fa7e956b4898432142824258e7780420e30a33ec6a5fed07d6ef24d45a2525b092adb2b14217a37207626b3ed2ebecda94966e40dc4baeec80c87f0fc3f0353bdc54653559a9b76b685cf15e8b1c9a7da6a3a644b15c4526c9631d1c119e07aff008573b6f28c2ba9287761948c153e98aeb648c7d8e7b99660b6c6d70cca73b595b72b7bf71c562a59e9dadc3e6cec5997fe5a41f2bf4ee7d0fa54e8e1691d51e68cfdd5a19be30d69a4f091b151bb7caa3703c0e739fd0d79e5b661d46239c618357ae6b5e09375e1ff002b4b919995848a929cb3b8cf523be33dabcdae742d552fe284d84c2663b72a37007ea2bb302e10838a672e2f9e53bd8dfd3d9889a5c6e17524ad06572339e8723183c1e7fad6cdb4b2ca56186332cb046731dab959198e3a003e503073ea3b55cd1342b59eda1d2c6a10ade2a6c58c0dca4fa31e99ebd2baef02daae99a9ddc12ac6972b2795204ed8008c7d73594a6a4eed1d0e0a10dfb6879c5def9754b99a562d2c8a09cf41d72066a5d1750934cd5239959846c363a76653d41aee7e2768c2d2fad35a8502c538f267c0c00ffc24fd7a7e55e76e0ab91df774f4a5522d68552a91a9adade47b36837767a66910da02238adc15c67903b0af3af89bff001360b7a14152fe4ab31fb808f9493f5cd7a9e92f6e96e918440b8e72b9cd52f18f87adb56f0e4e6dd618ae0618b740cb9e86b4a6ed2b9e44e35528ddad37f3feb73e65d1b537f0feb31dcf91149341267f7809db8c8c707dff004aecb47b9b6d4adf52d52ea57b157badd03c59cee653bc007ef67e5e2b3ef7c1da8fdaee6fefa7104000cca08632f38e839c9e3ad4961642d2d513975424a0618ebdfd8d74d5a90e5b8e9c7eb1a53968baafeb72fa8b3b80cb3477d70198b6e7916239f5e3241ab10e8da458c335e341782658f788e7973bd49001180370ce2a2b7b666932ff00bb0411bf3f77dcd5c92e2e2f8d9ca642f6fa733279adf2ef0e40031ec727f2ae38cdb7e476d7a11515793dd6a741a35824d736f1cb26db788176894950f20fba491fc3d4fd4d43e28beb0996d6470a2f15dd36dbc98208ee18f1d3d7daa0b759560958c9e5ddb23e493c6dc9c7ca7d3a7ffaeb0ef122bc9eeaeb1ba3b781238f381f3646e23ea4fe5c566be269f43674e328a7dcdb4d3eede1fb3b0770e331c05d70cc3903a75ee3d79aaba6dc33c6de6028f1c8c8eadc6c20e0822babf0f8b686c6d6cef76b5c22994b364ec5539ce7db20571d3de416f2dd4de7a9637b248bb549dc871d7038e87afa524f993457c12b9df787eee278cdb4adb2361f2fa026b0bc5f691596ad692cc3314e0e4f40ecbd01f7c7e7b6b262d5208d595645c3a80b99028c1ea7349ab6a035182348a43325b801149e1b1d719fe7ed5118b4d5cd5abde48e96c42bc91bbec66c864661fc8f6aab7b732e8fe2692fd41782e02ac8a0f2a47423e983f5c9f4a2d2e36c0aa580287ef7a8f6accf1049b74dbcf986e64528c0e49c6e24fd39fcc1a20e49d8a508cacd9b7e28f1969faf787574fb5dd7724922b49b633840a7f53f4af3d962742648b7490f3c7f120f435674f98a4aa23628579e38c71c63f4ad7d46057820bf8c60b80b32fa38eff88c56d29347552c2d35050fc4b5a36bfae4dbda148258a24dcc89c3afa9193cfd2ac6a3e3491ede2b66b832b4bff2cf6edc1cf01bdff1c62b81b3fb4cb3f976a1d9d86d2a99c9f63e82a492c25b0d6218af40f315159c039032dc7e55b28773c7c5d2c3cb960a56feea7baf3eb6f99a7ad6a925e4c9612c4aad1b798db09c11c81f9735bbe1bb0b4b8b39eea6026317fcb2e39e38fceb9fd4f4ebd96ee3bab18c174077a0232cbdf1efdeb37547b9d1eda09d2f628ee6e8928ca78441d4b63be78fcea5c3da5ac4d2f65858fb34ac9bd0e9ff00b22d6ede5699e424aa1de7e4580e49607b92001edd69d14bf6af3aceded44960a02640dc58739271f4078c9e4715836baaeab65a03dfddcc97fa7346cad20c33c4cc0ed271ce09c039a4d04bba81bd96dde11716974994db374d8c7a633b80cfad54a938c7530f7aad56eaecb65fafafe46e5ec524365733dccef2308f2b0b2852bd075eadeb54a2061b0b41193992549189e7201c9047739dbc7b574da95cda7883c1ad2ea56a63bc8a32fb61009538ca904720e597af5ae350ea3a569b6a6792269cafcab22e6452791c7b020e6a145db5dce884a29deedfaf4f2febe6747aa5e3bc26da01b2faed046371cb24639663d87a71d4e3d2b0f4358b4fd4228e43e6c69310c5f9dfeb9a743773a926d5374eff007a790ee79187d7a0a86eedb57b7be325ce9ceab285950c447cdd89ebf4ac92bc5c133a22e4a5cd25a16bc4cf141a8b595a2916d333498edfeefd327350c62ca2d16e7ed3179772bb5ade541f36fcfddcfa55399651a907b9041f2c0543ced5e7afb9a875092791618adfe67f353cb4cf04e78feb5708db955cec825ecdc923abd320bcbd62d0dc08d7b2c8bb88fa73d3daa7bcf0f6a251a465170a41ddb0f3efc56225f18a72b112a0ff003f4adab2d6a58997f7c54838fa57149d452d450928eb1471e825b4b96b790b2cb1f233c165f5ae86d3578dec8c1720baed20e31c8ff1f7ae8757d2ecbc4ba4fda44605f41cb327048ac3f0ae8905c6b691ddee9204e5e36e327a006ba954551799b529f2c1c9ec8d2b89dd20d2e494b1fb4489048203e5659870ddf38fee9c839ae6fc736f2695acc3be73712a9c190a04de9c601038c8ce323f2a28ad28e96b75b9e1e2211752536b54b465eb0bcc5acaf226e112962036376067df1d715cc6ab6e35c7b8b82ed084b6790463e6002ed381d3d793cd1456b495a6da2eb2bf2a7dc6785e356d26169373c77664b778c9e00c678edd483cf7157ed749825f0ae559d0594922150c76cca1b8dc3d791cf5e28a2b6acda8dfcce3aef969292dff00e090cbe21974b861ba86de30af6ed088d0950029efd77723ff00af53cd1c9737b6f7773379935dd9a5c361701792a140f4c0a28ac65151b35e675293f6bcbd3fe011990c5903e9c7d715b3a75ccd7b7096f348cc146d524e768f6a28ae4a896e7a10d74659d5f40592d16f21b964c398991d0303827078c7ad738a935bdf4aab30de9f286d83a601ef9c75a28a74a4dab334a3fc450e82eace2dedbcf2b9949c654edcfb9ebcfbd241712c73a5bb10e1a2570d8c601edeff005a28ad9454a93b9957f76aab1d068ba9dc44e6353f2b0c73ce2af68d7a6d75f78c20613b6d3ce369eb9fe74515c30d2abb1d3049d39a7d8fffd9' );
INSERT INTO PRODUCT (NAME,PRICE,DESCRIPTION,IMG,CATEGORY_ID,IMG_SRC) VALUES ('Green Tea',2.50,'Green tea from green mountains','greentea.jpg',2, 'ffd8ffe000104a46494600010101006000600000ffe1001645786966000049492a0008000000000000000000ffdb004300080606070605080707070909080a0c140d0c0b0b0c1912130f141d1a1f1e1d1a1c1c20242e2720222c231c1c2837292c30313434341f27393d38323c2e333432ffdb0043010909090c0b0c180d0d1832211c213232323232323232323232323232323232323232323232323232323232323232323232323232323232323232323232323232ffc00011080055008003012200021101031101ffc4001f0000010501010101010100000000000000000102030405060708090a0bffc400b5100002010303020403050504040000017d01020300041105122131410613516107227114328191a1082342b1c11552d1f02433627282090a161718191a25262728292a3435363738393a434445464748494a535455565758595a636465666768696a737475767778797a838485868788898a92939495969798999aa2a3a4a5a6a7a8a9aab2b3b4b5b6b7b8b9bac2c3c4c5c6c7c8c9cad2d3d4d5d6d7d8d9dae1e2e3e4e5e6e7e8e9eaf1f2f3f4f5f6f7f8f9faffc4001f0100030101010101010101010000000000000102030405060708090a0bffc400b51100020102040403040705040400010277000102031104052131061241510761711322328108144291a1b1c109233352f0156272d10a162434e125f11718191a262728292a35363738393a434445464748494a535455565758595a636465666768696a737475767778797a82838485868788898a92939495969798999aa2a3a4a5a6a7a8a9aab2b3b4b5b6b7b8b9bac2c3c4c5c6c7c8c9cad2d3d4d5d6d7d8d9dae2e3e4e5e6e7e8e9eaf2f3f4f5f6f7f8f9faffda000c03010002110311003f00d98ed214730428142ffac900c7e038ebfca9d749b552de085c230cc8c47247a7d4d5abdbe36b03cccaa39ce02f249feb9a5b46b8b8b1135c1db293bb6a2e303b673deb66d3212b6e67db46ff00da51c86126258db2641c02718a9e65cdc0236052a54e07e46abddcf30d4beceaec235803b29f52dc1fca89419ed654070e570ae0f43d6a1be85a5d49c4d0ae4492292390c060d20b884e4890b13d085aa7ba29238e40a31220917fa8ab566c8ce90855524fc8d8efe86a6f62ac385d82481b988fbd85e69bf6976701219093d2aef9054330da1bf8b8e68550cc30c43fd3152e4c3951504d783ee4031ee691d6f9c13f668803deae9664f9655ebfc42a44e798e4247a351cc9838b463982f4f2c517b73da93ecd7bd7ed231d8806b708e30e809ef4d58a2272095c7626905cca582f00cb5eb0f655a78b6ba23e7be988f40a2b58c2808dca41f5141890a651f3ec0f3f9500652dab807fd3ae0fb67141b22c39ba98e7d4d5fd9c9181ef9e0d1b13690c0fd68e6119a8c2fb5ad9c35bd91cb8ecd29e83e83afe35ad82b3b2b724f26b2f45b46b3d3144c7fd2666796638eaec7240fa74ad06dc668c9272463f4ad49663bb093c47a9283c430c29b4fbe4d5858f7636f073dbb552b5532ebdafcacdf2f9d145c75384ff00ebd5f82392324291c9dc33deb3b971d0a30c622bab8b52090bfe9308f58d8e1c7e0dfceae144209418c8ce09aafaa4834f9ed354703cab7629367fe793f07f23b4fe7571e189253e4b87b79543c6e0e772919c8a4fc8b8eacb56d7aadb63957f7c38073c30a7ca4382d182ac3a8ac978bcb24f9839f7abd6372cefe4cb8de0641fef2ff88f4a9bb7d0a705d192a4c0fcac39fee9a4e33c0e7bae3f954b35bee6f350f35548713abe4039f981e375170e52c45751b90ac18e38276e08ab3b124e637dd8ec7ad428564c8452c33c83c15fad28545ced3b4fa13fca8e625a17714e8580f41cd279e25ea013d318c50dbbafdf3eb8c1ff00ebd432cae72db0954fbc40e57ea28b89a2c82db720e40ec79a6972725938ed8e0555072460f3d71e952ac9f36d6c827f5a5744b193ba5a8cdccc90a8270d23051d3dff00a564cde29d1ec88cdd35c48a412204dc3f338af3692ea6ba94cb34af23ff0079db34c0e376defd723bd6f748cb567583c4f0412de3db59bb9bab833b34f2631c636f1db03d6a37f195e646c8ad531d3e5c91f99ae5a4591c7f11cf6c52340e8a0b90be828b8b53a393c597f3a34723c5246e08653129523d08ef4f87c597b122c6b26c8d46d55550028f603a5735b6251866e7da951c2fdd0d4d485667696fe29b87201989ec32a315a96fad998aeff2ce0e705475af3c469318ce055eb29a557042b103bd5f3ab09a7dcf50b7d40498dca8475240c55af261b93d0ab1eea73c7e35c5d86a1b57691d473baba1b3bfc852c41523040a9e68bdd13cd35b334bfb1ae8b6fb797cc23a01f2b7e47ad45324b04816f233137672b807ebe956ed2f53602a1813d0e7a56aadd0b8458e71e6291fc7ce7da93a309fc2ca8e266be2473e4957c6e03233ec680c4386dc5241c0607b7d7fa1abb3693f664611079adb76e083ef45feefa8f6aaacbbd37444b20e0e7823ea3b1ae794250dce88ce33d889d54b969140ff006a318c7d47f852ecf97259594f460781f5ee29eac02e0fca3d69af1be1648dc871fc5ebf5a8651e2be62c600240c75c8a8deef19dbdfa13c557663eb9a8d9b3c0144aa11ca4ed72e47dee3d0533cd24f43f89a880f5a77ca3a9fcab3e66c5625123ff7a9e24727ef134c4651fc1cfad4c19b3c607e15377dc341f1b367ad68d9dd4d1101493cd51467eb9fd2adc32b0392a0d52a96ea4b48de82fb763cc4049ebc56ad9dc44cebd579edd2b9c86543d548f7157a074dc086e9dba5691afa90e27716ac4431b2c88eac320a9c91ec476ad68240a01237363b57116774f01de1b9cf38ef5d369f7a932ee07e6c735baa91918c91d0c4d8453f312793c74a8750b16957ed56ac16e54637633e60f43eb4e81d881c64f4157836d5041ff7febdab68c94bdd64a6e2ee8e5e0996e48420094f4527e56f5fa539d1e17c0520742a78fcaa1d52dfc8bf9d553e563bc0071d68b7bf2b179173929d1646eabec4f5fc6b8a4b95d8f4632e6574785056209f4e48ef8f5a005c707f4ad1ba525564519287bf71dc553911436f4380e381efe95a55a3ecd99466a445b41ffebd01466a4f439e2838cf15ccc77155454c82a25e0d4f1f5acd924a83daad44a38e2a08c55a8ab2931a2d423a55a8d47a5411f6ab51d65cc32c46481804d6969f72d0c8181fc2b392a78ce08aba755a912d1e83632b9b78a407e590123df070456b40db88273d3a5739a20ce8de6e4e45ceccf6c6dcd6fda37ca58119c75af5a93e6b1cd25d0c8d53126aa63c16221078fad66cd06d25b079e36fb5491dd2ddeb9a84c1f288563520fa75ab40aca5831caf63e9515bde9dceba5a4523c6475354a58c07700f18dc3d8d14575d7d8c6043ce7ad21eb4515e73351e3ad4b1f5a28ac588b517357231c0a28ac24345b8c5594ed4515cef7193c75610e067d28a2aa3d00ecb473b742b641ff2d2691cfd4617f955bd6ef9f4dd06592151bc2e013ef4515ee61ff4399fc460787507f634529e5e563231f735b2adba3040c36ec6477a28ac65b9d8b63fffd9' );
INSERT INTO PRODUCT (NAME,PRICE,DESCRIPTION,IMG,CATEGORY_ID,IMG_SRC) VALUES ('Shovel',20.00,'Sturdy spade for digging','shovel.jpg',4, 'ffd8ffe000104a46494600010101006000600000ffe1001645786966000049492a0008000000000000000000ffdb004300080606070605080707070909080a0c140d0c0b0b0c1912130f141d1a1f1e1d1a1c1c20242e2720222c231c1c2837292c30313434341f27393d38323c2e333432ffdb0043010909090c0b0c180d0d1832211c213232323232323232323232323232323232323232323232323232323232323232323232323232323232323232323232323232ffc0001108005e008003012200021101031101ffc4001f0000010501010101010100000000000000000102030405060708090a0bffc400b5100002010303020403050504040000017d01020300041105122131410613516107227114328191a1082342b1c11552d1f02433627282090a161718191a25262728292a3435363738393a434445464748494a535455565758595a636465666768696a737475767778797a838485868788898a92939495969798999aa2a3a4a5a6a7a8a9aab2b3b4b5b6b7b8b9bac2c3c4c5c6c7c8c9cad2d3d4d5d6d7d8d9dae1e2e3e4e5e6e7e8e9eaf1f2f3f4f5f6f7f8f9faffc4001f0100030101010101010101010000000000000102030405060708090a0bffc400b51100020102040403040705040400010277000102031104052131061241510761711322328108144291a1b1c109233352f0156272d10a162434e125f11718191a262728292a35363738393a434445464748494a535455565758595a636465666768696a737475767778797a82838485868788898a92939495969798999aa2a3a4a5a6a7a8a9aab2b3b4b5b6b7b8b9bac2c3c4c5c6c7c8c9cad2d3d4d5d6d7d8d9dae2e3e4e5e6e7e8e9eaf2f3f4f5f6f7f8f9faffda000c03010002110311003f00f7fa28a280109c76ae3edbc776daa5b432e996b3bf9cbb9564421c7241054648208c57606b91d5b42d574cbd9355f0b1812599b75d5849f2c739ce4b2f60c7bf4cf5c839dd324dab2762a2d277688f55b8f13a69cda8c36f1e2d596e1adcb1124c8a72c8b8e848c8e715d6da5c4579690dcc0fbe1991648d87752322b8a5f88502a4f65aae9f71a66a22172914ea76b900f438ff0011ef5d178523f2bc2da626fde05bae0fb761f80c0a231e556149dddcd9a28a2a84145145001451450014514500145145001451450014514500656bfa1daf8834a92cae8119f9a29538785c7dd753d8835cff0083cc9a1c4346d466ff004a2e4055188d5b19213bed206e19f5c76aed08cd73de28d0c6a966268415bb87e6465e1b8e463dc751f977a8a9cd6bc4ba7cae5691d083914b5cff0085f5c7d56c76dcaedba84ec738c07c7f12fb1fd2ba0a709292ba14e0e12e561451455121451450014514500145145001451450014514500148466968a00e4f57b29349be1a9da0c44edfbc51d118f7fa1fe75d069d7f16a16c258c8c8e1d7d0d4f34293c2f148a1a3704329ee2bc7b5ad7f55f0178ed77b48fa3b2ae6323e578fbb8f70783e9c7ad64a0e33bad99a39a946cf73d9a8aaf657905fd9c3756d209219903a38ee0d58ad4cc28a28a0028a28a0028a28a0028a28a0028a28a0028a28a002b9ef17f85e0f14e8cd6ae563b98f2f6d2919d8f8e87d54f422ba1a2803c53e1e78a27f0b6b8de13d683c50cb294b72e73e4cbdd09f43d8fd2bda857997c5bf07c7aa696dad5b26dbab751e73270c547dd7faa9fd3e95b3f0cfc5a7c55e168dee187f68599f22e8772c3a37e22803b5a28a2800a28a2800a28a2800a28a2800a28a2800a28a2800a28a280192c692c4f1c8a1d1d4ab29e841ea2bc1f4791be1bfc649f4f91c8d335021327fbadfeadbf03c7e35e95affc4ff0af872f65b1bdd418de4470f0c519241f4c9c2e7f1af2bf88fab69de32f15da0d2e4cb5bda84669a3313162770c06c12077faf7a00f62f1878cb4ef06e906f6fcbbc8f95b7813ef4cc3b67a01ea4fe192403c2781fe31ff006add4d6fe255b6b1f3653f659a3c84453d164cf4ff007ba7a81dfcb3537d5f55b831ea377737535a644493ca5fcb1d085cfe1c8ea31552168210429cb77cd007d761b201a5af06f87ff10ee349d56c746bb91a5d32e25581371c9b766202ed3fddc90083d33918c73ef22800a28a2800a28a2800a28a2800a28a2800a28a280384f1b7c3f835c67d574d8208b5855e599401700740c7b1f435f3b5f5b5d26bf3fdba1956747d92c3282acb8ed8afb108cd616bfe12d1bc4683fb42d41980c25c47f2c8a3ebdc7b1c8f6a00f0ad2ada06b9b7bb5b890f963063957248c74dddff001aaf77e170f3cb347c2b92c141e95e8779f0a6f2d99a4d3b5385e31d04ea5187e2b9cfe42abd9784b557944466b42dea5db1ff00a0d0079a5b786aee6d52dade3cef9278d508ec4b8c7e5fd2beaaae43c3de0dfeccd405fdf491cd7118c40b183b532396e7a9ea3d87d78ebe800a28a2803fffd9' );
INSERT INTO PRODUCT (NAME,PRICE,DESCRIPTION,IMG,CATEGORY_ID,IMG_SRC) VALUES ('Watering Can',25.00,'Durable and stylish metal watering can','wateringcan.jpg',4, 'ffd8ffe000104a46494600010101006000600000ffe1001645786966000049492a0008000000000000000000ffdb004300080606070605080707070909080a0c140d0c0b0b0c1912130f141d1a1f1e1d1a1c1c20242e2720222c231c1c2837292c30313434341f27393d38323c2e333432ffdb0043010909090c0b0c180d0d1832211c213232323232323232323232323232323232323232323232323232323232323232323232323232323232323232323232323232ffc0001108006e008003012200021101031101ffc4001f0000010501010101010100000000000000000102030405060708090a0bffc400b5100002010303020403050504040000017d01020300041105122131410613516107227114328191a1082342b1c11552d1f02433627282090a161718191a25262728292a3435363738393a434445464748494a535455565758595a636465666768696a737475767778797a838485868788898a92939495969798999aa2a3a4a5a6a7a8a9aab2b3b4b5b6b7b8b9bac2c3c4c5c6c7c8c9cad2d3d4d5d6d7d8d9dae1e2e3e4e5e6e7e8e9eaf1f2f3f4f5f6f7f8f9faffc4001f0100030101010101010101010000000000000102030405060708090a0bffc400b51100020102040403040705040400010277000102031104052131061241510761711322328108144291a1b1c109233352f0156272d10a162434e125f11718191a262728292a35363738393a434445464748494a535455565758595a636465666768696a737475767778797a82838485868788898a92939495969798999aa2a3a4a5a6a7a8a9aab2b3b4b5b6b7b8b9bac2c3c4c5c6c7c8c9cad2d3d4d5d6d7d8d9dae2e3e4e5e6e7e8e9eaf2f3f4f5f6f7f8f9faffda000c03010002110311003f00f7fa28a2800a28a2800a28a2800a4a5a86e2e23b689e69982448a5998f402801659a38633248e1507526b365d537c4cf1910c4a325df8c7f8571f75e207d52e9ee256f2ad22c944f41ea7deb6b4cd0df550b73aba308010d0d9374c76690773eddb8cd65cdcced136f66a0af221fed1b9d598ae976d35e26706e247f2e21f89ebf8507c33acdd0ccd796b013ced8779c7e3c1aec0200001c01c014ec53e44f727dab5b1c945a578974d25edb528ae9782629c9c1c76048247e7535878c2d25d41b4dd4617b0bf4c6e8e5e87dc1f4f7e95d3919ac0f157856cbc53a70b7b92d15c444b5b5d20f9e1623b7b1ee3bfeb4f95a5a0b9949fbc6f020e08fcc53abc9bc21e2fbfd135997c33e221b6e206da1b39041c1054f70410715eaeac19430c1046411de9c64a429c394751451544851494b40051451400138ae1fc7daa8416fa6a390cdfbd900f4e401fcff00215dab90aa49c63debc735bbff00ed3f145ecc5c796b2145c764418cfe87f3acab4ad1b1b508de5737fc23a39bfbdfb44eb9b6b620956e8f2632a3e801cfd715e8a063af5af31b7f1b3e8ba3c30da69af70465a47072771e49c7e3fa5661f8bd79247ba3b4897071c9a88548c558a9d39ce573d8e8af24b5f89fa8cb1194c10903b569dbfc47b9687cd92ca32a33901b9aa55a24bc3cd1e91495c469df13748bd62b22c90ede1988e01aebed6f6daf6112db4c92a1eea6b45352d8ce506b73cebe2ef877ed7a641afda92975a79dae57bc648e7ea1b1f8135aff000dfc4a75cd0962989fb44390d9faf3fcc7e045759a8d947a969b73652ffabb889a36f60462bc4fe1dddc9a3f89d6de46c24a42b8ed924a9fe86b29fbb34cd61efc1a7d0f77ed59f7faa4365c13be5dace22419660064e00e49f61cd2ea5a941611c4259551e691628c13d58f403fcfe95c37f68057d3753ba9c34ad6d73b9e483ca6e8187c9cc8070bf2e41e84f3b41d1cac6518df5374f89eeb742e6cae1229447b498c1019b24ab73f2ec009662401d324d6f586a11df2394203a1c3ae738c8c83f4239ae0e5b15b5b1303dbe996f1c701b43f6962239530bb76c59c22b48dc8e49c283c918def0d393ad6a0bf780455665181952474eddea799dec5b87bb73aba28a2b53239cf191beff847e74d3f3e7ba95523d71d3f1e71ef8af1d0ef6f1de960cb2476ee5830c30e475cfd6bd9bc6633e10d4b920f943041c11c8af14b9d7e78a330df5bc3a8c4cbb18cb95931fef8e6b96bee7661db7163346d5266987cc73d33e95d9378634bf1159b8b888dbdc3818b9b7015f3ea78c37e35c769973a133874b5d42ddfd03acabfaf3f9d769a76a968a310cd77c7636e7fa1acd3468d3b1c9ea5e09d6f408e5f23fd3ec8f3e642086503fbc9d47e19aa50de04d36442467d3debd166f114099569ae14fb5bb7f8d731a9be8ba8176782fd9d8e59a18c465bea4e68925d0716fa9c5d8de22c376ac705ba739af42f85b3ea42fcff00acfb03e1577670cd9f9b6e7a80339ed9c5737145a7d8aeeb2d0612ff00f3d6fa43311efb7eefe95d1fc36bfbfbef1e4a6f2ee4942d8c8163ce1146e4e8a381443e242a9f033d96be7eba5161af4f3db805629a464e320ed248e7f0af7d9e55821795ce1114b31f403ad786496e2f2750506fb8944780471bdb071f9d6d5fa239f0fd4f43d4b517b9d64c3697d08991c2476fe5124b85672a64e426571938f94383d596b26d7cbb85bb8f4f7b5921bc459841e7491e51c30250803cbdefb9b772ccaa7ae46dbba9417f15c4f1f9777340c636f2eda511ba15740117001dad92cec587cb802b175ff1359e8bb5ef6e7cfbdb7bb79ade1063791d4860b938c44bf3100fdec71d49aa6edb828f62c5f6a1616307dae2b6d39649249953cb22562eb275dd8c0c15048e70c0018db5a5f0fb50b49e6be06e3fd28b2af96dfdd19391ea79e7e95e63a85af89af74d97c4d73a7cde46e0918588aac484f509d760f5c77c93deac782f558639552572a4904480e1837ae6b1e76a49b35e44e1647d060d2d61e97abb15486ed81cf0938fbae3dfd0d6de78aeb4d338dab185e34ff914352ffae5fd457cf7a9b735f41f8d0ffc521a97fd72fea2be79d48fcc3e95cb88f891d786f8592e8adfbe02bd37424002f1d7d4579868fc4e3eb5ea3a19cc69594773796c49ad443ef051d3d2b9d7000e82ba6d68fee85732e7ad396e4c7633ee738278ad2f85a73e3c9ffebca4ff00d092b32e8f06adfc39bdb7d3fc5d7b7975208e08ac642ee7b7cc981f53443e241557b8cf4ef19ea62d348fb2a64cd7476803b28ea7f90fc6b89f0d69ff006ff17da5b1276da2fdb2538f43845fc4e4ff00c06abeb3e2037b713ead7619625c08a25e4819e147a927f535dd781b409f49d2a5b8d4557fb4afdfce9c2e7f763a247ff015ebee4d6ebdf9dfa183fddd3b7566e6a1a3d8eab1ecbdb649876ce41fcc60d66d87823c37a64c25b5d1ad1650721dd77b67d72d9e7deba1a2b7e54735d8c64dca548c83c10475af27f19fc3230c8fab7866208c32f3588e878eb1fa1c8fbbf963a57add34ae454ca0a4ac38cdc1dd1e1de18f1832e2caef381852ae3073ef9e457a7699acaa448c6432db1e01ead1fd7d456378d7e1d5b6bde66a3a614b4d6065b77449cf60fe878e187e39af3cd27c45a8f86f51934fd4e29219a260af1b8e71cfe041ec7bd61ad37a9d3eed55a1ebfe309125f05ea3246c191a2043039c8c8af9eb523f3fe15ec325eaeb7a0dd5bd84ea12e136bc6fced3c1c8f4af22d6ed67b3ba68678ca48077e847a8f5151565ccd32e84795341a3f130cfad7a8e847f74b5e5ba49fdfae3d6bd4741ff0054a6a23b9acf62ceb5feac7d2b9993a574facf3129f6ae5a53cd396e286c50ba2306b0eca548f537dc09240011412ced9e0003a9e2b6ae8fcad5a5f0b155fc75286556db692329201da7720c8f4ea688abb48751da2d9d5783fc17732dd41ad6bd1189e13becac09ff0054dff3d24c705f1d07419e727a7a3018ed48060d3abb6315156479d29b9bbb0a28a2a890a314514009806b9cf1678374df165988ee97cab9887ee6ea31f3c7edeea7b8ae9283d29349ab31a6d3ba3e71b9835bf046ac2cef7284730ca872930f553fcc75151f8a3535d46ced6465512862188eb823fc6bd5be2c5cc10f8265b77852496691445b867cb2392c3d0e38fc6bc14b4ce8ab2f017a0ef5c5522a2ec8efa32e657668e904f9c33d73cd7a9681fea96bcb3493fbf5af52d03fd5afa54c772e5b16f59ff523e95cb4bd6ba9d607ee4572d2f39a72dc50d8cdba0306b57e1571e3b980ff009f293ff434acab9e87e9577e1ade259f8ec06507ed113420f704907ff6503f1a21f120abf033dda969296bbcf3428a28a0028a28a0028a28a00e63c71a1cbade80d1c11996688ef58d4805c6304027f8bb8f702be7fd52c66d3f1e726232e5165c70587553dd587753c8c77afa9980230466b1758f0d69bab8769a2f2e570034b181971e8c082187d41ac6a53e6d4da95570d0f9d34823cd53d39af51d07fd5ae0e7ad17bf0ba3b790c96ef032920654b4247e0372fe407d2b31f66812c692dcdc0de3728455938f73f2ff002ae7e5717a9d5cea4b437f5961e48f5ae56660b9c9a7dc6b96b7aeb199eec6f6da3f72bdcffbc6b6ecbc1cf7f27cae1b079324e47e8a9efea29b8b93d06a4a2b538db894bb88a252f239c2a28cb31f402babf873e17993516d52751bd1b6b60821083f741e85b38ce3a631d6bafd37c13a7dab66563263ef471af968dd783d5987b16c57510c11410a45122c71a8015146028f402b5852b3bb30ab5eeac8968a28ae8394ffd9' );
INSERT INTO PRODUCT (NAME,PRICE,DESCRIPTION,IMG,CATEGORY_ID,IMG_SRC) VALUES ('Axe',20.00,'Virtually unbreakable axe with ultra-sharp edge','axe.jpg',4, 'ffd8ffe000104a46494600010101006000600000ffe1001645786966000049492a0008000000000000000000ffdb004300080606070605080707070909080a0c140d0c0b0b0c1912130f141d1a1f1e1d1a1c1c20242e2720222c231c1c2837292c30313434341f27393d38323c2e333432ffdb0043010909090c0b0c180d0d1832211c213232323232323232323232323232323232323232323232323232323232323232323232323232323232323232323232323232ffc00011080080008003012200021101031101ffc4001f0000010501010101010100000000000000000102030405060708090a0bffc400b5100002010303020403050504040000017d01020300041105122131410613516107227114328191a1082342b1c11552d1f02433627282090a161718191a25262728292a3435363738393a434445464748494a535455565758595a636465666768696a737475767778797a838485868788898a92939495969798999aa2a3a4a5a6a7a8a9aab2b3b4b5b6b7b8b9bac2c3c4c5c6c7c8c9cad2d3d4d5d6d7d8d9dae1e2e3e4e5e6e7e8e9eaf1f2f3f4f5f6f7f8f9faffc4001f0100030101010101010101010000000000000102030405060708090a0bffc400b51100020102040403040705040400010277000102031104052131061241510761711322328108144291a1b1c109233352f0156272d10a162434e125f11718191a262728292a35363738393a434445464748494a535455565758595a636465666768696a737475767778797a82838485868788898a92939495969798999aa2a3a4a5a6a7a8a9aab2b3b4b5b6b7b8b9bac2c3c4c5c6c7c8c9cad2d3d4d5d6d7d8d9dae2e3e4e5e6e7e8e9eaf2f3f4f5f6f7f8f9faffda000c03010002110311003f00d7f16fc57d6b43f88375a4d85959cf636251258a4cef98b22b921c7dcc6718c374c907381de786bc6fa3f89d4456d335bdf6dcb595cfc928f5dbd9c7ba93d79c5797fc5df0ddc597884f8a2c91a48e7444bc8d06595946038f5054007d36e79cf1c7da6ab65ab4403ed2c0ee1ce0861c823b83ee3ffaf59de49969268fa901ed4b5e2ba1fc42d6f446582f99f57b15c0cc8c05ca0ef873c3e3d1f93fdfaf53d0bc45a5f88accdd69776b3229c48846d788fa3a9e54fd7af6aa524c97168d8cfb52d301a703c55085ed8a29334138a005cd19a063b503ad0019e6968a2801334138a0629714009ef4b4514019f7b6105fc2d14e81948c735e57e27f83f6d70cf77a61682e393ba338e7fad7b05211401f2ddcc7abf86a6f2357b73e4f4170aa76e3fda1dab4b4fd4258af21d4b4cb936f7718fddcd1f391d70474653dc1e3f9d7beeaba0d8ead6ed15cc28c1863915e2fe28f86f7de1d99ef744064b7cee6b6278ff80fa1fd2a1c7b16a5dcf4ef0878e20f1085b3bb8d2d75455dc6204ec980ead193faa9e47b8e6baf539af98ecaff00ed056447920b98183020ed92271d08f422bda3c17e341ad22e9fa8158f5455c82385b851d594766f55fc471d08be8c4e3d51db514d53914eab24774a052039a5a00091451450014b9a6934b8a003d68cd14500328c514500262a39a14990aba820fad4b4500793f8ebe1d0b866d5348022bc41938e8fec4579f58de4a6610befb7beb770dc1c3c6e3a107f91afa59d038208c835e61f103c066f07f69e980477b10c823a38fee9a968a4ec747e0cf182ebd09b3bd2b1eab0ae5d470265fefa8fe63b575a0fbd7cdba66a32b4e843c967a9da3e55bf89187f31fcc57b57843c5b1788ad4c53858753807efe11d187f7d7d54fe94297460e3d4eab34bd0d373914b9aa247668073494038a0075274a334bd68001d28a2909a006d1499a5a0028a28a004a8e445914ab0c8352e29b401e4df103c09248e756d286cbb8c72a38120f435c2693ad4cb750cf048d6ba8dab10091ca9eea47707d2be909a15950a30c82315e43e3ef004a666d5b481b2e472ca3a38f7a96bb149f73bcf0a78badbc456e6270b06a310ccd6f9ea3fbc9eabfcaba6c8af9934bd6245bb46df259ea36cdf2b0e194ff009fc0d7b0f85be2041a83258eafb2daf4f092e711cdf4feeb7b5252e8c1c7aa3bb07de94d301a70ab24751cfad2668cd002e7d683c9a28a006d18a28a0028068a2800cd18a38f4a28012a39a15950ab8c83daa5e692803cb7c71f0da1d4f75ed88f2aed4643af7f63eb5e54f717ba3dc1b1d620239c073f75be95f52b2e460f7ae63c49e0dd3f5eb67496142c7be2938dc6a56382f0c7c41bbd29121ba2f7da70000e733423d8ff0010f6af57d2f57b1d62cd6eec2e52784f52bd54fa11d41af9e75df066b1e169da5b50f71680e767f128f6f5aafa2f8967b4ba175637525a5d29c165e037b3a9e0fd0d45dc4bb296c7d3a0d2d79f786be255a6a063b5d6152cae4e02cd9fdcc87ebfc27d8f15deab83d0f6cfe1eb569a6434d12f4a514c0d9a5cd31083ad2d251cd002d149cd0280168a290d002d1451400629b8cd3a834014eeec61bc8cc72a06047715e57e31f85b15c97bcd33f7171d729dfd88ef5ebf51498236e339a00f94a496f746ba365a9c254e7682c3e57fa1f5ad95f11eaf1d8dbdbdb6b57f0d940c5a38e394a90f8c000f5dabc9c74c9c7ad6a7c5ad634cd5ef0695a622c8216dd7374a38247f021efee7f2ae1d265d8a89c2a8c05f4a70a7adc25376b1ee3e05f89d16b12c5a4eb8c90ea670b15c636c7727d3fd97f6e87b7a57a52b678af906421d08600a9ea2bdb7e0ef8b755d762bfd2f519a3b91a7a4663b8793f7c431236b0fe2031f7b8ec39ed528db5424cf53a29339a5a81851499a5a00075a318a28cd00140a281400bcd21a3346734019faaeaf63a35a9b9bfb98e08bb163cb1f403a93f4af1ff17fc4c9f558e4b1d2d1edecdb2aee4e1e41e9c741ec3f3ed5d17c5ad0a5bbb28755814bbdb02aea3fb87afe46bc61e4c8eb5a4229ea4b63257dc339e4f35425041dcb907d4559790671c03e952e99a55debbab5b69962bbae6e5b6a9c7ca83bb9f6039fc877156c41a4691ab788649a0d26cccf3c49b9f730555f404f4c9ec3dabe83f86fe0a8fc1ba1f97232cba8dd61eeee17a3301c2ae7f857271eb927be06b785fc2b61e19d221d3ece3f95065e46fbf2b9eaec7b93ff00d6e82b7d576f418158c9dd9490519e28a290c28181451400b4527346680178fc68a4c9a05002d145140105cc11dc40f148a191c6083debc07c79e03bbf0fcf25f58c6d2e9ac4921464c3f5f51fcabe8422a29a14990a3a0653d41a69d84d5cf8f5df2b956241f4e335ed5f043c39e4e9173e209d732de37936fb872912139c7fbcd9fc156b57c45f07744d6a77b8b3964d367739678141527d4a1e0fe18aef349d36df47d2ad34eb552b05b44b1460ff007546067dea9cae0917178a766928a819ffd9' );

就差不多了。