   `id_transaksi` int(9) NOT NULL,
   `nama_pelanggan` varchar(100) NOT NULL,
   `email_pelanggan` varchar(100) NOT NULL,
-  `no_hp` int(15) NOT NULL,
+  `no_hp` varchar(15) NOT NULL,
   `barang_beli` varchar(100) NOT NULL,
   `total_beli` varchar(200) NOT NULL,
   `qty_beli` int(100) NOT NULL,
   `no_rekening` varchar(50) NOT NULL
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+
+--
+-- Dumping data untuk tabel `transaksi`
+--
+
+INSERT INTO `transaksi` (`id_transaksi`, `nama_pelanggan`, `email_pelanggan`, `no_hp`, `barang_beli`, `total_beli`, `qty_beli`, `no_rekening`) VALUES
+(4, 'Gamma Luluh Lengingtyas Mawar Tania', 'gama@example.com', '089238100183', 'Grand Prime Golden Wacth', '100', 1, '1293008181080380');
 
 --
 -- Indexes for dumped tables

-- AUTO_INCREMENT for table `barang`
--
ALTER TABLE `barang`
  MODIFY `id_barang` int(9) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `pengiriman`
--
ALTER TABLE `pengiriman`
  MODIFY `id_transaksi` int(9) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `transaksi`
--
ALTER TABLE `transaksi`
  MODIFY `id_transaksi` int(9) NOT NULL AUTO_INCREMENT;
/*!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 */;

-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: 02 Jun 2017 pada 05.43
-- Versi Server: 10.1.19-MariaDB
-- PHP Version: 7.0.13

