   `qty` int(11) NOT NULL,
   `harga_barang` varchar(25) NOT NULL,
   `discount` varchar(4) NOT NULL,
+  `spesifikasi` text NOT NULL,
   `suplier` varchar(20) NOT NULL,
   `alamat_suplier` text NOT NULL,
   `image` varchar(255) NOT NULL
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+
+--
+-- Dumping data untuk tabel `barang`
+--
+
+INSERT INTO `barang` (`id_barang`, `nama_barang`, `kategori`, `qty`, `harga_barang`, `discount`, `spesifikasi`, `suplier`, `alamat_suplier`, `image`) VALUES
+(1, 'Grand Prime Golden Wacth', 'jam tangan', 100, '100', '50', 'bagus keren mantap', 'aryaagung', 'emboh', ''),
+(3, 'Grand Prime ARLOGI', 'jam tangan', 50, '200', '1', 'keren gila keren', 'aryaagung', 'jutak dung dung', '');
 
 -- --------------------------------------------------------
 

  `id_transaksi` int(9) NOT NULL,
  `nama_pelanggan` varchar(100) NOT NULL,
  `email_pelanggan` varchar(100) NOT NULL,
  `no_hp` int(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;

--
-- Indexes for dumped tables

  `kabupaten_kota` varchar(20) NOT NULL,
  `kecamatan` varchar(20) NOT NULL,
  `kodepos` int(7) NOT NULL,
  `alamat_lengkap` text NOT NULL,
  `tanggal` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data untuk tabel `pengiriman`
--

INSERT INTO `pengiriman` (`id_transaksi`, `provinsi`, `kabupaten_kota`, `kecamatan`, `kodepos`, `alamat_lengkap`, `tanggal`) VALUES
(4, 'Jawa Timur', 'Lumajang', 'Pasirian', 67832, 'Gang Sumarnoto No.131', '2017-05-31');

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

