-- phpMyAdmin SQL Dump
-- version 4.9.5
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Feb 19, 2021 at 03:03 AM
-- Server version: 5.7.33
-- PHP Version: 7.3.6

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";


/*!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 */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `ememberk_data`
--

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

--
-- Table structure for table `accounts`
--

CREATE TABLE `accounts` (
  `idacc` varchar(6) COLLATE utf8mb4_unicode_ci NOT NULL,
  `idbranch` varchar(6) COLLATE utf8mb4_unicode_ci NOT NULL,
  `idbank` varchar(6) COLLATE utf8mb4_unicode_ci NOT NULL,
  `accname` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `accno` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `acctype` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `accuser` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `accpwd` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `isactive` smallint(6) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `accounts`
--

INSERT INTO `accounts` (`idacc`, `idbranch`, `idbank`, `accname`, `accno`, `acctype`, `accuser`, `accpwd`, `isactive`, `created_at`, `updated_at`) VALUES
('ACC001', 'BRC001', 'BANK01', 'ANTON', '123456789', 'DEPOSIT', '-', '-', 1, '2021-02-05 13:00:20', '2021-02-05 20:46:20'),
('ACC002', 'BRC001', 'BANK01', 'BAMBANG', '123456789', 'WITHDRAWAL', '-', '-', 1, '2021-02-05 13:01:44', '2021-02-05 20:46:30');

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

--
-- Table structure for table `activities`
--

CREATE TABLE `activities` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `idmenu` smallint(6) NOT NULL,
  `iduser` varchar(6) COLLATE utf8mb4_unicode_ci NOT NULL,
  `idtrc` varchar(13) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `activities`
--

INSERT INTO `activities` (`id`, `idmenu`, `iduser`, `idtrc`, `description`, `created_at`, `updated_at`) VALUES
(7, 2, 'USR001', 'TRC0200000001', 'CREATE DEPOSIT', '2021-02-19 04:06:48', '2021-02-19 04:06:48');

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

--
-- Table structure for table `balances`
--

CREATE TABLE `balances` (
  `idblc` varchar(13) COLLATE utf8mb4_unicode_ci NOT NULL,
  `idacc` varchar(6) COLLATE utf8mb4_unicode_ci NOT NULL,
  `dtopening` date NOT NULL,
  `opening` decimal(17,2) NOT NULL,
  `running` decimal(17,2) DEFAULT NULL,
  `dtclosing` date DEFAULT NULL,
  `closing` decimal(17,2) DEFAULT '0.00',
  `remark` text COLLATE utf8mb4_unicode_ci,
  `iduser` varchar(6) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `balances`
--

INSERT INTO `balances` (`idblc`, `idacc`, `dtopening`, `opening`, `running`, `dtclosing`, `closing`, `remark`, `iduser`, `created_at`, `updated_at`) VALUES
('BLC2102000001', 'ACC001', '2021-02-07', 1000000.00, 2100000.00, NULL, 0.00, NULL, 'USR001', '2021-02-07 14:54:09', '2021-02-12 07:13:28'),
('BLC2102000002', 'ACC002', '2021-02-07', 500000.00, 500000.00, NULL, 0.00, NULL, 'USR001', '2021-02-07 15:05:49', '2021-02-12 07:13:23'),
('BLC2102000003', 'ACC001', '2021-02-17', 2000000.00, 2100000.00, NULL, 0.00, NULL, 'USR002', '2021-02-17 20:17:05', '2021-02-17 20:17:05'),
('BLC2102000004', 'ACC002', '2021-02-17', 1000000.00, 1000000.00, NULL, 0.00, NULL, 'USR002', '2021-02-17 20:18:06', '2021-02-17 20:18:06');

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

--
-- Table structure for table `banks`
--

CREATE TABLE `banks` (
  `idbank` varchar(6) COLLATE utf8mb4_unicode_ci NOT NULL,
  `bankcode` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `bankname` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `banksite` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `swiftcode` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `banks`
--

INSERT INTO `banks` (`idbank`, `bankcode`, `bankname`, `banksite`, `swiftcode`, `created_at`, `updated_at`) VALUES
('BANK01', 'BCA', 'Bank Central Asia', '-', '-', '2021-02-05 12:37:57', '2021-02-05 12:43:41'),
('BANK02', 'BNI', 'Bank Negara Indonesia', '-', '-', '2021-02-05 12:38:26', '2021-02-05 12:43:53'),
('BANK03', 'BRI', 'Bank Rakyat Indonesia', '-', '-', '2021-02-05 12:38:55', '2021-02-05 12:44:05'),
('BANK04', 'MANDIRI', 'Bank Mandiri', '-', '-', '2021-02-05 12:39:22', '2021-02-05 12:44:21'),
('BANK05', 'DANAMON', 'BANK DANAMON', '-', '-', '2021-02-16 10:56:50', '2021-02-16 10:57:07');

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

--
-- Table structure for table `bank_types`
--

CREATE TABLE `bank_types` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bank_types`
--

INSERT INTO `bank_types` (`id`, `title`, `created_at`, `updated_at`) VALUES
(1, 'DEPOSIT', '2021-02-05 14:36:02', NULL),
(2, 'WITHDRAWAL', '2021-02-05 14:36:04', NULL),
(3, 'BOTH', '2021-02-05 14:36:05', NULL);

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

--
-- Table structure for table `bonuses`
--

CREATE TABLE `bonuses` (
  `idbonus` varchar(13) COLLATE utf8mb4_unicode_ci NOT NULL,
  `idbranch` varchar(6) COLLATE utf8mb4_unicode_ci NOT NULL,
  `idmember` varchar(13) COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount` decimal(17,2) NOT NULL,
  `dtfrom` date DEFAULT NULL,
  `dtto` date DEFAULT NULL,
  `remark` text COLLATE utf8mb4_unicode_ci,
  `iduser` varchar(6) COLLATE utf8mb4_unicode_ci NOT NULL,
  `bnstatus` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `bonus_types`
--

CREATE TABLE `bonus_types` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `branches`
--

CREATE TABLE `branches` (
  `idbranch` varchar(6) COLLATE utf8mb4_unicode_ci NOT NULL,
  `branchname` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `branches`
--

INSERT INTO `branches` (`idbranch`, `branchname`, `created_at`, `updated_at`) VALUES
('BRC001', 'BENTO4D', '2021-02-05 12:32:38', '2021-02-05 20:45:42'),
('BRC002', 'BENTOTOTO', '2021-02-05 12:33:01', '2021-02-05 20:45:51'),
('BRC003', 'BENTOSLOT', '2021-02-05 12:33:12', '2021-02-05 20:46:00');

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

--
-- Table structure for table `coins`
--

CREATE TABLE `coins` (
  `idcoin` varchar(13) COLLATE utf8mb4_unicode_ci NOT NULL,
  `idbranch` varchar(6) COLLATE utf8mb4_unicode_ci NOT NULL,
  `dtopening` date NOT NULL,
  `opening` decimal(17,2) NOT NULL,
  `running` decimal(17,2) NOT NULL,
  `dtclosing` date DEFAULT NULL,
  `closing` decimal(17,2) DEFAULT '0.00',
  `remark` text COLLATE utf8mb4_unicode_ci,
  `iduser` varchar(6) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `coins`
--

INSERT INTO `coins` (`idcoin`, `idbranch`, `dtopening`, `opening`, `running`, `dtclosing`, `closing`, `remark`, `iduser`, `created_at`, `updated_at`) VALUES
('COIN210200001', 'BRC001', '2021-02-17', 100000000.00, 99900000.00, NULL, 0.00, NULL, 'USR002', '2021-02-17 20:23:06', '2021-02-17 20:23:06');

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

--
-- Table structure for table `details`
--

CREATE TABLE `details` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `idgroup` varchar(11) COLLATE utf8mb4_unicode_ci NOT NULL,
  `idmenu` int(11) NOT NULL,
  `hcreate` smallint(6) NOT NULL,
  `hread` smallint(6) NOT NULL,
  `hedit` smallint(6) NOT NULL,
  `hdelete` smallint(6) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `details`
--

INSERT INTO `details` (`id`, `idgroup`, `idmenu`, `hcreate`, `hread`, `hedit`, `hdelete`, `created_at`, `updated_at`) VALUES
(2, 'GRP21020001', 2, 1, 1, 1, 1, '2021-02-04 16:14:48', '2021-02-04 17:05:45'),
(3, 'GRP21020001', 5, 1, 1, 1, 1, '2021-02-04 16:23:29', '2021-02-04 16:23:29'),
(4, 'GRP21020001', 7, 1, 1, 1, 1, '2021-02-04 16:25:05', '2021-02-04 16:25:05'),
(5, 'GRP21020001', 13, 1, 1, 1, 1, '2021-02-04 16:51:17', '2021-02-04 16:51:17'),
(6, 'GRP21020001', 16, 1, 1, 1, 1, '2021-02-04 16:51:20', '2021-02-04 16:51:20'),
(7, 'GRP21020001', 19, 1, 1, 1, 1, '2021-02-04 16:51:25', '2021-02-04 16:51:25'),
(8, 'GRP21020001', 23, 1, 1, 1, 1, '2021-02-04 16:51:30', '2021-02-04 16:51:30'),
(9, 'GRP21020001', 25, 1, 1, 1, 1, '2021-02-04 16:51:32', '2021-02-04 16:51:32'),
(10, 'GRP21020001', 3, 1, 1, 1, 1, '2021-02-04 16:51:35', '2021-02-04 16:51:35'),
(11, 'GRP21020001', 4, 1, 1, 1, 1, '2021-02-04 16:51:38', '2021-02-04 16:51:38'),
(12, 'GRP21020001', 21, 1, 1, 1, 1, '2021-02-04 16:51:41', '2021-02-04 16:51:41'),
(13, 'GRP21020001', 6, 1, 1, 1, 1, '2021-02-04 16:51:43', '2021-02-04 16:51:43'),
(14, 'GRP21020001', 10, 1, 1, 1, 1, '2021-02-04 16:51:46', '2021-02-04 16:51:46'),
(15, 'GRP21020001', 11, 1, 1, 1, 1, '2021-02-04 16:51:48', '2021-02-04 16:51:48'),
(16, 'GRP21020001', 12, 1, 1, 1, 1, '2021-02-04 16:51:51', '2021-02-04 16:51:51'),
(17, 'GRP21020001', 8, 1, 1, 1, 1, '2021-02-04 16:51:53', '2021-02-04 16:51:53'),
(18, 'GRP21020001', 26, 1, 1, 1, 1, '2021-02-04 16:51:56', '2021-02-04 16:51:56'),
(19, 'GRP21020001', 27, 1, 1, 1, 1, '2021-02-04 16:51:59', '2021-02-04 16:51:59'),
(20, 'GRP21020001', 14, 1, 1, 1, 1, '2021-02-04 16:52:02', '2021-02-04 16:52:02'),
(21, 'GRP21020001', 15, 1, 1, 1, 1, '2021-02-04 16:52:05', '2021-02-04 16:52:05'),
(22, 'GRP21020001', 17, 1, 1, 1, 1, '2021-02-04 16:52:08', '2021-02-04 16:52:08'),
(23, 'GRP21020001', 18, 1, 1, 1, 1, '2021-02-04 16:52:11', '2021-02-04 16:52:11'),
(24, 'GRP21020001', 20, 1, 1, 1, 1, '2021-02-04 16:52:14', '2021-02-04 16:52:14'),
(25, 'GRP21020001', 22, 1, 1, 1, 1, '2021-02-04 16:52:17', '2021-02-04 16:52:17'),
(26, 'GRP21020001', 24, 1, 1, 1, 1, '2021-02-04 16:52:19', '2021-02-04 16:52:19'),
(27, 'GRP21020001', 1, 1, 1, 1, 1, '2021-02-04 17:04:34', '2021-02-04 17:04:34'),
(28, 'GRP21020002', 1, 1, 1, 1, 1, '2021-02-04 19:01:05', '2021-02-04 19:01:05'),
(29, 'GRP21020002', 2, 1, 1, 1, 1, '2021-02-04 19:01:09', '2021-02-04 19:01:09'),
(30, 'GRP21020002', 16, 1, 1, 1, 1, '2021-02-04 19:01:16', '2021-02-04 19:01:16'),
(31, 'GRP21020002', 25, 1, 1, 1, 1, '2021-02-04 19:01:21', '2021-02-04 19:01:21'),
(32, 'GRP21020002', 3, 1, 1, 1, 1, '2021-02-04 19:01:25', '2021-02-04 19:01:25'),
(33, 'GRP21020002', 4, 1, 1, 1, 1, '2021-02-04 19:01:29', '2021-02-04 19:01:29'),
(34, 'GRP21020002', 21, 1, 1, 1, 1, '2021-02-04 19:01:32', '2021-02-04 19:01:32'),
(35, 'GRP21020002', 11, 1, 1, 1, 1, '2021-02-04 19:01:39', '2021-02-04 19:01:39'),
(36, 'GRP21020002', 19, 1, 1, 1, 1, '2021-02-04 19:01:51', '2021-02-04 19:01:51'),
(37, 'GRP21020002', 23, 1, 1, 1, 1, '2021-02-04 19:01:54', '2021-02-04 19:01:54'),
(38, 'GRP21020002', 17, 1, 1, 1, 1, '2021-02-04 19:02:04', '2021-02-04 19:02:04'),
(39, 'GRP21020002', 20, 1, 1, 1, 1, '2021-02-04 19:02:08', '2021-02-04 19:02:08'),
(40, 'GRP21020002', 22, 1, 1, 1, 1, '2021-02-04 19:02:11', '2021-02-04 19:02:11'),
(41, 'GRP21020002', 24, 1, 1, 1, 1, '2021-02-04 19:02:13', '2021-02-04 19:02:13'),
(42, 'GRP21020001', 28, 1, 1, 1, 1, '2021-02-05 04:24:14', '2021-02-05 04:24:14'),
(43, 'GRP21020001', 29, 1, 1, 1, 1, '2021-02-05 19:53:11', '2021-02-05 19:53:11'),
(45, 'GROUP03', 1, 1, 1, 1, 1, '2021-02-07 14:50:01', '2021-02-07 14:50:01'),
(46, 'GROUP03', 3, 1, 1, 1, 1, '2021-02-07 14:50:35', '2021-02-07 14:50:35'),
(47, 'GROUP03', 4, 1, 1, 1, 1, '2021-02-07 14:50:38', '2021-02-07 14:50:38'),
(48, 'GROUP03', 21, 1, 1, 1, 1, '2021-02-07 14:50:41', '2021-02-07 14:50:41'),
(49, 'GROUP03', 2, 1, 1, 1, 1, '2021-02-07 14:50:44', '2021-02-07 14:50:44'),
(50, 'GRP21020001', 30, 1, 1, 1, 1, '2021-02-19 04:02:59', '2021-02-19 04:02:59');

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

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

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

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

--
-- Table structure for table `groups`
--

CREATE TABLE `groups` (
  `idgroup` varchar(11) COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `groups`
--

INSERT INTO `groups` (`idgroup`, `title`, `slug`, `created_at`, `updated_at`) VALUES
('GROUP03', 'CS', 'cs', '2021-02-07 14:48:57', '2021-02-07 14:48:57'),
('GRP21020001', 'ADMINISTRATOR', 'administrator', '2021-02-02 00:18:10', '2021-02-03 23:55:56'),
('GRP21020002', 'OPERATOR', 'operator', '2021-02-02 00:18:57', NULL);

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

--
-- Table structure for table `logins`
--

CREATE TABLE `logins` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `iduser` varchar(6) COLLATE utf8mb4_unicode_ci NOT NULL,
  `hostname` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ipaddress` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `country` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `regional` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `city` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `longitude` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `latitude` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `browser1` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `browser2` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `osystem` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `logins`
--

INSERT INTO `logins` (`id`, `iduser`, `hostname`, `ipaddress`, `country`, `regional`, `city`, `longitude`, `latitude`, `browser1`, `browser2`, `osystem`, `created_at`, `updated_at`) VALUES
(1, 'USR001', '/var/www/html/~ememberku/login', '36.85.188.254', 'Indonesia', 'Bali', 'Denpasar', '115.2167', NULL, 'Mozilla/5.0 ', ' AppleWebKit/537.36 ', 'Windows NT 10.0; Win64; x64', '2021-02-04 18:56:03', '2021-02-04 18:56:03'),
(2, 'USR001', '/var/www/html/~ememberku/login', '36.85.188.254', 'Indonesia', 'Bali', 'Denpasar', '115.2167', NULL, 'Mozilla/5.0 ', ' AppleWebKit/537.36 ', 'Windows NT 10.0; Win64; x64', '2021-02-04 18:56:03', '2021-02-04 18:56:03'),
(3, 'USR002', '/var/www/html/~ememberku/login', '223.255.228.94', 'Indonesia', 'Bali', 'Denpasar', '115.2167', NULL, 'Mozilla/5.0 ', ' AppleWebKit/605.1.15 ', 'iPhone; CPU iPhone OS 14_3 like Mac OS X', '2021-02-04 19:20:04', '2021-02-04 19:20:04'),
(4, 'USR002', '/var/www/html/~ememberku/login', '223.255.228.94', 'Indonesia', 'Bali', 'Denpasar', '115.2167', NULL, 'Mozilla/5.0 ', ' AppleWebKit/605.1.15 ', 'iPhone; CPU iPhone OS 14_3 like Mac OS X', '2021-02-04 19:20:04', '2021-02-04 19:20:04'),
(5, 'USR002', '/var/www/html/~ememberku/login', '180.252.69.27', 'Indonesia', 'Bali', 'Denpasar', '115.2167', NULL, 'Mozilla/5.0 ', ' AppleWebKit/537.36 ', 'X11; Linux x86_64', '2021-02-04 19:22:22', '2021-02-04 19:22:22'),
(6, 'USR002', '/var/www/html/~ememberku/login', '180.252.69.27', 'Indonesia', 'Bali', 'Denpasar', '115.2167', NULL, 'Mozilla/5.0 ', ' AppleWebKit/537.36 ', 'X11; Linux x86_64', '2021-02-04 19:22:22', '2021-02-04 19:22:22'),
(7, 'USR002', '/var/www/html/~ememberku/login', '180.252.69.27', 'Indonesia', 'Bali', 'Denpasar', '115.2167', NULL, 'Mozilla/5.0 ', ' AppleWebKit/537.36 ', 'X11; Linux x86_64', '2021-02-04 19:33:01', '2021-02-04 19:33:01'),
(8, 'USR002', '/var/www/html/~ememberku/login', '180.252.69.27', 'Indonesia', 'Bali', 'Denpasar', '115.2167', NULL, 'Mozilla/5.0 ', ' AppleWebKit/537.36 ', 'X11; Linux x86_64', '2021-02-04 19:33:01', '2021-02-04 19:33:01'),
(9, 'USR002', '/var/www/html/~ememberku/login', '36.85.188.254', 'Indonesia', 'Bali', 'Denpasar', '115.2167', NULL, 'Mozilla/5.0 ', ' AppleWebKit/605.1.15 ', 'iPhone; CPU iPhone OS 14_4 like Mac OS X', '2021-02-04 22:23:03', '2021-02-04 22:23:03'),
(10, 'USR002', '/var/www/html/~ememberku/login', '36.85.188.254', 'Indonesia', 'Bali', 'Denpasar', '115.2167', NULL, 'Mozilla/5.0 ', ' AppleWebKit/605.1.15 ', 'iPhone; CPU iPhone OS 14_4 like Mac OS X', '2021-02-04 22:23:03', '2021-02-04 22:23:03'),
(11, 'USR001', '/var/www/html/~ememberku/login', '36.85.188.254', 'Indonesia', 'Bali', 'Denpasar', '115.2167', NULL, 'Mozilla/5.0 ', ' AppleWebKit/537.36 ', 'Windows NT 10.0; Win64; x64', '2021-02-04 22:42:24', '2021-02-04 22:42:24'),
(12, 'USR001', '/var/www/html/~ememberku/login', '36.85.188.254', 'Indonesia', 'Bali', 'Denpasar', '115.2167', NULL, 'Mozilla/5.0 ', ' AppleWebKit/537.36 ', 'Windows NT 10.0; Win64; x64', '2021-02-04 22:42:24', '2021-02-04 22:42:24'),
(13, 'USR002', '/var/www/html/~ememberku/login', '180.252.69.27', 'Indonesia', 'Bali', 'Denpasar', '115.2167', NULL, 'Mozilla/5.0 ', ' AppleWebKit/537.36 ', 'X11; Linux x86_64', '2021-02-04 22:56:25', '2021-02-04 22:56:25'),
(14, 'USR002', '/var/www/html/~ememberku/login', '180.252.69.27', 'Indonesia', 'Bali', 'Denpasar', '115.2167', NULL, 'Mozilla/5.0 ', ' AppleWebKit/537.36 ', 'X11; Linux x86_64', '2021-02-04 22:56:25', '2021-02-04 22:56:25'),
(15, 'USR002', '/var/www/html/~ememberku/login', '36.85.188.254', 'Indonesia', 'Bali', 'Denpasar', '115.2167', NULL, 'Mozilla/5.0 ', ' AppleWebKit/537.36 ', 'Windows NT 10.0; Win64; x64', '2021-02-04 23:18:15', '2021-02-04 23:18:15'),
(16, 'USR002', '/var/www/html/~ememberku/login', '36.85.188.254', 'Indonesia', 'Bali', 'Denpasar', '115.2167', NULL, 'Mozilla/5.0 ', ' AppleWebKit/537.36 ', 'Windows NT 10.0; Win64; x64', '2021-02-04 23:18:15', '2021-02-04 23:18:15'),
(17, 'USR002', '/var/www/html/~ememberku/login', '180.252.69.27', 'Indonesia', 'Bali', 'Denpasar', '115.2167', NULL, 'Mozilla/5.0 ', ' AppleWebKit/605.1.15 ', 'iPhone; CPU iPhone OS 14_3 like Mac OS X', '2021-02-04 23:44:23', '2021-02-04 23:44:23'),
(18, 'USR002', '/var/www/html/~ememberku/login', '180.252.69.27', 'Indonesia', 'Bali', 'Denpasar', '115.2167', NULL, 'Mozilla/5.0 ', ' AppleWebKit/605.1.15 ', 'iPhone; CPU iPhone OS 14_3 like Mac OS X', '2021-02-04 23:44:23', '2021-02-04 23:44:23'),
(19, 'USR002', '/var/www/html/~ememberku/login', '180.252.69.27', 'Indonesia', 'Bali', 'Denpasar', '115.2167', NULL, 'Mozilla/5.0 ', ' AppleWebKit/537.36 ', 'X11; Linux x86_64', '2021-02-04 23:56:32', '2021-02-04 23:56:32'),
(20, 'USR002', '/var/www/html/~ememberku/login', '180.252.69.27', 'Indonesia', 'Bali', 'Denpasar', '115.2167', NULL, 'Mozilla/5.0 ', ' AppleWebKit/537.36 ', 'X11; Linux x86_64', '2021-02-04 23:56:32', '2021-02-04 23:56:32'),
(21, 'USR002', '/var/www/html/~ememberku/login', '180.252.69.27', 'Indonesia', 'Bali', 'Denpasar', '115.2167', NULL, 'Mozilla/5.0 ', ' AppleWebKit/537.36 ', 'X11; Linux x86_64', '2021-02-05 00:28:04', '2021-02-05 00:28:04'),
(22, 'USR002', '/var/www/html/~ememberku/login', '180.252.69.27', 'Indonesia', 'Bali', 'Denpasar', '115.2167', NULL, 'Mozilla/5.0 ', ' AppleWebKit/537.36 ', 'X11; Linux x86_64', '2021-02-05 00:28:04', '2021-02-05 00:28:04'),
(23, 'USR002', '/var/www/html/~ememberku/login', '180.252.69.27', 'Indonesia', 'Bali', 'Denpasar', '115.2167', NULL, 'Mozilla/5.0 ', ' AppleWebKit/537.36 ', 'X11; Linux x86_64', '2021-02-05 00:45:21', '2021-02-05 00:45:21'),
(24, 'USR002', '/var/www/html/~ememberku/login', '180.252.69.27', 'Indonesia', 'Bali', 'Denpasar', '115.2167', NULL, 'Mozilla/5.0 ', ' AppleWebKit/537.36 ', 'X11; Linux x86_64', '2021-02-05 00:45:21', '2021-02-05 00:45:21'),
(25, 'USR002', '/var/www/html/~ememberku/login', '180.252.69.27', 'Indonesia', 'Bali', 'Denpasar', '115.2167', NULL, 'Mozilla/5.0 ', ' AppleWebKit/537.36 ', 'X11; Linux x86_64', '2021-02-05 00:54:38', '2021-02-05 00:54:38'),
(26, 'USR002', '/var/www/html/~ememberku/login', '180.252.69.27', 'Indonesia', 'Bali', 'Denpasar', '115.2167', NULL, 'Mozilla/5.0 ', ' AppleWebKit/537.36 ', 'X11; Linux x86_64', '2021-02-05 00:54:38', '2021-02-05 00:54:38'),
(27, 'USR002', '/var/www/html/~ememberku/login', '180.252.69.27', 'Indonesia', 'Bali', 'Denpasar', '115.2167', NULL, 'Mozilla/5.0 ', ' AppleWebKit/537.36 ', 'X11; Linux x86_64', '2021-02-05 01:57:18', '2021-02-05 01:57:18'),
(28, 'USR002', '/var/www/html/~ememberku/login', '180.252.69.27', 'Indonesia', 'Bali', 'Denpasar', '115.2167', NULL, 'Mozilla/5.0 ', ' AppleWebKit/537.36 ', 'X11; Linux x86_64', '2021-02-05 01:57:18', '2021-02-05 01:57:18'),
(29, 'USR002', '/var/www/html/~ememberku/login', '180.252.69.27', 'Indonesia', 'Bali', 'Denpasar', '115.2167', NULL, 'Mozilla/5.0 ', ' Gecko/20100101 Firefox/84.0', 'X11; Ubuntu; Linux x86_64; rv:84.0', '2021-02-05 02:01:34', '2021-02-05 02:01:34'),
(30, 'USR002', '/var/www/html/~ememberku/login', '180.252.69.27', 'Indonesia', 'Bali', 'Denpasar', '115.2167', NULL, 'Mozilla/5.0 ', ' Gecko/20100101 Firefox/84.0', 'X11; Ubuntu; Linux x86_64; rv:84.0', '2021-02-05 02:01:34', '2021-02-05 02:01:34'),
(31, 'USR003', '/var/www/html/~ememberku/login', '36.85.188.254', 'Indonesia', 'Bali', 'Denpasar', '115.2167', NULL, 'Mozilla/5.0 ', ' AppleWebKit/537.36 ', 'Windows NT 10.0; Win64; x64', '2021-02-05 02:07:18', '2021-02-05 02:07:18'),
(32, 'USR003', '/var/www/html/~ememberku/login', '36.85.188.254', 'Indonesia', 'Bali', 'Denpasar', '115.2167', NULL, 'Mozilla/5.0 ', ' AppleWebKit/537.36 ', 'Windows NT 10.0; Win64; x64', '2021-02-05 02:07:18', '2021-02-05 02:07:18'),
(33, 'USR001', '/var/www/html/~ememberku/login', '36.85.188.254', 'Indonesia', 'Bali', 'Denpasar', '115.2167', NULL, 'Mozilla/5.0 ', ' AppleWebKit/537.36 ', 'Windows NT 10.0; Win64; x64', '2021-02-05 02:15:09', '2021-02-05 02:15:09'),
(34, 'USR001', '/var/www/html/~ememberku/login', '36.85.188.254', 'Indonesia', 'Bali', 'Denpasar', '115.2167', NULL, 'Mozilla/5.0 ', ' AppleWebKit/537.36 ', 'Windows NT 10.0; Win64; x64', '2021-02-05 02:15:09', '2021-02-05 02:15:09'),
(35, 'USR001', '/var/www/html/~ememberku/login', '36.85.188.254', 'Indonesia', 'Bali', 'Denpasar', '115.2167', NULL, 'Mozilla/5.0 ', ' AppleWebKit/537.36 ', 'Windows NT 10.0; Win64; x64', '2021-02-05 04:20:32', '2021-02-05 04:20:32'),
(36, 'USR001', '/var/www/html/~ememberku/login', '36.85.188.254', 'Indonesia', 'Bali', 'Denpasar', '115.2167', NULL, 'Mozilla/5.0 ', ' AppleWebKit/537.36 ', 'Windows NT 10.0; Win64; x64', '2021-02-05 04:20:32', '2021-02-05 04:20:32'),
(37, 'USR002', '/var/www/html/~ememberku/login', '103.157.247.20', 'Cambodia', 'Banteay Meanchey', 'Paoy Paet', '102.5636', NULL, 'Mozilla/5.0 ', ' AppleWebKit/537.36 ', 'Windows NT 10.0; Win64; x64', '2021-02-05 10:54:14', '2021-02-05 10:54:14'),
(38, 'USR002', '/var/www/html/~ememberku/login', '103.157.247.20', 'Cambodia', 'Banteay Meanchey', 'Paoy Paet', '102.5636', NULL, 'Mozilla/5.0 ', ' AppleWebKit/537.36 ', 'Windows NT 10.0; Win64; x64', '2021-02-05 10:54:14', '2021-02-05 10:54:14'),
(39, 'USR002', '/var/www/html/~ememberku/login', '36.85.193.34', 'Indonesia', 'Bali', 'Denpasar', '115.2167', NULL, 'Mozilla/5.0 ', ' AppleWebKit/537.36 ', 'Windows NT 10.0; Win64; x64', '2021-02-05 10:57:13', '2021-02-05 10:57:13'),
(40, 'USR002', '/var/www/html/~ememberku/login', '36.85.193.34', 'Indonesia', 'Bali', 'Denpasar', '115.2167', NULL, 'Mozilla/5.0 ', ' AppleWebKit/537.36 ', 'Windows NT 10.0; Win64; x64', '2021-02-05 10:57:14', '2021-02-05 10:57:14'),
(41, 'USR002', '/var/www/html/~ememberku/login', '114.122.168.206', 'Indonesia', 'Bali', 'Denpasar', '115.2167', NULL, 'Mozilla/5.0 ', ' AppleWebKit/537.36 ', 'Windows NT 10.0; WOW64', '2021-02-05 14:55:32', '2021-02-05 14:55:32'),
(42, 'USR002', '/var/www/html/~ememberku/login', '114.122.168.206', 'Indonesia', 'Bali', 'Denpasar', '115.2167', NULL, 'Mozilla/5.0 ', ' AppleWebKit/537.36 ', 'Windows NT 10.0; WOW64', '2021-02-05 14:55:33', '2021-02-05 14:55:33'),
(43, 'USR001', '/var/www/html/~ememberku/login', '36.85.188.254', 'Indonesia', 'Bali', 'Denpasar', '115.2167', NULL, 'Mozilla/5.0 ', ' AppleWebKit/537.36 ', 'Windows NT 10.0; Win64; x64', '2021-02-05 19:50:20', '2021-02-05 19:50:20'),
(44, 'USR001', '/var/www/html/~ememberku/login', '36.85.188.254', 'Indonesia', 'Bali', 'Denpasar', '115.2167', NULL, 'Mozilla/5.0 ', ' AppleWebKit/537.36 ', 'Windows NT 10.0; Win64; x64', '2021-02-05 19:50:20', '2021-02-05 19:50:20'),
(45, 'USR001', '/var/www/html/~ememberku/login', '36.85.188.254', 'Indonesia', 'Bali', 'Denpasar', '115.2167', NULL, 'Mozilla/5.0 ', ' AppleWebKit/537.36 ', 'Windows NT 10.0; Win64; x64', '2021-02-06 22:39:23', '2021-02-06 22:39:23'),
(46, 'USR001', '/var/www/html/~ememberku/login', '36.85.188.254', 'Indonesia', 'Bali', 'Denpasar', '115.2167', NULL, 'Mozilla/5.0 ', ' AppleWebKit/537.36 ', 'Windows NT 10.0; Win64; x64', '2021-02-06 22:39:24', '2021-02-06 22:39:24'),
(47, 'USR001', '/var/www/html/~ememberku/login', '36.85.188.254', 'Indonesia', 'Bali', 'Denpasar', '115.2167', NULL, 'Mozilla/5.0 ', ' AppleWebKit/537.36 ', 'Windows NT 10.0; Win64; x64', '2021-02-07 14:06:40', '2021-02-07 14:06:40'),
(48, 'USR001', '/var/www/html/~ememberku/login', '36.85.188.254', 'Indonesia', 'Bali', 'Denpasar', '115.2167', NULL, 'Mozilla/5.0 ', ' AppleWebKit/537.36 ', 'Windows NT 10.0; Win64; x64', '2021-02-07 14:06:40', '2021-02-07 14:06:40'),
(49, 'USR003', '/var/www/html/~ememberku/login', '36.85.188.254', 'Indonesia', 'Bali', 'Denpasar', '115.2167', NULL, 'Mozilla/5.0 ', ' AppleWebKit/537.36 ', 'Windows NT 10.0; Win64; x64', '2021-02-07 14:51:15', '2021-02-07 14:51:15'),
(50, 'USR003', '/var/www/html/~ememberku/login', '36.85.188.254', 'Indonesia', 'Bali', 'Denpasar', '115.2167', NULL, 'Mozilla/5.0 ', ' AppleWebKit/537.36 ', 'Windows NT 10.0; Win64; x64', '2021-02-07 14:51:15', '2021-02-07 14:51:15'),
(51, 'USR001', '/var/www/html/~ememberku/login', '36.85.188.254', 'Indonesia', 'Bali', 'Denpasar', '115.2167', NULL, 'Mozilla/5.0 ', ' AppleWebKit/537.36 ', 'Windows NT 10.0; Win64; x64', '2021-02-07 14:51:33', '2021-02-07 14:51:33'),
(52, 'USR001', '/var/www/html/~ememberku/login', '36.85.188.254', 'Indonesia', 'Bali', 'Denpasar', '115.2167', NULL, 'Mozilla/5.0 ', ' AppleWebKit/537.36 ', 'Windows NT 10.0; Win64; x64', '2021-02-07 14:51:33', '2021-02-07 14:51:33'),
(53, 'USR001', '/var/www/html/~ememberku/login', '110.136.224.191', 'Indonesia', 'Bali', 'Denpasar', '115.2167', NULL, 'Mozilla/5.0 ', ' AppleWebKit/537.36 ', 'Windows NT 10.0; Win64; x64', '2021-02-11 23:58:03', '2021-02-11 23:58:03'),
(54, 'USR001', '/var/www/html/~ememberku/login', '110.136.224.191', 'Indonesia', 'Bali', 'Denpasar', '115.2167', NULL, 'Mozilla/5.0 ', ' AppleWebKit/537.36 ', 'Windows NT 10.0; Win64; x64', '2021-02-11 23:58:03', '2021-02-11 23:58:03'),
(55, 'USR001', '/var/www/html/~ememberku/login', '110.136.224.191', 'Indonesia', 'Bali', 'Denpasar', '115.2167', NULL, 'Mozilla/5.0 ', ' AppleWebKit/537.36 ', 'Windows NT 10.0; Win64; x64', '2021-02-12 04:39:54', '2021-02-12 04:39:54'),
(56, 'USR001', '/var/www/html/~ememberku/login', '110.136.224.191', 'Indonesia', 'Bali', 'Denpasar', '115.2167', NULL, 'Mozilla/5.0 ', ' AppleWebKit/537.36 ', 'Windows NT 10.0; Win64; x64', '2021-02-12 04:39:54', '2021-02-12 04:39:54'),
(57, 'USR001', '/var/www/html/~ememberku/login', '110.136.224.191', 'Indonesia', 'Bali', 'Denpasar', '115.2167', NULL, 'Mozilla/5.0 ', ' AppleWebKit/537.36 ', 'Windows NT 10.0; Win64; x64', '2021-02-12 06:45:30', '2021-02-12 06:45:30'),
(58, 'USR001', '/var/www/html/~ememberku/login', '110.136.224.191', 'Indonesia', 'Bali', 'Denpasar', '115.2167', NULL, 'Mozilla/5.0 ', ' AppleWebKit/537.36 ', 'Windows NT 10.0; Win64; x64', '2021-02-12 06:45:30', '2021-02-12 06:45:30'),
(59, 'USR002', '/var/www/html/~ememberku/login', '103.138.192.32', 'Cambodia', 'Banteay Meanchey', 'Paoy Paet', '102.5636', NULL, 'Mozilla/5.0 ', ' AppleWebKit/537.36 ', 'Windows NT 10.0; Win64; x64', '2021-02-12 22:47:56', '2021-02-12 22:47:56'),
(60, 'USR002', '/var/www/html/~ememberku/login', '103.138.192.32', 'Cambodia', 'Banteay Meanchey', 'Paoy Paet', '102.5636', NULL, 'Mozilla/5.0 ', ' AppleWebKit/537.36 ', 'Windows NT 10.0; Win64; x64', '2021-02-12 22:47:56', '2021-02-12 22:47:56'),
(61, 'USR002', '/var/www/html/~ememberku/login', '103.122.65.230', 'Indonesia', 'Bali', 'Denpasar', '115.2167', NULL, 'Mozilla/5.0 ', ' AppleWebKit/537.36 ', 'Windows NT 10.0; Win64; x64', '2021-02-12 22:53:36', '2021-02-12 22:53:36'),
(62, 'USR002', '/var/www/html/~ememberku/login', '103.122.65.230', 'Indonesia', 'Bali', 'Denpasar', '115.2167', NULL, 'Mozilla/5.0 ', ' AppleWebKit/537.36 ', 'Windows NT 10.0; Win64; x64', '2021-02-12 22:53:36', '2021-02-12 22:53:36'),
(63, 'USR002', '/var/www/html/~ememberku/login', '45.201.201.176', 'Cambodia', 'Phnom Penh', 'Phnom Penh', '104.916', NULL, 'Mozilla/5.0 ', ' AppleWebKit/537.36 ', 'Windows NT 10.0; Win64; x64', '2021-02-12 23:45:11', '2021-02-12 23:45:11'),
(64, 'USR002', '/var/www/html/~ememberku/login', '45.201.201.176', 'Cambodia', 'Phnom Penh', 'Phnom Penh', '104.916', NULL, 'Mozilla/5.0 ', ' AppleWebKit/537.36 ', 'Windows NT 10.0; Win64; x64', '2021-02-12 23:45:11', '2021-02-12 23:45:11'),
(65, 'USR001', '/var/www/html/~ememberku/login', '110.136.224.191', 'Indonesia', 'Bali', 'Denpasar', '115.2167', NULL, 'Mozilla/5.0 ', ' AppleWebKit/537.36 ', 'Windows NT 10.0; Win64; x64', '2021-02-13 02:33:04', '2021-02-13 02:33:04'),
(66, 'USR001', '/var/www/html/~ememberku/login', '110.136.224.191', 'Indonesia', 'Bali', 'Denpasar', '115.2167', NULL, 'Mozilla/5.0 ', ' AppleWebKit/537.36 ', 'Windows NT 10.0; Win64; x64', '2021-02-13 02:33:04', '2021-02-13 02:33:04'),
(67, 'USR001', '/var/www/html/~ememberku/login', '180.254.229.103', 'Indonesia', 'Bali', 'Denpasar', '115.2167', NULL, 'Mozilla/5.0 ', ' AppleWebKit/537.36 ', 'Windows NT 10.0; Win64; x64', '2021-02-16 00:09:25', '2021-02-16 00:09:25'),
(68, 'USR001', '/var/www/html/~ememberku/login', '180.254.229.103', 'Indonesia', 'Bali', 'Denpasar', '115.2167', NULL, 'Mozilla/5.0 ', ' AppleWebKit/537.36 ', 'Windows NT 10.0; Win64; x64', '2021-02-16 00:09:25', '2021-02-16 00:09:25'),
(69, 'USR002', '/var/www/html/~ememberku/login', '110.136.231.76', 'Indonesia', 'Bali', 'Denpasar', '115.2167', NULL, 'Mozilla/5.0 ', ' AppleWebKit/537.36 ', 'Windows NT 10.0; Win64; x64', '2021-02-16 10:19:23', '2021-02-16 10:19:23'),
(70, 'USR002', '/var/www/html/~ememberku/login', '110.136.231.76', 'Indonesia', 'Bali', 'Denpasar', '115.2167', NULL, 'Mozilla/5.0 ', ' AppleWebKit/537.36 ', 'Windows NT 10.0; Win64; x64', '2021-02-16 10:19:23', '2021-02-16 10:19:23'),
(71, 'USR002', '/var/www/html/~ememberku/login', '103.122.65.230', 'Indonesia', 'Bali', 'Denpasar', '115.2167', NULL, 'Mozilla/5.0 ', ' AppleWebKit/537.36 ', 'Windows NT 10.0; Win64; x64', '2021-02-16 22:03:15', '2021-02-16 22:03:15'),
(72, 'USR002', '/var/www/html/~ememberku/login', '103.122.65.230', 'Indonesia', 'Bali', 'Denpasar', '115.2167', NULL, 'Mozilla/5.0 ', ' AppleWebKit/537.36 ', 'Windows NT 10.0; Win64; x64', '2021-02-16 22:03:15', '2021-02-16 22:03:15'),
(73, 'USR001', '/var/www/html/~ememberku/login', '180.254.229.103', 'Indonesia', 'Bali', 'Denpasar', '115.2167', NULL, 'Mozilla/5.0 ', ' AppleWebKit/537.36 ', 'Windows NT 10.0; Win64; x64', '2021-02-16 22:16:01', '2021-02-16 22:16:01'),
(74, 'USR001', '/var/www/html/~ememberku/login', '180.254.229.103', 'Indonesia', 'Bali', 'Denpasar', '115.2167', NULL, 'Mozilla/5.0 ', ' AppleWebKit/537.36 ', 'Windows NT 10.0; Win64; x64', '2021-02-16 22:16:01', '2021-02-16 22:16:01'),
(75, 'USR001', '/var/www/html/~ememberku/login', '180.254.229.103', 'Indonesia', 'Bali', 'Denpasar', '115.2167', NULL, 'Mozilla/5.0 ', ' AppleWebKit/537.36 ', 'Windows NT 10.0; Win64; x64', '2021-02-17 02:34:43', '2021-02-17 02:34:43'),
(76, 'USR001', '/var/www/html/~ememberku/login', '180.254.229.103', 'Indonesia', 'Bali', 'Denpasar', '115.2167', NULL, 'Mozilla/5.0 ', ' AppleWebKit/537.36 ', 'Windows NT 10.0; Win64; x64', '2021-02-17 02:34:43', '2021-02-17 02:34:43'),
(77, 'USR002', '/var/www/html/~ememberku/login', '43.230.61.82', 'Cambodia', 'Phnom Penh', 'Phnom Penh', '104.916', NULL, 'Mozilla/5.0 ', ' AppleWebKit/537.36 ', 'Windows NT 10.0; Win64; x64', '2021-02-17 20:00:47', '2021-02-17 20:00:47'),
(78, 'USR002', '/var/www/html/~ememberku/login', '43.230.61.82', 'Cambodia', 'Phnom Penh', 'Phnom Penh', '104.916', NULL, 'Mozilla/5.0 ', ' AppleWebKit/537.36 ', 'Windows NT 10.0; Win64; x64', '2021-02-17 20:00:47', '2021-02-17 20:00:47'),
(79, 'USR002', '/var/www/html/~ememberku/login', '103.122.65.230', 'Indonesia', 'Bali', 'Denpasar', '115.2167', NULL, 'Mozilla/5.0 ', ' AppleWebKit/537.36 ', 'Windows NT 10.0; Win64; x64', '2021-02-17 22:15:21', '2021-02-17 22:15:21'),
(80, 'USR002', '/var/www/html/~ememberku/login', '103.122.65.230', 'Indonesia', 'Bali', 'Denpasar', '115.2167', NULL, 'Mozilla/5.0 ', ' AppleWebKit/537.36 ', 'Windows NT 10.0; Win64; x64', '2021-02-17 22:15:21', '2021-02-17 22:15:21'),
(81, 'USR001', '/var/www/html/~ememberku/login', '180.254.229.103', 'Indonesia', 'Bali', 'Denpasar', '115.2167', NULL, 'Mozilla/5.0 ', ' AppleWebKit/537.36 ', 'Windows NT 10.0; Win64; x64', '2021-02-18 18:50:12', '2021-02-18 18:50:12'),
(82, 'USR001', '/var/www/html/~ememberku/login', '180.254.229.103', 'Indonesia', 'Bali', 'Denpasar', '115.2167', NULL, 'Mozilla/5.0 ', ' AppleWebKit/537.36 ', 'Windows NT 10.0; Win64; x64', '2021-02-18 18:50:12', '2021-02-18 18:50:12'),
(83, 'USR002', '/var/www/html/~ememberku/login', '180.252.69.27', 'Indonesia', 'Bali', 'Denpasar', '115.2167', NULL, 'Mozilla/5.0 ', ' AppleWebKit/537.36 ', 'X11; Linux x86_64', '2021-02-18 18:55:56', '2021-02-18 18:55:56'),
(84, 'USR002', '/var/www/html/~ememberku/login', '180.252.69.27', 'Indonesia', 'Bali', 'Denpasar', '115.2167', NULL, 'Mozilla/5.0 ', ' AppleWebKit/537.36 ', 'X11; Linux x86_64', '2021-02-18 18:55:56', '2021-02-18 18:55:56'),
(85, 'USR002', '/var/www/html/~ememberku/login', '180.249.116.115', 'Indonesia', 'Bali', 'Denpasar', '115.2167', NULL, 'Mozilla/5.0 ', ' Gecko/20100101 Firefox/85.0', 'Windows NT 10.0; Win64; x64; rv:85.0', '2021-02-18 20:22:34', '2021-02-18 20:22:34'),
(86, 'USR002', '/var/www/html/~ememberku/login', '180.249.116.115', 'Indonesia', 'Bali', 'Denpasar', '115.2167', NULL, 'Mozilla/5.0 ', ' Gecko/20100101 Firefox/85.0', 'Windows NT 10.0; Win64; x64; rv:85.0', '2021-02-18 20:22:34', '2021-02-18 20:22:34'),
(87, 'USR001', '/var/www/html/~ememberku/login', '180.254.229.103', 'Indonesia', 'Bali', 'Denpasar', '115.2167', NULL, 'Mozilla/5.0 ', ' AppleWebKit/537.36 ', 'Windows NT 10.0; Win64; x64', '2021-02-19 04:02:00', '2021-02-19 04:02:00'),
(88, 'USR001', '/var/www/html/~ememberku/login', '180.254.229.103', 'Indonesia', 'Bali', 'Denpasar', '115.2167', NULL, 'Mozilla/5.0 ', ' AppleWebKit/537.36 ', 'Windows NT 10.0; Win64; x64', '2021-02-19 04:02:00', '2021-02-19 04:02:00');

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

--
-- Table structure for table `members`
--

CREATE TABLE `members` (
  `idmember` varchar(13) COLLATE utf8mb4_unicode_ci NOT NULL,
  `idbranch` varchar(6) COLLATE utf8mb4_unicode_ci NOT NULL,
  `username` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `fullname` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `idbank` varchar(6) COLLATE utf8mb4_unicode_ci NOT NULL,
  `mbraccname` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mbraccno` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `level` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `remark` text COLLATE utf8mb4_unicode_ci,
  `isactive` smallint(6) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `members`
--

INSERT INTO `members` (`idmember`, `idbranch`, `username`, `fullname`, `email`, `phone`, `idbank`, `mbraccname`, `mbraccno`, `level`, `remark`, `isactive`, `created_at`, `updated_at`) VALUES
('MBR2102000001', 'BRC001', 'seringaiid', 'Seringai Band', 'seringai@demo.com', '08198765423', 'BANK01', 'Seringai', '123123123', 'WHITE', NULL, 1, '2021-02-05 04:32:07', '2021-02-07 14:44:19'),
('MBR2102000002', 'BRC001', 'TEST2021', 'TEST DULU', NULL, NULL, 'BANK01', 'TEST DULU', '123123123', 'WHITE', NULL, 1, '2021-02-17 02:35:12', '2021-02-17 02:35:12'),
('MBR2102000003', 'BRC001', 'DERI88', 'DERI PUTRA', NULL, NULL, 'BANK02', 'DERI PUTRA', '1153120521', 'WHITE', NULL, 1, '2021-02-17 20:15:45', '2021-02-17 20:15:45'),
('MBR2102000004', 'BRC001', 'DERI88', 'DERI PUTRA', NULL, NULL, 'BANK02', 'DERI PUTRA', '1153120521', 'WHITE', NULL, 1, '2021-02-17 20:15:50', '2021-02-17 20:15:50'),
('MBR2102000005', 'BRC001', 'DERI88', 'DERI PUTRA', NULL, NULL, 'BANK02', 'DERI PUTRA', '1153120521', 'WHITE', NULL, 1, '2021-02-17 20:15:50', '2021-02-17 20:15:50'),
('MBR2102000006', 'BRC001', 'deri085', 'DERI PUTRA', NULL, NULL, 'BANK01', 'DERI PUTRA', '1153120214', 'WHITE', NULL, 1, '2021-02-17 21:23:57', '2021-02-17 21:23:57'),
('MBR2102000007', 'BRC001', 'deri086', 'DERI PUTRA', NULL, NULL, 'BANK01', 'deriansyah', '1153120105', 'WHITE', NULL, 1, '2021-02-17 21:25:11', '2021-02-17 21:25:11'),
('MBR2102000008', 'BRC001', 'deri087', 'DERI PUTRA', NULL, NULL, 'BANK01', 'DERI PUTRA', '1153120047', 'WHITE', NULL, 1, '2021-02-17 21:25:54', '2021-02-17 21:25:54');

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

--
-- Table structure for table `menus`
--

CREATE TABLE `menus` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `parent` int(11) DEFAULT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `root` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `icon` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `page` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `newtab` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mnheader` int(11) DEFAULT NULL,
  `mnorder` int(11) DEFAULT NULL,
  `isactive` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `menus`
--

INSERT INTO `menus` (`id`, `parent`, `title`, `slug`, `root`, `icon`, `page`, `newtab`, `mnheader`, `mnorder`, `isactive`, `created_at`, `updated_at`) VALUES
(1, NULL, 'Dashboard', 'dashboard', 'true', 'flaticon2-layers', '/', '/', 1, 1, 1, '2021-01-13 23:55:47', '2021-02-02 04:51:27'),
(2, NULL, 'Transaction', 'transaction', 'true', 'flaticon2-checking', 'transaction', 'transaction', 1, 2, 1, '2021-01-13 23:57:01', '2021-02-02 17:45:38'),
(3, 2, 'Add Transaction', 'add-transaction', 'true', 'flaticon2-checking', 'transaction', 'false', NULL, 1, 1, '2021-01-13 23:59:08', '2021-02-02 17:45:30'),
(4, 2, 'History Transaction', 'history-transaction', 'true', 'flaticon2-checking', 'history-transaction', 'false', NULL, 2, 1, '2021-01-13 23:59:36', NULL),
(5, 0, 'Master Data', 'master-data', 'true', 'flaticon2-download', '', 'false', NULL, 7, 1, '2021-01-14 20:44:36', NULL),
(6, 5, 'Branch', 'branch', 'true', '', 'branches', 'branches', NULL, 4, 1, '2021-01-14 20:45:06', '2021-02-04 04:06:59'),
(7, 0, 'Users', 'users', 'true', 'flaticon2-user', '', 'false', NULL, 6, 1, '2021-01-14 20:58:56', NULL),
(8, 7, 'Data User', 'data-user', 'true', '', 'users', 'false', NULL, 1, 1, '2021-01-14 20:59:39', NULL),
(10, 5, 'Bank', 'bank', 'true', '', 'banks', 'false', NULL, 3, 1, '2021-01-18 13:01:39', NULL),
(11, 5, 'Account', 'account', 'true', '', 'accounts', 'false', NULL, 1, 1, '2021-01-18 13:02:22', NULL),
(13, 0, 'Settings', 'settings', 'true', 'flaticon2-settings', '', 'false', NULL, 8, 1, '2021-01-18 13:25:47', NULL),
(14, 13, 'General Setting', 'general-setting', 'true', '', 'general-setting', 'false', NULL, 1, 1, '2021-01-18 13:26:28', NULL),
(15, 13, 'Sidebar Menu', 'sidebar-menu', 'true', '', 'sidebar-menu', 'false', NULL, 2, 1, '2021-01-18 13:26:59', NULL),
(16, 0, 'Members', 'members', 'true', 'flaticon2-avatar', 'members', 'false', 1, 5, 1, '2021-01-18 13:33:12', NULL),
(17, 16, 'Data Member', 'data-member', 'true', 'flaticon2-avatar', 'members', 'false', NULL, 1, 1, '2021-01-18 13:39:06', NULL),
(18, 16, 'Blacklist', 'blacklist', 'true', '', 'blacklist', 'false', NULL, 2, 0, '2021-01-18 13:39:37', NULL),
(19, 0, 'Finance', 'finance', 'true', 'flaticon2-line-chart', '', 'false', NULL, 4, 1, '2021-01-18 13:41:01', NULL),
(20, 19, 'Balance', 'balance', 'true', 'flaticon2-line-chart', 'balances', 'false', NULL, 3, 1, '2021-01-18 13:41:27', NULL),
(22, 19, 'Audit', 'audit', 'true', 'flaticon2-line-chart', 'audit', 'false', 1, 2, 1, '2021-01-18 13:46:15', NULL),
(23, 0, 'Bonus', 'bonus', 'true', 'flaticon2-gift', '', 'false', NULL, 3, 1, '2021-01-18 13:47:53', NULL),
(24, 23, 'Data Bonus', 'data-bonus', 'true', '', 'bonus', 'false', NULL, 1, 1, '2021-01-18 13:49:37', NULL),
(25, 0, 'Log Information', 'log-information', 'true', 'flaticon-safe-shield-protection', 'log-information', 'false', NULL, 9, 1, '2021-01-18 13:50:31', NULL),
(26, 7, 'Login History', 'login-history', 'true', '', 'login-history', 'false', NULL, 3, 1, '2021-01-18 13:55:56', NULL),
(27, 7, 'Data Group', 'data-group', 'true', '', 'groups', 'false', NULL, 2, 1, '2021-02-02 00:32:21', NULL),
(28, 19, 'Coin', 'coins', 'true', 'flaticon2-line-chart', 'coins', 'false', NULL, 4, 1, '2021-02-05 02:23:11', NULL),
(29, 19, 'Summary', 'summary', 'true', 'flaticon2-line-chart', 'summary', 'summary', NULL, 1, 1, '2021-02-05 18:20:30', '2021-02-05 18:20:30'),
(30, 7, 'Activity', 'activity', 'true', 'flaticon2-list-1', 'activity', 'activity', NULL, 4, 1, '2021-02-19 02:00:30', '2021-02-19 02:07:28');

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

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

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

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

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_resets_table', 1),
(3, '2014_10_12_200000_add_two_factor_columns_to_users_table', 1),
(4, '2019_08_19_000000_create_failed_jobs_table', 1),
(5, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(6, '2021_01_10_081539_create_branches_table', 1),
(7, '2021_01_10_125700_create_banks_table', 1),
(8, '2021_01_10_125914_create_accounts_table', 1),
(9, '2021_01_10_130536_create_products_table', 1),
(10, '2021_01_10_130839_create_settings_table', 1),
(11, '2021_01_10_131536_create_members_table', 1),
(12, '2021_01_10_132219_create_transactions_table', 1),
(13, '2021_01_12_114804_create_sessions_table', 1),
(14, '2021_01_13_143541_create_menus_table', 1),
(15, '2021_01_18_074219_create_logins_table', 1),
(16, '2021_01_18_074455_create_versions_table', 1),
(17, '2021_01_19_215904_add_login_fields_to_users_table', 1),
(18, '2021_02_01_205911_create_balances_table', 1),
(19, '2021_02_02_001119_create_groups_table', 1),
(20, '2021_02_02_001453_create_details_table', 1),
(21, '2021_02_05_022126_create_coins_table', 2);

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

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

CREATE TABLE `password_resets` (
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `personal_access_tokens` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `tokenable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tokenable_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
  `abilities` text COLLATE utf8mb4_unicode_ci,
  `last_used_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `products` (
  `idproduct` varchar(6) COLLATE utf8mb4_unicode_ci NOT NULL,
  `idbranch` varchar(6) COLLATE utf8mb4_unicode_ci NOT NULL,
  `productname` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `site1` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `site2` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `site3` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remark` text COLLATE utf8mb4_unicode_ci,
  `isactive` smallint(6) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `products` (`idproduct`, `idbranch`, `productname`, `site1`, `site2`, `site3`, `remark`, `isactive`, `created_at`, `updated_at`) VALUES
('PID001', 'BRC001', 'TOGEL ONLINE', NULL, NULL, NULL, NULL, 1, '2021-02-05 12:41:32', '2021-02-05 12:41:32'),
('PID002', 'BRC001', 'CASINO ONLINE', NULL, NULL, NULL, NULL, 1, '2021-02-05 12:41:50', '2021-02-05 12:41:50');

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

--
-- Table structure for table `sessions`
--

CREATE TABLE `sessions` (
  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` varchar(6) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_agent` text COLLATE utf8mb4_unicode_ci,
  `payload` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_activity` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sessions`
--

INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES
('22wKMIdAU3oy7kqRn1aBvqxVmDS4sjFvCZ17zEIU', NULL, '168.119.186.61', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/84.0.4147.105 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiSlJRbTFvaDVLOHJ5YmpLSVFXY1FwWXl5ZVFrVElVenU4aWh3YmFHWCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzA6Imh0dHBzOi8vdmlldHRyYW5zZmVyLmNvbS9sb2dpbiI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1613676355),
('2KLcWPhba6L0oFbrr9tkDBx5LoTrPjZtf5Cx4n00', 'USR001', '180.254.229.103', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.182 Safari/537.36', 'YTo3OntzOjY6Il90b2tlbiI7czo0MDoiZGROcVR0YU1NaUhBV0NOTVVaVXZnaUF2cExKSDRMbnAzU2ZlWmF6diI7czozOiJ1cmwiO2E6MDp7fXM6OToiX3ByZXZpb3VzIjthOjE6e3M6MzoidXJsIjtzOjQ1OiJodHRwOi8vMTI4LjE5OS4yMjEuMTI5L35lbWVtYmVya3UvdHJhbnNhY3Rpb24iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX1zOjUwOiJsb2dpbl93ZWJfNTliYTM2YWRkYzJiMmY5NDAxNTgwZjAxNGM3ZjU4ZWE0ZTMwOTg5ZCI7czo2OiJVU1IwMDEiO3M6MTc6InBhc3N3b3JkX2hhc2hfd2ViIjtzOjYwOiIkMnkkMTAkREV5dEJDTGtoZktPaFN3aERuWFFZLlF5RXVQc1hjQnJaaVFqWnVBS0NVREpmMlNEVlYvVHkiO3M6NToiYWxlcnQiO2E6MDp7fX0=', 1613678890),
('2riDWR5Ex4BXXGgoSI25FW47PTHwPYYs2FOHI91g', NULL, '66.249.79.185', 'Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.153 Mobile Safari/537.36 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiMlA2WnM2OEVCUFdIRUNrS3lkdFFJbG1wTnNEUW1Hcm5aeTZKQmFzeiI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czo0ODoiaHR0cHM6Ly93d3cudmlldHRyYW5zZmVyLmNvbS9wcm9kdWN0cy9qb3NodWEtdGVlIjt9czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzQ6Imh0dHBzOi8vd3d3LnZpZXR0cmFuc2Zlci5jb20vbG9naW4iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1613702179),
('6ia6TzYPIvOqZ9FKoFPIxvUUB35mzJCid2l7hwuZ', NULL, '128.14.134.134', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/60.0.3112.113 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiR3UxRzZrYmQxdFdmYkJ3OFVRdDQzaFVWV0RFYkVQdnlxNUFLUnZaZyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjk6Imh0dHBzOi8vMTI4LjE5OS4yMjEuMTI5L2xvZ2luIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1613677936),
('97Ygvqg6ZNI8QSQWK0SbmCkTpHcH6bzyXELkpF71', NULL, '66.249.79.22', 'Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiRW4ycEU5MWllY01halQzbGxrYnRUM0RkMXJ2R09yWXlnZnIwOWRmYSI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czoyNDoiaHR0cHM6Ly92aWV0dHJhbnNmZXIuY29tIjt9czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzA6Imh0dHBzOi8vdmlldHRyYW5zZmVyLmNvbS9sb2dpbiI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1613682268),
('BSNaCzq6uEI88spTGjZKqLnLRdnrqpbY0rsnEScR', NULL, '168.119.186.61', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/84.0.4147.105 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiNDRIbmVqa2pOb1BhbkFKc3RHR0NiTkR1UmhxWFBKTW5KbTZmYmhLSSI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czo1OToiaHR0cHM6Ly92aWV0dHJhbnNmZXIuY29tL3Byb2R1Y3RzL3Zpc2lvbi1mbGVlY2UtZGlydHktYmxhY2siO31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czo1OToiaHR0cHM6Ly92aWV0dHJhbnNmZXIuY29tL3Byb2R1Y3RzL3Zpc2lvbi1mbGVlY2UtZGlydHktYmxhY2siO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1613676354),
('CbRodkKKuggbJzg5qt2JdkkmIEbQUfVr8RiWeus0', NULL, '216.218.206.68', '', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoid2lJMFNLVFk4RFNkTEtXbU52RlJHUGVhVGkzTmJGNWptcUFCcHNtQiI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czoyMzoiaHR0cHM6Ly8xMjguMTk5LjIyMS4xMjkiO31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czoyMzoiaHR0cHM6Ly8xMjguMTk5LjIyMS4xMjkiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1613695954),
('dk1ZK73AV1uI2hyorM5EH6XGCK5zQWc7DMgn9FwU', NULL, '128.14.134.134', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/60.0.3112.113 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiajY0STVVbjJMMDlPVzdRZXR4MEtBRndhOE1LcU0yWXl4SHRFRU9DSyI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czoyMzoiaHR0cHM6Ly8xMjguMTk5LjIyMS4xMjkiO31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czoyMzoiaHR0cHM6Ly8xMjguMTk5LjIyMS4xMjkiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1613677936),
('dRI2Hi6qVgf6XFW6uLqEKWaY0btVIEY3gjE1fRFx', NULL, '178.62.205.233', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/83.0.4103.61 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiWWRzUGxCcVhHY3pNODF0V3lmOUJHV3NyRjFCeWJKUTJxZk0zeTJNbyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzQ6Imh0dHA6Ly9lbWVtYmVya3UuZHVja2Rucy5vcmcvbG9naW4iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1613683021),
('fVvJ6DCMcFbS1ckx6fdhkvLYMKxFxpN4zfx97qSX', NULL, '139.162.113.204', 'HTTP Banner Detection (https://security.ipip.net)', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiU1dnYXNBVTVmUzdNeWZhRjFhamdWVTlOWlNyYVB1UVVza0pCT3ppeSI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czoyMzoiaHR0cHM6Ly8xMjguMTk5LjIyMS4xMjkiO31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czoyMzoiaHR0cHM6Ly8xMjguMTk5LjIyMS4xMjkiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1613680535),
('H1pznyLE9etxDk0r5ZJYioE2TrsRfDNw0CRFbzWh', NULL, '114.119.140.196', 'Mozilla/5.0 (Linux; Android 7.0;) AppleWebKit/537.36 (KHTML, like Gecko) Mobile Safari/537.36 (compatible; PetalBot;+https://aspiegel.com/petalbot)', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiVWx0eXZXaG5mbExMT3llUVpRYTZaeG1OSVdHOGJ0T2VNUndNc29OQiI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czo3NjoiaHR0cHM6Ly92aWV0dHJhbnNmZXIuY29tL3Byb2R1Y3RzL21heW9yLXN1bmdsYXNzZXMtYnVybmlzaGVkLWJyb3duLXBvbGFyaXplZCI7fXM6OToiX3ByZXZpb3VzIjthOjE6e3M6MzoidXJsIjtzOjMwOiJodHRwczovL3ZpZXR0cmFuc2Zlci5jb20vbG9naW4iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1613685414),
('jLhG4nGJtzSoxHKAJFD2KqbQYq2eIDTHXxkki3QZ', NULL, '192.53.170.243', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/60.0.3112.113 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiM1MwalI3dUc3MVAzdHNvUEFnRFphNXpQWFNsZ2Y5ekNRSFFvd0I3eiI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czoyMzoiaHR0cHM6Ly8xMjguMTk5LjIyMS4xMjkiO31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czoyMzoiaHR0cHM6Ly8xMjguMTk5LjIyMS4xMjkiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1613683469),
('K1yoAVofzSihOx9lWD2EdBrsAlDJeFYr3sYTi2g2', NULL, '180.249.187.113', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:85.0) Gecko/20100101 Firefox/85.0', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiQmc5UnhxWmpzZUo4V0dHM0hFVUdpc3NIM2hBdk50MGlKclp3RVJOSCI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czozMzoiaHR0cDovLzEyOC4xOTkuMjIxLjEyOS9+ZW1lbWJlcmt1Ijt9czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mzk6Imh0dHA6Ly8xMjguMTk5LjIyMS4xMjkvfmVtZW1iZXJrdS9sb2dpbiI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1613703166),
('Lf4jDvk2a2N0J2NEwYz5VWh2R7ezIRpRN0mlK6Z5', NULL, '178.62.205.233', '', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiVnc4aVRhNEtMNm9HNEpGQTNaZXdxVUJWbXUwTjFpTXFZR3pYS29xMiI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czoyODoiaHR0cDovL2VtZW1iZXJrdS5kdWNrZG5zLm9yZyI7fXM6OToiX3ByZXZpb3VzIjthOjE6e3M6MzoidXJsIjtzOjI4OiJodHRwOi8vZW1lbWJlcmt1LmR1Y2tkbnMub3JnIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1613683020),
('MJGJarzDUoeolixktEp1LdKdWhZvqJ4cUpPNl4Jl', NULL, '51.11.229.77', '', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiTG15bDNDWm5IdW04dWNtUGFLWGlGZUJJcDRpTmNiUWh6TDlXS3R1QiI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czoyODoiaHR0cDovL2VtZW1iZXJrdS5kdWNrZG5zLm9yZyI7fXM6OToiX3ByZXZpb3VzIjthOjE6e3M6MzoidXJsIjtzOjI4OiJodHRwOi8vZW1lbWJlcmt1LmR1Y2tkbnMub3JnIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1613685055),
('mSnYgcaTYdrAqWocZGvuXydpkdMGTarVssJH3i2Z', NULL, '192.53.170.243', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/60.0.3112.113 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiVzZsdk1NbUdoNjNFV2VNS3p5eVNvVWpoSWlKTTNaWVFTYXVhd1JORyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjk6Imh0dHBzOi8vMTI4LjE5OS4yMjEuMTI5L2xvZ2luIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1613683470),
('radcrRSWbkpWihaICfIhvNDvlSYaoKUGlDlRvJeA', NULL, '13.66.139.117', 'Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiY0o3cW0zbTJIVEhzRmhkcDVOck80c0h4UmprRVFLRllIejlXeUZ3byI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czoyNDoiaHR0cHM6Ly92aWV0dHJhbnNmZXIuY29tIjt9czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjQ6Imh0dHBzOi8vdmlldHRyYW5zZmVyLmNvbSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1613682756),
('RospgG4kCXSJxBQZBMgrQV4yNm3ZloicNuj7NSUs', NULL, '193.118.53.194', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/60.0.3112.113 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiVmJoZUJvUmZyVjJ0UTZjcTYyZDdGUWQ1MEE1V0NjdkZyMktuMUJnUCI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czoyMzoiaHR0cHM6Ly8xMjguMTk5LjIyMS4xMjkiO31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czoyMzoiaHR0cHM6Ly8xMjguMTk5LjIyMS4xMjkiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1613701040),
('UdPvojusXMf9oP4u6AJVHar0UoX0ezB3djo3ZHZh', NULL, '180.149.125.171', 'Mozilla/5.0 (Windows NT 5.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/60.0.3112.90 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiWDU1VDBvcXd3Yjg5VDJYenRQejhWbW9aOXcyTTVuWWZoRkRDdlpzdCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjk6Imh0dHBzOi8vMTI4LjE5OS4yMjEuMTI5L2xvZ2luIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1613681858),
('uocF6JguYYyBiel7luqcpHdDx9FiV62JbxkPgEzk', NULL, '174.138.4.57', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/83.0.4103.61 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiNW50V2Q1UEdmbDdKTWw2WnFaUE9sMnJWTmRicFBuamZ3cW50THdZMiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzQ6Imh0dHA6Ly9lbWVtYmVya3UuZHVja2Rucy5vcmcvbG9naW4iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1613694342),
('UP12vPodgSXV17DJHaAX3bDZ1GXJQYxzhAxmOcl9', NULL, '205.185.122.102', '', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiQzJFeDVYZVFoN2l2UExTVlFDTk1VTXU3Q1NjbmpOcU9nYTJHM2V5TSI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czoyODoiaHR0cDovL2VtZW1iZXJrdS5kdWNrZG5zLm9yZyI7fXM6OToiX3ByZXZpb3VzIjthOjE6e3M6MzoidXJsIjtzOjI4OiJodHRwOi8vZW1lbWJlcmt1LmR1Y2tkbnMub3JnIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1613698446),
('uRwNt5GFk01J2St1dJPOUCFp2cXvZpP5ozFMjwqu', NULL, '174.138.4.57', '', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiMFlURHZHSTJ4NDRsRm5iWWxYZjdoTmhDTlVlZDdwU3ZtUkFSeGN5NyI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czoyODoiaHR0cDovL2VtZW1iZXJrdS5kdWNrZG5zLm9yZyI7fXM6OToiX3ByZXZpb3VzIjthOjE6e3M6MzoidXJsIjtzOjI4OiJodHRwOi8vZW1lbWJlcmt1LmR1Y2tkbnMub3JnIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1613694341),
('vNhwVTKtqI4vjPnLugkTppcEo8BKra4tRozhMn9v', NULL, '114.55.95.132', '', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiRXRxYVhLUTRGeEhvM2x5ZllySU1Sc1VMeFFWM2czYmpiSTZCYnZEMyI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czoyODoiaHR0cDovL2VtZW1iZXJrdS5kdWNrZG5zLm9yZyI7fXM6OToiX3ByZXZpb3VzIjthOjE6e3M6MzoidXJsIjtzOjI4OiJodHRwOi8vZW1lbWJlcmt1LmR1Y2tkbnMub3JnIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1613685425),
('WR86LeYs7ykpVQAkmlv0jmqA3bst9a70B8ri7F7X', NULL, '180.149.125.171', 'Mozilla/5.0 (Windows NT 5.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/60.0.3112.90 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiRFhoMmJ6UFc5R1dlVWxwUE1JbTB4MlZJRTdja09qY2lCcHpmQkxCNiI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czoyMzoiaHR0cHM6Ly8xMjguMTk5LjIyMS4xMjkiO31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czoyMzoiaHR0cHM6Ly8xMjguMTk5LjIyMS4xMjkiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1613681858),
('XYVksfy2fTsySqrdlsInnNFqMaGPsJuy86y9y8hq', NULL, '193.118.53.202', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/60.0.3112.113 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiZVlGN1NyM2xVVzR3OEk0dXlZcU10MUF4RXRIZE9ibFZNaXo2emVPeSI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czoyMzoiaHR0cHM6Ly8xMjguMTk5LjIyMS4xMjkiO31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czoyMzoiaHR0cHM6Ly8xMjguMTk5LjIyMS4xMjkiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1613692478);

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

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `optname` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `optvalue` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `isactive` smallint(6) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` (`id`, `optname`, `optvalue`, `isactive`, `created_at`, `updated_at`) VALUES
(1, 'copyright', '2021', 1, '2021-01-19 23:56:52', '2021-02-02 02:13:36'),
(2, 'appname', 'eMemberKu', 1, '2021-01-20 18:41:09', '2021-01-20 19:53:39');

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

--
-- Table structure for table `transactions`
--

CREATE TABLE `transactions` (
  `idtrc` varchar(13) COLLATE utf8mb4_unicode_ci NOT NULL,
  `idbranch` varchar(6) COLLATE utf8mb4_unicode_ci NOT NULL,
  `datetrc` datetime NOT NULL,
  `idmember` varchar(13) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `idproduct` varchar(6) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `idacc` varchar(6) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dttype` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `trctype` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount` decimal(17,2) NOT NULL,
  `fee` decimal(17,2) DEFAULT NULL,
  `trcstatus` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `dateconfirm` datetime DEFAULT NULL,
  `note` varchar(13) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remark` text COLLATE utf8mb4_unicode_ci,
  `iduser` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `transactions`
--

INSERT INTO `transactions` (`idtrc`, `idbranch`, `datetrc`, `idmember`, `idproduct`, `idacc`, `dttype`, `trctype`, `amount`, `fee`, `trcstatus`, `dateconfirm`, `note`, `remark`, `iduser`, `created_at`, `updated_at`) VALUES
('TRC0200000001', 'BRC001', '2021-02-19 04:06:00', 'MBR2102000006', NULL, 'ACC001', 'DB', 'DEPOSIT', 100000.00, NULL, 'CONFIRM', '2021-02-19 04:06:48', NULL, 'Test', 'USR001', '2021-02-19 04:06:48', '2021-02-19 04:06:48');

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

--
-- Table structure for table `transactions_deleted`
--

CREATE TABLE `transactions_deleted` (
  `id` int(11) NOT NULL,
  `idtrc` varchar(13) COLLATE utf8mb4_unicode_ci NOT NULL,
  `idbranch` varchar(6) COLLATE utf8mb4_unicode_ci NOT NULL,
  `datetrc` datetime NOT NULL,
  `idmember` varchar(13) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `idproduct` varchar(6) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `idacc` varchar(6) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dttype` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `trctype` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `amount` decimal(17,2) DEFAULT NULL,
  `fee` decimal(17,2) DEFAULT NULL,
  `trcstatus` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dateconfirm` datetime DEFAULT NULL,
  `note` varchar(13) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remark` text COLLATE utf8mb4_unicode_ci,
  `iduser` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `users` (
  `iduser` varchar(6) COLLATE utf8mb4_unicode_ci NOT NULL,
  `idgroup` varchar(11) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `username` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `two_factor_secret` text COLLATE utf8mb4_unicode_ci,
  `two_factor_recovery_codes` text COLLATE utf8mb4_unicode_ci,
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `isactive` smallint(6) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `last_login_at` datetime DEFAULT NULL,
  `last_login_ip` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `users` (`iduser`, `idgroup`, `name`, `username`, `email`, `email_verified_at`, `password`, `two_factor_secret`, `two_factor_recovery_codes`, `remember_token`, `isactive`, `created_at`, `updated_at`, `last_login_at`, `last_login_ip`) VALUES
('USR001', 'GRP21020001', 'Joni I Wayan', 'iwyjoni', 'iwyjoni@gmail.com', NULL, '$2y$10$DEytBCLkhfKOhSwhDnXQY.QyEuPsXcBrZiQjZuAKCUDJf2SDVV/Ty', NULL, NULL, NULL, 1, '2021-01-15 12:12:43', '2021-02-02 02:22:10', '2021-02-19 04:02:00', '180.254.229.103'),
('USR002', 'GRP21020001', 'Demo', 'demo', 'demo@gmail.com', NULL, '$2y$10$JJp9FbLIiMMrPA0ADIB30OKhmX4ORhO4hlImSCiB7SpPTdPpbvr.S', NULL, NULL, NULL, 1, '2021-02-04 19:00:42', NULL, '2021-02-18 20:22:34', '180.249.116.115'),
('USR003', 'GRP21020002', 'Operator', 'operator', 'operator@demo.com', NULL, '$2y$10$xlwyXRVUDhE67eaTn1FGWejWqiM5pe9Ujr46AZ2GTcdrK1Y.GD6ve', NULL, NULL, NULL, 1, '2021-02-05 02:07:03', NULL, '2021-02-07 14:51:15', '36.85.188.254');

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

--
-- Table structure for table `versions`
--

CREATE TABLE `versions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `version` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `versions`
--

INSERT INTO `versions` (`id`, `title`, `description`, `version`, `created_at`, `updated_at`) VALUES
(1, 'eMemberKu', 'Member Releationship Management', '1.0', '2021-01-18 15:46:57', NULL),
(2, 'Add Features', '1. Add Popup Save Format Bank Account<br />\r\n2. Add Transfer Transaction<br />\r\n3. Add Summary Report<br />\r\n4. Fix Bugs Audit Report<br />\r\n5. Fix Bugs History Transaction Edit Member', '1.1', '2021-02-06 00:24:42', NULL),
(3, 'Add Features', '1. Add Fee At Transaction Form<br />\r\n2. Update History Transaction Page<br />\r\n3. Update Audit Page<br />\r\n4. Update Edit Member History Transaction', '1.2', '2021-02-06 22:43:58', NULL),
(4, 'Add Features', '1. Add User Activities', '1.3', '2021-02-19 04:05:18', NULL);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `accounts`
--
ALTER TABLE `accounts`
  ADD PRIMARY KEY (`idacc`);

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

--
-- Indexes for table `balances`
--
ALTER TABLE `balances`
  ADD PRIMARY KEY (`idblc`);

--
-- Indexes for table `banks`
--
ALTER TABLE `banks`
  ADD PRIMARY KEY (`idbank`);

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

--
-- Indexes for table `bonuses`
--
ALTER TABLE `bonuses`
  ADD PRIMARY KEY (`idbonus`);

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

--
-- Indexes for table `branches`
--
ALTER TABLE `branches`
  ADD PRIMARY KEY (`idbranch`);

--
-- Indexes for table `coins`
--
ALTER TABLE `coins`
  ADD PRIMARY KEY (`idcoin`);

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

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

--
-- Indexes for table `groups`
--
ALTER TABLE `groups`
  ADD PRIMARY KEY (`idgroup`);

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

--
-- Indexes for table `members`
--
ALTER TABLE `members`
  ADD PRIMARY KEY (`idmember`);

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

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

--
-- Indexes for table `password_resets`
--
ALTER TABLE `password_resets`
  ADD KEY `password_resets_email_index` (`email`);

--
-- Indexes for table `personal_access_tokens`
--
ALTER TABLE `personal_access_tokens`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
  ADD KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`);

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

--
-- Indexes for table `sessions`
--
ALTER TABLE `sessions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sessions_user_id_index` (`user_id`),
  ADD KEY `sessions_last_activity_index` (`last_activity`);

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

--
-- Indexes for table `transactions`
--
ALTER TABLE `transactions`
  ADD PRIMARY KEY (`idtrc`);

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

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`iduser`),
  ADD UNIQUE KEY `users_email_unique` (`email`);

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `activities`
--
ALTER TABLE `activities`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

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

--
-- AUTO_INCREMENT for table `bonus_types`
--
ALTER TABLE `bonus_types`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `details`
--
ALTER TABLE `details`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=51;

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

--
-- AUTO_INCREMENT for table `logins`
--
ALTER TABLE `logins`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=89;

--
-- AUTO_INCREMENT for table `menus`
--
ALTER TABLE `menus`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31;

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

--
-- AUTO_INCREMENT for table `personal_access_tokens`
--
ALTER TABLE `personal_access_tokens`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `settings`
--
ALTER TABLE `settings`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

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

--
-- AUTO_INCREMENT for table `versions`
--
ALTER TABLE `versions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
COMMIT;

/*!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 */;
