-- MySQL dump 10.13  Distrib 8.0.33, for Linux (x86_64)
--
-- Host: localhost    Database: tiger
-- ------------------------------------------------------
-- Server version	8.0.33-0ubuntu0.22.04.2

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `audit_trails`
--

DROP TABLE IF EXISTS `audit_trails`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `audit_trails` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `event` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` int DEFAULT NULL,
  `ip` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `uri` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `agent` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `audit_trails`
--

LOCK TABLES `audit_trails` WRITE;
/*!40000 ALTER TABLE `audit_trails` DISABLE KEYS */;
/*!40000 ALTER TABLE `audit_trails` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `careers`
--

DROP TABLE IF EXISTS `careers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `careers` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `email_address` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `careers`
--

LOCK TABLES `careers` WRITE;
/*!40000 ALTER TABLE `careers` DISABLE KEYS */;
INSERT INTO `careers` VALUES (1,'career@tiger.co.tz','2022-09-21 00:41:22','2022-09-21 00:41:22');
/*!40000 ALTER TABLE `careers` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `categories`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `categories` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `featured_image` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slug` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `landing_page_image` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `keywords` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_description` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=56 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `categories` WRITE;
/*!40000 ALTER TABLE `categories` DISABLE KEYS */;
INSERT INTO `categories` VALUES (50,'{\"en\":\"Beauty & Spa\",\"sw\":null}','/uploads/1660898878.jpg','{\"en\":\"beauty-spa\",\"sw\":\"\"}','2022-08-19 15:47:58','2022-08-19 15:47:58','',NULL,NULL),(51,'{\"en\":\"Bookstore\",\"sw\":null}','/uploads/1660898902.jpg','{\"en\":\"bookstore\",\"sw\":\"\"}','2022-08-19 15:48:22','2022-08-19 15:48:22','',NULL,NULL),(49,'{\"en\":\"Travel\",\"sw\":null}','/uploads/1660725385.jpg','{\"en\":\"travel\",\"sw\":\"\"}','2022-08-17 15:36:25','2022-08-17 15:36:25','',NULL,NULL),(48,'{\"en\":\"Pets\",\"sw\":null}','/uploads/1660725351.jpg','{\"en\":\"pets\",\"sw\":\"\"}','2022-08-17 15:35:51','2022-08-17 15:35:51','',NULL,NULL),(47,'{\"en\":\"Restaurants\",\"sw\":null}','/uploads/1660725320.jpg','{\"en\":\"restaurants\",\"sw\":\"\"}','2022-08-17 15:35:20','2022-08-17 15:35:20','',NULL,NULL),(45,'{\"en\":\"Yoga\",\"sw\":null}','/uploads/1660725210.jpg','{\"en\":\"yoga\",\"sw\":\"\"}','2022-08-17 15:33:30','2022-08-17 15:33:30','',NULL,NULL),(46,'{\"en\":\"Hospitals\",\"sw\":null}','/uploads/1660725235.jpg','{\"en\":\"hospitals\",\"sw\":\"\"}','2022-08-17 15:33:55','2022-08-17 15:33:55','',NULL,NULL),(44,'{\"en\":\"Gym\",\"sw\":null}','/uploads/1660725069.jpg','{\"en\":\"gym\",\"sw\":\"\"}','2022-08-17 15:31:09','2022-08-17 15:31:09','',NULL,NULL),(43,'{\"en\":\"Groceries\",\"sw\":null}','/uploads/1660725048.jpg','{\"en\":\"groceries\",\"sw\":\"\"}','2022-08-17 15:30:48','2022-08-17 15:30:48','',NULL,NULL),(42,'{\"en\":\"Florists\",\"sw\":null}','/uploads/1660725020.jpg','{\"en\":\"florists\",\"sw\":\"\"}','2022-08-17 15:30:20','2022-08-17 15:30:20','',NULL,NULL),(41,'{\"en\":\"Fast Food\",\"sw\":null}','/uploads/1660724998.jpg','{\"en\":\"fast-food\",\"sw\":\"\"}','2022-08-17 15:29:58','2022-08-17 15:29:58','',NULL,NULL),(40,'{\"en\":\"Fashion\",\"sw\":null}','/uploads/1660724972.jpg','{\"en\":\"fashion\",\"sw\":\"\"}','2022-08-17 15:29:32','2022-08-17 15:29:32','',NULL,NULL),(39,'{\"en\":\"Electronics\",\"sw\":null}','/uploads/1660724953.jpg','{\"en\":\"electronics\",\"sw\":\"\"}','2022-08-17 15:29:13','2022-08-17 15:29:13','',NULL,NULL),(38,'{\"en\":\"Cosmetics\",\"sw\":null}','/uploads/1660724932.jpg','{\"en\":\"cosmetics\",\"sw\":\"\"}','2022-08-17 15:28:52','2022-08-17 15:28:52','',NULL,NULL),(37,'{\"en\":\"Coffee Shops\",\"sw\":null}','/uploads/1660724909.jpg','{\"en\":\"coffee-shops\",\"sw\":\"\"}','2022-08-17 15:28:29','2022-08-17 15:28:29','',NULL,NULL),(36,'{\"en\":\"Butcheries\",\"sw\":null}','/uploads/1660724887.jpg','{\"en\":\"butcheries\",\"sw\":\"\"}','2022-08-17 15:28:07','2022-08-17 15:28:07','',NULL,NULL),(35,'{\"en\":\"Bar & Lounge\",\"sw\":null}','/uploads/1660724780.jpg','{\"en\":\"bar-lounge\",\"sw\":\"\"}','2022-08-17 15:26:20','2022-08-17 15:26:20','',NULL,NULL),(34,'{\"en\":\"Betting\",\"sw\":null}','/uploads/1660724691.jpg','{\"en\":\"betting\",\"sw\":\"\"}','2022-08-17 15:24:51','2022-08-17 15:24:51','',NULL,NULL),(33,'{\"en\":\"Bakery\",\"sw\":null}','/uploads/1660714355.jpg','{\"en\":\"bakery\",\"sw\":\"\"}','2022-08-17 12:32:35','2022-08-17 12:32:35','',NULL,NULL),(52,'{\"en\":\"Hotels\",\"sw\":null}','/uploads/1660898928.jpg','{\"en\":\"hotels\",\"sw\":\"\"}','2022-08-19 15:48:48','2022-08-19 15:48:48','',NULL,NULL),(53,'{\"en\":\"Liquor Stores\",\"sw\":null}','/uploads/1660898963.jpg','{\"en\":\"liquor-stores\",\"sw\":\"\"}','2022-08-19 15:49:23','2022-08-19 15:49:23','',NULL,NULL),(54,'{\"en\":\"Supermarkets\",\"sw\":null}','/uploads/1660899472.jpg','{\"en\":\"supermarkets\",\"sw\":\"\"}','2022-08-19 15:57:52','2022-08-19 15:57:52','',NULL,NULL);
/*!40000 ALTER TABLE `categories` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `client_landings`
--

DROP TABLE IF EXISTS `client_landings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `client_landings` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `top_section_title` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `top_section_image` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `top_section_caption` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `second_section_title` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `second_section_text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `second_section_image` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `why_tiger_title` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `benefit_title_one` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `benefit_text_one` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `benefit_title_two` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `benefit_text_two` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `benefit_title_three` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `benefit_text_three` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `benefit_title_four` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `benefit_text_four` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `benefit_title_five` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `benefit_text_five` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `benefit_title_six` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `benefit_text_six` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `fourth_section_image` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fourth_section_title` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `fourth_section_caption` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `deal_title` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `deal_caption` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `deal_button_label` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `deal_button_link` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deal_one` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deal_two` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deal_three` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deal_four` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `merchant_applestore_link` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `merchant_googleplay_store_link` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `customer_applestore_link` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `customer_googleplay_store_link` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `footer_image` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `about_tiger_title` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `about_tiger_text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `contact_title` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `contact_text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `newsletter_title` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `newsletter_caption` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `mobile_top_section_image` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `top_section_button_label` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `client_landings`
--

LOCK TABLES `client_landings` WRITE;
/*!40000 ALTER TABLE `client_landings` DISABLE KEYS */;
/*!40000 ALTER TABLE `client_landings` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `contacts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `contacts` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone_number` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `contacts`
--

LOCK TABLES `contacts` WRITE;
/*!40000 ALTER TABLE `contacts` DISABLE KEYS */;
/*!40000 ALTER TABLE `contacts` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `customer_landings`
--

DROP TABLE IF EXISTS `customer_landings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `customer_landings` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `slider_section_title` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `slider_section_caption` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `register_link_label` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `register_link` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `how_it_works_link` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `how_it_works_link_label` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `register_account_link` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `register_vendor_link` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `featured_deal_one` int DEFAULT NULL,
  `featured_deal_two` int DEFAULT NULL,
  `featured_deal_three` int DEFAULT NULL,
  `new_deal_one` int DEFAULT NULL,
  `new_deal_two` int DEFAULT NULL,
  `new_deal_three` int DEFAULT NULL,
  `bigdiscount_deal_one` int DEFAULT NULL,
  `bigdiscount_deal_two` int DEFAULT NULL,
  `bigdiscount_deal_three` int DEFAULT NULL,
  `category_one` int DEFAULT NULL,
  `category_two` int DEFAULT NULL,
  `category_three` int DEFAULT NULL,
  `category_four` int DEFAULT NULL,
  `category_five` int DEFAULT NULL,
  `category_six` int DEFAULT NULL,
  `category_seven` int DEFAULT NULL,
  `category_eight` int DEFAULT NULL,
  `category_nine` int DEFAULT NULL,
  `category_one_image` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `category_two_image` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `category_three_image` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `category_four_image` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `category_five_image` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `category_six_image` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `category_seven_image` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `category_eight_image` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `category_nine_image` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `apple_store_link` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `google_play_store_link` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `featured_deal_four` int DEFAULT NULL,
  `new_deal_four` int DEFAULT NULL,
  `bigdiscount_deal_four` int DEFAULT NULL,
  `reg_account_image` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `vendor_reg_account_image` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `register_account_label` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `register_vendor_label` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title_tag` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `register_account_caption` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `register_vendor_account_caption` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `keywords` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_description` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `customer_landings`
--

LOCK TABLES `customer_landings` WRITE;
/*!40000 ALTER TABLE `customer_landings` DISABLE KEYS */;
INSERT INTO `customer_landings` VALUES (1,'{\"en\":\"Great and latest deals from high street brands\",\"sw\":null}','{\"en\":\"We help you save money and time.\",\"sw\":null}','{\"sw\":null}','https://play.google.com/store/apps/details?id=com.vendors.tiger','https://vimeo.com/738997978','{\"en\":\"How It Works\",\"sw\":null}','https://apps.apple.com/tz/app/tiger-merchant/id1627441521','https://apps.apple.com/tz/app/tiger-loyalty/id1639509008',1,1,1,1,1,1,1,1,1,40,50,40,39,39,47,38,39,37,'/uploads/16621252191.jpg','/uploads/16621252192.jpg','/uploads/16621252195.jpg','/uploads/16621252196.jpg','/uploads/16621252197.jpg','/uploads/16621252198.jpg','/uploads/16621252199.jpg','/uploads/166212521910.jpg','/uploads/166212521911.jpg','https://apps.apple.com/tz/app/tiger-loyalty/id1639509008','https://play.google.com/store/apps/details?id=com.babjonii.tigerloyalty','2022-06-28 15:23:20','2022-11-16 08:38:57',1,1,1,'/uploads/','/uploads/','Customer Registration',NULL,'Inspired By Deals','Download Application now and enjoy a new world of Loyalty.','Download Tiger Loyalty now and start building a bond with your customers to gain exponential sales traffic.',NULL,NULL);
/*!40000 ALTER TABLE `customer_landings` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `deal_types`
--

DROP TABLE IF EXISTS `deal_types`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `deal_types` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slug` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `featured_image` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `deal_types`
--

LOCK TABLES `deal_types` WRITE;
/*!40000 ALTER TABLE `deal_types` DISABLE KEYS */;
INSERT INTO `deal_types` VALUES (1,'{\"en\":\"Featured Deals\",\"sw\":\"Ofa Zilizoangaziwa\"}','{\"en\":\"featured-deals\",\"sw\":\"ofa-zilizoangaziwa\"}','/uploads/1662962834.jpg','2022-06-17 01:11:04','2022-09-12 13:07:14'),(4,'{\"en\":\"Discount Deals\",\"sw\":\"Ofa za Punguzo\"}','{\"en\":\"discount-deals\",\"sw\":\"ofa-za-punguzo\"}','/uploads/1662962807.jpg','2022-06-27 15:14:29','2022-09-12 13:06:47'),(5,'{\"en\":\"New Deals\",\"sw\":\"Ofa Mpya\"}','{\"en\":\"new-deals\",\"sw\":\"ofa-mpya\"}','/uploads/1662962774.jpg','2022-06-27 15:15:21','2022-09-12 13:06:14');
/*!40000 ALTER TABLE `deal_types` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `deals`
--

DROP TABLE IF EXISTS `deals`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `deals` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `vendorid` bigint unsigned NOT NULL,
  `dealtypeid` bigint unsigned NOT NULL,
  `location` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `featured_image` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` int NOT NULL DEFAULT '1',
  `status_description` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `regionid` int DEFAULT NULL,
  `keywords` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_description` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `deals_vendorid_foreign` (`vendorid`),
  KEY `deals_dealtypeid_foreign` (`dealtypeid`)
) ENGINE=MyISAM AUTO_INCREMENT=47 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `deals`
--

LOCK TABLES `deals` WRITE;
/*!40000 ALTER TABLE `deals` DISABLE KEYS */;
INSERT INTO `deals` VALUES (46,6,4,NULL,'/uploads/1672144749.jpg','{\"en\":\"sale up to 50%\",\"sw\":null}',1,'active','2022-12-27 12:39:09','2022-12-27 12:39:09','{\"en\":\"<p>Get up to 50% discount through tiger at mass communication.<\\/p>\",\"sw\":null}',2,'{\"sw\":null}','{\"sw\":null}'),(45,9,1,NULL,'/uploads/1668621715.jpg','{\"en\":\"Ahlan\",\"sw\":null}',1,'active','2022-11-16 18:01:55','2022-11-16 18:01:55','{\"en\":\"<p>Sandwich&nbsp;<\\/p>\",\"sw\":null}',2,'{\"sw\":null}','{\"sw\":null}'),(44,5,5,NULL,'/uploads/1668619482.jpg','{\"en\":\"Taste Me\",\"sw\":null}',1,'active','2022-11-16 17:24:42','2022-11-16 17:24:42','{\"en\":\"<p>New timing<\\/p>\",\"sw\":null}',2,'{\"sw\":null}','{\"sw\":null}'),(42,8,1,NULL,'/uploads/1668619355.jpg','{\"en\":\"The Touch Spa\",\"sw\":null}',1,'active','2022-11-16 17:22:35','2022-11-16 17:22:35','{\"en\":\"<p>Aroma therapy&nbsp;<\\/p>\",\"sw\":null}',2,'{\"sw\":null}','{\"sw\":null}'),(43,7,1,NULL,'/uploads/1668619426.jpg','{\"en\":\"Subway\",\"sw\":null}',1,'active','2022-11-16 17:23:46','2022-11-16 17:23:46','{\"en\":\"<p>Double Meet<\\/p>\",\"sw\":null}',2,'{\"sw\":null}','{\"sw\":null}'),(40,4,5,NULL,'/uploads/1668612825.jpg','{\"en\":\"Sushi Night\",\"sw\":null}',1,'active','2022-11-16 15:33:45','2022-11-16 15:33:45','{\"en\":\"<p>Every saturday<\\/p>\",\"sw\":null}',2,'{\"sw\":null}','{\"sw\":null}');
/*!40000 ALTER TABLE `deals` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `f_a_q_banners`
--

DROP TABLE IF EXISTS `f_a_q_banners`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `f_a_q_banners` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `banner_image` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `f_a_q_banners`
--

LOCK TABLES `f_a_q_banners` WRITE;
/*!40000 ALTER TABLE `f_a_q_banners` DISABLE KEYS */;
INSERT INTO `f_a_q_banners` VALUES (1,'/uploads/1661851405.jpg','2022-08-22 15:37:10','2022-08-30 16:23:25');
/*!40000 ALTER TABLE `f_a_q_banners` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `failed_jobs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `failed_jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `failed_jobs`
--

LOCK TABLES `failed_jobs` WRITE;
/*!40000 ALTER TABLE `failed_jobs` DISABLE KEYS */;
/*!40000 ALTER TABLE `failed_jobs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `faq_categories`
--

DROP TABLE IF EXISTS `faq_categories`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `faq_categories` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slug` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `image` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `faq_categories`
--

LOCK TABLES `faq_categories` WRITE;
/*!40000 ALTER TABLE `faq_categories` DISABLE KEYS */;
INSERT INTO `faq_categories` VALUES (1,'{\"en\":\"About Tiger Loyalty\",\"sw\":\"Taarifa Za Mteja\"}','{\"en\":\"about-tiger-loyalty\",\"sw\":\"taarifa-za-mteja\"}','{\"en\":\"<p>Tiger Loyalty is a platform that has removed friction within the reward system by creating a common shop credit that is earned and spent within the community, for the benefit of both the customer and the merchant.&nbsp;<\\/p>\",\"sw\":null}','2022-06-17 05:53:55','2022-08-31 16:34:33','/uploads/1661938473.jpg'),(2,'{\"en\":\"About Rewards & Shop Credits.\",\"sw\":\"Taarifa Za Jumla\"}','{\"en\":\"about-rewards-shop-credits\",\"sw\":\"taarifa-za-jumla\"}','{\"en\":\"<p>Tiger Loyalty has created a decentralized shop credit that can be earned and spent within the ecosystem. Customers are rewarded and given the freedom to spend rewards across our merchant community, and merchants can create different reward programs within the platform for deal seekers.&nbsp;<\\/p>\",\"sw\":null}','2022-06-17 05:53:55','2022-08-30 17:18:22','/uploads/1661854702.jpg'),(3,'{\"en\":\"Merchants Community\",\"sw\":\"Manunuzi\"}','{\"en\":\"merchants-community\",\"sw\":\"manunuzi\"}','{\"en\":\"<p>Our community of merchants has hundreds of reputable brands ready to serve the community of deal seekers. Tiger loyalty offers merchants an opportunity to increase sales traffic through repeat purchases by creating a bond with customers through loyalty.&nbsp;<\\/p>\",\"sw\":null}','2022-06-17 05:53:55','2022-08-31 16:35:13','/uploads/1661938513.jpg'),(5,'{\"en\":\"Customer Community\",\"sw\":null}','{\"en\":\"customer-community\",\"sw\":\"\"}','{\"en\":\"<p>Our community of customers who are deal seekers is known as the tribe. It is a community of individuals looking for value returns when spending, and locations or brands that appreciate their purchasing and referral efforts.&nbsp;<\\/p>\",\"sw\":null}','2022-08-24 13:41:33','2022-08-31 16:35:47','/uploads/1661938547.jpg'),(6,'{\"en\":\"About Payment\",\"sw\":null}','{\"en\":\"about-payment\",\"sw\":\"\"}','{\"en\":\"<p>Our shop credit can be spent across merchants within the community to purchase products and services.&nbsp;<\\/p>\",\"sw\":null}','2022-08-24 13:44:10','2022-08-31 16:36:16','/uploads/1661938576.jpg'),(4,'{\"en\":\"About Compliance\",\"sw\":null}','{\"en\":\"about-compliance\",\"sw\":\"\"}','{\"en\":\"<p>Tiger Loyalty is a platform that follows all Tanzanian laws and is highly regulated by the authorities. Our platform members are in the safe hands and so as our partners.&nbsp;<\\/p>\",\"sw\":null}','2022-06-28 15:07:31','2022-09-01 12:12:22','/uploads/1662009142.jpg');
/*!40000 ALTER TABLE `faq_categories` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `faqs`
--

DROP TABLE IF EXISTS `faqs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `faqs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `faqcategory` bigint unsigned NOT NULL,
  `question` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `answer` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `banner_image` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `keywords` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_description` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `faqs_faqcategory_foreign` (`faqcategory`)
) ENGINE=MyISAM AUTO_INCREMENT=35 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `faqs`
--

LOCK TABLES `faqs` WRITE;
/*!40000 ALTER TABLE `faqs` DISABLE KEYS */;
INSERT INTO `faqs` VALUES (1,4,'{\"en\":\"What kind of deals will be available in Tiger App?\",\"sw\":null}','{\"en\":\"<p>Merchants will provide discounts, offers, and loyalty programs as part of deals for our members.&nbsp;<\\/p>\",\"sw\":null}','2022-06-28 15:08:56','2022-08-22 15:32:31',NULL,NULL,NULL),(2,4,'{\"en\":\"What are the benefits of being a member of Tiger community?\",\"sw\":null}','{\"en\":\"<p>Tiger brings you fresh deals every day from our partner brands, and incentivizes you for purchasing and referral efforts.&nbsp;<\\/p>\",\"sw\":null}','2022-06-28 15:09:29','2022-08-22 15:34:08',NULL,NULL,NULL),(28,4,'{\"en\":\"How are my rights as a member protected?\",\"sw\":null}','{\"en\":\"<p>Tiger Loyalty T&amp;C is very member-centric and approved by FCC. &nbsp;<\\/p>\",\"sw\":null}','2022-08-22 15:35:11','2022-08-22 15:35:11',NULL,NULL,NULL),(4,1,'{\"en\":\"What is Tiger Loyalty?\",\"sw\":null}','{\"en\":\"<p>Tiger Loyalty is a platform that focuses on helping business growth through loyalty. We have combined loyalty rewards, payment and brand marketing in creating a bond between merchants and customers hence increasing sales traffic.&nbsp;<\\/p>\",\"sw\":null}','2022-08-20 14:57:34','2022-08-22 15:09:59',NULL,NULL,NULL),(5,1,'{\"en\":\"What is the difference between Tiger Loyalty and other loyalty programs?\",\"sw\":null}','{\"en\":\"<p>It is convenient for both the merchant and the customer, rewards can be spent across the ecosystem, and customers are rewarded upfront before spending.<\\/p>\",\"sw\":null}','2022-08-20 14:58:52','2022-08-22 15:10:13',NULL,NULL,NULL),(6,1,'{\"en\":\"Where is your office located?\",\"sw\":null}','{\"en\":\"<p>Tiger Loyalty Co Limited office is located at Mwanga Towers, 10th Floor, Left-wing. Kijitonyama, Dar es Salaam Tanzania.&nbsp;<\\/p>\",\"sw\":null}','2022-08-20 14:59:45','2022-08-29 19:54:13',NULL,'{\"sw\":null}','{\"sw\":null}'),(7,1,'{\"en\":\"How do I contact you for complaints?\",\"sw\":null}','{\"en\":\"<p>You can contact our help support through various channels; Phone number, Email, WhatsApp, or our social media, all provided on our website and application.<strong>&nbsp;<a href=\\\"mailto:info@tiger.co.tz?subject=Inquiry&amp;body=Inquirying%20about%20your%20services\\\">info@tiger.co.tz<\\/a><\\/strong><\\/p>\",\"sw\":null}','2022-08-20 15:00:53','2022-08-29 19:48:52',NULL,'{\"sw\":null}','{\"sw\":null}'),(8,2,'{\"en\":\"How do I get rewarded?\",\"sw\":null}','{\"en\":\"<p>You will be rewarded with a bonus of up-to 5% each time you purchase Tiger shop credit.&nbsp;<\\/p>\",\"sw\":null}','2022-08-20 15:07:32','2022-08-22 14:59:58',NULL,NULL,NULL),(9,2,'{\"en\":\"What is Tiger shop credit?\",\"sw\":null}','{\"en\":\"<p>Tiger shop credit is a decentralized reward system that allows our platform members to buy loyalty rewards in advance with the freedom to spend within the community of our merchants, anytime and anywhere.&nbsp;<\\/p>\",\"sw\":null}','2022-08-20 15:09:04','2022-08-22 15:00:16',NULL,NULL,NULL),(10,2,'{\"en\":\"How can I get Tiger shop credit?\",\"sw\":null}','{\"en\":\"<p>You can purchase Tiger shop credit through Tiger Loyalty application, from your mobile money wallet or bank channel.&nbsp;<\\/p>\",\"sw\":null}','2022-08-20 15:09:54','2022-08-22 15:00:28',NULL,NULL,NULL),(11,2,'{\"en\":\"Can I withdraw cash from my Tiger wallet?\",\"sw\":null}','{\"en\":\"<p>No, you cannot withdraw cash from Tiger wallet. The rewards must be spent within the ecosystem.&nbsp;<\\/p>\",\"sw\":null}','2022-08-20 15:11:10','2022-08-22 15:05:57',NULL,NULL,NULL),(12,2,'{\"en\":\"Can I cancel my reward and recall my cash?\",\"sw\":null}','{\"en\":\"<p>Yes, you can cancel rewards and reverse&nbsp;the&nbsp;cash back to your account or mobile wallet, T&amp;C applied.&nbsp;<\\/p>\",\"sw\":null}','2022-08-20 15:12:25','2022-08-22 15:06:19',NULL,NULL,NULL),(13,2,'{\"en\":\"How do I utilise Tiger shop credit?\",\"sw\":null}','{\"en\":\"<p>Tiger shop credit can be spent across the community of brands on our platform online or offline, and can also be shared with friends and family at zero cost.<strong>&nbsp;&nbsp;<\\/strong><\\/p>\",\"sw\":null}','2022-08-20 15:13:07','2022-08-22 15:06:34',NULL,NULL,NULL),(14,2,'{\"en\":\"What is the conversion rate of a Tiger shop credit to Tanzania Shillings?\",\"sw\":null}','{\"en\":\"<p>One Tiger shop credit is equal to one Tanzania Shilling (1 Tiger shop credit = tzs1)<\\/p>\",\"sw\":null}','2022-08-20 15:13:54','2022-08-22 15:06:54',NULL,NULL,NULL),(15,2,'{\"en\":\"Do Tiger shop credit tokens Expire?\",\"sw\":null}','{\"en\":\"<p>Tiger shop credit tokens do not expire, they can be kept in your tiger wallet for as long as you want.&nbsp;<\\/p>\",\"sw\":null}','2022-08-20 15:16:40','2022-08-22 15:08:03',NULL,NULL,NULL),(33,5,'{\"en\":\"What are the benefits of being a member of Tiger community?\",\"sw\":null}','{\"en\":\"<p><strong>Tiger brings you fresh deals every day from our partner brands, and&nbsp; incentivizes you for purchasing and referral efforts.&nbsp;<\\/strong><\\/p><p><br \\/>&nbsp;<\\/p>\",\"sw\":null}','2022-08-24 15:07:42','2022-08-24 15:07:42',NULL,NULL,NULL),(17,3,'{\"en\":\"How can Tiger help me with my business growth?\",\"sw\":null}','{\"en\":\"<p>Tiger Loyalty provides you a digital tool to monetize your customers, set up sales campaigns and customised loyalty programs that can promote your business.&nbsp;&nbsp;<\\/p>\",\"sw\":null}','2022-08-22 15:12:51','2022-08-22 15:12:51',NULL,NULL,NULL),(18,3,'{\"en\":\"Who is eligible to become a Merchant on Tiger Loyalty?\",\"sw\":null}','{\"en\":\"<p>Registered businesses and&nbsp;non-registered businesses (Individuals) can apply to become merchants.&nbsp;<\\/p>\",\"sw\":null}','2022-08-22 15:14:19','2022-08-22 15:14:19',NULL,NULL,NULL),(20,3,'{\"en\":\"How can I become a Merchant on Tiger Loyalty?\",\"sw\":null}','{\"en\":\"<p>Apply as a merchant by filling the available forms on our website, or download the App and follow the instructions.<\\/p>\",\"sw\":null}','2022-08-22 15:19:08','2022-08-22 15:19:08',NULL,NULL,NULL),(21,3,'{\"en\":\"How much does it cost to register as a Merchant on Tiger Loyalty?\",\"sw\":null}','{\"en\":\"<p>Registration is free,&nbsp;with&nbsp;no sign-up fees.<\\/p>\",\"sw\":null}','2022-08-22 15:20:19','2022-08-22 15:20:19',NULL,NULL,NULL),(22,3,'{\"en\":\"How am I paid as a merchant?\",\"sw\":null}','{\"en\":\"<p>Merchants will be settled via our partner bank to their designated bank account or mobile wallet.&nbsp;<\\/p>\",\"sw\":null}','2022-08-22 15:21:01','2022-08-22 15:21:01',NULL,NULL,NULL),(23,3,'{\"en\":\"How many settlement days before I get my cash to my account?\",\"sw\":null}','{\"en\":\"<p>With Tiger,&nbsp;you get the same day settlement on business days, and the following business day for weekends.&nbsp;<\\/p>\",\"sw\":null}','2022-08-22 15:21:56','2022-08-22 15:21:56',NULL,NULL,NULL),(24,3,'{\"en\":\"How do I cancel my partnership?\",\"sw\":null}','{\"en\":\"<p>To cancel your partnership with Tiger, contact the marketing personnel or visit our offices.&nbsp;<\\/p>\",\"sw\":null}','2022-08-22 15:23:04','2022-08-22 15:23:04',NULL,NULL,NULL),(26,3,'{\"en\":\"How are my rights as a merchant protected?\",\"sw\":null}','{\"en\":\"<p>&nbsp;Tiger Loyalty T&amp;C is very member-centric and approved by FCC.<\\/p>\",\"sw\":null}','2022-08-22 15:25:44','2022-08-22 15:25:44',NULL,NULL,NULL),(30,6,'{\"en\":\"What is the guarantee that my tokens are secured with Tiger Loyalty?\",\"sw\":null}','{\"en\":\"<p><strong>Tiger Loyalty is very particular with compliance issues. Customer funds are under the custodian of&nbsp; our partner bank.&nbsp; <\\/strong><\\/p>\",\"sw\":null}','2022-08-24 13:57:53','2022-08-24 13:57:53',NULL,NULL,NULL),(31,6,'{\"en\":\"How are my rights as a member protected?\",\"sw\":null}','{\"en\":\"<p><strong>Tiger Loyalty T&amp;C are very member-centric and approved by FCC. <\\/strong><\\/p>\",\"sw\":null}','2022-08-24 13:59:05','2022-08-24 13:59:05',NULL,NULL,NULL),(32,6,'{\"en\":\"How secure is Tiger Loyalty?\",\"sw\":null}','{\"en\":\"<p><strong>Tiger is working with a partner bank which is regulated by BOT.<\\/strong><\\/p>\",\"sw\":null}','2022-08-24 14:08:57','2022-08-24 14:08:57',NULL,NULL,NULL),(34,5,'{\"en\":\"How do I cancel my membership?\",\"sw\":null}','{\"en\":\"<p><strong>Simply log into your profile and go setting, then follow the instructions. <\\/strong><\\/p>\",\"sw\":null}','2022-08-24 15:10:02','2022-08-24 15:10:02',NULL,NULL,NULL);
/*!40000 ALTER TABLE `faqs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `footer_addresses`
--

DROP TABLE IF EXISTS `footer_addresses`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `footer_addresses` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `footer_item` bigint unsigned NOT NULL,
  `address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `footer_addresses_footer_item_foreign` (`footer_item`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `footer_addresses`
--

LOCK TABLES `footer_addresses` WRITE;
/*!40000 ALTER TABLE `footer_addresses` DISABLE KEYS */;
INSERT INTO `footer_addresses` VALUES (1,1,'<p>Tiger Loyalty Co. Ltd.<br />Mwanga Tower&nbsp;10th Floor - Left Wing,<br />Kijitonyama,&nbsp;New Bagamoyo Road,<br />P. O. Box 34200<br />Dar es salaam, Tanzania.<br />+255 758 559 000</p><p><a href=\"mailto:business@tiger.co.tz?subject=email\">business@tiger.co.tz</a></p>','2022-06-28 03:29:59','2022-09-09 22:18:49');
/*!40000 ALTER TABLE `footer_addresses` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `footer_descriptions`
--

DROP TABLE IF EXISTS `footer_descriptions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `footer_descriptions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `footer_item` bigint unsigned NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `footer_descriptions_footer_item_foreign` (`footer_item`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `footer_descriptions`
--

LOCK TABLES `footer_descriptions` WRITE;
/*!40000 ALTER TABLE `footer_descriptions` DISABLE KEYS */;
/*!40000 ALTER TABLE `footer_descriptions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `footer_items`
--

DROP TABLE IF EXISTS `footer_items`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `footer_items` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `type` bigint unsigned NOT NULL,
  `title` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `footer_items_type_foreign` (`type`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `footer_items`
--

LOCK TABLES `footer_items` WRITE;
/*!40000 ALTER TABLE `footer_items` DISABLE KEYS */;
INSERT INTO `footer_items` VALUES (1,2,'Address','2022-06-28 03:29:59','2022-06-28 03:29:59');
/*!40000 ALTER TABLE `footer_items` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `footer_links`
--

DROP TABLE IF EXISTS `footer_links`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `footer_links` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `footer_item` bigint unsigned NOT NULL,
  `label` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `pageid` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `footer_links_footer_item_foreign` (`footer_item`),
  KEY `footer_links_pageid_foreign` (`pageid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `footer_links`
--

LOCK TABLES `footer_links` WRITE;
/*!40000 ALTER TABLE `footer_links` DISABLE KEYS */;
/*!40000 ALTER TABLE `footer_links` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `footer_logos`
--

DROP TABLE IF EXISTS `footer_logos`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `footer_logos` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `logo` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `footer_logos`
--

LOCK TABLES `footer_logos` WRITE;
/*!40000 ALTER TABLE `footer_logos` DISABLE KEYS */;
INSERT INTO `footer_logos` VALUES (1,'/uploads/1656336715.png','2022-06-27 20:31:55','2022-06-27 20:31:55');
/*!40000 ALTER TABLE `footer_logos` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `footer_types`
--

DROP TABLE IF EXISTS `footer_types`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `footer_types` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `footer_types`
--

LOCK TABLES `footer_types` WRITE;
/*!40000 ALTER TABLE `footer_types` DISABLE KEYS */;
INSERT INTO `footer_types` VALUES (1,'links','2022-06-27 20:31:23','2022-06-27 20:31:23'),(2,'address','2022-06-27 20:31:23','2022-06-27 20:31:23'),(3,'description','2022-06-27 20:31:23','2022-06-27 20:31:23');
/*!40000 ALTER TABLE `footer_types` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `infringement_reports`
--

DROP TABLE IF EXISTS `infringement_reports`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `infringement_reports` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `firstname` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `lastname` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `incident` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `infringement_reports`
--

LOCK TABLES `infringement_reports` WRITE;
/*!40000 ALTER TABLE `infringement_reports` DISABLE KEYS */;
/*!40000 ALTER TABLE `infringement_reports` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `investor_updates`
--

DROP TABLE IF EXISTS `investor_updates`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `investor_updates` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `image` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `file` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date` date DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `investor_updates`
--

LOCK TABLES `investor_updates` WRITE;
/*!40000 ALTER TABLE `investor_updates` DISABLE KEYS */;
INSERT INTO `investor_updates` VALUES (1,'{\"en\":\"3rd Quarter Updates\",\"sw\":null}','{\"en\":\"<p>Investor Relations (IR)&nbsp;<strong>combines finance, communication, and marketing to effectively control the flow of information between a public company, its investors, and its stakeholders<\\/strong>. Investors play a major and vital role in the success and growth of a company.<\\/p>\",\"sw\":null}','/uploads/1661840684.jpg','{\"en\":\"\\/uploads\\/1661956222.pdf\",\"sw\":\"\\/uploads\\/\"}',NULL,'2022-06-28 15:06:48','2022-08-31 21:30:22'),(2,'{\"en\":\"2nd Quarter Updates\",\"sw\":null}','{\"en\":\"<p>Investors and partners updates<\\/p>\",\"sw\":null}','/uploads/1662016696.jpg','{\"en\":\"\\/uploads\\/1662016696.pdf\",\"sw\":\"\\/uploads\\/\"}',NULL,'2022-09-01 14:18:16','2022-09-01 14:18:16');
/*!40000 ALTER TABLE `investor_updates` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `lets_talks`
--

DROP TABLE IF EXISTS `lets_talks`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `lets_talks` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `lets_talk_text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `lets_talks`
--

LOCK TABLES `lets_talks` WRITE;
/*!40000 ALTER TABLE `lets_talks` DISABLE KEYS */;
/*!40000 ALTER TABLE `lets_talks` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `locations`
--

DROP TABLE IF EXISTS `locations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `locations` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slug` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `regionid` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `locations`
--

LOCK TABLES `locations` WRITE;
/*!40000 ALTER TABLE `locations` DISABLE KEYS */;
INSERT INTO `locations` VALUES (1,'Mikocheni','mikocheni','2022-06-17 01:11:04','2022-06-17 01:11:04',2),(2,'Mbezi','mbezi','2022-06-17 01:11:04','2022-06-17 01:11:04',2),(3,'Ubungo','ubungo','2022-06-17 01:11:04','2022-06-17 01:11:04',2),(4,'Masaki','masaki','2022-06-17 01:11:04','2022-07-04 20:49:08',2),(5,'Mbagala',NULL,'2022-07-04 20:49:21','2022-07-04 20:49:21',2),(6,'Ngaramtoni',NULL,'2022-07-05 03:18:14','2022-07-05 03:18:14',1),(7,'Mbagala',NULL,'2022-07-05 03:20:00','2022-07-05 03:20:00',2);
/*!40000 ALTER TABLE `locations` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `merchant_landings`
--

DROP TABLE IF EXISTS `merchant_landings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `merchant_landings` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `top_section_title` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `top_section_image` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `top_section_caption` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `top_section_button_label` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `top_section_button_link` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `second_section_title` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `second_section_text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `second_section_image` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `why_tiger_title` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `benefit_title_one` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `benefit_text_one` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `benefit_title_two` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `benefit_text_two` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `benefit_title_three` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `benefit_text_three` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `benefit_title_four` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `benefit_text_four` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `benefit_title_five` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `benefit_text_five` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `benefit_title_six` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `benefit_text_six` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `fourth_section_image` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fourth_section_title` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `fourth_section_caption` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `merchant_applestore_link` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `merchant_googleplay_store_link` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `customer_applestore_link` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `customer_googleplay_store_link` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deal_title` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `deal_caption` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `deal_button_label` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `deal_button_link` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deal_one` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deal_two` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deal_three` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deal_four` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `footer_image` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `about_tiger_title` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `about_tiger_text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `contact_title` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `contact_text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `newsletter_title` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `newsletter_caption` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `how_it_works_link` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mobile_top_section_image` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `risk_title` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `risk_quote` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `merchant_landings`
--

LOCK TABLES `merchant_landings` WRITE;
/*!40000 ALTER TABLE `merchant_landings` DISABLE KEYS */;
INSERT INTO `merchant_landings` VALUES (1,'{\"en\":\"Motivate your customers, drive traffic and grow.\",\"sw\":null}','1658307674.png','{\"en\":\"Sell anything to our Millions of member community online or offline.\",\"sw\":null}','{\"en\":\"Sell Now\",\"sw\":null}','/register','{\"en\":\"Our members are your customers & sales force\",\"sw\":null}','{\"en\":\"<p>We recognize entrepreneur&rsquo;s pains and challenges to start, manage and grow businesses. Tiger Loyalty solves these problems by financially empowering our customers with a 5% upfront shop credit bonus to motivate and channel them to brands they love, to shop for sustenance and welfare products and services.<br \\/><br \\/>Merchants can also promote their brands to our multitude of members community at the same time set up their customised reward programs for repeat purchases and referrals to grow sales traffic, patronage and market share.<\\/p>\",\"sw\":null}','1658307707.png','{\"en\":\"Why Tiger\",\"sw\":\"Why Tiger\"}','{\"en\":\"Guarantees Sales\",\"sw\":\"Guarantees Sales\"}','{\"en\":\"We guarantee constant sales traffic through repeat purchases and referrals by members.\",\"sw\":null}','{\"en\":\"Business Growth\",\"sw\":\"Business Growth\"}','{\"en\":\"Create an authentic engagement with your customers for a compelling service delivery that builds true loyalty for business growth.\",\"sw\":null}','{\"en\":\"Personalized Loyalty\",\"sw\":\"Personalized Loyalty\"}','{\"en\":\"Small and large businesses can set up loyalty programs that suit their peculiarities whether to boost sales or new customer acquisitions.\",\"sw\":null}','{\"en\":\"Same Day Settlement\",\"sw\":\"Same Day Settlement\"}','{\"en\":\"Our same-day collection, reconciliation, and settlement are powered by our partner banks.\",\"sw\":null}','{\"en\":\"Suitability\",\"sw\":\"Suitability\"}','{\"en\":\"Suitable for both registered or non-registered, established or start-up, online or offline businesses.\",\"sw\":null}','{\"en\":\"Free sign Up\",\"sw\":\"Free sign Up\"}','{\"en\":\"There are no costs whether for upfront payment, hardware, software, maintenance, or any training required.\",\"sw\":null}','1658307707.png','{\"en\":\"We care about your business.\",\"sw\":\"We care about your business.\"}','{\"en\":\"Tiger Loyalty avails you the power to award and redeem your shop credits with a dashboard to track your loyalty performance effectively, effortlessly and transparently  We automatically keep a record of every transaction for both the merchant and customer to further unlock additional reward as may be set by merchants as an incentive for patronage and advocacy.\",\"sw\":\"Tiger Loyalty avails you the power to award and redeem your shop credits with a dashboard to track your loyalty performance effectively, effortlessly and transparently  We automatically keep a record of every transaction for both the merchant and customer to further unlock additional reward as may be set by merchants as an incentive for patronage and advocacy.\"}','https://apps.apple.com/tz/app/tiger-merchant/id1627441521','https://play.google.com/store/apps/details?id=com.vendors.tiger','https://apps.apple.com/tz/app/tiger-loyalty/id1639509008','https://play.google.com/store/apps/details?id=com.babjonii.tigerloyalty','{\"en\":\"Inspired by Deals!\",\"sw\":\"Inspired by Deals!\"}','{\"en\":\"Businesses that reward customers stand a better chance to grow brand loyalty for growth and sustainability.  Tiger Loyalty offers beyond brand satisfaction to customer engagement. We take away the heavy lifting in marketing and sales activities from businesses and allow them to focus on creating and delivering great products and services.\",\"sw\":\"Businesses that reward customers stand a better chance to grow brand loyalty for growth and sustainability.  Tiger Loyalty offers beyond brand satisfaction to customer engagement. We take away the heavy lifting in marketing and sales activities from businesses and allow them to focus on creating and delivering great products and services.\"}','{\"en\":\"Checkout Hot Deals\",\"sw\":null}','https://tiger.testing.co.tz/deals','2','8','4','5','1658307622.png','{\"en\":\"Tiger Loyalty\",\"sw\":null}','{\"en\":\"<p>We started out with one goal in mind: to create a common loyalty shop credit system for small businesses to encourage and incentivize continuous brand patronage for customers benefits upfront, transparently, &amp; securely while giving them the control to spend anywhere, anyhow, and anytime. It is our promise.<br \\/><br \\/>By rethinking reward systems and working with banks and industry regulators, Tiger Loyalty has developed a unique business model that reduces friction in loyalty system to support SMEs to grow their businesses, exponentially, drive customer patronage and economic consumption for increase GDP in Tanzania.<\\/p>\",\"sw\":null}','{\"en\":\"Contact Us\",\"sw\":null}','{\"en\":\"<p>Tiger Loyalty Co. Ltd.<br \\/>Mwanga Tower 10th Floor - Left Wing,<br \\/>Kijitonyama, New Bagamoyo Road,<br \\/>Dar es salaam, Tanzania.<\\/p>\",\"sw\":null}','{\"sw\":null}','{\"sw\":null}','2022-07-20 16:00:22','2022-11-15 14:49:45','https://vimeo.com/744866595','/uploads//uploads/','Risk Reversal Guarantee Statement','<p>All financial transactions on Tiger Loyalty platform are duly carried out, guaranteed and insured by our partner commercial bankers to ensure complete financial compliance.</p>');
/*!40000 ALTER TABLE `merchant_landings` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `migrations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `migrations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=237 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `migrations` WRITE;
/*!40000 ALTER TABLE `migrations` DISABLE KEYS */;
INSERT INTO `migrations` VALUES (165,'2014_10_12_000000_create_users_table',1),(166,'2014_10_12_100000_create_password_resets_table',1),(167,'2019_08_19_000000_create_failed_jobs_table',1),(168,'2019_12_14_000001_create_personal_access_tokens_table',1),(169,'2022_05_15_135945_create_page_types_table',1),(170,'2022_05_29_171509_create_deal_types_table',1),(171,'2022_05_30_064126_create_permission_tables',1),(172,'2022_05_30_095352_create_categories_table',1),(173,'2022_05_30_095458_create_vendors_table',1),(174,'2022_05_30_095623_create_sliders_table',1),(175,'2022_05_30_102011_create_locations_table',1),(176,'2022_05_30_102054_create_regions_table',1),(177,'2022_05_30_102722_create_deals_table',1),(178,'2022_05_31_170752_create_vendor_locations_table',1),(179,'2022_05_31_170924_create_vendor_categories_table',1),(180,'2022_06_01_160535_create_audit_trails_table',1),(181,'2022_06_01_164013_create_vendor_landings_table',1),(182,'2022_06_01_164305_create_pages_table',1),(183,'2022_06_01_164557_create_page_files_table',1),(184,'2022_06_01_165111_create_page_buttons_table',1),(185,'2022_06_01_171215_create_posts_table',1),(186,'2022_06_01_171355_create_post_media_table',1),(187,'2022_06_15_093648_add_columns_deals_table',1),(188,'2022_06_15_121955_add_new_slider_columns',1),(189,'2022_06_15_131736_add_landing_page_image_category',1),(190,'2022_06_15_140115_add_pagetype_column_to_pages',1),(191,'2022_06_15_170126_create_vacancies_table',1),(192,'2022_06_15_170945_create_infringement_reports_table',1),(193,'2022_06_15_171754_create_tiger_settings_table',1),(194,'2022_06_15_171820_create_faq_categories_table',1),(195,'2022_06_15_172043_create_faqs_table',1),(196,'2022_06_15_221637_add_missing_column_posts',1),(197,'2022_06_16_060736_create_investor_updates_table',1),(198,'2022_06_16_175633_change_on_sliders',1),(199,'2022_06_23_114450_create_footer_types_table',2),(200,'2022_06_23_114600_create_footer_items_table',2),(201,'2022_06_23_114841_create_footer_links_table',2),(202,'2022_06_23_114852_create_footer_addresses_table',2),(203,'2022_06_23_114911_create_footer_descriptions_table',2),(204,'2022_06_23_115223_create_footer_logos_table',2),(205,'2022_06_23_123929_create_social_media_table',2),(206,'2022_06_26_174717_add_schema_updates',2),(207,'2022_06_26_183828_create_customer_landings_table',2),(208,'2022_06_28_071910_add_columns_on_customerlanding',3),(209,'2022_06_28_084119_add_columns_on__new_customerlanding',4),(210,'2022_07_02_100901_add_latitude_longitude',5),(211,'2022_07_04_124818_add_more_columns_custormerlanding',6),(212,'2022_07_04_170625_add_region_column_on_location',7),(213,'2022_07_04_190848_add_region_column_on_vendor_locations',7),(214,'2022_07_04_195710_add_region_column_on_deals',7),(215,'2022_07_04_203235_add_column_middle_section_image',8),(216,'2022_07_04_204840_create_search_terms_table',9),(217,'2022_07_04_205050_create_lets_talks_table',9),(218,'2022_07_04_205102_create_contacts_table',9),(219,'2022_07_08_065534_add_missing_columns',9),(220,'2022_07_14_102947_create_merchant_landings_table',10),(221,'2022_07_14_103042_create_client_landings_table',10),(222,'2022_08_21_095611_add_faq_category_image',11),(223,'2022_08_21_095743_add_faq_banner_image',11),(224,'2022_08_21_100051_create_f_a_q_banners_table',11),(225,'2022_08_24_091854_add_seo_columns',12),(226,'2022_08_29_094527_add_merchant_landing',13),(227,'2022_08_30_091717_create_our_teams_table',14),(228,'2022_08_30_185904_change_column_description',15),(229,'2022_09_01_182158_create_term_conditions_table',16),(230,'2022_09_02_070635_create_term_condition_customers_table',17),(231,'2022_09_14_195220_create_careers_table',18),(232,'2022_09_21_110605_add_columns_merchant_landing',19),(233,'2022_09_21_113727_create_testimonials_table',19),(234,'2022_09_22_110430_add_columns_customer_landing',19),(235,'2023_02_10_105333_add_button_link_in_sliders',20),(236,'2023_02_17_055608_add_column_button_title',21);
/*!40000 ALTER TABLE `migrations` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `model_has_permissions`
--

DROP TABLE IF EXISTS `model_has_permissions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `model_has_permissions` (
  `permission_id` bigint unsigned NOT NULL,
  `model_type` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`model_id`,`model_type`),
  KEY `model_has_permissions_model_id_model_type_index` (`model_id`,`model_type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `model_has_permissions`
--

LOCK TABLES `model_has_permissions` WRITE;
/*!40000 ALTER TABLE `model_has_permissions` DISABLE KEYS */;
/*!40000 ALTER TABLE `model_has_permissions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `model_has_roles`
--

DROP TABLE IF EXISTS `model_has_roles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `model_has_roles` (
  `role_id` bigint unsigned NOT NULL,
  `model_type` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`role_id`,`model_id`,`model_type`),
  KEY `model_has_roles_model_id_model_type_index` (`model_id`,`model_type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `model_has_roles`
--

LOCK TABLES `model_has_roles` WRITE;
/*!40000 ALTER TABLE `model_has_roles` DISABLE KEYS */;
INSERT INTO `model_has_roles` VALUES (1,'App\\Models\\User',1),(1,'App\\Models\\User',2),(1,'App\\Models\\User',3);
/*!40000 ALTER TABLE `model_has_roles` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `our_teams`
--

DROP TABLE IF EXISTS `our_teams`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `our_teams` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `keywords` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `our_teams`
--

LOCK TABLES `our_teams` WRITE;
/*!40000 ALTER TABLE `our_teams` DISABLE KEYS */;
INSERT INTO `our_teams` VALUES (1,'{\"en\":\"Our Team\",\"sw\":\"dsds\"}','/uploads/1663081557.jpg','{\"en\":\"<p>We are proud to have built a balanced team of diverse professionals with strong business acumen, hard skills and probing mind set. Our strong ownership mentality and passion drive our love to challenge how &nbsp;we use technology to solve big problems for the undeserved mass markets.<\\/p>\",\"sw\":null}','{\"en\":\"tcb,jobs,businessanalyst\",\"sw\":null}','{\"en\":\"gdfsfg\",\"sw\":null}','2022-08-31 03:05:21','2022-09-13 22:05:57');
/*!40000 ALTER TABLE `our_teams` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `page_buttons`
--

DROP TABLE IF EXISTS `page_buttons`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `page_buttons` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `pageid` bigint unsigned NOT NULL,
  `text` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `text_colour` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `background_colour` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `page_buttons_pageid_foreign` (`pageid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `page_buttons`
--

LOCK TABLES `page_buttons` WRITE;
/*!40000 ALTER TABLE `page_buttons` DISABLE KEYS */;
/*!40000 ALTER TABLE `page_buttons` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `page_files`
--

DROP TABLE IF EXISTS `page_files`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `page_files` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `pageid` bigint unsigned NOT NULL,
  `filetype` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `file` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `page_files_pageid_foreign` (`pageid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `page_files`
--

LOCK TABLES `page_files` WRITE;
/*!40000 ALTER TABLE `page_files` DISABLE KEYS */;
/*!40000 ALTER TABLE `page_files` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `page_types`
--

DROP TABLE IF EXISTS `page_types`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `page_types` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slug` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `page_types`
--

LOCK TABLES `page_types` WRITE;
/*!40000 ALTER TABLE `page_types` DISABLE KEYS */;
INSERT INTO `page_types` VALUES (1,'Content','content','2022-06-17 05:53:41','2022-06-17 05:53:41'),(2,'Press Release','press-release','2022-06-17 05:53:41','2022-06-17 05:53:41'),(3,'Investor Relations','investor-relations','2022-06-17 05:53:41','2022-06-17 05:53:41'),(4,'Vacancy','vacancy','2022-06-17 05:53:41','2022-06-17 05:53:41'),(5,'FAQ','faq','2022-06-17 05:53:41','2022-06-17 05:53:41'),(6,'Gallery','gallery','2022-06-17 05:53:41','2022-06-17 05:53:41'),(7,'Infringement','infringement','2022-06-17 05:53:41','2022-06-17 05:53:41'),(8,'Contact Us','contact-us',NULL,NULL);
/*!40000 ALTER TABLE `page_types` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `pages`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `pages` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `tagline` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `caption` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slug` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `featured_image` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `pagetype` bigint unsigned NOT NULL,
  `keywords` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_description` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `pages_pagetype_foreign` (`pagetype`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pages`
--

LOCK TABLES `pages` WRITE;
/*!40000 ALTER TABLE `pages` DISABLE KEYS */;
INSERT INTO `pages` VALUES (5,'{\"en\":\"Featured Image\",\"sw\":null}','{\"sw\":null}','{\"sw\":null}',NULL,'featured-image','/uploads/1662537081.jpg',NULL,'2022-09-07 14:51:21','2022-09-07 14:51:21',8,'{\"sw\":null}','{\"sw\":null}'),(2,'{\"en\":\"Featured image\",\"sw\":null}','{\"sw\":null}','{\"sw\":null}',NULL,'featured-image','/uploads/1661781413.jpg',NULL,'2022-08-29 20:56:53','2022-08-29 20:56:53',2,'{\"sw\":null}','{\"sw\":null}'),(3,'{\"en\":\"Featured Image\",\"sw\":null}','{\"sw\":null}','{\"sw\":null}',NULL,'featured-image','/uploads/1661882284.jpg',NULL,'2022-08-31 00:58:04','2022-08-31 00:58:04',3,'{\"sw\":null}','{\"sw\":null}'),(4,'{\"en\":\"Featured Image\",\"sw\":null}','{\"sw\":null}','{\"sw\":null}',NULL,'featured-image','/uploads/1661882450.jpg',NULL,'2022-08-31 01:00:50','2022-08-31 01:00:50',4,'{\"sw\":null}','{\"sw\":null}');
/*!40000 ALTER TABLE `pages` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `password_resets`
--

DROP TABLE IF EXISTS `password_resets`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `password_resets` (
  `email` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  KEY `password_resets_email_index` (`email`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `password_resets`
--

LOCK TABLES `password_resets` WRITE;
/*!40000 ALTER TABLE `password_resets` DISABLE KEYS */;
/*!40000 ALTER TABLE `password_resets` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `permissions`
--

DROP TABLE IF EXISTS `permissions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `permissions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `permissions_name_guard_name_unique` (`name`,`guard_name`)
) ENGINE=MyISAM AUTO_INCREMENT=41 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `permissions`
--

LOCK TABLES `permissions` WRITE;
/*!40000 ALTER TABLE `permissions` DISABLE KEYS */;
INSERT INTO `permissions` VALUES (1,'user.create','web','2022-06-17 01:11:04','2022-06-17 01:11:04'),(2,'user.edit','web','2022-06-17 01:11:04','2022-06-17 01:11:04'),(3,'user.delete','web','2022-06-17 01:11:04','2022-06-17 01:11:04'),(4,'user.view','web','2022-06-17 01:11:04','2022-06-17 01:11:04'),(5,'vendor.create','web','2022-06-17 01:11:04','2022-06-17 01:11:04'),(6,'vendor.edit','web','2022-06-17 01:11:04','2022-06-17 01:11:04'),(7,'vendor.delete','web','2022-06-17 01:11:04','2022-06-17 01:11:04'),(8,'vendor.view','web','2022-06-17 01:11:04','2022-06-17 01:11:04'),(9,'deal.create','web','2022-06-17 01:11:04','2022-06-17 01:11:04'),(10,'deal.edit','web','2022-06-17 01:11:04','2022-06-17 01:11:04'),(11,'deal.delete','web','2022-06-17 01:11:04','2022-06-17 01:11:04'),(12,'deal.view','web','2022-06-17 01:11:04','2022-06-17 01:11:04'),(13,'order.create','web','2022-06-17 01:11:04','2022-06-17 01:11:04'),(14,'order.edit','web','2022-06-17 01:11:04','2022-06-17 01:11:04'),(15,'order.delete','web','2022-06-17 01:11:04','2022-06-17 01:11:04'),(16,'order.view','web','2022-06-17 01:11:04','2022-06-17 01:11:04'),(17,'slider.create','web','2022-06-17 01:11:04','2022-06-17 01:11:04'),(18,'slider.edit','web','2022-06-17 01:11:04','2022-06-17 01:11:04'),(19,'slider.delete','web','2022-06-17 01:11:04','2022-06-17 01:11:04'),(20,'slider.view','web','2022-06-17 01:11:04','2022-06-17 01:11:04'),(21,'customer.create','web','2022-06-17 01:11:04','2022-06-17 01:11:04'),(22,'customer.edit','web','2022-06-17 01:11:04','2022-06-17 01:11:04'),(23,'customer.delete','web','2022-06-17 01:11:04','2022-06-17 01:11:04'),(24,'customer.view','web','2022-06-17 01:11:04','2022-06-17 01:11:04'),(25,'category.create','web','2022-06-17 01:11:04','2022-06-17 01:11:04'),(26,'category.edit','web','2022-06-17 01:11:04','2022-06-17 01:11:04'),(27,'category.delete','web','2022-06-17 01:11:04','2022-06-17 01:11:04'),(28,'category.view','web','2022-06-17 01:11:04','2022-06-17 01:11:04'),(29,'vendorlanding.create','web','2022-06-17 01:11:04','2022-06-17 01:11:04'),(30,'vendorlanding.edit','web','2022-06-17 01:11:04','2022-06-17 01:11:04'),(31,'vendorlanding.delete','web','2022-06-17 01:11:04','2022-06-17 01:11:04'),(32,'vendorlanding.view','web','2022-06-17 01:11:04','2022-06-17 01:11:04'),(33,'page.create','web','2022-06-17 01:11:04','2022-06-17 01:11:04'),(34,'page.edit','web','2022-06-17 01:11:04','2022-06-17 01:11:04'),(35,'page.delete','web','2022-06-17 01:11:04','2022-06-17 01:11:04'),(36,'page.view','web','2022-06-17 01:11:04','2022-06-17 01:11:04'),(37,'vacancy.create','web','2022-06-17 01:11:04','2022-06-17 01:11:04'),(38,'vacancy.edit','web','2022-06-17 01:11:04','2022-06-17 01:11:04'),(39,'vacancy.delete','web','2022-06-17 01:11:04','2022-06-17 01:11:04'),(40,'vacancy.view','web','2022-06-17 01:11:04','2022-06-17 01:11:04');
/*!40000 ALTER TABLE `permissions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `personal_access_tokens`
--

DROP TABLE IF EXISTS `personal_access_tokens`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `personal_access_tokens` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `tokenable_type` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `tokenable_id` bigint unsigned NOT NULL,
  `name` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `abilities` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `last_used_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
  KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `personal_access_tokens`
--

LOCK TABLES `personal_access_tokens` WRITE;
/*!40000 ALTER TABLE `personal_access_tokens` DISABLE KEYS */;
/*!40000 ALTER TABLE `personal_access_tokens` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `post_media`
--

DROP TABLE IF EXISTS `post_media`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `post_media` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `postid` bigint unsigned NOT NULL,
  `media` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `post_media_postid_foreign` (`postid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `post_media`
--

LOCK TABLES `post_media` WRITE;
/*!40000 ALTER TABLE `post_media` DISABLE KEYS */;
/*!40000 ALTER TABLE `post_media` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `posts`
--

DROP TABLE IF EXISTS `posts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `posts` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `date` date DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `image` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `author` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `keywords` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_description` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `posts`
--

LOCK TABLES `posts` WRITE;
/*!40000 ALTER TABLE `posts` DISABLE KEYS */;
INSERT INTO `posts` VALUES (3,'{\"en\":\"THE DOWNSIDE OF LOYALTY PROGRAMS\",\"sw\":null}','{\"en\":\"<p>What is the benefit of a gift that is worthless to the beneficiary at times of need?<\\/p><p>The more I think about his question the more worried and curious I became, to know why I should deserve a gift, earned it, and not be able to use the same gift in my time of extreme need. The more I thought about it the more it became clearer to me that truly there are rewards that hold value, but the values are worthless to the beneficiary but only to serve the interest of the giver of the rewards. The first that jumps at me is a typical loyalty scheme, where the merchant incentives a customer with reward tokens for patronage but the reward now acts as a trap that further ring-fences the customer to continue patronizing the same merchant. The worst part is that the customer is blindfolded from seeking options in the market because of the reward.<\\/p><p>We sometimes get so blindfolded to see the options, flavours, styles, flexibilities, and beauty of openness, convenience, and cost savings. In this day and age of the digital economy, every true gift should allow the recipient of a reward to exercise options to redeem and use the reward at his discretion to benefit his situation and desires. Loyalty Schemes should give rewards that consumers can use to their advantage not necessarily to coarse recipients to be strung to their aprons by redemption that is exclusive at their stores for their priorities alone. The big question now is: whose benefit should a Loyalty program be helping?&nbsp;<\\/p><p>At Tiger Loyalty, we work with merchants to develop loyalty products that our platform members truly value &ndash; upfront, transparent, and flexible reward system that can be redeemed anywhere of their interest and choice. This in turn will generate organic and exponential transaction traffic for our platform merchants to boost their sales for a true a win-win value.<\\/p>\",\"sw\":null}',NULL,'2022-07-01 17:14:21','2022-07-01 17:14:21','/uploads/1656670461.jpg','admin admin',NULL,NULL),(2,'{\"en\":\"The New Loyalty Scheme\",\"sw\":null}','{\"en\":\"<p>Imagine every&nbsp;<strong>HELLO<\\/strong>&nbsp;word you spoke to a stranger could deposit little cash tokens into your digital wallet. And the freedom to spend these tokens on a rainy day anywhere, anytime across multiple merchants.<\\/p><p>Imagine how such tokens could be a life saver on a rainy day, or you could even transfer these tokens to a friend or family member in need!&nbsp;<\\/p><p>Imagine that the transfer fee was zero.<\\/p><p>Imagine how much more you could have purchased, or a source of blessing, relief, and love to people around you.&nbsp;<\\/p><p>Imagine how much you can empower people and the big smile you could have created!&nbsp;<\\/p><p>It&rsquo;s that easy.&nbsp;<\\/p><p>It&rsquo;s Tiger Loyalty!<br \\/>&nbsp;<\\/p>\",\"sw\":null}',NULL,'2022-07-01 17:02:03','2022-07-01 17:02:03','/uploads/1656669723.jpg','admin admin',NULL,NULL),(4,'{\"en\":\"WHEN A GIFT IS A BURDEN\",\"sw\":null}','{\"en\":\"<p>What is the purpose of a gift if it cannot be useful to the recipient when it is how and mostly needed? What is its usefulness as a gift if it does not attend to the need and aspirations of the beneficiary? It might mean that the gift only answers to the priorities of the giver. Maybe it is not a &lsquo;gift&rsquo; but a trap or burden to the recipient.<\\/p><p>Let&rsquo;s break it down further. Most loyalty programs are not intended to benefit customers as it may appear but to serve the agenda of the store (giver) in this case.&nbsp;&nbsp;Often, we hear promotional slogans like &ldquo;buy three and get one free&rdquo;. This sounds great! Imagine a situation where the offer was a 200L jar of coconut oil body lotion the store owner was trying to offload. This means that a customer will buy 600L of lotion to get a 200L bonus. How long will it take the customer to use all the 600L of lotion he paid for before using the bonus that was earned? I bet you it cannot be less than a year if he lives alone and lavishly shinning his skin daily with coconut body lotion. This means the customer cannot benefit until a year later hoping the lotion did not expire or lost its texture and value. But interestingly, the shop and the owner had cashed in their benefits instantly when the customer bought and paid for the product.&nbsp;<\\/p><p>Merchants have over the years used this trick on customers gullibly to meet their missions while pretending to be customer &ldquo;loving or caring&rdquo;. This is where Tiger Loyalty brings in a compelling proposition that a merchant can truly reward a customer to show genuine care and love for their patronage and instantly too. The shop offers customers its digital reward shop credits for patronage. Customers are granted the freedom to spend the shop credits anywhere, anyhow, and anytime they so wish. This is the true reward for a customer who patronized a brand with their hard-earned money in return for a shop credit that is not just transparent, flexible but importantly gives control to customers. These are what matters most to customers to remember such a shop for a repeat visit and patronage.<\\/p>\",\"sw\":null}',NULL,'2022-07-01 17:17:56','2022-07-01 17:17:56','/uploads/1656670676.jpg','admin admin',NULL,NULL);
/*!40000 ALTER TABLE `posts` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `regions`
--

DROP TABLE IF EXISTS `regions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `regions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `countryid` int DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=27 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `regions`
--

LOCK TABLES `regions` WRITE;
/*!40000 ALTER TABLE `regions` DISABLE KEYS */;
INSERT INTO `regions` VALUES (1,'Arusha','arusha',1,NULL,'2022-05-17 01:36:37','2022-05-17 01:36:37'),(2,'Dar es salaam','dar-es-salaam',1,NULL,'2022-05-17 01:36:37','2022-05-17 01:36:37'),(3,'Dodoma','dodoma',1,NULL,'2022-05-17 01:36:37','2022-05-17 01:36:37'),(4,'Geita','geita',1,NULL,'2022-05-17 01:36:37','2022-05-17 01:36:37'),(5,'Iringa','iringa',1,NULL,'2022-05-17 01:36:37','2022-05-17 01:36:37'),(6,'Kagera','kagera',1,NULL,'2022-05-17 01:36:37','2022-05-17 01:36:37'),(7,'Katavi','katavi',1,NULL,'2022-05-17 01:36:37','2022-05-17 01:36:37'),(8,'Kigoma','kigoma',1,NULL,'2022-05-17 01:36:37','2022-05-17 01:36:37'),(9,'Kilimanjaro','kilimanjaro',1,NULL,'2022-05-17 01:36:37','2022-05-17 01:36:37'),(10,'Lindi','lindi',1,NULL,'2022-05-17 01:36:37','2022-05-17 01:36:37'),(11,'Manyara','manyara',1,NULL,'2022-05-17 01:36:37','2022-05-17 01:36:37'),(12,'Mara','mara',1,NULL,'2022-05-17 01:36:37','2022-05-17 01:36:37'),(13,'Mbeya','mbeya',1,NULL,'2022-05-17 01:36:37','2022-05-17 01:36:37'),(14,'Morogoro','morogoro',1,NULL,'2022-05-17 01:36:37','2022-05-17 01:36:37'),(15,'Mtwara','mtwara',1,NULL,'2022-05-17 01:36:37','2022-05-17 01:36:37'),(16,'Mwanza','mwanza',1,NULL,'2022-05-17 01:36:37','2022-05-17 01:36:37'),(17,'Njombe','njombe',1,NULL,'2022-05-17 01:36:37','2022-05-17 01:36:37'),(18,'Pwani','pwani',1,NULL,'2022-05-17 01:36:37','2022-05-17 01:36:37'),(19,'Rukwa','rukwa',1,NULL,'2022-05-17 01:36:37','2022-05-17 01:36:37'),(20,'Shinyanga','shinyanga',1,NULL,'2022-05-17 01:36:37','2022-05-17 01:36:37'),(21,'Simiyu','simiyu',1,NULL,'2022-05-17 01:36:37','2022-05-17 01:36:37'),(22,'Singida','singida',1,NULL,'2022-05-17 01:36:37','2022-05-17 01:36:37'),(23,'Songwe','songwe',1,NULL,'2022-05-17 01:36:37','2022-05-17 01:36:37'),(24,'Tabora','tabora',1,NULL,'2022-05-17 01:36:37','2022-05-17 01:36:37'),(25,'Tanga','tanga',1,NULL,'2022-05-17 01:36:37','2022-05-17 01:36:37'),(26,'Ruvuma','ruvuma',1,NULL,'2022-05-17 01:36:37','2022-05-17 01:36:37');
/*!40000 ALTER TABLE `regions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `role_has_permissions`
--

DROP TABLE IF EXISTS `role_has_permissions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `role_has_permissions` (
  `permission_id` bigint unsigned NOT NULL,
  `role_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`role_id`),
  KEY `role_has_permissions_role_id_foreign` (`role_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `role_has_permissions`
--

LOCK TABLES `role_has_permissions` WRITE;
/*!40000 ALTER TABLE `role_has_permissions` DISABLE KEYS */;
INSERT INTO `role_has_permissions` VALUES (1,1),(2,1),(3,1),(4,1),(5,1),(6,1),(7,1),(8,1),(9,1),(10,1),(11,1),(12,1),(13,1),(14,1),(15,1),(16,1),(17,1),(18,1),(19,1),(20,1),(21,1),(22,1),(23,1),(24,1);
/*!40000 ALTER TABLE `role_has_permissions` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `roles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `roles` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `roles_name_guard_name_unique` (`name`,`guard_name`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `roles`
--

LOCK TABLES `roles` WRITE;
/*!40000 ALTER TABLE `roles` DISABLE KEYS */;
INSERT INTO `roles` VALUES (1,'superadmin','web','2022-06-17 01:11:04','2022-06-17 01:11:04'),(2,'customer','web','2022-06-17 01:11:04','2022-06-17 01:11:04'),(3,'system','web','2022-06-17 01:11:04','2022-06-17 01:11:04');
/*!40000 ALTER TABLE `roles` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `search_terms`
--

DROP TABLE IF EXISTS `search_terms`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `search_terms` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `search_term` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `search_terms`
--

LOCK TABLES `search_terms` WRITE;
/*!40000 ALTER TABLE `search_terms` DISABLE KEYS */;
/*!40000 ALTER TABLE `search_terms` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sliders`
--

DROP TABLE IF EXISTS `sliders`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sliders` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `image` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `caption` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `tagline` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `button_link` varchar(125) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `button_title` varchar(125) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sliders`
--

LOCK TABLES `sliders` WRITE;
/*!40000 ALTER TABLE `sliders` DISABLE KEYS */;
INSERT INTO `sliders` VALUES (1,'/uploads/1657018960.png','{\"en\":\"Vendors image\",\"sw\":null}','2022-07-05 18:02:41','2023-02-10 10:56:08','{\"en\":\"Trending deal\",\"sw\":null}','https:://slider.gigi',NULL),(2,'/uploads/1657019326.png','{\"en\":\"Smile\",\"sw\":null}','2022-07-05 18:08:47','2022-07-05 18:08:47','{\"en\":\"Trending deal\",\"sw\":null}',NULL,NULL),(3,'/uploads/1657019372.png','{\"en\":\"Deal hunters\",\"sw\":null}','2022-07-05 18:09:32','2022-07-05 18:09:32','{\"en\":\"Trending deal\",\"sw\":null}',NULL,NULL);
/*!40000 ALTER TABLE `sliders` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `social_media`
--

DROP TABLE IF EXISTS `social_media`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `social_media` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `media` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `link` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `social_media`
--

LOCK TABLES `social_media` WRITE;
/*!40000 ALTER TABLE `social_media` DISABLE KEYS */;
INSERT INTO `social_media` VALUES (1,'facebook','https://www.facebook.com/tigerloyaltytz','2022-08-24 19:39:15','2022-08-24 19:39:15'),(2,'twitter','https://twitter.com/tigerloyalty_tz','2022-08-24 19:39:15','2022-08-24 19:39:15'),(3,'linkedin','https://www.linkedin.com/in/tiger-loyalty-798883241/','2022-08-24 19:39:15','2022-08-24 19:39:15'),(4,'instagram','https://www.instagram.com/tigerloyalty_tz/','2022-08-24 19:39:15','2022-08-24 19:39:15');
/*!40000 ALTER TABLE `social_media` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `term_condition_customers`
--

DROP TABLE IF EXISTS `term_condition_customers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `term_condition_customers` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `term_conditions` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `term_condition_customers`
--

LOCK TABLES `term_condition_customers` WRITE;
/*!40000 ALTER TABLE `term_condition_customers` DISABLE KEYS */;
INSERT INTO `term_condition_customers` VALUES (1,'{\"en\":\"<p><strong>Welcome to TIGER!<\\/strong><\\/p><p>TIGER LOYALTY COMPANY&nbsp;(Tiger) provides Application and website features and other products and services to you when you visit&nbsp;&nbsp;<a href=\\\"http:\\/\\/www.tiger.co.tz\\/\\\">www.tiger.co.tz<\\/a>&nbsp;(the &quot;website&quot; ) or download&nbsp;&nbsp;Tiger Mobile Application, use TIGER devices, products, or services, use Tiger applications for mobile, or use software provided by Tiger Loyalty company in connection with any of the foregoing (collectively &quot;TIGER Services&quot;). Please see our privacy notice to understand how we collect and process your personal information. TIGER advertise and sells deals to you subject to the conditions set out on this page.<\\/p><p><strong>CONDITIONS OF USE<\\/strong><\\/p><p><strong>&nbsp;<\\/strong><\\/p><p>Please read these conditions carefully before using TIGER Services. By using TIGER Services, you signify your agreement to be bound by these conditions.&nbsp;<\\/p><ol><li><strong>PRIVACY<\\/strong><\\/li><\\/ol><p>TIGER shall follow the privacy policy posted on its website&nbsp;at&nbsp;<a href=\\\"about:blank\\\">www.Tiger,co.tz\\/privacypolicy<\\/a>&nbsp;when collecting and using information from you. TIGER may amend the privacy policy at any time by posting and notifying the amended privacy policy on its website.&nbsp;By using the App, you agree to be bound by our Privacy Policy, which is incorporated into these Terms of Use.<\\/p><p><strong>&nbsp;<\\/strong><\\/p><ol><li><strong>ELECTRONIC COMMUNICATIONS<\\/strong><\\/li><\\/ol><p>When you use any TIGER Service, you are communicating with us electronically. We will communicate with you electronically in a variety of ways, such as by email, text message, call, in-app push notices or by posting e-mail messages or communications on the App. For contractual purposes, you agree that all agreements, notices, disclosures and other communications that we provide you electronically satisfy any legal requirement that such communications be in writing, unless mandatory applicable laws specifically require a different form of communication.<\\/p><ol><li><strong>RECOMMENDATIONS AND PERSONALISATION<\\/strong><\\/li><\\/ol><p>As part of the TIGER Services, we may recommend features, products, and services, including third party ads that might be of interest to you, identify your preferences, and personalise your experience.<\\/p><ol><li><strong>&nbsp;COPYRIGHT, AUTHORS&#39; RIGHTS AND DATABASE RIGHTS<\\/strong><\\/li><\\/ol><p>All content included in or made available through any TIGER Service, such as text, graphics, logos, button icons, images, audio clips, digital downloads and data compilations is the property of TIGER or its content suppliers and is protected by applicable Copyright laws. The compilation of all content included in or made available through any TIGER Service is the exclusive property of TIGER and is protected by Tanzanian Copyright laws.<\\/p><p>You may not extract and\\/or re-utilise parts of the content of any TIGER Service without our express written consent. In particular, you may not utilise any data mining, robots, or similar data gathering and extraction tools to extract (whether once or many times) for re-utilisation of any substantial parts of the content of any TIGER Service, without our express written consent. You may also not create and\\/or publish your own database that features substantial parts of any TIGER Service (e.g. our prices and product listings) without our express written consent.<\\/p><ol><li><strong>&nbsp;TRADEMARK<\\/strong><\\/li><\\/ol><p><strong>&nbsp;<\\/strong><\\/p><p>In addition, graphics, logos, page headers, button icons, scripts, and service names included in or made available through any TIGER Service are trademarks or trade dress of TIGER. TIGER&#39;s trademarks and trade dress may not be used in connection with any product or service that is not TIGER&rsquo;s, in any manner that is likely to cause confusion among customers or in any manner that disparages or discredits TIGER. All other trademarks not owned by TIGER that appear in any TIGER Service are the property of their respective owners, who may or may not be affiliated with, connected to, or sponsored by TIGER.<\\/p><p><strong>&nbsp;<\\/strong><\\/p><p>&nbsp;<\\/p><p><strong>&nbsp;<\\/strong><\\/p><p>&nbsp;&nbsp;<strong>NOTICE AND PROCEDURE FOR NOTIFYING TIGER OF DEFAMATORY CONTENT<\\/strong><\\/p><p>Because millions of products are listed, and many thousands of customer reviews and comments are hosted on TIGER. It is not possible for us to be aware of the contents of each product listed for sale, or each customer review or comment that is displayed. Accordingly, we operate on a &quot;notice and action&quot; basis. If you believe that any content on, or within a product advertised for sale on, the TIGER website or App contains a defamatory statement, please notify TIGER immediately by sending an email to&nbsp;<a href=\\\"mailto:support@tafu.co.tz\\\">support@Tiger.co.tz<\\/a>with the subject line &quot; Defamation Notice [insert your name]&quot;&nbsp;<\\/p><p><strong>Important Warning:<\\/strong>&nbsp;giving false, misleading, or inaccurate information in the&nbsp;email to TIGER, or TIGER WhatsApp or any other communication channels of Defamatory Content on TIGER website may result in civil and criminal liability.<\\/p><ol><li><strong>&nbsp;TIGER SOFTWARE TERMS<\\/strong><\\/li><\\/ol><p>In addition to these Conditions of Use, the terms found&nbsp;here&nbsp;apply to any software (including any updates or upgrades to the software and any related documentation) that we make available to you from time to time for your use in connection with TIGER Services (the TIGER Application and Website&quot;).<\\/p><ol><li><strong>&nbsp;OTHER BUSINESSES<\\/strong><\\/li><\\/ol><p>Parties other than TIGER operate stores, provide services, or sell product lines on this App. In addition, we provide links, and location to the sites of affiliated companies and certain other businesses. We are not responsible for examining or evaluating, and we do not warrant the offerings of, any of these businesses or individuals or the content of their websites. TIGER does not assume any responsibility or liability for the actions, product, and content of all of these or any other third parties. You can tell when a third party is involved in your transactions, and we may share your information related to those transactions with that third party. You should carefully review their privacy statements and other conditions of use.<\\/p><p>&nbsp;<\\/p><ol><li><strong>TIGER&rsquo;S ROLE<\\/strong><\\/li><\\/ol><p><strong>&nbsp;<\\/strong><\\/p><p>TIGER allows third party sellers to list and sell their products deals at Tiger App and website&nbsp;<a href=\\\"http:\\/\\/www.tafu.co.tz\\/\\\">www.Tiger.co.tz<\\/a>. In each such case this is indicated on the respective product detail page. While TIGER as a service provider helps facilitate transactions that are carried out on the TIGER App, TIGER is neither&nbsp;the manufacturer, importer, representative, buyer&nbsp;nor the seller of the seller&#39;s items and services. TIGER provides a service for deal owners \\/sellers and deal seekers\\/buyers to complete transactions. Accordingly, the contract formed at the completion of a sale for these third-party products and services is solely between deal seekers\\/buyer and deal owners\\/seller. TIGER is not a party to this contract nor assumes any responsibility arising out of or in connection with it. The seller is responsible for the sale of the products\\/service and for dealing with any buyer claims or any other issue arising out of or in connection with the contract between the deal seeker\\/buyer and deal owner\\/seller.<\\/p><ol><li><strong>&nbsp;OUR LIABILITY (DISCLAIMER)<\\/strong><\\/li><\\/ol><p><strong>&nbsp;<\\/strong><\\/p><p>TIGER will do our utmost to ensure that availability of the TIGER Services will be uninterrupted and that transmissions will be error-free. However, due to the nature of the internet, this cannot be guaranteed. Also, your access to TIGER Services may also be occasionally suspended or restricted to allow for repairs, maintenance, or the introduction of new facilities or services. Upon notification to its client TIGER will attempt to limit the frequency and duration of any such suspension or restriction.<\\/p><p>TIGER will not be responsible for (i) losses that were not caused by any breach on our part, or (ii) any business loss (including loss of profits, revenue, contracts, anticipated savings, data, goodwill or wasted expenditure), or (iii) any loss caused by Fraud or misrepresentation, or (iv) any indirect or consequential losses that were not foreseeable to both you and us when you commenced using the TIGER Services.&nbsp;<\\/p><p>Each product and description displayed on the platform is according to information received from the Marchant.<\\/p><p>The sole responsibility of TIGER is to facilitate the contractual process between buyer\\/deal seekers and deal owners\\/Marchant. TIGER stands as an agent and therefore does not provide warrant, guarantee, or any kind of assurance on its services provided on the platform.&nbsp;<\\/p><p>&nbsp;<\\/p><p><strong>DISPUTE SETTLEMENT<\\/strong><\\/p><p>Any dispute arising from the&nbsp;formation, validity, binding effect,&nbsp;interpretation of or the performance of the terms and conditions hereunder shall be resolved amicably by mediation. If mediation fails, the said dispute will be referred to Arbitration in the presence of an Arbitrator agreed by both parties and&nbsp;pursuant to the current arbitration rules. For the purpose of avoiding doubt, the place of mediation shall be within the United Republic of Tanzania, and the language for arbitration will be in English or Kiswahili upon the client&rsquo;s choosing. The arbitration award shall be accepted as final and binding upon the Parties, and in any case where the complainant claims for damages, it should be limited to the value of the customer&rsquo;s exposure to the transaction on the platform.<\\/p><ol><li><strong>&nbsp;APPLICABLE LAW<\\/strong><\\/li><\\/ol><p>These conditions are governed by and construed in accordance with the laws of the United Republic of Tanzania. We both agree to submit to the jurisdiction of the courts of Tanzania, which means that you may bring a claim to enforce your rights in connection with these Conditions of Sale in Tanzania.<\\/p><p>&nbsp;<\\/p><ol><li><strong>&nbsp;ALTERATIONS TO SERVICE OR AMENDMENTS TO THE CONDITIONS OF USE<\\/strong><\\/li><\\/ol><p>TIGER reserves the right to make changes to any TIGER Services with notification to our client, policies, terms and conditions including these Conditions of Use, and Service Terms at any time. However we will notify the customers on all the changes that has been made. You will be subject to the terms and conditions, policies and Conditions of Use in force at the time that you use the TIGER Services. If any of these Conditions of Use is deemed invalid, void, or for any reason unenforceable, that condition will be deemed severable and will not affect the validity and enforceability of any remaining condition.<\\/p><ol><li><strong>&nbsp;WAIVER<\\/strong><\\/li><\\/ol><p>If you breach these Conditions of Use and we take no action, TIGER will still be entitled to use our rights and remedies in any other situation where you breach these Conditions of Use.<\\/p><ol><li><strong>&nbsp;TIGER&rsquo;S CONTACT DETAILS<\\/strong><\\/li><\\/ol><p>This App and website is owned and maintained by&nbsp;<\\/p><p>TIGER LOYALTY COMPANY.<\\/p><p>Old Bagamoyo Road, Mwanga Hakika Tower, Makumbusho<\\/p><p>Dar es salaam, Tanzania<\\/p><p>E-mail:&nbsp;<a href=\\\"mailto:business@tafu.co.tz\\\">business@Tiger.co.tz<\\/a><\\/p><p>Phone: +255 758 559 000<\\/p><p>WhatsApp: +255 758 559 000<\\/p><p>&nbsp;<\\/p><p><strong>ADDITIONAL TIGER SOFTWARE TERMS<\\/strong><br \\/>&nbsp;<\\/p><p><!--[if !supportLists]-->1.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<!--[endif]--><strong>Use of the TIGER Software.<\\/strong>&nbsp;You may use TIGER Application solely for purposes of enabling you to use and enjoy the TIGER Services as provided by TIGER, and as permitted by the Conditions of Use, these Software Terms and any Service Terms. You may not incorporate any portion of the TIGER Source Codes into your own programs or compile any portion of it in combination with your own programs, transfer it for use with another service, or sell, rent, lease, lend, loan, distribute or sub-license the TIGER Software or otherwise assign any rights to the TIGER Software in whole or in part. You may not use the TIGER Software for any illegal purpose. We may cease providing any TIGER Software and we may terminate your right to use any TIGER Software at any time. Your rights to use the TIGER Software will automatically terminate without notice from us if you fail to comply with any of these Software Terms, the Conditions of Use or any other Service Terms. Additional third-party terms contained within or distributed with certain TIGER Software that are specifically identified in related documentation may apply to that TIGER Software (or software incorporated with the TIGER Software) and will govern the use of such software in the event of a conflict with these Conditions of Use. All software used in any TIGER Service is the property of TIGER or its software suppliers and protected by law.<\\/p><p>&nbsp;<\\/p><p><!--[if !supportLists]-->2.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<!--[endif]--><strong>Use of Third-Party Services.<\\/strong>&nbsp;When you use the TIGER Software, you may also be using the services of one or more third parties, such as a wireless carrier or a mobile platform provider. Your use of these third-party services may be subject to the separate policies, terms of use, and fees of these third parties.<\\/p><p>&nbsp;<\\/p><p><!--[if !supportLists]-->3.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<!--[endif]--><strong>No Reverse Engineering.<\\/strong>&nbsp;Unless explicitly permitted under applicable mandatory law, you may not, and you will not encourage, assist or authorise any other person to copy, modify, reverse engineer, decompile or disassemble, or otherwise tamper with, the TIGER Software, whether in whole or in part, or create any derivative works from or of the TIGER Software.<\\/p><p>&nbsp;<\\/p><p><!--[if !supportLists]-->4.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<!--[endif]--><strong>Updates.<\\/strong>&nbsp;In order to keep the TIGER Software up to date, we may offer automatic or manual updates at any time and without notice to you.<\\/p><p>&nbsp;<\\/p><p>&nbsp;<\\/p><p><strong>PURCHASING TERMS<\\/strong><\\/p><p><strong>&nbsp;<\\/strong><\\/p><ol><li><strong>TIGER&rsquo;S CONTRACT<\\/strong><\\/li><\\/ol><p>We stand to be the agent between Deal Seekers (Customers) who is interested in buying deals on our Platform and the Deal Owners Marchant who has displayed the products on our Platform. We assist the customer to buy products displayed on our Platform by directing the location and deals time frame. Subject to the provisions of these terms and conditions, Until the Customer are allowed to buy tokens to be future spent at Merchant&rsquo;s by scanning customer&rsquo;s QR code at the merchant&rsquo;s shop. TIGER then makes settlement to the merchant&rsquo;s account which is equivalent to fiat currency of the Tiger token for that product or service.&nbsp;&nbsp;<\\/p><p>&nbsp;<\\/p><p><strong>RIGHT OF CANCELLATION, EXCEPTIONS TO CANCELLATION&nbsp;<\\/strong><\\/p><p>The Customer may decide to cancel the tiger tokens purchased but not utilized any time. The cancellation request is done directly on the platform and we will communicate an acknowledgement of receipt by notification soon after the Deal seeker (Customer) has applied for cancellation.&nbsp;<\\/p><p><strong>&nbsp;<\\/strong><\\/p><p><strong>&nbsp;<\\/strong><\\/p><p><strong>EFFECT OF CANCELLATION<\\/strong><\\/p><p>Subject to deduction of 10% of all payments made by a customer as cancellation charges. TIGER will not be responsible for payment reimbursement or refund after the customer has utilized the tokens at merchant.&nbsp;<\\/p><ol><li><strong>EXCEPTIONS TO THE RIGHT OF CANCELLATION<\\/strong><\\/li><\\/ol><p>The right of cancellation does not apply to the services made to your specifications or clearly personalized.<\\/p><ol><li><strong>PRICING AND AVAILABILITY<\\/strong><\\/li><\\/ol><p><strong>&nbsp;<\\/strong><\\/p><p>All prices are subject to legally applicable VAT.<\\/p><p>TIGER lists availability information for products displayed on the website and Mobile App including on each product information page. Beyond what we say on that page or otherwise on the website, we cannot be more specific about availability.&nbsp;<\\/p><p>Please note that unless otherwise stated on the App and website, TIGER is not responsible for deliveries of the products and services deals sold on the website and mobile App.<\\/p><p>Despite TIGER best efforts, a small number of the items in our catalogue may be mispriced. TIGER will verify pricing before make payment.&nbsp;<\\/p><p><strong>PAYMENTS AND ITS USE<\\/strong><\\/p><p>TIGER only accepts the payment methods which are provided on our website and Mobile App. We will not be responsible for any payment which is done out of the payment methods as provided by us.<\\/p><p>&nbsp;<\\/p><p>The payments are made in accordance with price as shown on an item displayed. Further, the payment made can only be used to spent on deals advertised. Our platform allows you to buy deals in advance.<\\/p><p>&nbsp;<\\/p><p>&nbsp;<\\/p><ol><li><strong>PROHIBITED ACTIVITIES<\\/strong><\\/li><\\/ol><p>&nbsp;<\\/p><p>You may not access or use the website and Mobile App for any purpose other than that for which we make the Platform available. The website and Mobile App may not be used in connection with any commercial endeavours except those that are specifically endorsed or approved by us.&nbsp;As a user of the website and Mobile App, you agree not to (i) Systematically retrieve data or other content from the website and Mobile App to create or compile, directly or indirectly, a collection, compilation, database, or directory without written permission from us, (ii) Make any unauthorized use of the website and Mobile App, including collecting usernames and\\/or email addresses of users by electronic or other means for the purpose of sending unsolicited email, or creating user accounts by automated means or under false pretences, (iii) Circumvent, disable, or otherwise interfere with security-related features of the website and Mobile App, including features that prevent or restrict the use or copying of any Content or enforce limitations on the use of the website and Mobile App and\\/or the Content contained therein, (iv) engage in unauthorized framing of link or publicly distribution of website and Mobile App link to people other than social connection, (v) attempt to impersonate another user or person or use the username of another user, (vi) use any product information obtained from the website and Mobile App in order to harass, abuse, or harm another person economically or in any other way, (vii) attempt to bypass any measures of the Site designed to prevent or restrict access to the Site, or any portion of the Site, or (viii)&nbsp;use the Site in a manner inconsistent with any applicable laws or regulations.<\\/p>\",\"sw\":null}','2022-09-02 16:35:04','2022-09-02 16:47:30'),(2,'{\"en\":\"<p><strong>Welcome to TIGER!<\\/strong><\\/p><p>TIGER LOYALTY COMPANY(Tiger) provides Application and website features and other products and services to you when you visit&nbsp;<a target=\\\"_blank\\\" href=\\\"http:\\/\\/www.tiger.co.tz\\/\\\">www.tiger.co.tz<\\/a> (the &quot;website&quot; )or download Tiger Mobile Application, use TIGER devices, products, or services, use Tiger applications for mobile, or use software provided by Tiger Loyalty company in connection with any of the foregoing (collectively &quot;TIGER Services&quot;). Please see our privacy notice to understand how we collect and process your personal information. TIGERadvertise and sells deals to you subject to the conditions set out on this page.<\\/p><p><strong>CONDITIONS OF USE<\\/strong><\\/p><p><strong>&nbsp;<\\/strong>Please read these conditions carefully before using TIGER Services. By using TIGER Services, you signify your agreement to be bound by these conditions.&nbsp;<\\/p><ol><li><strong>PRIVACY <\\/strong><\\/li><\\/ol><p>TIGER shall follow the privacy policy posted on its website at<a target=\\\"_blank\\\" href=\\\"about:blank\\\">www.Tiger,co.tz\\/privacypolicy<\\/a> when collecting and using information from you. TIGER may amend the privacy policy at any time by posting the amended privacy policy on its website.By using the App, you agree to be bound by our Privacy Policy, which is incorporated into these Terms of Use.<\\/p><ol><li><strong>ELECTRONIC COMMUNICATIONS<\\/strong><\\/li><\\/ol><p>When you use any TIGER Service, you are communicating with us electronically. We will communicate with you electronically in a variety of ways, such as by email, text message, call, in-app push notices or by posting e-mail messages or communications on the App. For contractual purposes, you agree that all agreements, notices, disclosures and other communications that we provide you electronically satisfy any legal requirement that such communications be in writing,unless mandatory applicable laws specifically require a different form of communication.<\\/p><p>&nbsp;<\\/p>\",\"sw\":null}','2022-09-02 19:34:53','2022-09-02 19:34:53');
/*!40000 ALTER TABLE `term_condition_customers` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `term_conditions`
--

DROP TABLE IF EXISTS `term_conditions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `term_conditions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `term_conditions` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `term_conditions`
--

LOCK TABLES `term_conditions` WRITE;
/*!40000 ALTER TABLE `term_conditions` DISABLE KEYS */;
INSERT INTO `term_conditions` VALUES (1,'{\"en\":\"<p><strong>Welcome to TIGER!<\\/strong><\\/p><p>TIGER LOYALTY COMPANY(Tiger) provides Application and website features and other products and services to you when you visit&nbsp;<a target=\\\"_blank\\\" href=\\\"http:\\/\\/www.tiger.co.tz\\/\\\">www.tiger.co.tz<\\/a> (the &quot;website&quot; )or download Tiger Mobile Application, use TIGER devices, products, or services, use Tiger applications for mobile, or use the software provided by Tiger Loyalty company in connection with any of the foregoing (collectively &quot;TIGER Services&quot;). Please see our privacy notice to understand how we collect and process your personal information. TIGERadvertise and sells deals to you subject to the conditions set out on this page.<\\/p><p><strong>CONDITIONS OF USE<\\/strong><\\/p><p><strong>&nbsp;<\\/strong>Please read these conditions carefully before using TIGER Services. By using TIGER Services, you signify your agreement to be bound by these conditions.&nbsp;<\\/p><ol><li><strong>PRIVACY <\\/strong><\\/li><\\/ol><p>TIGER shall follow the privacy policy posted on its website at <a target=\\\"_blank\\\" href=\\\"about:blank\\\">www.Tiger,co.tz\\/privacypolicy<\\/a> when collecting and using information from you. TIGER may amend the privacy policy at any time by posting the amended privacy policy on its website. By using the App, you agree to be bound by our Privacy Policy, which is incorporated into these Terms of Use.<\\/p><ol><li><strong>ELECTRONIC COMMUNICATIONS<\\/strong><\\/li><\\/ol><p>When you use any TIGER Service, you are communicating with us electronically. We will communicate with you electronically in a variety of ways, such as by email, text message, call, in-app push notices or by posting e-mail messages or communications on the App. For contractual purposes, you agree that all agreements, notices, disclosures and other communications that we provide you electronically satisfy any legal requirement that such communications be in writing, unless mandatory applicable laws specifically require a different form of communication.<\\/p><ol><li><strong>RECOMMENDATIONS AND PERSONALISATION<\\/strong><\\/li><\\/ol><p>As part of the TIGER Services, we may recommend features, products, and services, including third-party ads that might be of interest to you, identify your preferences, and personalise your experience.<\\/p><ol><li><strong>&nbsp;COPYRIGHT, AUTHORS&#39; RIGHTS AND DATABASE RIGHTS<\\/strong><\\/li><\\/ol><p>All content included in or made available through any TIGER Service, such as text, graphics, logos, button icons, images, audio clips, digital downloads and data compilations is the property of TIGER or its content suppliers and is protected by applicable Copyright laws. The compilation of all content included in or made available through any TIGER Service is the exclusive property of TIGER and is protected by Tanzanian Copyright laws.<\\/p><p>You may not extract and\\/or re-utilise parts of the content of any TIGER Service without our express written consent. In particular, you may not utilise any data mining, robots, or similar data gathering and extraction tools to extract (whether once or many times) for re-utilisation of any substantial parts of the content of any TIGER Service, without our express written consent. You may also not create and\\/or publish your own database that features substantial parts of any TIGER Service (e.g. our prices and product listings) without our express written consent.<\\/p><ol><li><strong>&nbsp;TRADEMARK<\\/strong><\\/li><\\/ol><p>In addition, graphics, logos, page headers, button icons, scripts, and service names included in or made available through any TIGER Service are trademarks or trade dress of TIGER. TIGER&#39;s trademarks and trade dress may not be used in connection with any product or service that is not TIGER&rsquo;s, in any manner that is likely to cause confusion among customers or in any manner that disparages or discredits TIGER. All other trademarks not owned by TIGER that appear in any TIGER Service are the property of their respective owners, who may or may not be affiliated with, connected to, or sponsored by TIGER.<\\/p><ol><li><strong>&nbsp;LICENCE AND ACCESS<\\/strong><\\/li><\\/ol><p>Subject to your compliance with these Conditions of Use and applicable Service Terms and your payment of any applicable fees, TIGER or its content providers may grant you a limited, non-exclusive, non-transferable, non-sublicensable licence to access and make personal and non-commercial use of the TIGER Services. This license does not include any resale or commercial use of any TIGER Service or its contents; any collection and use of any product listings, descriptions, or prices; any derivative use of any TIGER Service or its contents; any downloading or copying of account information for the benefit of another merchant; or any use of data mining, robots, or similar data gathering and extraction tools.<\\/p><p>All rights not expressly granted to you in these Conditions of Use or any Service Terms are reserved and retained by TIGER or its licensors, suppliers, publishers, rights holders, or other content providers. No TIGER Service, nor any part of any TIGER Service, may be reproduced, duplicated, copied, sold, resold, visited, or otherwise exploited for any commercial purpose without our express written consent. You may not frame or use framing techniques to enclose any trademark, logo or other proprietary information (including images, text, page layout, or form) of TIGER without our express written consent. You may not use any meta tags or any other &quot;hidden text&quot; utilising TIGER&#39;s names or trademarks without our express written consent.<\\/p><p>You may not misuse the TIGER Services. You may use the TIGER Services only as permitted by law. The licences granted by TIGER terminate if you do not comply with these Conditions of Use or any Service Terms.<\\/p><ol><li><strong>&nbsp;YOUR ACCOUNT<\\/strong><\\/li><\\/ol><p>You may need your own TIGER account to use certain TIGER Services, and you may be required to be logged into the account with a valid registered phone number.<\\/p><p>If you use any TIGER Service you are responsible for maintaining the confidentiality of your account and password and for restricting access to your computer and smartphone, and to the extent permitted by applicable law you agree to accept responsibility for all activities that occur under your account or password. You should take all necessary steps to ensure that the password is kept confidential and secure and should inform us immediately if you have any reason to believe that your password has become known to anyone else, or if the password is being, or is likely to be used in an unauthorised manner. You are responsible for ensuring that the details you provide us with are correct and complete, and for informing us of any changes to the information you have provided. You can access your information in the&nbsp;<strong>Account<\\/strong>&nbsp;section of the App.<\\/p><p>You must not use any TIGER Service: (i) in any way that causes, or is likely to cause, any TIGER Service, or any access to it to be interrupted, damaged or impaired in any way, or (ii) for fraudulent purposes, or in connection with a criminal offence or other unlawful activity, or (iii) to cause annoyance, inconvenience or anxiety.<\\/p><p>We reserve the right to use your Data, refuse service, suspend or terminate accounts or remove or edit content if you are in breach of applicable laws, these Conditions of Use or any other applicable terms and conditions, guidelines or policies.<\\/p><ol><li><strong>&nbsp;REVIEWS, COMMENTS, COMMUNICATIONS AND OTHER CONTENT<\\/strong><\\/li><\\/ol><p>Visitors may post reviews, comments and other content; send e-cards and other communications; and submit suggestions, ideas, comments, questions or other information, as long as the content is not illegal, obscene, abusive, threatening, defamatory, invasive of privacy, infringing of intellectual property rights, or otherwise injurious to third parties or objectionable and does not consist of or contain software viruses, political campaigning, commercial solicitation, chain letters, mass mailings or any form of &quot;spam&quot;. You may not use a false e-mail address, impersonate any person or entity, or otherwise mislead as to the origin of a card or other content. We reserve the right to remove or edit such content. If you believe that any content on or advertised for sale on any TIGER Service contains a defamatory statement, or that your intellectual property rights are being infringed by an item or information on any TIGER Service, please notify us by completing and submitting the appropriate&nbsp;notice form&nbsp;and we will respond.<\\/p><p>If you post customer reviews, comments, customer questions or answers, or other content generated by you for display on the App (including any images, video or audio, all together &quot;content&quot;, you grant TIGER (a) a non-exclusive, royalty-free licence to use, reproduce, publish, make available, translate and modify such content throughout the world (including the right to sublicense these rights to third parties) and (b) the right to use the name that you submit in connection with such content. No moral rights are transferred by this provision.<\\/p><p>You may delete your content from public view or, where such functionality is offered, change settings so that it is only shown to people to whom you grant access.<\\/p><p>You represent and warrant that you own or otherwise control all of the rights to the content that you post; that, as at the date that the content or material is posted: (i) the content and material is accurate; and (ii) use of the content and material you supply does not breach any applicable policies or guidelines and will not cause injury to any person or entity (including that the content or material is not defamatory). You agree to indemnify TIGER for all claims brought by a third party against TIGER arising out of or in connection with the content and material you supply except to the extent that any liability arises from our failure to properly remove the content when it is notified of the illegal nature of the content arising out of or on the grounds of, or originating from the content that you have communicated to us. By deleting content from public view, you withdraw your license for TIGER to publish and make available that content publicly.<\\/p><ol><li><strong>&nbsp;INTELLECTUAL PROPERTY CLAIMS<\\/strong><\\/li><\\/ol><p>TIGER respects the intellectual property of others. If you believe that your intellectual property rights have been used in a way that gives rise to concerns of infringement, please contact us on <a target=\\\"_blank\\\" href=\\\"mailto:support@tafu.co.tz\\\">support@Tiger.co.tz<\\/a><\\/p><p>Upon receipt of a complaint we may take certain actions, including removing information or an item, and termination of repeat infringers in appropriate circumstances. All such actions are taken without any admission as to liability and without prejudice to any rights, remedies or defences, all of which are expressly reserved. This includes forwarding the complaint to the parties involved in the provision of the allegedly infringing content. You agree to indemnify TIGER for all claims brought by a third party against TIGER arising out of or in connection with the submission of a complaint.<\\/p><p>10. <strong>NOTICE AND PROCEDURE FOR NOTIFYING TIGER OF DEFAMATORY CONTENT<\\/strong><\\/p><p>Because millions of products are listed, and many thousands of customer reviews and comments are hosted on TIGER. It is not possible for us to be aware of the contents of each product listed for sale, or each customer review or comment that is displayed. Accordingly, we operate on a &quot;notice and action&quot; basis. If you believe that any content on, or within a product advertised for sale on, the TIGER website or App contains a defamatory statement, please notify TIGER immediately by sending an email to <a target=\\\"_blank\\\" href=\\\"mailto:support@tafu.co.tz\\\">support@Tiger.co.tz<\\/a>with the subject line &quot; Defamation Notice [insert your name]&quot;<\\/p><p><strong>Important Warning:<\\/strong>&nbsp;giving false, misleading, or inaccurate information in the&nbsp;email to TIGER, or TIGER WhatsApp or any other communication channels of Defamatory Content on TIGER website may result in civil and criminal liability.<\\/p><ol><li><strong>TIGER SOFTWARE TERMS<\\/strong><\\/li><\\/ol><p>In addition to these Conditions of Use, the terms found&nbsp;here&nbsp;apply to any software (including any updates or upgrades to the software and any related documentation) that we make available to you from time to time for your use in connection with TIGER Services (the TIGER Application and Website&quot;).<\\/p><ol><li><strong>&nbsp;OTHER BUSINESSES<\\/strong><\\/li><\\/ol><p>Parties other than TIGER operate stores, provide services, or sell product lines on this App. In addition, we provide links, and location to the sites of affiliated companies and certain other businesses. We are not responsible for examining or evaluating, and we do not warrant the offerings of, any of these businesses or individuals or the content of their websites. TIGER does not assume any responsibility or liability for the actions, product, and content of all of these or any other third parties. You can tell when a third party is involved in your transactions, and we may share your information related to those transactions with that third party. You should carefully review their privacy statements and other conditions of use.<\\/p><ol><li><strong>TIGER&rsquo;S ROLE<\\/strong><\\/li><\\/ol><p>TIGER allows third party sellers to list and sell their products deals at Tiger App and website<a target=\\\"_blank\\\" href=\\\"http:\\/\\/www.tafu.co.tz\\/\\\">www.Tiger.co.tz<\\/a>. In each such case this is indicated on the respective product detail page. While TIGER as a service provider helps facilitate transactions that are carried out on the TIGERApp, TIGER is neither the manufacturer, importer, representative, buyer nor the seller of the seller&#39;s items and services. TIGER provides a service for deal owners \\/sellers and deal seekers\\/buyers to complete transactions. Accordingly, the contract formed at the completion of a sale for these third-party products and services is solely between deal seekers\\/buyer and deal owners\\/seller. TIGER is not a party to this contract nor assumes any responsibility arising out of or in connection with it. The seller is responsible for the sale of the products\\/service and for dealing with any buyer claims or any other issue arising out of or in connection with the contract between the deal seeker\\/buyer and deal owner\\/seller.<\\/p><ol><li><strong>&nbsp;OUR LIABILITY (DISCLAIMER)<\\/strong><\\/li><\\/ol><p>TIGER will do our utmost to ensure that availability of the TIGER Services will be uninterrupted and that transmissions will be error-free. However, due to the nature of the internet, this cannot be guaranteed. Also, your access to TIGER Services may also be occasionally suspended or restricted to allow for repairs, maintenance, or the introduction of new facilities or services. TIGER will attempt to limit the frequency and duration of any such suspension or restriction.<\\/p><p>TIGER will not be responsible for (i) losses that were not caused by any breach on our part, or (ii) any business loss (including loss of profits, revenue, contracts, anticipated savings, data, goodwill or wasted expenditure), or (iii) any loss caused by Fraud or misrepresentation, or (iv) any indirect or consequential losses that were not foreseeable to both you and us when you commenced using the TIGER Services.<\\/p><p>Each product and description displayed on the platform is according to information received from the Marchant.<\\/p><p>The sole responsibility of TIGER is to facilitate the contractual process between buyer\\/deal seekers and deal owners\\/Marchant. TIGER stands as an agent and therefore does not provide warrant, guarantee, or any kind of assurance on its services provided on the platform.<\\/p><p><strong>DISPUTE SETTLEMENT<\\/strong><\\/p><p>Any dispute arising from the formation, validity, binding effect, interpretation of or the performance of the terms and conditions hereunder shall be resolved amicably by mediation. If mediation fails, the said dispute will be referred to Arbitration in the presence of an Arbitrator agreed by both parties and pursuant to the current arbitration rules. For the purpose of avoiding doubt, the place of mediation shall be within the United Republic of Tanzania, and the language for arbitration will be in English or Kiswahili upon the client&rsquo;s choosing. The arbitration award shall be accepted as final and binding upon the Parties, and in any case where the complainant claims for damages, it should be limited to the value of the customer&rsquo;s exposure to the transaction on the platform.<\\/p><ol><li><strong>&nbsp;APPLICABLE LAW<\\/strong><\\/li><\\/ol><p>These conditions are governed by and construed in accordance with the laws of the United Republic of Tanzania. We both agree to submit to the jurisdiction of the courts of Tanzania, which means that you may bring a claim to enforce your rights in connection with these Conditions of Sale in Tanzania.<\\/p><ol><li><strong>&nbsp;ALTERATIONS TO SERVICE OR AMENDMENTS TO THE CONDITIONS OF USE<\\/strong><\\/li><\\/ol><p>TIGER reserves the right to make changes to any TIGER Services, policies, terms and conditions including these Conditions of Use, and Service Terms at any time. You will be subject to the terms and conditions, policies and Conditions of Use in force at the time that you use the TIGER Services. If any of these Conditions of Use is deemed invalid, void, or for any reason unenforceable, that condition will be deemed severable and will not affect the validity and enforceability of any remaining condition.<\\/p><ol><li><strong>&nbsp;WAIVER<\\/strong><\\/li><\\/ol><p>If you breach these Conditions of Use and we take no action, TIGER will still be entitled to use our rights and remedies in any other situation where you breach these Conditions of Use.<\\/p><ol><li><strong>TIGER&rsquo;S CONTACT DETAILS<\\/strong><\\/li><\\/ol><p>This App and website is owned and maintained by<\\/p><p>TIGERLOYALTY COMPANY.<\\/p><p>Old Bagamoyo Road, Mwanga Hakika Tower, Makumbusho<\\/p><p>Dar es salaam, Tanzania<\\/p><p>E-mail: <a target=\\\"_blank\\\" href=\\\"mailto:business@tafu.co.tz\\\">business@Tiger.co.tz<\\/a><\\/p><p>Phone: +255 758 559 000<\\/p><p>WhatsApp: +255 758 559 000<\\/p><p><strong>ADDITIONAL TIGER SOFTWARE TERMS<\\/strong><\\/p><p>1.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<strong>Use of the TIGER Software.<\\/strong>&nbsp;You may use TIGER Application solely for purposes of enabling you to use and enjoy the TIGER Services as provided by TIGER, and as permitted by the Conditions of Use, these Software Terms and any Service Terms. You may not incorporate any portion of the TIGER Source Codes into your own programs or compile any portion of it in combination with your own programs, transfer it for use with another service, or sell, rent, lease, lend, loan, distribute or sub-license the TIGER Software or otherwise assign any rights to the TIGER Software in whole or in part. You may not use the TIGER Software for any illegal purpose. We may cease providing any TIGER Software and we may terminate your right to use any TIGER Software at any time. Your rights to use the TIGER Software will automatically terminate without notice from us if you fail to comply with any of these Software Terms, the Conditions of Use or any other Service Terms. Additional third-party terms contained within or distributed with certain TIGER Software that are specifically identified in related documentation may apply to that TIGER Software (or software incorporated with the TIGER Software) and will govern the use of such software in the event of a conflict with these Conditions of Use. All software used in any TIGER Service is the property of TIGER or its software suppliers and protected by law.<\\/p><p>2.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<strong>Use of Third-Party Services.<\\/strong>&nbsp;When you use the TIGER Software, you may also be using the services of one or more third parties, such as a wireless carrier or a mobile platform provider. Your use of these third-party services may be subject to the separate policies, terms of use, and fees of these third parties.<\\/p><p>3.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<strong>No Reverse Engineering.<\\/strong>&nbsp;Unless explicitly permitted under applicable mandatory law, you may not, and you will not encourage, assist or authorise any other person to copy, modify, reverse engineer, decompile or disassemble, or otherwise tamper with, the TIGER Software, whether in whole or in part, or create any derivative works from or of the TIGER Software.<\\/p><p>4.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<strong>Updates.<\\/strong>&nbsp;In order to keep the TIGER Software up to date, we may offer automatic or manual updates at any time and without notice to you.<\\/p><p><strong>PURCHASING TERMS<\\/strong><\\/p><ol><li><strong>TIGER&rsquo;S CONTRACT<\\/strong><\\/li><\\/ol><p>We stand to be the agent between Deal Seekers (Customers) who is interested in buying deals on our Platform and the Deal Owners Marchant who has displayed the products on our Platform. We assist the customer to buy products displayed on our Platform by directing the location and deals time frame. Subject to the provisions of these terms and conditions, Until the Customer are allowed to buy tokens to be future spent at Merchant&rsquo;s by scanning customer&rsquo;s QR code at the merchant&rsquo;s shop. TIGER then makes settlement to the merchant&rsquo;s account which is equivalent to fiat currency of the Tiger token for that product or service.<\\/p><p><strong>RIGHT OF CANCELLATION, EXCEPTIONS TO CANCELLATION <\\/strong><\\/p><p>The Customer may decide to cancel the tiger tokens purchased but not utilized any time. The cancellation request is done directly on the platform and we will communicate an acknowledgement of receipt by notification soon after the Deal seeker (Customer) has applied for cancellation.<\\/p><p><strong>EFFECT OF CANCELLATION<\\/strong><\\/p><p>Subject to deduction of 10%% of all payments made by a customer as cancellation charges. TIGER will not be responsible for payment reimbursement or refund after the customer has utilized the tokens at merchant.<\\/p><ol><li><strong>EXCEPTIONS TO THE RIGHT OF CANCELLATION<\\/strong><\\/li><\\/ol><p>The right of cancellation does not apply to the services made to your specifications or clearly personalized.<\\/p><ol><li><strong>PRICING AND AVAILABILITY<\\/strong><\\/li><\\/ol><p>All prices are subject to legally applicable VAT.<\\/p><p>TIGER lists availability information for products displayed on the website and Mobile App including on each product information page. Beyond what we say on that page or otherwise on the website, we cannot be more specific about availability.<\\/p><p>Please note that unless otherwise stated on the App and website, TIGER is not responsible for deliveries of the products and services deals sold on the website and mobile App.<\\/p><p>Despite TIGER best efforts, a small number of the items in our catalogue may be mispriced. TIGER will verify pricing before make payment.<\\/p><p><strong>PAYMENTS AND ITS USE<\\/strong><\\/p><p>TIGER only accepts the payment methods which are provided on our website and Mobile App. We will not be responsible for any payment which is done out of the payment methods as provided by us.<\\/p><p>&nbsp;<\\/p><p>The payments are made in accordance with price as shown on an item displayed. Further, the payment made can only be used to spent on deals advertised. Our platform allows you to buy deals in advance.<\\/p><ol><li><strong>PROHIBITED ACTIVITIES<\\/strong><\\/li><\\/ol><p>You may not access or use the website and Mobile App for any purpose other than that for which we make the Platform available. The website and Mobile App may not be used in connection with any commercial endeavours except those that are specifically endorsed or approved by us.As a user of the website and Mobile App, you agree not to (i) Systematically retrieve data or other content from the website and Mobile App to create or compile, directly or indirectly, a collection, compilation, database, or directory without written permission from us, (ii) Make any unauthorized use of the website and Mobile App, including collecting usernames and\\/or email addresses of users by electronic or other means for the purpose of sending unsolicited email, or creating user accounts by automated means or under false pretences, (iii) Circumvent, disable, or otherwise interfere with security-related features of the website and Mobile App, including features that prevent or restrict the use or copying of any Content or enforce limitations on the use of the website and Mobile App and\\/or the Content contained therein, (iv) engage in unauthorized framing of link or publicly distribution of website and Mobile App link to people other than social connection, (v) attempt to impersonate another user or person or use the username of another user, (vi) use any product information obtained from the website and Mobile App in order to harass, abuse, or harm another person economically or in any other way, (vii) attempt to bypass any measures of the Site designed to prevent or restrict access to the Site, or any portion of the Site, or (viii)use the Site in a manner inconsistent with any applicable laws or regulations.<\\/p>\",\"sw\":null}','2022-09-02 02:30:17','2022-09-02 16:45:52');
/*!40000 ALTER TABLE `term_conditions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `testimonials`
--

DROP TABLE IF EXISTS `testimonials`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `testimonials` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `image` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fullname` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quote` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `testimonials`
--

LOCK TABLES `testimonials` WRITE;
/*!40000 ALTER TABLE `testimonials` DISABLE KEYS */;
/*!40000 ALTER TABLE `testimonials` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tiger_settings`
--

DROP TABLE IF EXISTS `tiger_settings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `tiger_settings` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `master_switch` int NOT NULL DEFAULT '0',
  `email_notification` int NOT NULL DEFAULT '0',
  `sms_notification` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tiger_settings`
--

LOCK TABLES `tiger_settings` WRITE;
/*!40000 ALTER TABLE `tiger_settings` DISABLE KEYS */;
INSERT INTO `tiger_settings` VALUES (1,1,0,0,'2022-06-17 01:11:15','2022-06-17 05:52:31');
/*!40000 ALTER TABLE `tiger_settings` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `users`
--

DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `users` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `first_name` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `last_name` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `usertype` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `username` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `password` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `remember_token` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `users`
--

LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES (1,'admin','admin','admin@tiger.co.tz',NULL,'admin',NULL,'$2y$10$RL4HtHKNNBhQ2tQDhGRSD.rE9Bk0FJfhSLHSg0Adv1NRvQltwngG2',NULL,'2022-06-17 01:11:04','2022-06-17 01:11:04'),(2,'admin','admin','james@tiger.co.tz',NULL,'superadmin','james','$2y$10$hCrd3j8zIKbZ0XhjpTV8heSe/KJAnVBtPAnHpFDTJchpVECD1Ylbi',NULL,'2022-06-27 01:52:16','2022-06-27 01:52:16'),(3,'admin','test','info@tiger.co.tz',NULL,'superadmin','tiger','$2y$10$8SnB9YP3auJ32if/1YMtLOMB6/SM2qZfthtmf2fIb9gugky8XiAMu',NULL,'2022-06-27 02:07:30','2022-06-27 02:07:30');
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `vacancies`
--

DROP TABLE IF EXISTS `vacancies`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `vacancies` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `caption` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `featured_image` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `applicationlink` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `file` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deadline` date DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `vacancies`
--

LOCK TABLES `vacancies` WRITE;
/*!40000 ALTER TABLE `vacancies` DISABLE KEYS */;
INSERT INTO `vacancies` VALUES (1,'{\"en\":\"Data Analyst\",\"sw\":null}','{\"en\":\"<p>&nbsp;<\\/p><p>We are looking to hire a data analyst to join our data team. You will take responsibility for managing our master data set, developing reports, and troubleshooting data issues. To do well in this role you need a very fine eye for detail, experience as a data analyst, and a deep understanding of the popular data analysis tools and databases.<\\/p><p><strong>Responsibilities<\\/strong><\\/p><ul><li>Managing master data, including creation, updates, and deletion.<\\/li><li>Managing users and user roles.<\\/li><li>Provide quality assurance of imported data, working with quality assurance analysts if necessary.<\\/li><li>Commissioning and decommissioning of data sets.<\\/li><li>Processing confidential data and information according to guidelines.<\\/li><li>Helping develop reports and analysis.<\\/li><li>Managing and designing the reporting environment, including data sources, security, and metadata.<\\/li><li>Supporting the data warehouse in identifying and revising reporting requirements.<\\/li><li>Supporting initiatives for data integrity and normalization.<\\/li><li>Assessing tests,&nbsp;implementing new or upgraded software and assisting with strategic decisions on new systems.<\\/li><li>Generating reports from single or multiple systems.<\\/li><li>Troubleshooting the reporting database environment and reports.<\\/li><li>Evaluating changes and updates to source production systems.<\\/li><li>Training end-users on new reports and dashboards.<\\/li><li>Providing technical expertise in data storage structures, data mining, and data cleansing.<\\/li><\\/ul><p><strong>Requirements<\\/strong><\\/p><ul><li>Bachelor&rsquo;s degree from an accredited university or college in computer science. statistics, social science or any other related field.<\\/li><li>Work experience as a data analyst or in a related field.<\\/li><li>Ability to work with stakeholders to assess potential risks.<\\/li><li>Ability to analyze existing tools and databases and provide software solution recommendations.<\\/li><li>Ability to translate business requirements into non-technical, lay terms.<\\/li><li>High-level experience in methodologies and processes for managing large-scale databases.<\\/li><li>Demonstrated experience in handling large data sets and relational databases.<\\/li><li>Understanding of addressing and metadata standards.<\\/li><\\/ul><p>&nbsp;<\\/p><p>Remuneration will be in line with the set procedures of the organizations which consider the experience and qualifications of the candidate (USD 2000-3500) Applications: Interested applicants should send their application letter accompanied by a resume with the names and addresses of 3 professional referees (including telephone and e-mail) Applications are by e-mails only, sent before 20th July 2022<\\/p>\",\"sw\":null}',NULL,'/uploads/1661764209.jpg',NULL,'{\"en\":\"\\/uploads\\/1656402773.jpg\",\"sw\":\"\\/uploads\\/\"}','2022-08-31','2022-06-28 14:52:53','2022-08-30 15:48:48'),(2,'{\"en\":\"Digital Marketing Manager\",\"sw\":null}','{\"en\":\"<p>The Manager Digital Marketing has overall responsibility for creating and implementing digital marketing strategy in accordance with the Company ambitious and exciting strategy and business objectives.<\\/p><p><strong>Responsibilities<\\/strong><\\/p><ul><li>Responsible for creating, implementing, and measuring the success of a comprehensive digital marketing programs that will enhance Company image.<\\/li><li>Act as the strategic lead and manage and deliver Company media and PR strategy, including responsibility for all major PR campaigns in line with Company strategy.<\\/li><li>Act as the strategic lead for all media engagement, pro-active and re-active.<\\/li><li>Spearhead the strategic and tactical execution of marketing campaigns and activities, including advertising, public relations, events, and promotions.<\\/li><li>Develop and implement performance metrics and tracking tools to monitor and measure results.<\\/li><li>Manage the production and dissemination of all marketing and communications material across all department and branches in line with the branding guidelines.<\\/li><li>Oversee the nature and tone of content, and adherence to branding, across the Company digital channels, in consultation with the IT Manager and Operation team.<\\/li><li>Collaborate with operation, agents and broking departments to create and implement effective go to market strategies for new and existing products.<\\/li><li>Maintaining social media accounts, especially Facebook, Instagram, and Twitter, as well as other new media executions, digital landscape and trends.<\\/li><li>In cooperation with Finance department prepare, manage, and deliver the digital marketing and communications budget.<\\/li><\\/ul><p><strong>Education and Qualifications<\\/strong><\\/p><ul><li>Graduate in insurance, marketing, business administration, IT or related field.<\\/li><\\/ul><p><strong>Requirements<\\/strong><\\/p><ul><li>Minimum of 3 years successful marketing that shows the use of skills necessary to execute this position successfully.<\\/li><li>Demonstrable experience of planning and executing marketing and advertising campaigns across a range of both traditional and non-traditional platforms.<\\/li><li>Demonstrable experience with digital and print marketing, content marketing, and social media marketing.<\\/li><li>Experience developing compelling content to generate response from audiences online<\\/li><li>Good language command for both English and Swahili<\\/li><\\/ul>\",\"sw\":null}',NULL,NULL,NULL,'{\"en\":\"\\/uploads\\/1661848800.jpg\",\"sw\":\"\\/uploads\\/\"}','2022-08-31','2022-08-30 15:40:00','2022-08-30 15:40:00'),(3,'{\"en\":\"Customer Experience Manager\",\"sw\":null}','{\"en\":\"<p>This role involved&nbsp;taking&nbsp;full responsibility for the successful delivery of excellent Customer experience to customers and clients.&nbsp;<\\/p><p><strong>Responsibilities<\\/strong><\\/p><p><strong>Customer Onboarding and Client engagement&nbsp;<\\/strong><\\/p><ul><li>Improve customer onboarding processes and coordinate with Sales, compliance, and account management teams to develop a seamless customer journey and ensure accounts meet compliance standards<\\/li><li>Through Market data and customer insight, drive new approaches, a step change and catalyze creating a customer experience culture.<\\/li><li>Provide direction and facilitate delivery of customer experience and service, balancing best practices, revenue generation and cost management<\\/li><\\/ul><p><strong>Service Quality and Client Management<\\/strong><\\/p><ul><li>Own the customer insight and customer satisfaction area by implementing a framework for proper tracking of customer complaints and queries to improve customer satisfaction<\\/li><li>Support change initiatives on uplifting overall branch experience and front-line staff professionalism, such as collecting findings via branch visits, customer immersions, and liaison with relevant business units for the program launched<\\/li><li>To optimize branch efficiency by coordinating with relevant stakeholders on digitalization, queue management to relieve counter traffic, streamlining branch operations etc.<\\/li><li>Regularly conduct customer surveys and compare with industry service benchmarking and use such analysis to develop service improvement plans to track performance against set service improvement targets.<\\/li><li>Run the Treat Customer Fairly process and be the champion of the principles, ensuring all staffs are trained and aware of these.<\\/li><li>To collect insights and learnings from various channels, including industries practices, the voice of customers and staff for identifying service gaps and action plan.<\\/li><li>Agree and manage service offerings and SLAs with internal customers (agree annually and measure every month.)<\\/li><\\/ul><p><strong>Product Cross-selling and performance<\\/strong><\\/p><ul><li>Work closely with operational Bankers, Relationship Managers, credit analysts and operations to achieve the revenue targets such as cross-sell, non-interest income, and liability growth in the number of customer groups.<\\/li><li>Identify gaps in our products and generate new Ideas to enhance the customer journeys, customer communication and internal process improvement.<\\/li><li>Engages leads and coordinates with the personal bank to maximize sales coverage and engagement in executing the company strategy.<\\/li><li>On the bank&#39;s monthly performance review content and process, using it not just as a reporting mechanism but as a mechanism for strategic and operational review and dialogue.<\\/li><li>Work with the in-country Senior Management Team to drive through the in-country business strategy based on market and competitor intelligence and a deep understanding of the business.<\\/li><li>Act as the final point of escalation\\/reference point in all customer complaints and queries from Customers and clients.<\\/li><\\/ul><p><strong>Education and Qualifications<\\/strong><\\/p><ul><li>Degree with relevant experience at the managerial level&nbsp;<\\/li><li>Demonstrated sales alignment experience<\\/li><li>Strong oral and written communication skills<\\/li><li>Consultative selling skills for service structure and service systems<\\/li><li>Ability to understand and apply market intelligence to sales strategy for customer retention processes<\\/li><li>High level of financial and business acumen<\\/li><li>Staff consulting and relationship-building skills<\\/li><li>Ability to use technology and analysis tools (Excel, Outlook, web, databases)<\\/li><li>Executive presence to influence senior decision-makers<\\/li><li>Academic Excellence and Business Degree will be essential<\\/li><\\/ul><p><strong>Requirements<\\/strong><\\/p><ul><li>5 years relevant experience<\\/li><\\/ul>\",\"sw\":null}',NULL,'/uploads/1661849515.jpg',NULL,'{\"en\":\"\\/uploads\\/\",\"sw\":\"\\/uploads\\/\"}','2022-08-31','2022-08-30 15:51:55','2022-08-30 15:51:55');
/*!40000 ALTER TABLE `vacancies` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `vendor_categories`
--

DROP TABLE IF EXISTS `vendor_categories`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `vendor_categories` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `vendorid` bigint unsigned NOT NULL,
  `category` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `vendor_categories_vendorid_foreign` (`vendorid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `vendor_categories`
--

LOCK TABLES `vendor_categories` WRITE;
/*!40000 ALTER TABLE `vendor_categories` DISABLE KEYS */;
/*!40000 ALTER TABLE `vendor_categories` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `vendor_landings`
--

DROP TABLE IF EXISTS `vendor_landings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `vendor_landings` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `top_section_image` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `top_section_title` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `top_section_caption` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `top_section_bgcolour` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `top_section_googleplaylink` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `top_section_appstorelink` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `middle_section_title` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `middle_section_videolink` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bottom_section_title_one` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bottom_section_caption_one` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bottom_section_image_one` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bottom_section_testimonial_name_one` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bottom_section_testimonial_message_one` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bottom_section_title_two` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bottom_section_caption_two` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bottom_section_image_two` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bottom_section_testimonial_name_two` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bottom_section_testimonial_message_two` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `middle_section_image` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `keywords` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_description` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `vendor_landings`
--

LOCK TABLES `vendor_landings` WRITE;
/*!40000 ALTER TABLE `vendor_landings` DISABLE KEYS */;
/*!40000 ALTER TABLE `vendor_landings` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `vendor_locations`
--

DROP TABLE IF EXISTS `vendor_locations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `vendor_locations` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `vendorid` bigint unsigned NOT NULL,
  `location` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `latitude` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `longitude` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `regionid` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `vendor_locations_vendorid_foreign` (`vendorid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `vendor_locations`
--

LOCK TABLES `vendor_locations` WRITE;
/*!40000 ALTER TABLE `vendor_locations` DISABLE KEYS */;
/*!40000 ALTER TABLE `vendor_locations` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `vendors`
--

DROP TABLE IF EXISTS `vendors`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `vendors` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mobilenumber` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `logo` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `latitude` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `longitude` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `location` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `region` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `category` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `maplocation` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tagline` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `featured_image` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `image` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `keywords` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_description` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `vendors`
--

LOCK TABLES `vendors` WRITE;
/*!40000 ALTER TABLE `vendors` DISABLE KEYS */;
INSERT INTO `vendors` VALUES (1,'MM Brands','0715070781','mmbrands@gmail.com','Dar es Salaam, Tanzania.',NULL,'-6.730283306907892','39.233102096446956','2','2','40',NULL,NULL,'<p><strong>Fashion/Clothing</strong><br />We garantee you brand satisfaction.</p><p><strong>Location:</strong> Sinza &amp; Kawe, Dar es Salaam.&nbsp;<br /><strong>Time:</strong> Monday- Sunday, 09:30am- 08:00pm<br /><strong>Phone</strong> <strong>Number:&nbsp;</strong>Sinza&nbsp;0715070781<strong>,&nbsp;</strong>Kawe&nbsp;0677080807<br /><strong>Email:&nbsp;</strong><a href=\"mailto:mmbrands@gmail.com?subject=Tiger%20Vendor\">mmbrands@gmail.com</a><br /><strong>Page</strong>:&nbsp;<a href=\"https://www.instagram.com/mmbrands.tz/\">https://www.instagram.com/mmbrands.tz/</a></p>',NULL,'2022-06-25 15:40:57','2022-11-17 14:05:04','/uploads/1668693904.jpg',NULL,NULL),(2,'GYVER BEAUTY SPA','+255 655 777 425','gyverbeautyspa@gmail.com','Dar es Salaam.',NULL,'-6.7643795369778426','39.275707967611794','1','2','50',NULL,NULL,'<p><strong>Beauty &amp; Spa</strong><br />Singo/ Facial treatment/ Waxing/ Pedicure/ Manicure/ Makeup.&nbsp;&nbsp;<br /><br /><strong>Location:</strong> DSM, Mikocheni, Ruvu street 30.<br /><strong>Day:</strong>&nbsp;Monday- Sunday<br /><strong>Phone number: </strong>0655777425,&nbsp;<br /><strong>Email:</strong>&nbsp;gyverbeautyspa@gmail.com<br /><strong>Page</strong>:&nbsp;https://www.instagram.com/reel/CmvRKO4Nt5r/?utm_source=ig_web_copy_link</p><p><a target=\"_blank\" href=\"https://l.instagram.com/?u=https%3A%2F%2Fapp.shedul.com%2Fonline_bookings%2Fgyver-beauty-spa-g5tmbs9d%2Flink&amp;e=AT3am4UaRpAl3IHZYjal6uxShkW0998YeyLjK4bx_oAzdttOGezlR9-dlHN8k04hxwSvFTygR6ZqH7xlrkxtYekxML4O9lDQoZpLUQM&amp;s=1\">app.shedul.com/online_bookings/gyver-beauty-spa-g5tmbs9d/link</a></p>',NULL,'2022-06-25 16:05:57','2023-01-31 11:05:45','/uploads/1675163145.jpg',NULL,NULL),(3,'Cherie Mals Beauty Spa','0685219111','graciemals@gmail.com','Mikocheni, Dar es Salaam.',NULL,'-6.776728148166558','39.25398454247214','1','2','50',NULL,NULL,'<p><strong>Beauty, Cosmetic &amp; Personal care</strong><br />We do Makeup, Facials, Dermaplaning, Body scrubs, Massage, Wax, Vajacial, Yoni steam, Morrocan Bath and more.&nbsp;</p><p><strong>Location:</strong>&nbsp;Mikocheni, Dar es Salaam.<br /><strong>Time: </strong>09:00am- 06:00pm<br /><strong>Phone Number:</strong>&nbsp;<a href=\"tel:0685219111\">0685219111</a><br /><strong>Email:</strong>&nbsp;<a href=\"mailto:graciemals@gmail.com?subject=email&amp;body=Email\">graciemals@gmail.com</a><br /><strong>Page:</strong>&nbsp;<a href=\"https://instagram.com/cherie_mals?igshid=YmMyMTA2M2Y=\">https://instagram.com/cherie_mals?igshid=YmMyMTA2M2Y=</a><br />&nbsp;</p>',NULL,'2022-06-28 17:03:26','2022-11-16 13:07:10','/uploads/1668602830.jpg',NULL,NULL),(4,'Kalypso Restaurant','0763898183','fnbmanager@kalypsotz.com','Masaki, Dar es salaam.',NULL,'-6.773193492265902','39.27603246761205','4','2','47',NULL,NULL,'<p><strong>Restaurant &amp; Shisha Lounge</strong><br />We offer&nbsp;and facilitate&nbsp;a premium entertainment experience for our customers by efficiently serving world class food offerings and premier beverage choices in an atmosphere that is contemporary, vibrant and relevant.</p><p>Location: Masaki, Dar es Salaam.<br />Time: 09:00am- 11:30pm<br />Phone Number:&nbsp;<a href=\"tel:0763898183\">0763898183</a><br />Email:&nbsp;<a href=\"mailto:reservations@kalypsotz.com?subject=Email&amp;body=Email\">reservations@kalypsotz.com</a><br />Page:&nbsp;<a href=\"https://www.instagram.com/kalypso_tz/\">https://www.instagram.com/kalypso_tz/</a></p>',NULL,'2022-06-28 17:10:49','2022-11-16 13:05:56','/uploads/1668603956.jpg',NULL,NULL),(5,'Taste Me Desserts & Cafe','0744424444','info@tastemetz.com','Dar es Salaam, Tanzania.',NULL,'-6.771190199108152','39.28212881363682','1','2','37',NULL,NULL,'<p><strong>Coffee Shop</strong><br />We are proud to be the first to serve Desserts and Cafe Tanzania.&nbsp;<br /><br /><strong>Location:</strong> Upanga, Mikocheni Plaza, Samora Avenue and Coco Beach,&nbsp;Dar es Salaam.&nbsp;<br /><strong>Time:</strong> Monday- Sunday, 09:00am- 11:00pm<br /><strong>Phone Number:</strong>&nbsp;<a href=\"tel:0744424444\">0744424444</a><br /><strong>Email:</strong>&nbsp;<a href=\"mailto:info@tastemetz.com?subject=Email&amp;body=Email\">info@tastemetz.com</a><br /><strong>Page:</strong>&nbsp;<a href=\"https://instagram.com/taste.me.desserts.cafe?igshid=YmMyMTA2M2Y=\">https://instagram.com/taste.me.desserts.cafe?igshid=YmMyMTA2M2Y=</a><br />&nbsp;</p>',NULL,'2022-06-28 17:52:37','2022-11-16 13:27:00','/uploads/1668605220.jpg',NULL,NULL),(6,'Mars communications Ltd','0694000400','mars.kkoo@gmail.com','Dar es Salaam, Tanzania.',NULL,'-6.8231684852509344','39.27425891178945','4','2','39',NULL,NULL,'<p><strong>Electronics</strong><br />Offical distributors of HISENSE products Tanzania.&nbsp;</p><p><strong>Location</strong>: Kariakoo, Masaki and Mlimani city Dar es Salaam.&nbsp;<br /><strong>Time:</strong> Monday- Sunday, 08:00am- 05:00pm<br /><strong>Phone Number:</strong>&nbsp;<a href=\"tel:0694000400\">0694000400</a><br /><strong>Email:</strong>&nbsp;<a href=\"mailto:mars.kkoo@gmail.com?subject=Email&amp;body=Email\">mars.kkoo@gmail.com</a><br /><strong>Page</strong>:&nbsp;<a href=\"https://instagram.com/marscommunicationsltd?igshid=YmMyMTA2M2Y=\">https://instagram.com/marscommunicationsltd?igshid=YmMyMTA2M2Y=</a><br />&nbsp;</p>',NULL,'2022-06-28 18:32:20','2022-11-16 14:10:41','/uploads/1668607841.jpg',NULL,NULL),(7,'Subway Tanzania','+255779200000','info@subway.com','Dar es Salaam, Tanzania.',NULL,'-6.77561260924567','39.24401096945988','4','2','41',NULL,NULL,'<p><strong>Fast Food</strong><br />The world&#39;s no. 1&nbsp;sandwich shop is helping you Eat Fresh in Dar.&nbsp;</p><p><strong>Location:</strong> Makumbusho, Mikocheni and Masaki, Dar es Salaam.&nbsp;<br /><strong>Time</strong>: Monday- Sunday, 11:00am- 10:00pm<br /><strong>Phone number</strong>:&nbsp;<a href=\"tel:+255779200000 \">+255779200000 </a><br /><strong>Page</strong>:&nbsp;<a href=\"https://instagram.com/subwaytanzania?igshid=YmMyMTA2M2Y=\">https://instagram.com/subwaytanzania?igshid=YmMyMTA2M2Y=</a></p><p>&nbsp;</p>',NULL,'2022-06-28 18:40:09','2022-11-16 13:48:54','/uploads/1668606534.jpg',NULL,NULL),(8,'The Touch Spa','0674950300','spa@thetouch.co.tz','Mikocheni, Dar es salaam',NULL,'-6.769491568378426','39.262123881105666','1','2','50',NULL,NULL,'<p><strong>Beauty &amp; Spa</strong><br />Try our massages, facials, body scrubs, manicure, pedicure, salon, sauna and more.&nbsp;</p><p><strong>Location:</strong> Mikocheni and Masaki, Dar es Salaam.&nbsp;<br /><strong>Time:</strong> Monday- Friday, 09:00am- 08:00pm<br />Saturday- Sunday, 09:00am- 06:00pm<br /><strong>Phone Number:</strong>&nbsp;<a href=\"tel:0674950300\">0674950300</a><br /><strong>Email:</strong>&nbsp;<a href=\"mailto:spa@thetouch.co.tz?subject=Email&amp;body=Email\">spa@thetouch.co.tz</a><br /><strong>Page:</strong>&nbsp;<a href=\"https://instagram.com/thetouchspa?igshid=YmMyMTA2M2Y=\">https://instagram.com/thetouchspa?igshid=YmMyMTA2M2Y=</a><br /><br />&nbsp;</p>',NULL,'2022-06-28 18:47:19','2022-11-16 14:38:16','/uploads/1668609496.jpg',NULL,NULL),(9,'Ahlan','0746 889 988','ahlantz1720@gmail.com','Dar es Salaam, Tanzania.',NULL,NULL,NULL,'4','2','47',NULL,NULL,'<p><strong>Restaurant</strong></p><p>Dar&#39;s most happening instagrammable place.&nbsp;<br />&nbsp;</p><p>Location: Masaki, Dar es Salaam.&nbsp;<br />Time: Monday- Sunday, 10:00am- 10:00pm</p><p>&nbsp;</p>',NULL,'2022-08-17 15:45:27','2022-11-16 18:00:46','/uploads/1668621646.png',NULL,NULL),(10,'Chill 24/7','+255748310691','info@chill-247.com','Masaki, Dar es salaam.',NULL,'-6.765303295994302','39.274874940624265','4','2','47',NULL,NULL,'<p>Restaurant<br />We offer good food and Shisha.&nbsp;</p><p>Location: Masaki, Dar es Salaam</p>',NULL,'2022-08-17 15:58:53','2022-11-17 14:41:52','/uploads/1668696112.jpg',NULL,NULL),(11,'See You Latte','0683533689','seeyoulattetz@gmail.com','Masaki, Dar es salaam.',NULL,'-6.7497026698799205','39.28418920994102','4','2','37',NULL,NULL,'<p><strong>Coffee Shop</strong><br />We do Coffee and Grill</p><p><strong>Location:</strong> Mwaya street- Masaki, Dar es Salaam.<br /><strong>Time:</strong> Tuesday- Sunday, 07:30am- 11:45pm<br /><strong>Phone Number:</strong>&nbsp;0683533689<br /><strong>Email:</strong>&nbsp;<a href=\"mailto:seeyoulattetz@gmail.com?subject=Email&amp;body=Email\">seeyoulattetz@gmail.com</a>&nbsp;<br /><strong>Page:&nbsp;</strong><a href=\"https://instagram.com/seeyoulattetz?igshid=YmMyMTA2M2Y=\">https://instagram.com/seeyoulattetz?igshid=YmMyMTA2M2Y=</a>&nbsp;</p>',NULL,'2022-08-17 16:00:16','2022-11-18 15:32:31','/uploads/1668785551.jpg',NULL,NULL),(12,'Bloom eventually','989787675','Bloom@gmail.com','Msasani, Dar es salaam.',NULL,NULL,NULL,NULL,NULL,'42',NULL,NULL,'Best flowers in Dar',NULL,'2022-08-17 16:01:37','2022-08-17 16:01:37','/uploads/1660726897.png',NULL,NULL),(13,'Azura Fitness','908976545','azura@gmail.com','Mikocheni, Dar es salaam.',NULL,NULL,NULL,'Choose','Choose','43',NULL,NULL,'<p><strong>Gym, Health &amp; Fitness</strong><br />Fitness and recreation club located at Kawe Beach. Indoor and outdoor gym, classes, swimming pool &amp;&nbsp;tennis.&nbsp;</p><p>Phone Number: +255 712 253 151<br />Email:&nbsp;<a href=\"mailto:azura@gmail.com?subject=Tiger%20vendor\">azura@gmail.com</a></p>',NULL,'2022-08-17 16:03:05','2022-08-31 18:59:01','/uploads/1660726985.png',NULL,NULL),(14,'Snow cream','9898978676','snowcream@gmail.com','Masaki, Dar es salaam.',NULL,NULL,NULL,NULL,NULL,'41',NULL,NULL,'Ice cream and Milk shakes',NULL,'2022-08-17 16:05:27','2022-08-17 16:05:27','/uploads/1660727127.jpg',NULL,NULL),(15,'BB Skin','8796765587','BB@gmail.com','Kijitonyama, Dar es salaam.',NULL,NULL,NULL,NULL,NULL,'38',NULL,NULL,'Best skin care products',NULL,'2022-08-17 16:06:41','2022-08-17 16:06:41','/uploads/1660727201.png',NULL,NULL),(16,'Batman Pizza','8767576456','batman@gmail.com','Mbezi, Dar es salaam.',NULL,NULL,NULL,NULL,NULL,'41',NULL,NULL,'Best pizzeria restaurant.',NULL,'2022-08-17 16:08:22','2022-08-17 16:08:22','/uploads/1660727302.jpg',NULL,NULL),(17,'LC Waikiki','87878679','waikiki@gmail.com','Mlimani city, Dar es salaam.',NULL,NULL,NULL,NULL,NULL,'40',NULL,NULL,'Affordable fashion outlet in Dar es Salaam.',NULL,'2022-08-17 16:12:11','2022-08-17 16:12:11','/uploads/1660727531.jpg',NULL,NULL),(18,'Serena Hotel','00712435678','serenahotel@gmail.com','<p>City Centre</p>',NULL,NULL,NULL,NULL,NULL,'52',NULL,NULL,'<p>Hotel in dar es salaam</p>',NULL,'2022-09-28 14:36:06','2022-09-28 14:36:06','/uploads/1664350566.jpg',NULL,NULL),(19,'White sands hotel','0754987556','whitesands@gmail.com','<p>Mbezi Beach</p>',NULL,NULL,NULL,NULL,NULL,'52',NULL,NULL,'<p>Hotel in Dar es salaam</p>',NULL,'2022-09-28 14:37:38','2022-09-28 14:37:38','/uploads/1664350658.jpg',NULL,NULL),(20,'Sea Cliff Hotel','0765765334','seacliff@gmail.com','<p>Masaki&nbsp;</p>',NULL,NULL,NULL,NULL,NULL,'52',NULL,NULL,'<p>Hotel in Dar es salaam</p>',NULL,'2022-09-28 14:39:22','2022-09-28 14:39:22','/uploads/1664350762.jpg',NULL,NULL),(21,'Slipway Hotel','0788647986','slipway@gmail.com','<p>Masaki</p>',NULL,NULL,NULL,NULL,NULL,'52',NULL,NULL,'<p>Hotel in dar es salam</p>',NULL,'2022-09-28 14:41:28','2022-09-28 14:41:28','/uploads/1664350888.jpg',NULL,NULL),(22,'Wavuvi Kempu','0784055505','info@samakisamaki.com','<p>Haile Selassie<br />Masaki, Dar es Salaam.</p>',NULL,NULL,NULL,'4','2','35',NULL,NULL,'<p><strong>Bar &amp; Lounge</strong></p><p>We do Seafood,&nbsp;Drinks &amp; Best Entertainment<br />Location:&nbsp;Masaki, Dar es Salaam.&nbsp;<br />Opening time: 11am till late<br />Phone Number:&nbsp;0686257503<br />Email:&nbsp;<a href=\"mailto:info@wavuvikempu.com?subject=email\">info@wavuvikempu.com</a><br />Instagram&nbsp;<a href=\"https://www.instagram.com/wavuvi_kempu/\">Wavuvi_Kempu</a></p>',NULL,'2022-10-07 21:50:36','2022-10-07 22:09:25','/uploads/1665155365.png',NULL,NULL),(23,'Gyver Beauty Spa','+255 655 777 425','gyverbeautyspa@gmail.com','<p>Mikocheni, ruvu street 30, Dar es salaam</p>',NULL,NULL,NULL,NULL,NULL,'50',NULL,NULL,'<p>We offer, Singo/ Facial treatment/ Waxing/ Pedicure/ Manicure/ Makeup.</p>',NULL,'2023-01-31 05:30:43','2023-01-31 05:30:43','/uploads/1675143043.jpg',NULL,NULL);
/*!40000 ALTER TABLE `vendors` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2023-06-21  7:13:36
