-- --------------------------------------------------------
-- Host:                         localhost
-- Server version:               10.4.22-MariaDB - mariadb.org binary distribution
-- Server OS:                    Win64
-- HeidiSQL Version:             11.3.0.6295
-- --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!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 */;


-- Dumping database structure for tmd_billing
CREATE DATABASE IF NOT EXISTS `tmd_billing` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci */;
USE `tmd_billing`;

-- Dumping structure for table tmd_billing.ewallet_payment
CREATE TABLE IF NOT EXISTS `ewallet_payment` (
  `reference_id` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `id` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `amount` int(11) DEFAULT NULL,
  `channel_code` varchar(15) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mobile_number` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `success_redirect_url` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payment_status` varchar(15) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `transaction_timestamp` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `json_data` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_time` datetime DEFAULT NULL,
  `updated_time` datetime DEFAULT NULL,
  PRIMARY KEY (`reference_id`) USING BTREE,
  KEY `id` (`id`) USING BTREE,
  KEY `created_time` (`created_time`) USING BTREE,
  KEY `updated_time` (`updated_time`) USING BTREE,
  KEY `transaction_timestamp` (`transaction_timestamp`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- Dumping data for table tmd_billing.ewallet_payment: ~0 rows (approximately)
/*!40000 ALTER TABLE `ewallet_payment` DISABLE KEYS */;
/*!40000 ALTER TABLE `ewallet_payment` ENABLE KEYS */;

-- Dumping structure for table tmd_billing.ewallet_request
CREATE TABLE IF NOT EXISTS `ewallet_request` (
  `reference_id` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `id` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `amount` int(11) DEFAULT NULL,
  `channel_code` varchar(15) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mobile_number` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `success_redirect_url` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `json_response` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_time` datetime DEFAULT NULL,
  PRIMARY KEY (`reference_id`),
  KEY `id` (`id`),
  KEY `created_time` (`created_time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table tmd_billing.ewallet_request: ~0 rows (approximately)
/*!40000 ALTER TABLE `ewallet_request` DISABLE KEYS */;
/*!40000 ALTER TABLE `ewallet_request` ENABLE KEYS */;

-- Dumping structure for table tmd_billing.fpc_payment
CREATE TABLE IF NOT EXISTS `fpc_payment` (
  `payment_id` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `external_id` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `id` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `expected_amount` int(11) DEFAULT NULL,
  `retail_outlet_name` varchar(15) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(15) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payment_code` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payment_status` varchar(15) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `transaction_timestamp` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `json_data` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_time` datetime DEFAULT NULL,
  `updated_time` datetime DEFAULT NULL,
  PRIMARY KEY (`payment_id`),
  KEY `id` (`id`) USING BTREE,
  KEY `created_time` (`created_time`) USING BTREE,
  KEY `updated_time` (`updated_time`) USING BTREE,
  KEY `external_id` (`external_id`),
  KEY `transaction_timestamp` (`transaction_timestamp`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- Dumping data for table tmd_billing.fpc_payment: ~0 rows (approximately)
/*!40000 ALTER TABLE `fpc_payment` DISABLE KEYS */;
/*!40000 ALTER TABLE `fpc_payment` ENABLE KEYS */;

-- Dumping structure for table tmd_billing.fpc_request
CREATE TABLE IF NOT EXISTS `fpc_request` (
  `external_id` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `id` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `expected_amount` int(11) DEFAULT NULL,
  `retail_outlet_name` varchar(15) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(15) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payment_code` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `json_response` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_time` datetime DEFAULT NULL,
  PRIMARY KEY (`external_id`) USING BTREE,
  KEY `id` (`id`) USING BTREE,
  KEY `created_time` (`created_time`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- Dumping data for table tmd_billing.fpc_request: ~0 rows (approximately)
/*!40000 ALTER TABLE `fpc_request` DISABLE KEYS */;
/*!40000 ALTER TABLE `fpc_request` ENABLE KEYS */;

-- Dumping structure for table tmd_billing.va_payment
CREATE TABLE IF NOT EXISTS `va_payment` (
  `payment_id` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `external_id` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `id` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `expected_amount` int(11) DEFAULT NULL,
  `bank_code` varchar(15) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(15) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `account_number` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payment_status` varchar(15) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `transaction_timestamp` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `json_data` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_time` datetime DEFAULT NULL,
  `updated_time` datetime DEFAULT NULL,
  PRIMARY KEY (`payment_id`),
  KEY `id` (`id`) USING BTREE,
  KEY `created_time` (`created_time`) USING BTREE,
  KEY `updated_time` (`updated_time`) USING BTREE,
  KEY `external_id` (`external_id`),
  KEY `transaction_timestamp` (`transaction_timestamp`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- Dumping data for table tmd_billing.va_payment: ~0 rows (approximately)
/*!40000 ALTER TABLE `va_payment` DISABLE KEYS */;
/*!40000 ALTER TABLE `va_payment` ENABLE KEYS */;

-- Dumping structure for table tmd_billing.va_request
CREATE TABLE IF NOT EXISTS `va_request` (
  `external_id` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `id` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `expected_amount` int(11) DEFAULT NULL,
  `bank_code` varchar(15) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(15) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `account_number` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `json_response` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_time` datetime DEFAULT NULL,
  PRIMARY KEY (`external_id`) USING BTREE,
  KEY `id` (`id`) USING BTREE,
  KEY `created_time` (`created_time`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- Dumping data for table tmd_billing.va_request: ~0 rows (approximately)
/*!40000 ALTER TABLE `va_request` DISABLE KEYS */;
/*!40000 ALTER TABLE `va_request` ENABLE KEYS */;

/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IFNULL(@OLD_FOREIGN_KEY_CHECKS, 1) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40111 SET SQL_NOTES=IFNULL(@OLD_SQL_NOTES, 1) */;
