-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `salonbestmobilea_pizzasite`
--

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

--
-- Table structure for table `add_to_carts`
--

CREATE TABLE `add_to_carts` (
  `id` bigint UNSIGNED NOT NULL,
  `product_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `product_price` float NOT NULL,
  `wings_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ws_price` float DEFAULT NULL,
  `sauces_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sauce_price` float DEFAULT NULL,
  `crusts_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `crust_price` float DEFAULT NULL,
  `dippings_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dipping_price` float DEFAULT NULL,
  `cookings_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cooking_price` float DEFAULT NULL,
  `size_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `size_price` float DEFAULT NULL,
  `ordernote` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `pqty` float NOT NULL,
  `user_id` int NOT NULL,
  `user_type` enum('Reg','Not-Reg') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `checkouts_id` int DEFAULT NULL,
  `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `category_id` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `add_to_carts`
--

INSERT INTO `add_to_carts` (`id`, `product_name`, `product_price`, `wings_name`, `ws_price`, `sauces_name`, `sauce_price`, `crusts_name`, `crust_price`, `dippings_name`, `dipping_price`, `cookings_name`, `cooking_price`, `size_name`, `size_price`, `ordernote`, `pqty`, `user_id`, `user_type`, `checkouts_id`, `status`, `category_id`, `created_at`, `updated_at`) VALUES
(1, 'The Works', 0, 'Mild', 2, 'White Garlic Sauce', 2, 'Thin', 20, 'Chedder Chipottle Dip', 10, 'Lightlydone', 5, 'Small(4slice)', 13.99, 'hhu', 1, 3, 'Reg', NULL, NULL, 2, '2022-09-21 02:44:03', '2022-09-21 02:44:03'),
(2, 'Large Pizza with 3 Toppings', 20.95, 'Mild', 2, 'In House Pizza Sauce', 50, 'Thin', 20, 'Pizza Sauce', 10.11, 'Lightlydone', 5, NULL, NULL, 'sd', 1, 360819474, 'Not-Reg', NULL, NULL, 1, '2022-09-21 19:29:20', '2022-09-21 19:29:20'),
(4, 'Salami and Cheese', 11, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 737322781, 'Not-Reg', NULL, NULL, 8, '2022-10-05 18:43:25', '2022-10-05 18:43:25'),
(5, 'Dip Fried Panzerotti', 5, 'Mild', 2, 'White Garlic Sauce', 2, 'Regular', 11, 'Pizza Sauce', 10.11, 'Lightlydone', 5, NULL, NULL, NULL, 3, 777814790, 'Not-Reg', NULL, NULL, 6, '2022-10-06 08:35:16', '2022-10-06 08:35:16'),
(6, 'Party Pizza with 3 Toppings & 3lbs of Wings', 44.95, NULL, NULL, 'In House Pizza Sauce', 50, 'Regular', 11, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 473057792, 'Not-Reg', NULL, NULL, 1, '2022-10-22 16:20:17', '2022-10-22 16:20:17'),
(7, 'Large Order (3lbs)', 29.99, NULL, NULL, 'In House Pizza Sauce', 50, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'rgr', 2, 636450577, 'Not-Reg', NULL, NULL, 5, '2022-10-31 04:36:11', '2022-10-31 04:36:11'),
(8, 'Large Pizza with 3 Toppings', 20.95, 'Mild', 2, 'In House Pizza Sauce', 50, 'Thin', 20, 'Pizza Sauce', 10.11, 'Regular', 15, NULL, NULL, 'ok', 1, 530132440, 'Not-Reg', NULL, NULL, 1, '2022-11-17 02:09:31', '2022-11-17 02:09:31'),
(9, 'Medium Order (2lbs)', 21.99, NULL, NULL, 'In House Pizza Sauce', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 675423803, 'Not-Reg', NULL, NULL, 5, '2023-01-17 11:20:07', '2023-01-17 11:20:07'),
(10, 'Party Pizza with 3 Toppings & 3lbs of Wings', 44.95, NULL, NULL, 'In House Pizza Sauce', 0, 'Thin', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 497645884, 'Not-Reg', NULL, NULL, 1, '2023-01-18 05:31:33', '2023-01-18 05:31:33');

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

--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `id` bigint UNSIGNED NOT NULL,
  `category` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `category_slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `categories`
--

INSERT INTO `categories` (`id`, `category`, `category_slug`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Combos', 'Combos', 1, '2022-09-17 05:14:51', '2022-11-17 01:56:43'),
(2, 'Specialty Pizza', 'Specialty Pizza', 1, '2022-09-17 05:15:33', '2022-09-17 05:15:33'),
(3, 'Specialty Subs', 'Specialty Subs', 1, '2022-09-17 05:15:49', '2022-09-17 05:15:49'),
(4, 'Make Your Own Pizza', 'Make Your Own Pizza', 1, '2022-09-17 05:32:00', '2022-09-17 05:32:00'),
(5, 'Wings', 'Wings', 1, '2022-09-17 05:32:16', '2022-09-17 05:32:16'),
(6, 'Panzarotti', 'Panzarotti', 1, '2022-09-17 05:33:20', '2022-09-17 05:33:20'),
(7, 'Hot Subs', 'Hot Subs', 1, '2022-09-17 05:33:50', '2022-09-17 05:33:50'),
(8, 'Cold Subs', 'Cold Subs', 1, '2022-09-17 05:34:09', '2022-09-17 05:34:09'),
(9, 'Appetizers', 'Appetizers', 1, '2022-09-17 05:35:17', '2022-09-17 05:35:17'),
(10, 'Salad & Other', 'Salad & Other', 1, '2022-09-17 05:36:35', '2022-09-17 05:36:35'),
(11, 'Drinks', 'Drinks', 1, '2022-09-17 05:36:59', '2022-09-17 05:36:59');

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

--
-- Table structure for table `checkouts`
--

CREATE TABLE `checkouts` (
  `id` bigint UNSIGNED NOT NULL,
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `fname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `lname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `street` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `appertment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `zipcode` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `delivered_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `payment_types` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `total_price` float DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `checkouts`
--

INSERT INTO `checkouts` (`id`, `email`, `phone`, `fname`, `lname`, `street`, `appertment`, `zipcode`, `note`, `user_id`, `delivered_type`, `payment_types`, `total_price`, `created_at`, `updated_at`) VALUES
(1, 'tripathidivyanshu1234@gmail.com', '6352507987', 'Tripathi', 'Divyanshu', '802 Wall Street I Opp Orient Club', 'ah', '88', 'it', '1', 'delivered', 'cod', NULL, '2022-09-07 06:39:51', '2022-09-07 06:39:51'),
(2, 'tripathidivyanshu1234@gmail.com', '6352507987', 'Tripathi', 'Divyanshu', '802 Wall Street I Opp Orient Club', 'ah', '88', 'it', '1', 'delivered', 'cod', NULL, '2022-09-07 06:40:21', '2022-09-07 06:40:21'),
(3, 'tripathidivyanshu1234@gmail.com', '6352507987', 'Tripathi', 'Divyanshu', '802 Wall Street I Opp Orient Club', 'ah', '88', 'it', '1', 'delivered', 'cod', NULL, '2022-09-07 06:42:24', '2022-09-07 06:42:24'),
(4, 'tyivyanshu1234@gmail.com', '9969584751', 'Shakil', 'khan', 'success  Opp Orient Club', 'Ahmedabad', '968574', 'Software Development', '2', 'delivered', 'cod', 156.51, '2022-09-08 03:19:53', '2022-09-08 03:19:53');

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

--
-- Table structure for table `cookings`
--

CREATE TABLE `cookings` (
  `id` bigint UNSIGNED NOT NULL,
  `cooking` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `cooking_price` float NOT NULL,
  `status` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cookings`
--

INSERT INTO `cookings` (`id`, `cooking`, `cooking_price`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Regular', 0, 1, '2022-07-26 06:54:39', '2022-11-21 23:23:55'),
(2, 'Welldone', 0, 1, '2022-07-26 06:55:01', '2022-11-21 23:23:49'),
(3, 'Lightlydone', 0, 1, '2022-07-26 06:55:10', '2022-11-21 23:24:02');

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

--
-- Table structure for table `coupons`
--

CREATE TABLE `coupons` (
  `id` bigint UNSIGNED NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `coupons`
--

INSERT INTO `coupons` (`id`, `title`, `code`, `value`, `status`, `created_at`, `updated_at`) VALUES
(1, 'first', 'first', '10000', 1, '2022-07-04 05:22:46', '2022-07-06 06:15:18'),
(3, 'tt', 'ttt', '50444', 1, '2022-07-06 00:13:51', '2022-07-06 00:25:34');

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

--
-- Table structure for table `crusts`
--

CREATE TABLE `crusts` (
  `id` bigint UNSIGNED NOT NULL,
  `crust` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `crust_price` float NOT NULL,
  `status` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `crusts`
--

INSERT INTO `crusts` (`id`, `crust`, `crust_price`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Thin', 0, 1, '2022-07-26 06:51:01', '2022-11-21 23:23:28'),
(2, 'Regular', 0, 1, '2022-07-26 06:51:11', '2022-11-21 23:23:35');

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

--
-- Table structure for table `dippings`
--

CREATE TABLE `dippings` (
  `id` bigint UNSIGNED NOT NULL,
  `dipping` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `dipping_price` float NOT NULL,
  `status` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `dippings`
--

INSERT INTO `dippings` (`id`, `dipping`, `dipping_price`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Pizza Sauce', 1.5, 1, '2022-07-22 01:45:21', '2022-11-21 23:19:53'),
(2, 'Garlic Dip', 1.5, 1, '2022-07-26 07:10:02', '2022-11-21 23:20:02'),
(3, 'Ranch Dip', 1.5, 1, '2022-07-26 07:11:23', '2022-11-21 23:20:10'),
(4, 'Chedder Chipottle Dip', 1.5, 1, '2022-07-26 07:11:45', '2022-11-21 23:20:17'),
(5, 'Blue Cheese', 1.5, 1, '2022-07-26 07:11:54', '2022-11-21 23:20:25');

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

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint UNSIGNED NOT NULL,
  `uuid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `insert_toppings`
--

CREATE TABLE `insert_toppings` (
  `id` bigint UNSIGNED NOT NULL,
  `toppings_left_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `toppings_left_id` float DEFAULT NULL,
  `toppings_center_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `toppings_center_id` float DEFAULT NULL,
  `toppings_right_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `toppings_right_id` float DEFAULT NULL,
  `toppingsqty` float DEFAULT NULL,
  `pretoppings_left_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pretoppings_left_id` float DEFAULT NULL,
  `pretoppings_center_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pretoppings_center_id` float DEFAULT NULL,
  `pretoppings_right_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pretoppings_right_id` float DEFAULT NULL,
  `pretoppingsqty` float DEFAULT NULL,
  `add_to_cart_id` int NOT NULL,
  `status` float DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `insert_toppings`
--

INSERT INTO `insert_toppings` (`id`, `toppings_left_name`, `toppings_left_id`, `toppings_center_name`, `toppings_center_id`, `toppings_right_name`, `toppings_right_id`, `toppingsqty`, `pretoppings_left_name`, `pretoppings_left_id`, `pretoppings_center_name`, `pretoppings_center_id`, `pretoppings_right_name`, `pretoppings_right_id`, `pretoppingsqty`, `add_to_cart_id`, `status`, `created_at`, `updated_at`) VALUES
(5, NULL, NULL, 'Extra Cheese', 1, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 5, 1, NULL, NULL),
(6, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Chicken', 2, NULL, NULL, 1, 5, 2, NULL, NULL),
(7, 'Extra Cheese', 0.5, 'Extra Cheese', 1, 'Extra Cheese', 0.5, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 6, 1, NULL, NULL),
(8, 'Pepperoni', 0.5, NULL, NULL, 'Pepperoni', 0.5, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 6, 0.5, NULL, NULL),
(9, NULL, NULL, 'Extra Cheese', 1, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 8, 1, NULL, NULL),
(10, NULL, NULL, 'Pepperoni', 1, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 8, 1, NULL, NULL),
(11, NULL, NULL, 'Mushrooms', 1, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 8, 1, NULL, NULL),
(12, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Chicken', 2, NULL, NULL, 1, 8, 2, NULL, NULL),
(13, 'Extra Cheese', 0.5, 'Extra Cheese', 1, 'Extra Cheese', 0.5, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 10, 1, '2023-01-18 05:31:33', '2023-01-18 05:31:33'),
(14, 'Pepperoni', 0.5, 'Pepperoni', 1, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 10, 1, '2023-01-18 05:31:33', '2023-01-18 05:31:33'),
(15, NULL, NULL, 'Onion', 1, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 10, 1, '2023-01-18 05:31:33', '2023-01-18 05:31:33');

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

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int UNSIGNED NOT NULL,
  `migration` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(10, '2022_06_16_084449_create_custregister_table', 1),
(25, '2014_10_12_000000_create_users_table', 2),
(26, '2014_10_12_100000_create_password_resets_table', 2),
(27, '2019_08_19_000000_create_failed_jobs_table', 2),
(28, '2019_12_14_000001_create_personal_access_tokens_table', 2),
(29, '2022_06_16_122628_create_custregisters_table', 2),
(30, '2022_06_21_100135_create_admins_table', 2),
(31, '2022_06_23_054441_create_categories_table', 2),
(32, '2022_07_04_070616_create_coupons_table', 3),
(33, '2022_07_06_092603_create_sizes_table', 4),
(34, '2022_07_06_114843_create_products_table', 5),
(57, '2022_07_20_123739_create_toppings_table', 6),
(58, '2022_07_20_134653_create_sauces_table', 6),
(59, '2022_07_21_055824_create_crusts_table', 6),
(60, '2022_07_21_065625_create_cookings_table', 6),
(61, '2022_07_21_101707_create_wings_table', 6),
(62, '2022_07_21_120034_create_dippings_table', 6),
(63, '2022_08_15_095121_create_add_to_cart_table', 7),
(64, '2022_08_15_113409_create_insert_toppings_table', 8),
(65, '2022_08_17_080150_create_checkouts_table', 9),
(66, '2022_08_24_151323_create_order_toppings_completes_table', 10),
(67, '2022_09_18_104717_create_pretoppings_table', 11);

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

--
-- Table structure for table `order_toppings_completes`
--

CREATE TABLE `order_toppings_completes` (
  `id` bigint UNSIGNED NOT NULL,
  `toppings_left_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `toppings_left_id` float DEFAULT NULL,
  `toppings_center_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `toppings_center_id` float DEFAULT NULL,
  `toppings_right_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `toppings_right_id` float DEFAULT NULL,
  `toppingsqty` float DEFAULT NULL,
  `checkout_id` int NOT NULL,
  `product_ckeckout_attrs_id` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `pretoppings`
--

CREATE TABLE `pretoppings` (
  `id` bigint UNSIGNED NOT NULL,
  `toppings` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `toppings_price` double(8,2) NOT NULL,
  `toppings_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pretoppings`
--

INSERT INTO `pretoppings` (`id`, `toppings`, `toppings_price`, `toppings_type`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Chicken', 2.00, 'Small(4slice)', 1, '2022-09-18 05:25:10', '2022-09-20 03:24:10'),
(2, 'Feta Cheese', 2.00, 'Small(4slice)', 1, '2022-09-18 05:25:30', '2022-09-20 03:24:16'),
(3, 'Sun dried Tomatoes', 2.00, 'Small(4slice)', 1, '2022-09-18 05:25:39', '2022-09-20 03:24:21'),
(4, 'Butter Chicken', 2.00, 'Small(4slice)', 1, '2022-09-18 05:25:48', '2022-09-20 03:24:26'),
(5, 'Bacon Strips', 2.00, 'Small(4slice)', 1, '2022-09-18 05:27:05', '2022-09-20 03:24:31'),
(6, 'Chicken', 4.00, 'Medium(8slice)', 1, '2022-09-20 03:25:01', '2022-09-20 03:25:01'),
(7, 'Feta Cheese', 4.00, 'Medium(8slice)', 1, '2022-09-20 03:25:14', '2022-09-20 03:25:14'),
(8, 'Sun dried Tomatoes', 4.00, 'Medium(8slice)', 1, '2022-09-20 03:25:27', '2022-09-20 03:25:27'),
(9, 'Butter Chicken', 4.00, 'Medium(8slice)', 1, '2022-09-20 03:25:46', '2022-09-20 03:25:46'),
(10, 'Bacon Strips', 4.00, 'Medium(8slice)', 1, '2022-09-20 03:25:57', '2022-09-20 03:25:57'),
(11, 'Chicken', 5.50, 'Small(4slice)', 1, '2022-09-20 03:26:18', '2022-11-21 23:26:14'),
(12, 'Feta Cheese', 5.50, 'Large(12slice)', 1, '2022-09-20 03:26:34', '2022-11-21 23:26:52'),
(13, 'Sun dried Tomatoes', 5.50, 'Large(12slice)', 1, '2022-09-20 03:26:56', '2022-11-21 23:27:09'),
(14, 'Butter Chicken', 5.50, 'Large(12slice)', 1, '2022-09-20 03:27:07', '2022-11-21 23:27:22'),
(15, 'Bacon Strips', 5.50, 'Small(4slice)', 1, '2022-09-20 03:27:17', '2022-11-21 23:27:36'),
(16, 'Chicken', 6.50, 'Party(24slice)', 1, '2022-09-20 03:27:41', '2022-09-20 03:27:41'),
(17, 'Feta Cheese', 6.50, 'Party(24slice)', 1, '2022-09-20 03:27:52', '2022-09-20 03:27:52'),
(18, 'Sun dried Tomatoes', 6.50, 'Party(24slice)', 1, '2022-09-20 03:28:06', '2022-09-20 03:28:06'),
(19, 'Butter Chicken', 6.50, 'Party(24slice)', 1, '2022-09-20 03:28:28', '2022-09-20 03:28:28'),
(20, 'Bacon Strips', 6.50, 'Party(24slice)', 1, '2022-09-20 03:28:43', '2022-09-20 03:28:43');

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

--
-- Table structure for table `products`
--

CREATE TABLE `products` (
  `id` bigint UNSIGNED NOT NULL,
  `category_id` int NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `product_price` float NOT NULL,
  `short_desc` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `desc` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `products`
--

INSERT INTO `products` (`id`, `category_id`, `name`, `image`, `slug`, `product_price`, `short_desc`, `desc`, `status`, `created_at`, `updated_at`) VALUES
(1, 2, 'The Works', '1663423137.jpg', 'the_works', 13.99, 'Tomato sauce, mozzarella cheese, pepperoni,  mushrooms, bacon, onions, green peppers, green olives,  and hot peppers', 'Tomato sauce, mozzarella cheese, pepperoni,  mushrooms, bacon, onions, green peppers, green olives,  and hot peppers', 1, '2022-09-17 08:28:58', '2022-11-17 02:00:02'),
(2, 3, 'Fat bastard steak sub', '1663466516.jpg', 'Fat_bastard_steak_sub', 14.99, 'Fat bastard steak sub', 'Fat bastard steak sub', 1, '2022-09-17 20:31:56', '2022-09-18 01:27:40'),
(3, 2, 'Meat Hater’s', '1663470976.jpg', 'Meat _Hater’s', 13.99, 'Tomato sauce, mozzarella cheese, onion, mushrooms,  green peppers, green and black olives, hot peppers,  sliced tomatoes, and pineapple', 'Tomato sauce, mozzarella cheese, onion, mushrooms,  green peppers, green and black olives, hot peppers,  sliced tomatoes, and pineapple', 1, '2022-09-17 21:46:16', '2022-09-17 21:46:16'),
(4, 2, 'Meat Lover’s', '1663471043.jpg', 'Meat_Lover’s', 13.99, 'Tomato sauce, mozzarella cheese, pepperoni, bacon,  salami, ham, ground beef, and hot sausage', 'Tomato sauce, mozzarella cheese, pepperoni, bacon,  salami, ham, ground beef, and hot sausage', 1, '2022-09-17 21:47:23', '2022-09-17 21:47:23'),
(5, 2, 'Chicken Club', '1663471091.jpg', 'Chicken _Club', 13.99, 'Garlic sauce, mozzarella cheese, red onion, fresh sliced tomatoes, bacon, and grilled chicken', 'Garlic sauce, mozzarella cheese, red onion, fresh sliced tomatoes, bacon, and grilled chicken', 1, '2022-09-17 21:48:11', '2022-09-17 21:48:11'),
(6, 2, 'Butter Chicken', '1663471136.jpg', 'Butter_Chicken', 13.99, 'Butter chicken sauce, mozzarella cheese, marinated  grilled chicken, red onion, green pepper and hot pepper', 'Butter chicken sauce, mozzarella cheese, marinated  grilled chicken, red onion, green pepper and hot pepper', 1, '2022-09-17 21:48:57', '2022-09-17 21:48:57'),
(7, 8, 'Capicola and Cheese', '1663482571.jpg', 'Capicola_and_cheese', 11, 'All cold subs include shredded lettuce, onions, tomatoes, mayo,  and sub sauce', 'Capicola , cheese , lettuce , tomato, onion , mayo, sub sauce', 1, '2022-09-18 00:59:31', '2022-12-07 16:43:30'),
(8, 8, 'Salami and Cheese', '1663482612.jpg', 'Salami_and_Cheese', 11, 'All cold subs include shredded lettuce, onions, tomatoes, mayo,  and sub sauce', 'All cold subs include shredded lettuce, onions, tomatoes, mayo,  and sub sauce', 1, '2022-09-18 01:00:12', '2022-09-18 01:02:34'),
(9, 8, 'Assorted', '1663482641.jpg', 'Assorted', 11, 'All cold subs include shredded lettuce, onions, tomatoes, mayo,  and sub sauce', 'All cold subs include shredded lettuce, onions, tomatoes, mayo,  and sub sauce', 1, '2022-09-18 01:00:41', '2022-09-18 01:02:22'),
(10, 8, 'Ham and Cheese', '1663482678.jpg', 'Ham_and_Cheese', 11, 'All cold subs include shredded lettuce, onions, tomatoes, mayo,  and sub sauce', 'All cold subs include shredded lettuce, onions, tomatoes, mayo,  and sub sauce', 1, '2022-09-18 01:01:18', '2022-09-18 01:02:01'),
(11, 7, 'Vegetarian', '1663482812.jpg', 'Vegetarian', 10.5, 'Mushroom, olives , onion, green papers , mayo, sub sauce.', 'Mix all veggies toasted. Latus and tomato', 1, '2022-09-18 01:03:32', '2022-12-07 17:01:07'),
(12, 7, 'Pizza', '1663482845.jpg', 'Pizza', 11.5, 'Served with red sauce OR tomato, lettuce, onion & mayo', 'Served with red sauce OR tomato, lettuce, onion & mayo', 1, '2022-09-18 01:04:05', '2022-09-18 01:04:26'),
(13, 7, 'Roast Beef', '1663482959.jpg', 'Roast_Beef', 11.5, 'Served with red sauce OR tomato, lettuce, onion & mayo', 'Served with red sauce OR tomato, lettuce, onion & mayo', 1, '2022-09-18 01:05:59', '2022-09-18 01:05:59'),
(14, 7, 'Meatball', '1663483156.jpg', 'Meatball', 11.5, 'Served with red sauce OR tomato, lettuce, onion & mayo', 'Served with red sauce OR tomato, lettuce, onion & mayo', 1, '2022-09-18 01:09:16', '2022-09-18 01:09:16'),
(15, 7, 'B.L.T. -N- Cheese', '1663483198.jpg', 'B.L.T. -N- Cheese', 11.5, 'Served with red sauce OR tomato, lettuce, onion & mayo', 'Served with red sauce OR tomato, lettuce, onion & mayo', 1, '2022-09-18 01:09:58', '2022-09-18 01:09:58'),
(16, 7, 'Chicken Club', '1663483241.jpg', 'Chicken_Club', 12.5, 'Served with beacon strips, in house grilled chicken, mayo, sub sauce, onion, cheese  toasted perfectly and topped with latus and tomato', 'Served with beacon strips, in house grilled chicken, mayo, sub sauce, onion, cheese  toasted perfectly and topped with latus and tomato', 1, '2022-09-18 01:10:41', '2023-01-06 08:50:30'),
(17, 7, 'Steak', '1663483288.jpg', 'Steak', 12.5, 'Served with red sauce OR tomato, lettuce, onion & mayo', 'Served with red sauce OR tomato, lettuce, onion & mayo', 1, '2022-09-18 01:11:28', '2022-09-18 01:11:28'),
(18, 7, 'Hot Italian Sausage and Cheese', '1663483328.jpg', 'Hot_Italian_Sausage_and_Cheese', 11.5, 'Served with red sauce OR tomato, lettuce, onion & mayo', 'Served with red sauce OR tomato, lettuce, onion & mayo', 1, '2022-09-18 01:12:08', '2022-09-18 01:12:08'),
(19, 1, 'Large Pizza with 3 Toppings', '1663483476.jpg', 'Large_Pizza_with_3_Toppings', 20.95, 'Blue Cheese and Celery included in all wing combos', 'Blue Cheese and Celery included in all wing combos', 1, '2022-09-18 01:14:36', '2022-09-18 01:14:36'),
(20, 1, 'Party Pizza with 3 Toppings', '1663483545.jpg', 'Party_Pizza_with_3_Toppings', 27.95, 'Blue Cheese and Celery included in all wing combos', 'Blue Cheese and Celery included in all wing combos', 1, '2022-09-18 01:15:45', '2022-09-18 01:15:45'),
(21, 1, 'Medium Pizza with 3 Toppings & 1lb of Wings', '1663483611.jpg', 'Medium_Pizza_with3Toppings&1lbofWings', 26.95, 'Blue Cheese and Celery included in all wing combos', 'Blue Cheese and Celery included in all wing combos', 1, '2022-09-18 01:16:51', '2022-09-18 01:16:51'),
(22, 1, 'Large Pizza with 3 Toppings & 2lbs of Wings', '1663483682.jpg', 'Large_Pizza_with3Toppings&2lbs _ofWings', 34.95, 'Blue Cheese and Celery included in all wing combos', 'Blue Cheese and Celery included in all wing combos', 1, '2022-09-18 01:18:02', '2022-09-18 01:18:02'),
(23, 1, 'Large Pizza with 3 Toppings & 3lbs of Wings', '1663483826.jpg', 'Large_Pizza _with3Toppings&3lbsofWings', 39.95, 'Blue Cheese and Celery included in all wing combos', 'Blue Cheese and Celery included in all wing combos', 1, '2022-09-18 01:20:26', '2022-09-18 01:20:26'),
(24, 1, 'Party Pizza with 3 Toppings & 2lbs of Wings', '1663483887.jpg', 'Party_Pizza_with3Toppings&2lbs_of_Wings .', 39.95, 'Blue Cheese and Celery included in all wing combos', 'Blue Cheese and Celery included in all wing combos', 1, '2022-09-18 01:21:27', '2022-09-18 01:21:27'),
(25, 1, 'Party Pizza with 3 Toppings & 3lbs of Wings', '1663484003.jpg', 'Party_Pizza_with3Toppings_&_3lbs_of_Wings', 44.95, 'Blue Cheese and Celery included in all wing combos', 'Blue Cheese and Celery included in all wing combos', 1, '2022-09-18 01:23:23', '2022-09-18 01:23:23'),
(26, 1, 'Party Pizza with 3 Toppings & 4lbs of Wings', '1663484060.jpg', 'Party_Pizza_with3Toppings&4lbs_of_Wings', 49.95, 'Blue Cheese and Celery included in all wing combos', 'Blue Cheese and Celery included in all wing combos', 1, '2022-09-18 01:24:20', '2022-09-18 01:24:20'),
(27, 3, 'Bad Boy', '1663484346.jpg', 'Bad_Boy', 12.99, 'The Original 1/4 pound of tender rib-eye steak', 'The Original 1/4 pound of tender rib-eye steak', 1, '2022-09-18 01:29:06', '2022-09-18 01:29:06'),
(28, 3, 'Coronary', '1663484392.jpg', 'Coronary', 19.99, 'A whopping 3/4 pound of tender rib-eye steak', 'A whopping 3/4 pound of tender rib-eye steak', 1, '2022-09-18 01:29:52', '2022-09-18 01:29:52'),
(29, 3, 'Titanic', '1663484431.jpg', 'Titanic', 24.99, 'A colossal 1 pound of tender rib-eye steak', 'A colossal 1 pound of tender rib-eye steak', 1, '2022-09-18 01:30:31', '2022-09-18 01:30:31'),
(30, 5, 'Small Order (1lb)', '1663484517.jpg', 'Small_Order_(1lb)', 12.99, 'Celery and blue cheese included', 'Celery and blue cheese included', 1, '2022-09-18 01:31:57', '2022-09-18 01:31:57'),
(31, 5, 'Medium Order (2lbs)', '1663484563.jpg', 'Medium_Order_(2lbs)', 21.99, 'Celery and blue cheese included', 'Celery and blue cheese included', 1, '2022-09-18 01:32:43', '2022-09-18 01:32:43'),
(32, 5, 'Large Order (3lbs)', '1663484611.jpg', 'Large_Order_(3lbs)', 29.99, 'Celery and blue cheese included', 'Celery and blue cheese included', 1, '2022-09-18 01:33:31', '2022-09-18 01:33:31'),
(33, 5, 'X-Large Order (4lbs)', '1663484660.jpg', 'X-Large_Order_(4lbs)', 34.99, 'Celery and blue cheese included', 'Celery and blue cheese included', 1, '2022-09-18 01:34:20', '2022-09-18 01:34:20'),
(34, 5, 'Party Pack (5lbs)', '1663484706.jpg', 'Party_Pack_(5lbs)', 42.99, 'Celery and blue cheese included', 'Celery and blue cheese included', 1, '2022-09-18 01:35:06', '2022-09-18 01:35:06'),
(35, 5, 'Chicken Fingers with fries & plum sauce', '1663484764.jpg', 'Chicken_Fingers_with_fries_&_plum_sauce', 16.95, 'Celery and blue cheese included', 'Celery and blue cheese included', 1, '2022-09-18 01:36:04', '2022-09-18 01:36:04'),
(36, 11, 'Pop (can)', '1663485028.jpg', 'Pop_(can)', 1.5, 'Pop (can)', 'Pop (can)', 1, '2022-09-18 01:40:28', '2022-09-18 01:40:28'),
(37, 11, 'Pop (2L)', '1663485093.jpg', 'Pop_(2L)', 3.5, 'Pop (2L)', 'Pop (2L)', 1, '2022-09-18 01:41:33', '2022-09-18 01:41:33'),
(38, 11, 'Monster', '1663485130.jpg', 'Monster', 3.25, 'Monster', 'Monster', 1, '2022-09-18 01:42:10', '2022-09-18 01:42:10'),
(39, 11, 'Bottled Water', '1663485175.jpg', 'Bottled_Water', 1, 'Bottled Water', 'Bottled Water', 1, '2022-09-18 01:42:55', '2022-09-18 01:42:55'),
(40, 11, 'Beer (341 ml)', '1663485211.jpg', 'Bee_(341 ml)', 4.98, 'Beer (341 ml)', 'Beer (341 ml)', 1, '2022-09-18 01:43:31', '2022-09-18 01:43:31'),
(41, 11, 'Premium Beer (341 ml-475 ml)', '1663485260.jpg', 'Premium_Beer(341ml-475 ml)', 5.38, 'Premium Beer (341 ml-475 ml)', 'Premium Beer (341 ml-475 ml)', 1, '2022-09-18 01:44:20', '2022-09-18 01:44:20'),
(42, 11, 'Cider (440 ml)', '1663485297.jpg', 'Cider(440ml)', 5.82, 'Cider (440 ml)', 'Cider (440 ml)', 1, '2022-09-18 01:44:57', '2022-09-18 01:44:57'),
(43, 11, 'Coolers (330 ml to 473 ml)', '1663485350.jpg', 'Coolers(330_mlto_473ml)', 5.82, 'Coolers (330 ml to 473 ml)', 'Coolers (330 ml to 473 ml)', 1, '2022-09-18 01:45:50', '2022-09-18 01:45:50'),
(44, 11, 'Bottled Wine (750 ml)', '1663485394.jpg', 'Bottled_Wine(750ml)', 19.99, 'Bottled Wine (750 ml)', 'Bottled Wine (750 ml)', 1, '2022-09-18 01:46:34', '2022-09-18 01:46:34'),
(45, 6, 'Regular Panzerotti', '1663485586.jpg', 'Regular', 14.99, 'Tomato sauce, cheese, pepperoni, ham, and mushrooms', 'Tomato sauce, cheese, pepperoni, ham, and mushrooms', 1, '2022-09-18 01:49:46', '2022-12-07 16:46:16'),
(46, 6, 'Supersized', '1663485628.jpg', 'Supersized', 17.99, 'Tomato sauce, cheese, pepperoni, ham, and mushrooms', 'Tomato sauce, cheese, pepperoni, ham, and mushrooms', 1, '2022-09-18 01:50:28', '2022-09-18 01:50:28'),
(47, 4, 'Small (4 Slice) Pizza with Sauce and cheese', '1663486751.jpg', 'Small(4Slice)Pizza_with_Sauce_and_cheese', 7.49, 'Regular or Thin Crust Available', 'Regular or Thin Crust Available', 1, '2022-09-18 02:09:11', '2022-09-18 02:09:11'),
(48, 4, 'Medium ( 8 Slice) Pizza with Sauce and chesse', '1663486816.jpg', 'Medium( 8_Slice)Pizza_with_Sauce_and_chesse', 12.49, 'Regular or Thin Crust Available', 'Regular or Thin Crust Available', 1, '2022-09-18 02:10:16', '2022-09-18 02:10:16'),
(49, 4, 'Large (12 Slice) Pizza with Sauce and Cheese', '1663486883.jpg', 'Large(12Slice)Pizza_with_Sauce_and_Cheese', 16.99, 'Regular or Thin Crust Available', 'Regular or Thin Crust Available', 1, '2022-09-18 02:11:23', '2022-09-18 02:11:23'),
(50, 4, 'Party Tray (24 Slice) Pizza with Sauce and Cheese', '1663486953.jpg', 'Party_Tray(24Slice)Pizza_with_Sauce_and_Cheese', 20.99, 'Regular or Thin Crust Available', 'Regular or Thin Crust Available', 1, '2022-09-18 02:12:33', '2022-09-18 02:12:33'),
(51, 10, 'Garden Salad', '1663487643.jpg', 'Garden_Salad', 7.99, 'Garden Salad', 'Garden Salad', 1, '2022-09-18 02:24:03', '2022-09-18 02:24:03'),
(52, 10, 'Chicken Caesar Salad', '1663487737.jpg', 'Chicken_caeser_Salad', 11.99, 'Chicken Caesar Salad', 'Chicken Caesar Salad', 1, '2022-09-18 02:25:37', '2022-09-18 02:26:42'),
(53, 10, 'Caesar Salad', '1663487789.jpg', 'Caesar_Salad', 9.99, 'Caesar Salad', 'Caesar Salad', 1, '2022-09-18 02:26:29', '2022-09-18 02:26:29'),
(54, 9, 'Mozzarella Sticks', '1663488471.jpg', 'Mozzarella_Sticks', 8.49, 'Creamy Garlic, Ranch, Blue Cheese, Cheddar Chipotle', 'Creamy Garlic, Ranch, Blue Cheese, Cheddar Chipotle', 1, '2022-09-18 02:37:51', '2022-09-18 02:41:44'),
(55, 9, 'Deep Fried Pickles', '1663488578.jpg', 'Deep_Fried_Pickles', 8.49, 'Creamy Garlic, Ranch, Blue Cheese, Cheddar Chipotle', 'Creamy Garlic, Ranch, Blue Cheese, Cheddar Chipotle', 1, '2022-09-18 02:39:11', '2022-09-18 02:41:56'),
(56, 9, 'Jalapeno Poppers', '1663488623.jpg', 'Jalapeno_Poppers', 8.49, 'Creamy Garlic, Ranch, Blue Cheese, Cheddar Chipotle', 'Creamy Garlic, Ranch, Blue Cheese, Cheddar Chipotle', 1, '2022-09-18 02:40:23', '2022-09-18 02:42:07'),
(57, 9, 'Cheeseballs', '1663488681.jpg', 'Cheeseballs', 8.49, 'Creamy Garlic, Ranch, Blue Cheese, Cheddar Chipotle', 'Creamy Garlic, Ranch, Blue Cheese, Cheddar Chipotle', 1, '2022-09-18 02:41:21', '2022-09-18 02:41:21'),
(58, 9, 'Deep Fried Wontons', '1663488779.jpg', 'Deep_Fried_Wontons', 8.99, 'Creamy Garlic, Ranch, Blue Cheese, Cheddar Chipotle', 'Creamy Garlic, Ranch, Blue Cheese, Cheddar Chipotle', 1, '2022-09-18 02:42:59', '2022-09-18 02:42:59'),
(59, 9, 'Sweet Potato Fries', '1663488888.jpg', 'Sweet_Potato_Fries', 8.49, 'Creamy Garlic, Ranch, Blue Cheese, Cheddar Chipotle', 'Creamy Garlic, Ranch, Blue Cheese, Cheddar Chipotle', 1, '2022-09-18 02:44:48', '2022-09-18 02:44:48'),
(60, 9, 'Cauliflower Bites', '1663488935.jpg', 'Cauliflower_Bites.', 8.49, 'Creamy Garlic, Ranch, Blue Cheese, Cheddar Chipotle', 'Creamy Garlic, Ranch, Blue Cheese, Cheddar Chipotle', 1, '2022-09-18 02:45:35', '2022-09-18 02:45:35'),
(61, 9, 'Mac & Cheese Bites', '1663488976.jpg', 'Mac&Cheese_Bites', 8.49, 'Creamy Garlic, Ranch, Blue Cheese, Cheddar Chipotle', 'Creamy Garlic, Ranch, Blue Cheese, Cheddar Chipotle', 1, '2022-09-18 02:46:17', '2022-09-18 02:46:17'),
(62, 9, 'Breaded Mushrooms', '1663489024.jpg', 'Breaded_Mushrooms', 8.49, 'Creamy Garlic, Ranch, Blue Cheese, Cheddar Chipotle', 'Creamy Garlic, Ranch, Blue Cheese, Cheddar Chipotle', 1, '2022-09-18 02:47:04', '2022-09-18 02:47:04'),
(63, 9, 'Samosa (4 w/ chili dip)', '1663489131.jpg', 'Samosa(4w/chili_dip)', 7.49, 'Creamy Garlic, Ranch, Blue Cheese, Cheddar Chipotle', 'Creamy Garlic, Ranch, Blue Cheese, Cheddar Chipotle', 1, '2022-09-18 02:48:51', '2022-09-18 02:48:51'),
(64, 9, 'Samosa Poutine', '1663489169.jpg', 'Samosa_Poutine', 8.99, 'Creamy Garlic, Ranch, Blue Cheese, Cheddar Chipotle', 'Creamy Garlic, Ranch, Blue Cheese, Cheddar Chipotle', 1, '2022-09-18 02:49:29', '2022-09-18 02:49:29'),
(65, 9, 'Gravy', '1663489201.jpg', 'Gravy', 2, 'Creamy Garlic, Ranch, Blue Cheese, Cheddar Chipotle', 'Creamy Garlic, Ranch, Blue Cheese, Cheddar Chipotle', 1, '2022-09-18 02:50:01', '2022-09-18 02:50:01'),
(66, 9, 'Dipping Sauce', '1663489233.jpg', 'Dipping_Sauce', 1.5, 'Creamy Garlic, Ranch, Blue Cheese, Cheddar Chipotle', 'Creamy Garlic, Ranch, Blue Cheese, Cheddar Chipotle', 1, '2022-09-18 02:50:33', '2022-09-18 02:50:33'),
(67, 0, 'Medium Meat Haters', '1663574785.jpg', 'Medium_Meat_Haters', 15.99, 'Medium Meat Haters', 'Medium Meat Haters', 1, '2022-09-19 02:36:25', '2022-09-19 02:36:25'),
(68, 9, 'Fries Small', '1663579667.jpg', 'Fries_small', 5.25, 'Creamy Garlic, Ranch, Blue Cheese, Cheddar Chipotle', 'Creamy Garlic, Ranch, Blue Cheese, Cheddar Chipotle', 1, '2022-09-19 03:57:48', '2022-09-19 03:57:48'),
(69, 9, 'Fries Large', '1663579726.jpg', 'Fries_large', 6.75, 'Creamy Garlic, Ranch, Blue Cheese, Cheddar Chipotle', 'Creamy Garlic, Ranch, Blue Cheese, Cheddar Chipotle', 1, '2022-09-19 03:58:46', '2022-09-19 03:58:46'),
(70, 9, 'Poutine Small', '1663579773.jpg', 'Poutine_small', 7.25, 'Creamy Garlic, Ranch, Blue Cheese, Cheddar Chipotle', 'Creamy Garlic, Ranch, Blue Cheese, Cheddar Chipotle', 1, '2022-09-19 03:59:33', '2022-09-19 03:59:33'),
(71, 9, 'Poutine Large', '1663579824.jpg', 'Poutine_large', 9.25, 'Creamy Garlic, Ranch, Blue Cheese, Cheddar Chipotle', 'Creamy Garlic, Ranch, Blue Cheese, Cheddar Chipotle', 1, '2022-09-19 04:00:24', '2022-09-19 04:00:24'),
(72, 9, 'Steak Poutine Small', '1663579862.jpg', 'Steak_Poutine_small', 10.25, 'Creamy Garlic, Ranch, Blue Cheese, Cheddar Chipotle', 'Creamy Garlic, Ranch, Blue Cheese, Cheddar Chipotle', 1, '2022-09-19 04:01:02', '2022-09-19 04:02:09'),
(73, 9, 'Steak Poutine Large', '1663579908.jpg', 'Steak_Poutine_large', 12.25, 'Creamy Garlic, Ranch, Blue Cheese, Cheddar Chipotle', 'Creamy Garlic, Ranch, Blue Cheese, Cheddar Chipotle', 1, '2022-09-19 04:01:48', '2022-09-19 04:01:48'),
(74, 9, 'Onion Rings Small', '1663579978.jpg', 'Onion_rings_small', 5.5, 'Creamy Garlic, Ranch, Blue Cheese, Cheddar Chipotle', 'Creamy Garlic, Ranch, Blue Cheese, Cheddar Chipotle', 1, '2022-09-19 04:02:58', '2022-09-19 04:02:58'),
(75, 9, 'Onion Rings Large', '1663580024.jpg', 'Onion_rings_large', 6.75, 'Creamy Garlic, Ranch, Blue Cheese, Cheddar Chipotle', 'Creamy Garlic, Ranch, Blue Cheese, Cheddar Chipotle', 1, '2022-09-19 04:03:44', '2022-09-19 04:03:44'),
(76, 6, 'Dip Fried Panzerotti', '1665050339.jpg', 'dip_fried_panzerotti', 5, 'Tomato sauce, cheese, pepperoni, ham, and mushrooms', 'Tomato sauce, cheese, pepperoni, ham, and mushrooms', 1, '2022-10-05 23:28:59', '2022-10-05 23:29:59');

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

--
-- Table structure for table `product_ckeckout_attrs`
--

CREATE TABLE `product_ckeckout_attrs` (
  `id` bigint UNSIGNED NOT NULL,
  `product_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `product_price` float NOT NULL,
  `pqty` float NOT NULL,
  `wings_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `ws_price` float NOT NULL,
  `sauces_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `sauce_price` float NOT NULL,
  `crusts_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `crust_price` float NOT NULL,
  `dippings_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `dipping_price` float NOT NULL,
  `cookings_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `cooking_price` float NOT NULL,
  `checkout_id` int NOT NULL,
  `total_price` float NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `product_ckeckout_attrs`
--

INSERT INTO `product_ckeckout_attrs` (`id`, `product_name`, `product_price`, `pqty`, `wings_name`, `ws_price`, `sauces_name`, `sauce_price`, `crusts_name`, `crust_price`, `dippings_name`, `dipping_price`, `cookings_name`, `cooking_price`, `checkout_id`, `total_price`, `created_at`, `updated_at`) VALUES
(1, 'margereta', 15.2, 1, 'Hot', 12, 'White Garlic Sauce', 2, 'Regular', 11, 'Garlic Dip', 5.22, 'Welldone', 10, 1, 115.42, NULL, NULL),
(2, 'pizza', 25.12, 1, 'Mild', 2, 'White Garlic Sauce', 2, 'Thin', 20, 'Ranch Dip', 6.33, 'Lightlydone', 5, 1, 111.95, NULL, NULL);

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

--
-- Table structure for table `sauces`
--

CREATE TABLE `sauces` (
  `id` bigint UNSIGNED NOT NULL,
  `sauce` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `sauce_price` float NOT NULL,
  `status` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sauces`
--

INSERT INTO `sauces` (`id`, `sauce`, `sauce_price`, `status`, `created_at`, `updated_at`) VALUES
(1, 'In House Pizza Sauce', 0, 1, '2022-07-26 06:47:28', '2022-11-21 23:22:54'),
(2, 'White Garlic Sauce', 0, 1, '2022-07-26 06:47:41', '2022-11-21 23:23:01');

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

--
-- Table structure for table `sizes`
--

CREATE TABLE `sizes` (
  `id` bigint UNSIGNED NOT NULL,
  `size` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `category_id` int NOT NULL,
  `price` float NOT NULL,
  `status` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sizes`
--

INSERT INTO `sizes` (`id`, `size`, `category_id`, `price`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Small(4slice)', 2, 13.99, 1, '2022-09-17 08:15:07', '2022-09-17 08:15:07'),
(2, 'Medium(8slice)', 2, 20.5, 1, '2022-09-17 08:18:48', '2022-09-17 08:18:48'),
(3, 'Large(12slice)', 2, 25.95, 1, '2022-09-17 08:19:14', '2022-09-17 08:19:14'),
(4, 'Party(24slice)', 2, 33.95, 1, '2022-09-17 08:19:37', '2022-09-17 08:19:37'),
(5, 'Small', 9, 5.25, 1, '2022-09-18 02:52:26', '2022-09-18 02:52:36'),
(6, 'Small(4slice)', 1, 13.99, 0, '2022-09-20 02:24:07', '2022-09-21 19:28:48'),
(7, 'Medium(8slice)', 1, 20.5, 0, '2022-09-20 02:24:23', '2022-09-21 19:28:51'),
(8, 'Large(12slice)', 1, 25.95, 0, '2022-09-20 02:24:39', '2022-09-21 19:28:54'),
(9, 'Party(24slice)', 1, 33.95, 0, '2022-09-20 02:24:53', '2022-09-21 19:28:57'),
(10, 'Small(4slice)', 4, 7.49, 1, '2022-09-21 02:37:42', '2022-09-21 02:37:42'),
(11, 'Medium(8slice)', 4, 12.49, 1, '2022-09-21 02:38:01', '2022-09-21 02:38:01'),
(12, 'Large(12slice)', 4, 16.99, 1, '2022-09-21 02:38:18', '2022-09-21 02:38:18'),
(13, 'Party(24slice)', 4, 20.99, 1, '2022-09-21 02:38:33', '2022-09-21 02:38:33');

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

--
-- Table structure for table `toppings`
--

CREATE TABLE `toppings` (
  `id` bigint UNSIGNED NOT NULL,
  `toppings` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `toppings_price` float NOT NULL,
  `toppings_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `toppings`
--

INSERT INTO `toppings` (`id`, `toppings`, `toppings_price`, `toppings_type`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Extra Cheese', 1, 'Small(4slice)', 1, '2022-07-22 01:44:57', '2022-09-19 07:03:55'),
(2, 'Pepperoni', 1, 'Small(4slice)', 1, '2022-07-26 06:40:24', '2022-09-19 07:35:22'),
(3, 'Mushrooms', 1, 'Small(4slice)', 1, '2022-08-02 04:23:36', '2022-09-19 07:35:16'),
(4, 'Canned Mushroom', 1, 'Small(4slice)', 1, '2022-08-02 04:24:17', '2022-09-19 07:35:26'),
(5, 'Bacon', 1, 'Small(4slice)', 1, '2022-08-02 04:24:27', '2022-09-19 07:35:32'),
(6, 'Roasted Red papers', 1, 'Small(4slice)', 1, '2022-08-02 04:24:50', '2022-09-19 07:35:37'),
(7, 'Green Papers', 1, 'Small(4slice)', 1, '2022-08-02 04:25:00', '2022-09-19 07:35:42'),
(8, 'Hot papers', 1, 'Small(4slice)', 1, '2022-08-02 04:25:12', '2022-09-19 07:35:46'),
(9, 'Onion', 1, 'Small(4slice)', 1, '2022-08-02 04:25:20', '2022-09-19 07:35:52'),
(10, 'Red Onions', 1, 'Small(4slice)', 1, '2022-08-02 04:25:37', '2022-09-19 07:35:57'),
(11, 'Green Olives', 1, 'Small(4slice)', 1, '2022-08-02 04:25:48', '2022-09-19 07:36:04'),
(12, 'Black Olives', 1, 'Small(4slice)', 1, '2022-08-02 04:25:57', '2022-09-19 07:36:46'),
(13, 'Ham', 1, 'Small(4slice)', 1, '2022-08-02 04:26:05', '2022-09-19 07:36:53'),
(14, 'Ground Beef', 1, 'Small(4slice)', 1, '2022-08-02 04:26:13', '2022-09-19 07:37:00'),
(15, 'Pineapple', 1, 'Small(4slice)', 1, '2022-08-02 04:26:21', '2022-09-19 07:37:07'),
(16, 'Sliced Tomatoes', 1, 'Small(4slice)', 1, '2022-08-02 04:27:42', '2022-09-19 07:36:38'),
(17, 'Salami', 1, 'Small(4slice)', 1, '2022-08-02 04:27:52', '2022-09-19 07:36:31'),
(18, 'Hot Sausage', 1, 'Small(4slice)', 1, '2022-08-02 04:28:00', '2022-09-19 07:36:24'),
(19, 'Jalapeno Paper', 1, 'Small(4slice)', 1, '2022-08-02 04:28:08', '2022-09-19 07:36:17'),
(20, 'Anchovies', 1, 'Small(4slice)', 1, '2022-08-02 04:28:16', '2022-09-19 07:36:11'),
(21, 'Extra Cheese', 2, 'Medium(8slice)', 1, '2022-09-19 07:26:23', '2022-09-19 07:26:23'),
(22, 'Pepperoni', 2, 'Medium(8slice)', 1, '2022-09-19 07:28:16', '2022-09-19 07:28:16'),
(23, 'Mushrooms', 2, 'Medium(8slice)', 1, '2022-09-19 07:29:50', '2022-09-19 07:29:50'),
(24, 'Canned Mushroom', 2, 'Medium(8slice)', 1, '2022-09-19 07:30:01', '2022-09-19 07:30:01'),
(25, 'Bacon', 2, 'Medium(8slice)', 1, '2022-09-19 07:30:16', '2022-09-19 07:30:16'),
(26, 'Roasted Red papers', 2, 'Medium(8slice)', 1, '2022-09-19 07:30:29', '2022-09-19 07:30:29'),
(27, 'Green Papers', 2, 'Medium(8slice)', 1, '2022-09-19 07:30:49', '2022-09-19 07:30:49'),
(28, 'Hot papers', 2, 'Medium(8slice)', 1, '2022-09-19 07:31:02', '2022-09-19 07:31:02'),
(29, 'Onion', 2, 'Medium(8slice)', 1, '2022-09-19 07:31:13', '2022-09-19 07:31:13'),
(30, 'Red Onions', 2, 'Medium(8slice)', 1, '2022-09-19 07:31:23', '2022-09-19 07:31:23'),
(31, 'Green Olives', 2, 'Medium(8slice)', 1, '2022-09-19 07:31:42', '2022-09-19 07:31:42'),
(32, 'Ham', 2, 'Medium(8slice)', 1, '2022-09-19 07:32:22', '2022-09-19 07:32:22'),
(33, 'Ground Beef', 2, 'Medium(8slice)', 1, '2022-09-19 07:32:38', '2022-09-19 07:32:38'),
(34, 'Pineapple', 2, 'Medium(8slice)', 1, '2022-09-19 07:33:01', '2022-09-19 07:33:01'),
(35, 'Sliced Tomatoes', 2, 'Medium(8slice)', 1, '2022-09-19 07:33:15', '2022-09-19 07:33:15'),
(36, 'Salami', 2, 'Medium(8slice)', 1, '2022-09-19 07:33:28', '2022-09-19 07:33:28'),
(37, 'Hot Sausage', 2, 'Medium(8slice)', 1, '2022-09-19 07:33:43', '2022-09-19 07:33:43'),
(38, 'Jalapeno Paper', 2, 'Medium(8slice)', 1, '2022-09-19 07:33:57', '2022-09-19 07:33:57'),
(39, 'Anchovies', 2, 'Medium(8slice)', 1, '2022-09-19 07:34:12', '2022-09-19 07:34:12'),
(40, 'Extra Cheese', 2.75, 'Large(12slice)', 1, '2022-09-19 07:37:36', '2022-09-19 07:37:36'),
(41, 'Black Olives', 2, 'Medium(8slice)', 1, '2022-09-19 07:39:13', '2022-09-19 07:39:13'),
(42, 'Pepperoni', 2.75, 'Large(12slice)', 1, '2022-09-19 07:39:44', '2022-09-19 07:39:44'),
(43, 'Mushrooms', 2.75, 'Large(12slice)', 1, '2022-09-19 07:39:54', '2022-09-19 07:39:54'),
(44, 'Canned Mushroom', 2.75, 'Large(12slice)', 1, '2022-09-19 07:40:12', '2022-09-19 07:40:12'),
(45, 'Bacon', 2.75, 'Large(12slice)', 1, '2022-09-19 07:40:31', '2022-09-19 07:40:31'),
(46, 'Roasted Red papers', 2.75, 'Large(12slice)', 1, '2022-09-19 07:40:50', '2022-09-19 07:40:50'),
(47, 'Green Papers', 2.75, 'Large(12slice)', 1, '2022-09-19 07:41:05', '2022-09-19 07:41:05'),
(48, 'Hot papers', 2.75, 'Large(12slice)', 1, '2022-09-19 07:41:20', '2022-09-19 07:41:20'),
(49, 'Onion', 2.75, 'Large(12slice)', 1, '2022-09-19 07:41:33', '2022-09-19 07:41:33'),
(50, 'Red Onions', 2.75, 'Large(12slice)', 1, '2022-09-19 07:41:46', '2022-09-19 07:41:46'),
(51, 'Green Olives', 2.75, 'Large(12slice)', 1, '2022-09-19 07:43:52', '2022-09-19 07:43:52'),
(52, 'Black Olives', 2.75, 'Large(12slice)', 1, '2022-09-19 07:44:06', '2022-09-19 07:44:06'),
(53, 'Ham', 2.75, 'Large(12slice)', 1, '2022-09-19 07:44:18', '2022-09-19 07:44:18'),
(54, 'Ground Beef', 2.75, 'Large(12slice)', 1, '2022-09-19 07:44:31', '2022-09-19 07:44:31'),
(55, 'Pineapple', 2.75, 'Large(12slice)', 1, '2022-09-19 07:44:43', '2022-09-19 07:44:43'),
(56, 'Sliced Tomatoes', 2.75, 'Large(12slice)', 1, '2022-09-19 07:44:55', '2022-09-19 07:44:55'),
(57, 'Salami', 2.75, 'Large(12slice)', 1, '2022-09-19 07:45:17', '2022-09-19 07:45:17'),
(58, 'Hot Sausage', 2.75, 'Large(12slice)', 1, '2022-09-19 07:45:28', '2022-09-19 07:45:28'),
(59, 'Jalapeno Paper', 2.75, 'Large(12slice)', 1, '2022-09-19 07:45:39', '2022-09-19 07:45:39'),
(60, 'Anchovies', 2.75, 'Large(12slice)', 1, '2022-09-19 07:45:50', '2022-09-19 07:45:50'),
(61, 'Extra Cheese', 3.25, 'Party(24slice)', 1, '2022-09-19 07:46:08', '2022-09-19 07:46:08'),
(62, 'Pepperoni', 3.25, 'Party(24slice)', 1, '2022-09-19 07:46:19', '2022-09-19 07:46:28'),
(63, 'Mushrooms', 3.25, 'Party(24slice)', 1, '2022-09-19 07:46:46', '2022-09-19 07:46:46'),
(64, 'Canned Mushroom', 3.25, 'Party(24slice)', 1, '2022-09-19 07:46:59', '2022-09-19 07:46:59'),
(65, 'Bacon', 3.25, 'Party(24slice)', 1, '2022-09-19 07:47:09', '2022-09-19 07:47:09'),
(66, 'Roasted Red papers', 3.25, 'Party(24slice)', 1, '2022-09-19 07:47:21', '2022-09-19 07:47:21'),
(67, 'Green Papers', 3.25, 'Party(24slice)', 1, '2022-09-19 07:47:37', '2022-09-19 07:47:37'),
(68, 'Hot papers', 3.25, 'Party(24slice)', 1, '2022-09-19 07:47:56', '2022-09-19 07:47:56'),
(69, 'Onion', 3.25, 'Party(24slice)', 1, '2022-09-19 07:48:17', '2022-09-19 07:48:17'),
(70, 'Red Onions', 3.25, 'Party(24slice)', 1, '2022-09-19 07:48:29', '2022-09-19 07:48:29'),
(71, 'Green Olives', 3.25, 'Party(24slice)', 1, '2022-09-19 07:48:46', '2022-09-19 07:48:46'),
(72, 'Black Olives', 3.25, 'Party(24slice)', 1, '2022-09-19 07:49:00', '2022-09-19 07:49:00'),
(73, 'Ham', 3.25, 'Party(24slice)', 1, '2022-09-19 07:49:11', '2022-09-19 07:49:11'),
(74, 'Ground Beef', 3.25, 'Party(24slice)', 1, '2022-09-19 07:49:24', '2022-09-19 07:49:24'),
(75, 'Pineapple', 3.25, 'Party(24slice)', 1, '2022-09-19 07:49:36', '2022-09-19 07:49:36'),
(76, 'Sliced Tomatoes', 3.25, 'Party(24slice)', 1, '2022-09-19 07:50:12', '2022-09-19 07:50:12'),
(77, 'Salami', 3.25, 'Party(24slice)', 1, '2022-09-19 07:50:23', '2022-09-19 07:50:23'),
(78, 'Hot Sausage', 3.25, 'Party(24slice)', 1, '2022-09-19 07:51:55', '2022-09-19 07:51:55'),
(79, 'Jalapeno Paper', 3.25, 'Party(24slice)', 1, '2022-09-19 07:52:11', '2022-09-19 07:52:11'),
(80, 'Anchovies', 3.25, 'Party(24slice)', 1, '2022-09-19 07:52:22', '2022-09-19 07:52:22');

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

--
-- Table structure for table `wings`
--

CREATE TABLE `wings` (
  `id` bigint UNSIGNED NOT NULL,
  `wings_sauce` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `ws_price` float NOT NULL,
  `status` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wings`
--

INSERT INTO `wings` (`id`, `wings_sauce`, `ws_price`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Mild', 0, 1, '2022-07-26 07:05:44', '2022-12-06 12:29:30'),
(2, 'Medium', 0, 1, '2022-07-26 07:05:55', '2022-12-06 12:29:39'),
(3, 'Hot', 0, 1, '2022-07-26 07:06:03', '2022-12-06 12:29:46'),
(4, 'Suicide', 0, 1, '2022-07-26 07:06:12', '2022-12-06 12:30:00'),
(5, 'Cajun', 0, 1, '2022-12-07 16:51:07', '2022-12-07 16:51:07'),
(6, 'Maestro\'s meltdown', 0, 1, '2022-12-07 16:53:03', '2022-12-07 16:53:03'),
(7, 'Honey garlic', 0, 1, '2022-12-07 16:53:46', '2022-12-07 16:53:46'),
(8, 'Buffalo style', 0, 1, '2022-12-07 16:55:33', '2022-12-07 16:55:33'),
(9, 'Honey/Hot', 0, 1, '2022-12-07 16:56:08', '2022-12-07 16:56:08'),
(10, 'Lemon Paper', 0, 1, '2022-12-07 16:56:31', '2022-12-07 16:56:31'),
(11, 'Sweet Chili', 0, 1, '2022-12-07 16:56:55', '2022-12-07 16:56:55'),
(12, 'Garlic parmesan', 0, 1, '2022-12-07 16:57:46', '2022-12-07 16:57:46'),
(13, 'Salt and paper', 0, 1, '2022-12-07 16:58:08', '2022-12-07 16:58:08');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `add_to_carts`
--
ALTER TABLE `add_to_carts`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `categories`
--
ALTER TABLE `categories`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `checkouts`
--
ALTER TABLE `checkouts`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `cookings`
--
ALTER TABLE `cookings`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `coupons`
--
ALTER TABLE `coupons`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `crusts`
--
ALTER TABLE `crusts`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `dippings`
--
ALTER TABLE `dippings`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

--
-- Indexes for table `insert_toppings`
--
ALTER TABLE `insert_toppings`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `order_toppings_completes`
--
ALTER TABLE `order_toppings_completes`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `pretoppings`
--
ALTER TABLE `pretoppings`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `products`
--
ALTER TABLE `products`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `product_ckeckout_attrs`
--
ALTER TABLE `product_ckeckout_attrs`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `sauces`
--
ALTER TABLE `sauces`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `sizes`
--
ALTER TABLE `sizes`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `toppings`
--
ALTER TABLE `toppings`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `wings`
--
ALTER TABLE `wings`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `add_to_carts`
--
ALTER TABLE `add_to_carts`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `categories`
--
ALTER TABLE `categories`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `checkouts`
--
ALTER TABLE `checkouts`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `cookings`
--
ALTER TABLE `cookings`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `coupons`
--
ALTER TABLE `coupons`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `crusts`
--
ALTER TABLE `crusts`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `dippings`
--
ALTER TABLE `dippings`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `insert_toppings`
--
ALTER TABLE `insert_toppings`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=68;

--
-- AUTO_INCREMENT for table `order_toppings_completes`
--
ALTER TABLE `order_toppings_completes`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `pretoppings`
--
ALTER TABLE `pretoppings`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- AUTO_INCREMENT for table `products`
--
ALTER TABLE `products`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=77;

--
-- AUTO_INCREMENT for table `product_ckeckout_attrs`
--
ALTER TABLE `product_ckeckout_attrs`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `sauces`
--
ALTER TABLE `sauces`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `sizes`
--
ALTER TABLE `sizes`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `toppings`
--
ALTER TABLE `toppings`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=81;

--
-- AUTO_INCREMENT for table `wings`
--
ALTER TABLE `wings`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;
COMMIT;

