perbaikan 104

-- phpMyAdmin SQL Dump
-- version 5.0.2
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: Apr 24, 2020 at 10:45 PM
-- Server version: 5.7.24
-- PHP Version: 7.2.19

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";

--
-- Database: `wrk_demo`
--

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

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

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

--
-- Table structure for table `headerpenjualan`
--

CREATE TABLE `headerpenjualan` (
  `tanggal` date NOT NULL,
  `id_customer` varchar(10) CHARACTER SET latin1 NOT NULL,
  `id_kasir` varchar(5) CHARACTER SET latin1 NOT NULL,
  `total_penjualan` bigint(10) NOT NULL,
  `total_pembayaran` bigint(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `kasir`
--

CREATE TABLE `kasir` (
  `id_kasir` varchar(5) CHARACTER SET latin1 NOT NULL,
  `nama_kasir` varchar(15) CHARACTER SET latin1 NOT NULL,
  `username` varchar(10) CHARACTER SET latin1 NOT NULL,
  `password` varchar(10) CHARACTER SET latin1 NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `masterbarang`
--

CREATE TABLE `masterbarang` (
  `id_barang` int(10) NOT NULL,
  `nama_barang` varchar(50) CHARACTER SET latin1 NOT NULL,
  `harga_barang` bigint(20) NOT NULL,
  `stok_akhir` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `mastercustomer`
--

CREATE TABLE `mastercustomer` (
  `id_customer` varchar(10) CHARACTER SET latin1 NOT NULL,
  `nama_customer` varchar(30) CHARACTER SET latin1 NOT NULL,
  `alamat_customer` int(100) NOT NULL,
  `notelpon` varchar(50) CHARACTER SET latin1 NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `my_report`
--

CREATE TABLE `my_report` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  `descriptions` char(50) DEFAULT NULL COMMENT 'info sederhana',
  `summary` longtext COMMENT 'total log'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='report untuk proses';

--
-- Indexes for dumped tables
--

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

--
-- Indexes for table `headerpenjualan`
--
ALTER TABLE `headerpenjualan`
  ADD KEY `id_customer` (`id_customer`),
  ADD KEY `id_kasir` (`id_kasir`);

--
-- Indexes for table `kasir`
--
ALTER TABLE `kasir`
  ADD PRIMARY KEY (`id_kasir`);

--
-- Indexes for table `masterbarang`
--
ALTER TABLE `masterbarang`
  ADD PRIMARY KEY (`id_barang`);

--
-- Indexes for table `mastercustomer`
--
ALTER TABLE `mastercustomer`
  ADD PRIMARY KEY (`id_customer`);

--
-- Indexes for table `my_report`
--
ALTER TABLE `my_report`
  ADD PRIMARY KEY (`id`),
  ADD KEY `descriptions` (`descriptions`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `masterbarang`
--
ALTER TABLE `masterbarang`
  MODIFY `id_barang` int(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `my_report`
--
ALTER TABLE `my_report`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

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

--
-- Constraints for table `headerpenjualan`
--
ALTER TABLE `headerpenjualan`
  ADD CONSTRAINT `headerpenjualan_ibfk_1` FOREIGN KEY (`id_customer`) REFERENCES `mastercustomer` (`id_customer`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `kasir` FOREIGN KEY (`id_kasir`) REFERENCES `kasir` (`id_kasir`);
COMMIT;