--
-- Host: 127.0.0.1    Database: gojek_order
-- ------------------------------------------------------


--
-- Table structure for table `cuisines`
--

CREATE TABLE `cuisines` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `store_type_id` int(10) unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint(4) NOT NULL,
  `company_id` int(10) unsigned NOT NULL,
  `created_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` int(10) unsigned DEFAULT NULL,
  `modified_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `modified_by` int(10) unsigned DEFAULT NULL,
  `deleted_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_by` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `cuisines_store_type_id_foreign` (`store_type_id`),
  CONSTRAINT `cuisines_store_type_id_foreign` FOREIGN KEY (`store_type_id`) REFERENCES `store_types` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cuisines`
--

INSERT INTO `cuisines` VALUES (1,1,'North Indian Foods',1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,1,'South Indian Foods',1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,1,'American Foods',1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,1,'Arabian Foods',1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,1,'Bakers',1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,1,'Asian',1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,1,'African Food',1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,2,'Beverages',1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,2,'Dairy',1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10,3,'Bacon Beer Cornbread',1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(11,3,'Boozy Sausage',1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(12,3,'Chips and Guac',1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(13,3,'Cheez Its Boxed Wine',1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(14,3,'Tandoori Chicken Bites',1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(15,3,'Cheese Stuffed Chicken ',1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(16,3,'French Fries and Potato Chips',1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(17,3,'Tandoori Chicken',1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(18,3,'Paneer Tikka',1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(19,3,'Chicken wing',1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `store_addons`
--

CREATE TABLE `store_addons` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `store_id` int(10) unsigned NOT NULL,
  `company_id` int(10) unsigned NOT NULL,
  `addon_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `addon_status` tinyint(4) NOT NULL,
  `created_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` int(10) unsigned DEFAULT NULL,
  `modified_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `modified_by` int(10) unsigned DEFAULT NULL,
  `deleted_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_by` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `store_addons_store_id_foreign` (`store_id`),
  CONSTRAINT `store_addons_store_id_foreign` FOREIGN KEY (`store_id`) REFERENCES `stores` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `store_addons`
--

INSERT INTO `store_addons` VALUES (1,1,1,'Onion',1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,1,1,'Sauce',1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,1,1,'Mayonnaise',1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,2,1,'Onion',1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,2,1,'Mayonnaise',1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,2,1,'Sauce',1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,4,1,'Cheese',1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,3,1,'Sause',1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,6,1,'Onion',1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10,6,1,'Sauce',1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(11,2,1,'Cheese',1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(12,2,1,'Cheese',1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `store_cards`
--

CREATE TABLE `store_cards` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `store_id` int(10) unsigned NOT NULL,
  `last_four` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `card_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `company_id` int(10) unsigned NOT NULL,
  `brand` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_default` int(11) NOT NULL DEFAULT '0',
  `created_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` int(10) unsigned DEFAULT NULL,
  `modified_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `modified_by` int(10) unsigned DEFAULT NULL,
  `deleted_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_by` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `store_cards_store_id_foreign` (`store_id`),
  CONSTRAINT `store_cards_store_id_foreign` FOREIGN KEY (`store_id`) REFERENCES `stores` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `store_cards`
--


--
-- Table structure for table `store_cart_item_addons`
--

CREATE TABLE `store_cart_item_addons` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `store_cart_item_id` int(10) unsigned NOT NULL,
  `store_item_addons_id` int(10) unsigned NOT NULL,
  `store_cart_id` int(10) unsigned NOT NULL,
  `store_addon_id` int(10) unsigned DEFAULT NULL,
  `addon_price` decimal(10,2) NOT NULL DEFAULT '0.00',
  `company_id` int(10) unsigned NOT NULL,
  `created_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` int(10) unsigned DEFAULT NULL,
  `modified_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `modified_by` int(10) unsigned DEFAULT NULL,
  `deleted_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_by` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `store_cart_item_addons_store_cart_item_id_foreign` (`store_cart_item_id`),
  KEY `store_cart_item_addons_store_cart_id_foreign` (`store_cart_id`),
  KEY `store_cart_item_addons_store_item_addons_id_foreign` (`store_item_addons_id`),
  CONSTRAINT `store_cart_item_addons_store_cart_id_foreign` FOREIGN KEY (`store_cart_id`) REFERENCES `store_carts` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `store_cart_item_addons_store_cart_item_id_foreign` FOREIGN KEY (`store_cart_item_id`) REFERENCES `store_items` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `store_cart_item_addons_store_item_addons_id_foreign` FOREIGN KEY (`store_item_addons_id`) REFERENCES `store_item_addons` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `store_cart_item_addons`
--


--
-- Table structure for table `store_carts`
--

CREATE TABLE `store_carts` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL,
  `store_item_id` int(10) unsigned NOT NULL,
  `store_id` int(10) unsigned NOT NULL,
  `store_order_id` int(10) unsigned DEFAULT NULL,
  `company_id` int(10) unsigned NOT NULL,
  `quantity` double(8,2) NOT NULL DEFAULT '0.00',
  `item_price` double(8,2) NOT NULL DEFAULT '0.00',
  `total_item_price` double(8,2) NOT NULL DEFAULT '0.00',
  `tot_addon_price` double(8,2) NOT NULL DEFAULT '0.00',
  `note` text COLLATE utf8mb4_unicode_ci,
  `product_data` longtext COLLATE utf8mb4_unicode_ci,
  `created_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` int(10) unsigned DEFAULT NULL,
  `modified_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `modified_by` int(10) unsigned DEFAULT NULL,
  `deleted_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_by` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `store_carts_store_item_id_foreign` (`store_item_id`),
  CONSTRAINT `store_carts_store_item_id_foreign` FOREIGN KEY (`store_item_id`) REFERENCES `store_items` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `store_carts`
--

INSERT INTO `store_carts` VALUES (1,31,24,14,NULL,1,1.00,95.00,95.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-20 12:46:23','2020-11-20 12:46:23',NULL),(2,31,25,14,NULL,1,1.00,49.50,49.50,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-20 12:46:36','2020-11-20 12:46:36',NULL);

--
-- Table structure for table `store_categories`
--

CREATE TABLE `store_categories` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `store_id` int(10) unsigned NOT NULL,
  `company_id` int(10) unsigned NOT NULL,
  `store_category_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `store_category_description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `picture` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `store_category_status` tinyint(4) NOT NULL,
  `created_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` int(10) unsigned DEFAULT NULL,
  `modified_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `modified_by` int(10) unsigned DEFAULT NULL,
  `deleted_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_by` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `store_categories_store_id_foreign` (`store_id`),
  CONSTRAINT `store_categories_store_id_foreign` FOREIGN KEY (`store_id`) REFERENCES `stores` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=68 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `store_categories`
--

INSERT INTO `store_categories` VALUES (1,1,1,'Veg','Vegetarian',NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,1,1,'Non-Vegetarian','Non-Vegetarian',NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,2,1,'Non-Vegetarian','Non-Vegetarian',NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,3,1,'Vegetarian','Vegetarian',NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,4,1,'Burger','Yummy',NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,14,1,'Beverages','Cool Drinks',NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,14,1,'Breakfast and cereal','Breakfast',NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,14,1,'Flowers','Flowers',NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,15,1,'Diary','Diary',NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10,15,1,'Meat','Meat',NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(11,15,1,'Pantry','Pantry',NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(12,16,1,'Bakery','Bakery',NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(13,16,1,'Frozen','Frozen',NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(14,16,1,'HouseHold','HouseHold',NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(15,28,1,'Same Day Flowers','Same Day Flowers',NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(16,28,1,'Birthday','Wishes',NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(17,28,1,'Occasions','Occasions',NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(18,5,1,'Rice','Rice',NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(19,6,1,'Veg','Vegetarian',NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(20,23,1,'Wine','Wines with high acidity taste tart and zesty. Red wines have more tart fruit characteristics (versus “sweet fruitâ€). White wines are often described with characteristics similar to lemon or lime juice.',NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(21,23,1,'Vodka','Vodka is the most common distilled spirit found in cocktails and mixed drinks and it is essential to every bar. Its popularity comes from the general characteristic that it has no discernible or distinct flavor or smell and it is often clear.',NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(22,23,1,'Gin','Gin is a colorless spirit obtained by distilling an aqueous mixture of alcohol together with aromatic plant materials, generally juniper berries (Juniperus communis L.), to which water and alcohol and at times fruit juices, extracts, and/or essential oils',NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(23,7,1,'Non-Veg','Non-Vegetarian',NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(24,29,1,'Roses','Aromatic Roses',NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(25,29,1,'Premium Flowers','Fresh Flowers',NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(26,29,1,'Flowers N Cakes','Fresh Flowers and cakes',NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(27,24,1,'Beer','beer – formerly known as “Bass Finestâ€ – pours a ruby colour with a white, thinnish head. The nose is quite subdued, with nettle and light malt notes and a nutty character. On the palate it is quite fresh and fruity, with moderate bitterness and a',NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(28,24,1,'Whisky','Kentucky- Smooth and approachable with an easy finish, a true contrast to hot, harsh whiskies that \"blow your ears off\" and a downright revolutionary idea at the time. Maker\'s Mark is made slowly in small batches, in our National Historic Landmark distill',NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(29,26,1,'Brandy','One of the most distinctive qualities of E & J Brandy is its remarkable character. This is accomplished by vertical blending of brandies of different ages from the finest white oak barrels. This aging process also develops the full and natural brandy flav',NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(30,26,1,'Tequila','Tequila is a popular distilled spirit that is rich in history, far beyond the popular margarita or tequila shot. Originally used during rituals beginning 2,000 years ago, tequila has evolved into the potent spirit we drink today. In recent years, it has t',NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(31,27,1,'Rum','Barbados- Made in the spirit of traditional Caribbean flavored rums and filled with the fresh, natural taste of coconut, this smooth-drinking rum infuses any drink with a taste of the tropics. Perfect on its own or as a refreshing splash in any rum-based',NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(32,27,1,'Bacardi Limon','The original modern icon from Bacardi. It\'s chic, adult, innovative, and desirable. Bacardi has crafted Limon in honor of the long-lasting tradition of drinking BACARDI rums on the rocks with lime.',NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(33,25,1,'Spirits','Crystal clear, pure ultra premium. Light, fresh spirits is a favorite of connoisseurs worldwide. Smooth, soft, light tequila. The perfect ingredient in special margaritas or mixed cocktails, neat or on the rocks.',NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(34,25,1,'Bourbon','The dry, clean flavor is mellow and spice with rye, not hot in the throat. This 90-proof Kentucky bourbon delivers a wonderfully complex taste with hints of vanilla and honey and a long smoky finish.',NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(35,23,1,'Beer','beer – formerly known as “Bass Finestâ€ – pours a ruby colour with a white, thinnish head. The nose is quite subdued, with nettle and light malt notes and a nutty character. On the palate it is quite fresh and fruity, with moderate bitterness and a',NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(36,24,1,'Scotch','The original Walker family blend, handcrafted from as many as 40 of the finest Scotch whiskies aged a minimum of 12 years, for a smooth and robust blend. Rich smoky malt, peat and sherry fruit character deliver a satisfyingly complex flavor on the long, l',NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(37,8,1,'Veg','Vegetarian',NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(38,8,1,'Non-Veg','Non-Vegetarian',NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(39,9,1,'Veg','Vegetarian',NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(40,10,1,'Veg','Vegetarian',NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(41,10,1,'Non-Veg','Non-Vegetarian',NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(42,11,1,'Non-Veg','Non-vegetarian',NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(43,30,1,'Roses','A small token of endless  love as roses bunch to gratify the person you wish to',NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(44,30,1,'Carnations','Dianthus caryophyllus, Pink carnations have the most symbolic and historical significance. Acco... ',NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(45,31,1,'Gerberas','Bunch of  Mix Color Flowers.',NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(46,31,1,'Mix Flowers','A Colourful wish of 20 mixed Flowers',NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(47,32,1,'Flowers By Colors','Various colors of flowers',NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(48,32,1,'Flowers By Combo','Various Combos of flowers.',NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(49,33,1,'Flowers By Design','Bundly of lovely designs',NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(50,33,1,'Flowers By Price','Lower and higher price flowers',NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(51,34,1,'Orchids','most highly evolved of all flowering plants.',NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(52,34,1,'Lilies','really excellent plants for beds and borders. Lilies are suitable for use in a shrub border, as accent plants, a formal or naturalized pool planting',NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(53,17,1,'Beverages','A drink is a liquid intended for human consumption. In addition to their basic function of satisfying thirst, drinks play important roles in human culture',NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(54,17,1,'Bread/Bakery','Bakery products, particularly bread, have a long history of development. The biochemistry of the main components of wheat flour (proteins, carbohydrates, and lipids) are presented and discussed with a focus on those properties relevant to the baking indus',NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(55,17,1,'Staples','Products purchased regularly and out of necessity are considered \"staple goods\" to your store. Traditionally, these items have fewer markdowns and sometimes lower profit margins. While price shifts may raise or lower demand for certain kinds of products,',NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(56,18,1,'Dairy','Dairy products, milk products or lacticinia are a type of food produced from or containing the milk of mammals. They are primarily produced from mammals such as cattle, water buffaloes, goats, sheep, camels and humans',NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(57,18,1,'Dry/Baking Goods','Baked goods are cooked by baking, a method ofcooking food that uses prolonged dry heat, normally in an oven, but also in hot ashes, or on hot stones. The most common baked item is bread but many other types of foods are baked as well.',NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(58,19,1,'Chocolates & Sweets','Candy, also called sweets or lollies, is a confection that features sugar as a principal ingredient. The category, called sugar confectionery, encompasses any sweet confection, including chocolate, chewing gum, and sugar candy',NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(59,19,1,'Soft Drinks','The sweetener may be a sugar, high-fructose corn syrup, fruit juice, a sugar substitute (in the case of diet drinks), or some combination of these. Soft drinks may also contain caffeine, colorings, preservatives, and/or other ingredients. Soft drinks are',NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(60,19,1,'Packaged food','The majority of your diet should still be made up of real, whole foods—think vegetables, fruits, whole grains, proteins. Packaged foods get a bad rap for their long ingredient lists, trans fats and sodium, but not all packaged foods are created equal',NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(61,20,1,'Dals and Pulses','Dal is a term used in the Indian subcontinent for dried, split pulses. The term is also used for various soups prepared from these pulses. These pulses are among the most important staple foods in South Asian countries, and form an important part of the c',NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(62,20,1,'Pickles & Chutney','Some pickles and chutneys in India has been passed over to commercial production, whereas at one time it was done entirely in people\'s homes. The disadvantage of commercial chutneys and those produced in western style with vinegar and large amounts of sug',NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(63,20,1,'Ketchups & Spreads','Ketchup is a sauce used as a condiment. Originally, recipes used egg whites, mushrooms, oysters, mussels, or walnuts, among other ingredients,but now the unmodified term usually refers to tomato ketchup. Various other terms for the sauce include catsup, c',NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(64,21,1,'Masalas & Spices','masala is a spice mixture that has been ground into a powder or paste used for cooking Indian food, or a dish flavored with this powder.',NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(65,21,1,'Dry Fruits, Nuts & Seeds','Dried fruit is fruit from which the majority of the original water content has been removed either naturally, through sun drying, or through the use of specialized dryers or dehydrators. A nut is a fruit composed of an inedible hard shell and aseed, which',NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(66,21,1,'Health Drink Mix','water topped the list, but that doesn\'t mean it\'s the only healthy choice. Unsweetened tea, coffee and milk have a place in your healthy eating plan, while juice, alcohol and sweetened beverages should be consumed sparingly. Water helps restore fluid loss',NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(67,2,1,'Snacks','sszcxsds',NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `store_cities`
--

CREATE TABLE `store_cities` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `admin_service` enum('TRANSPORT','ORDER','SERVICE') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `country_id` int(10) unsigned NOT NULL,
  `city_id` int(10) unsigned NOT NULL,
  `company_id` int(10) unsigned NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '1',
  `created_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` int(10) unsigned DEFAULT NULL,
  `modified_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `modified_by` int(10) unsigned DEFAULT NULL,
  `deleted_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_by` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `store_cities`
--

INSERT INTO `store_cities` VALUES (1,'ORDER',101,3659,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'ORDER',1,5963,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,'ORDER',13,6571,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,'ORDER',18,7291,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,'ORDER',38,10449,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,'ORDER',44,11182,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,'ORDER',75,17726,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,'ORDER',102,21497,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,'ORDER',103,21776,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10,'ORDER',109,25084,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(11,'ORDER',111,25174,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(12,'ORDER',113,25506,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(13,'ORDER',132,26962,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(14,'ORDER',142,28173,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(15,'ORDER',160,30697,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(16,'ORDER',181,36746,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(17,'ORDER',196,37570,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(18,'ORDER',202,38074,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(19,'ORDER',207,38956,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(20,'ORDER',213,39618,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(21,'ORDER',229,41406,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(22,'ORDER',230,42234,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(23,'ORDER',231,48294,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `store_city_prices`
--

CREATE TABLE `store_city_prices` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `admin_service` enum('TRANSPORT','ORDER','SERVICE') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `store_type_id` int(10) unsigned NOT NULL,
  `country_id` int(10) unsigned DEFAULT NULL,
  `city_id` int(10) unsigned NOT NULL,
  `company_id` int(10) unsigned NOT NULL,
  `delivery_charge` decimal(10,2) NOT NULL DEFAULT '0.00',
  `status` tinyint(4) NOT NULL DEFAULT '1',
  `created_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` int(10) unsigned DEFAULT NULL,
  `modified_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `modified_by` int(10) unsigned DEFAULT NULL,
  `deleted_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_by` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `store_city_prices`
--

INSERT INTO `store_city_prices` VALUES (1,'ORDER',1,50,3659,1,50.00,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'ORDER',1,50,5963,1,50.00,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,'ORDER',1,50,6571,1,50.00,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,'ORDER',1,50,7291,1,50.00,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,'ORDER',1,50,10449,1,50.00,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,'ORDER',1,50,11182,1,50.00,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,'ORDER',1,50,17726,1,50.00,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,'ORDER',1,50,21497,1,50.00,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,'ORDER',1,50,21776,1,50.00,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10,'ORDER',1,50,25084,1,50.00,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(11,'ORDER',1,50,25174,1,50.00,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(12,'ORDER',1,50,25506,1,50.00,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(13,'ORDER',1,50,26962,1,50.00,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(14,'ORDER',1,50,28173,1,50.00,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(15,'ORDER',1,50,30697,1,50.00,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(16,'ORDER',1,50,36746,1,50.00,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(17,'ORDER',1,50,37570,1,50.00,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(18,'ORDER',1,50,38074,1,50.00,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(19,'ORDER',1,50,38956,1,50.00,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(20,'ORDER',1,50,39618,1,50.00,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(21,'ORDER',1,50,41406,1,50.00,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(22,'ORDER',1,50,42234,1,50.00,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(23,'ORDER',1,50,48294,1,50.00,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `store_cuisines`
--

CREATE TABLE `store_cuisines` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `store_type_id` int(10) unsigned DEFAULT NULL,
  `store_id` int(10) unsigned DEFAULT NULL,
  `cuisines_id` int(10) unsigned DEFAULT NULL,
  `company_id` int(10) unsigned DEFAULT NULL,
  `created_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` int(10) unsigned DEFAULT NULL,
  `modified_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `modified_by` int(10) unsigned DEFAULT NULL,
  `deleted_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_by` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `store_cuisines_store_type_id_foreign` (`store_type_id`),
  KEY `store_cuisines_store_id_foreign` (`store_id`),
  KEY `store_cuisines_cuisines_id_foreign` (`cuisines_id`),
  CONSTRAINT `store_cuisines_cuisines_id_foreign` FOREIGN KEY (`cuisines_id`) REFERENCES `cuisines` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `store_cuisines_store_id_foreign` FOREIGN KEY (`store_id`) REFERENCES `stores` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `store_cuisines_store_type_id_foreign` FOREIGN KEY (`store_type_id`) REFERENCES `store_types` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `store_cuisines`
--

INSERT INTO `store_cuisines` VALUES (1,1,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,1,1,2,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,1,1,3,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,1,1,5,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,1,1,6,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,1,5,6,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,1,6,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,1,6,2,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,1,6,3,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10,1,7,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(11,1,7,2,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(12,1,8,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(13,1,8,2,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(14,1,9,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(15,1,9,2,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(16,1,10,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(17,1,10,2,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(18,1,11,3,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(19,1,11,5,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(20,1,12,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(21,1,3,5,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(22,1,2,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(23,1,4,3,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(24,1,13,7,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `store_item_addons`
--

CREATE TABLE `store_item_addons` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `store_id` int(10) unsigned NOT NULL,
  `store_item_id` int(10) unsigned NOT NULL,
  `store_addon_id` int(10) unsigned NOT NULL,
  `price` double(8,2) NOT NULL,
  `company_id` int(10) unsigned NOT NULL,
  `created_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` int(10) unsigned DEFAULT NULL,
  `modified_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `modified_by` int(10) unsigned DEFAULT NULL,
  `deleted_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_by` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `store_item_addons_store_id_foreign` (`store_id`),
  KEY `store_item_addons_store_item_id_foreign` (`store_item_id`),
  KEY `store_item_addons_store_addon_id_foreign` (`store_addon_id`),
  CONSTRAINT `store_item_addons_store_addon_id_foreign` FOREIGN KEY (`store_addon_id`) REFERENCES `store_addons` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `store_item_addons_store_id_foreign` FOREIGN KEY (`store_id`) REFERENCES `stores` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `store_item_addons_store_item_id_foreign` FOREIGN KEY (`store_item_id`) REFERENCES `store_items` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `store_item_addons`
--

INSERT INTO `store_item_addons` VALUES (1,1,6,2,5.00,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,1,1,1,10.00,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,1,1,2,10.00,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,1,1,3,10.00,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,1,9,1,5.00,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,1,10,1,5.00,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,1,10,2,5.00,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,1,11,1,5.00,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,1,11,2,5.00,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10,1,11,3,5.00,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(11,1,12,1,5.00,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(12,2,2,5,5.00,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(13,2,2,6,5.00,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(14,2,14,6,5.00,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(15,2,18,4,5.00,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(16,2,18,6,5.00,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(17,4,3,7,3.00,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(18,1,5,2,3.00,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(19,2,16,4,20.00,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(20,6,56,9,10.00,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(21,6,57,9,15.00,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(22,6,58,9,10.00,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(23,6,59,9,10.00,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(24,6,60,9,10.00,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(25,6,61,9,10.00,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(26,6,62,9,10.00,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(27,6,63,9,10.00,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(28,6,64,9,10.00,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(29,6,65,9,10.00,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(30,1,66,1,20.00,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(31,1,67,1,10.00,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(32,2,68,4,10.00,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(33,2,68,5,10.00,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(34,2,69,4,10.00,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(35,2,69,6,10.00,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(36,2,70,4,10.00,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(37,2,70,6,10.00,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(38,2,71,4,10.00,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(39,2,71,5,12.00,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `store_items`
--

CREATE TABLE `store_items` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `store_id` int(10) unsigned NOT NULL,
  `company_id` int(10) unsigned NOT NULL,
  `item_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `item_description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `picture` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `store_category_id` int(10) unsigned NOT NULL,
  `is_veg` enum('Pure Veg','Non Veg') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `item_price` decimal(10,2) NOT NULL DEFAULT '0.00',
  `item_discount` decimal(10,2) NOT NULL DEFAULT '0.00',
  `item_discount_type` enum('PERCENTAGE','AMOUNT') COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_addon` tinyint(4) NOT NULL DEFAULT '0',
  `status` tinyint(4) NOT NULL DEFAULT '1',
  `created_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` int(10) unsigned DEFAULT NULL,
  `modified_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `modified_by` int(10) unsigned DEFAULT NULL,
  `deleted_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_by` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `store_items_store_id_foreign` (`store_id`),
  KEY `store_items_store_category_id_foreign` (`store_category_id`),
  CONSTRAINT `store_items_store_category_id_foreign` FOREIGN KEY (`store_category_id`) REFERENCES `store_categories` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `store_items_store_id_foreign` FOREIGN KEY (`store_id`) REFERENCES `stores` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=182 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `store_items`
--

INSERT INTO `store_items` VALUES (1,1,1,'Chicken 65','chicken 65','https://goxdevwebsite.mi2.in/images/order/items/chicken_65.png',0,'Non Veg',100.00,10.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,2,1,'Mexican Shawarma','Delicious!!','https://goxdevwebsite.mi2.in/images/order/items/mexican_shawarma.png',0,'Non Veg',100.00,5.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,4,1,'Chicken Fried Rice','Delicious!!','https://goxdevwebsite.mi2.in/images/order/items/chicken_fried_rice.png',0,'Non Veg',20.00,5.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,3,1,'Mango Juice','Yummy!!','https://goxdevwebsite.mi2.in/images/order/items/mango_juice.png',0,'Pure Veg',12.00,12.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,1,1,'Chicken Soup','Delicious!!','https://goxdevwebsite.mi2.in/images/order/items/chicken_soup.png',0,'Non Veg',12.00,4.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,1,1,'Chicken Briyani','Yummy!!','https://goxdevwebsite.mi2.in/images/order/items/chicken_briyani.png',0,'Non Veg',150.00,2.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,3,1,'Vanilla Milkshake','Yummy!!','https://goxdevwebsite.mi2.in/images/order/items/vanilla_milkshake.png',0,'Pure Veg',100.00,5.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,3,1,'Sweet Lassi','Yummy!!','https://goxdevwebsite.mi2.in/images/order/items/sweet_lassi.png',0,'Pure Veg',102.00,4.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,1,1,'Egg Briyani','Yummy!!','https://goxdevwebsite.mi2.in/images/order/items/egg_briyani.png',0,'Non Veg',150.00,5.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10,1,1,'Fish Fry','Delicious!!','https://goxdevwebsite.mi2.in/images/order/items/fish_fry.png',0,'Non Veg',200.00,5.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(11,1,1,'Grill Chicken','Delicious!!','https://goxdevwebsite.mi2.in/images/order/items/grill_chicken.png',0,'Non Veg',100.00,5.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(12,1,1,'Prawn Fry','Yummy!!','https://goxdevwebsite.mi2.in/images/order/items/prawn_fry.png',0,'Non Veg',200.00,5.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(13,1,1,'Veg Soup','Yummy!!','https://goxdevwebsite.mi2.in/images/order/items/veg_soup.png',0,'Pure Veg',100.00,2.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(14,2,1,'Chicken Burger','Yummy!!','https://goxdevwebsite.mi2.in/images/order/items/chicken_burger.png',0,'Non Veg',100.00,200.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(15,2,1,'Combo Pack','','https://goxdevwebsite.mi2.in/images/order/items/combo_pack.png',0,'Non Veg',200.00,4.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(16,2,1,'French Fries','Delicious!!','https://goxdevwebsite.mi2.in/images/order/items/french_fries.png',0,'Pure Veg',50.00,4.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(17,2,1,'Nuggets','Delicious!!','https://goxdevwebsite.mi2.in/images/order/items/nuggets.png',0,'Non Veg',100.00,0.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(18,2,1,'Pop-corn Chicken','Yummy!!','https://goxdevwebsite.mi2.in/images/order/items/pop-corn_chicken.png',0,'Non Veg',200.00,0.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(19,3,1,'Strawberry Shake','Yummy!!','https://goxdevwebsite.mi2.in/images/order/items/strawberry_shake.png',0,'Pure Veg',200.00,0.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(20,3,1,'Butterscotch Shake','Yummy!!','https://goxdevwebsite.mi2.in/images/order/items/butterscotch_shake.png',0,'Pure Veg',200.00,0.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(21,4,1,'Chicken Noodles','Yummy!!','https://goxdevwebsite.mi2.in/images/order/items/chicken_noodles.png',0,'Non Veg',200.00,5.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(22,4,1,'Prawn Fry','Yummy!!','https://goxdevwebsite.mi2.in/images/order/items/prawn_fry.png',0,'Non Veg',100.00,4.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(23,4,1,'Mutton Briyani','Yummy!!','https://goxdevwebsite.mi2.in/images/order/items/mutton_briyani.png',0,'Non Veg',200.00,4.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(24,14,1,'Lacroix Drinks','Drinks','https://goxdevwebsite.mi2.in/images/order/items/lacroix_drinks.png',0,'Pure Veg',100.00,5.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(25,14,1,'Cocacola','Drinks','https://goxdevwebsite.mi2.in/images/order/items/cocacola.png',0,'Pure Veg',50.00,1.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(26,14,1,'Cheerios','Cereal','https://goxdevwebsite.mi2.in/images/order/items/cheerios_.png',0,'Pure Veg',200.00,3.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(27,14,1,'Pop Tarts','Poptarts','https://goxdevwebsite.mi2.in/images/order/items/pop_tarts.png',0,'Pure Veg',36.00,5.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(28,14,1,'Belvita','Belvita','https://goxdevwebsite.mi2.in/images/order/items/belvita.png',0,'Pure Veg',200.00,5.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(29,14,1,'Quaker Oats','Quaker Oats','https://goxdevwebsite.mi2.in/images/order/items/quaker_oats.png',0,'Pure Veg',200.00,5.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(30,14,1,'Tupils Bouquet','Bouquet','https://goxdevwebsite.mi2.in/images/order/items/tupils_bouquet.png',0,'Pure Veg',50.00,5.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(31,14,1,'Red Rose Bouquet','Red Roses','https://goxdevwebsite.mi2.in/images/order/items/red_rose_bouquet.png',0,'Pure Veg',100.00,5.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(32,14,1,'Bunch Bouquet','Bouquet','https://goxdevwebsite.mi2.in/images/order/items/bunch_bouquet.png',0,'Pure Veg',100.00,4.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(33,15,1,'Marshmallow','Marshmallow','https://goxdevwebsite.mi2.in/images/order/items/marshmallow.png',0,'Pure Veg',50.00,5.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(34,15,1,'American SIngles','American SIngles','https://goxdevwebsite.mi2.in/images/order/items/american_singles.png',0,'Pure Veg',100.00,3.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(35,15,1,'Cheese','Cheese','https://goxdevwebsite.mi2.in/images/order/items/cheese.png',0,'Pure Veg',100.00,2.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(36,15,1,'Boneless Chicken','Boneless Chicken','https://goxdevwebsite.mi2.in/images/order/items/boneless_chicken.png',0,'Non Veg',400.00,3.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(37,15,1,'Meat','Meat','https://goxdevwebsite.mi2.in/images/order/items/meat.png',0,'Non Veg',100.00,3.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(38,15,1,'Tuna Salad','Tuna Salad','https://goxdevwebsite.mi2.in/images/order/items/tuna_salad.png',0,'Non Veg',200.00,3.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(39,15,1,'Ranch','Ranch','https://goxdevwebsite.mi2.in/images/order/items/ranch.png',0,'Non Veg',100.00,2.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(40,16,1,'Mini Cookies','Mini Cookies','https://goxdevwebsite.mi2.in/images/order/items/mini_cookies.png',0,'Pure Veg',200.00,3.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(41,16,1,'Sugar Cookies','Sugar Cookies','https://goxdevwebsite.mi2.in/images/order/items/sugar_cookies.png',0,'Pure Veg',200.00,4.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(42,16,1,'Strawberry Cake','Strawberry Cake','https://goxdevwebsite.mi2.in/images/order/items/strawberry_cake.png',0,'Non Veg',200.00,5.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(43,16,1,'Bacon','Bacon','https://goxdevwebsite.mi2.in/images/order/items/bacon.png',0,'Non Veg',200.00,3.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(44,16,1,'Vividly Vanilla','Vividly Vanilla','https://goxdevwebsite.mi2.in/images/order/items/vividly_vanilla.png',0,'Non Veg',200.00,3.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(45,16,1,'Air Freshener','Air Freshener','https://goxdevwebsite.mi2.in/images/order/items/air_freshener.png',0,'Non Veg',200.00,3.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(46,16,1,'Shower Cleaner','Shower Cleaner','https://goxdevwebsite.mi2.in/images/order/items/shower_cleaner.png',0,'Non Veg',200.00,2.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(47,28,1,'Floral Embrace','Floral Embrace','https://goxdevwebsite.mi2.in/images/order/items/floral_embrace.png',0,'Pure Veg',100.00,3.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(48,28,1,'Lovely Lavender Medley','Lovely Lavender Medley','https://goxdevwebsite.mi2.in/images/order/items/lovely_lavender_medley.png',0,'Pure Veg',100.00,2.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(49,28,1,'Blooming Love','Blooming Love','https://goxdevwebsite.mi2.in/images/order/items/blooming_love.png',0,'Pure Veg',100.00,2.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(50,28,1,'Wonderful Wishes Bouquet','Wonderful Wishes Bouquet','https://goxdevwebsite.mi2.in/images/order/items/wonderful_wishes_bouquet.png',0,'Pure Veg',200.00,3.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(51,28,1,'Sassy n’ Sweet','Sassy n’ Sweet','https://goxdevwebsite.mi2.in/images/order/items/sassy_n’_sweet.png',0,'Pure Veg',200.00,2.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(52,28,1,'Assorted Tulips','Assorted Tulips','https://goxdevwebsite.mi2.in/images/order/items/assorted_tulips.png',0,'Pure Veg',200.00,2.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(53,28,1,'Healing Tears Blue & White','Healing Tears Blue & White','https://goxdevwebsite.mi2.in/images/order/items/healing_tears_blue_&_white.png',0,'Pure Veg',200.00,2.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(54,28,1,'Stunning Red Rose & Calla Lily Bouquet','Stunning Red Rose & Calla Lily Bouquet','https://goxdevwebsite.mi2.in/images/order/items/stunning_red_rose_&_calla_lily_bouquet.png',0,'Pure Veg',200.00,2.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(55,5,1,'Chow King Fried Rice','10','https://goxdevwebsite.mi2.in/images/order/items/chow_king_fried_rice.png',0,'Non Veg',1000.00,10.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(56,6,1,'Krusty Burger','The fictional Simpsons hangout was so popular, it became a real-life restaurant in 2013, when Universal Studios Orlando opened a Simpsons theme park. Ironically, menu staples like the Clogger Burger and the Mother Nature Burger','https://goxdevwebsite.mi2.in/images/order/items/krusty_burger.png',0,'Pure Veg',280.00,2.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(57,6,1,'Varsity Burger','The ordering lingo for this Atlanta staple, which debuted in 1928, is almost as delicious as the burger itself: you get it “all the wayâ€ in lieu of “with onions,â€ and “walk a steakâ€ replaces “to-go.â€','https://goxdevwebsite.mi2.in/images/order/items/varsity_burger.png',0,'Pure Veg',250.00,5.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(58,6,1,'Umami Burger','It  meant to taste like, well, umami (a savory taste embodied in MSG), incorporating such toppings as soy-roasted tomatoes, parmesan crisps and pickled ginger.','https://goxdevwebsite.mi2.in/images/order/items/umami_burger.png',0,'Pure Veg',100.00,3.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(59,6,1,'Shack Burger',' The first burger to start a food craze, inspiring hordes of eaters to wait in lines that stretched throughout New York’s Madison Square Park.','https://goxdevwebsite.mi2.in/images/order/items/shack_burger.png',0,'Pure Veg',5.00,5.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(60,6,1,'Burger King Whopper','Fast food industry’s first gimmick burger—developed as a premium alternative to McDonald’s, Wendy’s and others.','https://goxdevwebsite.mi2.in/images/order/items/burger_king_whopper.png',0,'Pure Veg',100.00,5.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(61,6,1,'The 21 Burger','When the 21 Club introduced its gourmet burger in the late 1940s or early 1950s, New Yorkers were shocked that an upper-class establishment would offer something as lowly as the burger','https://goxdevwebsite.mi2.in/images/order/items/the_21_burger.png',0,'Pure Veg',100.00,5.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(62,6,1,'In-N-Out Burger','Whereas McDonald’s focused on fast, In-N-Out focused on food—its signature burger, which debuted in 1948, was made from locally sourced ground beef and fresh vegetables','https://goxdevwebsite.mi2.in/images/order/items/in-n-out_burger.png',0,'Pure Veg',100.00,5.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(63,6,1,'White Castle Slider','White Castle had 10 U.S. locations. But more importantly, the restaurant’s emphasis on cleanliness—facilities were white and customers could watch their burger meat being ground through a window','https://goxdevwebsite.mi2.in/images/order/items/white_castle_slider.png',0,'Pure Veg',350.00,100.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(64,6,1,'Gardenburger','The original veggie burger was invented in 1981 at—go figure—the Gardenhouse, an Oregon vegetarian restaurant, and it consisted mainly of leftover vegetables and grains','https://goxdevwebsite.mi2.in/images/order/items/gardenburger.png',0,'Pure Veg',350.00,5.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(65,6,1,'Quadruple Bypass Burger','The burger became an exemplar of the more-is-more burger culture, preceding a series of other gluttonous dishes including Paula Deen’s doughnut-encased Lady’s Brunch Burger.','https://goxdevwebsite.mi2.in/images/order/items/quadruple_bypass_burger.png',0,'Pure Veg',250.00,5.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(66,1,1,'Mughal Briyani','Biryani may soon be declared as the national dish in India for the fact that it is a dish which beyond cultures is a favourite among most. How it arrived in India has a lot of legendary stories.','https://goxdevwebsite.mi2.in/images/order/items/mughal_briyani.png',0,'Non Veg',100.00,5.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(67,1,1,'Hyderabadi Biryani','When we think of biryani, Hyderabadi Biryani is the first that comes to one’s mind. It was initially conceived as a dish under Asaf Jaha I, the appointed Governor of Deccan by Aurangzeb','https://goxdevwebsite.mi2.in/images/order/items/hyderabadi_biryani.png',0,'Non Veg',250.00,5.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(68,2,1,'SCOFF-EE CUP','The way you see the Britt enjoy the taste of the \"Scoff-ee Cup\" menu should say a lot to you already. It\'s a delicious recipe that you should surely try at least once before you see your deathbed.','https://goxdevwebsite.mi2.in/images/order/items/scoff-ee_cup.png',0,'Pure Veg',250.00,5.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(69,2,1,'DEEP-FRIED CORN SOUP','The deep-fried corn soup is a perfect combination of delicious and unique. That’s why the Japanese can\'t get over it.','https://goxdevwebsite.mi2.in/images/order/items/deep-fried_corn_soup.png',0,'Pure Veg',100.00,5.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(70,2,1,'VEGETABLE STRIPS','The vegetable strips caused the chicken to be ditched in the dumps because the deep-fried batter found its way around vegetables','https://goxdevwebsite.mi2.in/images/order/items/vegetable_strips.png',0,'Non Veg',100.00,5.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(71,2,1,'DIPPING FRIES','The dipping fries are hollowed-out fries that have the shape of fried potato skin. The reason why the fries are hollowed-out is to make sure all the dip you want to stay firm on the snack.','https://goxdevwebsite.mi2.in/images/order/items/dipping_fries.png',0,'Pure Veg',450.00,11.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(72,2,1,'DIPPING FRIES','The dipping fries are hollowed-out fries that have the shape of fried potato skin. The reason why the fries are hollowed-out is to make sure all the dip you want to stay firm on the snack.','https://goxdevwebsite.mi2.in/images/order/items/dipping_fries.png',0,'Pure Veg',450.00,11.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(73,3,1,'Chilled Darjeeling First Flush with Mango','Add iced water (sans the ice) to the tea to make enough for 4 glasses and also to dilute the tea which would otherwise be very intensely flavoured.','https://goxdevwebsite.mi2.in/images/order/items/chilled_darjeeling_first_flush_with_mango.png',0,'Pure Veg',75.00,5.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(74,3,1,'Milk Thandai Recipe','For a larger batch of the spice mix, dry grind and keep in an airtight container, refrigerated for a few days. You can also alter the quantities to suit your personal taste and preference.','https://goxdevwebsite.mi2.in/images/order/items/milk_thandai_recipe.png',0,'Pure Veg',45.00,5.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(75,3,1,'Spinach Dip Recipe','Add nutmeg and salt to taste. Let the mixture cool down and put in blender and grind for desired consistency.','https://goxdevwebsite.mi2.in/images/order/items/spinach_dip_recipe.png',0,'Pure Veg',50.00,4.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(76,3,1,'Irish Coffee','Whip the cream until the bubbles disappear and it has just started to thicken and form ribbons underneath the whisk. Put back in the refrigerator.','https://goxdevwebsite.mi2.in/images/order/items/irish_coffee.png',0,'Pure Veg',35.00,5.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(77,3,1,'Fruit Infused Tea Recipe','Test','https://goxdevwebsite.mi2.in/images/order/items/fruit_infused_tea_recipe.png',0,'Pure Veg',10.00,5.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(78,4,1,'Portugese Fish Stew Recipe','This Portugese fish stew is an easy and simple recipe to prepare for a brunch or light side dish for dinner. Potatoes, fish fillet, shrimps, few veggies along with white wine and spices come together to form this delicious stew that you can serve with coo','https://goxdevwebsite.mi2.in/images/order/items/portugese_fish_stew_recipe.png',0,'Pure Veg',350.00,5.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(79,29,1,'Vivid-Red Rose Bouquet','Roses','https://goxdevwebsite.mi2.in/images/order/items/vivid-red_rose_bouquet.png',0,'Pure Veg',200.00,2.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(80,29,1,'Endearing 8 Pink Roses Bouquet','Roses','https://goxdevwebsite.mi2.in/images/order/items/endearing_8_pink_roses_bouquet.png',0,'Pure Veg',200.00,3.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(81,29,1,'Pristine White Roses Bunch','Roses','https://goxdevwebsite.mi2.in/images/order/items/pristine_white_roses_bunch.png',0,'Pure Veg',200.00,2.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(82,29,1,'Royal- Forever Blue Rose in Velvet Box','Roses','https://goxdevwebsite.mi2.in/images/order/items/royal-_forever_blue_rose_in_velvet_box.png',0,'Pure Veg',496.00,2.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(83,7,1,'Korean Fried Chicken','This dish was traditionally eaten on the eve of the lunar new year as the people at that time felt that they had to get rid of all of their leftover side dishes before the new year. It is listed at number 40 on the World’s 50 Most Delicious Food Readers','https://goxdevwebsite.mi2.in/images/order/items/korean_fried_chicken.png',0,'Non Veg',95.00,0.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(84,29,1,'Roses-orchids-vase-arrangement','roses-orchids-vase-arrangement','https://goxdevwebsite.mi2.in/images/order/items/roses-orchids-vase-arrangement.png',0,'Pure Veg',1500.00,2.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(85,29,1,'Beautiful Box Of Roses','Beautiful Box Of Roses','https://goxdevwebsite.mi2.in/images/order/items/beautiful_box_of_roses.png',0,'Pure Veg',200.00,2.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(86,7,1,'Korean Fried Chicken Wings','double-fried with one of two secret sauces. Despite Bonchon’s growing presence around the world, our name ensures we never lose sight of our roots.','https://goxdevwebsite.mi2.in/images/order/items/korean_fried_chicken_wings.png',0,'Non Veg',100.00,0.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(87,29,1,'Symphony Of Orange Roses','Symphony Of Orange Roses','https://goxdevwebsite.mi2.in/images/order/items/symphony_of_orange_roses.png',0,'Pure Veg',400.00,4.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(88,29,1,'Yellow Roses Bouquet & Black Forest Cake','Yellow Roses Bouquet & Black Forest Cake','https://goxdevwebsite.mi2.in/images/order/items/yellow_roses_bouquet_&_black_forest_cake.png',0,'Pure Veg',2000.00,2.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(89,29,1,'Red Roses & Pineapple Cake Combo','Red Roses & Pineapple Cake Combo','https://goxdevwebsite.mi2.in/images/order/items/red_roses_&_pineapple_cake_combo.png',0,'Pure Veg',1000.00,2.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(90,7,1,'French Fries Chicken','Bonchon is a franchise specialized in Korean-style fried chicken with a variety of savory Asian fusion dishes and Korean specialties. Bonchon was born in Busan, South Korea and is raised in the heart of New York City','https://goxdevwebsite.mi2.in/images/order/items/french_fries_chicken.png',0,'Non Veg',100.00,0.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(91,7,1,'BonChon Chicken Bangkok','BonChon Chicken is a global chain that spread through Korea and the USA before making its way back to Asia on the merits of its crispy, Korean-style fried chicken','https://goxdevwebsite.mi2.in/images/order/items/bonchon_chicken_bangkok.png',0,'Non Veg',250.00,0.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(92,23,1,'Red Wine','Summer is right around the corner! Looking for the best reds to take on your upcoming trips? These wines won\'t disappoint.','https://goxdevwebsite.mi2.in/images/order/items/red_wine.png',0,'Non Veg',350.00,3.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(93,23,1,'White Wine','You don’t have to spend a ton to impress your guests. We have plenty of highly rated white wines.','https://goxdevwebsite.mi2.in/images/order/items/white_wine.png',0,'Non Veg',500.00,5.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(94,23,1,'Tower Vodka','This vodka proves that a top-shelf vodka doesn\'t always need a top-shelf price. Gluten-free, made from corn and distilled 6 times for a clean, crisp mouth feel with a silky smooth finish. Only 96 calories per serving! Double Gold -Seattle Spirits Comp; SF','https://goxdevwebsite.mi2.in/images/order/items/tower_vodka.png',0,'Non Veg',490.00,2.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(95,23,1,'Tito\'s Handmade Vodka','Designed to be savored by spirit connoisseurs. Micro-distilled in an old-fashioned pot still to provide more control over the distillation process and resulting in a spectacularly clean product. Only the heart of the run is taken, leaving behind residual','https://goxdevwebsite.mi2.in/images/order/items/tito\'s_handmade_vodka.png',0,'Non Veg',450.00,0.00,'AMOUNT',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(96,23,1,'Tanqueray Gin','Crafted using a time honored recipe of only the highest quality grains, the purest water, the most select juniper berries, finest botanicals, and a unique quadruple-distillation process.','https://goxdevwebsite.mi2.in/images/order/items/tanqueray_gin_.png',0,'Non Veg',350.00,0.00,'AMOUNT',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(97,23,1,'Hendricks Gin','Made in small batches with a fully restored 19th-centrury Carter-Head Still, which \"bathes\" the ingredients in vapors instead of boiling, producing a smoother gin. A unique blend of botanicals, including Bulgarian Rose petal and cucumber. Kosher Certified','https://goxdevwebsite.mi2.in/images/order/items/hendricks_gin.png',0,'Non Veg',590.00,0.00,'AMOUNT',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(98,23,1,'Craft Beer','Canned beers are lighter than bottles, unbreakable and keep summer’s brightest sunshine from funk-i-fying the brew inside. Bring canned beers with you on all of your fun, summer adventures.','https://goxdevwebsite.mi2.in/images/order/items/craft_beer.png',0,'Non Veg',290.00,0.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(99,23,1,'Import Beer','Designed to be savored by spirit connoisseurs. Micro-distilled in an old-fashioned pot still to provide more control over the distillation process and resulting in a spectacularly clean product. Only the heart of the run is taken, leaving behind residual','https://goxdevwebsite.mi2.in/images/order/items/import_beer.png',0,'Non Veg',350.00,2.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(100,24,1,'Import Beer','Designed to be savored by spirit connoisseurs. Micro-distilled in an old-fashioned pot still to provide more control over the distillation process and resulting in a spectacularly clean product. Only the heart of the run is taken, leaving behind residual','https://goxdevwebsite.mi2.in/images/order/items/import_beer.png',0,'Non Veg',400.00,0.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(101,24,1,'Craft Beer','Canned beers are lighter than bottles, unbreakable and keep summer’s brightest sunshine from funk-i-fying the brew inside. Bring canned beers with you on all of your fun, summer adventures.','https://goxdevwebsite.mi2.in/images/order/items/craft_beer.png',0,'Non Veg',350.00,0.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(102,24,1,'Jameson Irish Whiskey','Wine Enthusiast -Ireland- A pot still whiskey blended of light and medium flavored whiskies that were triple distilled for exceptional smoothness. Matured in Bourbon and Sherry casks to produce a crisp, clean, mellow taste with sweet, spicy, vanilla tones','https://goxdevwebsite.mi2.in/images/order/items/jameson_irish_whiskey.png',0,'Non Veg',600.00,0.00,'AMOUNT',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(103,24,1,'Jim Beam Bourbon Whiskey','Kentucky- The world\'s number one bourbon. Jim Beam was founded in 1795 and has been operated by one family for seven generations. We\'ve always created bourbon our way, aging it twice as long as the law requires.','https://goxdevwebsite.mi2.in/images/order/items/jim_beam_bourbon_whiskey.png',0,'Non Veg',700.00,0.00,'AMOUNT',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(104,8,1,'Fresh Burger','We know what a proper hamburger tastes like, and so should you. Try our famous Freshburger, and add something extra to your burger for a special layer of delicious!','https://goxdevwebsite.mi2.in/images/order/items/fresh_burger.png',0,'Pure Veg',45.00,0.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(105,24,1,'Famous Grouse','Scotland- Fine malt whiskies are married with exceptional grain whiskies for an unusually long period in fully seasoned oak casks, thus creating a blend of the smoothest possible character.\n','https://goxdevwebsite.mi2.in/images/order/items/famous_grouse.png',0,'Non Veg',500.00,0.00,'AMOUNT',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(106,24,1,'Glenmorangie The Original','Wine Enthusiast -Higlands, Scotland- \"Delicate notes of candied apple, light toffee and pear drops...nuances of rose petals, carnations and lightly toasted malt. The palate entry is grainy and moderately sweet; at midpalate there’s a burst of red pepper','https://goxdevwebsite.mi2.in/images/order/items/glenmorangie_the_original.png',0,'Non Veg',450.00,0.00,'AMOUNT',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(107,8,1,'Fish & Chips','2 pieces of 100% ocean fresh fish fillet, side with fries and mouth-watering dill pickle sauce and delicious vegetable salad.\n\n','https://goxdevwebsite.mi2.in/images/order/items/fish_&_chips.png',0,'Non Veg',65.00,0.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(108,25,1,'Rose Spirits','USA- This premium Vodka has been distilled five times and infused with mango, passionfruit and blood orange liqueur, creating succulent flavor that will leave you satisfied. Enjoy in a cocktail or as a shot.','https://goxdevwebsite.mi2.in/images/order/items/rose_spirits.png',0,'Non Veg',380.00,2.00,'AMOUNT',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(109,25,1,'Johnnie Walker Double Black','\"Kentucky straight bourbon whiskey finished in a port pipe. This is veteran master distiller Lincoln Henderson\'s newest creation, and it\'s a beauty. Richly textured, silky, and well-rounded, with ripe berried fruits, candied tangerine, light toffee, maple','https://goxdevwebsite.mi2.in/images/order/items/johnnie_walker_double_black.png',0,'Non Veg',480.00,4.00,'AMOUNT',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(110,25,1,'Jim Beam Bourbon Whiskey','Kentucky- The world\'s number one bourbon. Jim Beam was founded in 1795 and has been operated by one family for seven generations. We\'ve always created bourbon our way, aging it twice as long as the law requires.','https://goxdevwebsite.mi2.in/images/order/items/jim_beam_bourbon_whiskey.png',0,'Non Veg',600.00,6.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(111,25,1,'Woodford Reserve','Kentucky- Spicy and forceful taking its flavor from the charred barrels that are used to age this bourbon. Charred oak, toffee, vanilla and pepper are the dominate flavors. A long lasting dry finish. Enjoy neat, with water, or with ice. Gold Medal - San F','https://goxdevwebsite.mi2.in/images/order/items/woodford_reserve.png',0,'Non Veg',500.00,7.00,'AMOUNT',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(112,27,1,'Malibu Coconut Rum','Barbados- Made in the spirit of traditional Caribbean flavored rums and filled with the fresh, natural taste of coconut, this smooth-drinking rum infuses any drink with a taste of the tropics. Perfect on its own or as a refreshing splash in any rum-based','https://goxdevwebsite.mi2.in/images/order/items/malibu_coconut_rum.png',0,'Non Veg',450.00,0.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(113,27,1,'Sailor Jerry Spiced Rum','US Virgin Islands- This 92 proof spiced rum is modeled after the rums that sailors used to create and is based on the recipe of Sailor Jerry Collins, a famous tattoo artist. Spiced with a hint of cherry and vanilla, it is very full-bodied but goes down sm','https://goxdevwebsite.mi2.in/images/order/items/sailor_jerry_spiced_rum.png',0,'Non Veg',370.00,0.00,'AMOUNT',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(114,8,1,'Cheesy-O-Burger','Juicy marinated whole chunk of boneless chicken thigh meat with a delicious slice of chicken patty topped with melted cheese, tasty Tower Burger™ sauce, fresh hand cut iceberg lettuce and served on a warm toasted sesame seeded bun','https://goxdevwebsite.mi2.in/images/order/items/cheesy-o-burger.png',0,'Pure Veg',100.00,0.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(115,27,1,'Bulleit Bourbon','.Kentucky- Oaky, smoky, and spicy. The dry, clean flavor is mellow and spice with rye, not hot in the throat. This 90-proof Kentucky bourbon delivers a wonderfully complex taste with hints of vanilla and honey and a long smoky finish.\n','https://goxdevwebsite.mi2.in/images/order/items/bulleit_bourbon_.png',0,'Non Veg',600.00,0.00,'AMOUNT',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(116,27,1,'.Woodford Reserve','Kentucky- Spicy and forceful taking its flavor from the charred barrels that are used to age this bourbon. Charred oak, toffee, vanilla and pepper are the dominate flavors. A long lasting dry finish. Enjoy neat, with water, or with ice. Gold Medal - San F','https://goxdevwebsite.mi2.in/images/order/items/.woodford_reserve.png',0,'Non Veg',500.00,0.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(117,8,1,'Chick-A-Licious','Hand-breaded 2 pieces of original recipe chicken, fresh cut coleslaw and fries. Complete with perfection black pepper sauce or mushroom sauce','https://goxdevwebsite.mi2.in/images/order/items/chick-a-licious.png',0,'Non Veg',100.00,0.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(118,26,1,'Hennessy VS','Cognac, France- A blend of over 40 eaux de vies from the four premier growing regions of Cognac. Beautiful golden color with a fruity sweetness and a hint of vanilla in the finish. A classic','https://goxdevwebsite.mi2.in/images/order/items/hennessy_vs.png',0,'Non Veg',400.00,0.00,'AMOUNT',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(119,26,1,'.Hennessy VSOP','Cognac, France- The world\'s first V.S.O.P Cognac Fine Champagne, Remy Martin V.S.O.P is a well-balanced and multi-layered cognac aged up to 14 years in French oak casks with vanilla, stone fruit and licorice notes.\n','https://goxdevwebsite.mi2.in/images/order/items/.hennessy_vsop.png',0,'Non Veg',580.00,4.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(120,26,1,'Clase Azul Reposado Tequila','Mexico - Filtered before bottling so that the clean, clear taste of the 100% Agave tequila can be fully enjoyed by aficionados who crave the true original taste of premium agave.','https://goxdevwebsite.mi2.in/images/order/items/clase_azul_reposado_tequila.png',0,'Non Veg',500.00,0.00,'AMOUNT',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(121,26,1,'Don Julio Blanco Tequila','Mexico- Clean, clear and colorless. Holds aromas of agave, clean and fresh on the nose. The agave notes continue through the flavor, strong but not overpowering. Warm, smooth finish. Use in your favorite tequila cocktails.\n','https://goxdevwebsite.mi2.in/images/order/items/don_julio_blanco_tequila.png',0,'Non Veg',650.00,2.00,'AMOUNT',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(122,9,1,'Panner Butter masala','probably the most stereotypical of vegetarian foods. But there may be a reason for that. Tofu is pretty tasty, and it can be used in so many different ways. It\'s like a sponge, capable of soaking up a myriad of different flavors.','https://goxdevwebsite.mi2.in/images/order/items/panner_butter_masala.png',0,'Pure Veg',75.00,0.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(123,9,1,'Pasta','Pasta will never let you down when it comes to options: Stuffed shells, ravioli, stir-fry, and lo mein are just a few of our favorites. And, of course, the ultimate lazy vegetarian pasta','https://goxdevwebsite.mi2.in/images/order/items/pasta.png',0,'Pure Veg',75.00,0.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(124,10,1,'Meals','The famous chicken rice cooked in cloves garlic, crushed ginger and sesame oil. Comes with slices of boneless breast of chicken seasoned to perfection, freshly hand-cut acar, crispy papadam and topped with delicious Marrybrown® chicken rice sauce. Comes','https://goxdevwebsite.mi2.in/images/order/items/meals.png',0,'Non Veg',150.00,0.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(125,10,1,'Bubur Ayam','Test','https://goxdevwebsite.mi2.in/images/order/items/bubur_ayam.png',0,'Pure Veg',100.00,0.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(126,11,1,'White Coconut Rice','Nigerian Coconut Rice with team White Coconut Rice always fighting with team Jollof Coconut Rice. You don\'t have to fight for these two meals because they are both delicious','https://goxdevwebsite.mi2.in/images/order/items/white_coconut_rice.png',0,'Non Veg',100.00,0.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(127,30,1,'Colorful Roses','20 Roses Bunch of Mixed Colour','https://goxdevwebsite.mi2.in/images/order/items/colorful_roses.png',0,'Pure Veg',50.00,0.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(128,30,1,'Red Rose Bunch','Beautiful Bunch of 12 Red Roses to please any one.','https://goxdevwebsite.mi2.in/images/order/items/red_rose_bunch.png',0,'Pure Veg',60.00,0.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(129,30,1,'Orange Carnation','12 Stalks Orange Carnation','https://goxdevwebsite.mi2.in/images/order/items/orange_carnation.png',0,'Pure Veg',100.00,0.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(130,30,1,'Red Carnation','12 Red Carnation Bunch','https://goxdevwebsite.mi2.in/images/order/items/red_carnation.png',0,'Non Veg',120.00,0.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(131,31,1,'25 Red Gerbera','5 Red Gerberas Bunch','https://goxdevwebsite.mi2.in/images/order/items/25_red_gerbera.png',0,'Pure Veg',100.00,2.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(132,31,1,'Bright Gerberas','Basket of 15 Yellow fresh gerberas','https://goxdevwebsite.mi2.in/images/order/items/bright_gerberas.png',0,'Pure Veg',120.00,2.00,'AMOUNT',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(133,31,1,'Mix Flower Bunch','Bunch of 12 Carnations and 7 Roses','https://goxdevwebsite.mi2.in/images/order/items/mix_flower_bunch.png',0,'Pure Veg',240.00,4.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(134,31,1,'Tall Exotic Arrangement','3-4 feet tall exotic arrangement of 10 blue orchids, 24 white carnations and 50 roses.\nSend this stunning and gorgeous arrangement to cherish the special moments of special day in your loved one\'s life','https://goxdevwebsite.mi2.in/images/order/items/tall_exotic_arrangement.png',0,'Pure Veg',150.00,6.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(135,32,1,'Pink Flowers','Elegance n love','https://goxdevwebsite.mi2.in/images/order/items/pink_flowers_.png',0,'Pure Veg',150.00,6.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(136,32,1,'Purple Flowers','Colorful Fifteen Orchids Arrangement','https://goxdevwebsite.mi2.in/images/order/items/purple_flowers.png',0,'Pure Veg',190.00,4.00,'AMOUNT',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(137,32,1,'Flowers and fruits','Flowers Arrangment with Fruits','https://goxdevwebsite.mi2.in/images/order/items/flowers_and_fruits.png',0,'Pure Veg',200.00,0.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(138,32,1,' Flowers and teddy','Teddy on Top','https://goxdevwebsite.mi2.in/images/order/items/_flowers_and_teddy.png',0,'Pure Veg',300.00,0.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(139,33,1,'Heart shaped','Heart Shaped Arrangement of 30 Red Roses.','https://goxdevwebsite.mi2.in/images/order/items/heart_shaped.png',0,'Pure Veg',400.00,0.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(140,33,1,'Basket Arrangements','Basket of beauty','https://goxdevwebsite.mi2.in/images/order/items/basket_arrangements_.png',0,'Pure Veg',450.00,0.00,'AMOUNT',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(141,33,1,'Under 499','Freshness Personified','https://goxdevwebsite.mi2.in/images/order/items/under_499.png',0,'Pure Veg',499.00,15.00,'AMOUNT',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(142,33,1,'500-999','Orchids fascination','https://goxdevwebsite.mi2.in/images/order/items/500-999.png',0,'Non Veg',1000.00,10.00,'AMOUNT',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(143,34,1,'Noble Orchids','6 Blue Orchids wrapped in Cellophane Paper','https://goxdevwebsite.mi2.in/images/order/items/noble_orchids.png',0,'Pure Veg',120.00,2.00,'AMOUNT',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(144,34,1,'Winter Orchids','10 White Orchids in special paper','https://goxdevwebsite.mi2.in/images/order/items/winter_orchids.png',0,'Pure Veg',140.00,2.00,'AMOUNT',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(145,34,1,'Stunning hot lilies','4 Asiatic Pink Lilies and 12 Red Roses','https://goxdevwebsite.mi2.in/images/order/items/stunning_hot_lilies.png',0,'Pure Veg',150.00,4.00,'AMOUNT',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(146,34,1,'Blush Pink Lilies','10 Pink Asiatic Lilies','https://goxdevwebsite.mi2.in/images/order/items/blush_pink_lilies.png',0,'Pure Veg',160.00,4.00,'AMOUNT',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(147,17,1,'Hard soda','Hard soda, also referred to as flavored beer, is a type of alcoholic beverage and craft beer that is manufactured in the style of a soft drink','https://goxdevwebsite.mi2.in/images/order/items/hard_soda.png',0,'Pure Veg',30.00,4.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(148,17,1,'Popcorn','Popcorn is a variety of corn kernel, which expands and puffs up when heated. A popcorn kernel\'s strong hull contains the seed\'s hard, starchy endosperm with 14–20% moisture, which turns to steam as the kernel is heated','https://goxdevwebsite.mi2.in/images/order/items/popcorn.png',0,'Pure Veg',60.00,0.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(149,17,1,'Snacky Nuts','A nut is a fruit composed of an inedible hard shell and a seed, which is generally edible. In general usage, a wide variety of dried seeds are called nuts, but in a botanical context \"nut\" implies that the shell does not open to release the seed','https://goxdevwebsite.mi2.in/images/order/items/snacky_nuts.png',0,'Pure Veg',38.00,0.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(150,17,1,'Bread','There’s nothing like taking a loaf of fresh yeast bread out of the oven. Just the enticing scent alone makes one of the world’s most celebrated foods worth baking! From a handful of ingredients—at its most basic flour, yeast, water, and salt—to th','https://goxdevwebsite.mi2.in/images/order/items/bread__.png',0,'Pure Veg',20.00,0.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(151,17,1,'Cooking Oils','.Cooking oil is plant, animal, or synthetic fat used in frying, baking, and other types of cooking. It is also used in food preparation and flavouring not involving heat, such as salad dressings and bread dips, and in this sense might be more accurately t','https://goxdevwebsite.mi2.in/images/order/items/cooking_oils.png',0,'Pure Veg',180.00,0.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(152,17,1,'Cakes','Layer cakes, cupcakes, snack cakes, roulades, and even cheesecakes—the cake category is vast. Most cakes are often classified into two categories: whether they contain fat, such as butter or oil (shortened cakes) or whether they contain little or no fat','https://goxdevwebsite.mi2.in/images/order/items/cakes__.png',0,'Pure Veg',86.00,0.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(153,17,1,'Custard','Custards are thick, rich, creamy desserts typically made from eggs and milk or cream. They can be sweet or savory and flavored loads of different ways. Made on the stovetop or baked, they range from cheesecake and flan to ice cream, pastry cream, and even','https://goxdevwebsite.mi2.in/images/order/items/custard.png',0,'Pure Veg',20.00,0.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(154,17,1,'Ghee ','Ghee, is a class of clarified butter that originated in ancient India. It is commonly used in Middle Eastern cuisine, cuisine of the Indian subcontinent, Southeast Asian cuisine, traditional medicine, and religious rituals','https://goxdevwebsite.mi2.in/images/order/items/ghee___.png',0,'Pure Veg',45.00,0.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(155,17,1,'Wheat','Wheat is a grass widely cultivated for its seed, a cereal grain which is a worldwide staple food. The many species of wheat together make up the genus Triticum; the most widely grown is common wheat','https://goxdevwebsite.mi2.in/images/order/items/wheat.png',0,'Pure Veg',50.00,0.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(156,18,1,'Milk','Milk is a nutrient-rich, white liquid food produced by the mammary glands of mammals. It is the primary source of nutrition for infant mammals before they are able to digest other types of food  ','https://goxdevwebsite.mi2.in/images/order/items/milk__.png',0,'Pure Veg',10.00,0.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(157,18,1,'Cheese','Cheese is a dairy product derived from milk that is produced in a wide range of flavors, textures, and forms by coagulation of the milk protein casein. It comprises proteins and fat from milk, usually the milk of cows, buffalo, goats, or sheep','https://goxdevwebsite.mi2.in/images/order/items/cheese__.png',0,'Pure Veg',30.00,0.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(158,18,1,'Soya Milk','Soy milk or soymilk is a plant-based drink produced by soaking and grinding soybeans, boiling the mixture, and filtering out remaining particulates. It is a stable emulsion of oil, water, and protein. Its original form is a natural by-product','https://goxdevwebsite.mi2.in/images/order/items/soya_milk.png',0,'Pure Veg',40.00,0.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(159,18,1,'Cocoa Powder','Trader Joe’s sells unsweetened cocoa powder that is delicious in my recipe for T’s Dreamy Chocolate Sauce for our Dessert Nachos for Breakfast! YUM!!! I also buy raw cacao powder.','https://goxdevwebsite.mi2.in/images/order/items/cocoa_powder_.png',0,'Pure Veg',40.00,0.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(160,18,1,'Chocolate Chips','prefer to use cacao nibs (and cacao/cocoa powder) whenever possible. My husband and kids really like chocolate chips. Look at the ingredient label to make sure that they do not contain any dairy','https://goxdevwebsite.mi2.in/images/order/items/chocolate_chips.png',0,'Pure Veg',40.00,0.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(161,19,1,'Chocolates','Chocolate is a usually sweet, brown food preparation of roasted and ground cacao seeds that is made in the form of a liquid, paste, or in a block, or used as a flavoring ingredient in other foods ','https://goxdevwebsite.mi2.in/images/order/items/chocolates__.png',0,'Pure Veg',45.00,0.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(162,19,1,'Gums','The purpose of GEMS/Food is to compile data on food contamination and human exposure from different countries for global synthesis, evaluation and presentation.','https://goxdevwebsite.mi2.in/images/order/items/gums.png',0,'Pure Veg',5.00,0.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(163,19,1,'Mouth Freshner','Spraymintt is a one second mouth freshener that makes you kiss ready in just one second. With its natural formulation and no side effects it is the best solution for instant mouth freshener','https://goxdevwebsite.mi2.in/images/order/items/mouth_freshner.png',0,'Pure Veg',35.00,0.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(164,19,1,'Friut Drinks','.Juice is a drink made from the extraction or pressing of the natural liquid contained in fruit and vegetables. It can also refer to liquids that are flavored with concentrate or other biological food sources, such as meat or seafood, such as clam juice','https://goxdevwebsite.mi2.in/images/order/items/friut_drinks.png',0,'Pure Veg',35.00,0.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(165,19,1,'Energy Drink','An energy drink is a type of drink containing sugar and stimulant compounds, usually caffeine, which is marketed as providing mental and physical stimulation. They may or may not be carbonated and may also contain other sweeteners, herbal extracts, taurin','https://goxdevwebsite.mi2.in/images/order/items/energy_drink.png',0,'Pure Veg',50.00,0.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(166,19,1,'Noodles','Noodles are unleavened dough which is stretched, extruded, or rolled flat and cut into one of a variety of shapes which usually include long, thin strips, or waves, helices, tubes, strings, or shells, or folded over, or cut into other shapes     ','https://goxdevwebsite.mi2.in/images/order/items/noodles.png',0,'Pure Veg',50.00,0.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(167,19,1,'Pasta','Pasta is type of noodle typically made from an unleavened dough of durum wheat flour mixed with water or eggs, and formed into sheets or various shapes, then cooked by boiling or baking','https://goxdevwebsite.mi2.in/images/order/items/pasta.png',0,'Pure Veg',75.00,0.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(168,20,1,'Toor dal','perennial legume from the family Fabaceae. Since its domestication in the Indian subcontinent at least 3,500 years ago, its seeds have become a common food in Asia, Africa, and Latin America','https://goxdevwebsite.mi2.in/images/order/items/toor_dal.png',0,'Pure Veg',45.00,0.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(169,20,1,'Urad dal','Vigna mungo, black gram, urad bean, urid bean, minapa pappu, mungo bean or black matpe bean is a bean grown in the Indian subcontinent. Like its relative, the mung bean, it has been reclassified from the Phaseolus to the Vigna genus','https://goxdevwebsite.mi2.in/images/order/items/urad_dal_.png',0,'Pure Veg',45.00,0.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(170,20,1,'Moong Dall','The mung bean, alternatively known as the green gram, maash, or moong , is a plant species in the legume family. The mung bean is mainly cultivated in East Asia, Southeast Asia and Indian subcontinent','https://goxdevwebsite.mi2.in/images/order/items/moong_dall.png',0,'Pure Veg',65.00,0.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(171,20,1,'Pickles','A pickled cucumber is a cucumber that has been pickled in a brine, vinegar, or other solution and left to ferment for a period of time, by either immersing the cucumbers in an acidic solution or through souring by lacto-fermentation.','https://goxdevwebsite.mi2.in/images/order/items/pickles__.png',0,'Pure Veg',55.00,0.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(172,20,1,'Chutney','Chutney is a sauce or a dry base for a sauce, originating from the Indian subcontinent, used with the cuisines of the Indian subcontinent, that can include such forms as a spicy coconut dip, a tomato relish, a ground peanut garnish or a dahi, cucumber, an','https://goxdevwebsite.mi2.in/images/order/items/chutney.png',0,'Pure Veg',35.00,0.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(173,20,1,'Ketchups ','Ketchup is a sauce used as a condiment. Originally, recipes used egg whites, mushrooms, oysters, mussels, or walnuts, among other ingredients, but now the unmodified term usually refers to tomato ketchup','https://goxdevwebsite.mi2.in/images/order/items/ketchups___.png',0,'Pure Veg',60.00,0.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(174,20,1,'Dip Spreads','.A spread is a food that is spread, generally with a knife, onto foods such as bread and crackers. Spreads are added to food to enhance the flavor or texture of the food, which may be considered bland without it. Butter and soft cheeses are typical spread','https://goxdevwebsite.mi2.in/images/order/items/dip_spreads.png',0,'Pure Veg',35.00,0.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(175,21,1,'Powdered Spices','Spices are used in different forms: whole, chopped, ground, roasted, sautéed, fried, and as topping. They blend food to extract the nutrients and bind them in a palatable form. Some spices are added at the end as a flavouring and are typically heated in','https://goxdevwebsite.mi2.in/images/order/items/powdered_spices.png',0,'Pure Veg',30.00,0.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(176,21,1,'Whole Spices','Fenugreek is used to add flavor to meat dishes. It is also considered as an aphrodisiac. Garam Masala – meaning “hot spicesâ€ - is a mixture of ground spices (recipes vary) (cloves, cardamom, cumin, peppercorns and cinnamon, bay leaves). It is far be','https://goxdevwebsite.mi2.in/images/order/items/whole_spices.png',0,'Pure Veg',30.00,0.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(177,21,1,'Cooking Paste','A food paste is a semi-liquid colloidal suspension, emulsion, or aggregation used in food preparation or eaten directly as a spread. Pastes are often highly spicy or aromatic, are often prepared well in advance of actual usage, and are often made into a p','https://goxdevwebsite.mi2.in/images/order/items/cooking_paste.png',0,'Pure Veg',50.00,0.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(178,21,1,'Cashew Nuts','The cashew tree is a tropical evergreen tree that produces the cashew seed and the cashew apple. It can grow as high as 14 m,  growing up to 6 m, has proved more profitable, with earlier maturity and higher yields','https://goxdevwebsite.mi2.in/images/order/items/cashew_nuts.png',0,'Pure Veg',50.00,0.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(179,21,1,'Edible Seeds','Edible seeds are angiosperms, but a few are gymnosperms. The most important global seed food source, by weight, is cereals, followed by legumes, and nuts.','https://goxdevwebsite.mi2.in/images/order/items/edible_seeds.png',0,'Pure Veg',30.00,0.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(180,21,1,'Dried Fruits','Dried fruit is fruit from which the majority of the original water content has been removed either naturally, through sun drying, or through the use of specialized dryers or dehydrators','https://goxdevwebsite.mi2.in/images/order/items/dried_fruits.png',0,'Pure Veg',40.00,0.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(181,21,1,'Health Powder Mix','Multigrain Health Drink. This is the ultimate health drink powder for kids, with ingredients like millet, horse gram, sago, almonds, pistachios, cashew nuts and many others.','https://goxdevwebsite.mi2.in/images/order/items/health_powder_mix.png',0,'Pure Veg',50.00,0.00,'PERCENTAGE',0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `store_order_disputes`
--

CREATE TABLE `store_order_disputes` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `dispute_type` enum('user','provider','system') COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` int(10) unsigned DEFAULT NULL,
  `store_id` int(10) unsigned DEFAULT NULL,
  `store_order_id` int(10) unsigned DEFAULT NULL,
  `provider_id` int(11) DEFAULT NULL,
  `dispute_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `dispute_title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `comments` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dispute_type_comments` text COLLATE utf8mb4_unicode_ci,
  `refund_amount` double(10,2) NOT NULL DEFAULT '0.00',
  `company_id` int(10) unsigned NOT NULL,
  `comments_by` enum('user','admin','shop') COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` enum('open','closed') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'open',
  `is_admin` tinyint(4) NOT NULL DEFAULT '0',
  `created_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` int(10) unsigned DEFAULT NULL,
  `modified_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `modified_by` int(10) unsigned DEFAULT NULL,
  `deleted_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_by` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `store_order_disputes_store_order_id_foreign` (`store_order_id`),
  CONSTRAINT `store_order_disputes_store_order_id_foreign` FOREIGN KEY (`store_order_id`) REFERENCES `store_orders` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `store_order_disputes`
--


--
-- Table structure for table `store_order_invoices`
--

CREATE TABLE `store_order_invoices` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `store_order_id` int(10) unsigned NOT NULL,
  `payment_mode` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payment_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_id` int(10) unsigned NOT NULL,
  `store_id` int(10) unsigned NOT NULL,
  `item_price` double(10,2) NOT NULL DEFAULT '0.00',
  `gross` decimal(10,2) NOT NULL DEFAULT '0.00',
  `net` decimal(10,2) NOT NULL DEFAULT '0.00',
  `discount` decimal(10,2) NOT NULL DEFAULT '0.00',
  `promocode_id` decimal(10,2) NOT NULL DEFAULT '0.00',
  `promocode_amount` decimal(10,2) NOT NULL DEFAULT '0.00',
  `wallet_amount` decimal(10,2) NOT NULL DEFAULT '0.00',
  `tax_per` decimal(10,2) NOT NULL DEFAULT '0.00',
  `tax_amount` decimal(10,2) NOT NULL DEFAULT '0.00',
  `commision_per` decimal(10,2) NOT NULL DEFAULT '0.00',
  `commision_amount` decimal(10,2) NOT NULL DEFAULT '0.00',
  `delivery_per` decimal(10,2) NOT NULL DEFAULT '0.00',
  `delivery_amount` decimal(10,2) NOT NULL DEFAULT '0.00',
  `store_package_amount` decimal(10,2) NOT NULL DEFAULT '0.00',
  `total_amount` decimal(10,2) NOT NULL DEFAULT '0.00',
  `cash` decimal(10,2) NOT NULL DEFAULT '0.00',
  `payable` decimal(10,2) NOT NULL DEFAULT '0.00',
  `cart_details` text COLLATE utf8mb4_unicode_ci,
  `status` tinyint(4) NOT NULL DEFAULT '1',
  `created_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` int(10) unsigned DEFAULT NULL,
  `modified_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `modified_by` int(10) unsigned DEFAULT NULL,
  `deleted_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_by` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `store_order_invoices_store_order_id_foreign` (`store_order_id`),
  CONSTRAINT `store_order_invoices_store_order_id_foreign` FOREIGN KEY (`store_order_id`) REFERENCES `store_orders` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `store_order_invoices`
--


--
-- Table structure for table `store_order_statuses`
--

CREATE TABLE `store_order_statuses` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `company_id` int(10) unsigned NOT NULL,
  `store_order_id` int(10) unsigned NOT NULL,
  `status` enum('ORDERED','RECEIVED','CANCELLED','ASSIGNED','PROCESSING','REACHED','PICKEDUP','ARRIVED','COMPLETED','SEARCHING') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'ORDERED',
  `created_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` int(10) unsigned DEFAULT NULL,
  `modified_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `modified_by` int(10) unsigned DEFAULT NULL,
  `deleted_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_by` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `store_order_statuses_store_order_id_foreign` (`store_order_id`),
  CONSTRAINT `store_order_statuses_store_order_id_foreign` FOREIGN KEY (`store_order_id`) REFERENCES `store_orders` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `store_order_statuses`
--


--
-- Table structure for table `store_outlet_item_stocks`
--

CREATE TABLE `store_outlet_item_stocks` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `store_id` int(10) unsigned NOT NULL,
  `store_item_id` int(10) unsigned NOT NULL,
  `store_outlet_id` int(10) unsigned NOT NULL,
  `company_id` int(10) unsigned NOT NULL,
  `store_outlets_stock` tinyint(4) NOT NULL DEFAULT '1',
  `created_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` int(10) unsigned DEFAULT NULL,
  `modified_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `modified_by` int(10) unsigned DEFAULT NULL,
  `deleted_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_by` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `store_outlet_item_stocks_store_id_foreign` (`store_id`),
  KEY `store_outlet_item_stocks_store_item_id_foreign` (`store_item_id`),
  KEY `store_outlet_item_stocks_store_outlet_id_foreign` (`store_outlet_id`),
  CONSTRAINT `store_outlet_item_stocks_store_id_foreign` FOREIGN KEY (`store_id`) REFERENCES `stores` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `store_outlet_item_stocks_store_item_id_foreign` FOREIGN KEY (`store_item_id`) REFERENCES `store_items` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `store_outlet_item_stocks_store_outlet_id_foreign` FOREIGN KEY (`store_outlet_id`) REFERENCES `store_outlets` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `store_outlet_item_stocks`
--


--
-- Table structure for table `store_outlets`
--

CREATE TABLE `store_outlets` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `store_id` int(10) unsigned NOT NULL,
  `company_id` int(10) unsigned NOT NULL,
  `store_outlet_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `store_outlet_location` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `store_outlet_zipcode` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `contact_person` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `contact_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_primary` tinyint(4) NOT NULL DEFAULT '0',
  `status` tinyint(4) NOT NULL DEFAULT '1',
  `created_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` int(10) unsigned DEFAULT NULL,
  `modified_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `modified_by` int(10) unsigned DEFAULT NULL,
  `deleted_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_by` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `store_outlets_store_id_foreign` (`store_id`),
  CONSTRAINT `store_outlets_store_id_foreign` FOREIGN KEY (`store_id`) REFERENCES `stores` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `store_outlets`
--


--
-- Table structure for table `store_timings`
--

CREATE TABLE `store_timings` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `store_id` int(10) unsigned NOT NULL,
  `company_id` int(10) unsigned NOT NULL,
  `store_start_time` time DEFAULT NULL,
  `store_end_time` time DEFAULT NULL,
  `store_day` enum('ALL','SUN','MON','TUE','WED','THU','FRI','SAT') COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` int(10) unsigned DEFAULT NULL,
  `modified_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `modified_by` int(10) unsigned DEFAULT NULL,
  `deleted_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_by` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `store_timings_store_id_foreign` (`store_id`),
  CONSTRAINT `store_timings_store_id_foreign` FOREIGN KEY (`store_id`) REFERENCES `stores` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `store_timings`
--

INSERT INTO `store_timings` VALUES (1,15,1,'00:00:00','12:00:00','ALL',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,16,1,'00:00:00','12:00:00','ALL',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,28,1,'00:00:00','12:00:00','ALL',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,14,1,'00:00:00','23:00:00','ALL',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,1,1,'12:00:00','00:10:00','ALL',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,5,1,'00:00:00','23:59:00','ALL',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,6,1,'18:00:00','00:00:00','ALL',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,7,1,'12:00:00','00:00:00','ALL',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,8,1,'00:00:00','12:00:00','ALL',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10,9,1,'12:00:00','00:00:00','ALL',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(11,10,1,'12:00:00','00:00:00','ALL',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(12,11,1,'12:00:00','00:00:00','ALL',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(13,29,1,'00:00:00','12:00:00','ALL',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(14,17,1,'01:00:00','12:00:00','ALL',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(15,30,1,'00:00:00','12:00:00','ALL',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(16,31,1,'00:00:00','12:00:00','ALL',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(17,33,1,'00:00:00','12:00:00','ALL',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(18,32,1,'00:00:00','12:00:00','ALL',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(19,34,1,'00:00:00','12:00:00','ALL',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(20,24,1,'00:00:00','12:00:00','ALL',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(21,18,1,'01:00:00','12:00:00','ALL',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(22,26,1,'00:00:00','12:00:00','ALL',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(23,25,1,'00:00:00','12:00:00','ALL',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(24,27,1,'00:00:00','12:00:00','ALL',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(25,23,1,'00:00:00','12:00:00','ALL',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(26,19,1,'01:00:00','12:00:00','ALL',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(27,12,1,'00:00:00','12:00:00','ALL',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(28,20,1,'00:00:00','00:00:00','ALL',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(29,3,1,'00:00:00','23:00:00','ALL',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(30,21,1,'01:00:00','12:00:00','ALL',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(31,2,1,'00:00:00','23:59:00','ALL',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(32,4,1,'00:00:00','12:00:00','ALL',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(33,22,1,'00:00:00','00:00:00','ALL',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(34,13,1,'08:00:00','16:00:00','SUN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(35,13,1,'08:00:00','16:00:00','MON',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(36,13,1,'08:00:00','16:00:00','TUE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(37,13,1,'08:00:00','16:00:00','WED',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(38,13,1,'08:00:00','16:00:00','THU',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(39,13,1,'08:00:00','16:00:00','FRI',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(40,13,1,'08:00:00','16:00:00','SAT',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `store_types`
--

CREATE TABLE `store_types` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `company_id` int(10) unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `category` enum('FOOD','OTHERS') COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint(4) NOT NULL,
  `created_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` int(10) unsigned DEFAULT NULL,
  `modified_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `modified_by` int(10) unsigned DEFAULT NULL,
  `deleted_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_by` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `store_types`
--

INSERT INTO `store_types` VALUES (1,1,'Foodie','FOOD',1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,1,'Grocery','OTHERS',1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,1,'Alcohol','OTHERS',1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,1,'Flower','OTHERS',1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `store_wallets`
--

CREATE TABLE `store_wallets` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `store_id` int(10) unsigned NOT NULL,
  `transaction_id` int(11) NOT NULL,
  `company_id` int(10) unsigned NOT NULL,
  `transaction_alias` varchar(25) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `transaction_desc` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` enum('C','D') COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount` double(15,8) NOT NULL DEFAULT '0.00000000',
  `open_balance` double(15,8) NOT NULL DEFAULT '0.00000000',
  `close_balance` double(15,8) NOT NULL DEFAULT '0.00000000',
  `admin_service` enum('TRANSPORT','ORDER','SERVICE') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` int(10) unsigned DEFAULT NULL,
  `modified_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `modified_by` int(10) unsigned DEFAULT NULL,
  `deleted_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_by` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `store_wallets_store_id_foreign` (`store_id`),
  CONSTRAINT `store_wallets_store_id_foreign` FOREIGN KEY (`store_id`) REFERENCES `stores` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `store_wallets`
--



