 
 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');
 
 -- --------------------------------------------------------
 

--

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

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

--

INSERT INTO `transaksi` (`id`, `id_pel`, `tgl`, `stand_lalu`, `stand_kini`, `pemakaian`, `foto`, `keterangan`) VALUES
(35, 2147483647, '2017-07-19', 0, 4000, 4000, 'foto_170719035537.png', 'hahaha'),
(32, 1239, '2017-07-18', 0, 12121, 12121, 'foto_170718105756.jpg', 'hahahaha'),
(34, 999, '2017-07-13', 0, 5777, 5777, 'foto_170719035313.jpg', 'hahahha'),
(33, 999, '2017-07-06', 0, 5000, 5000, 'foto_170719035239.png', 'hahaha'),
(36, 2147483647, '2017-07-13', 0, 79000, 79000, 'foto_170719035628.png', 'hahhaha');

--
-- Indexes for dumped tables
