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

START TRANSACTION;



--
-- Database: `luckyvitamins`
--

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

--
-- Table structure for table `brands`
--

CREATE TABLE `brands` (
  `id` int(11) NOT NULL,
  `name` varchar(250) NOT NULL,
  `status` enum('0','1') NOT NULL DEFAULT '1' COMMENT '''0''-inactive,''1''-active',
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `brands`
--

INSERT INTO `brands` (`id`, `name`, `status`, `updated_at`, `created_at`) VALUES
(1, 'LuckyVitamin', '1', '2022-06-06 10:23:37', '2022-06-06 10:23:37'),
(2, 'NOW Foods\r\n', '1', '2022-06-06 10:23:37', '2022-06-06 10:23:37'),
(3, 'Garden of Life', '1', '2022-06-06 10:24:06', '2022-06-06 10:24:06'),
(4, 'Solaray', '1', '2022-06-06 10:24:06', '2022-06-06 10:24:06'),
(5, 'Nature\'s Way', '1', '2022-06-06 10:24:57', '2022-06-06 10:24:57'),
(6, 'LuckyHerbs', '1', '2022-06-06 10:24:57', '2022-06-06 10:24:57'),
(7, 'Carlson Labs', '1', '2022-06-06 10:25:22', '2022-06-06 10:25:22'),
(8, 'Jarrow Formulas', '1', '2022-06-06 10:25:22', '2022-06-06 10:25:22'),
(9, 'Solgar', '1', '2022-06-06 10:25:43', '2022-06-06 10:25:43'),
(10, 'Source Naturals', '1', '2022-06-06 10:25:43', '2022-06-06 10:25:43'),
(11, 'Mrs. Meyer\'s', '1', '2022-06-06 10:26:19', '2022-06-06 10:26:19'),
(12, 'EO Products', '1', '2022-06-06 10:26:19', '2022-06-06 10:26:19'),
(13, 'Dr. Bronner\'s', '1', '2022-06-06 10:26:41', '2022-06-06 10:26:41'),
(14, 'Kiss My Face', '1', '2022-06-06 10:26:41', '2022-06-06 10:26:41'),
(15, 'LuckyTru', '1', '2022-06-06 10:27:05', '2022-06-06 10:27:05'),
(16, 'Desert Essence', '1', '2022-06-06 10:27:05', '2022-06-06 10:27:05'),
(17, 'Tom\'s of Maine', '1', '2022-06-06 10:27:26', '2022-06-06 10:27:26'),
(18, 'Nubian Heritage', '1', '2022-06-06 10:27:26', '2022-06-06 10:27:26'),
(19, 'LuckyAromas', '1', '2022-06-06 10:27:47', '2022-06-06 10:27:47'),
(20, 'JASON Natural Products', '1', '2022-06-06 10:27:47', '2022-06-06 10:27:47'),
(21, 'NuGo Nutrition', '1', '2022-06-06 10:28:14', '2022-06-06 10:28:14'),
(22, 'Lily\'s', '1', '2022-06-06 10:28:14', '2022-06-06 10:28:14'),
(23, 'LuckyEats', '1', '2022-06-06 10:28:37', '2022-06-06 10:28:37'),
(24, 'SweetLeaf', '1', '2022-06-06 10:28:37', '2022-06-06 10:28:37'),
(25, 'Mount Hagen', '1', '2022-06-06 10:28:54', '2022-06-06 10:28:54'),
(26, 'Natures Plus', '1', '2022-06-06 10:28:54', '2022-06-06 10:28:54'),
(27, 'Bob\'s Red Mill', '1', '2022-06-06 10:29:16', '2022-06-06 10:29:16'),
(28, 'Primal Kitchen', '1', '2022-06-06 10:29:16', '2022-06-06 10:29:16'),
(29, 'Walden Farms', '1', '2022-06-06 10:29:36', '2022-06-06 10:29:36'),
(30, 'Xlear', '1', '2022-06-06 10:29:36', '2022-06-06 10:29:36'),
(31, 'Yogi Tea', '1', '2022-06-06 10:29:55', '2022-06-06 10:29:55'),
(32, 'Orgain', '1', '2022-06-06 10:29:55', '2022-06-06 10:29:55'),
(33, 'Ultima Health Products\r\n', '1', '2022-06-06 10:30:13', '2022-06-06 10:30:13'),
(34, 'PlantFusion', '1', '2022-06-06 10:30:13', '2022-06-06 10:30:13'),
(35, 'Quest Nutrition', '1', '2022-06-06 10:30:36', '2022-06-06 10:30:36'),
(36, 'MRM', '1', '2022-06-06 10:30:36', '2022-06-06 10:30:36'),
(37, 'Ancient Nutrition\r\n', '1', '2022-06-06 10:30:59', '2022-06-06 10:30:59');

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

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

CREATE TABLE `categories` (
  `id` int(11) NOT NULL,
  `name` varchar(250) NOT NULL,
  `parent_id` int(11) NOT NULL,
  `slug` varchar(250) NOT NULL,
  `updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `created_at` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

INSERT INTO `categories` (`id`, `name`, `parent_id`, `slug`, `updated_at`, `created_at`) VALUES
(1, 'Vitamins & Supplements', 0, 'vitamins-supplements', '2022-06-03 15:27:09', '2022-06-03 15:27:09'),
(2, 'Immune Health', 1, 'immune-health', '2022-06-03 15:27:25', '2022-06-03 15:27:25'),
(3, 'Elderberry', 2, 'elderberry', '2022-06-03 15:28:08', '2022-06-03 15:28:08'),
(4, 'Vitamin C', 2, 'vitamin-c', '2022-06-03 15:28:18', '2022-06-03 15:28:18'),
(5, 'Zinc', 2, 'zinc', '2022-06-03 15:28:28', '2022-06-03 15:28:28'),
(6, 'Mushrooms', 2, 'mushrooms', '2022-06-03 15:28:37', '2022-06-03 15:28:37'),
(7, 'Vitamin D', 2, 'vitamin-d', '2022-06-03 15:28:49', '2022-06-03 15:28:49'),
(8, 'Multivitamins ', 1, 'multivitamins', '2022-06-03 15:29:10', '2022-06-03 15:29:10'),
(9, 'Women\'s Multiples', 8, 'women-s-multiples', '2022-06-03 15:29:46', '2022-06-03 15:29:46'),
(10, 'Children\'s Formulas', 8, 'children-s-formulas', '2022-06-03 15:33:58', '2022-06-03 15:33:58'),
(11, 'Men\'s Multiples', 8, 'men-s-multiples', '2022-06-03 15:34:12', '2022-06-03 15:34:12'),
(12, 'Prenatal Vitamins', 8, 'prenatal-vitamins', '2022-06-03 15:34:25', '2022-06-03 15:34:25'),
(13, 'Letter Vitamins ', 1, 'letter-vitamins', '2022-06-03 15:34:34', '2022-06-03 15:34:34'),
(14, 'Vitamin K', 13, 'vitamin-k', '2022-06-03 15:34:48', '2022-06-03 15:34:48'),
(15, 'Vitamin B', 13, 'vitamin-b', '2022-06-03 15:34:57', '2022-06-03 15:34:57'),
(16, 'Vitamin B12', 13, 'vitamin-b12', '2022-06-03 15:35:05', '2022-06-03 15:35:05'),
(17, 'Minerals ', 1, 'minerals', '2022-06-03 15:35:15', '2022-06-03 15:35:15'),
(18, 'Magnesium', 17, 'magnesium', '2022-06-03 15:35:23', '2022-06-03 15:35:23'),
(19, 'Calcium', 17, 'calcium', '2022-06-03 15:35:31', '2022-06-03 15:35:31'),
(20, 'Gut Health', 1, 'gut-health', '2022-06-03 15:35:43', '2022-06-03 15:35:43'),
(21, 'Probiotics', 20, 'probiotics', '2022-06-03 15:35:55', '2022-06-03 15:35:55'),
(22, 'Digestive Enzymes', 20, 'digestive-enzymes', '2022-06-03 15:36:03', '2022-06-03 15:36:03'),
(23, 'Psyllium Husk', 20, 'psyllium-husk', '2022-06-03 15:36:12', '2022-06-03 15:36:12'),
(24, 'Heart Health ', 1, 'heart-health', '2022-06-03 15:36:24', '2022-06-03 15:36:24'),
(25, 'Omega 3 Fish Oil', 24, 'omega-3-fish-oil', '2022-06-03 15:36:37', '2022-06-03 15:36:37'),
(26, 'CoQ10', 24, 'coq10', '2022-06-03 15:36:48', '2022-06-03 15:36:48'),
(27, 'Beauty From Within ', 1, 'beauty-from-within', '2022-06-03 15:36:59', '2022-06-03 15:36:59'),
(28, 'Collagen', 27, 'collagen', '2022-06-03 15:37:19', '2022-06-03 15:37:19'),
(29, 'Biotin', 27, 'biotin', '2022-06-03 15:37:30', '2022-06-03 15:37:30'),
(30, 'Hair, Skin & Nail', 27, 'hair-skin-nail', '2022-06-03 15:37:38', '2022-06-03 15:37:38'),
(31, 'Herbs ', 1, 'herbs', '2022-06-03 15:37:46', '2022-06-03 15:37:46'),
(32, 'Turmeric', 31, 'turmeric', '2022-06-03 15:37:59', '2022-06-03 15:37:59'),
(33, 'Ashwagandha', 31, 'ashwagandha', '2022-06-03 15:38:07', '2022-06-03 15:38:07'),
(34, 'Black Seed Oil', 31, 'black-seed-oil', '2022-06-03 15:38:18', '2022-06-03 15:38:18'),
(35, 'Garlic', 31, 'garlic', '2022-06-03 15:38:27', '2022-06-03 15:38:27'),
(36, 'Joint & Bone Support ', 1, 'joint-bone-support', '2022-06-03 15:38:36', '2022-06-03 15:38:36'),
(37, 'Inflammation & Pain', 36, 'inflammation-pain', '2022-06-03 15:38:44', '2022-06-03 15:38:44'),
(38, 'Density & Strength', 36, 'density-strength', '2022-06-03 15:38:54', '2022-06-03 15:38:54'),
(39, 'Anti-Inflammatory ', 1, 'anti-inflammatory', '2022-06-03 15:39:03', '2022-06-03 15:39:03'),
(40, 'Antioxidant Formulas ', 1, 'antioxidant-formulas', '2022-06-03 15:39:11', '2022-06-03 15:39:11'),
(41, 'Brain Health ', 1, 'brain-health', '2022-06-03 15:39:19', '2022-06-03 15:39:19'),
(42, 'Detoxification & Cleansing ', 1, 'detoxification-cleansing', '2022-06-03 15:39:29', '2022-06-03 15:39:29'),
(43, 'Professional Supplements ', 1, 'professional-supplements', '2022-06-03 15:39:38', '2022-06-03 15:39:38'),
(44, 'Homeopathy ', 1, 'homeopathy', '2022-06-03 15:39:47', '2022-06-03 15:39:47'),
(45, 'Mushroom Health ', 1, 'mushroom-health', '2022-06-03 15:39:55', '2022-06-03 15:39:55'),
(47, 'Personal Care & Beauty', 0, 'personal-care-beauty', '2022-06-03 15:40:22', '2022-06-03 15:40:22'),
(48, 'Oral Care ', 47, 'oral-care', '2022-06-03 15:40:32', '2022-06-03 15:40:32'),
(49, 'Toothpaste', 48, 'toothpaste', '2022-06-03 15:40:40', '2022-06-03 15:40:40'),
(50, 'Mouthwash', 48, 'mouthwash', '2022-06-03 15:40:49', '2022-06-03 15:40:49'),
(51, 'Bath and Body Care ', 47, 'bath-and-body-care', '2022-06-03 15:41:04', '2022-06-03 15:41:04'),
(52, 'Hand Soaps', 51, 'hand-soaps', '2022-06-03 15:41:13', '2022-06-03 15:41:13'),
(53, 'Bar Soaps', 51, 'bar-soaps', '2022-06-03 15:41:23', '2022-06-03 15:41:23'),
(54, 'Deodorants', 51, 'deodorants', '2022-06-03 15:41:33', '2022-06-03 15:41:33'),
(55, 'Body Lotions', 51, 'body-lotions', '2022-06-03 15:41:42', '2022-06-03 15:41:42'),
(56, 'Sun Care ', 47, 'sun-care', '2022-06-03 15:41:58', '2022-06-03 15:41:58'),
(57, 'Sunscreens', 56, 'sunscreens', '2022-06-03 15:42:07', '2022-06-03 15:42:07'),
(58, 'Aloe Vera', 56, 'aloe-vera', '2022-06-03 15:42:15', '2022-06-03 15:42:15'),
(59, 'Hair Care ', 47, 'hair-care', '2022-06-03 15:42:28', '2022-06-03 15:42:28'),
(60, 'Shampoos', 59, 'shampoos', '2022-06-03 15:42:37', '2022-06-03 15:42:37'),
(61, 'Conditioners', 59, 'conditioners', '2022-06-03 15:42:47', '2022-06-03 15:42:47'),
(62, 'Hair Coloring', 59, 'hair-coloring', '2022-06-03 15:43:01', '2022-06-03 15:43:01'),
(63, 'Face Care ', 47, 'face-care', '2022-06-03 15:43:16', '2022-06-03 15:43:16'),
(64, 'Face Creams', 63, 'face-creams', '2022-06-03 15:43:29', '2022-06-03 15:43:29'),
(65, 'Face Serums', 63, 'face-serums', '2022-06-03 15:43:42', '2022-06-03 15:43:42'),
(66, 'Face Cleansers', 63, 'face-cleansers', '2022-06-03 15:43:51', '2022-06-03 15:43:51'),
(67, 'Feminine Products ', 47, 'feminine-products', '2022-06-03 15:44:12', '2022-06-03 15:44:12'),
(68, 'Maxi Pads', 67, 'maxi-pads', '2022-06-03 15:44:23', '2022-06-03 15:44:23'),
(69, 'Tampons', 67, 'tampons', '2022-06-03 15:44:34', '2022-06-03 15:44:34'),
(70, 'Feminine Wash', 67, 'feminine-wash', '2022-06-03 15:44:42', '2022-06-03 15:44:42'),
(71, 'Aromatherapy & Essential Oils ', 47, 'aromatherapy-essential-oils', '2022-06-03 15:44:57', '2022-06-03 15:44:57'),
(72, 'Essential Oils', 71, 'essential-oils', '2022-06-03 15:45:08', '2022-06-03 15:45:08'),
(73, 'Diffusers', 71, 'diffusers', '2022-06-03 15:45:16', '2022-06-03 15:45:16'),
(74, 'Scented Candles', 71, 'scented-candles', '2022-06-03 15:45:27', '2022-06-03 15:45:27'),
(75, 'Flower Essences ', 47, 'flower-essences', '2022-06-03 15:45:45', '2022-06-03 15:45:45'),
(76, 'Rescue Remedies', 75, 'rescue-remedies', '2022-06-03 15:45:54', '2022-06-03 15:45:54'),
(77, 'Women\'s Health ', 47, 'women-s-health', '2022-06-03 15:46:34', '2022-06-03 15:46:34'),
(78, 'Progesterone Creams', 77, 'progesterone-creams', '2022-06-03 15:46:43', '2022-06-03 15:46:43'),
(79, 'Men\'s Grooming ', 47, 'men-s-grooming', '2022-06-03 15:47:14', '2022-06-03 15:47:14'),
(80, 'Beauty/Makeup ', 47, 'beauty-makeup', '2022-06-03 15:47:25', '2022-06-03 15:47:25'),
(81, 'Beauty Tools & Applicators ', 47, 'beauty-tools-applicators', '2022-06-03 15:47:36', '2022-06-03 15:47:36'),
(82, 'Shaving & Hair Removal ', 47, 'shaving-hair-removal', '2022-06-03 15:47:45', '2022-06-03 15:47:45'),
(83, 'First Aid & Wound Care ', 47, 'first-aid-wound-care', '2022-06-03 15:47:56', '2022-06-03 15:47:56'),
(85, 'Grocery', 0, 'grocery', '2022-06-04 14:19:47', '2022-06-04 14:19:47'),
(86, 'Baking ', 85, 'baking', '2022-06-04 14:20:03', '2022-06-04 14:20:03'),
(87, 'Baking Chocolates', 86, 'baking-chocolates', '2022-06-04 14:20:19', '2022-06-04 14:20:19'),
(88, 'Flours', 86, 'flours', '2022-06-04 14:20:50', '2022-06-04 14:20:50'),
(89, 'Nutritional Yeast Flakes', 86, 'nutritional-yeast-flakes', '2022-06-04 14:21:30', '2022-06-04 14:21:30'),
(90, 'Honey & Sweeteners ', 85, 'honey-sweeteners', '2022-06-04 14:22:57', '2022-06-04 14:22:57'),
(91, 'Stevia', 90, 'stevia', '2022-06-04 14:23:25', '2022-06-04 14:23:25'),
(92, 'Candy & Chocolate ', 85, 'candy-chocolate', '2022-06-04 14:24:07', '2022-06-04 14:24:07'),
(93, 'Chocolate Bars', 92, 'chocolate-bars', '2022-06-04 14:24:22', '2022-06-04 14:24:22'),
(94, 'Chewing Gum', 92, 'chewing-gum', '2022-06-04 14:24:34', '2022-06-04 14:24:34'),
(95, 'Mints', 92, 'mints', '2022-06-04 14:24:47', '2022-06-04 14:24:47'),
(96, 'Snacks ', 85, 'snacks', '2022-06-04 14:24:58', '2022-06-04 14:24:58'),
(97, 'Chips', 96, 'chips', '2022-06-04 14:25:12', '2022-06-04 14:25:12'),
(98, 'Cookies', 96, 'cookies', '2022-06-04 14:25:23', '2022-06-04 14:25:23'),
(99, 'Nutrition Bars', 96, 'nutrition-bars', '2022-06-04 14:25:35', '2022-06-04 14:25:35'),
(100, 'Dried Fruit, Nuts, & Seeds', 96, 'dried-fruit-nuts-seeds', '2022-06-04 14:25:47', '2022-06-04 14:25:47'),
(101, 'Beverages & Mixes ', 85, 'beverages-mixes', '2022-06-04 14:25:59', '2022-06-04 14:25:59'),
(102, 'Apple Cider Vinegar', 101, 'apple-cider-vinegar', '2022-06-04 14:26:14', '2022-06-04 14:26:14'),
(103, 'Meals & Side Dishes ', 85, 'meals-side-dishes', '2022-06-04 14:26:32', '2022-06-04 14:26:32'),
(104, 'Meal Replacement Shakes', 103, 'meal-replacement-shakes', '2022-06-04 14:26:58', '2022-06-04 14:26:58'),
(105, 'Canned & Packaged Foods ', 85, 'canned-packaged-foods', '2022-06-04 14:27:15', '2022-06-04 14:27:15'),
(106, 'Breakfast ', 85, 'breakfast', '2022-06-04 14:27:27', '2022-06-04 14:27:27'),
(107, 'Syrup', 106, 'syrup', '2022-06-04 14:27:47', '2022-06-04 14:27:47'),
(108, 'Cereal', 106, 'cereal', '2022-06-04 14:28:00', '2022-06-04 14:28:00'),
(109, 'Granola', 106, 'granola', '2022-06-04 14:28:26', '2022-06-04 14:28:26'),
(110, 'Coffee ', 85, 'coffee', '2022-06-04 14:28:42', '2022-06-04 14:28:42'),
(111, 'Instant Coffee', 110, 'instant-coffee', '2022-06-04 14:28:59', '2022-06-04 14:28:59'),
(112, 'Tea ', 85, 'tea', '2022-06-04 14:29:20', '2022-06-04 14:29:20'),
(113, 'Green Teas', 112, 'green-teas', '2022-06-04 14:29:32', '2022-06-04 14:29:32'),
(114, 'Black Teas', 112, 'black-teas', '2022-06-04 14:29:44', '2022-06-04 14:29:44'),
(115, 'Nut Butter & Fruit Spreads ', 85, 'nut-butter-fruit-spreads', '2022-06-04 14:29:55', '2022-06-04 14:29:55'),
(116, 'Seasonings & Condiments ', 85, 'seasonings-condiments', '2022-06-04 14:30:11', '2022-06-04 14:30:11'),
(117, 'Cooking Oils & Vinegars ', 85, 'cooking-oils-vinegars', '2022-06-04 14:30:24', '2022-06-04 14:30:24'),
(118, 'Pasta & Grains ', 85, 'pasta-grains', '2022-06-04 14:30:36', '2022-06-04 14:30:36'),
(120, 'Fitness', 0, 'fitness', '2022-06-04 14:31:09', '2022-06-04 14:31:09'),
(121, 'Protein ', 120, 'protein', '2022-06-04 14:31:21', '2022-06-04 14:31:21'),
(122, 'Plant Protein', 121, 'plant-protein', '2022-06-04 14:31:32', '2022-06-04 14:31:32'),
(123, 'Whey Protein Isolate Powders', 121, 'whey-protein-isolate-powders', '2022-06-04 14:31:42', '2022-06-04 14:31:42'),
(124, 'Protein Bars', 121, 'protein-bars', '2022-06-04 14:31:52', '2022-06-04 14:31:52'),
(125, 'Endurance ', 120, 'endurance', '2022-06-04 14:32:02', '2022-06-04 14:32:02'),
(126, 'Electrolytes', 125, 'electrolytes', '2022-06-04 14:32:20', '2022-06-04 14:32:20'),
(127, 'BCAA Formulas', 125, 'bcaa-formulas', '2022-06-04 14:32:34', '2022-06-04 14:32:34'),
(128, 'Pre Workout Boosters', 125, 'pre-workout-boosters', '2022-06-04 14:32:44', '2022-06-04 14:32:44'),
(129, 'Weight Management ', 120, 'weight-management', '2022-06-04 14:32:54', '2022-06-04 14:32:54'),
(130, 'Meal Replacement Powders', 129, 'meal-replacement-powders', '2022-06-04 14:33:07', '2022-06-04 14:33:07'),
(131, 'Medium Chain Triglycerides (MCTs)', 129, 'medium-chain-triglycerides-mcts', '2022-06-04 14:33:17', '2022-06-04 14:33:17'),
(132, 'Fat Burners', 129, 'fat-burners', '2022-06-04 14:33:30', '2022-06-04 14:33:30'),
(133, 'Amino Acid Formulas ', 120, 'amino-acid-formulas', '2022-06-04 14:33:41', '2022-06-04 14:33:41'),
(134, 'Testosterone Support ', 120, 'testosterone-support', '2022-06-04 14:33:53', '2022-06-04 14:33:53'),
(135, 'Diet Bars ', 120, 'diet-bars', '2022-06-04 14:34:05', '2022-06-04 14:34:05'),
(136, 'Appetite Control ', 120, 'appetite-control', '2022-06-04 14:34:16', '2022-06-04 14:34:16'),
(137, 'Sports Wellness ', 120, 'sports-wellness', '2022-06-04 14:34:31', '2022-06-04 14:34:31'),
(138, 'Fitness Accessories ', 120, 'fitness-accessories', '2022-06-04 14:34:43', '2022-06-04 14:34:43');

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

--
-- Table structure for table `category_product`
--

CREATE TABLE `category_product` (
  `id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `created_at` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `contacts`
--

CREATE TABLE `contacts` (
  `id` int(11) NOT NULL,
  `first_name` varchar(150) DEFAULT NULL,
  `last_name` varchar(150) DEFAULT NULL,
  `company` varchar(150) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `phone` varchar(100) DEFAULT NULL,
  `comments` text DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `countries`
--

CREATE TABLE `countries` (
  `id` int(11) NOT NULL,
  `iso` char(2) NOT NULL,
  `name` varchar(80) NOT NULL,
  `nicename` varchar(80) NOT NULL,
  `iso3` char(3) DEFAULT NULL,
  `numcode` smallint(6) DEFAULT NULL,
  `phonecode` int(5) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `countries`
--

INSERT INTO `countries` (`id`, `iso`, `name`, `nicename`, `iso3`, `numcode`, `phonecode`) VALUES
(1, 'AF', 'AFGHANISTAN', 'Afghanistan', 'AFG', 4, 93),
(2, 'AL', 'ALBANIA', 'Albania', 'ALB', 8, 355),
(3, 'DZ', 'ALGERIA', 'Algeria', 'DZA', 12, 213),
(4, 'AS', 'AMERICAN SAMOA', 'American Samoa', 'ASM', 16, 1684),
(5, 'AD', 'ANDORRA', 'Andorra', 'AND', 20, 376),
(6, 'AO', 'ANGOLA', 'Angola', 'AGO', 24, 244),
(7, 'AI', 'ANGUILLA', 'Anguilla', 'AIA', 660, 1264),
(8, 'AQ', 'ANTARCTICA', 'Antarctica', NULL, NULL, 0),
(9, 'AG', 'ANTIGUA AND BARBUDA', 'Antigua and Barbuda', 'ATG', 28, 1268),
(10, 'AR', 'ARGENTINA', 'Argentina', 'ARG', 32, 54),
(11, 'AM', 'ARMENIA', 'Armenia', 'ARM', 51, 374),
(12, 'AW', 'ARUBA', 'Aruba', 'ABW', 533, 297),
(13, 'AU', 'AUSTRALIA', 'Australia', 'AUS', 36, 61),
(14, 'AT', 'AUSTRIA', 'Austria', 'AUT', 40, 43),
(15, 'AZ', 'AZERBAIJAN', 'Azerbaijan', 'AZE', 31, 994),
(16, 'BS', 'BAHAMAS', 'Bahamas', 'BHS', 44, 1242),
(17, 'BH', 'BAHRAIN', 'Bahrain', 'BHR', 48, 973),
(18, 'BD', 'BANGLADESH', 'Bangladesh', 'BGD', 50, 880),
(19, 'BB', 'BARBADOS', 'Barbados', 'BRB', 52, 1246),
(20, 'BY', 'BELARUS', 'Belarus', 'BLR', 112, 375),
(21, 'BE', 'BELGIUM', 'Belgium', 'BEL', 56, 32),
(22, 'BZ', 'BELIZE', 'Belize', 'BLZ', 84, 501),
(23, 'BJ', 'BENIN', 'Benin', 'BEN', 204, 229),
(24, 'BM', 'BERMUDA', 'Bermuda', 'BMU', 60, 1441),
(25, 'BT', 'BHUTAN', 'Bhutan', 'BTN', 64, 975),
(26, 'BO', 'BOLIVIA', 'Bolivia', 'BOL', 68, 591),
(27, 'BA', 'BOSNIA AND HERZEGOVINA', 'Bosnia and Herzegovina', 'BIH', 70, 387),
(28, 'BW', 'BOTSWANA', 'Botswana', 'BWA', 72, 267),
(29, 'BV', 'BOUVET ISLAND', 'Bouvet Island', NULL, NULL, 0),
(30, 'BR', 'BRAZIL', 'Brazil', 'BRA', 76, 55),
(31, 'IO', 'BRITISH INDIAN OCEAN TERRITORY', 'British Indian Ocean Territory', NULL, NULL, 246),
(32, 'BN', 'BRUNEI DARUSSALAM', 'Brunei Darussalam', 'BRN', 96, 673),
(33, 'BG', 'BULGARIA', 'Bulgaria', 'BGR', 100, 359),
(34, 'BF', 'BURKINA FASO', 'Burkina Faso', 'BFA', 854, 226),
(35, 'BI', 'BURUNDI', 'Burundi', 'BDI', 108, 257),
(36, 'KH', 'CAMBODIA', 'Cambodia', 'KHM', 116, 855),
(37, 'CM', 'CAMEROON', 'Cameroon', 'CMR', 120, 237),
(38, 'CA', 'CANADA', 'Canada', 'CAN', 124, 1),
(39, 'CV', 'CAPE VERDE', 'Cape Verde', 'CPV', 132, 238),
(40, 'KY', 'CAYMAN ISLANDS', 'Cayman Islands', 'CYM', 136, 1345),
(41, 'CF', 'CENTRAL AFRICAN REPUBLIC', 'Central African Republic', 'CAF', 140, 236),
(42, 'TD', 'CHAD', 'Chad', 'TCD', 148, 235),
(43, 'CL', 'CHILE', 'Chile', 'CHL', 152, 56),
(44, 'CN', 'CHINA', 'China', 'CHN', 156, 86),
(45, 'CX', 'CHRISTMAS ISLAND', 'Christmas Island', NULL, NULL, 61),
(46, 'CC', 'COCOS (KEELING) ISLANDS', 'Cocos (Keeling) Islands', NULL, NULL, 672),
(47, 'CO', 'COLOMBIA', 'Colombia', 'COL', 170, 57),
(48, 'KM', 'COMOROS', 'Comoros', 'COM', 174, 269),
(49, 'CG', 'CONGO', 'Congo', 'COG', 178, 242),
(50, 'CD', 'CONGO, THE DEMOCRATIC REPUBLIC OF THE', 'Congo, the Democratic Republic of the', 'COD', 180, 242),
(51, 'CK', 'COOK ISLANDS', 'Cook Islands', 'COK', 184, 682),
(52, 'CR', 'COSTA RICA', 'Costa Rica', 'CRI', 188, 506),
(53, 'CI', 'COTE D\'IVOIRE', 'Cote D\'Ivoire', 'CIV', 384, 225),
(54, 'HR', 'CROATIA', 'Croatia', 'HRV', 191, 385),
(55, 'CU', 'CUBA', 'Cuba', 'CUB', 192, 53),
(56, 'CY', 'CYPRUS', 'Cyprus', 'CYP', 196, 357),
(57, 'CZ', 'CZECH REPUBLIC', 'Czech Republic', 'CZE', 203, 420),
(58, 'DK', 'DENMARK', 'Denmark', 'DNK', 208, 45),
(59, 'DJ', 'DJIBOUTI', 'Djibouti', 'DJI', 262, 253),
(60, 'DM', 'DOMINICA', 'Dominica', 'DMA', 212, 1767),
(61, 'DO', 'DOMINICAN REPUBLIC', 'Dominican Republic', 'DOM', 214, 1809),
(62, 'EC', 'ECUADOR', 'Ecuador', 'ECU', 218, 593),
(63, 'EG', 'EGYPT', 'Egypt', 'EGY', 818, 20),
(64, 'SV', 'EL SALVADOR', 'El Salvador', 'SLV', 222, 503),
(65, 'GQ', 'EQUATORIAL GUINEA', 'Equatorial Guinea', 'GNQ', 226, 240),
(66, 'ER', 'ERITREA', 'Eritrea', 'ERI', 232, 291),
(67, 'EE', 'ESTONIA', 'Estonia', 'EST', 233, 372),
(68, 'ET', 'ETHIOPIA', 'Ethiopia', 'ETH', 231, 251),
(69, 'FK', 'FALKLAND ISLANDS (MALVINAS)', 'Falkland Islands (Malvinas)', 'FLK', 238, 500),
(70, 'FO', 'FAROE ISLANDS', 'Faroe Islands', 'FRO', 234, 298),
(71, 'FJ', 'FIJI', 'Fiji', 'FJI', 242, 679),
(72, 'FI', 'FINLAND', 'Finland', 'FIN', 246, 358),
(73, 'FR', 'FRANCE', 'France', 'FRA', 250, 33),
(74, 'GF', 'FRENCH GUIANA', 'French Guiana', 'GUF', 254, 594),
(75, 'PF', 'FRENCH POLYNESIA', 'French Polynesia', 'PYF', 258, 689),
(76, 'TF', 'FRENCH SOUTHERN TERRITORIES', 'French Southern Territories', NULL, NULL, 0),
(77, 'GA', 'GABON', 'Gabon', 'GAB', 266, 241),
(78, 'GM', 'GAMBIA', 'Gambia', 'GMB', 270, 220),
(79, 'GE', 'GEORGIA', 'Georgia', 'GEO', 268, 995),
(80, 'DE', 'GERMANY', 'Germany', 'DEU', 276, 49),
(81, 'GH', 'GHANA', 'Ghana', 'GHA', 288, 233),
(82, 'GI', 'GIBRALTAR', 'Gibraltar', 'GIB', 292, 350),
(83, 'GR', 'GREECE', 'Greece', 'GRC', 300, 30),
(84, 'GL', 'GREENLAND', 'Greenland', 'GRL', 304, 299),
(85, 'GD', 'GRENADA', 'Grenada', 'GRD', 308, 1473),
(86, 'GP', 'GUADELOUPE', 'Guadeloupe', 'GLP', 312, 590),
(87, 'GU', 'GUAM', 'Guam', 'GUM', 316, 1671),
(88, 'GT', 'GUATEMALA', 'Guatemala', 'GTM', 320, 502),
(89, 'GN', 'GUINEA', 'Guinea', 'GIN', 324, 224),
(90, 'GW', 'GUINEA-BISSAU', 'Guinea-Bissau', 'GNB', 624, 245),
(91, 'GY', 'GUYANA', 'Guyana', 'GUY', 328, 592),
(92, 'HT', 'HAITI', 'Haiti', 'HTI', 332, 509),
(93, 'HM', 'HEARD ISLAND AND MCDONALD ISLANDS', 'Heard Island and Mcdonald Islands', NULL, NULL, 0),
(94, 'VA', 'HOLY SEE (VATICAN CITY STATE)', 'Holy See (Vatican City State)', 'VAT', 336, 39),
(95, 'HN', 'HONDURAS', 'Honduras', 'HND', 340, 504),
(96, 'HK', 'HONG KONG', 'Hong Kong', 'HKG', 344, 852),
(97, 'HU', 'HUNGARY', 'Hungary', 'HUN', 348, 36),
(98, 'IS', 'ICELAND', 'Iceland', 'ISL', 352, 354),
(99, 'IN', 'INDIA', 'India', 'IND', 356, 91),
(100, 'ID', 'INDONESIA', 'Indonesia', 'IDN', 360, 62),
(101, 'IR', 'IRAN, ISLAMIC REPUBLIC OF', 'Iran, Islamic Republic of', 'IRN', 364, 98),
(102, 'IQ', 'IRAQ', 'Iraq', 'IRQ', 368, 964),
(103, 'IE', 'IRELAND', 'Ireland', 'IRL', 372, 353),
(104, 'IL', 'ISRAEL', 'Israel', 'ISR', 376, 972),
(105, 'IT', 'ITALY', 'Italy', 'ITA', 380, 39),
(106, 'JM', 'JAMAICA', 'Jamaica', 'JAM', 388, 1876),
(107, 'JP', 'JAPAN', 'Japan', 'JPN', 392, 81),
(108, 'JO', 'JORDAN', 'Jordan', 'JOR', 400, 962),
(109, 'KZ', 'KAZAKHSTAN', 'Kazakhstan', 'KAZ', 398, 7),
(110, 'KE', 'KENYA', 'Kenya', 'KEN', 404, 254),
(111, 'KI', 'KIRIBATI', 'Kiribati', 'KIR', 296, 686),
(112, 'KP', 'KOREA, DEMOCRATIC PEOPLE\'S REPUBLIC OF', 'Korea, Democratic People\'s Republic of', 'PRK', 408, 850),
(113, 'KR', 'KOREA, REPUBLIC OF', 'Korea, Republic of', 'KOR', 410, 82),
(114, 'KW', 'KUWAIT', 'Kuwait', 'KWT', 414, 965),
(115, 'KG', 'KYRGYZSTAN', 'Kyrgyzstan', 'KGZ', 417, 996),
(116, 'LA', 'LAO PEOPLE\'S DEMOCRATIC REPUBLIC', 'Lao People\'s Democratic Republic', 'LAO', 418, 856),
(117, 'LV', 'LATVIA', 'Latvia', 'LVA', 428, 371),
(118, 'LB', 'LEBANON', 'Lebanon', 'LBN', 422, 961),
(119, 'LS', 'LESOTHO', 'Lesotho', 'LSO', 426, 266),
(120, 'LR', 'LIBERIA', 'Liberia', 'LBR', 430, 231),
(121, 'LY', 'LIBYAN ARAB JAMAHIRIYA', 'Libyan Arab Jamahiriya', 'LBY', 434, 218),
(122, 'LI', 'LIECHTENSTEIN', 'Liechtenstein', 'LIE', 438, 423),
(123, 'LT', 'LITHUANIA', 'Lithuania', 'LTU', 440, 370),
(124, 'LU', 'LUXEMBOURG', 'Luxembourg', 'LUX', 442, 352),
(125, 'MO', 'MACAO', 'Macao', 'MAC', 446, 853),
(126, 'MK', 'MACEDONIA, THE FORMER YUGOSLAV REPUBLIC OF', 'Macedonia, the Former Yugoslav Republic of', 'MKD', 807, 389),
(127, 'MG', 'MADAGASCAR', 'Madagascar', 'MDG', 450, 261),
(128, 'MW', 'MALAWI', 'Malawi', 'MWI', 454, 265),
(129, 'MY', 'MALAYSIA', 'Malaysia', 'MYS', 458, 60),
(130, 'MV', 'MALDIVES', 'Maldives', 'MDV', 462, 960),
(131, 'ML', 'MALI', 'Mali', 'MLI', 466, 223),
(132, 'MT', 'MALTA', 'Malta', 'MLT', 470, 356),
(133, 'MH', 'MARSHALL ISLANDS', 'Marshall Islands', 'MHL', 584, 692),
(134, 'MQ', 'MARTINIQUE', 'Martinique', 'MTQ', 474, 596),
(135, 'MR', 'MAURITANIA', 'Mauritania', 'MRT', 478, 222),
(136, 'MU', 'MAURITIUS', 'Mauritius', 'MUS', 480, 230),
(137, 'YT', 'MAYOTTE', 'Mayotte', NULL, NULL, 269),
(138, 'MX', 'MEXICO', 'Mexico', 'MEX', 484, 52),
(139, 'FM', 'MICRONESIA, FEDERATED STATES OF', 'Micronesia, Federated States of', 'FSM', 583, 691),
(140, 'MD', 'MOLDOVA, REPUBLIC OF', 'Moldova, Republic of', 'MDA', 498, 373),
(141, 'MC', 'MONACO', 'Monaco', 'MCO', 492, 377),
(142, 'MN', 'MONGOLIA', 'Mongolia', 'MNG', 496, 976),
(143, 'MS', 'MONTSERRAT', 'Montserrat', 'MSR', 500, 1664),
(144, 'MA', 'MOROCCO', 'Morocco', 'MAR', 504, 212),
(145, 'MZ', 'MOZAMBIQUE', 'Mozambique', 'MOZ', 508, 258),
(146, 'MM', 'MYANMAR', 'Myanmar', 'MMR', 104, 95),
(147, 'NA', 'NAMIBIA', 'Namibia', 'NAM', 516, 264),
(148, 'NR', 'NAURU', 'Nauru', 'NRU', 520, 674),
(149, 'NP', 'NEPAL', 'Nepal', 'NPL', 524, 977),
(150, 'NL', 'NETHERLANDS', 'Netherlands', 'NLD', 528, 31),
(151, 'AN', 'NETHERLANDS ANTILLES', 'Netherlands Antilles', 'ANT', 530, 599),
(152, 'NC', 'NEW CALEDONIA', 'New Caledonia', 'NCL', 540, 687),
(153, 'NZ', 'NEW ZEALAND', 'New Zealand', 'NZL', 554, 64),
(154, 'NI', 'NICARAGUA', 'Nicaragua', 'NIC', 558, 505),
(155, 'NE', 'NIGER', 'Niger', 'NER', 562, 227),
(156, 'NG', 'NIGERIA', 'Nigeria', 'NGA', 566, 234),
(157, 'NU', 'NIUE', 'Niue', 'NIU', 570, 683),
(158, 'NF', 'NORFOLK ISLAND', 'Norfolk Island', 'NFK', 574, 672),
(159, 'MP', 'NORTHERN MARIANA ISLANDS', 'Northern Mariana Islands', 'MNP', 580, 1670),
(160, 'NO', 'NORWAY', 'Norway', 'NOR', 578, 47),
(161, 'OM', 'OMAN', 'Oman', 'OMN', 512, 968),
(162, 'PK', 'PAKISTAN', 'Pakistan', 'PAK', 586, 92),
(163, 'PW', 'PALAU', 'Palau', 'PLW', 585, 680),
(164, 'PS', 'PALESTINIAN TERRITORY, OCCUPIED', 'Palestinian Territory, Occupied', NULL, NULL, 970),
(165, 'PA', 'PANAMA', 'Panama', 'PAN', 591, 507),
(166, 'PG', 'PAPUA NEW GUINEA', 'Papua New Guinea', 'PNG', 598, 675),
(167, 'PY', 'PARAGUAY', 'Paraguay', 'PRY', 600, 595),
(168, 'PE', 'PERU', 'Peru', 'PER', 604, 51),
(169, 'PH', 'PHILIPPINES', 'Philippines', 'PHL', 608, 63),
(170, 'PN', 'PITCAIRN', 'Pitcairn', 'PCN', 612, 0),
(171, 'PL', 'POLAND', 'Poland', 'POL', 616, 48),
(172, 'PT', 'PORTUGAL', 'Portugal', 'PRT', 620, 351),
(173, 'PR', 'PUERTO RICO', 'Puerto Rico', 'PRI', 630, 1787),
(174, 'QA', 'QATAR', 'Qatar', 'QAT', 634, 974),
(175, 'RE', 'REUNION', 'Reunion', 'REU', 638, 262),
(176, 'RO', 'ROMANIA', 'Romania', 'ROM', 642, 40),
(177, 'RU', 'RUSSIAN FEDERATION', 'Russian Federation', 'RUS', 643, 70),
(178, 'RW', 'RWANDA', 'Rwanda', 'RWA', 646, 250),
(179, 'SH', 'SAINT HELENA', 'Saint Helena', 'SHN', 654, 290),
(180, 'KN', 'SAINT KITTS AND NEVIS', 'Saint Kitts and Nevis', 'KNA', 659, 1869),
(181, 'LC', 'SAINT LUCIA', 'Saint Lucia', 'LCA', 662, 1758),
(182, 'PM', 'SAINT PIERRE AND MIQUELON', 'Saint Pierre and Miquelon', 'SPM', 666, 508),
(183, 'VC', 'SAINT VINCENT AND THE GRENADINES', 'Saint Vincent and the Grenadines', 'VCT', 670, 1784),
(184, 'WS', 'SAMOA', 'Samoa', 'WSM', 882, 684),
(185, 'SM', 'SAN MARINO', 'San Marino', 'SMR', 674, 378),
(186, 'ST', 'SAO TOME AND PRINCIPE', 'Sao Tome and Principe', 'STP', 678, 239),
(187, 'SA', 'SAUDI ARABIA', 'Saudi Arabia', 'SAU', 682, 966),
(188, 'SN', 'SENEGAL', 'Senegal', 'SEN', 686, 221),
(189, 'CS', 'SERBIA AND MONTENEGRO', 'Serbia and Montenegro', NULL, NULL, 381),
(190, 'SC', 'SEYCHELLES', 'Seychelles', 'SYC', 690, 248),
(191, 'SL', 'SIERRA LEONE', 'Sierra Leone', 'SLE', 694, 232),
(192, 'SG', 'SINGAPORE', 'Singapore', 'SGP', 702, 65),
(193, 'SK', 'SLOVAKIA', 'Slovakia', 'SVK', 703, 421),
(194, 'SI', 'SLOVENIA', 'Slovenia', 'SVN', 705, 386),
(195, 'SB', 'SOLOMON ISLANDS', 'Solomon Islands', 'SLB', 90, 677),
(196, 'SO', 'SOMALIA', 'Somalia', 'SOM', 706, 252),
(197, 'ZA', 'SOUTH AFRICA', 'South Africa', 'ZAF', 710, 27),
(198, 'GS', 'SOUTH GEORGIA AND THE SOUTH SANDWICH ISLANDS', 'South Georgia and the South Sandwich Islands', NULL, NULL, 0),
(199, 'ES', 'SPAIN', 'Spain', 'ESP', 724, 34),
(200, 'LK', 'SRI LANKA', 'Sri Lanka', 'LKA', 144, 94),
(201, 'SD', 'SUDAN', 'Sudan', 'SDN', 736, 249),
(202, 'SR', 'SURINAME', 'Suriname', 'SUR', 740, 597),
(203, 'SJ', 'SVALBARD AND JAN MAYEN', 'Svalbard and Jan Mayen', 'SJM', 744, 47),
(204, 'SZ', 'SWAZILAND', 'Swaziland', 'SWZ', 748, 268),
(205, 'SE', 'SWEDEN', 'Sweden', 'SWE', 752, 46),
(206, 'CH', 'SWITZERLAND', 'Switzerland', 'CHE', 756, 41),
(207, 'SY', 'SYRIAN ARAB REPUBLIC', 'Syrian Arab Republic', 'SYR', 760, 963),
(208, 'TW', 'TAIWAN, PROVINCE OF CHINA', 'Taiwan, Province of China', 'TWN', 158, 886),
(209, 'TJ', 'TAJIKISTAN', 'Tajikistan', 'TJK', 762, 992),
(210, 'TZ', 'TANZANIA, UNITED REPUBLIC OF', 'Tanzania, United Republic of', 'TZA', 834, 255),
(211, 'TH', 'THAILAND', 'Thailand', 'THA', 764, 66),
(212, 'TL', 'TIMOR-LESTE', 'Timor-Leste', NULL, NULL, 670),
(213, 'TG', 'TOGO', 'Togo', 'TGO', 768, 228),
(214, 'TK', 'TOKELAU', 'Tokelau', 'TKL', 772, 690),
(215, 'TO', 'TONGA', 'Tonga', 'TON', 776, 676),
(216, 'TT', 'TRINIDAD AND TOBAGO', 'Trinidad and Tobago', 'TTO', 780, 1868),
(217, 'TN', 'TUNISIA', 'Tunisia', 'TUN', 788, 216),
(218, 'TR', 'TURKEY', 'Turkey', 'TUR', 792, 90),
(219, 'TM', 'TURKMENISTAN', 'Turkmenistan', 'TKM', 795, 7370),
(220, 'TC', 'TURKS AND CAICOS ISLANDS', 'Turks and Caicos Islands', 'TCA', 796, 1649),
(221, 'TV', 'TUVALU', 'Tuvalu', 'TUV', 798, 688),
(222, 'UG', 'UGANDA', 'Uganda', 'UGA', 800, 256),
(223, 'UA', 'UKRAINE', 'Ukraine', 'UKR', 804, 380),
(224, 'AE', 'UNITED ARAB EMIRATES', 'United Arab Emirates', 'ARE', 784, 971),
(225, 'GB', 'UNITED KINGDOM', 'United Kingdom', 'GBR', 826, 44),
(226, 'US', 'UNITED STATES', 'United States', 'USA', 840, 1),
(227, 'UM', 'UNITED STATES MINOR OUTLYING ISLANDS', 'United States Minor Outlying Islands', NULL, NULL, 1),
(228, 'UY', 'URUGUAY', 'Uruguay', 'URY', 858, 598),
(229, 'UZ', 'UZBEKISTAN', 'Uzbekistan', 'UZB', 860, 998),
(230, 'VU', 'VANUATU', 'Vanuatu', 'VUT', 548, 678),
(231, 'VE', 'VENEZUELA', 'Venezuela', 'VEN', 862, 58),
(232, 'VN', 'VIET NAM', 'Viet Nam', 'VNM', 704, 84),
(233, 'VG', 'VIRGIN ISLANDS, BRITISH', 'Virgin Islands, British', 'VGB', 92, 1284),
(234, 'VI', 'VIRGIN ISLANDS, U.S.', 'Virgin Islands, U.s.', 'VIR', 850, 1340),
(235, 'WF', 'WALLIS AND FUTUNA', 'Wallis and Futuna', 'WLF', 876, 681),
(236, 'EH', 'WESTERN SAHARA', 'Western Sahara', 'ESH', 732, 212),
(237, 'YE', 'YEMEN', 'Yemen', 'YEM', 887, 967),
(238, 'ZM', 'ZAMBIA', 'Zambia', 'ZMB', 894, 260),
(239, 'ZW', 'ZIMBABWE', 'Zimbabwe', 'ZWE', 716, 263);

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

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

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

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

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_resets_table', 1),
(3, '2022_05_27_164326_create_roles_table', 1);

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

--
-- Table structure for table `orders`
--

CREATE TABLE `orders` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `payment_id` varchar(250) DEFAULT NULL,
  `payer_id` varchar(250) DEFAULT NULL,
  `amount` varchar(100) DEFAULT NULL,
  `status` enum('0','1','2','3') NOT NULL COMMENT '''0''-pending,''1''-success,''2''-Fail,''3''-cancel',
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `order_details`
--

CREATE TABLE `order_details` (
  `id` int(11) NOT NULL,
  `order_id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `qty` int(11) NOT NULL,
  `price` varchar(100) NOT NULL,
  `subtotal` varchar(150) NOT NULL,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `pages`
--

CREATE TABLE `pages` (
  `id` int(11) NOT NULL,
  `title` varchar(250) NOT NULL,
  `slug` varchar(100) NOT NULL,
  `content` text NOT NULL,
  `additional_notes` text DEFAULT NULL,
  `supporting_docs` text DEFAULT NULL,
  `status` enum('1','2','3') NOT NULL DEFAULT '1' COMMENT '''1''-active,''2''-inactive,''3''-deleted',
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

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

CREATE TABLE `products` (
  `id` int(11) NOT NULL,
  `title` varchar(250) NOT NULL,
  `description` longblob DEFAULT NULL,
  `price` varchar(150) NOT NULL,
  `compare_price` varchar(200) DEFAULT NULL,
  `category_id` int(11) DEFAULT NULL,
  `brand_id` int(11) NOT NULL,
  `slug` varchar(250) NOT NULL,
  `ship_weight` varchar(200) DEFAULT NULL,
  `servings` varchar(200) DEFAULT NULL,
  `dosage` varchar(200) DEFAULT NULL,
  `suggested_use` text DEFAULT NULL,
  `ingredient_title` text DEFAULT NULL,
  `ingredient_sub_title` text DEFAULT NULL,
  `supplement_title` varchar(250) DEFAULT NULL,
  `supplement_sub_title` varchar(250) DEFAULT NULL,
  `other_ingredients` varchar(250) DEFAULT NULL,
  `contains_no` text DEFAULT NULL,
  `warning` text DEFAULT NULL,
  `quantity` varchar(50) NOT NULL DEFAULT '1',
  `status` enum('0','1','2') NOT NULL COMMENT '''0''-pending,''1''-active,''2''-deleted',
  `updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `created_at` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

INSERT INTO `products` (`id`, `title`, `description`, `price`, `compare_price`, `category_id`, `brand_id`, `slug`, `ship_weight`, `servings`, `dosage`, `suggested_use`, `ingredient_title`, `ingredient_sub_title`, `supplement_title`, `supplement_sub_title`, `other_ingredients`, `contains_no`, `warning`, `quantity`, `status`, `updated_at`, `created_at`) VALUES
(1, 'Elderberry and Zinc - 30 Lozenges', 0x[BLOB], '379.80', '692.83', 3, 2, 'elderberry-and-zinc-30-lozenges', '0.10 Lb(s)', '15', '2 Lozenge(s)', 'As a dietary supplement, Adults: Take 2 lozenge daily. For short term high-intensity use, take 1 to 2 lozenges every 2-4 hours, dissolving completely in the mouth. Children under 60 pounds: Use 1/2 adult amount. Do not exceed 10 lozenges per day or use intense levels for more than 7 days.', 'NOW Foods - Elderberry and Zinc - 30 Lozenges', NULL, 'Serving Size: 1 Lozenge', 'Servings Per Container: 30', 'Fructose, Sorbitol, Magnesium Stearate (vegetable source), Silica, Cellulose and Natural Raspberry Flavor.', NULL, 'Contains no: Salt, wheat, gluten, soy, milk, egg, shellfish or preservatives.', '1', '1', '2022-07-06 11:00:30', '2022-06-24 19:00:53'),
(2, 'XyliWhite Toothpaste Gel with Baking Soda Platinum Mint - 6.4 oz.', 0x[BLOB], '305.96', '476.05', 49, 2, 'xyliwhite-toothpaste-gel-with-baking-soda-platinum', '0.25 Lb(s)', NULL, NULL, 'Adults and children 2 years and older: Apply XyliWhitte toothpaste gel on to a soft bristle toothbrush. Brush thoroughly after meals or at least twice a day or as directed by your dentist.', '<b>Functional Ingredients:</b> Xylitol (25%), Sodium Bicarbonate (9%) (whitening), Papain (whitening).', '<b>Ingredients:</b>  water, xylitol (25%), hydrated silica, sodium bicarbonate, glycerin, sorbitol, natural peppermint flavor, sodium coco-sulfate, chondrus crispus (carrageenan), potassium sorbate, papain, sodium carbonate, melaleuca alternifolia (tea tree) leaf oil.', NULL, NULL, NULL, 'Flouoride, SLS, Parabens and Gluten.', 'Xylitol is harmful to pets; seek veterinary care immediately if ingestion is suspected.<br/><br/>\r\n\r\n<b>WARNING:</b> Ingestion of Xylitol, in any product is a veterinary medical emergency if consumed by pets, especially dogs, ferrets and rabbits. If you suspect your pet ingested xylitol by either observing this happen or finding evidence of a chewed container or product, and the animal is acting normal, you should attempt to give animal(s) a small meal and at the same time, immediately seek veterinary medical attention. If you have evidence that they ingested a product that contains xylitol and the animal(s) is not acting normal you should  seek veterinary medical attention immediately without giving the animal any food.', '1', '1', '2022-07-22 15:39:55', '2022-06-25 05:47:17');
INSERT INTO `products` (`id`, `title`, `description`, `price`, `compare_price`, `category_id`, `brand_id`, `slug`, `ship_weight`, `servings`, `dosage`, `suggested_use`, `ingredient_title`, `ingredient_sub_title`, `supplement_title`, `supplement_sub_title`, `other_ingredients`, `contains_no`, `warning`, `quantity`, `status`, `updated_at`, `created_at`) VALUES
(3, 'Vitamin C Antioxidant 1000 mg. - 250 Veg Capsules', 0x[BLOB], '1247.79', '2253.65', 4, 1, 'vitamin-c-antioxidant-1000-mg-250-veg-capsules', '0.90 Lb(s)', '250', '1 Capsule(s)', 'Take 1 capsule daily.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', '2022-07-04 14:21:06', '2022-06-25 11:54:11'),
(4, 'NOW Sports L-Glutamine Powder - 1 lb.', 0x[BLOB], '1617.18', '3120.77', 133, 2, 'now-sports-l-glutamine-powder-1-lb', '1.19 Lb(s)', '605', '0.25 Teaspoon(s)', 'As a dietary supplement, mix 1 rounded teaspoon in juice, preferably between meals, 1 to 2 times daily as needed. Store in a cool, dry, dark place after opening.\r\n\r\nNOW L-Glutamine Powder is a pure, free-form, non-essential amino acid and is the highest grade available.', '<strong>NOW Foods - NOW Sports L-Glutamine Powder - 1 lb. (454 g)</strong>', NULL, 'Serving Size: 1 Rounded Teaspoon (approx. 5 g)', 'Servings Per Container: about 91', 'None', 'Not manufactured with wheat, gluten, soy, milk, egg, fish, shellfish or tree nut ingredients. Produced in a GMP facility that processes other ingredients containing these allergens.', '<b>Caution: </b> For adults only. Consult physician if pregnant/nursing, taking medication, or have a medical condition (including liver disease or bipolar disorder). Keep out of reach of children. Do not eat freshness packet enclosed.\r\n<br/><br/>\r\nThis product is sold by weight not volume. Natural color variation may occur in this product.', '1', '1', '2022-07-06 13:00:46', '2022-07-04 12:16:23');
INSERT INTO `products` (`id`, `title`, `description`, `price`, `compare_price`, `category_id`, `brand_id`, `slug`, `ship_weight`, `servings`, `dosage`, `suggested_use`, `ingredient_title`, `ingredient_sub_title`, `supplement_title`, `supplement_sub_title`, `other_ingredients`, `contains_no`, `warning`, `quantity`, `status`, `updated_at`, `created_at`) VALUES
(5, 'Black Elderberry Gummies with Vitamin C & Zinc Berry - 30 Gummies', 0x[BLOB], '990.96', '1135.14', 3, 8, 'black-elderberry-gummies-with-vitamin-c-zinc-berry', '0.25 Lb(s)', '30', '1 Gummy(s)', NULL, 'Sambucol - Black Elderberry Gummies with Vitamin C & Zinc Berry - 30 Gummies', NULL, 'Serving Size: 1 vegan gummy (2g)', 'Servings Per Container: 30', 'Cane Sugar, Tapioca Syrup, Purified Water, Pectin, Citric Acid, Sodium Citrate, Natural Flavors (Raspberry, Lemon), Vegetable Oil, Carnauba Wax.', NULL, 'Safety sealed for your protection. Do not use if seal under child resistant bottlecap is broken or missing. Store at room temperature. Avoid excessive heat and direct sunlight. Keep tightly sealed. Keep out of reach of children.', '1', '1', '2022-07-13 15:31:49', '2022-07-13 15:27:03');

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

--
-- Table structure for table `product_images`
--

CREATE TABLE `product_images` (
  `id` int(11) NOT NULL,
  `image` varchar(250) NOT NULL,
  `product_id` int(11) NOT NULL,
  `status` enum('0','1') NOT NULL DEFAULT '1' COMMENT '''0''-inactive,''1''-active',
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `product_images`
--

INSERT INTO `product_images` (`id`, `image`, `product_id`, `status`, `updated_at`, `created_at`) VALUES
(1, 'public/products/images/2022/06/1656097253_product_0.jpg', 1, '1', '2022-06-24 13:30:53', '2022-06-24 13:30:53'),
(2, 'public/products/images/2022/06/1656097253_product_1.jpg', 1, '1', '2022-06-24 13:30:53', '2022-06-24 13:30:53'),
(3, 'public/products/images/2022/06/1656097253_product_2.jpg', 1, '1', '2022-06-24 13:30:53', '2022-06-24 13:30:53'),
(4, 'public/products/images/2022/06/1656097253_product_3.jpg', 1, '1', '2022-06-24 13:30:54', '2022-06-24 13:30:54'),
(5, 'public/products/images/2022/06/1656136037_product_0.jpg', 2, '1', '2022-06-25 00:17:17', '2022-06-25 00:17:17'),
(6, 'public/products/images/2022/06/1656136037_product_1.jpg', 2, '1', '2022-06-25 00:17:17', '2022-06-25 00:17:17'),
(7, 'public/products/images/2022/06/1656136037_product_2.jpg', 2, '1', '2022-06-25 00:17:17', '2022-06-25 00:17:17'),
(8, 'public/products/images/2022/06/1656158051_product_0.jpg', 3, '1', '2022-06-25 06:24:11', '2022-06-25 06:24:11'),
(9, 'public/products/images/2022/06/1656158051_product_1.jpg', 3, '1', '2022-06-25 06:24:11', '2022-06-25 06:24:11'),
(10, 'public/products/images/2022/06/1656158052_product_2.jpg', 3, '1', '2022-06-25 06:24:12', '2022-06-25 06:24:12'),
(11, 'public/products/images/2022/06/1656158052_product_3.jpg', 3, '1', '2022-06-25 06:24:12', '2022-06-25 06:24:12'),
(12, 'public/products/images/2022/06/1656158052_product_4.jpg', 3, '1', '2022-06-25 06:24:12', '2022-06-25 06:24:12'),
(13, 'public/products/images/2022/07/1656936983_product_0.jpg', 4, '1', '2022-07-04 06:46:24', '2022-07-04 06:46:24'),
(14, 'public/products/images/2022/07/1656936984_product_1.jpg', 4, '1', '2022-07-04 06:46:24', '2022-07-04 06:46:24'),
(15, 'public/products/images/2022/07/1656936984_product_2.jpg', 4, '1', '2022-07-04 06:46:24', '2022-07-04 06:46:24'),
(16, 'public/products/images/2022/07/1657726023_product_0.jpg', 5, '1', '2022-07-13 09:57:03', '2022-07-13 09:57:03'),
(17, 'public/products/images/2022/07/1657726023_product_1.jpg', 5, '1', '2022-07-13 09:57:03', '2022-07-13 09:57:03'),
(18, 'public/products/images/2022/07/1657726023_product_2.jpg', 5, '1', '2022-07-13 09:57:03', '2022-07-13 09:57:03');

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

--
-- Table structure for table `product_specialities`
--

CREATE TABLE `product_specialities` (
  `id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `speciality_id` int(11) NOT NULL,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `product_specialities`
--

INSERT INTO `product_specialities` (`id`, `product_id`, `speciality_id`, `updated_at`, `created_at`) VALUES
(170, 3, 4, '2022-07-04 08:51:06', '2022-07-04 08:51:06'),
(171, 3, 5, '2022-07-04 08:51:06', '2022-07-04 08:51:06'),
(172, 3, 6, '2022-07-04 08:51:06', '2022-07-04 08:51:06'),
(173, 3, 7, '2022-07-04 08:51:06', '2022-07-04 08:51:06'),
(174, 3, 8, '2022-07-04 08:51:06', '2022-07-04 08:51:06'),
(175, 3, 9, '2022-07-04 08:51:06', '2022-07-04 08:51:06'),
(176, 3, 12, '2022-07-04 08:51:06', '2022-07-04 08:51:06'),
(177, 3, 13, '2022-07-04 08:51:06', '2022-07-04 08:51:06'),
(178, 3, 14, '2022-07-04 08:51:07', '2022-07-04 08:51:07'),
(179, 3, 15, '2022-07-04 08:51:07', '2022-07-04 08:51:07'),
(180, 3, 18, '2022-07-04 08:51:07', '2022-07-04 08:51:07'),
(181, 3, 20, '2022-07-04 08:51:07', '2022-07-04 08:51:07'),
(182, 2, 4, '2022-07-04 08:51:59', '2022-07-04 08:51:59'),
(183, 2, 5, '2022-07-04 08:51:59', '2022-07-04 08:51:59'),
(184, 2, 7, '2022-07-04 08:52:00', '2022-07-04 08:52:00'),
(185, 2, 9, '2022-07-04 08:52:00', '2022-07-04 08:52:00'),
(186, 2, 13, '2022-07-04 08:52:00', '2022-07-04 08:52:00'),
(187, 2, 17, '2022-07-04 08:52:00', '2022-07-04 08:52:00'),
(188, 2, 18, '2022-07-04 08:52:00', '2022-07-04 08:52:00'),
(189, 2, 19, '2022-07-04 08:52:00', '2022-07-04 08:52:00'),
(190, 1, 4, '2022-07-04 08:52:34', '2022-07-04 08:52:34'),
(191, 1, 5, '2022-07-04 08:52:34', '2022-07-04 08:52:34'),
(192, 1, 6, '2022-07-04 08:52:34', '2022-07-04 08:52:34'),
(193, 1, 7, '2022-07-04 08:52:34', '2022-07-04 08:52:34'),
(194, 1, 8, '2022-07-04 08:52:34', '2022-07-04 08:52:34'),
(195, 1, 9, '2022-07-04 08:52:34', '2022-07-04 08:52:34'),
(196, 1, 10, '2022-07-04 08:52:34', '2022-07-04 08:52:34'),
(197, 1, 11, '2022-07-04 08:52:34', '2022-07-04 08:52:34'),
(198, 1, 12, '2022-07-04 08:52:34', '2022-07-04 08:52:34'),
(199, 1, 13, '2022-07-04 08:52:34', '2022-07-04 08:52:34'),
(200, 1, 14, '2022-07-04 08:52:35', '2022-07-04 08:52:35'),
(201, 1, 15, '2022-07-04 08:52:35', '2022-07-04 08:52:35'),
(202, 1, 16, '2022-07-04 08:52:35', '2022-07-04 08:52:35'),
(203, 4, 4, '2022-07-04 08:53:37', '2022-07-04 08:53:37'),
(204, 4, 5, '2022-07-04 08:53:37', '2022-07-04 08:53:37'),
(205, 4, 6, '2022-07-04 08:53:37', '2022-07-04 08:53:37'),
(206, 4, 7, '2022-07-04 08:53:38', '2022-07-04 08:53:38'),
(207, 4, 8, '2022-07-04 08:53:38', '2022-07-04 08:53:38'),
(208, 4, 9, '2022-07-04 08:53:38', '2022-07-04 08:53:38'),
(209, 4, 10, '2022-07-04 08:53:38', '2022-07-04 08:53:38'),
(210, 4, 11, '2022-07-04 08:53:38', '2022-07-04 08:53:38'),
(211, 4, 12, '2022-07-04 08:53:38', '2022-07-04 08:53:38'),
(212, 4, 13, '2022-07-04 08:53:38', '2022-07-04 08:53:38'),
(213, 4, 14, '2022-07-04 08:53:38', '2022-07-04 08:53:38'),
(214, 4, 15, '2022-07-04 08:53:38', '2022-07-04 08:53:38'),
(215, 4, 16, '2022-07-04 08:53:38', '2022-07-04 08:53:38'),
(216, 4, 18, '2022-07-04 08:53:38', '2022-07-04 08:53:38'),
(217, 4, 21, '2022-07-04 08:53:38', '2022-07-04 08:53:38'),
(218, 4, 22, '2022-07-04 08:53:38', '2022-07-04 08:53:38'),
(219, 4, 23, '2022-07-04 08:53:38', '2022-07-04 08:53:38'),
(220, 4, 24, '2022-07-04 08:53:38', '2022-07-04 08:53:38'),
(221, 4, 25, '2022-07-04 08:53:38', '2022-07-04 08:53:38'),
(222, 5, 1, '2022-07-13 09:57:03', '2022-07-13 09:57:03'),
(223, 5, 6, '2022-07-13 09:57:04', '2022-07-13 09:57:04'),
(224, 5, 8, '2022-07-13 09:57:04', '2022-07-13 09:57:04'),
(225, 5, 9, '2022-07-13 09:57:04', '2022-07-13 09:57:04'),
(226, 5, 12, '2022-07-13 09:57:04', '2022-07-13 09:57:04'),
(227, 5, 13, '2022-07-13 09:57:04', '2022-07-13 09:57:04'),
(228, 5, 14, '2022-07-13 09:57:04', '2022-07-13 09:57:04'),
(229, 5, 16, '2022-07-13 09:57:04', '2022-07-13 09:57:04'),
(230, 5, 18, '2022-07-13 09:57:04', '2022-07-13 09:57:04'),
(231, 5, 29, '2022-07-13 09:57:04', '2022-07-13 09:57:04'),
(232, 5, 30, '2022-07-13 09:57:04', '2022-07-13 09:57:04');

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

--
-- Table structure for table `product_supplements`
--

CREATE TABLE `product_supplements` (
  `id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `title` varchar(250) DEFAULT NULL,
  `amount_per_serving` varchar(100) DEFAULT NULL,
  `daily_value` varchar(100) DEFAULT NULL,
  `status` enum('0','1') NOT NULL DEFAULT '1' COMMENT '''0''-inactive,''1''-active',
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `product_supplements`
--

INSERT INTO `product_supplements` (`id`, `product_id`, `title`, `amount_per_serving`, `daily_value`, `status`, `updated_at`, `created_at`) VALUES
(17, 1, 'Calories    10', '10', NULL, '1', '2022-07-06 05:58:35', '2022-07-06 05:58:35'),
(18, 1, 'Total Carbohydrates', '2.5 g', '1%', '1', '2022-07-06 05:58:35', '2022-07-06 05:58:35'),
(19, 1, 'Sugars', '2.5 g', NULL, '1', '2022-07-06 05:58:35', '2022-07-06 05:58:35'),
(20, 1, 'Vitamin C (Ascorbic Acid/Sodium Ascorbate)', '150 mg', '250%', '1', '2022-07-06 05:58:35', '2022-07-06 05:58:35'),
(21, 1, 'Zinc (from Zinc Gluconate)', '12 mg', '80%', '1', '2022-07-06 05:58:35', '2022-07-06 05:58:35'),
(22, 1, 'Elderberry (Sambucus nigra) (10:1 Extract)', '100 mg', '*', '1', '2022-07-06 05:58:35', '2022-07-06 05:58:35'),
(23, 1, 'Echinacea purpurea (Root)', '25 mg', '*', '1', '2022-07-06 05:58:35', '2022-07-06 05:58:35'),
(24, 1, 'Bee Propolis', '25 mg', '*', '1', '2022-07-06 05:58:35', '2022-07-06 05:58:35'),
(25, 1, 'Slippery Elm Bark (Ulmus rubra) (Bark)', '25 mg', '*', '1', '2022-07-06 05:58:35', '2022-07-06 05:58:35'),
(28, 4, 'L-Glutamine (Free-Form)', '5 g (5000 mg)', '**', '1', '2022-07-06 07:30:46', '2022-07-06 07:30:46'),
(29, 5, 'Calories 5', NULL, NULL, '1', '2022-07-13 10:01:49', '2022-07-13 10:01:49'),
(30, 5, 'Total Carbohydrate', '2 g', '<1%†', '1', '2022-07-13 10:01:49', '2022-07-13 10:01:49'),
(31, 5, 'Total Sugars    Includes 1g Added Sugars', '1 g', '2%', '1', '2022-07-13 10:01:50', '2022-07-13 10:01:50'),
(32, 5, 'Sodium', '5 mg', '<1%', '1', '2022-07-13 10:01:50', '2022-07-13 10:01:50'),
(33, 5, 'Vitamin C (as Ascorbic Acid)', '45mg', '50%', '1', '2022-07-13 10:01:50', '2022-07-13 10:01:50'),
(34, 5, 'Zinc (as Zinc Citrate)', '4mg', '34%', '1', '2022-07-13 10:01:50', '2022-07-13 10:01:50'),
(35, 5, 'Black Elderberry (Sambucus Nigra) Extract (equivalent to 1.7 g of Premium Black Elderberry Fruit)', '50mg', NULL, '1', '2022-07-13 10:01:50', '2022-07-13 10:01:50');

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

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `role_id` bigint(20) UNSIGNED NOT NULL,
  `role_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `role_slug` varchar(255) COLLATE utf8mb4_unicode_ci 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 `roles`
--

INSERT INTO `roles` (`role_id`, `role_name`, `role_slug`, `created_at`, `updated_at`) VALUES
(1, 'Admin', 'admin', NULL, NULL),
(2, 'User', 'user', NULL, NULL),
(3, 'Manager', 'manager', NULL, NULL);

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

--
-- Table structure for table `specialities`
--

CREATE TABLE `specialities` (
  `id` int(11) NOT NULL,
  `name` varchar(200) NOT NULL,
  `image` varchar(200) NOT NULL,
  `detail` varchar(200) NOT NULL,
  `status` enum('0','1') NOT NULL DEFAULT '1' COMMENT '''0''-inactive,''1''-active',
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `specialities`
--

INSERT INTO `specialities` (`id`, `name`, `image`, `detail`, `status`, `updated_at`, `created_at`) VALUES
(1, 'Artificial Colors Free', 'public/img/icons/artificial-colors-free.svg', 'Contains no artificial or synthetic colors.', '1', '2022-06-06 12:49:55', '2022-06-06 12:49:55'),
(2, 'Alcohol Free', 'public/img/icons/alcohol-free.svg', 'Products with this mark are free of alcohol ingredients that can cause irritation or a drying effect.', '1', '2022-06-06 12:49:55', '2022-06-06 12:49:55'),
(3, 'Artificial flavors free', 'public/img/icons/artificial-flavors-free.svg', 'Free of synthetic essences or extractives which contain flavoring constituents.', '1', '2022-06-06 12:53:07', '2022-06-06 12:53:07'),
(4, ' Companies For a Cause ', 'public/img/icons/companies-for-a-cause.svg', 'Organizations that give back and donate a portion of sales to charitable organizations.', '1', '2022-06-06 12:53:07', '2022-06-06 12:53:07'),
(5, 'GMP Certified', 'public/img/icons/gmp-certified.svg', 'Good Manufacturing Practices are recognized for their management of manufacturing and quality.', '1', '2022-06-24 14:29:30', '2022-06-24 14:29:30'),
(6, 'Dairy-Free', 'public/img/icons/dairy-free.svg', 'Contains no milk or milk-derived ingredients such as butter, yogurt, cream or cheese.', '1', '2022-06-24 14:29:30', '2022-06-24 14:29:30'),
(7, 'Eco Friendly', 'public/img/icons/eco-friendly.svg', 'Products and/or companies that provide environmental, social and economic benefits.', '1', '2022-06-24 14:31:39', '2022-06-24 14:31:39'),
(8, 'Egg-Free', 'public/img/icons/egg-free.svg', 'Products that do not contain any eggs or ingredients derived from eggs.', '1', '2022-06-24 14:31:39', '2022-06-24 14:31:39'),
(9, 'Gluten-Free', 'public/img/icons/gluten-free.svg', 'Excludes any ingredient that is a gluten-containing grain including wheat, barley, rye or triticale.', '1', '2022-06-24 14:34:51', '2022-06-24 14:34:51'),
(10, 'Kosher', 'public/img/icons/kosher.svg', 'Complies with a strict policy of kosher food laws including cleanliness, purity and quality. ', '1', '2022-06-24 14:34:51', '2022-06-24 14:34:51'),
(11, 'Cruelty-Free', 'public/img/icons/cruelty-free.svg', 'Guarantees that no animal testing is conducted or commissioned for finished products.', '1', '2022-06-24 14:37:24', '2022-06-24 14:37:24'),
(12, 'Soy-Free', 'public/img/icons/soy-free.svg', 'Soy-free products do not contain soybeans or any other forms of soy.', '1', '2022-06-24 14:37:24', '2022-06-24 14:37:24'),
(13, 'Vegetarian', 'public/img/icons/vegetarian.svg', 'Excludes all meat products and any meat derivatives, but can include eggs, dairy and other animal-sourced foods. ', '1', '2022-06-24 14:39:09', '2022-06-24 14:39:09'),
(14, 'Wheat-Free', 'public/img/icons/wheat-free.svg', 'Wheat-free products contain no wheat or ingredients derived from wheat.', '1', '2022-06-24 14:39:09', '2022-06-24 14:39:09'),
(15, 'Fish/Shellfish Free', 'public/img/icons/fish-shellfish-free.svg', 'Does not contain any ingredients from made from crustaceans and mollusks.', '1', '2022-06-24 14:41:24', '2022-06-24 14:41:24'),
(16, 'Preservatives Free', 'public/img/icons/preservatives-free.svg', 'Does not contain any additional chemical compounds to prevent decomposition.', '1', '2022-06-24 14:41:24', '2022-06-24 14:41:24'),
(17, ' SLS-Free', 'public/img/icons/sls-free.svg', 'Free of all sodium lauryl sulfate, a foaming agent that produces bubbles.', '1', '2022-07-01 16:56:58', '2022-06-25 05:55:00'),
(18, 'Vegan ', 'public/img/icons/vegan.svg', 'A diet and lifestyle that does not include any meat or animal by-products including honey, eggs and dairy.', '1', '2022-06-25 05:55:00', '2022-06-25 05:55:00'),
(19, ' Paraben-Free', 'public/img/icons/paraben-free.svg', 'Free of the chemical esters commonly used to preserve cosmetics and pharmaceuticals.', '1', '2022-06-25 05:57:27', '2022-06-25 05:57:27'),
(20, 'Tree-Nut Free', 'public/img/icons/tree-nut-free.svg', 'Does not contain include almonds, Brazil nuts, cashews, chestnuts, filberts/hazelnuts, macadamia nuts, pecans, pistachios, and walnuts.', '1', '2022-06-25 11:47:27', '2022-06-25 11:47:27'),
(21, 'Halal Certified', 'public/img/icons/halal-certified.svg', 'Products allowed under Islamic dietary guidelines and do not contain any pork by-products.', '1', '2022-07-04 11:45:42', '2022-07-04 11:45:42'),
(22, 'Yeast-Free', 'public/img/icons/yeast-free.svg', 'Products marked yeast-free do not contain any yeast.', '1', '2022-07-04 11:45:42', '2022-07-04 11:45:42'),
(23, 'Sugar-Free', 'public/img/icons/sugar-free.svg', 'Products less than .5 grams of sugar per serving and are usually sweetened with a sugar substitute.', '1', '2022-07-04 11:51:09', '2022-07-04 11:51:09'),
(24, 'Corn Free', 'public/img/icons/alcohol-free.svg', 'Product ingredients do not include corn or any products derived from corn.', '1', '2022-07-04 11:51:09', '2022-07-04 11:51:09'),
(25, 'Starch Free', 'public/img/icons/starch-free.svg', 'Does not contain polysaccharides or carbohydrates consisting of a large number of glucose units. ', '1', '2022-07-04 11:52:19', '2022-07-04 11:52:19'),
(26, 'Non-GMO', 'public/img/icons/non-gmo.svg', 'Products that are Non-GMO Project Verified are free of genetically modified organisms.', '1', '2022-07-06 10:29:54', '2022-07-06 10:29:54'),
(27, '100% Natural', 'public/img/icons/100-natural.svg', 'Products that contain 100% naturally-sourced ingredients and no synthetics.', '1', '2022-07-06 10:29:54', '2022-07-06 10:29:54'),
(28, 'Phthalate-Free', 'public/img/icons/phthalate-free.svg', 'Product does not contain chemical plasticizers.', '1', '2022-07-06 15:03:03', '2022-07-06 15:03:03'),
(29, 'FSA Eligible', 'public/img/icons/fsa-eligible.svg', 'Flexible Spending Account allow employees to set aside pre-tax money from their pay for medical expenses. ', '1', '2022-07-13 15:21:27', '2022-07-13 15:21:27'),
(30, 'Nut-Free', 'public/img/icons/nut-free.svg', 'Contains no nuts and is not manufactured in a facility that processes nuts of any kind.', '1', '2022-07-13 15:21:27', '2022-07-13 15:21:27');

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

--
-- Table structure for table `supplement_terms`
--

CREATE TABLE `supplement_terms` (
  `id` int(11) NOT NULL,
  `name` text NOT NULL,
  `status` enum('0','1') NOT NULL DEFAULT '1' COMMENT '''0''-inactive,''1''-active',
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `supplement_terms`
--

INSERT INTO `supplement_terms` (`id`, `name`, `status`, `updated_at`, `created_at`) VALUES
(1, '*Daily Value Not Established.', '1', '2022-07-05 15:44:05', '2022-07-05 15:44:05'),
(2, '†Percent Daily Values are based on a 2,000 calorie diet. Your diet values may be higher or lower depending on your calorie needs.', '1', '2022-07-05 15:44:05', '2022-07-05 15:44:05');

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

--
-- Table structure for table `user_shippings`
--

CREATE TABLE `user_shippings` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `first_name` varchar(150) DEFAULT NULL,
  `last_name` varchar(150) DEFAULT NULL,
  `address` varchar(250) DEFAULT NULL,
  `apartment` varchar(250) DEFAULT NULL,
  `phone` varchar(100) DEFAULT NULL,
  `city` varchar(100) DEFAULT NULL,
  `country` int(11) DEFAULT NULL,
  `state` varchar(200) DEFAULT NULL,
  `zipcode` varchar(100) DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `roles`
--
ALTER TABLE `roles`
  ADD PRIMARY KEY (`role_id`);

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `brands`
--
ALTER TABLE `brands`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=38;

--
-- AUTO_INCREMENT for table `categories`
--
ALTER TABLE `categories`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=141;

--
-- AUTO_INCREMENT for table `category_product`
--
ALTER TABLE `category_product`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `contacts`
--
ALTER TABLE `contacts`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `countries`
--
ALTER TABLE `countries`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=240;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `orders`
--
ALTER TABLE `orders`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `order_details`
--
ALTER TABLE `order_details`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `pages`
--
ALTER TABLE `pages`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `products`
--
ALTER TABLE `products`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `product_images`
--
ALTER TABLE `product_images`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;

--
-- AUTO_INCREMENT for table `product_specialities`
--
ALTER TABLE `product_specialities`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=233;

--
-- AUTO_INCREMENT for table `product_supplements`
--
ALTER TABLE `product_supplements`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=36;

--
-- AUTO_INCREMENT for table `roles`
--
ALTER TABLE `roles`
  MODIFY `role_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `specialities`
--
ALTER TABLE `specialities`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31;

--
-- AUTO_INCREMENT for table `supplement_terms`
--
ALTER TABLE `supplement_terms`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `user_shippings`
--
ALTER TABLE `user_shippings`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
COMMIT;

