/*
SQLyog Job Agent v12.4.3 (64 bit) Copyright(c) Webyog Inc. All Rights Reserved.


MySQL - 10.1.21-MariaDB : Database - ktmcore
*********************************************************************
*/

/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`ktmcore` /*!40100 DEFAULT CHARACTER SET latin1 */;

USE `ktmcore`;

/*Table structure for table `tele_channel_user` */

DROP TABLE IF EXISTS `tele_channel_user`;

CREATE TABLE `tele_channel_user` (
  `id` char(20) NOT NULL,
  `first_name` varchar(100) DEFAULT NULL,
  `user` varchar(100) DEFAULT NULL,
  `phone` varchar(100) DEFAULT NULL,
  `is_bot` varchar(100) DEFAULT NULL,
  `updateCreated` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `tele_channel_user` */

insert  into `tele_channel_user` values 
('1000037376','Muhammad Haidir','','','false','2020-04-27 23:25:57'),
('1002221158','Edy Fachrin','','6281251049495','false','2020-04-27 23:17:09'),
('1005434782','mohammad noor','','6281346208464','false','2020-04-27 23:22:31'),
('1006447245','Putri','PutriNina','','false','2020-04-27 23:23:50'),
('1007847502','Citra','','628119519251','false','2020-04-27 23:28:28'),
('1014938707','Dhany','','6285250658865','false','2020-04-27 23:15:42'),
('1016824825','Puryadi','','','false','2020-04-27 23:23:51'),
('1026083993','Yuniza','','','false','2020-04-27 23:29:42'),
('1051348562','Dina Octavia','','6281281848382','false','2020-04-27 23:23:14'),
('1056268099','Doddy','','628125519348','false','2020-04-27 23:21:45'),
('106198693','Fitri','fitri_dewi','6285350011234','false','2020-04-27 23:17:15'),
('1077490503','Sukmo Legowo','','6285250552077','false','2020-04-27 23:25:55'),
('1079379963','Olin','','','false','2020-04-27 23:23:14'),
('1093366794','Marcellina','','','false','2020-04-27 23:21:45'),
('1104558187','Asnari Abdullah','','','false','2020-04-27 23:13:30'),
('1108520349','Rasman','','','false','2020-04-27 23:25:53'),
('1136039469','Saleh EB','','6281256594575','false','2020-04-27 23:25:54'),
('1141503963','julia','','','false','2020-04-27 23:19:47'),
('1182110282','Dyta','','','false','2020-04-27 23:22:30'),
('1205006215','Aji Nisfi','','6285236221640','false','2020-04-27 23:22:30'),
('1238815383','Lendri','','','false','2020-04-27 23:21:03'),
('1273054773','Ferry Adriannur','','6281254583342','false','2020-04-27 23:13:32'),
('151244207','AndoyDech','','628115833906','false','2020-04-27 23:13:43'),
('159397187','Ismail','ismail_marjuki','62811587716','false','2020-04-27 23:21:43'),
('185246374','Eka','ekacahyarizki','6281217217970','false','2020-04-27 23:25:19'),
('197445668','Oneng','','6285250644982','false','2020-04-27 23:30:20'),
('200312274','Madi','','628115839991','false','2020-04-27 23:21:44'),
('211896721','mirza','mirzanorma','','false','2020-04-27 23:21:45'),
('213609964','Ikhwan','Ikhwanktm','6281253954427','false','2020-04-27 23:19:12'),
('216056206','Ade Prima','Ko_Dede','628115591086','false','2020-04-27 23:20:29'),
('217277606','hendri.arba','hendriarba','6281346663663','false','2020-04-27 23:30:21'),
('218016852','Ina','inanurjannah','6281350828848','false','2020-04-27 23:22:35'),
('220424377','Roy Rahmat Dianur','','628115500752','false','2020-04-27 23:25:19'),
('221284218','Irma Adm kredit','Irma_h','628115823739','false','2020-04-27 23:19:10'),
('221496355','Dini Sid','Dhiwul','6281351505551','false','2020-04-27 23:28:32'),
('229939810','Doni','donz04','6281230030041','false','2020-04-27 23:25:58'),
('235003666','Ayip','','628115827328','false','2020-04-27 23:22:40'),
('240044026','IFTTT','IFTTT','','true','2020-04-27 23:19:13'),
('242426760','Maulana Kcu','maulana3','6281258001180','false','2020-04-27 23:25:12'),
('255792050','Aga','','','false','2020-04-27 23:17:51'),
('264429371','Aulia','Auliafachreza','','false','2020-04-27 23:19:08'),
('266479797','Almira','almirayumna','','false','2020-04-27 23:29:41'),
('266842016','Zelina','','','false','2020-04-27 23:30:20'),
('268219147','Amat','amat_lombok78','6285393184152','false','2020-04-27 23:21:52'),
('270013935','roody','roody20','62811551718','false','2020-04-27 23:25:15'),
('274415646','Putri','','','false','2020-04-27 23:23:52'),
('275648535','Anggi Prospek','','6282179961112','false','2020-04-27 23:26:08'),
('278134790','Donni Kas','donnido','628125547791','false','2020-04-27 23:15:50'),
('279939350','Rizka','Rizkarf','','false','2020-04-27 23:25:08'),
('281822365','Ervana Suhani','hunny_UUN','6285247884646','false','2020-04-27 23:27:18'),
('292236732','Aya','Aya1711','','false','2020-04-27 23:13:44'),
('302210132','@wennicdr','wennicdr','','false','2020-04-27 23:28:32'),
('303570141','Niiaarr','','','false','2020-04-27 23:22:32'),
('306743306','fatih','fatihizza','','false','2020-04-27 23:17:14'),
('306917847','verawati','','6281250155565','false','2020-04-27 23:27:53'),
('312297410','Yusuf','','6281245923015','false','2020-04-27 23:29:41'),
('314801798','Randi Fitra 2','','6281347186812','false','2020-04-27 23:25:16'),
('317781532','Buddy','armine18','','false','2020-04-27 23:14:27'),
('322679315','Tika','','','false','2020-04-27 23:26:44'),
('333235305','Irwan','Irwansetiawann','6285391256357','false','2020-04-27 23:28:31'),
('333654388','Trio','trioas','','false','2020-04-27 23:26:42'),
('341186406','Riky','','','false','2020-04-27 23:25:18'),
('349749967','M S','shak4dani','','false','2020-04-27 23:26:06'),
('357718174','Ari Fitriani','','6281251168585','false','2020-04-27 23:17:16'),
('358825689','Bpd Yuliana Pimkas','Yuli4n4','6281347606790','false','2020-04-27 23:29:45'),
('360315063','Joan','','','false','2020-04-27 23:19:48'),
('362388464','Zulmi','','6285250983332','false','2020-04-27 23:30:20'),
('363483832','AndRe','AndReYazz','','false','2020-04-27 23:29:46'),
('367610379','Jaya','','','false','2020-04-27 23:19:48'),
('368037251','Surya','','6281347313000','false','2020-04-27 23:26:07'),
('370728391','Cania','','','false','2020-04-27 23:15:06'),
('374031628','Nanang Helmi','nananghelmi','6281347587499','false','2020-04-27 23:22:39'),
('385184295','Ichwan','ichwannoorvin','','false','2020-04-27 23:22:33'),
('385485546','Santi Kas','','6285246977878','false','2020-04-27 23:22:38'),
('386001276','Suhaimi','','','false','2020-04-27 23:26:06'),
('386132056','Agung Umum','','6281253788121','false','2020-04-27 23:22:36'),
('387666101','Eni','','6281253333087','false','2020-04-27 23:25:13'),
('388614974','Budi Setiyo','Setiyobudiasmoro','6285247223606','false','2020-04-27 23:26:06'),
('395367596','Ayu','ayudea','6282242420654','false','2020-04-27 23:15:42'),
('398658823','Anti','','6281350722905','false','2020-04-27 23:13:52'),
('401554489','Mey','','','false','2020-04-27 23:26:03'),
('402028929','Farid Hazmi','','628115556688','false','2020-04-27 23:18:32'),
('402527265','Winda','','','false','2020-04-27 23:28:32'),
('403456320','Hesti','','628125474473','false','2020-04-27 23:18:31'),
('405278156','Pemimpin Bidang Operasional','kcu_pimbid_operasional','','false','2020-04-27 23:23:52'),
('405979667','Karina','','','false','2020-04-27 23:26:00'),
('406360943','Fara','','6285393338887','false','2020-04-27 23:26:01'),
('409204260','Dewi','Dewwijaya','','false','2020-04-27 23:28:31'),
('410570682','Ryanta','','6282255140777','false','2020-04-27 23:26:07'),
('411155392','kcubot','kcubot','','true','2020-04-27 23:20:29'),
('411585375','Dessy','','','false','2020-04-27 23:15:47'),
('411761763','Henny Sarihastuti','','628125367022','false','2020-04-27 23:26:07'),
('414586618','Mahfud','','62811591181','false','2020-04-27 23:27:19'),
('414784697','Gadis','','','false','2020-04-27 23:23:59'),
('415124103','Ay','','','false','2020-04-27 23:13:46'),
('418490106','Bashir Alhamdhani','','6285246266677','false','2020-04-27 23:14:31'),
('423465673','GIlang','','','false','2020-04-27 23:28:29'),
('426375916','Ery Pratama','','6285250740007','false','2020-04-27 23:24:01'),
('429317618','Febby','','','false','2020-04-27 23:17:08'),
('436318406','Windira','anindyawindira','','false','2020-04-27 23:28:33'),
('437253863','Mirna','','','false','2020-04-27 23:21:54'),
('438637207','Pujiarti','Pujiarti','','false','2020-04-27 23:23:59'),
('439067134','Hadi Eb','','6281347417303','false','2020-04-27 23:26:08'),
('439202057','Avira Ratna','','','false','2020-04-27 23:25:17'),
('439638359','+6281254874132','','6281254874132','false','2020-04-27 23:19:11'),
('441707436','Andy\'s','','','false','2020-04-27 23:26:05'),
('442980116','Lina','','628125520628','false','2020-04-27 23:26:05'),
('443151855','Regina','','','false','2020-04-27 23:25:10'),
('443899085','Farid Ikhsan','','628125838929','false','2020-04-27 23:19:11'),
('444875687','Nurul','','62811580411','false','2020-04-27 23:22:39'),
('447641597','Marfuah','','6281349559695','false','2020-04-27 23:21:55'),
('448409145','Agnes','','','false','2020-04-27 23:15:49'),
('449914174','Desy Nurfatul','','6285250907535','false','2020-04-27 23:22:40'),
('450521640','ade','adewindy','','false','2020-04-27 23:28:27'),
('452329977','Laurensia','','','false','2020-04-27 23:21:08'),
('454747409','Dian','','','false','2020-04-27 23:19:12'),
('456581652','kcu','kcu_pimbid_layanan','6282198935082','false','2020-04-27 23:24:00'),
('460704524','Fauziah','Fauziah_lahjie','6281348608344','false','2020-04-27 23:21:05'),
('460822141','Dewi','','','false','2020-04-27 23:23:57'),
('464674052','Fina Chandralita','','6281254994959','false','2020-04-27 23:17:16'),
('468768340','Pemimpin Bidang Perkreditan','kcu_pimbid_perkreditan','','false','2020-04-27 23:23:56'),
('470543880','Sahala','Batak_Edan','6281258398686','false','2020-04-27 23:30:21'),
('479662330','Herliyani','','628115815131','false','2020-04-27 23:29:43'),
('480351364','Gina','','','false','2020-04-27 23:18:31'),
('482246600','Helga','HelgaBrigita','6285388751881','false','2020-04-27 23:19:49'),
('491409303','Jannah','','','false','2020-04-27 23:19:48'),
('491498886','A','','','false','2020-04-27 23:25:16'),
('500154443','Bpd Ervita','','6281345088037','false','2020-04-27 23:29:45'),
('502710142','Ayu Usd','nimadeayusd','6282157093394','false','2020-04-27 23:26:06'),
('514081805','Ben','Benny_hmdni','','false','2020-04-27 23:18:29'),
('514901862','Hasmiwaty','Hasmiwaty','628125352430','false','2020-04-27 23:18:30'),
('517057469','Albin','Albindesmahendra','','false','2020-04-27 23:15:52'),
('524144437','Siti','','6282126333370','false','2020-04-27 23:26:04'),
('524424876','Ratna Eli','','6282157575522','false','2020-04-27 23:28:30'),
('524439965','Wahyudi Ichsan','','6282254320853','false','2020-04-27 23:28:33'),
('529663190','Maya','','','false','2020-04-27 23:23:17'),
('531898039','Marsha Juli','','6285250149779','false','2020-04-27 23:21:55'),
('532258357','Elma Feby','elmhafebby','6285350034222','false','2020-04-27 23:25:15'),
('536631133','Ayu Dea 2','','6285250421110','false','2020-04-27 23:15:48'),
('539544760','Feni','','','false','2020-04-27 23:23:57'),
('542779634','Puspa','pusparamadaniati','','false','2020-04-27 23:25:17'),
('543699257','Riza','RLarasati18','','false','2020-04-27 23:25:14'),
('548561620','YOLANDHA','','6281253954856','false','2020-04-27 23:29:46'),
('549316724','Esther Parak','','628125530835','false','2020-04-27 23:23:52'),
('549419894','Putri','','','false','2020-04-27 23:24:00'),
('550707478','Hafid','','6285248371957','false','2020-04-27 23:18:33'),
('552072698','Lusi','','6282156662490','false','2020-04-27 23:21:09'),
('555034556','Friska','','','false','2020-04-27 23:17:15'),
('556449161','Aisea Camara','','','false','2020-04-27 23:23:16'),
('560537095','kcubot2','kcu2bot','','true','2020-04-27 23:20:29'),
('566549732','Rosi','ocirf','','false','2020-04-27 23:25:18'),
('568421105','Anggi Okta','','6282231000058','false','2020-04-27 23:23:16'),
('568810356','Dhiyah Puji','Dhipujilestari','','false','2020-04-27 23:24:00'),
('569166083','Eka','Ekadwansa','','false','2020-04-27 23:16:29'),
('581318170','edsir','','6282250776663','false','2020-04-27 23:26:03'),
('582447286','Suhaendi','','','false','2020-04-27 23:26:05'),
('585679498','Noni','','6282158018119','false','2020-04-27 23:22:39'),
('593876834','Muzammil','','','false','2020-04-27 23:21:51'),
('594029173','Mariani Tanjung','','62811581690','false','2020-04-27 23:26:44'),
('595113039','Syafii Kas','','6282168030888','false','2020-04-27 23:26:08'),
('596508481','Rizki','rizkislv','','false','2020-04-27 23:26:04'),
('596978756','Wawan Eko','','6281346844469','false','2020-04-27 23:28:31'),
('597014309','Nova','','628115577882','false','2020-04-27 23:22:31'),
('608016350','NOVIA','FITRIADY','628125885284','false','2020-04-27 23:22:36'),
('608985386','RiFANi','','6281235673777','false','2020-04-27 23:25:14'),
('610049078','Anita Rizqia Utami','anitarizqiautami','','false','2020-04-27 23:27:18'),
('620292961','Rinaldi','','628985923986','false','2020-04-27 23:25:14'),
('623148276','Hairiah','','6282132326716','false','2020-04-27 23:19:11'),
('623688727','bank fitri','','6282311191113','false','2020-04-27 23:17:14'),
('625861075','Ita Mufarita','Mufarita','6285233120002','false','2020-04-27 23:21:49'),
('627901120','Yandi','','628125504263','false','2020-04-27 23:29:44'),
('632850557','Gigir','gigiralamsyah','','false','2020-04-27 23:17:50'),
('634482760','Endra','','6287878863353','false','2020-04-27 23:16:32'),
('636403735','Silvia','','','false','2020-04-27 23:26:03'),
('642110352','Kharisma Aulia','','','false','2020-04-27 23:20:25'),
('642941237','Yunita','','','false','2020-04-27 23:29:42'),
('647462469','Mufida','','','false','2020-04-27 23:21:44'),
('650038281','Aish','aishyrd','','false','2020-04-27 23:13:39'),
('653424271','Budi','','','false','2020-04-27 23:14:29'),
('655439784','Desi Lembus','','6285250000256','false','2020-04-27 23:23:58'),
('666424725','hijrah','Mayang2595','','false','2020-04-27 23:21:53'),
('670738688','Noor Bogel','','6282158517000','false','2020-04-27 23:22:35'),
('676880460','weni','','','false','2020-04-27 23:28:27'),
('679407287','Made','','6285246943300','false','2020-04-27 23:21:50'),
('680941372','Bpd Dyah Heru','','6282157368004','false','2020-04-27 23:18:26'),
('682112631','Lucky','','','false','2020-04-27 23:21:47'),
('684947374','Randy Umum','','6282397700087','false','2020-04-27 23:25:11'),
('687084857','darasch_','','','false','2020-04-27 23:15:47'),
('689299936','Fenny','fennyprmslla','','false','2020-04-27 23:23:54'),
('691707561','ricca','riccadjadide','','false','2020-04-27 23:25:17'),
('693987276','Egie','','62811550361','false','2020-04-27 23:23:51'),
('699201450','Annisa Nur','Nisaprlia','','false','2020-04-27 23:22:37'),
('699717852','Lisa Sdm','','6282253120077','false','2020-04-27 23:25:11'),
('701284048','Veronica','','','false','2020-04-27 23:27:53'),
('704561710','Mega','','','false','2020-04-27 23:28:30'),
('704982953','Mona','','','false','2020-04-27 23:21:50'),
('706663657','Ocy','','6282351876789','false','2020-04-27 23:25:13'),
('708323310','Mihda','Yanthie109','','false','2020-04-27 23:29:45'),
('70880491','Dita','','','false','2020-04-27 23:25:13'),
('714715718','Windy Tri Hapsari','','','false','2020-04-27 23:28:30'),
('716338458','Sari','','','false','2020-04-27 23:25:57'),
('717395558','Angky D Tafiano','','','false','2020-04-27 23:26:44'),
('717609793','Dede','','6282153212212','false','2020-04-27 23:21:51'),
('719311366','Dayang','','','false','2020-04-27 23:25:59'),
('728730594','Cika','','6285351515286','false','2020-04-27 23:20:24'),
('733210501','Tika','','628152012332','false','2020-04-27 23:26:42'),
('733567577','Rinda Ayu Aryani','','','false','2020-04-27 23:25:10'),
('741865024','Cleofegulanes','','6281253007272','false','2020-04-27 23:23:16'),
('742649640','Sayid Hasan','','628115989680','false','2020-04-27 23:25:54'),
('743746025','Dina','','','false','2020-04-27 23:15:45'),
('744051501','Bakti','baktiptr','','false','2020-04-27 23:23:53'),
('744069480','Prisca','','','false','2020-04-27 23:26:02'),
('744771851','Isti','','','false','2020-04-27 23:19:07'),
('746521388','Sari','abbiyani','','false','2020-04-27 23:26:02'),
('748263324','Elisa','Elisaanggraini','','false','2020-04-27 23:16:30'),
('750090854','Dyene','','628115800719','false','2020-04-27 23:23:58'),
('754970036','Bonetoo','','','false','2020-04-27 23:14:26'),
('759145868','Lita Afriani','','','false','2020-04-27 23:21:07'),
('760676229','Lala Naila','','6285250737517','false','2020-04-27 23:25:09'),
('766463271','Darma','','','false','2020-04-27 23:26:43'),
('769341198','Bahtiar','','6285352144444','false','2020-04-27 23:14:28'),
('772972123','Pramudya Redha','','','false','2020-04-27 23:25:07'),
('776416803','Cleove','','6285252523644','false','2020-04-27 23:26:04'),
('781236285','Ryan','marbuzzi','','false','2020-04-27 23:25:16'),
('783119717','Dims','dimschrisna','','false','2020-04-27 23:15:49'),
('787600495','Lita Juniati','','6285246191754','false','2020-04-27 23:21:08'),
('795590679','Yulie','','','false','2020-04-27 23:29:43'),
('797123556','Haswinda','','','false','2020-04-27 23:28:27'),
('800897266','HolikMN','','','false','2020-04-27 23:18:29'),
('801946585','Norhayati.Is','','','false','2020-04-27 23:22:31'),
('806454095','Nelfianti','','','false','2020-04-27 23:22:32'),
('809600850','Nisir','','','false','2020-04-27 23:22:33'),
('810850504','Enod Aulia Yanuar','','6285390304753','false','2020-04-27 23:29:44'),
('812584951','Nur','nursaidah08','','false','2020-04-27 23:26:00'),
('816865217','Prasetyo','','','false','2020-04-27 23:23:55'),
('825733014','Irvan','','628125391454','false','2020-04-27 23:21:48'),
('830478263','Ika','','','false','2020-04-27 23:21:47'),
('834302480','Reksy','','','false','2020-04-27 23:25:58'),
('837811485','Dea Wiratama Putra','','','false','2020-04-27 23:28:29'),
('843144396','Satya','','','false','2020-04-27 23:25:55'),
('846821964','Febry','','','false','2020-04-27 23:25:09'),
('856466298','Megawan Surya','megawansurya','','false','2020-04-27 23:26:01'),
('858126938','Laily','','','false','2020-04-27 23:29:44'),
('879322755','Yunita','','','false','2020-04-27 23:29:42'),
('884858662','Mia','','','false','2020-04-27 23:21:47'),
('887643164','Riskaa','','','false','2020-04-27 23:25:07'),
('905933374','Dilla','dillaayusha','','false','2020-04-27 23:15:46'),
('911206971','Lina','','','false','2020-04-27 23:25:54'),
('912034135','Agung','','','false','2020-04-27 23:18:26'),
('913589264','Dita','DitaTrisnaa','','false','2020-04-27 23:26:42'),
('914334506','BPD Fila Anggana','filaoktavia','6282221266660','false','2020-04-27 23:17:09'),
('914930310','faujiah','','6285250600330','false','2020-04-27 23:22:30'),
('925766274','Denny','','','false','2020-04-27 23:28:29'),
('929829383','febrian sara','','','false','2020-04-27 23:25:56'),
('936144470','Tab Pimpinan Cabang Bos','','628115571678','false','2020-04-27 23:26:01'),
('936360027','zul','','','false','2020-04-27 23:30:19'),
('936452575','Fajri','','6285347779996','false','2020-04-27 23:17:50'),
('937112052','Sukarna','','6282157713222','false','2020-04-27 23:25:59'),
('937598249','Naomi','Naomi_Febriana','','false','2020-04-27 23:22:34'),
('938176981','Sri','','','false','2020-04-27 23:28:28'),
('939760216','Andhika','','6281250804535','false','2020-04-27 23:25:08'),
('951321295','Syelly','','','false','2020-04-27 23:28:28'),
('951410539','Nurul','','6285270371551','false','2020-04-27 23:22:34'),
('961619578','Hany','','','false','2020-04-27 23:21:46'),
('968970432','Dewi','Dwsrswsti','','false','2020-04-27 23:26:00'),
('970178198','Raini','','6281254355979','false','2020-04-27 23:25:08'),
('972272305','Nuzul','nuzulfirjan','','false','2020-04-27 23:22:33'),
('975493140','Sukma','','','false','2020-04-27 23:25:56'),
('977360015','Nida','','','false','2020-04-27 23:27:18'),
('980921405','Razid','razidrkp','6285392241007','false','2020-04-27 23:25:10'),
('984729120','Alya','','','false','2020-04-27 23:13:36'),
('989264787','Ika','','','false','2020-04-27 23:29:43'),
('997219358','Milda','MildaFaisal','628115816689','false','2020-04-27 23:23:53');

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;