java_ee_sdk-8u1-web.zip

INSERT INTO "FOREST"."CATEGORY" (NAME,TAGS) VALUES ('Plants','Seeds, trees, flowers ...') INSERT INTO "FOREST"."CATEGORY" (NAME,TAGS) VALUES ('Food','Foods, healthy items ...') INSERT INTO "FOREST"."CATEGORY" (NAME,TAGS) VALUES ('Services','Fence installation, gardening ...') INSERT INTO "FOREST"."CATEGORY" (NAME,TAGS) VALUES ('Tools','Tools for gardeners and landscapers') INSERT INTO "FOREST"."PERSON" (FIRSTNAME,LASTNAME,EMAIL,ADDRESS,CITY,PASSWORD,DTYPE) VALUES ('Robert','Exampler','robert@example.com','Example street','San Francisco','81dc9bdb52d04dc20036dbd8313ed055','Customer') INSERT INTO "FOREST"."PERSON" (FIRSTNAME,LASTNAME,EMAIL,ADDRESS,CITY,PASSWORD,DTYPE) VALUES ('Admin','Admin','admin@example.com','Example street','Belmont','81dc9bdb52d04dc20036dbd8313ed055','Administrator') INSERT INTO "FOREST"."PERSON" (FIRSTNAME,LASTNAME,EMAIL,ADDRESS,CITY,PASSWORD,DTYPE) VALUES ('Jack','Frost','jack@example.com','Example Blvd','San Francisco','81dc9bdb52d04dc20036dbd8313ed055','Customer') INSERT INTO "FOREST"."PERSON" (FIRSTNAME,LASTNAME,EMAIL,ADDRESS,CITY,PASSWORD,DTYPE) VALUES ('Payment','User','paymentUser@dukesforest.com','-','-','58175e1df62779046a3a4e2483575937','Customer') INSERT INTO "FOREST"."GROUPS" (NAME, DESCRIPTION) VALUES ('USERS', 'Users of the store') INSERT INTO "FOREST"."GROUPS" (NAME, DESCRIPTION) VALUES ('ADMINS', 'Administrators of the store') INSERT INTO "FOREST"."PERSON_GROUPS" (GROUPS_ID,EMAIL) VALUES (1,'robert@example.com') INSERT INTO "FOREST"."PERSON_GROUPS" (GROUPS_ID,EMAIL) VALUES (2,'admin@example.com') INSERT INTO "FOREST"."PERSON_GROUPS" (GROUPS_ID,EMAIL) VALUES (1,'jack@example.com') INSERT INTO "FOREST"."PERSON_GROUPS" (GROUPS_ID,EMAIL) VALUES (1,'paymentUser@dukesforest.com') INSERT INTO "FOREST"."ORDER_STATUS" (ID,STATUS,DESCRIPTION) VALUES (1,'Pending processing','') INSERT INTO "FOREST"."ORDER_STATUS" (ID,STATUS,DESCRIPTION) VALUES (2,'Validating payment','') INSERT INTO "FOREST"."ORDER_STATUS" (ID,STATUS,DESCRIPTION) VALUES (3,'Ready to ship','Payment approved') INSERT INTO "FOREST"."ORDER_STATUS" (ID,STATUS,DESCRIPTION) VALUES (4,'Order shipped', '') INSERT INTO "FOREST"."ORDER_STATUS" (ID,STATUS,DESCRIPTION) VALUES (5,'Order cancelled','$1000 order limit exceeded') INSERT INTO "FOREST"."ORDER_STATUS" (ID,STATUS,DESCRIPTION) VALUES (6,'Order cancelled','Cancelled by administrator') INSERT INTO "FOREST"."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, CAST (X'ffd8ffe000104a46494600010101006000600000ffe1001645786966000049492a0008000000000000000000ffdb004300080606070605080707070909080a0c140d0c0b0b0c1912130f141d1a1f1e1d1a1c1c20242e2720222c231c1c2837292c30313434341f27393d38323c2e333432ffdb0043010909090c0b0c180d0d1832211c213232323232323232323232323232323232323232323232323232323232323232323232323232323232323232323232323232ffc0001108006d008003012200021101031101ffc4001f0000010501010101010100000000000000000102030405060708090a0bffc400b5100002010303020403050504040000017d01020300041105122131410613516107227114328191a1082342b1c11552d1f02433627282090a161718191a25262728292a3435363738393a434445464748494a535455565758595a636465666768696a737475767778797a838485868788898a92939495969798999aa2a3a4a5a6a7a8a9aab2b3b4b5b6b7b8b9bac2c3c4c5c6c7c8c9cad2d3d4d5d6d7d8d9dae1e2e3e4e5e6e7e8e9eaf1f2f3f4f5f6f7f8f9faffc4001f0100030101010101010101010000000000000102030405060708090a0bffc400b51100020102040403040705040400010277000102031104052131061241510761711322328108144291a1b1c109233352f0156272d10a162434e125f11718191a262728292a35363738393a434445464748494a535455565758595a636465666768696a737475767778797a82838485868788898a92939495969798999aa2a3a4a5a6a7a8a9aab2b3b4b5b6b7b8b9bac2c3c4c5c6c7c8c9cad2d3d4d5d6d7d8d9dae2e3e4e5e6e7e8e9eaf2f3f4f5f6f7f8f9faffda000c03010002110311003f00f7fa28a2800a28ac0f16f89a0f0ae8e750b84f301708b1870a589f4fa75a4da4aec1bb1bd9a896e626242ba92adb08cf46eb8faf35f3a5e7c58f105fc66d0de476f1c995c421964db93fc7d43018e722b988bc57ab5b48c61d42ee0691b78912729961900e738ee7d7eb58fb65d119fb55d0fa9f52d734ed223325f5dc500033866e4fd077ae46e3e2f785a39c4505c4d70588d8cb190af9e4e09c723df15f3bc97f773c6ada84ef3166da198e73c9c9639c93c9eb9a91ed60ba1e589479ea42ec0a155d7a6723f0e3152eabbe843abae87d39a2f8f7c3dae2016fa9431cfb773c32b0564e71c93c7e469f71e39f0fda6a0f63757eb04c8fb18383807b67ebd41e95f284cf3f9f1b48009914ee638c8edd4739c71fe35656f6e6de40b2ef94ec0f9dd9e3f84f20e0d54aacba0fdab3ec7595580c1072323dc7ad381cd7cbda3fc41d7b48b896e1ae669a73b5374ec589507383b81e39e830066bd83c0ff11e2f11e21d405bdadd48c16244727cd6f989da3b000773fd29c6b27a32e3513d0f42a29aac18641c8a756c5851451400534b051934ece2b86f89dac49a6785256b4bf8ed6e4c88012e0330cf20039ec0fe00d4c9f2ab89bb2b90f8e3e245af85ee3ec514467bbc0660ae3e41d4e4673d31f5cf5af0df19f8ef54f175c99a755b78e0dad1c08e76e3a649ce4b127d0718fc70aff53bfbfb8f32691af2425638c3be58e3000f53c63bd559235711cbf3bcbbb0c3192bce78f7c7f5ac2ee5abd8c1c9cbd0bd25c473406260bb18614c6b805b18ea473ef55848f0dd3189362b603315ce3d73fe7b54d1ac9752b4e646cef01500c819e809180723d3d297538cdbda2e1f6248c15e35e7d5810718fc07a566ac9d8cc8a58dee4bef6f3153ab8704803ebd491daa78c48522720cbf2364b0e14f4c7d7e9c8aac11f646cac5d00dc5d1f2cfcff17b8ab1e6fda24891369c3e49600053ff00d7f4a5aad8453bb1247218e17756404489b8e00f41d689a09dc2a8064997ef1572c7eb9efed834ed4dbf788228d0485c97dad939f7e7a52c4d3e1564711ee05f0e70b8ef8e7a9f4ad16d72fa0f30badaab484396380aed96c8ec0753c9ab5a4ea33e99742f6d4cc93c60ac6d1a85009c020f07391907eb54a79e61289db6b2e7070bf2f1d3dfbfb53a180c9c9972c50e237dc021cf5c7d39a96bb88f61f08fc5f6b6b7fb3eb693cd33cbb8cbb97804fdd0a00c63803d726bdae0984a8add32a0e339c57c6513856c92bf28c6e001e9e9fe7d2bd53e1e7c44bc8afec348bd94bda01e483e580c39f97278e72793dc01550a8e2eccd6153a33dfe8a6a1c8a75751b0d6e9cd7cd5f146f2ea0f135eda5edd44227918c50c641dbe8cdd70c70091e9f5afa42f1b65ac8d92308791f4af93fc5e97875f94ea718179bf75c64fcdbd80396fc3f2c62b1ab2b5919d47a1cd476d3dc36f50bf21df18c1c313e9db1c568f911456f2cf26dc11b64f2beec671c63fcfad429711db416db6671b461c28c6f39ed9e9c1eb4ae8b290500dbb4908cdd7a0e09ea339fcab2777a18b06bb58dc1495515d40fdd8da08c756cf1bb8a70b88ae2d31bcb3a38731b0395e3ae73fe73502c492a6df310471a9288cb9e7bfbe7dfdaa4692148d9f3b9d86ccaaf03b60fbfbd4da3b12ec4f0c588a478b771f326e1cafaedc1a7476e6311b8901327ef0bf1839ff000a8219a448be74910b1f92404e79e368ed8ef5085533ef40884a85eb93c75a5caf5b8ac4970b28b9511b29c0c3123e53ee7d0fb5456b1f96591cc512c87e62ed80719c03e9cfa55892583c92f0a852d90d1ca727af18fad221610b2387dcc8176cdd38eb8cff00915717a58a5d8a2d1ac924a7cd3236fda0386248f5c9ad48e189edc3c6abe76d0e58f050671d476e41aa52a87bb522289107544e9566e2e2365119b23b64552ce8c41563dc03d88ed44aef61bd46b32098c318f3228b3b4b8e4f393db91927f4a9ad9ae74fd420b8390eacaebb58ab0039ea3a671d6b3adda78d269da394aa6102b1000c83c9fcb356445744cb24d26d641b4956cede38e3d3d87a52920d8facbc21ae41af6816d7716c562837c6afbbcb247427d6b7ebccfe0fddda8f0f9b0b5b768bca6deeccc0f98ec06e2bec0e4735e995d3097346e74c5dd18de25d55f46d1a5bd5844c130a5338273c71ebce38af96b5d926d675296e66964b97076c729fbcea385cfbed02beb3d474eb5d52c9ed2f22f3607c6e4ce33839eb5f3f7c5bf09c3e1dd460bab0d91dbdeb3ec863e18303b9b27a639007a0e2b2aca574d19d44f73cca24c3168c82889b49ce58839cf07d307f0c55e816d9ee9d5627f26384286c6ee41cf3e99ef4cb4264d45e158a201830577936845c724fa9eb8fad3a3b669199407c04048cedc81ebdb18c544a5d0c591472f91e710bb1db1863c67be01edc7e751cb215915cefd9b7018819cfaf1fceaec852ea758e652c321f7a63e41fd78c7e74db88095f34a104908a921cb6d23391edc7eb5319771221b41f6a4091b2e2307e695be5049ed4341e6dc4a8761653f7bee8f5e2a6b3f252005a224756607846e4e07afbd59859e68669e3556006648d901ffbe6a652698ba99cd1b5adb3cbb1240ff2b2939d87b1a9e69ae8ac6d3464c0002553a03d327b8a956ed6d8fd9d23f2ddd3322b1dcaf9e841aa6d13c6c92162eb245caa3e0a8cf46f615a4757a9488a3bf78bca0f024b0c2fbf6ecc6eed8dd52dbc9e6dcc9b5918291206704924745f6fe5c5472b2fda81b43b611b479523e41ec00ff3c55fb4b413cde42aa4802b15fe10303bb771ff00d6a6f4d87e85430dd2c91cad16c8ce577b721b91c73f41ef535c451b46ad93248ec4944181d08c01dba9a7d94c8d2c6b791930f99b4bbe708debc1ea0532625eea5f2588b61f7982e393d0f3c8e7159bb