-- --------------------------------------------------------
-- 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.');

