-- --------------------------------------------------------
-- Server OS:                    Win64
-- HeidiSQL Version:             12.0.0.6468
-- --------------------------------------------------------



-- Dumping database structure for purchase_order_db
CREATE DATABASE IF NOT EXISTS `purchase_order_db` /*!40100 DEFAULT CHARACTER SET utf8mb4 */;
USE `purchase_order_db`;

-- Dumping structure for table purchase_order_db.item_list
CREATE TABLE IF NOT EXISTS `item_list` (
  `id` int(30) NOT NULL AUTO_INCREMENT,
  `name` varchar(250) NOT NULL,
  `description` text NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT ' 1 = Active, 0 = Inactive',
  `date_created` datetime NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=305 DEFAULT CHARSET=utf8mb4;

-- Dumping data for table purchase_order_db.item_list: ~304 rows (approximately)
REPLACE INTO `item_list` (`id`, `name`, `description`, `status`, `date_created`) VALUES
	(1, '1', 'Lemon Ice', 1, '2021-09-08 10:17:19'),
	(2, '2', 'Berry Burst', 0, '2021-09-08 10:21:42'),
	(3, '3', 'Black RaspBerry', 1, '2021-09-08 10:22:10'),
	(4, '4', 'Blue Hawaii', 1, '2022-09-04 09:51:47'),
	(5, '5', 'Blueberry', 0, '2022-09-04 09:55:16'),
	(6, '6', 'Bubble Gum', 1, '2022-09-04 09:55:31'),
	(7, '8', 'Cantaloupe', 0, '2022-09-04 09:57:28'),
	(8, '9', 'Carribbean Splash', 1, '2022-09-04 09:58:13'),
	(9, '10', 'Cherry', 1, '2022-09-04 09:58:45'),
	(10, '11', 'Chocolate', 1, '2022-09-04 10:00:06'),
	(11, '12', 'Cotton Candy', 1, '2022-09-04 19:52:49'),
	(12, '14', 'Grape', 1, '2022-09-04 19:53:22'),
	(13, '15', 'Honeydew', 1, '2022-09-04 19:53:39'),
	(14, '16', 'Ice Tea', 0, '2022-09-04 19:53:51'),
	(15, '17', 'Island Punch', 0, '2022-09-04 10:11:17'),
	(16, '18', 'Lime', 1, '2022-09-04 10:14:06'),
	(17, '19', 'Mai Tai', 0, '2022-09-04 10:14:42'),
	(18, '20', 'Mango', 1, '2022-09-04 10:15:54'),
	(19, '21', 'Margaharita', 1, '2022-09-04 10:16:27'),
	(20, '22', 'Orange', 1, '2022-09-04 10:17:12'),
	(21, '23', 'Passion Fruit', 1, '2021-09-04 10:12:12'),
	(22, '24', 'Peach', 1, '2022-09-04 10:18:08'),
	(23, '25', 'Pineapple', 1, '2022-09-04 10:18:50'),
	(24, '27', 'Root Beer', 1, '2022-09-04 10:23:12'),
	(25, '30', 'Strawberry', 1, '2022-09-04 10:25:59'),
	(26, '31', 'Strawberry Margharita', 1, '2022-09-04 10:27:07'),
	(27, '32', 'Watermelon', 1, '2022-09-05 09:53:29'),
	(28, '33', 'Banana', 1, '2022-09-04 10:30:56'),
	(29, '34', 'Cappuccino', 1, '2022-09-04 10:49:57'),
	(30, '35 ', 'Choco. Macaroon', 1, '2022-09-04 11:37:27'),
	(31, '36', 'Choco Mousse Chip', 1, '2022-09-04 11:38:21'),
	(32, '37', 'Coconut', 1, '2022-09-04 11:39:03'),
	(33, '38', 'Cremalata', 1, '2022-09-04 11:39:40'),
	(34, '39', 'Mint Chip', 1, '2022-09-04 11:40:22'),
	(35, '40', 'Mint Ice', 0, '2021-09-04 11:40:42'),
	(36, '41', 'Mousse No Chips', 1, '2022-09-04 11:41:21'),
	(37, '42', 'Pina Colada', 1, '2022-09-04 11:41:50'),
	(38, '43', 'Pistachio', 1, '2022-09-04 11:42:28'),
	(39, '44', 'Rum Raisin', 0, '2022-09-04 11:42:54'),
	(40, '45', 'Vanilla', 1, '2022-09-05 09:57:33'),
	(41, '46', 'Vanilla Chip', 1, '2022-09-04 11:44:04'),
	(42, '47', 'Cherry Cola', 1, '2022-09-04 11:44:26'),
	(43, '48', 'Choco. Cookies & Creme', 1, '2022-09-04 11:45:21'),
	(44, '49', 'Cola', 1, '2022-09-04 11:45:37'),
	(45, '50', 'Cookies & Cremw', 1, '2022-09-04 11:46:19'),
	(46, '51', 'Orange & Creme', 1, '2022-09-04 11:46:39'),
	(47, '52', 'Key Lime', 1, '2022-09-04 11:48:35'),
	(48, '53', 'Malibu Bay Breeze', 1, '2022-09-04 11:49:04'),
	(49, '54', 'Peanut Butter', 1, '2022-09-04 11:49:24'),
	(50, '55', 'Red Raspberry', 1, '2022-09-04 11:50:20'),
	(51, '56', 'Strawberry Banana', 1, '2022-09-04 11:50:52'),
	(52, '57', 'Chocolate  Milk', 1, '2022-09-04 11:51:26'),
	(53, '58', 'Crazy Coconut', 1, '2022-09-04 11:52:08'),
	(54, '59', 'Banana Fudge', 1, '2022-09-04 11:52:30'),
	(55, '60', 'Blk Cherry Vanilla', 1, '2022-09-05 10:00:54'),
	(56, '61', 'Blk Cherry Cheescake', 1, '2022-09-04 11:53:23'),
	(57, '62', 'Cannoli', 1, '2022-09-04 11:54:00'),
	(58, '63', 'Cherry Jubilee', 1, '2022-09-04 11:54:24'),
	(59, '64', 'Choco PB Cup', 1, '2022-09-04 11:54:53'),
	(60, '65', 'Choco Fudge Brownie', 1, '2022-09-04 11:55:23'),
	(61, '66', 'Choco Marshmellow', 1, '2022-09-04 11:56:00'),
	(62, '67 ', 'Banzai Banana', 1, '2022-09-04 11:56:39'),
	(63, '68', 'Coconut Rasp Tart', 1, '2022-09-04 11:57:06'),
	(64, '69', 'Dulce de Leche', 1, '2022-09-04 11:57:41'),
	(65, '70', 'Health Bar', 1, '2021-09-04 11:58:08'),
	(66, '71', 'Java Chip', 1, '2022-09-04 12:16:54'),
	(67, '72', 'Jelly Ring', 1, '2022-09-04 12:17:19'),
	(68, '73', 'Lemon Meringue', 1, '2022-09-04 12:17:46'),
	(69, '74', 'Choc Caramel', 1, '2022-09-04 12:18:13'),
	(70, '75', 'Mint Madness', 1, '2022-09-04 12:18:38'),
	(71, '76', 'Mocha Chip', 1, '2022-09-04 12:19:04'),
	(72, '77', 'Mud Slide', 1, '2022-09-04 12:19:43'),
	(73, '78', 'Choc Hazelnut', 1, '2022-09-04 12:20:03'),
	(74, '79', 'PB Cookie Dough', 1, '2022-09-04 12:20:31'),
	(75, '80', 'Cookie Dough', 0, '2022-09-04 12:20:51'),
	(76, '81', 'PB & Jelly', 1, '2022-09-04 12:21:00'),
	(77, '82', 'Peppermint Patty', 1, '2022-09-04 12:22:04'),
	(78, '83', 'Pineapple Cheese Cake', 1, '2022-09-04 12:22:55'),
	(79, '84', 'Rocky Road', 1, '2022-09-04 12:23:15'),
	(80, '85', 'Toasted Marshmallow', 1, '2022-09-04 12:23:41'),
	(81, '86', 'P.B. Candy Bar Fudge', 1, '2022-09-04 12:24:13'),
	(82, '87', 'P.B. Candy Bar', 1, '2022-09-04 12:24:33'),
	(83, '88', 'Strawberry Cheese Cake', 1, '2022-09-04 12:25:08'),
	(84, '89', 'Strawberry Daquari', 0, '2022-09-04 12:25:48'),
	(85, '90', 'Strawberry SHACKcake', 1, '2022-09-04 12:26:29'),
	(86, '91', 'Tiramisu', 1, '2022-09-04 12:27:03'),
	(87, '92', 'Vanilla Fudge Crunch', 0, '2022-09-04 12:27:27'),
	(88, '93', 'Vanilla Fudge Brownie', 1, '2022-09-04 12:27:54'),
	(89, '94', 'Vanilla Peanut Butter', 1, '2022-09-04 12:28:33'),
	(90, '95', 'Butter Pecan Ice Cream', 1, '2022-09-04 12:28:59'),
	(91, '96', 'Cake Batter Ice Cream', 1, '2022-09-04 12:29:22'),
	(92, '97', 'Chocolate Ice Cream', 1, '2022-09-04 12:29:46'),
	(93, '98', 'Cookie Dough Ice Cream', 1, '2022-09-04 12:30:19'),
	(94, '99', 'Min Chip Ice Cream', 1, '2022-09-04 12:31:37'),
	(95, '100', 'Mississippi Mud Ice Cream', 1, '2022-09-05 10:08:16'),
	(96, '101', 'Pistachio Ice Cream', 1, '2022-09-04 12:32:14'),
	(97, '103', 'Strawberry Ice Cream', 1, '2022-09-04 12:33:21'),
	(98, '104', 'Vanilla Chip Ice Cream', 1, '2022-09-04 12:33:56'),
	(99, '106', 'Vanilla Ice Cream', 1, '2022-09-04 12:34:21'),
	(100, '108', 'Spumoni', 1, '2022-09-04 12:35:32'),
	(101, '109', 'Rainbow', 1, '2022-09-04 12:36:16'),
	(102, '110', 'Sugar Free Chocolate', 1, '2022-09-04 16:21:22'),
	(103, '111', 'NSA Cherry', 1, '2022-09-04 16:21:46'),
	(104, '112', 'NSA Lemon', 1, '2021-09-04 16:22:16'),
	(105, '113', 'NSA Vanilla Chip', 1, '2022-09-04 16:22:56'),
	(106, '114', 'NSA Lemon Lime', 1, '2022-09-04 16:23:25'),
	(107, '115', 'NSA Java Chip', 1, '2022-09-04 16:23:49'),
	(108, '116', 'NSA Chocolate Mousse', 1, '2022-09-04 16:24:40'),
	(109, '117 ', 'NSA Cremesickle', 1, '2022-09-04 16:25:10'),
	(110, '118', 'NSA Cappuccino', 1, '2022-09-04 16:26:02'),
	(111, '119', 'Lemon Lime', 0, '2022-09-05 10:11:57'),
	(112, '120', 'Citrus Twister', 1, '2022-09-05 10:12:26'),
	(113, '122', 'Brownies tray', 1, '2022-09-04 16:26:28'),
	(114, '123', 'Choco Espresso Bean', 1, '2022-09-04 16:26:59'),
	(115, '124', 'Choco Chip Cookies for Sundae', 1, '2022-09-04 16:28:06'),
	(116, '125', 'Chocolate Sprinkles 10 lbs', 1, '2022-09-04 16:29:35'),
	(117, '126 ', 'Cookie Pieces', 1, '2022-09-04 16:30:07'),
	(118, '127', 'Frozen Strawberries for Sundae', 1, '2022-09-04 16:30:45'),
	(119, '128', 'Giardelli Choco Powder', 1, '2022-09-04 16:31:32'),
	(120, '129', 'Giardelli Vanills Powder', 1, '2022-09-04 16:32:09'),
	(121, '130', 'Graham Cracker Crunch Topping', 1, '2022-09-04 16:32:40'),
	(122, '131', 'Hot Fudge', 1, '2022-09-04 16:33:01'),
	(123, '132', 'Mint Bit Cookies', 1, '2022-09-04 16:33:24'),
	(124, '133', 'Nerds', 1, '2022-09-04 16:33:53'),
	(125, '134', 'Rainbow Sprinkles 10 lbs', 1, '2022-09-04 16:34:27'),
	(126, '135', 'Reeses Pieces', 1, '2022-09-04 16:34:45'),
	(127, '136', 'Toasted Coconut', 1, '2022-09-04 16:35:07'),
	(128, '138', 'White Coconut Bits', 1, '2022-09-04 16:35:48'),
	(129, '140', 'Dutch Apple Pie', 1, '2022-09-05 10:16:32'),
	(130, '141', 'Birthday Cake', 1, '2022-09-05 10:17:14'),
	(131, '142', 'Whip Charges', 1, '2022-09-04 16:36:19'),
	(132, '143', 'Rainbow Cookie', 1, '2022-09-04 16:36:45'),
	(133, '144', 'Shipping Fee', 1, '2022-09-04 16:37:07'),
	(134, '145', 'Sour Cherry', 0, '2022-09-04 16:37:32'),
	(135, '147', 'Coffee Ice Cream', 1, '2022-09-04 16:38:06'),
	(136, 're', 'Returned Check Fee', 1, '2022-09-04 16:38:35'),
	(137, 'g2', '$2 Gift Certificate', 1, '2021-09-04 16:39:18'),
	(138, 'g5', '$5 Gift Certificate', 1, '2022-09-04 16:39:53'),
	(139, 'cr', 'Credit', 1, '2022-09-04 16:40:13'),
	(140, '150', 'Pound Cake', 1, '2022-09-04 16:40:33'),
	(141, '151', 'Sea Salt Caramel Topping', 1, '2022-09-04 16:47:02'),
	(142, 'cl', 'Clipper 4/23 & 8/18 Mailing', 1, '2022-09-04 16:47:52'),
	(143, 'va', 'Val Pak 5/8 & 9/8 Mailing', 1, '2022-09-04 16:48:43'),
	(144, '149', 'Cocolate Cup Cake', 1, '2022-09-04 16:49:13'),
	(145, '200', 'whip cream dispenser', 1, '2022-09-04 16:49:44'),
	(146, '156', 'Black Forest', 1, '2022-09-05 10:21:35'),
	(147, '161', 'Rocky Road Ice Cream', 1, '2022-09-04 16:50:24'),
	(148, '162', 'Candy Bar Ice Cream', 1, '2022-09-04 16:50:56'),
	(149, '153', 'Chocolate Drops', 1, '2022-09-05 10:22:46'),
	(150, '163', ' Vanilla Swiss Almond', 1, '2022-09-04 16:51:30'),
	(151, '164', 'Vanilla Chip Water', 1, '2022-09-04 16:52:08'),
	(152, 'c2', '$2 coupon credit', 1, '2022-09-04 16:53:01'),
	(153, '165', 'NSA Mint Chip', 1, '2022-09-04 16:53:27'),
	(154, '166', 'crazy coconut ice cream', 0, '2022-09-04 16:53:55'),
	(155, '167', 'Cookies & Cream Ice Cream', 1, '2022-09-04 16:54:22'),
	(156, '168', 'van swiss almond Ice Cream', 1, '2022-09-04 16:55:18'),
	(157, 'vf', 'Vanilla Flavor', 1, '2022-09-04 16:55:42'),
	(158, 'cd', 'Choc Cone Dip', 1, '2022-09-04 16:56:19'),
	(159, 'wc', 'whip cream package', 1, '2022-09-04 16:56:53'),
	(160, 'mn', 'Mixed Nuts (2.5 lbs)', 1, '2022-09-04 16:57:18'),
	(161, 'MT ', 'Marshmallow Topping', 1, '2022-09-04 16:58:32'),
	(162, 'at', 'Apple Topping', 1, '2022-09-04 16:59:03'),
	(163, 'cc', '2 lb. Cocolate Crunch Topping', 1, '2022-09-04 16:59:53'),
	(164, '169', 'Macadamia Craze', 1, '2022-09-04 17:00:30'),
	(165, 'CF', 'Choco Flvr Soft Serve', 0, '2022-09-04 17:01:17'),
	(166, 'cl2', 'Clipper aug 13th mailing', 1, '2022-09-04 17:02:45'),
	(167, 'vp2', 'Val Pak Sept 6th Mailing', 1, '2022-09-04 17:04:14'),
	(168, 'ccr', 'Clipper Coupon Credit', 1, '2022-09-04 17:04:54'),
	(169, 'ecr', 'Entertainment Coupon Credit', 1, '2022-09-04 17:05:37'),
	(170, 'vcr', 'Val Pak July 09 Coupon Credit', 1, '2022-09-04 17:06:38'),
	(171, 'gcr', 'Gift Certificate Refund', 1, '2022-09-04 17:07:20'),
	(172, '155', 'Butter Scotch Chip', 1, '2022-09-04 17:09:49'),
	(173, '148', 'Melon Mania', 1, '2022-09-04 17:10:58'),
	(174, '7', 'Chocolate Chip Cheesecake', 1, '2022-09-04 17:12:26'),
	(175, 'rf', 'September 2020 Mix Royalty', 1, '2022-09-04 17:13:08'),
	(176, '170', 'Maple Walnut Ice', 1, '2022-09-04 17:13:39'),
	(177, 'BC', 'Black Cherry Topping', 1, '2022-09-04 17:14:16'),
	(178, '171', 'Broken P.B. Cups', 1, '2022-09-04 17:15:51'),
	(179, '172', 'Peanut Butter Sauce', 1, '2022-09-04 17:17:05'),
	(180, '173', 'Red Raspberry Sauce', 1, '2022-09-04 17:18:07'),
	(181, '154', 'Pink Guava', 0, '2022-09-04 17:20:00'),
	(182, '176', 'Choc Fudge Pretzel', 1, '2022-09-04 17:41:44'),
	(183, '177', 'P.B. Fudge Pretzel', 1, '2022-09-04 17:42:30'),
	(184, '178', 'Chocolate Malt', 1, '2022-09-04 17:43:01'),
	(185, '179', 'Vanilla Malt Crunch', 1, '2022-09-04 17:43:32'),
	(186, 'nc', 'Newsday coupon credit', 1, '2022-09-04 17:44:08'),
	(187, '180', 'Blk Rasp I.C.', 1, '2022-09-04 17:44:47'),
	(188, '2009', '2009 Advertising co-op', 1, '2022-09-04 17:48:03'),
	(189, '201', '6 pk fun bucket(lemon)', 1, '2022-09-04 17:48:55'),
	(190, '202', '6 pk fun bucket(Mango)', 1, '2022-09-04 17:49:07'),
	(191, '203', '6 pk fun bucket(Strawberry)', 1, '2022-09-04 17:50:16'),
	(192, '204', '6 pk fun bucket(Vanilla Chip)', 1, '2022-09-04 17:50:43'),
	(193, '205', '6 pk fun bucket(Choc Mousse)', 1, '2022-09-04 17:51:18'),
	(194, '182', 'Pink Lemonade', 0, '2022-09-04 17:51:45'),
	(195, '183', 'Cinnamon Roll', 0, '2022-09-04 17:52:16'),
	(196, '184', 'Graham Crunch Ice', 1, '2022-09-04 17:52:49'),
	(197, 'trays', 'Carry Out Trays (Case 175 ct)', 1, '2022-09-04 17:53:42'),
	(198, '185', 'Chocolate Layer Cake', 1, '2022-09-04 17:54:05'),
	(199, '186', 'Mint Cookie Crumb', 1, '2022-09-04 17:54:49'),
	(200, '206', 'Mango Puree', 1, '2022-09-04 17:55:26'),
	(201, '207', 'Strawberry Puree', 1, '2022-09-04 17:56:03'),
	(202, '208', 'Lemon Puree', 1, '2022-09-04 17:56:31'),
	(203, '209', 'Blk Rasp Puree', 1, '2022-09-04 17:57:08'),
	(204, '210 ', 'Peach Puree', 1, '2022-09-04 17:57:29'),
	(205, '211', 'Passion Colada Puree', 1, '2022-09-04 17:58:04'),
	(206, 'g3', '$3 Gift Certificates', 0, '2022-09-04 17:58:39'),
	(207, 'g10', '$10 Gift Certificates', 0, '2022-09-04 17:59:11'),
	(208, 'cc5', 'Chocolate Crunch 5lb.', 1, '2022-09-04 17:59:48'),
	(209, '187', 'Blood Orange', 1, '2022-09-04 18:00:18'),
	(210, '174', 'Mini M &  M\'s(4 lbs)', 0, '2022-09-04 18:01:02'),
	(211, '188', 'Cassata', 1, '2022-09-04 18:01:20'),
	(212, '189', 'Hazelnut', 1, '2022-09-04 18:01:42'),
	(213, 'cp', 'Caramel Pump', 1, '2022-09-04 18:02:13'),
	(214, '190', 'Orange Cranberry', 1, '2022-09-04 18:02:46'),
	(215, '212', 'Rum Runner Puree', 1, '2022-09-04 18:03:19'),
	(216, '191', 'Carrot Cake', 0, '2022-09-04 18:03:57'),
	(217, '192', 'Linzer Tart', 1, '2022-09-04 18:04:25'),
	(218, '196', 'Red Velvet', 0, '2022-09-04 18:04:49'),
	(219, '215', 'Vanilla Chip Ice Cream', 1, '2022-09-04 18:05:21'),
	(220, '216', 'Blk Cherry Ice Cream', 1, '2022-09-04 18:05:46'),
	(221, '217', 'Blk Raspberry Ice Cream', 1, '2022-09-04 18:06:18'),
	(222, '218', 'No Fat Vanille I.C.', 1, '2022-09-04 18:06:48'),
	(223, '219', 'No Fat Coffee I.C.', 1, '2022-09-04 18:07:23'),
	(224, '220', 'No Fat Choco I.C.', 1, '2022-09-04 18:07:51'),
	(225, '221', 'Peanut Butter Fluff', 0, '2022-09-04 18:07:59'),
	(226, '214', 'Chocolate Cake Batter I.C.', 0, '2022-09-04 18:08:54'),
	(227, '230', 'Fat Free Blueberry Tart Yogurt', 1, '2022-09-04 18:09:28'),
	(228, '231', 'Fat Free Strawberry Tart Yogurt', 1, '2022-09-04 18:10:00'),
	(229, '232', 'Fat Free Blk Raspberry Tart Yogurt', 1, '2022-09-04 18:10:40'),
	(230, '233', 'Low Fat Vanilla Yogurt', 1, '2022-09-04 18:11:28'),
	(231, '234', 'Low Fat Chocolate Yogurt', 1, '2022-09-04 18:11:55'),
	(232, '235', 'Low Fat Espresso Chip Yogurt', 1, '2022-09-04 18:12:29'),
	(233, '236', 'Gummi Bear', 1, '2022-09-04 18:12:52'),
	(234, 'ec', 'Espresso Chips', 1, '2022-09-04 18:13:24'),
	(235, '237', 'Sour Apple', 1, '2022-09-04 18:19:11'),
	(236, '222', 'Vanilla Graham Cracker I.C.', 1, '2022-09-04 18:19:52'),
	(237, '223', 'Key Lime Pie', 1, '2022-09-04 18:20:17'),
	(238, '224', 'Pumpkin Cheesecake', 1, '2022-09-04 18:20:49'),
	(239, '238', 'Pumpkin Pie', 0, '2022-09-04 18:21:15'),
	(240, 'pc', '2011 Promotional Credit', 1, '2022-09-04 18:21:50'),
	(241, '239', 'Cookie & Creme Cheesecake', 0, '2022-09-04 18:22:28'),
	(242, '240', 'Irish Creme Pie I.C.', 0, '2022-09-04 18:22:56'),
	(243, '241', 'French Cookie Custard IC', 0, '2022-09-04 18:23:29'),
	(244, '242', 'Blueberry Cheesecake', 1, '2022-09-04 18:23:50'),
	(245, '197', 'Peanut Cluster I.C.', 0, '2022-09-04 18:24:24'),
	(246, '300', 'Peanut Brittle', 1, '2022-09-04 18:24:51'),
	(247, '243', 'Blue/Cotton Candy I.C.', 1, '2022-09-04 18:25:30'),
	(248, '198', 'Pancake Ice Cream', 1, '2022-09-04 18:26:05'),
	(249, '244', 'Crunchy Peanut Butter', 0, '2022-09-04 18:26:42'),
	(250, '245', 'Cinnamon Ice Cream', 0, '2022-09-04 18:26:57'),
	(251, 'fi', 'Late Fee Inv #V', 1, '2022-09-04 18:28:27'),
	(252, '246', 'Cookie Craze Ice Cream', 1, '2022-09-04 18:28:55'),
	(253, '247', 'Butter Almond I.C.', 1, '2022-09-04 18:29:31'),
	(254, 'pp', 'Pretzel Pieces', 1, '2022-09-04 18:29:54'),
	(255, '333', 'Salty Caramel Pretzel', 1, '2022-09-04 18:30:20'),
	(256, '334', 'Choc Graham Marshmallow', 1, '2022-09-04 18:30:59'),
	(257, '335', 'caramel apple', 0, '2022-09-04 18:31:17'),
	(258, 'pl', 'Pistachio Flavor', 1, '2022-09-04 18:32:15'),
	(259, 'caf', 'Cannoli Flavor', 1, '2022-09-04 18:32:44'),
	(260, 'crf', 'Cremalata Flavor', 1, '2022-09-04 18:33:13'),
	(261, 'chf', 'Cherry Flavor', 1, '2022-09-04 18:33:36'),
	(262, 'bf', 'Blue Flavor', 1, '2022-09-04 18:33:55'),
	(263, 'scf', 'Salty Caramel Flavor', 1, '2022-09-04 18:34:31'),
	(264, '336', 'Sour Punch', 0, '2022-09-04 18:34:58'),
	(265, '340', 'confetti cake', 1, '2022-09-04 18:35:27'),
	(266, '343', 'Paulies Pecan Pie', 0, '2022-09-04 18:36:06'),
	(267, 'mf', 'Mint Flavor', 1, '2022-09-04 18:36:34'),
	(268, '341', 'Caramel Kettlecorn', 1, '2022-09-04 18:40:22'),
	(269, 'bcp', 'Broken Cookie Pieces (Box)', 1, '2022-09-04 18:41:01'),
	(270, 'chocdrop', 'Chocolate Drops (box)', 1, '2022-09-04 18:41:59'),
	(271, 'waf', 'Frozen Waffles', 1, '2022-09-04 18:42:29'),
	(272, 'acai', 'Acai Sorbet (3 Gal)', 1, '2022-09-04 18:43:06'),
	(273, 'bro', 'Brownies (60 cnt)', 1, '2022-09-04 18:43:50'),
	(274, 'ccc', 'Chocolate Chip Cookies', 1, '2022-09-04 18:44:46'),
	(275, '28', 'Sour Blue', 1, '2022-09-04 18:45:06'),
	(276, '301', 'PB Fudge Brownie', 1, '2022-09-04 18:45:33'),
	(277, 'XC1', 'Small printed Cups (1000 ct)', 1, '2022-09-04 18:46:09'),
	(278, 'XC2', 'Medium Printed Cups (1000 ct)', 1, '2022-09-04 18:46:49'),
	(279, 'XC3', 'Large Printed Cups (1000 ct)', 1, '2022-09-04 18:47:37'),
	(280, 'XL1', 'Dome Lids D- 80 (2000 ct)', 1, '2022-09-04 18:49:22'),
	(281, 'XL2', 'Flat Lid D- 80 (2000ct)', 1, '2022-09-04 18:50:12'),
	(282, 'scm', 'Sweeten Condensed Milk', 1, '2022-09-04 18:54:40'),
	(283, 'DCD', 'David Edible Cookie Dough (2pk)', 1, '2022-09-04 18:55:28'),
	(284, 'DCDB', 'David Edible Birthday Cake Dough(2)', 1, '2022-09-04 18:56:40'),
	(285, 'XC4', '4oz. Printed Pape Cup (2000ct)', 1, '2022-09-04 18:57:35'),
	(286, 'XL3', 'Flat Lid D- 75 for 4oz Cups (2000ct)', 1, '2022-09-04 18:59:03'),
	(287, 'XC8', '8oz Small I.C. Cup', 0, '2022-09-04 18:59:45'),
	(288, 'XL8', 'Dome Lid D- 98 for 8oz/12oz/Sundae', 1, '2022-09-04 19:01:12'),
	(289, 'Xl16', 'Paper Print/Quart D- 118', 1, '2022-09-04 19:01:56'),
	(290, 'XC16', 'Paper Print Container', 1, '2022-09-04 19:02:28'),
	(291, 'XC32', 'Paper Quart Container', 1, '2022-09-04 19:02:50'),
	(292, '152', 'Caramel Topping', 1, '2022-09-04 19:03:09'),
	(293, 'g4', '$4 Gift Certificate', 1, '2022-09-04 19:03:36'),
	(294, 'XC12', '12oz Large I.C. Cup', 1, '2022-09-04 19:04:27'),
	(295, 'ma', 'Disposable Masks with Ear Loops ', 1, '2022-09-04 19:05:33'),
	(296, 'dcdpb', 'Davids Edible PB Mini Reeses', 1, '2022-09-04 19:06:24'),
	(297, 'dcdch', 'Davids Edible Triple Chocolate Brownie', 1, '2022-09-04 19:06:54'),
	(298, 'XC64', 'Fun Bucket (64oz)', 1, '2022-09-04 19:07:49'),
	(299, 'XC86', 'Party Bucket (86oz)', 1, '2022-09-04 19:08:53'),
	(300, 'XL64', 'Bucket Lid', 1, '2022-09-04 19:09:20'),
	(301, 'XCs', 'Printed Sundae Cup', 1, '2022-09-04 19:09:59'),
	(302, 'ssm', 'Ralphs Vanilla 10% Mix', 1, '2022-09-04 19:10:27'),
	(303, 'ssmc', 'Ralphs 10% Chocolate mix', 1, '2022-09-04 19:11:04'),
	(304, 'XCr', 'Paper Product Credit', 1, '2022-09-04 19:11:31');

-- Dumping structure for table purchase_order_db.order_items
CREATE TABLE IF NOT EXISTS `order_items` (
  `po_id` int(30) NOT NULL,
  `item_id` int(11) NOT NULL,
  `quantity` float NOT NULL,
  `description` longblob DEFAULT NULL,
  KEY `po_id` (`po_id`),
  KEY `item_no` (`item_id`),
  CONSTRAINT `order_items_ibfk_1` FOREIGN KEY (`item_id`) REFERENCES `item_list` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  CONSTRAINT `order_items_ibfk_2` FOREIGN KEY (`po_id`) REFERENCES `po_list` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- Dumping data for table purchase_order_db.order_items: ~11 rows (approximately)
REPLACE INTO `order_items` (`po_id`, `item_id`, `quantity`, `description`) VALUES
	(13, 234, 2, _binary 0x457370726573736f204368697073),
	(13, 240, 4, _binary 0x323031312050726f6d6f74696f6e616c20437265646974),
	(13, 259, 6, _binary 0x43616e6e6f6c6920466c61766f72),
	(13, 269, 8, _binary 0x42726f6b656e20436f6f6b6965205069656365732028426f7829),
	(14, 288, 10, _binary 0x446f6d65204c696420442d20393820666f7220386f7a2f31326f7a2f53756e646165),
	(14, 289, 10, _binary 0x5061706572205072696e742f517561727420442d20313138),
	(14, 294, 2, _binary 0x31326f7a204c6172676520492e432e20437570),
	(14, 298, 2, _binary 0x46756e204275636b6574202836346f7a29),
	(14, 299, 2, _binary 0x5061727479204275636b6574202838366f7a29),
	(14, 300, 3, _binary 0x4275636b6574204c6964),
	(14, 301, 4, _binary 0x5072696e7465642053756e64616520437570);

-- Dumping structure for table purchase_order_db.po_list
CREATE TABLE IF NOT EXISTS `po_list` (
  `id` int(30) NOT NULL AUTO_INCREMENT,
  `po_no` varchar(100) NOT NULL,
  `supplier_id` int(30) DEFAULT NULL,
  `date_created` datetime NOT NULL DEFAULT current_timestamp(),
  `date_updated` datetime DEFAULT NULL ON UPDATE current_timestamp(),
  `user_id` int(11) NOT NULL,
  `ship` tinyint(1) DEFAULT NULL,
  `location` varchar(250) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `supplier_id` (`supplier_id`),
  CONSTRAINT `po_list_ibfk_1` FOREIGN KEY (`supplier_id`) REFERENCES `supplier_list` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4;

-- Dumping data for table purchase_order_db.po_list: ~2 rows (approximately)
REPLACE INTO `po_list` (`id`, `po_no`, `supplier_id`, `date_created`, `date_updated`, `user_id`, `ship`, `location`) VALUES
	(13, 'PO-000013', NULL, '2022-10-13 08:11:43', NULL, 5, 0, 'Marlboro'),
	(14, 'PO-000014', NULL, '2022-10-13 09:40:45', NULL, 5, 0, 'Marlboro');

-- Dumping structure for table purchase_order_db.system_info
CREATE TABLE IF NOT EXISTS `system_info` (
  `id` int(30) NOT NULL AUTO_INCREMENT,
  `meta_field` text NOT NULL,
  `meta_value` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4;

-- Dumping data for table purchase_order_db.system_info: ~8 rows (approximately)
REPLACE INTO `system_info` (`id`, `meta_field`, `meta_value`) VALUES
	(1, 'name', 'Ralph&apos;s Order Entry System'),
	(6, 'short_name', 'Ralph&apos;s-Order Entry'),
	(11, 'logo', 'uploads/1662212520_lemon.gif'),
	(13, 'user_avatar', 'uploads/user_avatar.jpg'),
	(14, 'cover', 'uploads/1631064360_sample_bg.jpg'),
	(15, 'company_name', 'Ralph&apos;s Ices'),
	(16, 'company_email', 'info@ralphsices.com'),
	(17, 'company_address', '501 Port Richmond Ave., Staten island · 10302 · NY · United States.');

-- Dumping structure for table purchase_order_db.users
CREATE TABLE IF NOT EXISTS `users` (
  `id` int(50) NOT NULL AUTO_INCREMENT,
  `firstname` varchar(250) NOT NULL,
  `lastname` varchar(250) DEFAULT NULL,
  `username` text NOT NULL,
  `password` text NOT NULL,
  `avatar` text DEFAULT NULL,
  `last_login` datetime DEFAULT NULL,
  `type` tinyint(1) NOT NULL DEFAULT 1,
  `date_added` datetime NOT NULL DEFAULT current_timestamp(),
  `date_updated` datetime DEFAULT NULL ON UPDATE current_timestamp(),
  `company_address` text NOT NULL,
  `company_email` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=102 DEFAULT CHARSET=utf8mb4;

-- Dumping data for table purchase_order_db.users: ~98 rows (approximately)
REPLACE INTO `users` (`id`, `firstname`, `lastname`, `username`, `password`, `avatar`, `last_login`, `type`, `date_added`, `date_updated`, `company_address`, `company_email`) VALUES
	(1, 'Adminstrator', 'Admin', 'admin', 'e2a874aaa3e1853e4ed6f94f902cf481', 'uploads/1624240500_avatar.png', NULL, 1, '2021-01-20 14:02:37', '2022-09-03 09:33:09', '', ''),
	(5, 'Marlboro', 'john', 'john', '0eb7e1f71974d5e5ae01a801d9395dfb', 'uploads/1662229440_About_but.gif', NULL, 2, '2022-09-03 09:34:50', '2022-10-13 09:38:42', '501 PORT RICHMOND AVE · STATEN ISLAND · 10302 · NY · United States.', 'john.marlboro@test.com'),
	(6, 'Aberdeen', ' ', 'Aberdeen', 'c066bffbb13a31dd9a4ddbcae34ef4ae', 'uploads/1662213720_About_but.gif', NULL, 2, '2022-09-03 09:48:13', '2022-09-03 10:12:36', '', ''),
	(7, 'Asbury Boardwalk', ' ', 'Asbury', '70e5f6707f27662b82e976bd0311a4e3', 'uploads/1662213540_About_but_on.gif', NULL, 2, '2022-09-03 09:53:31', '2022-09-03 09:59:43', '', ''),
	(8, 'Babylon', ' ', 'Babylon', 'b977eaea15987da91afa13670d21af87', 'uploads/1662213660_About_but.gif', NULL, 2, '2022-09-03 09:58:35', '2022-09-03 10:01:02', '', ''),
	(9, 'Bayshore', ' ', 'bayshore', 'c88b2bcaf34dc73ac3908c522e70060b', 'uploads/1662213780_About_but.gif', NULL, 2, '2022-09-03 10:03:09', NULL, '', ''),
	(10, 'Bellmore', ' ', 'bellmore', '0d8ab59a91f5f1918cd0461626ac1b94', 'uploads/1662214320_About_but.gif', NULL, 2, '2022-09-03 10:12:03', NULL, '', ''),
	(11, 'Commack', ' ', 'commack', '2ecf6e984ff5cd8614e10440b916f2c0', 'uploads/1662214440_About_but.gif', NULL, 2, '2022-09-03 10:14:58', NULL, '', ''),
	(12, 'Deer Park', ' ', 'deerpark', '7234d61e8084f6c576bb77d26c68a811', 'uploads/1662222660_About_but.gif', NULL, 2, '2022-09-03 12:30:27', '2022-09-03 12:31:51', '', ''),
	(13, 'Dix Hills', ' ', 'dixhills', 'a1f41319488a2fe52e08b52efafeab82', 'uploads/1662222720_About_but.gif', NULL, 2, '2022-09-03 12:32:44', NULL, '', ''),
	(14, 'East Islip', ' ', 'eastislip', 'a14e3e41f54c449c72b5c5984d23c128', 'uploads/1662222780_About_but.gif', NULL, 2, '2022-09-03 12:33:38', NULL, '', ''),
	(15, 'East Oceanside', ' ', 'eastoceanside', '4dfb5d50c09ea56ad803d2ebcd0a311a', 'uploads/1662222840_About_but.gif', NULL, 2, '2022-09-03 12:34:39', NULL, '', ''),
	(16, 'East Meadow', ' ', 'eastmeadow', 'eaf4c9032f1d3acd6f0128eae83198e4', 'uploads/1662222960_About_but.gif', NULL, 2, '2022-09-03 12:36:52', NULL, '', ''),
	(17, 'Farmindale', ' ', 'farmingdale', '3bd0fde0d1f8d16a66b3011884b0b759', 'uploads/1662223020_About_but.gif', NULL, 2, '2022-09-03 12:37:58', NULL, '', ''),
	(18, 'Farmingville', ' ', 'farmingville', 'c6964f4e9f68053a5d9bdd68f344380d', 'uploads/1662223140_About_but.gif', NULL, 2, '2022-09-03 12:39:16', NULL, '', ''),
	(19, 'Floral Park', ' ', 'floralpark', '4ae02474b0f367eff6b8fc5e3af6abff', 'uploads/1662223200_About_but.gif', NULL, 2, '2022-09-03 12:40:19', NULL, '', ''),
	(20, 'Franklin Square', ' ', 'franklin', 'b2fa6a62ee11f35b0fff844f1961a746', 'uploads/1662223260_About_but.gif', NULL, 2, '2022-09-03 12:41:23', NULL, '', ''),
	(21, 'Freeport', ' ', 'freeport', 'b38f94da0ec2d34ee93dabd300357a1c', 'uploads/1662223320_About_but.gif', NULL, 2, '2022-09-03 12:42:12', NULL, '', ''),
	(22, 'Glenhead', ' ', 'glenhead', '106dc6b5312c8143531abece66d27324', 'uploads/1662223320_About_but.gif', NULL, 2, '2022-09-03 12:42:52', NULL, '', ''),
	(23, 'Green Port', ' ', 'greenport', '0f85bd974bd85513cd67e586cbacbe15', 'uploads/1662223380_About_but.gif', NULL, 2, '2022-09-03 12:43:37', NULL, '', ''),
	(24, 'Hazlet', ' ', 'hazlet', '4c2e1af81203c1ef4d0b8d6732e1df58', 'uploads/1662223440_About_but.gif', NULL, 2, '2022-09-03 12:44:09', NULL, '', ''),
	(25, 'Bay St Ralphs', ' ', 'bayst', '3e1b34b22753492befd8d627da442b19', 'uploads/1662223440_About_but.gif', NULL, 2, '2022-09-03 12:44:55', NULL, '', ''),
	(26, 'Holbrook', ' ', 'holbrook', '9b7fadb9d29423c02ccd9773f1b65b75', 'uploads/1662223500_About_but.gif', NULL, 2, '2022-09-03 12:45:46', NULL, '', ''),
	(27, 'Huntington Village', ' ', 'huntvillage', 'de1ddd67af74501b60cd86cef1f7b363', 'uploads/1662223800_About_but.gif', NULL, 2, '2022-09-03 12:50:21', NULL, '', ''),
	(28, 'Huguenot Ralphs', ' ', 'huguenot', '9daa67d4d0dc57427f42403adbd6a6e2', 'uploads/1662223920_About_but.gif', NULL, 2, '2022-09-03 12:52:10', NULL, '', ''),
	(29, 'Hylan Blvd Ralphs', ' ', 'greatkills', '3e1b34b22753492befd8d627da442b19', 'uploads/1662223980_About_but.gif', NULL, 2, '2022-09-03 12:53:49', NULL, '', ''),
	(30, 'Island Park', ' ', 'islandpark', 'f5db7ac25090ab6fa9d27fe1c4ad8865', 'uploads/1662224040_About_but.gif', NULL, 2, '2022-09-03 12:54:26', NULL, '', ''),
	(31, 'Kings Park', ' ', 'kingspark', '76c2af794b60631e714de70463b11385', 'uploads/1662224100_About_but.gif', NULL, 2, '2022-09-03 12:55:24', NULL, '', ''),
	(32, 'Lake Ronconkama', ' ', 'ronkonkoma', 'b2276009f22d07b6e74a9d39cb7e87eb', 'uploads/1662224160_About_but.gif', NULL, 2, '2022-09-03 12:56:28', NULL, '', ''),
	(33, 'Lanoka Harbor Ralphs', ' ', 'lanoka', 'a3f7b4175eb3c1da2f477685808422a5', 'uploads/1662224220_About_but.gif', NULL, 2, '2022-09-03 12:57:41', NULL, '', ''),
	(34, 'Levittown', ' ', 'levittown', 'deec953a9219da14272e4ca887e1db54', 'uploads/1662224340_About_but.gif', NULL, 2, '2022-09-03 12:59:53', NULL, '', ''),
	(35, 'Lincroft', ' ', 'lincroft', 'aa68e6640a28c852839bb0cd80599133', 'uploads/1662224460_About_but.gif', NULL, 2, '2022-09-03 13:01:03', NULL, '', ''),
	(36, 'Lindenhurst', ' ', 'lindenhurst', '1e508003e20832c1e410b3602de10ed2', 'uploads/1662224580_About_but.gif', NULL, 2, '2022-09-03 13:03:02', NULL, '', ''),
	(37, 'Long Beach', ' ', 'longbeach', '4396380d3dddfce2de1daf22c01859c5', 'uploads/1662224580_About_but.gif', NULL, 2, '2022-09-03 13:03:59', NULL, '', ''),
	(38, 'Massapequa Park', ' ', 'masspark', 'be6b0c62e8a48ffac5a0b54b6df9e476', 'uploads/1662224640_About_but.gif', NULL, 2, '2022-09-03 13:04:57', NULL, '', ''),
	(39, 'Merrick', ' ', 'merrick', '4022b70285e468ff98d01073c52038b8', 'uploads/1662224700_About_but.gif', NULL, 2, '2022-09-03 13:05:36', NULL, '', ''),
	(40, 'Merrick # 2', ' ', 'merrick2', 'f2d2562d4dcbfb6ee03cffa12f6e62de', 'uploads/1662224760_About_but.gif', NULL, 2, '2022-09-03 13:06:15', NULL, '', ''),
	(41, 'Miller Place', ' ', 'millerplace', '36388794be2cf5f298978498ff3c64a2', 'uploads/1662224820_About_but.gif', NULL, 2, '2022-09-03 13:07:02', NULL, '', ''),
	(42, 'Nesconset', ' ', 'nesconset', '63811556284a75073310f511f8bbe65b', 'uploads/1662224820_About_but.gif', NULL, 2, '2022-09-03 13:07:51', NULL, '', ''),
	(43, 'New Dorp Ralphs Store', ' ', 'newdorp', '5ec13aa2858a57bfd80bf4bf8e9b3dfa', 'uploads/1662224940_About_but.gif', NULL, 2, '2022-09-03 13:09:17', NULL, '', ''),
	(44, 'North Babylon', ' ', 'northbabylon', 'a32f0bd4ddcf2376f96d73cb8c54975d', 'uploads/1662225000_About_but.gif', NULL, 2, '2022-09-03 13:10:06', NULL, '', ''),
	(45, 'North Massapequa', ' ', 'northmass', '2774e98b9307c8fac411689714243fb6', 'uploads/1662225060_About_but.gif', NULL, 2, '2022-09-03 13:11:19', NULL, '', ''),
	(46, 'East Northport', ' ', 'enorthport', 'b1f2c8d267732be2a24d7a6908c9400f', 'uploads/1662225060_About_but.gif', NULL, 2, '2022-09-03 13:11:57', NULL, '', ''),
	(47, 'Oceanside', ' ', 'Oceanside', 'a184897c89e41eb366f2e56cc04ede23', 'uploads/1662225360_About_but.gif', NULL, 2, '2022-09-03 13:16:39', NULL, '', ''),
	(48, 'Old Bridge Ralphs', ' ', 'oldbridge', 'abe9c8e3897536e7ce8fee70f89157a1', 'uploads/1662225480_About_but.gif', NULL, 2, '2022-09-03 13:18:28', NULL, '', ''),
	(49, 'Oyster Bay', ' ', 'oysterbay', 'b4344a1140c2b6c4063415c6c4304423', 'uploads/1662225540_About_but.gif', NULL, 2, '2022-09-03 13:19:28', NULL, '', ''),
	(50, 'Patchouge', ' ', 'patchouge', '3cbf5f69c4c2b1ea02de993e764bab38', 'uploads/1662225600_About_but.gif', NULL, 2, '2022-09-03 13:20:16', NULL, '', ''),
	(51, 'Plainview', ' ', 'plainview', '9057665d8500d48d8255384844ae5015', 'uploads/1662225660_About_but.gif', NULL, 2, '2022-09-03 13:21:18', NULL, '', ''),
	(52, 'Port Jefferson', ' ', 'portjeff', 'b2e831d5002a31a0b48b66f463249eea', 'uploads/1662225720_About_but.gif', NULL, 2, '2022-09-03 13:22:02', NULL, '', ''),
	(53, 'Port Washington', ' ', 'portwashington', '6fcc4b7d36184ba33346b4be2d5d8244', 'uploads/1662225720_About_but.gif', NULL, 2, '2022-09-03 13:22:59', NULL, '', ''),
	(54, 'Rockville Center', ' ', 'rockville', 'f9b6fe2af26d67de4a835dfabcc889d0', 'uploads/1662225780_About_but.gif', NULL, 2, '2022-09-03 13:23:38', NULL, '', ''),
	(55, 'Sayville', ' ', 'sayville', '0a1e99d06e5d44850fdbb558912dec64', 'uploads/1662225840_About_but.gif', NULL, 2, '2022-09-03 13:24:37', NULL, '', ''),
	(56, 'Seaford', ' ', 'seaford', '4d1e515049e5a3eba4e0ea8f55453d5e', 'uploads/1662225900_About_but.gif', NULL, 2, '2022-09-03 13:25:13', NULL, '', ''),
	(57, 'Shirly', ' ', 'shirly', 'ea3b841e2c5261e79a5b99e32cef9a58', 'uploads/1662225900_About_but.gif', NULL, 2, '2022-09-03 13:25:52', NULL, '', ''),
	(58, 'Smithtown', ' ', 'smithtown', '9eb3e4a8cafc6c590939f58ae20886d7', 'uploads/1662225960_About_but.gif', NULL, 2, '2022-09-03 13:26:36', NULL, '', ''),
	(59, 'South Shore Ralphs', ' ', 'southshore', 'bd8b7d978caf2eceb560573d95599eab', 'uploads/1662226020_About_but.gif', NULL, 2, '2022-09-03 13:27:30', NULL, '', ''),
	(60, 'Spotswood', ' ', 'spotswood', 'b25f86f9565313d61f14f98a6d301b20', 'uploads/1662226080_About_but.gif', NULL, 2, '2022-09-03 13:28:21', NULL, '', ''),
	(61, 'Stoneybrook', ' ', ' stoneybrook', 'c0b78ab4c8b5b1545bda1ccb1f524ae5', 'uploads/1662226140_About_but.gif', NULL, 2, '2022-09-03 13:29:34', NULL, '', ''),
	(62, 'Syosset', ' ', 'syosset', '23c312e152f3b69df44975cf77bdc0ac', 'uploads/1662226200_About_but.gif', NULL, 2, '2022-09-03 13:30:30', NULL, '', ''),
	(63, 'Toms River', ' ', 'tomsriver', 'ef7de3f485174ff47f061ad27d83d0ee', 'uploads/1662226260_About_but.gif', NULL, 2, '2022-09-03 13:31:17', NULL, '', ''),
	(64, 'Uniondale', ' ', 'uniondale', 'e6ca54f0dfb0b4ca02c226a14b130d10', 'uploads/1662226980_About_but.gif', NULL, 2, '2022-09-03 13:43:06', NULL, '', ''),
	(65, 'Valley Stream', ' ', 'valleystream', '6aaf72567f40821202cd8b46ec964409', 'uploads/1662227040_About_but.gif', NULL, 2, '2022-09-03 13:44:05', NULL, '', ''),
	(66, 'West Babylon', ' ', 'westbabylon', 'b387ea322ab7dd52d5a0401931e1c108', 'uploads/1662227100_About_but.gif', NULL, 2, '2022-09-03 13:45:09', NULL, '', ''),
	(67, 'Westbury', ' ', 'westbury', 'dd3b0331b09e8ad2c75cd48c0d572dbc', 'uploads/1662227160_About_but.gif', NULL, 2, '2022-09-03 13:46:06', NULL, '', ''),
	(68, 'Whitestone', ' ', 'whitestone', 'fd180b0de52760d5247bef08bff1a89e', 'uploads/1662227160_About_but.gif', NULL, 2, '2022-09-03 13:46:53', NULL, '', ''),
	(69, 'Williston Park', ' ', 'willistonpark', '532d7dbec50908811750859a380355d8', 'uploads/1662227220_About_but.gif', NULL, 2, '2022-09-03 13:47:39', NULL, '', ''),
	(70, 'Greenridge', ' ', 'greenridge', '455b52a355ea66351e7d343c7776a867', 'uploads/1662227280_About_but.gif', NULL, 2, '2022-09-03 13:48:21', NULL, '', ''),
	(71, 'Melville', ' ', 'melville', 'bbca0134a4bc379f17fe07c451cd09b0', 'uploads/1662227340_About_but.gif', NULL, 2, '2022-09-03 13:49:24', NULL, '', ''),
	(72, 'Asbury', ' ', 'cookma', '36dbbfc0d798d24d4d38b9aa97c6bac4', 'uploads/1662227400_About_but.gif', NULL, 2, '2022-09-03 13:50:14', NULL, '', ''),
	(73, 'Middle Village', ' ', 'middlevillage', '4a548addbfb239bbd12f5afe11a4b6dc', 'uploads/1662227400_About_but.gif', NULL, 2, '2022-09-03 13:50:49', NULL, '', ''),
	(74, 'kenilworth', ' ', 'kenilworth', '4073c033483edef98c0c6e3783a7d5c2', 'uploads/1662227460_About_but.gif', NULL, 2, '2022-09-03 13:51:46', NULL, '', ''),
	(75, 'glen cove', ' ', 'GLENCOVE', '5466deeeb99004f8b3e381d987122567', 'uploads/1662227520_About_but.gif', NULL, 2, '2022-09-03 13:52:27', NULL, '', ''),
	(76, 'Coram', ' ', 'coram', '36388794be2cf5f298978498ff3c64a2', 'uploads/1662227580_About_but.gif', NULL, 2, '2022-09-03 13:53:01', NULL, '', ''),
	(77, 'selden', ' ', 'selden', '28cb413c64b7e30ec34dc79a0f407366', 'uploads/1662227580_About_but.gif', NULL, 2, '2022-09-03 13:53:42', NULL, '', ''),
	(78, 'riverhead', ' ', 'riverhead', 'b2e831d5002a31a0b48b66f463249eea', 'uploads/1662227640_About_but.gif', NULL, 2, '2022-09-03 13:54:32', NULL, '', ''),
	(79, 'Northport 2', ' ', 'Northport', '14b6e37dcecb384cbc8769195c7a12e1', 'uploads/1662227700_About_but.gif', NULL, 2, '2022-09-03 13:55:41', NULL, '', ''),
	(80, 'Long Beach 2', ' ', 'longbeach2', '7eacec682c2fb9f8c81287a825274bb8', 'uploads/1662227760_About_but.gif', NULL, 2, '2022-09-03 13:56:23', NULL, '', ''),
	(81, 'Wading River', ' ', 'wadingriver', '0f5520e286068354bce303a1627cdefc', 'uploads/1662227820_About_but.gif', NULL, 2, '2022-09-03 13:57:26', NULL, '', ''),
	(82, 'Gosh Darn', ' ', 'goshdarn', '6365ffc7b39154d75ba8df520da25e6c', 'uploads/1662227880_About_but.gif', NULL, 2, '2022-09-03 13:58:15', NULL, '', ''),
	(83, 'Great Neck', ' ', 'greatneck', '89c5c30498c2989611f9044be006197c', 'uploads/1662227880_About_but.gif', NULL, 2, '2022-09-03 13:58:55', NULL, '', ''),
	(84, 'Shirley 990', ' ', 'shirley990', 'ef2afe0ea76c76b6b4b1ee92864c4d5c', 'uploads/1662228000_About_but.gif', NULL, 2, '2022-09-03 14:00:16', NULL, '', ''),
	(85, 'mamaroneck', ' ', 'mamaroneck', 'fcf407de4e149e51ececc985ca20f747', 'uploads/1662228060_About_but.gif', NULL, 2, '2022-09-03 14:01:03', NULL, '', ''),
	(86, 'Montauk', ' ', 'montauk', '602573e81c08583d8bd589695faf798d', 'uploads/1662228120_About_but.gif', NULL, 2, '2022-09-03 14:02:02', NULL, '', ''),
	(87, 'wesley chapel', ' ', 'wesley chapel', '814791b5bcc3221f00052ff78bd71c3d', 'uploads/1662228180_About_but.gif', NULL, 2, '2022-09-03 14:03:14', NULL, '', ''),
	(88, 'white plains', ' ', 'whitplains', '740237728e8c6c4e016445516148454e', 'uploads/1662228240_About_but.gif', NULL, 2, '2022-09-03 14:04:02', NULL, '', ''),
	(89, 'Hightstown', ' ', 'hightstown', '608c857e36ee0e77f131c9b859254bce', 'uploads/1662228300_About_but.gif', NULL, 2, '2022-09-03 14:05:04', NULL, '', ''),
	(90, 'yonkers', ' ', 'yonkers', '860f6052e33940d7b05a3cb79e817ef7', 'uploads/1662228300_About_but.gif', NULL, 2, '2022-09-03 14:05:42', NULL, '', ''),
	(91, 'NYC Ralphs', ' ', 'NYC', '30ee7643d71343b938c3089c6409363f', 'uploads/1662228360_About_but.gif', NULL, 2, '2022-09-03 14:06:29', NULL, '', ''),
	(92, 'NYC-2', ' ', 'nyc2', '5beb5fbd6aa7d663ac66e3694b1746ce', 'uploads/1662228420_About_but.gif', NULL, 2, '2022-09-03 14:07:04', NULL, '', ''),
	(93, 'stamford', ' ', 'stamford', '10877ed42a92ab6a5f8bdd452de60818', 'uploads/1662228420_About_but.gif', NULL, 2, '2022-09-03 14:07:49', NULL, '', ''),
	(94, 'Hasbrouck', ' ', 'hasbrouck', '87dc66e21fb410d909029a9f1ad57d52', 'uploads/1662228480_About_but.gif', NULL, 2, '2022-09-03 14:08:26', NULL, '', ''),
	(95, 'Westfield', ' ', 'westfield', 'c066dd182b15f86dd200d4dfde289d91', 'uploads/1662228540_About_but.gif', NULL, 2, '2022-09-03 14:09:06', NULL, '', ''),
	(96, 'nyc3', ' ', 'nyc3', '3e6e2d0b0f90750d407005477b29cf8e', 'uploads/1662228540_About_but.gif', NULL, 2, '2022-09-03 14:09:48', NULL, '', ''),
	(97, 'Astoria', ' ', 'Astoria', '42c1c7786562d96f358a7b3640aa35c9', 'uploads/1662228600_About_but.gif', NULL, 2, '2022-09-03 14:10:51', NULL, '', ''),
	(98, '2nd Ave', ' ', '2ndAve', '298d7d682ec88809bfd07a663854c985', 'uploads/1662228660_About_but.gif', NULL, 2, '2022-09-03 14:11:40', '2022-09-03 14:20:03', '', ''),
	(99, '1st Ave', ' ', '1stAve', '0c3640254f92fadb854bd0ca0fd53b89', 'uploads/1662229020_About_but.gif', NULL, 2, '2022-09-03 14:17:40', NULL, '', ''),
	(100, 'Ave A', ' ', 'avea', 'bc54c0e16cb550d28fa77a48e8f55a3f', 'uploads/1662229080_About_but.gif', NULL, 2, '2022-09-03 14:18:19', NULL, '', ''),
	(101, 'JCherchio', ' ', 'JCherchio', '58f228a54bdb2412158ef2ef4def7ade', 'uploads/1662229500_1960.gif', NULL, 1, '2022-09-03 14:25:37', NULL, '', '');

