/*
SQLyog Ultimate v12.4.3 (64 bit)
MySQL - 10.1.31-MariaDB : Database - pdam_web
*********************************************************************
*/



/*Table structure for table `users` */


CREATE TABLE `users` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `username` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `full_name` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone_number` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `photo` varchar(1000) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `built_in` tinyint(1) NOT NULL DEFAULT '0',
  `firebase_token` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `nip` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `latitude` double(10,7) DEFAULT NULL,
  `longitude` double(10,7) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_username_unique` (`username`),
  UNIQUE KEY `users_email_unique` (`email`),
  UNIQUE KEY `users_phone_number_unique` (`phone_number`)
) ENGINE=InnoDB AUTO_INCREMENT=129 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `users` */

insert  into `users`(`id`,`username`,`full_name`,`email`,`address`,`phone_number`,`password`,`photo`,`active`,`built_in`,`firebase_token`,`remember_token`,`created_at`,`updated_at`,`nip`,`latitude`,`longitude`) values 
(1,'admin','Administrator','admin@artcak.com',NULL,'0817777','$2y$10$QYfIq929cWPtBQed1Y9lsOZxVtQmB3I8uw2jIcYPX7QgL0hYCSQWO',NULL,1,1,NULL,NULL,'2018-06-06 10:24:38','2018-06-06 10:24:38',NULL,NULL,NULL),
(2,'ownser','Owner','owner@artcak.com',NULL,'0818888','$2y$10$mG/PA7w6R1Ipd0ug0cQM1OcgzYLaHsUCIEuHCZumEFCS5I.vWHyPC',NULL,1,0,NULL,NULL,'2018-06-06 10:24:39','2018-06-06 10:24:39',NULL,NULL,NULL),
(3,'contributor1','Contributor 1','contributor1@artcak.com',NULL,'0815555','$2y$10$XAwR3jgFL0.swWgGqjjAqO.P9fD9gl6uaV/kbitDnhfXihFOg56g.',NULL,1,0,NULL,NULL,'2018-06-06 10:24:39','2018-06-06 10:24:39',NULL,NULL,NULL),
(4,'user','user','user@artcak.com',NULL,'0816666','$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO',NULL,1,0,NULL,NULL,'2018-06-07 03:50:46','2018-06-07 03:50:47',NULL,NULL,NULL),
(5,'surveyor','surveyor','surveyor@artcak.com',NULL,'0819999','$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO',NULL,1,0,NULL,NULL,'2018-06-07 03:50:46','2018-06-07 03:50:47',NULL,NULL,NULL),
(6,'','','',NULL,NULL,'',NULL,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(89,'201','Mellany Junono                ','surveyor201@pdam.go.id',NULL,'0811201','$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO',NULL,0,1,NULL,NULL,'2018-07-04 07:46:59','2018-07-04 07:46:59',NULL,NULL,NULL),
(90,'203','S u k a m t o                 ','surveyor203@pdam.go.id',NULL,'0811203','$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO',NULL,0,1,NULL,NULL,'2018-07-04 07:47:00','2018-07-04 07:47:00',NULL,NULL,NULL),
(91,'207','S y a m s u r i               ','surveyor207@pdam.go.id',NULL,'0811207','$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO',NULL,0,1,NULL,NULL,'2018-07-04 07:47:00','2018-07-04 07:47:00',NULL,NULL,NULL),
(92,'208','U s n a d i                   ','surveyor208@pdam.go.id',NULL,'0811208','$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO',NULL,0,1,NULL,NULL,'2018-07-04 07:47:00','2018-07-04 07:47:00',NULL,NULL,NULL),
(93,'209','Oni Sahroni                   ','surveyor209@pdam.go.id',NULL,'0811209','$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO',NULL,0,1,NULL,NULL,'2018-07-04 07:47:01','2018-07-04 07:47:01',NULL,NULL,NULL),
(94,'210','Khamim Sulton H.              ','surveyor210@pdam.go.id',NULL,'0811210','$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO',NULL,0,1,NULL,NULL,'2018-07-04 07:47:01','2018-07-04 07:47:01',NULL,NULL,NULL),
(95,'211','M. Irfan Fahlefi              ','surveyor211@pdam.go.id',NULL,'0811211','$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO',NULL,0,1,NULL,NULL,'2018-07-04 07:47:02','2018-07-04 07:47:02',NULL,NULL,NULL),
(96,'213','Sumilan BE                    ','surveyor213@pdam.go.id',NULL,'0811213','$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO',NULL,0,1,NULL,NULL,'2018-07-04 07:47:02','2018-07-04 07:47:02',NULL,NULL,NULL),
(97,'214','Edy Priyono                   ','surveyor214@pdam.go.id',NULL,'0811214','$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO',NULL,0,1,NULL,NULL,'2018-07-04 07:47:02','2018-07-04 07:47:02',NULL,NULL,NULL),
(98,'215','Moch. Farchan                 ','surveyor215@pdam.go.id',NULL,'0811215','$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO',NULL,0,1,NULL,NULL,'2018-07-04 07:47:02','2018-07-04 07:47:02',NULL,NULL,NULL),
(99,'218','S u g i a n t o               ','surveyor218@pdam.go.id',NULL,'0811218','$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO',NULL,0,1,NULL,NULL,'2018-07-04 07:47:03','2018-07-04 07:47:03',NULL,NULL,NULL),
(100,'220','Budi Waluyo                   ','surveyor220@pdam.go.id',NULL,'0811220','$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO',NULL,0,1,NULL,NULL,'2018-07-04 07:47:03','2018-07-04 07:47:03',NULL,NULL,NULL),
(101,'221','S u s a n t o  BA.E.          ','surveyor221@pdam.go.id',NULL,'0811221','$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO',NULL,0,1,NULL,NULL,'2018-07-04 07:47:04','2018-07-04 07:47:04',NULL,NULL,NULL),
(102,'222','Rachmad Bahagia               ','surveyor222@pdam.go.id',NULL,'0811222','$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO',NULL,0,1,NULL,NULL,'2018-07-04 07:47:04','2018-07-04 07:47:04',NULL,NULL,NULL),
(103,'223','Trisna Hadi                   ','surveyor223@pdam.go.id',NULL,'0811223','$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO',NULL,0,1,NULL,NULL,'2018-07-04 07:47:04','2018-07-04 07:47:04',NULL,NULL,NULL),
(104,'224','K a r m u d j i               ','surveyor224@pdam.go.id',NULL,'0811224','$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO',NULL,0,1,NULL,NULL,'2018-07-04 07:47:05','2018-07-04 07:47:05',NULL,NULL,NULL),
(105,'228','Imansyah N.                   ','surveyor228@pdam.go.id',NULL,'0811228','$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO',NULL,0,1,NULL,NULL,'2018-07-04 07:47:05','2018-07-04 07:47:05',NULL,NULL,NULL),
(106,'229','S u d i o n o                 ','surveyor229@pdam.go.id',NULL,'0811229','$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO',NULL,0,1,NULL,NULL,'2018-07-04 07:47:05','2018-07-04 07:47:05',NULL,NULL,NULL),
(107,'230','Andi Eko Purwono              ','surveyor230@pdam.go.id',NULL,'0811230','$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO',NULL,0,1,NULL,NULL,'2018-07-04 07:47:06','2018-07-04 07:47:06',NULL,NULL,NULL),
(108,'231','Agus Martono                  ','surveyor231@pdam.go.id',NULL,'0811231','$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO',NULL,0,1,NULL,NULL,'2018-07-04 07:47:06','2018-07-04 07:47:06',NULL,NULL,NULL),
(109,'232','Teguh Susijono                ','surveyor232@pdam.go.id',NULL,'0811232','$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO',NULL,0,1,NULL,NULL,'2018-07-04 07:47:06','2018-07-04 07:47:06',NULL,NULL,NULL),
(110,'233','Irwan Hermana U.              ','surveyor233@pdam.go.id',NULL,'0811233','$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO',NULL,0,1,NULL,NULL,'2018-07-04 07:47:07','2018-07-04 07:47:07',NULL,NULL,NULL),
(111,'234','Forneo  H.S.                  ','surveyor234@pdam.go.id',NULL,'0811234','$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO',NULL,0,1,NULL,NULL,'2018-07-04 07:47:07','2018-07-04 07:47:07',NULL,NULL,NULL),
(112,'235','Zupri                         ','surveyor235@pdam.go.id',NULL,'0811235','$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO',NULL,0,1,NULL,NULL,'2018-07-04 07:47:07','2018-07-04 07:47:07',NULL,NULL,NULL),
(113,'236','Bambang Tri W.                ','surveyor236@pdam.go.id',NULL,'0811236','$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO',NULL,0,1,NULL,NULL,'2018-07-04 07:47:08','2018-07-04 07:47:08',NULL,NULL,NULL),
(114,'237','Eko Saputra                   ','surveyor237@pdam.go.id',NULL,'0811237','$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO',NULL,0,1,NULL,NULL,'2018-07-04 07:47:08','2018-07-04 07:47:08',NULL,NULL,NULL),
(115,'238','Irawan Sudarsono              ','surveyor238@pdam.go.id',NULL,'0811238','$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO',NULL,0,1,NULL,NULL,'2018-07-04 07:47:09','2018-07-04 07:47:09',NULL,NULL,NULL),
(116,'239','Kuswara                       ','surveyor239@pdam.go.id',NULL,'0811239','$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO',NULL,0,1,NULL,NULL,'2018-07-04 07:47:09','2018-07-04 07:47:09',NULL,NULL,NULL),
(117,'240','Teguh Wiyono                  ','surveyor240@pdam.go.id',NULL,'0811240','$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO',NULL,0,1,NULL,NULL,'2018-07-04 07:47:10','2018-07-04 07:47:10',NULL,NULL,NULL),
(118,'241','M. ABDUS SOMAD MUSLIM, AMD    ','surveyor241@pdam.go.id',NULL,'0811241','$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO',NULL,0,1,NULL,NULL,'2018-07-04 07:47:10','2018-07-04 07:47:10',NULL,NULL,NULL),
(119,'242','AGUS HARYADI                  ','surveyor242@pdam.go.id',NULL,'0811242','$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO',NULL,0,1,NULL,NULL,'2018-07-04 07:47:11','2018-07-04 07:47:11',NULL,NULL,NULL),
(120,'243','Joko Indah Permadi            ','surveyor243@pdam.go.id',NULL,'0811243','$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO',NULL,0,1,NULL,NULL,'2018-07-04 07:47:11','2018-07-04 07:47:11',NULL,NULL,NULL),
(121,'244','Deny Eka Pratama              ','surveyor244@pdam.go.id',NULL,'0811244','$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO',NULL,0,1,NULL,NULL,'2018-07-04 07:47:11','2018-07-04 07:47:11',NULL,NULL,NULL),
(122,'245','Angga Christian Hananta       ','surveyor245@pdam.go.id',NULL,'0811245','$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO',NULL,0,1,NULL,NULL,'2018-07-04 07:47:12','2018-07-04 07:47:12',NULL,NULL,NULL),
(123,'246','Deni Kurniawati               ','surveyor246@pdam.go.id',NULL,'0811246','$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO',NULL,0,1,NULL,NULL,'2018-07-04 07:47:12','2018-07-04 07:47:12',NULL,NULL,NULL),
(124,'247','Surios Ramisda                ','surveyor247@pdam.go.id',NULL,'0811247','$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO',NULL,0,1,NULL,NULL,'2018-07-04 07:47:12','2018-07-04 07:47:12',NULL,NULL,NULL),
(125,'248','Danny Erwanto                 ','surveyor248@pdam.go.id',NULL,'0811248','$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO',NULL,0,1,NULL,NULL,'2018-07-04 07:47:12','2018-07-04 07:47:12',NULL,NULL,NULL),
(126,'249','Nur Cholis Ikhsan             ','surveyor249@pdam.go.id',NULL,'0811249','$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO',NULL,0,1,NULL,NULL,'2018-07-04 07:47:13','2018-07-04 07:47:13',NULL,NULL,NULL),
(127,'250','Ahmad Rais Setyo Laksono      ','surveyor250@pdam.go.id',NULL,'0811250','$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO',NULL,0,1,NULL,NULL,'2018-07-04 07:47:13','2018-07-04 07:47:13',NULL,NULL,NULL),
(128,'251','Achmad Hardianas              ','surveyor251@pdam.go.id',NULL,'0811251','$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO',NULL,0,1,NULL,NULL,'2018-07-04 07:47:13','2018-07-04 07:47:13',NULL,NULL,NULL);

