 
 CREATE TABLE `pelanggan` (
   `id_pel` int(15) NOT NULL,
+  `nama` varchar(20) NOT NULL,
   `alamat` text NOT NULL,
   `no_tiang` varchar(30) NOT NULL,
   `lat` varchar(100) NOT NULL,
   `long` varchar(100) NOT NULL,
   `kode_baca` varchar(10) NOT NULL
 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+
+--
+-- Dumping data untuk tabel `pelanggan`
+--
+
+INSERT INTO `pelanggan` (`id_pel`, `nama`, `alamat`, `no_tiang`, `lat`, `long`, `kode_baca`) VALUES
+(999, 'rahman', 'Malang', '231', '123', '234', 'Rbc1'),
+(2147483647, 'arif', 'Klaten', '23', '99888', '88998', 'T121'),
+(45, 'duso', 'hahaha', '1213', '213i10823', '256253265', 'hn'),
+(49, 'hanif', 'karanganom', '09', '2131344335', '2342422', 'kl03010001'),
+(1239, 'nanda', 'klaten', '12', '1616', '18181', 'ni1');
 
 -- --------------------------------------------------------
 

-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: 16 Jul 2017 pada 03.15
-- Versi Server: 10.1.25-MariaDB
-- PHP Version: 5.6.31


--

INSERT INTO `login` (`id`, `username`, `password`, `nama`, `jabatan`) VALUES
(1, 'nanda', '859a37720c27b9f70e11b79bab9318fe', 'dhitta nanda', 'supervisor'),
(6, 'dista', '54c4e9954a45edbd08909b5433002c1f', 'dista', 'superadmin');

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