-- phpMyAdmin SQL Dump
-- version 5.2.0
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Jun 10, 2024 at 06:56 PM
-- Server version: 10.4.24-MariaDB
-- PHP Version: 8.1.6

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";

CREATE DATABASE IF NOT EXISTS `teadb`;
USE `teadb`;


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `teadb`
--

-- --------------------------------------------------------

--
-- Table structure for table `databasemanagemententity`
--

CREATE TABLE `databasemanagemententity` (
  `ID` bigint(20) NOT NULL,
  `FINISHEDGENERATING` tinyint(1) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `databasemanagemententity`
--

INSERT INTO `databasemanagemententity` (`ID`, `FINISHEDGENERATING`) VALUES
(1, 1);

-- --------------------------------------------------------

--
-- Table structure for table `persistencecategory`
--

CREATE TABLE `persistencecategory` (
  `ID` bigint(20) NOT NULL,
  `DESCRIPTION` longtext DEFAULT NULL,
  `NAME` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `persistencecategory`
--

INSERT INTO `persistencecategory` (`ID`, `DESCRIPTION`, `NAME`) VALUES
(2, 'Rainbow, Fairytale', 'Unicorns'),
(3, 'Saltwater, Freshwater', 'Fish'),
(4, 'Man\'s best friend', 'Dogs'),
(5, 'Various Breeds, Exotic Varieties', 'Cats'),
(6, 'Lizards, Turtles Snakes', 'Reptiles');

-- --------------------------------------------------------

--
-- Table structure for table `persistenceorder`
--

CREATE TABLE `persistenceorder` (
  `ID` bigint(20) NOT NULL,
  `ADDRESS1` varchar(255) DEFAULT NULL,
  `ADDRESS2` varchar(255) DEFAULT NULL,
  `ADDRESSNAME` varchar(255) DEFAULT NULL,
  `CREDITCARDCOMPANY` varchar(255) DEFAULT NULL,
  `CREDITCARDEXPIRYLOCALDATE` date DEFAULT NULL,
  `CREDITCARDNUMBER` varchar(255) DEFAULT NULL,
  `ORDERTIME` datetime DEFAULT NULL,
  `TOTALPRICEINCENTS` bigint(20) DEFAULT NULL,
  `USER_ID` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `persistenceorder`
--

INSERT INTO `persistenceorder` (`ID`, `ADDRESS1`, `ADDRESS2`, `ADDRESSNAME`, `CREDITCARDCOMPANY`, `CREDITCARDEXPIRYLOCALDATE`, `CREDITCARDNUMBER`, `ORDERTIME`, `TOTALPRICEINCENTS`, `USER_ID`) VALUES
(607, '360 East 1509 North', 'District 104, Utopia, 29872', 'Helene Johnson', 'Visa', '2024-07-31', '9174 9017 4504 1255', '2008-02-10 10:50:00', 44410, 507),
(612, '3108 West 1705 North', 'District 402, Utopia, 14384', 'Helen Johnson', 'MasterCard', '2024-04-16', '1903 4250 1903 3810', '2014-07-05 06:33:00', 126617, 507),
(616, '177 West 5357 South', 'District 431, Utopia, 10615', 'Stephen Harris', 'Visa', '2026-06-02', '5787 8320 9288 4541', '2011-02-09 22:25:00', 71172, 509),
(622, '1681 West 6566 North', 'District 161, Utopia, 22095', 'Margaret Clark', 'MasterCard', '2023-04-17', '7578 2213 4557 8530', '2015-09-05 06:00:00', 13839, 511),
(625, '4924 East 4126 South', 'District 19, Utopia, 24209', 'Margaret Robinson', 'MasterCard', '2023-08-11', '9869 5357 3948 2160', '2009-03-15 06:20:00', 71646, 512),
(631, '6640 West 4462 North', 'District 37, Utopia, 31040', 'Margaret Robinson', 'Visa', '2024-12-17', '6203 3726 5135 2692', '2015-05-12 09:37:00', 129215, 512),
(638, '7075 East 5528 South', 'District 261, Utopia, 31091', 'Margaret Robinson', 'Visa', '2023-03-07', '9954 2778 1546 7925', '2017-05-06 18:57:00', 22873, 512),
(642, '6159 West 3126 South', 'District 160, Utopia, 30979', 'Elizabeth Jones', 'MasterCard', '2024-10-29', '9452 5691 7463 9820', '2015-01-24 17:58:00', 23595, 513),
(644, '1140 West 7568 South', 'District 25, Utopia, 41924', 'Elizabeth Jones', 'MasterCard', '2018-05-15', '1398 5071 2593 9030', '2016-03-23 20:13:00', 27039, 513),
(649, '23 West 7821 South', 'District 35, Utopia, 30065', 'Elizabeth Jones', 'MasterCard', '2026-06-30', '4199 2315 8102 4978', '2016-04-17 07:22:00', 109209, 513),
(655, '2 East 386 South', 'District 289, Utopia, 10403', 'Lisa Wright', 'MasterCard', '2027-10-31', '5302 5572 7157 4683', '2009-05-14 04:57:00', 18510, 514),
(660, '6600 West 1522 South', 'District 80, Utopia, 20228', 'Lisa Wright', 'MasterCard', '2024-09-14', '8430 4729 7941 3277', '2009-04-17 08:07:00', 46980, 514),
(664, '8785 West 8968 South', 'District 153, Utopia, 47022', 'Raymond Robinson', 'MasterCard', '2026-08-29', '2604 7526 7421 5960', '2015-07-08 03:23:00', 68128, 515),
(669, '4623 East 2780 North', 'District 176, Utopia, 38980', 'Raymond Robinson', 'MasterCard', '2019-03-15', '5898 7115 3147 7807', '2015-02-08 05:49:00', 36467, 515),
(674, '2074 West 747 South', 'District 185, Utopia, 36465', 'Larry Davis', 'Visa', '2025-05-14', '5783 7188 6543 2380', '2009-10-17 14:17:00', 39060, 516),
(678, '6548 East 6486 South', 'District 332, Utopia, 43503', 'Lisa Hall', 'MasterCard', '2023-06-15', '6943 6210 7117 4634', '2017-07-15 07:38:00', 53665, 517),
(683, '3890 East 3401 South', 'District 406, Utopia, 13915', 'Lisa Hall', 'MasterCard', '2025-06-12', '7938 5551 5658 9152', '2014-02-14 05:43:00', 44655, 517),
(689, '1837 West 7555 South', 'District 306, Utopia, 26181', 'Maria Wilson', 'MasterCard', '2026-12-27', '9292 8188 1395 8757', '2009-06-08 05:32:00', 91324, 518),
(693, '7742 West 3525 South', 'District 481, Utopia, 18996', 'Joshua Martin', 'MasterCard', '2024-05-19', '4015 5263 3303 6814', '2009-06-08 10:49:00', 96592, 520),
(697, '8894 West 7587 South', 'District 59, Utopia, 42537', 'Donald Miller', 'MasterCard', '2025-02-03', '1477 7778 1312 9393', '2015-04-10 21:16:00', 63331, 521),
(702, '5219 West 602 North', 'District 86, Utopia, 21196', 'Donald Miller', 'Visa', '2021-12-06', '2032 2808 5343 2100', '2017-02-16 13:18:00', 46108, 521),
(706, '4900 East 8273 North', 'District 339, Utopia, 11906', 'Kimberly Robinson', 'Visa', '2026-06-29', '5527 9428 4062 3640', '2014-07-10 12:44:00', 85526, 522),
(712, '6018 West 771 North', 'District 125, Utopia, 23468', 'Scott Smith', 'MasterCard', '2019-12-09', '3241 2117 3324 3046', '2011-02-13 06:11:00', 71722, 523),
(715, '6692 East 6101 North', 'District 438, Utopia, 17928', 'Scott Smith', 'Visa', '2020-04-08', '4920 5328 1653 1805', '2008-05-09 10:02:00', 54615, 523),
(717, '1707 West 6981 South', 'District 396, Utopia, 43898', 'Scott Smith', 'Visa', '2027-01-31', '4308 4787 4158 5572', '2012-06-09 20:37:00', 189873, 523),
(723, '7958 West 7214 South', 'District 217, Utopia, 21266', 'Scott Smith', 'Visa', '2021-04-07', '4901 6952 8934 5174', '2011-08-07 18:18:00', 33241, 523),
(728, '3109 West 4654 South', 'District 397, Utopia, 15376', 'Brian Jones', 'MasterCard', '2020-11-23', '8694 7057 6656 3074', '2017-02-08 09:57:00', 65515, 525),
(737, '802 West 5493 South', 'District 319, Utopia, 26993', 'Helen Wilson', 'Visa', '2018-08-27', '5047 9420 1466 7503', '2010-09-19 17:08:00', 45560, 526),
(740, '3894 East 89 North', 'District 50, Utopia, 21771', 'Michael Rodriguez', 'Visa', '2019-10-22', '9461 1050 3356 5390', '2016-04-01 06:47:00', 61812, 530),
(744, '6632 West 6536 North', 'District 67, Utopia, 29865', 'Michael Rodriguez', 'MasterCard', '2019-07-08', '6040 1000 7808 1465', '2013-10-17 21:51:00', 94739, 530),
(750, '1797 West 3753 South', 'District 2, Utopia, 38263', 'Carol Thomas', 'MasterCard', '2026-12-06', '6444 2938 9919 8757', '2011-07-02 10:02:00', 8076, 531),
(752, '1566 West 2184 South', 'District 118, Utopia, 17702', 'Carol Thomas', 'MasterCard', '2024-04-30', '1755 8842 8023 8936', '2009-06-17 20:57:00', 101451, 531),
(757, '7330 West 7866 South', 'District 293, Utopia, 46763', 'Carol Thomas', 'Visa', '2023-01-31', '3436 5973 5826 5619', '2016-06-21 19:08:00', 55541, 531),
(763, '8513 East 7016 North', 'District 386, Utopia, 26708', 'Carol Thomas', 'Visa', '2027-07-27', '3639 9095 8900 6515', '2009-05-22 08:30:00', 28435, 531),
(765, '2179 West 7801 North', 'District 349, Utopia, 21202', 'Dorothy Thomas', 'Visa', '2019-03-11', '2969 3207 3783 5849', '2008-06-11 00:42:00', 7485, 532),
(768, '8932 East 6849 North', 'District 213, Utopia, 10386', 'Joshua Miller', 'Visa', '2019-04-10', '2997 9098 4659 8875', '2012-03-07 02:28:00', 81610, 533),
(774, '3497 West 7741 North', 'District 284, Utopia, 33415', 'Patrick Anderson', 'MasterCard', '2024-05-02', '6023 8701 8124 5614', '2013-02-01 20:04:00', 35497, 534),
(780, '56 West 8664 South', 'District 412, Utopia, 33824', 'Sharon Anderson', 'MasterCard', '2026-11-05', '6626 4347 7353 7075', '2010-04-09 17:58:00', 143591, 535),
(787, '3697 West 3809 North', 'District 353, Utopia, 48668', 'John Johnson', 'MasterCard', '2025-12-08', '3442 9529 9750 4758', '2010-05-19 01:27:00', 91807, 537),
(792, '6635 East 3298 South', 'District 16, Utopia, 33416', 'John Johnson', 'Visa', '2027-02-13', '8689 3285 2826 5575', '2017-05-04 10:09:00', 53489, 537),
(798, '2555 West 6109 South', 'District 390, Utopia, 12965', 'John Johnson', 'MasterCard', '2020-04-02', '9102 9034 3526 2499', '2013-04-11 20:44:00', 32694, 537),
(802, '8493 East 8921 North', 'District 190, Utopia, 20401', 'Walter King', 'MasterCard', '2022-10-29', '4354 3944 3266 8888', '2011-06-16 14:19:00', 28385, 538),
(806, '6980 West 587 North', 'District 326, Utopia, 28351', 'Walter King', 'MasterCard', '2027-09-23', '9348 4453 7476 3265', '2016-03-11 11:11:00', 209242, 538),
(814, '3391 West 1329 South', 'District 145, Utopia, 41329', 'Robert Martinez', 'Visa', '2022-12-08', '2672 7222 4916 7739', '2014-01-19 14:20:00', 48367, 539),
(819, '1675 West 6432 North', 'District 129, Utopia, 29566', 'Robert Martinez', 'MasterCard', '2024-02-21', '2829 7018 7813 9487', '2012-07-17 11:56:00', 67736, 539),
(823, '8025 West 806 North', 'District 143, Utopia, 42443', 'Nancy Smith', 'MasterCard', '2022-04-24', '1852 6053 9860 1338', '2010-05-06 22:02:00', 22263, 540),
(825, '4023 East 6468 South', 'District 13, Utopia, 30789', 'Thomas Thompson', 'MasterCard', '2025-11-04', '8750 2483 5245 1815', '2015-05-24 22:44:00', 35750, 541),
(828, '4147 East 1812 South', 'District 14, Utopia, 36854', 'Thomas Thompson', 'MasterCard', '2020-08-08', '3553 5856 2787 5122', '2013-04-05 14:08:00', 106799, 541),
(835, '409 West 3442 South', 'District 386, Utopia, 26980', 'Thomas Thompson', 'MasterCard', '2025-07-05', '6277 6529 5530 2621', '2015-07-14 14:25:00', 61714, 541),
(840, '3547 West 7947 North', 'District 266, Utopia, 44329', 'Patrick Walker', 'MasterCard', '2022-11-22', '9595 5261 1500 2199', '2008-08-21 11:41:00', 95582, 542),
(845, '8447 West 259 South', 'District 379, Utopia, 24411', 'Charles Scoot', 'Visa', '2025-06-24', '4555 9636 9047 6101', '2013-01-09 07:46:00', 29163, 543),
(848, '6051 East 865 South', 'District 196, Utopia, 18947', 'Charles Scoot', 'Visa', '2026-10-19', '9609 9580 5374 5364', '2014-05-22 21:08:00', 132970, 543),
(854, '2249 East 2772 North', 'District 44, Utopia, 27089', 'Charles Scoot', 'Visa', '2020-11-17', '4377 7220 8812 3193', '2009-04-03 16:17:00', 75615, 543),
(860, '973 West 371 South', 'District 305, Utopia, 40143', 'Charles Scoot', 'MasterCard', '2018-02-18', '4114 3060 3220 9978', '2012-05-19 22:17:00', 100674, 543),
(866, '4303 East 6819 North', 'District 322, Utopia, 25949', 'Charles Scoot', 'MasterCard', '2022-09-06', '5956 1534 9662 9005', '2014-08-03 14:24:00', 26392, 543),
(871, '1880 West 5225 North', 'District 143, Utopia, 35628', 'Betty Scoot', 'MasterCard', '2024-06-21', '5481 4509 8407 8327', '2009-07-04 08:35:00', 53707, 544),
(875, '1373 East 1590 North', 'District 404, Utopia, 29501', 'Betty Scoot', 'MasterCard', '2025-04-08', '8063 8301 9245 5511', '2010-07-08 01:40:00', 14817, 544),
(878, '2389 West 8502 South', 'District 444, Utopia, 49571', 'Jerry Smith', 'MasterCard', '2018-08-11', '7433 2733 7688 7337', '2010-04-23 05:20:00', 94797, 545),
(882, '782 West 6717 South', 'District 183, Utopia, 23270', 'Jerry Smith', 'MasterCard', '2018-09-10', '9751 3251 9731 9943', '2008-07-12 05:11:00', 29850, 545),
(886, '3208 West 4904 South', 'District 495, Utopia, 35806', 'Jerry Smith', 'MasterCard', '2022-11-04', '5629 8525 8621 2434', '2009-04-08 00:51:00', 128588, 545),
(893, '5408 West 260 North', 'District 446, Utopia, 13063', 'Jerry Smith', 'Visa', '2018-10-02', '3916 1443 8188 2345', '2014-04-10 15:43:00', 55178, 545),
(896, '2903 West 5767 South', 'District 16, Utopia, 28024', 'Michelle Lewis', 'Visa', '2020-09-20', '8031 3322 1507 1410', '2011-05-10 21:05:00', 34566, 546),
(899, '6092 East 3890 South', 'District 414, Utopia, 46597', 'Michelle Lewis', 'Visa', '2023-01-31', '2094 7111 3606 4019', '2016-10-15 18:51:00', 49270, 546),
(902, '2962 West 7865 South', 'District 330, Utopia, 46026', 'Michelle Lewis', 'MasterCard', '2022-12-12', '1814 8709 1863 8435', '2011-09-22 08:55:00', 89850, 546),
(906, '4980 East 4565 South', 'District 122, Utopia, 33225', 'Michelle Lewis', 'MasterCard', '2027-07-20', '7548 2118 4927 8122', '2017-05-05 06:13:00', 56626, 546),
(910, '206 East 2948 South', 'District 30, Utopia, 36129', 'Kimberly Hernandez', 'Visa', '2023-07-21', '2191 2679 1866 4800', '2011-01-11 18:47:00', 32409, 547),
(914, '3546 East 4349 North', 'District 14, Utopia, 36083', 'Kimberly Hernandez', 'Visa', '2024-05-14', '3551 7105 1608 5212', '2012-02-21 04:52:00', 75073, 547),
(918, '8911 East 8966 North', 'District 305, Utopia, 48513', 'Kimberly Hernandez', 'MasterCard', '2027-08-12', '7597 3746 4733 8798', '2010-08-02 00:56:00', 109130, 547),
(923, '967 West 3488 North', 'District 248, Utopia, 35171', 'Kimberly Hernandez', 'MasterCard', '2021-04-28', '5929 6224 5995 1811', '2015-05-06 13:56:00', 98614, 547),
(930, '288 West 3841 North', 'District 179, Utopia, 23635', 'Deborah Walker', 'Visa', '2025-07-18', '4353 8871 1718 5420', '2011-01-04 15:57:00', 68496, 550),
(935, '6404 East 5577 South', 'District 395, Utopia, 23449', 'Deborah Walker', 'MasterCard', '2021-03-01', '4945 1046 5442 7980', '2010-06-01 06:07:00', 0, 550),
(937, '1961 West 1583 South', 'District 103, Utopia, 23849', 'Patricia Davis', 'MasterCard', '2024-03-13', '9696 8655 5940 3592', '2015-02-06 21:44:00', 24268, 551),
(941, '4291 East 1134 South', 'District 273, Utopia, 25590', 'Patricia Davis', 'MasterCard', '2024-06-19', '1286 7060 4020 2100', '2015-04-17 15:23:00', 59710, 551),
(947, '7406 West 4481 North', 'District 155, Utopia, 24845', 'Michelle Harris', 'MasterCard', '2018-09-21', '6775 7245 3772 3672', '2009-10-09 05:12:00', 44788, 552),
(952, '179 West 5436 South', 'District 322, Utopia, 44897', 'Michelle Harris', 'MasterCard', '2026-11-02', '8302 5138 8242 4024', '2016-08-21 12:17:00', 0, 552),
(954, '1816 East 5312 South', 'District 212, Utopia, 20431', 'Donna White', 'Visa', '2020-09-25', '1738 4698 1533 1907', '2013-08-05 19:56:00', 232634, 553),
(961, '5990 West 739 North', 'District 171, Utopia, 31761', 'Donna White', 'MasterCard', '2020-10-01', '4357 6181 2454 4384', '2010-07-05 21:35:00', 54000, 553),
(966, '6605 West 1333 North', 'District 475, Utopia, 28768', 'Sarah Martinez', 'Visa', '2025-11-30', '6559 9212 4908 7079', '2013-10-15 15:26:00', 67140, 554),
(970, '4940 West 1559 North', 'District 322, Utopia, 21950', 'Shirley Lee', 'Visa', '2018-11-08', '4078 3276 4257 7712', '2010-06-12 06:55:00', 51061, 556),
(975, '5296 East 5064 North', 'District 323, Utopia, 23001', 'Shirley Lee', 'Visa', '2027-11-26', '3548 6589 5393 2552', '2015-03-21 11:22:00', 91430, 556),
(980, '833 West 7336 South', 'District 33, Utopia, 23645', 'Timothy King', 'MasterCard', '2027-11-01', '8427 7981 3432 6444', '2014-03-08 09:33:00', 27344, 557),
(983, '4750 West 1675 North', 'District 66, Utopia, 31444', 'Timothy King', 'MasterCard', '2025-02-27', '7642 3794 8444 6444', '2008-03-05 19:05:00', 90030, 557),
(988, '6700 East 8083 North', 'District 83, Utopia, 45051', 'Kevin Brown', 'Visa', '2025-07-02', '4450 3436 7197 9738', '2016-03-03 19:51:00', 90823, 558),
(992, '3313 West 2568 North', 'District 68, Utopia, 46743', 'Kevin Brown', 'Visa', '2019-05-29', '2855 7508 6218 2704', '2010-04-11 00:35:00', 106917, 558),
(1000, '2237 West 5887 North', 'District 332, Utopia, 24727', 'Jospeph Hernandez', 'MasterCard', '2024-01-07', '1069 2748 4945 8045', '2009-01-02 06:13:00', 2622, 559),
(1003, '2240 East 4663 South', 'District 135, Utopia, 24182', 'Elizabeth Jackson', 'MasterCard', '2025-12-08', '9858 6505 7943 9327', '2014-01-04 06:58:00', 34668, 560),
(1007, '1442 East 6431 North', 'District 125, Utopia, 25182', 'Elizabeth Jackson', 'MasterCard', '2022-06-04', '2464 9270 9230 7220', '2008-02-19 18:55:00', 15730, 560),
(1009, '4245 West 4822 South', 'District 187, Utopia, 45882', 'Elizabeth Jackson', 'MasterCard', '2022-12-22', '9439 1062 6983 1249', '2016-08-17 09:03:00', 196779, 560),
(1018, '6688 West 1901 North', 'District 375, Utopia, 35826', 'Elizabeth Jackson', 'MasterCard', '2025-07-09', '8694 6751 4767 3288', '2008-07-04 12:03:00', 40813, 560),
(1022, '8091 West 2240 South', 'District 475, Utopia, 43247', 'Jerry Allen', 'Visa', '2020-03-09', '6006 2160 8106 2057', '2016-01-05 01:21:00', 21992, 561),
(1026, '1028 West 6990 South', 'District 474, Utopia, 16967', 'Jerry Allen', 'Visa', '2023-02-03', '1922 7733 2151 5337', '2017-03-22 20:00:00', 6125, 561),
(1030, '7603 West 1548 North', 'District 86, Utopia, 11407', 'Jerry Allen', 'Visa', '2026-07-09', '4405 4399 5913 4514', '2017-05-06 08:45:00', 14664, 561),
(1034, '2792 East 7119 South', 'District 173, Utopia, 37657', 'Scott Williams', 'MasterCard', '2027-05-24', '8414 2505 7947 6123', '2016-02-21 12:37:00', 124786, 562),
(1041, '7693 East 283 South', 'District 449, Utopia, 29390', 'Richard Smith', 'MasterCard', '2027-05-06', '7073 4426 1369 9118', '2015-10-23 11:24:00', 65498, 565),
(1048, '8623 West 2581 North', 'District 434, Utopia, 44102', 'Richard Smith', 'Visa', '2021-05-17', '4840 6038 7280 2843', '2016-04-01 17:50:00', 40603, 565),
(1054, '1006 West 5224 North', 'District 95, Utopia, 13132', 'Richard Smith', 'Visa', '2018-11-05', '8643 5395 5327 9642', '2017-06-10 15:53:00', 116501, 565),
(1059, '5240 West 1558 South', 'District 295, Utopia, 16068', 'Betty Martin', 'Visa', '2026-12-15', '1025 1031 6490 9556', '2015-07-21 00:39:00', 30632, 566),
(1062, '3363 East 570 South', 'District 187, Utopia, 28798', 'Betty Martin', 'Visa', '2019-06-05', '8450 7803 1478 3916', '2009-02-10 02:44:00', 63486, 566),
(1067, '1013 West 744 South', 'District 84, Utopia, 20593', 'Betty Martin', 'MasterCard', '2019-11-13', '8615 1991 2114 7820', '2016-08-07 20:40:00', 0, 566),
(1069, '8393 West 2304 North', 'District 50, Utopia, 48033', 'Kimberly Harris', 'MasterCard', '2021-06-30', '4222 6878 3925 1708', '2009-03-01 16:37:00', 50312, 567),
(1073, '4530 West 874 South', 'District 234, Utopia, 12807', 'Peter Brown', 'MasterCard', '2019-07-05', '1085 4567 9081 7000', '2009-05-09 14:54:00', 50594, 568),
(1078, '7011 East 8918 South', 'District 318, Utopia, 18176', 'Jessica Martin', 'MasterCard', '2020-05-01', '7818 2962 4977 2709', '2011-02-06 17:49:00', 91577, 569),
(1083, '4639 West 4128 South', 'District 435, Utopia, 34928', 'Anthony Johnson', 'Visa', '2023-02-28', '8444 9096 2722 9533', '2011-08-12 06:08:00', 106398, 571),
(1088, '1449 East 1448 South', 'District 410, Utopia, 13430', 'Anthony Johnson', 'MasterCard', '2024-02-08', '5285 5585 5510 3715', '2008-09-02 05:43:00', 41583, 571),
(1091, '5145 West 6434 North', 'District 316, Utopia, 31297', 'Anthony Johnson', 'MasterCard', '2024-01-12', '2583 4571 3961 9345', '2012-07-16 02:27:00', 64741, 571),
(1094, '5327 West 1148 North', 'District 256, Utopia, 48553', 'Maria Walker', 'Visa', '2023-11-19', '1695 1833 5330 3267', '2017-04-20 19:02:00', 223, 572),
(1096, '352 East 818 South', 'District 422, Utopia, 29767', 'Patricia Thompson', 'Visa', '2022-09-01', '4997 2867 4497 8977', '2012-02-03 12:22:00', 7400, 573),
(1101, '810 East 8805 North', 'District 133, Utopia, 22387', 'Patricia Thompson', 'Visa', '2027-09-27', '6055 8822 6435 6822', '2010-02-05 11:54:00', 13180, 573),
(1104, '5138 East 5510 North', 'District 493, Utopia, 41668', 'Patricia Thompson', 'Visa', '2026-06-21', '1072 1105 5364 8106', '2013-10-16 01:23:00', 98302, 573),
(1109, '3839 West 2961 North', 'District 217, Utopia, 36087', 'Patricia Thompson', 'Visa', '2021-10-09', '9325 6488 9859 9715', '2015-05-24 12:45:00', 92178, 573),
(1112, '2942 East 90 North', 'District 57, Utopia, 14471', 'Dennis Smith', 'Visa', '2023-11-02', '4608 6726 6038 3437', '2016-04-04 07:01:00', 69232, 574),
(1116, '5352 East 4120 South', 'District 58, Utopia, 27786', 'Cynthia Robinson', 'Visa', '2025-09-21', '4683 3227 2825 4405', '2013-07-07 20:16:00', 41456, 575),
(1121, '8966 West 70 South', 'District 466, Utopia, 13828', 'Cynthia Robinson', 'MasterCard', '2022-12-15', '4510 4158 6494 3996', '2016-09-10 10:13:00', 76916, 575),
(1124, '8111 West 5180 South', 'District 237, Utopia, 20968', 'Cynthia Robinson', 'Visa', '2023-05-02', '6511 3575 3244 4023', '2008-10-10 11:06:00', 139389, 575),
(1130, '5307 West 7544 South', 'District 331, Utopia, 35363', 'John Brown', 'MasterCard', '2021-04-20', '3090 1212 6479 5809', '2010-02-16 18:41:00', 23702, 576),
(1133, '588 West 2603 South', 'District 182, Utopia, 25671', 'John Brown', 'MasterCard', '2021-07-07', '5125 6315 2081 4497', '2011-07-18 15:01:00', 72912, 576),
(1136, '1824 East 2756 North', 'District 54, Utopia, 34012', 'Paul Thompson', 'MasterCard', '2022-02-21', '2816 5458 8699 8223', '2017-04-23 17:26:00', 12843, 577),
(1138, '4656 East 7864 South', 'District 219, Utopia, 38781', 'Paul Hill', 'Visa', '2025-06-13', '7624 8046 8401 2764', '2016-06-18 16:11:00', 75964, 578),
(1143, '1085 West 1320 South', 'District 32, Utopia, 45558', 'Paul Hill', 'MasterCard', '2023-02-25', '2458 8035 4842 2386', '2016-01-12 01:45:00', 65195, 578),
(1149, '3081 West 3218 North', 'District 374, Utopia, 35955', 'Mark Anderson', 'Visa', '2021-07-22', '3060 3326 1321 3483', '2015-09-11 21:48:00', 23272, 579),
(1153, '8784 East 2950 North', 'District 464, Utopia, 15896', 'Mark Anderson', 'Visa', '2018-10-26', '5851 7426 6835 3041', '2009-03-07 06:51:00', 71125, 579),
(1158, '4540 East 6014 North', 'District 295, Utopia, 21774', 'Mark Anderson', 'MasterCard', '2027-03-20', '5330 1458 5373 9591', '2008-10-01 02:08:00', 90915, 579),
(1164, '8402 West 8916 North', 'District 252, Utopia, 32425', 'Patricia Moorse', 'Visa', '2023-08-03', '9550 1664 7451 5231', '2015-05-17 03:16:00', 0, 580),
(1167, '7759 West 4103 North', 'District 479, Utopia, 30908', 'James Harris', 'Visa', '2024-06-10', '9880 6205 3126 3976', '2013-08-10 02:47:00', 23194, 581),
(1170, '6535 West 3068 North', 'District 212, Utopia, 48991', 'James Harris', 'MasterCard', '2020-06-04', '7594 5731 8127 7340', '2012-01-09 13:49:00', 8754, 581),
(1174, '861 East 2885 North', 'District 71, Utopia, 47347', 'James Harris', 'Visa', '2020-08-26', '2282 3512 6779 5344', '2013-09-04 05:30:00', 0, 581),
(1177, '7122 East 3824 North', 'District 487, Utopia, 26618', 'James Harris', 'Visa', '2024-11-02', '1832 5752 8403 9888', '2008-01-11 07:22:00', 55696, 581),
(1181, '1931 West 789 North', 'District 332, Utopia, 22304', 'Lisa Robinson', 'Visa', '2023-02-16', '9493 7404 2432 3847', '2010-10-20 13:21:00', 70756, 582),
(1188, '2747 East 4017 South', 'District 132, Utopia, 22873', 'Jerry Martin', 'Visa', '2027-08-19', '4908 5936 8366 8302', '2013-07-03 17:32:00', 6900, 583),
(1190, '2287 East 1523 South', 'District 232, Utopia, 37097', 'Jospeph Lewis', 'MasterCard', '2022-04-20', '3633 3909 6010 2489', '2008-06-18 20:22:00', 76286, 585),
(1196, '1600 East 8504 North', 'District 417, Utopia, 12995', 'Jospeph Lewis', 'MasterCard', '2019-03-29', '7644 5113 3402 2254', '2015-04-13 10:28:00', 142907, 585),
(1203, '6025 East 6039 North', 'District 89, Utopia, 18888', 'Matthew Martinez', 'MasterCard', '2023-05-07', '7860 2837 6284 4100', '2016-07-16 21:41:00', 40081, 586),
(1207, '3491 West 8784 North', 'District 128, Utopia, 38787', 'Barbara Martinez', 'MasterCard', '2018-07-31', '8088 3646 2079 6922', '2015-04-15 21:20:00', 163055, 587),
(1214, '6189 East 2820 North', 'District 384, Utopia, 26349', 'Barbara Martinez', 'Visa', '2022-08-05', '4435 2095 3484 6106', '2011-01-21 17:58:00', 52386, 587),
(1220, '3802 West 399 North', 'District 50, Utopia, 46327', 'Shirley Jones', 'MasterCard', '2025-06-04', '5419 6233 2264 9896', '2017-05-17 20:33:00', 79994, 588),
(1225, '8285 West 2423 North', 'District 404, Utopia, 26109', 'Shirley Jones', 'MasterCard', '2027-01-12', '5616 4341 3092 3883', '2014-10-11 11:39:00', 63872, 588),
(1229, '5883 West 1603 South', 'District 359, Utopia, 28402', 'Edward Martinez', 'Visa', '2027-05-21', '6883 1675 8410 3154', '2011-01-05 02:00:00', 104944, 589),
(1233, '3377 East 6139 South', 'District 457, Utopia, 10065', 'Edward Martinez', 'Visa', '2019-07-17', '9912 7835 5267 4444', '2013-09-12 16:22:00', 67584, 589),
(1236, '4152 West 459 North', 'District 137, Utopia, 25341', 'Mark Thomas', 'MasterCard', '2027-03-22', '2321 5056 6571 9796', '2016-02-18 05:04:00', 98495, 590),
(1244, '1109 East 3573 North', 'District 228, Utopia, 48589', 'Dorothy Brown', 'Visa', '2024-06-20', '4775 8648 2869 9066', '2014-05-18 16:41:00', 63261, 591),
(1250, '2750 East 6638 North', 'District 207, Utopia, 24169', 'Dorothy Brown', 'MasterCard', '2021-05-04', '2331 9135 8741 2805', '2014-08-13 00:09:00', 126104, 591),
(1257, '727 East 6115 South', 'District 383, Utopia, 24592', 'Deborah Wilson', 'MasterCard', '2027-04-28', '4175 7351 8986 9405', '2009-02-19 09:43:00', 52015, 592),
(1259, '6940 West 6146 North', 'District 150, Utopia, 11790', 'Deborah Wilson', 'Visa', '2021-08-06', '6872 4020 5048 3442', '2010-07-21 10:24:00', 95927, 592),
(1264, '5807 West 517 North', 'District 155, Utopia, 40375', 'Ruth Johnson', 'MasterCard', '2027-06-04', '6790 8904 9087 6580', '2015-10-04 07:31:00', 120074, 593),
(1269, '7476 East 2858 South', 'District 450, Utopia, 44704', 'Ruth Johnson', 'MasterCard', '2027-08-29', '3763 8230 5353 5516', '2008-06-01 19:43:00', 13365, 593),
(1271, '7669 East 1189 North', 'District 21, Utopia, 26417', 'Maria Taylor', 'MasterCard', '2025-07-14', '5278 3753 8667 6051', '2013-07-23 20:31:00', 92652, 594),
(1276, '5710 East 5204 North', 'District 304, Utopia, 14656', 'Maria Taylor', 'MasterCard', '2025-11-29', '1081 7196 9256 6168', '2008-05-16 06:43:00', 42162, 594),
(1280, '5373 East 7783 North', 'District 279, Utopia, 49897', 'Maria Taylor', 'MasterCard', '2018-06-18', '8464 4390 2142 9208', '2008-06-09 10:14:00', 76617, 594),
(1283, '2081 East 5359 South', 'District 153, Utopia, 33820', 'Susan Williams', 'MasterCard', '2027-05-16', '9947 4173 3253 8490', '2011-06-14 08:25:00', 80924, 595),
(1288, '6988 West 4887 South', 'District 246, Utopia, 40139', 'Susan Williams', 'MasterCard', '2024-09-15', '6592 2518 9316 7248', '2017-07-24 17:29:00', 109739, 595),
(1293, '4898 East 1264 South', 'District 485, Utopia, 29377', 'Susan Williams', 'Visa', '2021-09-15', '6331 8604 4091 2638', '2013-01-01 20:09:00', 84954, 595),
(1296, '3052 East 6221 North', 'District 341, Utopia, 43756', 'Maria Hall', 'MasterCard', '2018-12-29', '7965 6834 3979 9638', '2017-01-20 06:04:00', 67145, 596),
(1300, '6411 East 5526 North', 'District 255, Utopia, 48026', 'Maria Hall', 'Visa', '2025-10-14', '4649 9797 1829 8338', '2012-09-10 06:30:00', 58320, 596),
(1303, '2284 East 6421 South', 'District 368, Utopia, 14746', 'Maria Hall', 'Visa', '2019-07-17', '4086 9918 6729 8129', '2008-10-07 10:55:00', 54058, 596),
(1307, '5357 East 8273 North', 'District 289, Utopia, 41495', 'Kevin Brown', 'MasterCard', '2019-04-24', '1598 3135 8407 4939', '2013-07-04 22:05:00', 68436, 597),
(1310, '7273 West 8116 South', 'District 199, Utopia, 47917', 'Gary Rodriguez', 'MasterCard', '2019-10-25', '4050 7331 9874 2625', '2013-03-09 08:49:00', 60408, 598),
(1314, '8690 East 3263 North', 'District 495, Utopia, 20447', 'Gary Rodriguez', 'Visa', '2020-07-24', '8418 6424 6168 2395', '2012-05-05 21:22:00', 78089, 598),
(1319, '5555 West 809 South', 'District 126, Utopia, 22856', 'Timothy Johnson', 'MasterCard', '2026-05-23', '3419 7389 1942 8959', '2013-05-10 09:35:00', 68780, 600),
(1326, '3195 West 3796 South', 'District 18, Utopia, 47303', 'Timothy Johnson', 'MasterCard', '2023-01-16', '6045 6520 6450 8494', '2013-09-23 05:04:00', 84825, 600),
(1330, '1111 West 6770 South', 'District 495, Utopia, 25306', 'Timothy Johnson', 'MasterCard', '2024-09-30', '9277 5542 6803 5398', '2012-07-11 04:02:00', 24175, 600),
(1334, '2307 West 7141 South', 'District 131, Utopia, 27619', 'Karen Jackson', 'Visa', '2026-06-10', '4622 9135 3682 2697', '2017-02-21 14:48:00', 80984, 601),
(1339, '6382 East 1098 South', 'District 126, Utopia, 20469', 'Karen Jackson', 'MasterCard', '2022-12-16', '2163 9272 7184 6920', '2016-08-24 21:07:00', 62373, 601),
(1342, '248 East 396 South', 'District 259, Utopia, 33493', 'Jerry Thomas', 'Visa', '2025-09-01', '1595 2444 5818 1614', '2013-03-03 13:31:00', 106317, 602),
(1346, '6259 West 8505 South', 'District 339, Utopia, 26204', 'Jerry Thomas', 'MasterCard', '2025-11-08', '8730 9309 1714 5671', '2010-10-08 20:22:00', 29987, 602),
(1350, '5255 East 4927 South', 'District 290, Utopia, 37415', 'Jerry Thomas', 'MasterCard', '2021-12-11', '4707 3613 7324 8944', '2008-06-10 17:20:00', 33956, 602),
(1353, '7287 West 8358 North', 'District 200, Utopia, 46959', 'Jerry Thomas', 'MasterCard', '2021-08-12', '9885 5297 5048 8413', '2010-06-24 20:41:00', 171171, 602),
(1360, '1386 East 5992 North', 'District 34, Utopia, 31737', 'Eric Moorse', 'Visa', '2023-10-16', '9832 5098 4295 6092', '2013-06-01 19:24:00', 570, 603),
(1362, '4615 East 2455 North', 'District 6, Utopia, 17598', 'Gregory Wright', 'Visa', '2021-08-26', '5919 6723 9487 5414', '2016-08-20 20:32:00', 193219, 604),
(1372, '2143 East 2195 South', 'District 329, Utopia, 25116', 'Gregory Wright', 'MasterCard', '2026-08-14', '7752 3296 8696 5442', '2016-02-20 18:42:00', 258354, 604),
(1379, '1881 West 1291 North', 'District 54, Utopia, 34318', 'Jennifer Jackson', 'MasterCard', '2026-07-25', '2031 8033 2565 4012', '2016-03-21 17:44:00', 9050, 605),
(1382, '5630 East 3876 South', 'District 463, Utopia, 24867', 'Jennifer Jackson', 'Visa', '2018-08-30', '4230 6026 6780 2104', '2013-07-12 10:02:00', 58722, 605),
(1386, '6278 West 817 South', 'District 258, Utopia, 22963', 'Jennifer Jackson', 'Visa', '2024-08-31', '3445 7187 6700 7740', '2012-10-17 17:50:00', 92407, 605);

-- --------------------------------------------------------

--
-- Table structure for table `persistenceorderitem`
--

CREATE TABLE `persistenceorderitem` (
  `ID` bigint(20) NOT NULL,
  `QUANTITY` int(11) DEFAULT NULL,
  `UNITPRICEINCENTS` bigint(20) DEFAULT NULL,
  `ORDER_ID` bigint(20) DEFAULT NULL,
  `PRODUCT_ID` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `persistenceorderitem`
--

INSERT INTO `persistenceorderitem` (`ID`, `QUANTITY`, `UNITPRICEINCENTS`, `ORDER_ID`, `PRODUCT_ID`) VALUES
(608, 4, 3274, 607, 116),
(609, 0, 7423, 607, 173),
(610, 4, 4117, 607, 185),
(611, 2, 7423, 607, 173),
(613, 6, 8561, 612, 428),
(614, 1, 9893, 612, 469),
(615, 6, 10893, 612, 479),
(617, 3, 8175, 616, 311),
(618, 0, 10438, 616, 183),
(619, 3, 8875, 616, 389),
(620, 2, 2716, 616, 321),
(621, 2, 7295, 616, 408),
(623, 3, 4613, 622, 76),
(624, 0, 6513, 622, 326),
(626, 2, 6053, 625, 329),
(627, 2, 11038, 625, 270),
(628, 3, 6828, 625, 267),
(629, 4, 4245, 625, 210),
(630, 0, 5841, 625, 276),
(632, 6, 4146, 631, 246),
(633, 3, 4758, 631, 234),
(634, 6, 9216, 631, 266),
(635, 5, 2969, 631, 238),
(636, 4, 3840, 631, 226),
(637, 2, 2282, 631, 258),
(639, 2, 5045, 638, 461),
(640, 3, 4261, 638, 340),
(641, 0, 1700, 638, 398),
(643, 3, 7865, 642, 380),
(645, 1, 5169, 644, 147),
(646, 1, 10251, 644, 344),
(647, 0, 5503, 644, 189),
(648, 1, 11619, 644, 128),
(650, 2, 4995, 649, 64),
(651, 6, 11828, 649, 73),
(652, 1, 3451, 649, 30),
(653, 1, 3598, 649, 61),
(654, 2, 10601, 649, 11),
(656, 0, 2826, 655, 466),
(657, 2, 7530, 655, 426),
(658, 0, 7753, 655, 445),
(659, 2, 1725, 655, 412),
(661, 0, 3274, 660, 116),
(662, 3, 10884, 660, 153),
(663, 3, 4776, 660, 203),
(665, 6, 1381, 664, 293),
(666, 6, 8142, 664, 244),
(667, 2, 365, 664, 280),
(668, 3, 3420, 664, 220),
(670, 2, 11925, 669, 490),
(671, 0, 4660, 669, 463),
(672, 1, 10542, 669, 486),
(673, 5, 415, 669, 36),
(675, 4, 3712, 674, 351),
(676, 4, 6053, 674, 329),
(677, 0, 10373, 674, 371),
(679, 5, 3578, 678, 223),
(680, 0, 1583, 678, 235),
(681, 5, 7075, 678, 271),
(682, 4, 100, 678, 144),
(684, 6, 3523, 683, 21),
(685, 1, 1519, 683, 10),
(686, 2, 7728, 683, 46),
(687, 5, 148, 683, 55),
(688, 1, 5802, 683, 41),
(690, 4, 11242, 689, 403),
(691, 4, 11589, 689, 227),
(692, 0, 8551, 689, 322),
(694, 6, 9720, 693, 262),
(695, 4, 9568, 693, 264),
(696, 0, 927, 693, 231),
(698, 2, 9002, 697, 407),
(699, 6, 1910, 697, 497),
(700, 2, 11925, 697, 490),
(701, 1, 10017, 697, 442),
(703, 2, 7014, 702, 167),
(704, 3, 10500, 702, 162),
(705, 1, 580, 702, 166),
(707, 2, 4874, 706, 504),
(708, 6, 7823, 706, 484),
(709, 0, 6969, 706, 409),
(710, 4, 1057, 706, 446),
(711, 4, 6153, 706, 414),
(713, 6, 11577, 712, 165),
(714, 4, 565, 712, 114),
(716, 5, 10923, 715, 290),
(718, 5, 6821, 717, 268),
(719, 6, 3552, 717, 303),
(720, 6, 11651, 717, 171),
(721, 4, 7376, 717, 278),
(722, 6, 5841, 717, 276),
(724, 1, 7295, 723, 408),
(725, 2, 1073, 723, 501),
(726, 4, 5950, 723, 506),
(727, 0, 10893, 723, 479),
(729, 1, 3916, 728, 240),
(730, 6, 4281, 728, 209),
(731, 4, 285, 728, 263),
(732, 3, 203, 728, 222),
(733, 2, 927, 728, 231),
(734, 3, 1748, 728, 232),
(735, 3, 9022, 728, 233),
(736, 0, 1130, 728, 298),
(738, 0, 12068, 737, 436),
(739, 5, 9112, 737, 422),
(741, 0, 5503, 740, 189),
(742, 2, 11577, 740, 165),
(743, 6, 6443, 740, 194),
(745, 0, 6186, 744, 92),
(746, 4, 6864, 744, 83),
(747, 2, 5439, 744, 493),
(748, 5, 8188, 744, 438),
(749, 3, 5155, 744, 106),
(751, 6, 1346, 750, 68),
(753, 5, 1041, 752, 43),
(754, 0, 5802, 752, 41),
(755, 6, 8402, 752, 69),
(756, 6, 7639, 752, 75),
(758, 4, 9653, 757, 315),
(759, 4, 2599, 757, 379),
(760, 0, 2599, 757, 379),
(761, 1, 3597, 757, 308),
(762, 1, 2936, 757, 320),
(764, 5, 5687, 763, 314),
(766, 0, 10979, 765, 47),
(767, 5, 1497, 765, 32),
(769, 0, 2276, 768, 429),
(770, 0, 11713, 768, 274),
(771, 5, 11751, 768, 424),
(772, 2, 9356, 768, 208),
(773, 3, 1381, 768, 293),
(775, 1, 6443, 774, 194),
(776, 0, 4117, 774, 185),
(777, 1, 4839, 774, 111),
(778, 2, 11101, 774, 151),
(779, 3, 671, 774, 137),
(781, 4, 11713, 780, 274),
(782, 2, 4179, 780, 456),
(783, 5, 1381, 780, 293),
(784, 6, 2905, 780, 230),
(785, 2, 11497, 780, 260),
(786, 4, 10263, 780, 265),
(788, 5, 3779, 787, 499),
(789, 4, 1463, 787, 468),
(790, 3, 11288, 787, 369),
(791, 4, 8299, 787, 455),
(793, 2, 11331, 792, 78),
(794, 5, 4455, 792, 84),
(795, 4, 986, 792, 95),
(796, 2, 1497, 792, 32),
(797, 2, 807, 792, 59),
(799, 1, 1831, 798, 420),
(800, 4, 5427, 798, 385),
(801, 5, 1831, 798, 420),
(803, 2, 3243, 802, 196),
(804, 1, 11619, 802, 128),
(805, 1, 10280, 802, 172),
(807, 6, 3243, 806, 196),
(808, 5, 9072, 806, 184),
(809, 1, 435, 806, 138),
(810, 6, 3746, 806, 135),
(811, 3, 6906, 806, 124),
(812, 5, 11859, 806, 155),
(813, 5, 8300, 806, 139),
(815, 4, 1667, 814, 216),
(816, 1, 10744, 814, 215),
(817, 6, 3840, 814, 226),
(818, 5, 1583, 814, 235),
(820, 4, 1216, 819, 325),
(821, 5, 4660, 819, 463),
(822, 4, 9893, 819, 469),
(824, 3, 7421, 823, 450),
(826, 0, 7695, 825, 101),
(827, 5, 7150, 825, 118),
(829, 6, 6524, 828, 161),
(830, 5, 3746, 828, 135),
(831, 1, 4839, 828, 111),
(832, 6, 6772, 828, 182),
(833, 2, 200, 828, 202),
(834, 3, 1018, 828, 113),
(836, 0, 7228, 835, 269),
(837, 6, 432, 835, 447),
(838, 3, 5439, 835, 493),
(839, 5, 8561, 835, 428),
(841, 6, 5011, 840, 299),
(842, 5, 6304, 840, 156),
(843, 6, 5666, 840, 174),
(844, 0, 10783, 840, 198),
(846, 3, 1497, 845, 32),
(847, 6, 4112, 845, 26),
(849, 2, 9072, 848, 184),
(850, 4, 2411, 848, 143),
(851, 1, 8478, 848, 175),
(852, 6, 9356, 848, 208),
(853, 4, 10142, 848, 179),
(855, 2, 8175, 854, 311),
(856, 3, 1594, 854, 365),
(857, 3, 2458, 854, 339),
(858, 3, 6681, 854, 360),
(859, 3, 9022, 854, 233),
(861, 3, 753, 860, 228),
(862, 1, 9700, 860, 12),
(863, 5, 9022, 860, 233),
(864, 4, 8235, 860, 248),
(865, 3, 3555, 860, 241),
(867, 5, 4660, 866, 463),
(868, 5, 100, 866, 144),
(869, 0, 1831, 866, 420),
(870, 6, 432, 866, 447),
(872, 6, 7913, 871, 132),
(873, 1, 6229, 871, 164),
(874, 0, 2240, 871, 301),
(876, 0, 6681, 875, 360),
(877, 3, 4939, 875, 402),
(879, 5, 2905, 878, 230),
(880, 4, 9824, 878, 305),
(881, 4, 10244, 878, 302),
(883, 4, 1948, 882, 471),
(884, 2, 11029, 882, 481),
(885, 0, 9112, 882, 422),
(887, 5, 1519, 886, 10),
(888, 2, 7728, 886, 46),
(889, 3, 7756, 886, 195),
(890, 3, 8547, 886, 53),
(891, 6, 7582, 886, 7),
(892, 4, 2784, 886, 37),
(894, 4, 10640, 893, 347),
(895, 2, 6309, 893, 323),
(897, 3, 7020, 896, 57),
(898, 2, 6753, 896, 79),
(900, 4, 4750, 899, 425),
(901, 6, 5045, 899, 461),
(903, 5, 5498, 902, 313),
(904, 4, 10373, 902, 371),
(905, 3, 6956, 902, 395),
(907, 2, 4062, 906, 294),
(908, 5, 9216, 906, 266),
(909, 2, 1211, 906, 252),
(911, 2, 4062, 910, 294),
(912, 2, 8730, 910, 304),
(913, 3, 2275, 910, 236),
(915, 6, 5841, 914, 276),
(916, 3, 11084, 914, 288),
(917, 1, 6775, 914, 237),
(919, 0, 3601, 918, 362),
(920, 6, 5711, 918, 343),
(921, 5, 8200, 918, 310),
(922, 3, 11288, 918, 369),
(924, 4, 11030, 923, 193),
(925, 1, 200, 923, 202),
(926, 4, 3294, 923, 168),
(927, 2, 6229, 923, 164),
(928, 3, 9365, 923, 186),
(929, 1, 565, 923, 114),
(931, 6, 5687, 930, 314),
(932, 0, 2803, 930, 358),
(933, 3, 11458, 930, 381),
(934, 0, 2716, 930, 321),
(936, 0, 6053, 935, 329),
(938, 0, 6906, 937, 124),
(939, 1, 2310, 937, 24),
(940, 2, 10979, 937, 421),
(942, 2, 9022, 941, 233),
(943, 4, 4062, 941, 294),
(944, 2, 6821, 941, 268),
(945, 2, 1130, 941, 298),
(946, 2, 4758, 941, 234),
(948, 0, 9022, 947, 233),
(949, 1, 6670, 947, 300),
(950, 3, 4062, 947, 294),
(951, 6, 4322, 947, 219),
(953, 0, 1594, 952, 365),
(955, 4, 885, 954, 388),
(956, 4, 8551, 954, 322),
(957, 6, 10847, 954, 372),
(958, 5, 7907, 954, 332),
(959, 6, 9817, 954, 15),
(960, 3, 10457, 954, 330),
(962, 2, 1018, 961, 113),
(963, 2, 9348, 961, 127),
(964, 2, 3294, 961, 168),
(965, 4, 6670, 961, 107),
(967, 6, 2229, 966, 467),
(968, 6, 4813, 966, 491),
(969, 4, 6222, 966, 505),
(971, 3, 10542, 970, 486),
(972, 3, 3082, 970, 400),
(973, 5, 393, 970, 71),
(974, 2, 4112, 970, 26),
(976, 3, 5667, 975, 318),
(977, 6, 10640, 975, 347),
(978, 1, 6956, 975, 395),
(979, 3, 1211, 975, 252),
(981, 3, 8052, 980, 406),
(982, 2, 1594, 980, 365),
(984, 4, 11181, 983, 254),
(985, 0, 10744, 983, 215),
(986, 5, 7218, 983, 213),
(987, 1, 9216, 983, 266),
(989, 6, 12087, 988, 154),
(990, 3, 3999, 988, 205),
(991, 1, 6304, 988, 156),
(993, 0, 5155, 992, 106),
(994, 3, 3451, 992, 30),
(995, 3, 10732, 992, 60),
(996, 4, 1387, 992, 38),
(997, 6, 4073, 992, 23),
(998, 5, 3452, 992, 50),
(999, 2, 8561, 992, 428),
(1001, 2, 1311, 1000, 378),
(1002, 0, 7147, 1000, 367),
(1004, 0, 3294, 1003, 168),
(1005, 3, 565, 1003, 114),
(1006, 3, 10991, 1003, 152),
(1008, 2, 7865, 1007, 380),
(1010, 3, 4196, 1009, 100),
(1011, 0, 9416, 1009, 16),
(1012, 4, 10979, 1009, 47),
(1013, 5, 6125, 1009, 80),
(1014, 1, 4112, 1009, 26),
(1015, 5, 7508, 1009, 85),
(1016, 5, 11886, 1009, 345),
(1017, 3, 2856, 1009, 31),
(1019, 1, 9216, 1018, 266),
(1020, 3, 10397, 1018, 253),
(1021, 2, 203, 1018, 222),
(1023, 0, 5112, 1022, 331),
(1024, 0, 9022, 1022, 233),
(1025, 4, 5498, 1022, 313),
(1027, 0, 3454, 1026, 462),
(1028, 1, 6125, 1026, 80),
(1029, 0, 8583, 1026, 503),
(1031, 4, 2187, 1030, 8),
(1032, 6, 986, 1030, 95),
(1033, 0, 8652, 1030, 39),
(1035, 4, 4261, 1034, 340),
(1036, 5, 3712, 1034, 351),
(1037, 6, 10601, 1034, 94),
(1038, 1, 11242, 1034, 403),
(1039, 3, 4778, 1034, 356),
(1040, 0, 11713, 1034, 274),
(1042, 0, 1792, 1041, 74),
(1043, 3, 3451, 1041, 30),
(1044, 1, 9817, 1041, 15),
(1045, 3, 9700, 1041, 12),
(1046, 4, 2310, 1041, 24),
(1047, 2, 3494, 1041, 169),
(1049, 5, 1546, 1048, 48),
(1050, 2, 3451, 1048, 30),
(1051, 1, 393, 1048, 71),
(1052, 1, 10122, 1048, 103),
(1053, 2, 7728, 1048, 46),
(1055, 0, 5600, 1054, 191),
(1056, 3, 8595, 1054, 317),
(1057, 5, 9908, 1054, 382),
(1058, 4, 10294, 1054, 374),
(1060, 0, 9433, 1059, 498),
(1061, 4, 7658, 1059, 119),
(1063, 4, 3552, 1062, 303),
(1064, 0, 8200, 1062, 310),
(1065, 5, 3147, 1062, 285),
(1066, 3, 11181, 1062, 254),
(1068, 0, 7680, 1067, 102),
(1070, 4, 4880, 1069, 413),
(1071, 2, 1546, 1069, 48),
(1072, 4, 6925, 1069, 449),
(1074, 4, 10438, 1073, 183),
(1075, 0, 5839, 1073, 146),
(1076, 1, 4003, 1073, 141),
(1077, 1, 4839, 1073, 111),
(1079, 0, 8837, 1078, 457),
(1080, 6, 10847, 1078, 372),
(1081, 5, 2098, 1078, 377),
(1082, 3, 5335, 1078, 430),
(1084, 2, 10979, 1083, 421),
(1085, 5, 4807, 1083, 459),
(1086, 5, 9054, 1083, 494),
(1087, 3, 5045, 1083, 461),
(1089, 3, 11751, 1088, 424),
(1090, 6, 1055, 1088, 410),
(1092, 1, 9817, 1091, 15),
(1093, 6, 9154, 1091, 63),
(1095, 1, 223, 1094, 188),
(1097, 0, 7658, 1096, 119),
(1098, 0, 10935, 1096, 109),
(1099, 0, 9311, 1096, 201),
(1100, 5, 1480, 1096, 142),
(1102, 1, 2042, 1101, 65),
(1103, 2, 5569, 1101, 9),
(1105, 0, 3854, 1104, 211),
(1106, 2, 6968, 1104, 149),
(1107, 2, 8244, 1104, 112),
(1108, 6, 11313, 1104, 206),
(1110, 6, 5112, 1109, 331),
(1111, 6, 10251, 1109, 344),
(1113, 4, 10017, 1112, 442),
(1114, 1, 8730, 1112, 304),
(1115, 2, 10217, 1112, 224),
(1117, 2, 2098, 1116, 377),
(1118, 2, 4778, 1116, 356),
(1119, 6, 3712, 1116, 351),
(1120, 2, 2716, 1116, 321),
(1122, 4, 1157, 1121, 272),
(1123, 6, 12048, 1121, 249),
(1125, 2, 8157, 1124, 475),
(1126, 6, 3779, 1124, 499),
(1127, 5, 8235, 1124, 248),
(1128, 1, 9761, 1124, 478),
(1129, 5, 9893, 1124, 469),
(1131, 3, 3134, 1130, 342),
(1132, 2, 7150, 1130, 118),
(1134, 4, 4813, 1133, 491),
(1135, 5, 10732, 1133, 60),
(1137, 3, 4281, 1136, 209),
(1139, 4, 8244, 1138, 112),
(1140, 4, 4004, 1138, 178),
(1141, 4, 6443, 1138, 194),
(1142, 6, 200, 1138, 202),
(1144, 1, 5600, 1143, 191),
(1145, 6, 3494, 1143, 169),
(1146, 1, 8699, 1143, 122),
(1147, 4, 7483, 1143, 123),
(1148, 0, 7150, 1143, 118),
(1150, 2, 11636, 1149, 51),
(1151, 0, 1779, 1149, 89),
(1152, 0, 5125, 1149, 42),
(1154, 2, 6229, 1153, 164),
(1155, 1, 4842, 1153, 19),
(1156, 3, 11535, 1153, 316),
(1157, 2, 9610, 1153, 392),
(1159, 1, 1381, 1158, 293),
(1160, 4, 4146, 1158, 246),
(1161, 6, 7218, 1158, 213),
(1162, 4, 1463, 1158, 468),
(1163, 5, 4758, 1158, 234),
(1165, 0, 959, 1164, 286),
(1166, 0, 7688, 1164, 296),
(1168, 4, 4425, 1167, 480),
(1169, 1, 5494, 1167, 86),
(1171, 1, 7014, 1170, 167),
(1172, 3, 580, 1170, 166),
(1173, 0, 3746, 1170, 135),
(1175, 0, 4778, 1174, 356),
(1176, 0, 2803, 1174, 358),
(1178, 4, 7262, 1177, 350),
(1179, 2, 3976, 1177, 472),
(1180, 2, 9348, 1177, 127),
(1182, 3, 1866, 1181, 418),
(1183, 4, 2370, 1181, 399),
(1184, 2, 5980, 1181, 384),
(1185, 2, 7865, 1181, 380),
(1186, 2, 10847, 1181, 372),
(1187, 3, 2098, 1181, 377),
(1189, 4, 1725, 1188, 412),
(1191, 1, 10500, 1190, 162),
(1192, 3, 8478, 1190, 175),
(1193, 3, 4098, 1190, 180),
(1194, 1, 8063, 1190, 110),
(1195, 5, 3999, 1190, 205),
(1197, 3, 8837, 1196, 457),
(1198, 2, 7946, 1196, 474),
(1199, 0, 2276, 1196, 429),
(1200, 4, 8188, 1196, 438),
(1201, 2, 8598, 1196, 476),
(1202, 6, 8426, 1196, 433),
(1204, 1, 1480, 1203, 142),
(1205, 3, 780, 1203, 192),
(1206, 3, 12087, 1203, 154),
(1208, 4, 9002, 1207, 407),
(1209, 6, 10290, 1207, 488),
(1210, 3, 8561, 1207, 428),
(1211, 0, 6969, 1207, 409),
(1212, 3, 10979, 1207, 421),
(1213, 3, 2229, 1207, 467),
(1215, 1, 9060, 1214, 452),
(1216, 6, 1910, 1214, 497),
(1217, 5, 994, 1214, 427),
(1218, 1, 7644, 1214, 423),
(1219, 4, 4813, 1214, 491),
(1221, 5, 5275, 1220, 33),
(1222, 3, 10122, 1220, 103),
(1223, 2, 9348, 1220, 127),
(1224, 3, 1519, 1220, 10),
(1226, 4, 1700, 1225, 398),
(1227, 3, 7602, 1225, 335),
(1228, 6, 5711, 1225, 343),
(1230, 1, 4874, 1229, 504),
(1231, 5, 11260, 1229, 28),
(1232, 6, 7295, 1229, 99),
(1234, 3, 3746, 1233, 135),
(1235, 6, 9391, 1233, 187),
(1237, 2, 12087, 1236, 154),
(1238, 2, 2665, 1236, 130),
(1239, 2, 3598, 1236, 61),
(1240, 3, 223, 1236, 188),
(1241, 0, 5839, 1236, 146),
(1242, 2, 8361, 1236, 117),
(1243, 4, 11101, 1236, 151),
(1245, 3, 8293, 1244, 52),
(1246, 1, 4750, 1244, 425),
(1247, 4, 1463, 1244, 468),
(1248, 2, 9020, 1244, 500),
(1249, 5, 1948, 1244, 471),
(1251, 2, 6186, 1250, 92),
(1252, 1, 565, 1250, 114),
(1253, 3, 11949, 1250, 13),
(1254, 4, 3494, 1250, 169),
(1255, 2, 7483, 1250, 123),
(1256, 6, 8063, 1250, 110),
(1258, 5, 10403, 1257, 27),
(1260, 4, 11042, 1259, 415),
(1261, 6, 8561, 1259, 428),
(1262, 1, 393, 1259, 71),
(1263, 0, 2179, 1259, 454),
(1265, 3, 8123, 1264, 120),
(1266, 5, 8641, 1264, 177),
(1267, 5, 10500, 1264, 162),
(1268, 0, 2919, 1264, 129),
(1270, 3, 4455, 1269, 84),
(1272, 6, 8630, 1271, 295),
(1273, 1, 4673, 1271, 229),
(1274, 2, 2774, 1271, 255),
(1275, 3, 10217, 1271, 224),
(1277, 0, 565, 1276, 114),
(1278, 2, 9072, 1276, 184),
(1279, 6, 4003, 1276, 141),
(1281, 6, 10847, 1280, 372),
(1282, 1, 11535, 1280, 316),
(1284, 3, 9022, 1283, 233),
(1285, 2, 6821, 1283, 268),
(1286, 2, 11293, 1283, 256),
(1287, 5, 3526, 1283, 275),
(1289, 2, 11713, 1288, 274),
(1290, 1, 6229, 1288, 164),
(1291, 4, 8486, 1288, 134),
(1292, 4, 11535, 1288, 316),
(1294, 5, 12048, 1293, 249),
(1295, 6, 4119, 1293, 464),
(1297, 1, 9227, 1296, 312),
(1298, 6, 9653, 1296, 315),
(1299, 0, 6956, 1296, 395),
(1301, 0, 11084, 1300, 288),
(1302, 6, 9720, 1300, 262),
(1304, 3, 5664, 1303, 45),
(1305, 1, 10786, 1303, 14),
(1306, 3, 8760, 1303, 87),
(1308, 4, 10884, 1307, 153),
(1309, 3, 8300, 1307, 139),
(1311, 3, 7376, 1310, 278),
(1312, 6, 365, 1310, 280),
(1313, 5, 7218, 1310, 213),
(1315, 6, 5169, 1314, 147),
(1316, 6, 6772, 1314, 182),
(1317, 0, 10991, 1314, 152),
(1318, 1, 6443, 1314, 194),
(1320, 0, 7075, 1319, 271),
(1321, 2, 3526, 1319, 275),
(1322, 4, 885, 1319, 388),
(1323, 6, 6787, 1319, 386),
(1324, 3, 1240, 1319, 309),
(1325, 3, 4582, 1319, 357),
(1327, 5, 5667, 1326, 318),
(1328, 6, 1240, 1326, 309),
(1329, 6, 8175, 1326, 311),
(1331, 1, 9327, 1330, 363),
(1332, 4, 3712, 1330, 351),
(1333, 0, 4409, 1330, 333),
(1335, 4, 4062, 1334, 294),
(1336, 5, 11181, 1334, 254),
(1337, 2, 2275, 1334, 236),
(1338, 1, 4281, 1334, 209),
(1340, 3, 8561, 1339, 428),
(1341, 6, 6115, 1339, 453),
(1343, 6, 10742, 1342, 34),
(1344, 5, 2187, 1342, 8),
(1345, 5, 6186, 1342, 92),
(1347, 3, 8489, 1346, 250),
(1348, 0, 2920, 1346, 257),
(1349, 4, 1130, 1346, 298),
(1351, 4, 8489, 1350, 250),
(1352, 0, 11293, 1350, 256),
(1354, 6, 8300, 1353, 139),
(1355, 6, 9054, 1353, 494),
(1356, 4, 348, 1353, 108),
(1357, 5, 9387, 1353, 136),
(1358, 0, 348, 1353, 108),
(1359, 5, 3744, 1353, 176),
(1361, 2, 285, 1360, 263),
(1363, 6, 3744, 1362, 176),
(1364, 1, 4839, 1362, 111),
(1365, 1, 671, 1362, 137),
(1366, 3, 8244, 1362, 112),
(1367, 0, 3746, 1362, 135),
(1368, 4, 6982, 1362, 204),
(1369, 5, 11030, 1362, 193),
(1370, 2, 435, 1362, 138),
(1371, 5, 11313, 1362, 206),
(1373, 4, 10483, 1372, 338),
(1374, 4, 9065, 1372, 349),
(1375, 5, 7262, 1372, 350),
(1376, 4, 9065, 1372, 349),
(1377, 6, 8705, 1372, 324),
(1378, 6, 9227, 1372, 312),
(1380, 1, 6775, 1379, 237),
(1381, 1, 2275, 1379, 236),
(1383, 5, 7602, 1382, 335),
(1384, 6, 434, 1382, 470),
(1385, 2, 9054, 1382, 494),
(1387, 6, 2411, 1386, 143),
(1388, 4, 4079, 1386, 411),
(1389, 2, 11030, 1386, 193),
(1390, 5, 7913, 1386, 132);

-- --------------------------------------------------------

--
-- Table structure for table `persistenceproduct`
--

CREATE TABLE `persistenceproduct` (
  `ID` bigint(20) NOT NULL,
  `DESCRIPTION` longtext DEFAULT NULL,
  `LISTPRICEINCENTS` bigint(20) DEFAULT NULL,
  `NAME` varchar(100) DEFAULT NULL,
  `CATEGORY_ID` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `persistenceproduct`
--

INSERT INTO `persistenceproduct` (`ID`, `DESCRIPTION`, `LISTPRICEINCENTS`, `NAME`, `CATEGORY_ID`) VALUES
(7, 'The best Replacement horn for Unicorns', 7582, 'Replacement horn', 2),
(8, 'The best Glitter (gold) for Unicorns', 2187, 'Glitter (gold)', 2),
(9, 'The best Glitter (silver) for Unicorns', 5569, 'Glitter (silver)', 2),
(10, 'The best Glitter (mixed color) for Unicorns', 1519, 'Glitter (mixed color)', 2),
(11, 'The best Saddle (leather) for Unicorns', 10601, 'Saddle (leather)', 2),
(12, 'The best Saddle (cloth) for Unicorns', 9700, 'Saddle (cloth)', 2),
(13, 'The best Irons (basic) for Unicorns', 11949, 'Irons (basic)', 2),
(14, 'The best Irons (guilded) for Unicorns', 10786, 'Irons (guilded)', 2),
(15, 'The best Mane comb for Unicorns', 9817, 'Mane comb', 2),
(16, 'The best Mane replacement for Unicorns', 9416, 'Mane replacement', 2),
(17, 'The best Food: Roses for Unicorns', 5926, 'Food: Roses', 2),
(18, 'The best Food: High quality hey for Unicorns', 9398, 'Food: High quality hey', 2),
(19, 'The best Replacement horn for Unicorns', 4842, 'Replacement horn, v1', 2),
(20, 'The best Glitter (gold) for Unicorns', 10655, 'Glitter (gold), v1', 2),
(21, 'The best Glitter (silver) for Unicorns', 3523, 'Glitter (silver), v1', 2),
(22, 'The best Glitter (mixed color) for Unicorns', 10185, 'Glitter (mixed color), v1', 2),
(23, 'The best Saddle (leather) for Unicorns', 4073, 'Saddle (leather), v1', 2),
(24, 'The best Saddle (cloth) for Unicorns', 2310, 'Saddle (cloth), v1', 2),
(25, 'The best Irons (basic) for Unicorns', 6112, 'Irons (basic), v1', 2),
(26, 'The best Irons (guilded) for Unicorns', 4112, 'Irons (guilded), v1', 2),
(27, 'The best Mane comb for Unicorns', 10403, 'Mane comb, v1', 2),
(28, 'The best Mane replacement for Unicorns', 11260, 'Mane replacement, v1', 2),
(29, 'The best Food: Roses for Unicorns', 8903, 'Food: Roses, v1', 2),
(30, 'The best Food: High quality hey for Unicorns', 3451, 'Food: High quality hey, v1', 2),
(31, 'The best Replacement horn for Unicorns', 2856, 'Replacement horn, v2', 2),
(32, 'The best Glitter (gold) for Unicorns', 1497, 'Glitter (gold), v2', 2),
(33, 'The best Glitter (silver) for Unicorns', 5275, 'Glitter (silver), v2', 2),
(34, 'The best Glitter (mixed color) for Unicorns', 10742, 'Glitter (mixed color), v2', 2),
(35, 'The best Saddle (leather) for Unicorns', 11810, 'Saddle (leather), v2', 2),
(36, 'The best Saddle (cloth) for Unicorns', 415, 'Saddle (cloth), v2', 2),
(37, 'The best Irons (basic) for Unicorns', 2784, 'Irons (basic), v2', 2),
(38, 'The best Irons (guilded) for Unicorns', 1387, 'Irons (guilded), v2', 2),
(39, 'The best Mane comb for Unicorns', 8652, 'Mane comb, v2', 2),
(40, 'The best Mane replacement for Unicorns', 1224, 'Mane replacement, v2', 2),
(41, 'The best Food: Roses for Unicorns', 5802, 'Food: Roses, v2', 2),
(42, 'The best Food: High quality hey for Unicorns', 5125, 'Food: High quality hey, v2', 2),
(43, 'The best Replacement horn for Unicorns', 1041, 'Replacement horn, v3', 2),
(44, 'The best Glitter (gold) for Unicorns', 638, 'Glitter (gold), v3', 2),
(45, 'The best Glitter (silver) for Unicorns', 5664, 'Glitter (silver), v3', 2),
(46, 'The best Glitter (mixed color) for Unicorns', 7728, 'Glitter (mixed color), v3', 2),
(47, 'The best Saddle (leather) for Unicorns', 10979, 'Saddle (leather), v3', 2),
(48, 'The best Saddle (cloth) for Unicorns', 1546, 'Saddle (cloth), v3', 2),
(49, 'The best Irons (basic) for Unicorns', 9965, 'Irons (basic), v3', 2),
(50, 'The best Irons (guilded) for Unicorns', 3452, 'Irons (guilded), v3', 2),
(51, 'The best Mane comb for Unicorns', 11636, 'Mane comb, v3', 2),
(52, 'The best Mane replacement for Unicorns', 8293, 'Mane replacement, v3', 2),
(53, 'The best Food: Roses for Unicorns', 8547, 'Food: Roses, v3', 2),
(54, 'The best Food: High quality hey for Unicorns', 7137, 'Food: High quality hey, v3', 2),
(55, 'The best Replacement horn for Unicorns', 148, 'Replacement horn, v4', 2),
(56, 'The best Glitter (gold) for Unicorns', 11690, 'Glitter (gold), v4', 2),
(57, 'The best Glitter (silver) for Unicorns', 7020, 'Glitter (silver), v4', 2),
(58, 'The best Glitter (mixed color) for Unicorns', 7900, 'Glitter (mixed color), v4', 2),
(59, 'The best Saddle (leather) for Unicorns', 807, 'Saddle (leather), v4', 2),
(60, 'The best Saddle (cloth) for Unicorns', 10732, 'Saddle (cloth), v4', 2),
(61, 'The best Irons (basic) for Unicorns', 3598, 'Irons (basic), v4', 2),
(62, 'The best Irons (guilded) for Unicorns', 10007, 'Irons (guilded), v4', 2),
(63, 'The best Mane comb for Unicorns', 9154, 'Mane comb, v4', 2),
(64, 'The best Mane replacement for Unicorns', 4995, 'Mane replacement, v4', 2),
(65, 'The best Food: Roses for Unicorns', 2042, 'Food: Roses, v4', 2),
(66, 'The best Food: High quality hey for Unicorns', 3526, 'Food: High quality hey, v4', 2),
(67, 'The best Replacement horn for Unicorns', 8194, 'Replacement horn, v5', 2),
(68, 'The best Glitter (gold) for Unicorns', 1346, 'Glitter (gold), v5', 2),
(69, 'The best Glitter (silver) for Unicorns', 8402, 'Glitter (silver), v5', 2),
(70, 'The best Glitter (mixed color) for Unicorns', 9421, 'Glitter (mixed color), v5', 2),
(71, 'The best Saddle (leather) for Unicorns', 393, 'Saddle (leather), v5', 2),
(72, 'The best Saddle (cloth) for Unicorns', 5060, 'Saddle (cloth), v5', 2),
(73, 'The best Irons (basic) for Unicorns', 11828, 'Irons (basic), v5', 2),
(74, 'The best Irons (guilded) for Unicorns', 1792, 'Irons (guilded), v5', 2),
(75, 'The best Mane comb for Unicorns', 7639, 'Mane comb, v5', 2),
(76, 'The best Mane replacement for Unicorns', 4613, 'Mane replacement, v5', 2),
(77, 'The best Food: Roses for Unicorns', 3144, 'Food: Roses, v5', 2),
(78, 'The best Food: High quality hey for Unicorns', 11331, 'Food: High quality hey, v5', 2),
(79, 'The best Replacement horn for Unicorns', 6753, 'Replacement horn, v6', 2),
(80, 'The best Glitter (gold) for Unicorns', 6125, 'Glitter (gold), v6', 2),
(81, 'The best Glitter (silver) for Unicorns', 450, 'Glitter (silver), v6', 2),
(82, 'The best Glitter (mixed color) for Unicorns', 7152, 'Glitter (mixed color), v6', 2),
(83, 'The best Saddle (leather) for Unicorns', 6864, 'Saddle (leather), v6', 2),
(84, 'The best Saddle (cloth) for Unicorns', 4455, 'Saddle (cloth), v6', 2),
(85, 'The best Irons (basic) for Unicorns', 7508, 'Irons (basic), v6', 2),
(86, 'The best Irons (guilded) for Unicorns', 5494, 'Irons (guilded), v6', 2),
(87, 'The best Mane comb for Unicorns', 8760, 'Mane comb, v6', 2),
(88, 'The best Mane replacement for Unicorns', 9168, 'Mane replacement, v6', 2),
(89, 'The best Food: Roses for Unicorns', 1779, 'Food: Roses, v6', 2),
(90, 'The best Food: High quality hey for Unicorns', 8958, 'Food: High quality hey, v6', 2),
(91, 'The best Replacement horn for Unicorns', 3251, 'Replacement horn, v7', 2),
(92, 'The best Glitter (gold) for Unicorns', 6186, 'Glitter (gold), v7', 2),
(93, 'The best Glitter (silver) for Unicorns', 8483, 'Glitter (silver), v7', 2),
(94, 'The best Glitter (mixed color) for Unicorns', 10601, 'Glitter (mixed color), v7', 2),
(95, 'The best Saddle (leather) for Unicorns', 986, 'Saddle (leather), v7', 2),
(96, 'The best Saddle (cloth) for Unicorns', 2832, 'Saddle (cloth), v7', 2),
(97, 'The best Irons (basic) for Unicorns', 7938, 'Irons (basic), v7', 2),
(98, 'The best Irons (guilded) for Unicorns', 9206, 'Irons (guilded), v7', 2),
(99, 'The best Mane comb for Unicorns', 7295, 'Mane comb, v7', 2),
(100, 'The best Mane replacement for Unicorns', 4196, 'Mane replacement, v7', 2),
(101, 'The best Food: Roses for Unicorns', 7695, 'Food: Roses, v7', 2),
(102, 'The best Food: High quality hey for Unicorns', 7680, 'Food: High quality hey, v7', 2),
(103, 'The best Replacement horn for Unicorns', 10122, 'Replacement horn, v8', 2),
(104, 'The best Glitter (gold) for Unicorns', 2564, 'Glitter (gold), v8', 2),
(105, 'The best Glitter (silver) for Unicorns', 149, 'Glitter (silver), v8', 2),
(106, 'The best Glitter (mixed color) for Unicorns', 5155, 'Glitter (mixed color), v8', 2),
(107, 'The best Aquarium 1x2m for Fish', 6670, 'Aquarium 1x2m', 3),
(108, 'The best Aquarium 1x3m for Fish', 348, 'Aquarium 1x3m', 3),
(109, 'The best Aquarium 2x3m for Fish', 10935, 'Aquarium 2x3m', 3),
(110, 'The best Aquarium 2x4m for Fish', 8063, 'Aquarium 2x4m', 3),
(111, 'The best Pump (up to 200 l) for Fish', 4839, 'Pump (up to 200 l)', 3),
(112, 'The best Pump (up to 4000 l) for Fish', 8244, 'Pump (up to 4000 l)', 3),
(113, 'The best Small net for Fish', 1018, 'Small net', 3),
(114, 'The best Medium Net for Fish', 565, 'Medium Net', 3),
(115, 'The best Decorative Rocks for Fish', 11859, 'Decorative Rocks', 3),
(116, 'The best Decorative Plants for Fish', 3274, 'Decorative Plants', 3),
(117, 'The best Food: Plankton for Fish', 8361, 'Food: Plankton', 3),
(118, 'The best Food: Small Fish for Fish', 7150, 'Food: Small Fish', 3),
(119, 'The best Aquarium 1x2m for Fish', 7658, 'Aquarium 1x2m, v1', 3),
(120, 'The best Aquarium 1x3m for Fish', 8123, 'Aquarium 1x3m, v1', 3),
(121, 'The best Aquarium 2x3m for Fish', 1193, 'Aquarium 2x3m, v1', 3),
(122, 'The best Aquarium 2x4m for Fish', 8699, 'Aquarium 2x4m, v1', 3),
(123, 'The best Pump (up to 200 l) for Fish', 7483, 'Pump (up to 200 l), v1', 3),
(124, 'The best Pump (up to 4000 l) for Fish', 6906, 'Pump (up to 4000 l), v1', 3),
(125, 'The best Small net for Fish', 8538, 'Small net, v1', 3),
(126, 'The best Medium Net for Fish', 1335, 'Medium Net, v1', 3),
(127, 'The best Decorative Rocks for Fish', 9348, 'Decorative Rocks, v1', 3),
(128, 'The best Decorative Plants for Fish', 11619, 'Decorative Plants, v1', 3),
(129, 'The best Food: Plankton for Fish', 2919, 'Food: Plankton, v1', 3),
(130, 'The best Food: Small Fish for Fish', 2665, 'Food: Small Fish, v1', 3),
(131, 'The best Aquarium 1x2m for Fish', 2733, 'Aquarium 1x2m, v2', 3),
(132, 'The best Aquarium 1x3m for Fish', 7913, 'Aquarium 1x3m, v2', 3),
(133, 'The best Aquarium 2x3m for Fish', 4618, 'Aquarium 2x3m, v2', 3),
(134, 'The best Aquarium 2x4m for Fish', 8486, 'Aquarium 2x4m, v2', 3),
(135, 'The best Pump (up to 200 l) for Fish', 3746, 'Pump (up to 200 l), v2', 3),
(136, 'The best Pump (up to 4000 l) for Fish', 9387, 'Pump (up to 4000 l), v2', 3),
(137, 'The best Small net for Fish', 671, 'Small net, v2', 3),
(138, 'The best Medium Net for Fish', 435, 'Medium Net, v2', 3),
(139, 'The best Decorative Rocks for Fish', 8300, 'Decorative Rocks, v2', 3),
(140, 'The best Decorative Plants for Fish', 2342, 'Decorative Plants, v2', 3),
(141, 'The best Food: Plankton for Fish', 4003, 'Food: Plankton, v2', 3),
(142, 'The best Food: Small Fish for Fish', 1480, 'Food: Small Fish, v2', 3),
(143, 'The best Aquarium 1x2m for Fish', 2411, 'Aquarium 1x2m, v3', 3),
(144, 'The best Aquarium 1x3m for Fish', 100, 'Aquarium 1x3m, v3', 3),
(145, 'The best Aquarium 2x3m for Fish', 5000, 'Aquarium 2x3m, v3', 3),
(146, 'The best Aquarium 2x4m for Fish', 5839, 'Aquarium 2x4m, v3', 3),
(147, 'The best Pump (up to 200 l) for Fish', 5169, 'Pump (up to 200 l), v3', 3),
(148, 'The best Pump (up to 4000 l) for Fish', 4594, 'Pump (up to 4000 l), v3', 3),
(149, 'The best Small net for Fish', 6968, 'Small net, v3', 3),
(150, 'The best Medium Net for Fish', 3660, 'Medium Net, v3', 3),
(151, 'The best Decorative Rocks for Fish', 11101, 'Decorative Rocks, v3', 3),
(152, 'The best Decorative Plants for Fish', 10991, 'Decorative Plants, v3', 3),
(153, 'The best Food: Plankton for Fish', 10884, 'Food: Plankton, v3', 3),
(154, 'The best Food: Small Fish for Fish', 12087, 'Food: Small Fish, v3', 3),
(155, 'The best Aquarium 1x2m for Fish', 11859, 'Aquarium 1x2m, v4', 3),
(156, 'The best Aquarium 1x3m for Fish', 6304, 'Aquarium 1x3m, v4', 3),
(157, 'The best Aquarium 2x3m for Fish', 10472, 'Aquarium 2x3m, v4', 3),
(158, 'The best Aquarium 2x4m for Fish', 1636, 'Aquarium 2x4m, v4', 3),
(159, 'The best Pump (up to 200 l) for Fish', 1557, 'Pump (up to 200 l), v4', 3),
(160, 'The best Pump (up to 4000 l) for Fish', 5856, 'Pump (up to 4000 l), v4', 3),
(161, 'The best Small net for Fish', 6524, 'Small net, v4', 3),
(162, 'The best Medium Net for Fish', 10500, 'Medium Net, v4', 3),
(163, 'The best Decorative Rocks for Fish', 3712, 'Decorative Rocks, v4', 3),
(164, 'The best Decorative Plants for Fish', 6229, 'Decorative Plants, v4', 3),
(165, 'The best Food: Plankton for Fish', 11577, 'Food: Plankton, v4', 3),
(166, 'The best Food: Small Fish for Fish', 580, 'Food: Small Fish, v4', 3),
(167, 'The best Aquarium 1x2m for Fish', 7014, 'Aquarium 1x2m, v5', 3),
(168, 'The best Aquarium 1x3m for Fish', 3294, 'Aquarium 1x3m, v5', 3),
(169, 'The best Aquarium 2x3m for Fish', 3494, 'Aquarium 2x3m, v5', 3),
(170, 'The best Aquarium 2x4m for Fish', 4019, 'Aquarium 2x4m, v5', 3),
(171, 'The best Pump (up to 200 l) for Fish', 11651, 'Pump (up to 200 l), v5', 3),
(172, 'The best Pump (up to 4000 l) for Fish', 10280, 'Pump (up to 4000 l), v5', 3),
(173, 'The best Small net for Fish', 7423, 'Small net, v5', 3),
(174, 'The best Medium Net for Fish', 5666, 'Medium Net, v5', 3),
(175, 'The best Decorative Rocks for Fish', 8478, 'Decorative Rocks, v5', 3),
(176, 'The best Decorative Plants for Fish', 3744, 'Decorative Plants, v5', 3),
(177, 'The best Food: Plankton for Fish', 8641, 'Food: Plankton, v5', 3),
(178, 'The best Food: Small Fish for Fish', 4004, 'Food: Small Fish, v5', 3),
(179, 'The best Aquarium 1x2m for Fish', 10142, 'Aquarium 1x2m, v6', 3),
(180, 'The best Aquarium 1x3m for Fish', 4098, 'Aquarium 1x3m, v6', 3),
(181, 'The best Aquarium 2x3m for Fish', 1716, 'Aquarium 2x3m, v6', 3),
(182, 'The best Aquarium 2x4m for Fish', 6772, 'Aquarium 2x4m, v6', 3),
(183, 'The best Pump (up to 200 l) for Fish', 10438, 'Pump (up to 200 l), v6', 3),
(184, 'The best Pump (up to 4000 l) for Fish', 9072, 'Pump (up to 4000 l), v6', 3),
(185, 'The best Small net for Fish', 4117, 'Small net, v6', 3),
(186, 'The best Medium Net for Fish', 9365, 'Medium Net, v6', 3),
(187, 'The best Decorative Rocks for Fish', 9391, 'Decorative Rocks, v6', 3),
(188, 'The best Decorative Plants for Fish', 223, 'Decorative Plants, v6', 3),
(189, 'The best Food: Plankton for Fish', 5503, 'Food: Plankton, v6', 3),
(190, 'The best Food: Small Fish for Fish', 1172, 'Food: Small Fish, v6', 3),
(191, 'The best Aquarium 1x2m for Fish', 5600, 'Aquarium 1x2m, v7', 3),
(192, 'The best Aquarium 1x3m for Fish', 780, 'Aquarium 1x3m, v7', 3),
(193, 'The best Aquarium 2x3m for Fish', 11030, 'Aquarium 2x3m, v7', 3),
(194, 'The best Aquarium 2x4m for Fish', 6443, 'Aquarium 2x4m, v7', 3),
(195, 'The best Pump (up to 200 l) for Fish', 7756, 'Pump (up to 200 l), v7', 3),
(196, 'The best Pump (up to 4000 l) for Fish', 3243, 'Pump (up to 4000 l), v7', 3),
(197, 'The best Small net for Fish', 2768, 'Small net, v7', 3),
(198, 'The best Medium Net for Fish', 10783, 'Medium Net, v7', 3),
(199, 'The best Decorative Rocks for Fish', 7177, 'Decorative Rocks, v7', 3),
(200, 'The best Decorative Plants for Fish', 6495, 'Decorative Plants, v7', 3),
(201, 'The best Food: Plankton for Fish', 9311, 'Food: Plankton, v7', 3),
(202, 'The best Food: Small Fish for Fish', 200, 'Food: Small Fish, v7', 3),
(203, 'The best Aquarium 1x2m for Fish', 4776, 'Aquarium 1x2m, v8', 3),
(204, 'The best Aquarium 1x3m for Fish', 6982, 'Aquarium 1x3m, v8', 3),
(205, 'The best Aquarium 2x3m for Fish', 3999, 'Aquarium 2x3m, v8', 3),
(206, 'The best Aquarium 2x4m for Fish', 11313, 'Aquarium 2x4m, v8', 3),
(207, 'The best Dog House 2x3m for Dogs', 8566, 'Dog House 2x3m', 4),
(208, 'The best Dog House 3x4m for Dogs', 9356, 'Dog House 3x4m', 4),
(209, 'The best Leash 2m for Dogs', 4281, 'Leash 2m', 4),
(210, 'The best Leash 3m for Dogs', 4245, 'Leash 3m', 4),
(211, 'The best Leash, extending (up to 5m) for Dogs', 3854, 'Leash, extending (up to 5m)', 4),
(212, 'The best Collar (textile, black) for Dogs', 9920, 'Collar (textile, black)', 4),
(213, 'The best Collar (textile, blue) for Dogs', 7218, 'Collar (textile, blue)', 4),
(214, 'The best Collar (textile, white) for Dogs', 1514, 'Collar (textile, white)', 4),
(215, 'The best Collar (metal) for Dogs', 10744, 'Collar (metal)', 4),
(216, 'The best Ball for Dogs', 1667, 'Ball', 4),
(217, 'The best Throwing Stick for Dogs', 947, 'Throwing Stick', 4),
(218, 'The best Tasty Meats for Dogs', 9370, 'Tasty Meats', 4),
(219, 'The best Eating Bowl for Dogs', 4322, 'Eating Bowl', 4),
(220, 'The best Water Bowl for Dogs', 3420, 'Water Bowl', 4),
(221, 'The best Dog House 2x3m for Dogs', 9429, 'Dog House 2x3m, v1', 4),
(222, 'The best Dog House 3x4m for Dogs', 203, 'Dog House 3x4m, v1', 4),
(223, 'The best Leash 2m for Dogs', 3578, 'Leash 2m, v1', 4),
(224, 'The best Leash 3m for Dogs', 10217, 'Leash 3m, v1', 4),
(225, 'The best Leash, extending (up to 5m) for Dogs', 3465, 'Leash, extending (up to 5m), v1', 4),
(226, 'The best Collar (textile, black) for Dogs', 3840, 'Collar (textile, black), v1', 4),
(227, 'The best Collar (textile, blue) for Dogs', 11589, 'Collar (textile, blue), v1', 4),
(228, 'The best Collar (textile, white) for Dogs', 753, 'Collar (textile, white), v1', 4),
(229, 'The best Collar (metal) for Dogs', 4673, 'Collar (metal), v1', 4),
(230, 'The best Ball for Dogs', 2905, 'Ball, v1', 4),
(231, 'The best Throwing Stick for Dogs', 927, 'Throwing Stick, v1', 4),
(232, 'The best Tasty Meats for Dogs', 1748, 'Tasty Meats, v1', 4),
(233, 'The best Eating Bowl for Dogs', 9022, 'Eating Bowl, v1', 4),
(234, 'The best Water Bowl for Dogs', 4758, 'Water Bowl, v1', 4),
(235, 'The best Dog House 2x3m for Dogs', 1583, 'Dog House 2x3m, v2', 4),
(236, 'The best Dog House 3x4m for Dogs', 2275, 'Dog House 3x4m, v2', 4),
(237, 'The best Leash 2m for Dogs', 6775, 'Leash 2m, v2', 4),
(238, 'The best Leash 3m for Dogs', 2969, 'Leash 3m, v2', 4),
(239, 'The best Leash, extending (up to 5m) for Dogs', 3142, 'Leash, extending (up to 5m), v2', 4),
(240, 'The best Collar (textile, black) for Dogs', 3916, 'Collar (textile, black), v2', 4),
(241, 'The best Collar (textile, blue) for Dogs', 3555, 'Collar (textile, blue), v2', 4),
(242, 'The best Collar (textile, white) for Dogs', 5032, 'Collar (textile, white), v2', 4),
(243, 'The best Collar (metal) for Dogs', 6517, 'Collar (metal), v2', 4),
(244, 'The best Ball for Dogs', 8142, 'Ball, v2', 4),
(245, 'The best Throwing Stick for Dogs', 3012, 'Throwing Stick, v2', 4),
(246, 'The best Tasty Meats for Dogs', 4146, 'Tasty Meats, v2', 4),
(247, 'The best Eating Bowl for Dogs', 264, 'Eating Bowl, v2', 4),
(248, 'The best Water Bowl for Dogs', 8235, 'Water Bowl, v2', 4),
(249, 'The best Dog House 2x3m for Dogs', 12048, 'Dog House 2x3m, v3', 4),
(250, 'The best Dog House 3x4m for Dogs', 8489, 'Dog House 3x4m, v3', 4),
(251, 'The best Leash 2m for Dogs', 98, 'Leash 2m, v3', 4),
(252, 'The best Leash 3m for Dogs', 1211, 'Leash 3m, v3', 4),
(253, 'The best Leash, extending (up to 5m) for Dogs', 10397, 'Leash, extending (up to 5m), v3', 4),
(254, 'The best Collar (textile, black) for Dogs', 11181, 'Collar (textile, black), v3', 4),
(255, 'The best Collar (textile, blue) for Dogs', 2774, 'Collar (textile, blue), v3', 4),
(256, 'The best Collar (textile, white) for Dogs', 11293, 'Collar (textile, white), v3', 4),
(257, 'The best Collar (metal) for Dogs', 2920, 'Collar (metal), v3', 4),
(258, 'The best Ball for Dogs', 2282, 'Ball, v3', 4),
(259, 'The best Throwing Stick for Dogs', 3167, 'Throwing Stick, v3', 4),
(260, 'The best Tasty Meats for Dogs', 11497, 'Tasty Meats, v3', 4),
(261, 'The best Eating Bowl for Dogs', 11201, 'Eating Bowl, v3', 4),
(262, 'The best Water Bowl for Dogs', 9720, 'Water Bowl, v3', 4),
(263, 'The best Dog House 2x3m for Dogs', 285, 'Dog House 2x3m, v4', 4),
(264, 'The best Dog House 3x4m for Dogs', 9568, 'Dog House 3x4m, v4', 4),
(265, 'The best Leash 2m for Dogs', 10263, 'Leash 2m, v4', 4),
(266, 'The best Leash 3m for Dogs', 9216, 'Leash 3m, v4', 4),
(267, 'The best Leash, extending (up to 5m) for Dogs', 6828, 'Leash, extending (up to 5m), v4', 4),
(268, 'The best Collar (textile, black) for Dogs', 6821, 'Collar (textile, black), v4', 4),
(269, 'The best Collar (textile, blue) for Dogs', 7228, 'Collar (textile, blue), v4', 4),
(270, 'The best Collar (textile, white) for Dogs', 11038, 'Collar (textile, white), v4', 4),
(271, 'The best Collar (metal) for Dogs', 7075, 'Collar (metal), v4', 4),
(272, 'The best Ball for Dogs', 1157, 'Ball, v4', 4),
(273, 'The best Throwing Stick for Dogs', 436, 'Throwing Stick, v4', 4),
(274, 'The best Tasty Meats for Dogs', 11713, 'Tasty Meats, v4', 4),
(275, 'The best Eating Bowl for Dogs', 3526, 'Eating Bowl, v4', 4),
(276, 'The best Water Bowl for Dogs', 5841, 'Water Bowl, v4', 4),
(277, 'The best Dog House 2x3m for Dogs', 992, 'Dog House 2x3m, v5', 4),
(278, 'The best Dog House 3x4m for Dogs', 7376, 'Dog House 3x4m, v5', 4),
(279, 'The best Leash 2m for Dogs', 4265, 'Leash 2m, v5', 4),
(280, 'The best Leash 3m for Dogs', 365, 'Leash 3m, v5', 4),
(281, 'The best Leash, extending (up to 5m) for Dogs', 6273, 'Leash, extending (up to 5m), v5', 4),
(282, 'The best Collar (textile, black) for Dogs', 615, 'Collar (textile, black), v5', 4),
(283, 'The best Collar (textile, blue) for Dogs', 11489, 'Collar (textile, blue), v5', 4),
(284, 'The best Collar (textile, white) for Dogs', 10464, 'Collar (textile, white), v5', 4),
(285, 'The best Collar (metal) for Dogs', 3147, 'Collar (metal), v5', 4),
(286, 'The best Ball for Dogs', 959, 'Ball, v5', 4),
(287, 'The best Throwing Stick for Dogs', 6760, 'Throwing Stick, v5', 4),
(288, 'The best Tasty Meats for Dogs', 11084, 'Tasty Meats, v5', 4),
(289, 'The best Eating Bowl for Dogs', 8488, 'Eating Bowl, v5', 4),
(290, 'The best Water Bowl for Dogs', 10923, 'Water Bowl, v5', 4),
(291, 'The best Dog House 2x3m for Dogs', 5613, 'Dog House 2x3m, v6', 4),
(292, 'The best Dog House 3x4m for Dogs', 8856, 'Dog House 3x4m, v6', 4),
(293, 'The best Leash 2m for Dogs', 1381, 'Leash 2m, v6', 4),
(294, 'The best Leash 3m for Dogs', 4062, 'Leash 3m, v6', 4),
(295, 'The best Leash, extending (up to 5m) for Dogs', 8630, 'Leash, extending (up to 5m), v6', 4),
(296, 'The best Collar (textile, black) for Dogs', 7688, 'Collar (textile, black), v6', 4),
(297, 'The best Collar (textile, blue) for Dogs', 9373, 'Collar (textile, blue), v6', 4),
(298, 'The best Collar (textile, white) for Dogs', 1130, 'Collar (textile, white), v6', 4),
(299, 'The best Collar (metal) for Dogs', 5011, 'Collar (metal), v6', 4),
(300, 'The best Ball for Dogs', 6670, 'Ball, v6', 4),
(301, 'The best Throwing Stick for Dogs', 2240, 'Throwing Stick, v6', 4),
(302, 'The best Tasty Meats for Dogs', 10244, 'Tasty Meats, v6', 4),
(303, 'The best Eating Bowl for Dogs', 3552, 'Eating Bowl, v6', 4),
(304, 'The best Water Bowl for Dogs', 8730, 'Water Bowl, v6', 4),
(305, 'The best Dog House 2x3m for Dogs', 9824, 'Dog House 2x3m, v7', 4),
(306, 'The best Dog House 3x4m for Dogs', 6659, 'Dog House 3x4m, v7', 4),
(307, 'The best Scratching Post (small) for Cats', 2103, 'Scratching Post (small)', 5),
(308, 'The best Scratching Post (huge) for Cats', 3597, 'Scratching Post (huge)', 5),
(309, 'The best Scratching Playground for Cats', 1240, 'Scratching Playground', 5),
(310, 'The best Food Bowl for Cats', 8200, 'Food Bowl', 5),
(311, 'The best Water Bowl for Cats', 8175, 'Water Bowl', 5),
(312, 'The best Collar, black for Cats', 9227, 'Collar, black', 5),
(313, 'The best Collar, white for Cats', 5498, 'Collar, white', 5),
(314, 'The best Collar, blue for Cats', 5687, 'Collar, blue', 5),
(315, 'The best Litter Box (small) for Cats', 9653, 'Litter Box (small)', 5),
(316, 'The best Litter Box (huge) for Cats', 11535, 'Litter Box (huge)', 5),
(317, 'The best Tasty Meat for Cats', 8595, 'Tasty Meat', 5),
(318, 'The best Gross Meat for Cats', 5667, 'Gross Meat', 5),
(319, 'The best Scratching Post (small) for Cats', 10949, 'Scratching Post (small), v1', 5),
(320, 'The best Scratching Post (huge) for Cats', 2936, 'Scratching Post (huge), v1', 5),
(321, 'The best Scratching Playground for Cats', 2716, 'Scratching Playground, v1', 5),
(322, 'The best Food Bowl for Cats', 8551, 'Food Bowl, v1', 5),
(323, 'The best Water Bowl for Cats', 6309, 'Water Bowl, v1', 5),
(324, 'The best Collar, black for Cats', 8705, 'Collar, black, v1', 5),
(325, 'The best Collar, white for Cats', 1216, 'Collar, white, v1', 5),
(326, 'The best Collar, blue for Cats', 6513, 'Collar, blue, v1', 5),
(327, 'The best Litter Box (small) for Cats', 9758, 'Litter Box (small), v1', 5),
(328, 'The best Litter Box (huge) for Cats', 1039, 'Litter Box (huge), v1', 5),
(329, 'The best Tasty Meat for Cats', 6053, 'Tasty Meat, v1', 5),
(330, 'The best Gross Meat for Cats', 10457, 'Gross Meat, v1', 5),
(331, 'The best Scratching Post (small) for Cats', 5112, 'Scratching Post (small), v2', 5),
(332, 'The best Scratching Post (huge) for Cats', 7907, 'Scratching Post (huge), v2', 5),
(333, 'The best Scratching Playground for Cats', 4409, 'Scratching Playground, v2', 5),
(334, 'The best Food Bowl for Cats', 8143, 'Food Bowl, v2', 5),
(335, 'The best Water Bowl for Cats', 7602, 'Water Bowl, v2', 5),
(336, 'The best Collar, black for Cats', 4783, 'Collar, black, v2', 5),
(337, 'The best Collar, white for Cats', 795, 'Collar, white, v2', 5),
(338, 'The best Collar, blue for Cats', 10483, 'Collar, blue, v2', 5),
(339, 'The best Litter Box (small) for Cats', 2458, 'Litter Box (small), v2', 5),
(340, 'The best Litter Box (huge) for Cats', 4261, 'Litter Box (huge), v2', 5),
(341, 'The best Tasty Meat for Cats', 5186, 'Tasty Meat, v2', 5),
(342, 'The best Gross Meat for Cats', 3134, 'Gross Meat, v2', 5),
(343, 'The best Scratching Post (small) for Cats', 5711, 'Scratching Post (small), v3', 5),
(344, 'The best Scratching Post (huge) for Cats', 10251, 'Scratching Post (huge), v3', 5),
(345, 'The best Scratching Playground for Cats', 11886, 'Scratching Playground, v3', 5),
(346, 'The best Food Bowl for Cats', 6526, 'Food Bowl, v3', 5),
(347, 'The best Water Bowl for Cats', 10640, 'Water Bowl, v3', 5),
(348, 'The best Collar, black for Cats', 4363, 'Collar, black, v3', 5),
(349, 'The best Collar, white for Cats', 9065, 'Collar, white, v3', 5),
(350, 'The best Collar, blue for Cats', 7262, 'Collar, blue, v3', 5),
(351, 'The best Litter Box (small) for Cats', 3712, 'Litter Box (small), v3', 5),
(352, 'The best Litter Box (huge) for Cats', 9575, 'Litter Box (huge), v3', 5),
(353, 'The best Tasty Meat for Cats', 3353, 'Tasty Meat, v3', 5),
(354, 'The best Gross Meat for Cats', 8580, 'Gross Meat, v3', 5),
(355, 'The best Scratching Post (small) for Cats', 7065, 'Scratching Post (small), v4', 5),
(356, 'The best Scratching Post (huge) for Cats', 4778, 'Scratching Post (huge), v4', 5),
(357, 'The best Scratching Playground for Cats', 4582, 'Scratching Playground, v4', 5),
(358, 'The best Food Bowl for Cats', 2803, 'Food Bowl, v4', 5),
(359, 'The best Water Bowl for Cats', 3658, 'Water Bowl, v4', 5),
(360, 'The best Collar, black for Cats', 6681, 'Collar, black, v4', 5),
(361, 'The best Collar, white for Cats', 1218, 'Collar, white, v4', 5),
(362, 'The best Collar, blue for Cats', 3601, 'Collar, blue, v4', 5),
(363, 'The best Litter Box (small) for Cats', 9327, 'Litter Box (small), v4', 5),
(364, 'The best Litter Box (huge) for Cats', 136, 'Litter Box (huge), v4', 5),
(365, 'The best Tasty Meat for Cats', 1594, 'Tasty Meat, v4', 5),
(366, 'The best Gross Meat for Cats', 5507, 'Gross Meat, v4', 5),
(367, 'The best Scratching Post (small) for Cats', 7147, 'Scratching Post (small), v5', 5),
(368, 'The best Scratching Post (huge) for Cats', 8105, 'Scratching Post (huge), v5', 5),
(369, 'The best Scratching Playground for Cats', 11288, 'Scratching Playground, v5', 5),
(370, 'The best Food Bowl for Cats', 3317, 'Food Bowl, v5', 5),
(371, 'The best Water Bowl for Cats', 10373, 'Water Bowl, v5', 5),
(372, 'The best Collar, black for Cats', 10847, 'Collar, black, v5', 5),
(373, 'The best Collar, white for Cats', 113, 'Collar, white, v5', 5),
(374, 'The best Collar, blue for Cats', 10294, 'Collar, blue, v5', 5),
(375, 'The best Litter Box (small) for Cats', 7004, 'Litter Box (small), v5', 5),
(376, 'The best Litter Box (huge) for Cats', 3760, 'Litter Box (huge), v5', 5),
(377, 'The best Tasty Meat for Cats', 2098, 'Tasty Meat, v5', 5),
(378, 'The best Gross Meat for Cats', 1311, 'Gross Meat, v5', 5),
(379, 'The best Scratching Post (small) for Cats', 2599, 'Scratching Post (small), v6', 5),
(380, 'The best Scratching Post (huge) for Cats', 7865, 'Scratching Post (huge), v6', 5),
(381, 'The best Scratching Playground for Cats', 11458, 'Scratching Playground, v6', 5),
(382, 'The best Food Bowl for Cats', 9908, 'Food Bowl, v6', 5),
(383, 'The best Water Bowl for Cats', 3950, 'Water Bowl, v6', 5),
(384, 'The best Collar, black for Cats', 5980, 'Collar, black, v6', 5),
(385, 'The best Collar, white for Cats', 5427, 'Collar, white, v6', 5),
(386, 'The best Collar, blue for Cats', 6787, 'Collar, blue, v6', 5),
(387, 'The best Litter Box (small) for Cats', 10975, 'Litter Box (small), v6', 5),
(388, 'The best Litter Box (huge) for Cats', 885, 'Litter Box (huge), v6', 5),
(389, 'The best Tasty Meat for Cats', 8875, 'Tasty Meat, v6', 5),
(390, 'The best Gross Meat for Cats', 1098, 'Gross Meat, v6', 5),
(391, 'The best Scratching Post (small) for Cats', 6254, 'Scratching Post (small), v7', 5),
(392, 'The best Scratching Post (huge) for Cats', 9610, 'Scratching Post (huge), v7', 5),
(393, 'The best Scratching Playground for Cats', 1194, 'Scratching Playground, v7', 5),
(394, 'The best Food Bowl for Cats', 6837, 'Food Bowl, v7', 5),
(395, 'The best Water Bowl for Cats', 6956, 'Water Bowl, v7', 5),
(396, 'The best Collar, black for Cats', 992, 'Collar, black, v7', 5),
(397, 'The best Collar, white for Cats', 5687, 'Collar, white, v7', 5),
(398, 'The best Collar, blue for Cats', 1700, 'Collar, blue, v7', 5),
(399, 'The best Litter Box (small) for Cats', 2370, 'Litter Box (small), v7', 5),
(400, 'The best Litter Box (huge) for Cats', 3082, 'Litter Box (huge), v7', 5),
(401, 'The best Tasty Meat for Cats', 1451, 'Tasty Meat, v7', 5),
(402, 'The best Gross Meat for Cats', 4939, 'Gross Meat, v7', 5),
(403, 'The best Scratching Post (small) for Cats', 11242, 'Scratching Post (small), v8', 5),
(404, 'The best Scratching Post (huge) for Cats', 5949, 'Scratching Post (huge), v8', 5),
(405, 'The best Scratching Playground for Cats', 4857, 'Scratching Playground, v8', 5),
(406, 'The best Food Bowl for Cats', 8052, 'Food Bowl, v8', 5),
(407, 'The best Terrarium 1x2m for Reptiles', 9002, 'Terrarium 1x2m', 6),
(408, 'The best Terrarium 1x3m for Reptiles', 7295, 'Terrarium 1x3m', 6),
(409, 'The best Terrarium 2x3m for Reptiles', 6969, 'Terrarium 2x3m', 6),
(410, 'The best Terrarium 2x4m for Reptiles', 1055, 'Terrarium 2x4m', 6),
(411, 'The best Heater (50 W) for Reptiles', 4079, 'Heater (50 W)', 6),
(412, 'The best Heater (200 W) for Reptiles', 1725, 'Heater (200 W)', 6),
(413, 'The best Excrement Scoop for Reptiles', 4880, 'Excrement Scoop', 6),
(414, 'The best Tropical Sun Light for Reptiles', 6153, 'Tropical Sun Light', 6),
(415, 'The best Ocean Sun Light for Reptiles', 11042, 'Ocean Sun Light', 6),
(416, 'The best Electric Incubator for Reptiles', 700, 'Electric Incubator', 6),
(417, 'The best Food: Flies for Reptiles', 9022, 'Food: Flies', 6),
(418, 'The best Food: Worms for Reptiles', 1866, 'Food: Worms', 6),
(419, 'The best Terrarium 1x2m for Reptiles', 8937, 'Terrarium 1x2m, v1', 6),
(420, 'The best Terrarium 1x3m for Reptiles', 1831, 'Terrarium 1x3m, v1', 6),
(421, 'The best Terrarium 2x3m for Reptiles', 10979, 'Terrarium 2x3m, v1', 6),
(422, 'The best Terrarium 2x4m for Reptiles', 9112, 'Terrarium 2x4m, v1', 6),
(423, 'The best Heater (50 W) for Reptiles', 7644, 'Heater (50 W), v1', 6),
(424, 'The best Heater (200 W) for Reptiles', 11751, 'Heater (200 W), v1', 6),
(425, 'The best Excrement Scoop for Reptiles', 4750, 'Excrement Scoop, v1', 6),
(426, 'The best Tropical Sun Light for Reptiles', 7530, 'Tropical Sun Light, v1', 6),
(427, 'The best Ocean Sun Light for Reptiles', 994, 'Ocean Sun Light, v1', 6),
(428, 'The best Electric Incubator for Reptiles', 8561, 'Electric Incubator, v1', 6),
(429, 'The best Food: Flies for Reptiles', 2276, 'Food: Flies, v1', 6),
(430, 'The best Food: Worms for Reptiles', 5335, 'Food: Worms, v1', 6),
(431, 'The best Terrarium 1x2m for Reptiles', 9417, 'Terrarium 1x2m, v2', 6),
(432, 'The best Terrarium 1x3m for Reptiles', 7288, 'Terrarium 1x3m, v2', 6),
(433, 'The best Terrarium 2x3m for Reptiles', 8426, 'Terrarium 2x3m, v2', 6),
(434, 'The best Terrarium 2x4m for Reptiles', 4380, 'Terrarium 2x4m, v2', 6),
(435, 'The best Heater (50 W) for Reptiles', 6014, 'Heater (50 W), v2', 6),
(436, 'The best Heater (200 W) for Reptiles', 12068, 'Heater (200 W), v2', 6),
(437, 'The best Excrement Scoop for Reptiles', 10991, 'Excrement Scoop, v2', 6),
(438, 'The best Tropical Sun Light for Reptiles', 8188, 'Tropical Sun Light, v2', 6),
(439, 'The best Ocean Sun Light for Reptiles', 6702, 'Ocean Sun Light, v2', 6),
(440, 'The best Electric Incubator for Reptiles', 3899, 'Electric Incubator, v2', 6),
(441, 'The best Food: Flies for Reptiles', 4024, 'Food: Flies, v2', 6),
(442, 'The best Food: Worms for Reptiles', 10017, 'Food: Worms, v2', 6),
(443, 'The best Terrarium 1x2m for Reptiles', 7962, 'Terrarium 1x2m, v3', 6),
(444, 'The best Terrarium 1x3m for Reptiles', 4187, 'Terrarium 1x3m, v3', 6),
(445, 'The best Terrarium 2x3m for Reptiles', 7753, 'Terrarium 2x3m, v3', 6),
(446, 'The best Terrarium 2x4m for Reptiles', 1057, 'Terrarium 2x4m, v3', 6),
(447, 'The best Heater (50 W) for Reptiles', 432, 'Heater (50 W), v3', 6),
(448, 'The best Heater (200 W) for Reptiles', 9289, 'Heater (200 W), v3', 6),
(449, 'The best Excrement Scoop for Reptiles', 6925, 'Excrement Scoop, v3', 6),
(450, 'The best Tropical Sun Light for Reptiles', 7421, 'Tropical Sun Light, v3', 6),
(451, 'The best Ocean Sun Light for Reptiles', 10156, 'Ocean Sun Light, v3', 6),
(452, 'The best Electric Incubator for Reptiles', 9060, 'Electric Incubator, v3', 6),
(453, 'The best Food: Flies for Reptiles', 6115, 'Food: Flies, v3', 6),
(454, 'The best Food: Worms for Reptiles', 2179, 'Food: Worms, v3', 6),
(455, 'The best Terrarium 1x2m for Reptiles', 8299, 'Terrarium 1x2m, v4', 6),
(456, 'The best Terrarium 1x3m for Reptiles', 4179, 'Terrarium 1x3m, v4', 6),
(457, 'The best Terrarium 2x3m for Reptiles', 8837, 'Terrarium 2x3m, v4', 6),
(458, 'The best Terrarium 2x4m for Reptiles', 9203, 'Terrarium 2x4m, v4', 6),
(459, 'The best Heater (50 W) for Reptiles', 4807, 'Heater (50 W), v4', 6),
(460, 'The best Heater (200 W) for Reptiles', 11869, 'Heater (200 W), v4', 6),
(461, 'The best Excrement Scoop for Reptiles', 5045, 'Excrement Scoop, v4', 6),
(462, 'The best Tropical Sun Light for Reptiles', 3454, 'Tropical Sun Light, v4', 6),
(463, 'The best Ocean Sun Light for Reptiles', 4660, 'Ocean Sun Light, v4', 6),
(464, 'The best Electric Incubator for Reptiles', 4119, 'Electric Incubator, v4', 6),
(465, 'The best Food: Flies for Reptiles', 5543, 'Food: Flies, v4', 6),
(466, 'The best Food: Worms for Reptiles', 2826, 'Food: Worms, v4', 6),
(467, 'The best Terrarium 1x2m for Reptiles', 2229, 'Terrarium 1x2m, v5', 6),
(468, 'The best Terrarium 1x3m for Reptiles', 1463, 'Terrarium 1x3m, v5', 6),
(469, 'The best Terrarium 2x3m for Reptiles', 9893, 'Terrarium 2x3m, v5', 6),
(470, 'The best Terrarium 2x4m for Reptiles', 434, 'Terrarium 2x4m, v5', 6),
(471, 'The best Heater (50 W) for Reptiles', 1948, 'Heater (50 W), v5', 6),
(472, 'The best Heater (200 W) for Reptiles', 3976, 'Heater (200 W), v5', 6),
(473, 'The best Excrement Scoop for Reptiles', 5219, 'Excrement Scoop, v5', 6),
(474, 'The best Tropical Sun Light for Reptiles', 7946, 'Tropical Sun Light, v5', 6),
(475, 'The best Ocean Sun Light for Reptiles', 8157, 'Ocean Sun Light, v5', 6),
(476, 'The best Electric Incubator for Reptiles', 8598, 'Electric Incubator, v5', 6),
(477, 'The best Food: Flies for Reptiles', 192, 'Food: Flies, v5', 6),
(478, 'The best Food: Worms for Reptiles', 9761, 'Food: Worms, v5', 6),
(479, 'The best Terrarium 1x2m for Reptiles', 10893, 'Terrarium 1x2m, v6', 6),
(480, 'The best Terrarium 1x3m for Reptiles', 4425, 'Terrarium 1x3m, v6', 6),
(481, 'The best Terrarium 2x3m for Reptiles', 11029, 'Terrarium 2x3m, v6', 6),
(482, 'The best Terrarium 2x4m for Reptiles', 1951, 'Terrarium 2x4m, v6', 6),
(483, 'The best Heater (50 W) for Reptiles', 2076, 'Heater (50 W), v6', 6),
(484, 'The best Heater (200 W) for Reptiles', 7823, 'Heater (200 W), v6', 6),
(485, 'The best Excrement Scoop for Reptiles', 7357, 'Excrement Scoop, v6', 6),
(486, 'The best Tropical Sun Light for Reptiles', 10542, 'Tropical Sun Light, v6', 6),
(487, 'The best Ocean Sun Light for Reptiles', 11628, 'Ocean Sun Light, v6', 6),
(488, 'The best Electric Incubator for Reptiles', 10290, 'Electric Incubator, v6', 6),
(489, 'The best Food: Flies for Reptiles', 10209, 'Food: Flies, v6', 6),
(490, 'The best Food: Worms for Reptiles', 11925, 'Food: Worms, v6', 6),
(491, 'The best Terrarium 1x2m for Reptiles', 4813, 'Terrarium 1x2m, v7', 6),
(492, 'The best Terrarium 1x3m for Reptiles', 1064, 'Terrarium 1x3m, v7', 6),
(493, 'The best Terrarium 2x3m for Reptiles', 5439, 'Terrarium 2x3m, v7', 6),
(494, 'The best Terrarium 2x4m for Reptiles', 9054, 'Terrarium 2x4m, v7', 6),
(495, 'The best Heater (50 W) for Reptiles', 10487, 'Heater (50 W), v7', 6),
(496, 'The best Heater (200 W) for Reptiles', 3241, 'Heater (200 W), v7', 6),
(497, 'The best Excrement Scoop for Reptiles', 1910, 'Excrement Scoop, v7', 6),
(498, 'The best Tropical Sun Light for Reptiles', 9433, 'Tropical Sun Light, v7', 6),
(499, 'The best Ocean Sun Light for Reptiles', 3779, 'Ocean Sun Light, v7', 6),
(500, 'The best Electric Incubator for Reptiles', 9020, 'Electric Incubator, v7', 6),
(501, 'The best Food: Flies for Reptiles', 1073, 'Food: Flies, v7', 6),
(502, 'The best Food: Worms for Reptiles', 4698, 'Food: Worms, v7', 6),
(503, 'The best Terrarium 1x2m for Reptiles', 8583, 'Terrarium 1x2m, v8', 6),
(504, 'The best Terrarium 1x3m for Reptiles', 4874, 'Terrarium 1x3m, v8', 6),
(505, 'The best Terrarium 2x3m for Reptiles', 6222, 'Terrarium 2x3m, v8', 6),
(506, 'The best Terrarium 2x4m for Reptiles', 5950, 'Terrarium 2x4m, v8', 6);

-- --------------------------------------------------------

--
-- Table structure for table `persistenceuser`
--

CREATE TABLE `persistenceuser` (
  `ID` bigint(20) NOT NULL,
  `EMAIL` varchar(255) DEFAULT NULL,
  `PASSWORD` varchar(255) DEFAULT NULL,
  `REALNAME` varchar(255) DEFAULT NULL,
  `USERNAME` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `persistenceuser`
--

INSERT INTO `persistenceuser` (`ID`, `EMAIL`, `PASSWORD`, `REALNAME`, `USERNAME`) VALUES
(507, 'user0@petsupplystore.fr', '$2a$10$nTQGt/A3frfvEf.3oNc0e.QNB3CcnBxwsRgnowQm88KUZ3voXcJbi', 'Helene Johnson', 'user0'),
(508, 'user1@petsupplystore.com', '$2a$10$zVxZmFUsinxzgap1ZO8IHusk5ycepkjSNnYwZgcnFvcbxJk1bfKRu', 'Richard Lewis', 'user1'),
(509, 'user2@petsupplystore.com', '$2a$10$f4DFwQjy4Ys2yiQjzEr/2uyQTF0oxTiBf9KXX3OmZXtkWgGEjPixW', 'Stephen Harris', 'user2'),
(510, 'user3@petsupplystore.com', '$2a$10$QV3Pp5WQtk9wE5vcUDER/OvxjvhAFbKo5ZMXc7FlNGfAa0mUZ1Zv6', 'Larry Williams', 'user3'),
(511, 'user4@petsupplystore.com', '$2a$10$Qn/KSTLj5kq2B6TJXhmatOEf2SWKSlp9.cbeAjJGhWrH1PwqlUseG', 'Margaret Clark', 'user4'),
(512, 'user5@petsupplystore.com', '$2a$10$fj.FzLptFUJ6gwtBOM/lse1F0qJQsIBeLZnSH.OEeQErlyLWa/yG.', 'Margaret Robinson', 'user5'),
(513, 'user6@petsupplystore.com', '$2a$10$4yAJ5nH3MTsPv/eTqqs7U.4VTaoxobRV11O6ixjo6F7Z4u7tJjSRq', 'Elizabeth Jones', 'user6'),
(514, 'user7@petsupplystore.com', '$2a$10$o6J29DzhmoV7JyKgXRjvou43t4sC38R17DA9CrWsMssAv742tjdVa', 'Lisa Wright', 'user7'),
(515, 'user8@petsupplystore.com', '$2a$10$EPNo7SCa3bQDUhcB4xqjaelht9XZ8evzk8WNfUZhfvV.pD.1VxMRi', 'Raymond Robinson', 'user8'),
(516, 'user9@petsupplystore.fr', '$2a$10$gDa8006j/DCne90hcHlGyuX7zoGxmdFGNUmJCgQbpWEwx4k1wQbGq', 'Larry Davis', 'user9'),
(517, 'user10@petsupplystore.com', '$2a$10$HR6plkx1QcscUFyLc0.QTO3LHbQ52zSu7iu1nCpU2BZD8JKYHMsH.', 'Lisa Hall', 'user10'),
(518, 'user11@petsupplystore.com', '$2a$10$maY5oxfrClK0.ISWeAtZS.aLElEkyLr6ac6xeVB1bdKx5JnPzbdbG', 'Maria Wilson', 'user11'),
(519, 'user12@petsupplystore.com', '$2a$10$9ZvE761R2fzFensCZh07aekDw0xZSz4zJGYgLsJdyrbcvyurChaCy', 'Anthony Clark', 'user12'),
(520, 'user13@petsupplystore.com', '$2a$10$ZBMxMHbjkqyRnGYzQOlXAeBWrz8hRnKRm0dOnkTtDALMqFENl4bsS', 'Joshua Martin', 'user13'),
(521, 'user14@petsupplystore.com', '$2a$10$lJL3m9cifad5UB/h0kswN.biTeXSDLiDOwS/aJTACOVRubtLgR1Ru', 'Donald Miller', 'user14'),
(522, 'user15@petsupplystore.com', '$2a$10$TifFmsyUDLUnzH2gGID4hubgrrCESN74E82shfbaXWl5gZ7eX8ia2', 'Kimberly Robinson', 'user15'),
(523, 'user16@petsupplystore.com', '$2a$10$Gz44fBQmPivy4Nrii7GDFuC8PHJFrdPFM4eowmD2jJyCXe.rXAkw6', 'Scott Smith', 'user16'),
(524, 'user17@petsupplystore.com', '$2a$10$GGpky82sukBa9K5dleYfyeNvjt.fjjm.Kts4OD/aUGH35oywqehZe', 'Mark Martin', 'user17'),
(525, 'user18@petsupplystore.com', '$2a$10$qXesg9Wrj3nZ.Ri166ykXeXXrWiJSGut6UP.2xF7sB60kQXSWot8.', 'Brian Jones', 'user18'),
(526, 'user19@petsupplystore.com', '$2a$10$qd.lX9oC2k4NPQ6lqrhSHeesC8vHcroRvfzlzYGkIUqlQfFsJXtl2', 'Helen Wilson', 'user19'),
(527, 'user20@petsupplystore.com', '$2a$10$uHdJZ/il8ArLdmIoKy1MX.0lbCCs2QZE4aXfwrgu/kWtmQS7.K9m.', 'Timothy Rodriguez', 'user20'),
(528, 'user21@petsupplystore.com', '$2a$10$qTQaXZUeKP3EZK0NDtXpk.1q58v/bI7A/fgscfGG3noYy2rlHwfLK', 'Susan Hill', 'user21'),
(529, 'user22@petsupplystore.com', '$2a$10$t.xH4swYIprjdyMolvwmBOiegSlBMyg952XmwP4sOc//ZDqDYdNTm', 'Cynthia Jones', 'user22'),
(530, 'user23@petsupplystore.com', '$2a$10$EtMvzcxFY4Hdo5Pz8mBgtuc61Yj4KJssblAgDzDQNLwHu4XZtTqT.', 'Michael Rodriguez', 'user23'),
(531, 'user24@petsupplystore.com', '$2a$10$hJvbsBXfSXv3Yzz8uibr1e9..6H78yu43.DLbAWWMtrbrpDjGQSKK', 'Carol Thomas', 'user24'),
(532, 'user25@petsupplystore.com', '$2a$10$6N09dmeRQZsW6t64BCFW.eYClXOhazI.rmJcS0eTPHOB57W5YM6US', 'Dorothy Thomas', 'user25'),
(533, 'user26@petsupplystore.com', '$2a$10$5eiyc0vbBPMmkCPKYhWUOOKU5bQxJ3vi9kp08r4Z13Lmkz50AUKiy', 'Joshua Miller', 'user26'),
(534, 'user27@petsupplystore.com', '$2a$10$rXuEvxFjqEbUy2nHB6230eOiiPUKHhi1IVOhwPDfJcwEA.zcV.tdm', 'Patrick Anderson', 'user27'),
(535, 'user28@petsupplystore.com', '$2a$10$nouFeRJEzuPbRWmf6tDILOGEfX3.g0/FTxbJmBkByhSR2Xu.GhnZi', 'Sharon Anderson', 'user28'),
(536, 'user29@petsupplystore.com', '$2a$10$UGnC7ylHgke7C9bAvaWmgeein3/kH7BJ7scPylz5IS4mkNL/31EXy', 'Gary Martinez', 'user29'),
(537, 'user30@petsupplystore.com', '$2a$10$yhTGnOL8GzAutcTwmVdVMuHqEmBA7cQ7szgj6.wGj81BLQr3ePx1O', 'John Johnson', 'user30'),
(538, 'user31@petsupplystore.com', '$2a$10$BmxaLDknOXMCn1rp9GUM6uzlLaSpLFBDF5/xHol2YlsCnx4r8p7/W', 'Walter King', 'user31'),
(539, 'user32@petsupplystore.com', '$2a$10$yT296OxU1lpz46GOoOpKUO4z11pS7J4Y192LNx2p38SPqfLVvUUS6', 'Robert Martinez', 'user32'),
(540, 'user33@petsupplystore.com', '$2a$10$pVIVL5XDqzwBQ37UdoCZhOr1wIo/uX.9uwdNl9WocodN0Kj/9I8SK', 'Nancy Smith', 'user33'),
(541, 'user34@petsupplystore.com', '$2a$10$tL6Xf/DVhgZtXgMvAFz8HukN/IC1U15A4cCNcZkU6GJ78TyXAg62y', 'Thomas Thompson', 'user34'),
(542, 'user35@petsupplystore.com', '$2a$10$Dnem9szgFqnmUFFj0DWH.O78hGSIzVPaw0LsxoDr17zVWHhXb47Z6', 'Patrick Walker', 'user35'),
(543, 'user36@petsupplystore.com', '$2a$10$rk1Q.pC/E4jVHdEjcGhQte8XEZdY6g8NUFa8KpE0KaAVDF.lczGEe', 'Charles Scoot', 'user36'),
(544, 'user37@petsupplystore.com', '$2a$10$4H6PGrKWMf7L8vywHGFCXu9/XYb0d9XWuzsbYgGR0MFRxu9lSbA3q', 'Betty Scoot', 'user37'),
(545, 'user38@petsupplystore.com', '$2a$10$I081qPKhXMkrlT.l/XJGluIEszZJm2kUstqugoFQvamSvzaC3bsGu', 'Jerry Smith', 'user38'),
(546, 'user39@petsupplystore.com', '$2a$10$VGt5nA9DmsNLT0y73Y6hJ.KP84XVJOGIb5jQFrAZ0QKRZQrzjQSlu', 'Michelle Lewis', 'user39'),
(547, 'user40@petsupplystore.com', '$2a$10$Bl5JgrvjPrJ.5WrJ9BEoZOX8pSEKc4wZoqPhbmHzEO8RSN./5Fq56', 'Kimberly Hernandez', 'user40'),
(548, 'user41@petsupplystore.com', '$2a$10$gCeSCE5Ws66bAexeabUa1./3PZJ.LN766OufKuSv.S45iwvT.K3Ge', 'Barbara Harris', 'user41'),
(549, 'user42@petsupplystore.com', '$2a$10$irdfVioNCmMFio3oglMkZe/duIg3HDl7mnbVzLahFFPByaTAxjSMS', 'Gary Williams', 'user42'),
(550, 'user43@petsupplystore.com', '$2a$10$1ZAozRxWK2hqyNWF0JqmlugbOPyUNJDZF1shgr9EZk7N2dAeIGmMa', 'Deborah Walker', 'user43'),
(551, 'user44@petsupplystore.com', '$2a$10$K2HknclLoYjWRUcXDeH7a.NlSOM2I.v.facxyuOUwxF1IyScYNLJS', 'Patricia Davis', 'user44'),
(552, 'user45@petsupplystore.com', '$2a$10$Pzm3.y9VAlHMS6ZzBwAqeuupA8y4pFdTOMAz7jQaxBqe5cQllLQpq', 'Michelle Harris', 'user45'),
(553, 'user46@petsupplystore.com', '$2a$10$pLAxEuHO5EQE6y35XpIK.ukFsUePuNFcS/skfs8O/5WmmhNmA89LS', 'Donna White', 'user46'),
(554, 'user47@petsupplystore.com', '$2a$10$yQAcl24ldWFqcNZQQaTbCerKdu9gyUm0Ac14iPWw8mOK49bFaC7dO', 'Sarah Martinez', 'user47'),
(555, 'user48@petsupplystore.com', '$2a$10$Wh5d/fkDzPZLa8.d7nlyf.C7WOyrfGDUhUo.IoKJDj9p41VYC5qwe', 'Karen Lee', 'user48'),
(556, 'user49@petsupplystore.com', '$2a$10$X3p2ZAj.sc.E4rclKJ/6mu0AS3v8JX4S9JuG4EEOArBIQCoozzs3K', 'Shirley Lee', 'user49'),
(557, 'user50@petsupplystore.com', '$2a$10$hvllwU0Vs/RO9TJUQBI7MuFjTgMMkQ.Vjv17ByWDdgSS2Yhpq8gwq', 'Timothy King', 'user50'),
(558, 'user51@petsupplystore.com', '$2a$10$kuTIk3WMEjUkpPBz1rCVy.UGAsPXIgr3TJG63ewEMkT8Q8abj9wAG', 'Kevin Brown', 'user51'),
(559, 'user52@petsupplystore.com', '$2a$10$kEFY1g6wjKtx/bSNNejQvu9BIQRZF.KbOSHGJQkK.8R3JQ579qRhm', 'Jospeph Hernandez', 'user52'),
(560, 'user53@petsupplystore.com', '$2a$10$zek1ouHNbhkA09dFGMwFf.2mIFOQdTMWkIVYgz3J7.Lzoe.rn5Vxq', 'Elizabeth Jackson', 'user53'),
(561, 'user54@petsupplystore.com', '$2a$10$1VepWBI2KFfLg1HhA4kQEuRRkzmOadGDbS2h43.zJuwZnneyCYbf6', 'Jerry Allen', 'user54'),
(562, 'user55@petsupplystore.com', '$2a$10$5SfAet6IdgH32lNtVv0IfOcf/GbzArw5gSM2Ktng00w9cSvXMo.cy', 'Scott Williams', 'user55'),
(563, 'user56@petsupplystore.com', '$2a$10$owNR7UjVVOSyoZ3jHRHvdeOA7pSs8hT5fss8U7MX7iWqV6AUL4TAa', 'Stephen Taylor', 'user56'),
(564, 'user57@petsupplystore.com', '$2a$10$sW2tUhzF0NIMdWdW7odJvuUCUHV4TWjn1jDJwhgnjdjT7R81VvsIi', 'Richard Hall', 'user57'),
(565, 'user58@petsupplystore.com', '$2a$10$IS1G3rlAid1dh1puyrVPD.K.VSH2AEGdWxHmtIYMNY/VDh/3sv15y', 'Richard Smith', 'user58'),
(566, 'user59@petsupplystore.com', '$2a$10$f8nQIBgQ3/y21diMzHqCCOsSfEO/BLeM.wZ1pvh8NkyL8HYPqjN6q', 'Betty Martin', 'user59'),
(567, 'user60@petsupplystore.com', '$2a$10$TcOjh3D4jVFPKKMV72n./uDyRUGJP4YJDCtcb8VUVvE.OwRPmchXS', 'Kimberly Harris', 'user60'),
(568, 'user61@petsupplystore.com', '$2a$10$ErOWYrW49V42pBa.p0E7HeBKrhOc.XJwFRUNmHPPqQAhfylrv9fWq', 'Peter Brown', 'user61'),
(569, 'user62@petsupplystore.com', '$2a$10$euPmqSvg9ueuzqaPxqhOVev8eKRsuhmEkxlKRtUXqLekag00h5bV6', 'Jessica Martin', 'user62'),
(570, 'user63@petsupplystore.com', '$2a$10$zLe5jsO1zHx/hD2vDGgvO.IlRyly2IqQKn.arkWLalVNqvWCf.Kse', 'Gary Jackson', 'user63'),
(571, 'user64@petsupplystore.com', '$2a$10$M6PKopLtlVo7yYbBLw0Ga.1rSbILuZg954CUC84YKS72VeIKASZny', 'Anthony Johnson', 'user64'),
(572, 'user65@petsupplystore.com', '$2a$10$pGQgeUiS8042Hr.KOnhQ7u4L67Jyten9xzhWIrtf74kwkMNry8gOC', 'Maria Walker', 'user65'),
(573, 'user66@petsupplystore.com', '$2a$10$KiQWMmtQd3so0bR5O6YJhuqHCBYQ6l6T3fH9oyoBRpBAnon7j4U8C', 'Patricia Thompson', 'user66'),
(574, 'user67@petsupplystore.com', '$2a$10$HhOsbWAFrIu0bV8tfPIha.YJK0xV7FksnoOYcpL6h0fDy71zwYsg.', 'Dennis Smith', 'user67'),
(575, 'user68@petsupplystore.com', '$2a$10$p8aCWqfLU7OSPid08tZ2Pew0rbpWU1cQLPhC3xxhqah51wkw09oAK', 'Cynthia Robinson', 'user68'),
(576, 'user69@petsupplystore.com', '$2a$10$5HNEHgklTdE.v0oiRHcbfeGkHO0mwRVMGiZHRt/lubz9nj4y0uAzm', 'John Brown', 'user69'),
(577, 'user70@petsupplystore.com', '$2a$10$EbYFBQJhO.KbJJg5899B3eyeiiBBSqU27L4r/qxay4RE1nCnpF47O', 'Paul Thompson', 'user70'),
(578, 'user71@petsupplystore.com', '$2a$10$Cfu0A37OSNgEieNw.l9TtODHI43PaT5QHA6VEupBEVzmaAIGbfBgG', 'Paul Hill', 'user71'),
(579, 'user72@petsupplystore.com', '$2a$10$rl9ohLoxHS6yPVnWM7tgz.xt3ljYio3hcQ21L7jVrRqli7Gq99LPO', 'Mark Anderson', 'user72'),
(580, 'user73@petsupplystore.com', '$2a$10$9hGfGaybDlVMH2lgwvKQcub8b6M5XgAXEsXpfl0IdeqB/VIAh9Zy2', 'Patricia Moorse', 'user73'),
(581, 'user74@petsupplystore.com', '$2a$10$UePObvwYpx1rIBG9RU7hxuenNrJths4hY8mAgA.getsfXIkD5K.ja', 'James Harris', 'user74'),
(582, 'user75@petsupplystore.com', '$2a$10$KcfhF2qeJNxsZzs6CDEjueka61GNTyaxLgOT0oU.U2y6v7DvYOs6S', 'Lisa Robinson', 'user75'),
(583, 'user76@petsupplystore.com', '$2a$10$nQDKvxb9zrdNumoXdmg8g.qXvbXAZzdABP8fxAYKnwSyZO9bs.PE.', 'Jerry Martin', 'user76'),
(584, 'user77@petsupplystore.com', '$2a$10$ejz5zDdxG6v5b7k3E/Pv7uucQhZUXtanUxUrb86cqIo1SDpFXo2B2', 'Walter King', 'user77'),
(585, 'user78@petsupplystore.com', '$2a$10$5flKpOilMiRxASZIxhN7NuMjfD1u9ChWzwBuQWi/a0VGSh83JIyry', 'Jospeph Lewis', 'user78'),
(586, 'user79@petsupplystore.com', '$2a$10$WKOcp2p15G1rdbN0XKHSeOML.M4vhcd84gYdFFVOC9c5tVTstLxeC', 'Matthew Martinez', 'user79'),
(587, 'user80@petsupplystore.com', '$2a$10$ws59UpisYXnyeB8pagQBZeZx/gWae1FQ.6EAwRLvozTIE2QxDgDPm', 'Barbara Martinez', 'user80'),
(588, 'user81@petsupplystore.com', '$2a$10$auKmywaCuEd2zi7SiSBFgeDqU1ccYd5Dh91FZ9Uc3T/uQOv9OmyVy', 'Shirley Jones', 'user81'),
(589, 'user82@petsupplystore.com', '$2a$10$NoWL0umPLW7CEm7j4uQj2Ov1aewTnuUYaWip3wB3.6TGCtSigsvri', 'Edward Martinez', 'user82'),
(590, 'user83@petsupplystore.com', '$2a$10$SvbayKqCw4eVxie7I69eoOfrf6jfxerIFy.OY5ydjBgxTxdn8nPKa', 'Mark Thomas', 'user83'),
(591, 'user84@petsupplystore.com', '$2a$10$BkXyPYOOAxb29hTs/pA7Qu/2GYrM.o20iLOe00sMRGRbhf7tn9bx2', 'Dorothy Brown', 'user84'),
(592, 'user85@petsupplystore.com', '$2a$10$XgG.UFPTm7UZbkflbEob/ec85gSGs1xS5XeklAVBoV/qB2F/Y76Du', 'Deborah Wilson', 'user85'),
(593, 'user86@petsupplystore.com', '$2a$10$/8AWqeH6rXH4WKNmRjMOUOMMJCVuwjVrYXpRQDUeU65OSEVsu9vQy', 'Ruth Johnson', 'user86'),
(594, 'user87@petsupplystore.com', '$2a$10$wnr6fQpSKBMynku5sbokiOoMWCQ9EwPH6q6G3MdsTudckj9gFU6h2', 'Maria Taylor', 'user87'),
(595, 'user88@petsupplystore.com', '$2a$10$7D55iWVS/xTwqwQWvgcAK.Lem50CO3KSZixtHOpqvQZhwx3H6KgHe', 'Susan Williams', 'user88'),
(596, 'user89@petsupplystore.com', '$2a$10$93LsJJtqMILlO/pWSU553e17Pgtbq3hTwJ9EX8oE/vCDktCMPF0/i', 'Maria Hall', 'user89'),
(597, 'user90@petsupplystore.com', '$2a$10$AkHzXjGRnHIq3tJPqy/5CO4hq1orJg.3ENS8MQLylkj/dqcQ0GMei', 'Kevin Brown', 'user90'),
(598, 'user91@petsupplystore.com', '$2a$10$pRohWxQ1I9sSZ5/7gh1EqeTv5OEoRwTI66jkHwk3eRqjeG.paibnm', 'Gary Rodriguez', 'user91'),
(599, 'user92@petsupplystore.com', '$2a$10$MalM4nXwlZyW9WrXtRFAROvU11eUCwnPrYXnFUF2NKLd4PUXmYrsq', 'Laura Hill', 'user92'),
(600, 'user93@petsupplystore.com', '$2a$10$y41xkYKgpdFo0jqN70x3nu8DkwXd3rG.M0.6MCEjKgPUF88XYRwCi', 'Timothy Johnson', 'user93'),
(601, 'user94@petsupplystore.com', '$2a$10$mZWVUy6KDVgnNoqx1kuSDO9LUdWGDPeNHj2MgcKSpru.uqIHhiDMG', 'Karen Jackson', 'user94'),
(602, 'user95@petsupplystore.com', '$2a$10$GW7LnUmflNdYzOBCIUxB0.6nNffKtQjIDum8Dh2rBm6Uze1Xec0F6', 'Jerry Thomas', 'user95'),
(603, 'user96@petsupplystore.com', '$2a$10$joKN00V5aXshfUlfYyWxBuFEBnVIpUeSAq5you8Lo363I6b7WNDIO', 'Eric Moorse', 'user96'),
(604, 'user97@petsupplystore.com', '$2a$10$S3b.6Qs0RV4GCLXx8gAijOdxXJNVxthaw3poHGatznD4lfLZzNHQa', 'Gregory Wright', 'user97'),
(605, 'user98@petsupplystore.com', '$2a$10$YoCLkcQ6OP9dF.w1f7wIaufGJaLBaCN6xnCLbtpCHw.uOT4tJPezS', 'Jennifer Jackson', 'user98'),
(606, 'user99@petsupplystore.com', '$2a$10$wE9Tn./8TwcptCQev.32Jumi6sDPJUHWce0f1Tb5amikQH7Zhccou', 'Nancy Hernandez', 'user99');

-- --------------------------------------------------------

--
-- Stand-in structure for view `provider_view`
-- (See below for the actual view)
--
CREATE TABLE `provider_view` (
`po_ID` bigint(20)
,`po_ADDRESS1` varchar(255)
,`po_ADDRESS2` varchar(255)
,`po_ADDRESSNAME` varchar(255)
,`po_CREDITCARDCOMPANY` varchar(255)
,`po_CREDITCARDEXPIRYLOCALDATE` date
,`po_CREDITCARDNUMBER` varchar(255)
,`po_ORDERTIME` datetime
,`po_TOTALPRICEINCENTS` bigint(20)
,`po_USER_ID` bigint(20)
,`pu_ID` bigint(20)
,`pu_EMAIL` varchar(255)
,`pu_PASSWORD` varchar(255)
,`pu_REALNAME` varchar(255)
,`pu_USERNAME` varchar(255)
);

-- --------------------------------------------------------

--
-- Table structure for table `sequence`
--

CREATE TABLE `sequence` (
  `SEQ_NAME` varchar(50) NOT NULL,
  `SEQ_COUNT` decimal(38,0) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence`
--

INSERT INTO `sequence` (`SEQ_NAME`, `SEQ_COUNT`) VALUES
('SEQ_GEN', '1400');

-- --------------------------------------------------------

--
-- Structure for view `provider_view`
--
DROP TABLE IF EXISTS `provider_view`;

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `provider_view`  AS SELECT `po`.`ID` AS `po_ID`, `po`.`ADDRESS1` AS `po_ADDRESS1`, `po`.`ADDRESS2` AS `po_ADDRESS2`, `po`.`ADDRESSNAME` AS `po_ADDRESSNAME`, `po`.`CREDITCARDCOMPANY` AS `po_CREDITCARDCOMPANY`, `po`.`CREDITCARDEXPIRYLOCALDATE` AS `po_CREDITCARDEXPIRYLOCALDATE`, `po`.`CREDITCARDNUMBER` AS `po_CREDITCARDNUMBER`, `po`.`ORDERTIME` AS `po_ORDERTIME`, `po`.`TOTALPRICEINCENTS` AS `po_TOTALPRICEINCENTS`, `po`.`USER_ID` AS `po_USER_ID`, `pu`.`ID` AS `pu_ID`, `pu`.`EMAIL` AS `pu_EMAIL`, `pu`.`PASSWORD` AS `pu_PASSWORD`, `pu`.`REALNAME` AS `pu_REALNAME`, `pu`.`USERNAME` AS `pu_USERNAME` FROM (`persistenceorder` `po` join `persistenceuser` `pu`)  ;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `databasemanagemententity`
--
ALTER TABLE `databasemanagemententity`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `persistencecategory`
--
ALTER TABLE `persistencecategory`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `persistenceorder`
--
ALTER TABLE `persistenceorder`
  ADD PRIMARY KEY (`ID`),
  ADD KEY `FK_PERSISTENCEORDER_USER_ID` (`USER_ID`);

--
-- Indexes for table `persistenceorderitem`
--
ALTER TABLE `persistenceorderitem`
  ADD PRIMARY KEY (`ID`),
  ADD KEY `FK_PERSISTENCEORDERITEM_ORDER_ID` (`ORDER_ID`),
  ADD KEY `FK_PERSISTENCEORDERITEM_PRODUCT_ID` (`PRODUCT_ID`);

--
-- Indexes for table `persistenceproduct`
--
ALTER TABLE `persistenceproduct`
  ADD PRIMARY KEY (`ID`),
  ADD KEY `FK_PERSISTENCEPRODUCT_CATEGORY_ID` (`CATEGORY_ID`);

--
-- Indexes for table `persistenceuser`
--
ALTER TABLE `persistenceuser`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `sequence`
--
ALTER TABLE `sequence`
  ADD PRIMARY KEY (`SEQ_NAME`);

--
-- Constraints for dumped tables
--

--
-- Constraints for table `persistenceorder`
--
ALTER TABLE `persistenceorder`
  ADD CONSTRAINT `FK_PERSISTENCEORDER_USER_ID` FOREIGN KEY (`USER_ID`) REFERENCES `persistenceuser` (`ID`);

--
-- Constraints for table `persistenceorderitem`
--
ALTER TABLE `persistenceorderitem`
  ADD CONSTRAINT `FK_PERSISTENCEORDERITEM_ORDER_ID` FOREIGN KEY (`ORDER_ID`) REFERENCES `persistenceorder` (`ID`),
  ADD CONSTRAINT `FK_PERSISTENCEORDERITEM_PRODUCT_ID` FOREIGN KEY (`PRODUCT_ID`) REFERENCES `persistenceproduct` (`ID`);

--
-- Constraints for table `persistenceproduct`
--
ALTER TABLE `persistenceproduct`
  ADD CONSTRAINT `FK_PERSISTENCEPRODUCT_CATEGORY_ID` FOREIGN KEY (`CATEGORY_ID`) REFERENCES `persistencecategory` (`ID`);
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;