contoh sql

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

--
-- Table structure for table `detailpenjualan`
--

CREATE TABLE `detailpenjualan` (
  `id_urut` int(11) NOT NULL,
  `id_barang` int(10) NOT NULL,
  `jumlah_pembelian` int(15) NOT NULL,
  `harga_satuan` bigint(10) NOT NULL,
  `tanggal_penjualan` date NOT NULL,
  `total_harga` bigint(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `detailpenjualan`
--
ALTER TABLE `detailpenjualan`
  ADD PRIMARY KEY (`id_urut`),
  ADD KEY `id_barang` (`id_barang`);

--
-- Constraints for dumped tables
--

--
-- Constraints for table `detailpenjualan`
--
ALTER TABLE `detailpenjualan`
  ADD CONSTRAINT `detailpenjualan_ibfk_1` FOREIGN KEY (`id_barang`) REFERENCES `masterbarang` (`id_barang`) ON DELETE CASCADE ON UPDATE CASCADE;
COMMIT;