text: -- MySQL dump 10.13  Distrib 5.7.12, for Win64 (x86_64)
  --
  -- Host: 127.0.0.1    Database: camara
  -- ------------------------------------------------------
  -- Server version	5.5.5-10.1.19-MariaDB
  
  /*!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 utf8 */;
  /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
  /*!40103 SET TIME_ZONE='+00:00' */;
  /*!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 */;
  
  --
  -- Table structure for table `tenkependik`
  --
  
  DROP TABLE IF EXISTS `tenkependik`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `tenkependik` (
    `id_tenkependik` int(10) NOT NULL AUTO_INCREMENT,
    `npsn` int(10) NOT NULL,
    `tahun_ajaran` varchar(9) NOT NULL,
    `nbm` varchar(15) NOT NULL,
    `jabatan` varchar(20) NOT NULL,
    `nama` varchar(30) NOT NULL,
    `nip` varchar(20) NOT NULL,
    `tempat_lhr` varchar(20) NOT NULL,
    `tgl_lhr` date NOT NULL,
    `telepon` varchar(30) NOT NULL,
    `email` varchar(50) NOT NULL,
    `pangkat` varchar(25) NOT NULL,
    `tgl_pengangkatan` date NOT NULL,
    `jk` varchar(12) NOT NULL,
    `status_pegawai` varchar(10) NOT NULL,
    `organisasi` varchar(50) NOT NULL,
    `alamat` varchar(75) NOT NULL,
    `rt_rw` varchar(6) NOT NULL,
    `kel` varchar(40) NOT NULL,
    `kec` varchar(20) NOT NULL,
    `kab` varchar(20) NOT NULL,
    `prov` varchar(50) NOT NULL,
    `pnd_thr` varchar(30) NOT NULL,
    PRIMARY KEY (`id_tenkependik`)
  ) ENGINE=InnoDB AUTO_INCREMENT=60 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `tenkependik`
  --
  
  LOCK TABLES `tenkependik` WRITE;
  /*!40000 ALTER TABLE `tenkependik` DISABLE KEYS */;
  INSERT INTO `tenkependik` VALUES (1,20363279,'2016/2017','768.113','Tenaga Administ','Agus Purwadi','','Bantul','1969-08-07','811256755','agus_purwadi@yahoo.com','II/c','1996-08-01','L','PTY','PRM Pendowoharjo Bar','Jl. Bantul Km.7 - Pucung Pendowoharjo Sewon Bantul','52','Pendowoharjo','12','1','1','SMK'),(2,20400305,'2016/2017','796958','Tenaga Administ','Abdullah Hakim','','Bantul','1968-12-20','','','','2002-07-01','L','PTT','Ya','Senggotan','','Tirtonirmolo','16','1','1','D1'),(3,20400309,'2016/2017','756409','Kepala Tata Usa','MUJONO','','Bantul','1973-06-13','87838166656','jhonodoank@gmail.com','','1994-07-22','L','PTY','HW','Mantup RT. 08 Baturetno Banguntapan Bantul','8','Baturetno','13','1','1','SMA'),(4,20400311,'2016/2017','','Tenaga Administ','PONIRAT','','Bantul','1962-11-25','819996701193','','','1985-10-16','L','Honor Daer','','seropan','0','0','5','1','1','SMA'),(5,20400312,'2016/2017','1145103','TU','SARJIYEM','','BANTUL ','0000-00-00','87839747538','','','2005-07-16','P','PTT','','BENDUNGAN .DK GANDUNGAN KEPUH CANDEN','1','CANDEN','7','1','1','SMK'),(6,20400314,'2016/2017','1037601','Kapala Tata Usa','Wahid Luqman Nurrohman','','Gunungkidul','1985-12-29','85643328003','wahid_luqman@yahoo.com','-','2006-07-26','L','GTY','','Piyungan','5','Srimartani','14','1','1','SMA'),(7,20400315,'2016/2017','','Tenaga Administ','ANWAR NURCHOLIS','','BANTUL','1998-01-19','85641017085','Anwar.nc05@yahoo.co.id','-','2015-07-27','L','Tenaga Hon','','Purworejo','7','Wonolelo','6','1','1','SMA'),(8,20400323,'2016/2017','645488','Ka.TU','WARSANA','','Bantul','1962-02-07','81328672184','','','1983-01-01','L','PTY','RANTING','NAMPAN,GADINGSARI,SANDEN','RT.0','GADINGSARI','1','1','1','SMA'),(9,20400324,'2016/2017','','Tenaga Kebersih','SUPARYADI','','Bantul','1971-12-28','82223230961','suparyadi28@gmail.com','','2003-07-17','L','PTT','','Blali','1','Seloharjo','3','1','1','SMK'),(10,20400398,'2016/2017','697408','Kepala TU','Dra. Siti Jazamah','','Bantul','1959-08-09','81228384291','','','1987-05-17','P','PTT','PRA Pleret','Kanggotan, Pleret, Pleret, Bantul, 55791','','Pleret','6','1','1','S1'),(11,20400411,'2016/2017','','pustakawan','ARIFAH YULIANTI','','SLEMAN','1976-07-10','274621130','01arifah@gmail.com','','2015-07-27','P','GTT','','KARANGTENGAH','4','NOGOTIRTO','64','4','1','S1'),(12,20400435,'2016/2017','','SOPIR','BAMBANG BINTORO','','KULON PROGO','1988-03-18','87838842562','b_bintoro@mail.com','','2010-07-01','L','PTY','Aktif Organisasi  ke','DERWOLO','0','PENGASIH','56','3','1','SMK'),(13,20400445,'2016/2017','529919','Ka. TU','MARJIYEM','','BANTUL','1961-10-02','','','','1982-06-10','P','PTY','PRA Timbulharjo','Balong Timbulharjo Sewon Bantul','','Timbulharjo','12','1','1','SMK'),(14,20400451,'2016/2017','527909','Ka. Tata Usaha','AHMADI','','Bantul  ','1959-01-16','85643143440','ahmaditu16@gmail.com','','1989-08-05','L','PTT','Aktif Organisasi  ke','Kwasen','3','Srimartani','14','1','1','SPG'),(15,20400452,'2016/2017','756432','Bendahara','Sukamsiyah, S.Pd','','Bantul','1972-06-15','87838046233','-','-','1994-07-01','P','PTY','Aktif Organisasi  ke','Jelapan, Seloharjo, Pundong, Bantul','3','Seloharjo','3','1','1','S1'),(16,20401325,'2016/2017','1203 8411 10966','Tenaga Administ','Sari Astuti, S.IP','','Sleman','1984-08-29','','sarieast@yahoo.com','','2009-07-01','P','PTY','','Rewulu Wetan','','Sidokarto','65','4','1','S1'),(17,20401328,'2016/2017','','Staf Administra','SHOLAWATI, S. Hum.','','Temanggung ','1992-01-13','85211475924','sholawati.jo@gmail.com','','2015-07-01','P','PTT','','Sambisari','02/0','Purwomartani','66','4','1','S1'),(18,20401329,'2016/2017','1203 7610 10922','Staff Administr','Warijo','','Sleman','1976-11-05','81804034018','warijoa@gmail.com','','2010-07-07','L','PTT','','Plembon Sendangsari Minggir Sleman','RT 0','Sendangsari','67','4','1','SMK'),(19,20401330,'2016/2017','1203 8097 80873','Staff Tata Usah','Riyanti','','Sleman','1980-11-21','81328815621','riyantidimas@gmail.com','-','2011-01-02','P','PTY','','Kadisono Tegaltirto Berbah Sleman','08-Jan','Tegaltirto','61','4','1','SMK'),(20,20401331,'2016/2017','','Tenaga Administ','Furi Umiyati','','Yogyakarta','1984-12-11','85743050517','furyum50@gmail.com','','2010-07-01','P','PTY','','Kebosungu II','3/0','Dlingo','5','1','1','S1'),(21,20401336,'2016/2017','1242942','Staff Tata Usah','Maivany ZM Putri Gami,S.Pd','','Medan','1985-05-05','81260510026','maivany.putri020214@gmail.com','-','2015-07-01','P','PTT','','Tlogowono,Tegaltirto Berbah Sleman','05/0','Tegaltirto','61','4','1','SMK'),(22,20401343,'2016/2017','1159853','Operator Sekola','Dewi Sri Sukismi','','Sleman','1986-09-04','85228927808','dewix_04sept@yahoo.com','','2011-07-01','P','PTT','','Dukuhan XIII','05-Feb','Sendangagung','67','4','1','S1'),(23,20401346,'2016/2017','','Penjaga Sekolah','Sugondo','','Sleman','1965-06-02','85729048935','','','2010-01-01','L','PTY','','Sragan','Jan-19','Sendangmulyo','67','4','1','SMP'),(24,20401348,'2016/2017','','PTY','Ngadiyana','','Sleman','1969-09-11','','','','2009-04-01','L','PTY','','Jetis Prenggan','','Sidokarto','65','4','1','SD'),(25,20401352,'2016/2017','','Penjaga Sekolah','Supriyanto','','Sleman','1979-12-01','','','','2005-01-03','L','PTY','Anggota PRM','Losari','','Wukirharjo','73','4','1','SMA'),(26,20401353,'2016/2017','1157120','Penjaga Sekolah','Sri Lestari','','Klaten','1966-12-06','85878594122','','','1992-04-10','P','GTY','','Gunungharjo','04 /','Bokoharjo','73','4','1','SD'),(27,20401354,'2016/2017','','Pesuruh','Sardiyono','','Sleman','1966-03-09','','','','2002-08-27','L','PTY','','Ngentak','','Bangunkerto','77','4','1','D1'),(28,20401357,'2016/2017','1203 9116 12521','Tenaga Administ','Nita Suryani','','Sleman','1991-06-07','87834050694','nitasuryani29@yahoo.co.id','-','2010-07-01','P','PTT','Ya','Tempel','01-May','LUMBUNGREJO','76','4','1','SMK'),(29,20401367,'2016/2017','1214120','Petugas adminis','Lailia Royan Kurnia','','Jepara','1995-11-29','85729143054','','','2013-09-01','P','PTT','','Sorasan','','Bimomartani','71','4','1','SMK'),(30,20401370,'2016/2017','','TU','Setri Wilujeng','','Sleman','1991-05-28','','','','2011-01-01','P','PTY','','Selowangsan, Wonokerto, Turi','','Wonokerto','77','4','1','SMK'),(31,20401371,'2016/2017','','Perpustakaan','Rr. Cahaya Sekarwangi','','Sleman','1991-07-21','87838979004','swangi@yahoo.com','','2015-01-01','P','PTT','','Pandean, Sidoluhur, Godean, Sleman','02-Jan','Sidoluhur','65','4','1','S2'),(32,20402093,'2016/2017','1154449','JURU BENGKEL','BIBIT YULIANTO','','GUNUNGKIDUL','1985-07-19','','bibit@muspla.sch.id','','2005-07-20','L','PTY','','KEPEK 2','01-May','KEPEK','35','2','1','D3'),(33,20402130,'2016/2017','','Guru Mapel','AGUS NUGROHO','','Gunungkidul','1983-03-20','81578628602','agusnugroho1983.an@gmail.com','','2006-07-01','L','Guru Honor','','Kerdon,RT 002/ RW 002 Karangsari, Semin, Gunungkid','02-Feb','Karangsari','32','2','1',''),(34,20402132,'2016/2017','662476',' Persuratan dan','AMAR JAYA','','GUNUNGKIDUL','1968-07-17','81904075806','amarjaya17@gmail.com','','1990-07-01','L','PTY','','JATISARI 018/004, PLAYEN, PLAYEN, GUNUNGKIDUL, DIY','18','PLAYEN','26','2','1','SMK'),(35,20402708,'2016/2017','724.81','Ka TU','ISMADI','','Kulon Progo','1961-08-05','','','','1983-07-01','L','GTT','Aktif','Wora wari','RT 1','Sukoreno','58','3','1','SMA'),(36,20402709,'2016/2017','','Operator Sekola','Agus Supriyadi Jatmiko','','Kulon Progo ','1980-08-07','85274234856','den.jatmiko@yaho.co.id','','2003-08-07','L','PTY','','Jurangkah','03-Apr','Dadirejo','92','6','1','SMK'),(37,20402711,'2016/2017','709,017','Administrasi','Sumarsih','','Kulon Progo','1965-10-19','87839667410','sumarsihmp@yahoo.com','-','1987-05-01','P','PTT','PRA','Kedundang','17','Kedundang','59','3','1','SMK'),(38,20402721,'2016/2017','725053','KA TU','PURWIDI','','KULON PROGO','1973-05-06','85226311032','widiningdumadi80@yahoo.co.id','','2011-07-01','L','PTY','Ya','Nganti','RT 7','Hargotirto','52','3','1','SMK'),(39,20402722,'2016/2017','795998','KA TU','DALIMAN ISMAIL','','KULON PROGO','0000-00-00','81908975460','daliman_ismail@yahoo.co.id','','1992-07-01','L','PTT','Ranting Muhammadiyah','Srandu','51/2','Banjarharjo','51','3','1','SMP'),(40,20402730,'2016/2017','1130905','','AGUS SUSMIARTO','','TEGAL','1968-09-03','','','','2008-07-01','L','','','SANGGRAHAN KIDUL','15-Jul','BENDUNGAN','60','3','1','SMP'),(41,20402736,'2016/2017','','TATA USAHA','SUYATNO','','KULON PROGO','1963-06-12','81227785597','','','1989-07-15','L','PTT','','Jarakan','04/0','Kebonharjo','57','3','1','SMK'),(42,20402801,'2016/2017','570.271','KTU','Hastini','','Kulon progo','0000-00-00','81802618596','hantin.brosot@yahoo.com','0','1981-09-01','P','Yayasan','Aisyiyah','Brosot Galur Kulon Progo','15','Brosot','50','3','1','SMA'),(43,20402838,'2016/2017','757474','KTU','Sri Wiwing Sutrisnawati','','Banyuwangi','1963-08-10','87739800112','','','1992-07-02','P','PTT','','Gadingan','44/2','Wates','60','3','1','SMA'),(44,20402839,'2016/2017','','Pengurus TU','Dwi Setyani','','Kulon Progo','1987-08-29','','','','2012-07-02','P','PTT','','Pongangan','12 /','Sentolo','58','3','1','D3'),(45,20403148,'2016/2017','','Penjaga Sekolah','AGUS TRI WAHYONO','','BANTUL','1968-08-07','85292539495','mupat_agus@yahoo.com','','1993-07-01','L','PTY','','BLADO  BALONG LOR POTORONO BANGUNTAPAN BANTUL','2 / ','POTORONO','13','1','1','SMA'),(46,20403242,'2016/2017','1,117,856','Satpam','Agung Nugroho','','Yogyakarta','1975-01-25','87839900095','agungnugroho1111@gmail.com','-','2010-11-01','L','PTT','ya','Purwodiningratan','46/9','Purwodiningratan','87','5','1','SMA'),(47,20403246,'2016/2017','653794','KTU','Ida Prastiwi, Ama.Pd.','','Purworejo','0000-00-00','85729422765','idaprastiwi66@gmail.com','Pengatur Muda / II a','2013-09-19','P','PTY','Ikut','Warungboto UH 4/986','34','Warungboto','90','5','1','D2'),(48,20403248,'2016/2017','1106534','Kepala Tata Usa','Andrianto Nurprasetyo Prabanca','','Yogyakarta','1984-08-22','85643697898','restless2002@gmail.com','-','2010-12-31','L','PTT','PRM','Notoprajan NG II/618 Yogyakarta 55262','RT 0','Notoprajan','87','5','1','S1'),(49,20403249,'2016/2017','','Tenaga Administ','CUT RIFATMI FADHILAINI','','YOGYAKARTA','1992-11-09','85742340321','cut.fadhilaini@gmail.com','','2016-07-18','P','GTT','','GEDONGAN KG III/15A','1','PURBAYAN','83','5','1','S1'),(50,20404085,'2016/2017','1023956','Admin ','KIDIN','','Bantul','1967-06-08','87838155895','','','2008-05-01','L','PTY','PRM Kec. Sedayu','Sukoharjo','44/-','Argodadi','15','1','1','SMK'),(51,20404088,'2016/2017','1203 7106 97302','Penjaga Sekolah','Kemis','','Sleman','1971-01-01','85228494684','kemiskasman@yahoo.com','','2001-01-01','L','PTY','','Cerbonan','','Sendangmulyo','67','4','1','SMA'),(52,20404090,'2016/2017','1156993','PENJAGA SEKOLAH','AGIK YAN PRASETYA','','Sleman','1990-12-11','89674662007','prasetya_agik@yahoo.com','','2011-10-20','L','PTY','','Wadas','7','Tridadi','75','4','1','SMK'),(53,20404174,'2016/2017','733.73','Pesuruh/Office ','Ahmad Mukhid','','Bantul','1969-10-29','','ahmad.mukhid@yahoo.com','','1997-07-01','L','Tenaga Hon','','Bogoran','2','Trirenggo','11','1','1','SMA'),(54,20407341,'2016/2017','985 119','Admin ','Saparji Pranuju','','Gunungkidul','1978-02-05','87838476913','pranuju.ajie@yahoo.com','','2004-07-01','L','PTY','Kepengurusan HW Kwar','Tilaman,RT 01,  Wukirsari, Imogiri, Bantul 55782.','01/-','Wukirsari','4','1','1','SMK'),(55,20411881,'2016/2017','111 5475','Kepala TU','Suratiman','','Kulon Progo','1979-10-14','0817 0426 303','slash.timan@gmail.com','-','2010-07-12','L','PTY','','Barongan Ped. XVI','065/','Karangsewu','50','3','1','SMK'),(56,20411922,'2016/2017','','Bendahara','Mariyah','','Kulon Progo','1978-05-20','81227135536','ts.nibras@gmail.com','','2005-07-01','P','PTY','','Kauman','018/','Tirtorahayu','50','3','1','SMK'),(57,20411931,'2016/2017','1204-770-875832','Kepala Tata Usa','Nur Cahya Dwi Nugroho,A.Md','','Kulon Progo','0000-00-00','82329175215','','','2014-09-15','L','PTY','Aktif','Wonosidi Lor Rw 12 Rt 04 Wates','12','Wates','60','3','1','D3'),(58,20420732,'2016/2017','969943','Bendahara','Asni Fauziyah','','Kulon Progo','1968-01-11','','','','1986-07-01','P','PTY','','Pandowan  I','03-Feb','Pandowan','50','3','1','SMA'),(59,69945435,'2016/2017','1174964','Saff Administra','Devi Ayunani Wandasari, ST','','Sleman','1991-06-12','85600888112','nda.ayunani@gmail.com','','2016-07-01','P','PTT','sekertaris PRNA','Majegan','03/0','Pandowoharjo','75','4','1','S1');
  /*!40000 ALTER TABLE `tenkependik` ENABLE KEYS */;
  UNLOCK TABLES;
  /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
  
  /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
  /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
  /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
  /*!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 */;
  /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
  
  -- Dump completed on 2017-06-07 12:49:59
  