-- 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
\r\n2. Add Transfer Transaction
\r\n3. Add Summary Report
\r\n4. Fix Bugs Audit Report
\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
\r\n2. Update History Transaction Page
\r\n3. Update Audit Page
\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 */;