-- phpMyAdmin SQL Dump
-- version 5.0.2
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Feb 17, 2024 at 07:29 AM
-- Server version: 10.4.14-MariaDB
-- PHP Version: 7.4.10

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


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `jembatantimbang`
--

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

--
-- Table structure for table `keluar`
--

CREATE TABLE `keluar` (
  `id` int(11) NOT NULL,
  `timbangan` bigint(20) DEFAULT NULL,
  `notiket` varchar(100) DEFAULT NULL,
  `nopolisi` varchar(100) DEFAULT NULL,
  `namasupir` varchar(100) DEFAULT NULL,
  `namamuatan` varchar(100) DEFAULT NULL,
  `berattotal` bigint(20) DEFAULT NULL,
  `beratkosong` bigint(20) DEFAULT NULL,
  `beratmuatan` bigint(20) DEFAULT NULL,
  `image` varchar(100) DEFAULT NULL,
  `createdate` timestamp NULL DEFAULT current_timestamp(),
  `harga_tbs` double DEFAULT NULL,
  `potongan` double DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `keluar`
--

INSERT INTO `keluar` (`id`, `timbangan`, `notiket`, `nopolisi`, `namasupir`, `namamuatan`, `berattotal`, `beratkosong`, `beratmuatan`, `image`, `createdate`, `harga_tbs`, `potongan`) VALUES
(7, 200, '0002', 'KB 5201 KN', 'OM BOTAK', 'Buah Sawit', 5000, 200, 4800, NULL, '2024-01-29 05:46:14', 2200, 3.7),
(11, 300, '0003', 'KB 3320 LA', 'OM BREWOK', 'Buah Sawit', 3000, 300, 2700, NULL, '2024-01-30 04:39:08', 2200, 3.7),
(12, 230, '0004', 'KB 5201 KN', 'OM BOTAK', 'Buah Sawit', 3000, 230, 2770, NULL, '2024-01-30 04:43:06', 2200, 3.7);

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

--
-- Table structure for table `kendaraan`
--

CREATE TABLE `kendaraan` (
  `id` int(11) NOT NULL,
  `no_kendaraan` varchar(50) DEFAULT NULL,
  `nama_supir` varchar(255) DEFAULT NULL,
  `alamat` text DEFAULT NULL,
  `nomor_hp` varchar(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `kendaraan`
--

INSERT INTO `kendaraan` (`id`, `no_kendaraan`, `nama_supir`, `alamat`, `nomor_hp`) VALUES
(2, 'KB 4562 LA', 'MARWAN', 'jalan JALAN', NULL),
(11, 'KB 3320 LA', 'OM BREWOK', 'JALN KERINDUAN', NULL),
(12, 'KB 5201 KN', 'OM BOTAK', 'JALAN KELAKAR', NULL);

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

--
-- Table structure for table `masuk`
--

CREATE TABLE `masuk` (
  `id` int(11) NOT NULL,
  `timbangan` bigint(20) DEFAULT NULL,
  `notiket` varchar(100) DEFAULT NULL,
  `nopolisi` varchar(100) DEFAULT NULL,
  `namasupir` varchar(100) DEFAULT NULL,
  `namamuatan` varchar(100) DEFAULT NULL,
  `berattotal` bigint(20) DEFAULT NULL,
  `beratkosong` bigint(20) DEFAULT NULL,
  `beratmuatan` bigint(20) DEFAULT NULL,
  `image` varchar(100) DEFAULT NULL,
  `createdate` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `masuk`
--

INSERT INTO `masuk` (`id`, `timbangan`, `notiket`, `nopolisi`, `namasupir`, `namamuatan`, `berattotal`, `beratkosong`, `beratmuatan`, `image`, `createdate`) VALUES
(8, 6000, '0001', 'KB 4142 KE', 'WIWIN', 'Buah Sawit', 6000, 0, 0, NULL, '2024-01-27 03:08:20'),
(9, 5000, '0002', 'KB 5201 KN', 'OM BOTAK', 'Buah Sawit', 5000, 0, 0, NULL, '2024-01-29 05:35:46'),
(10, 3000, '0003', 'KB 3320 LA', 'OM BREWOK', 'Buah Sawit', 3000, 0, 0, NULL, '2024-01-30 03:13:44'),
(11, 3000, '0004', 'KB 5201 KN', 'OM BOTAK', 'Buah Sawit', 3000, 0, 0, NULL, '2024-01-30 04:42:49');

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

--
-- Table structure for table `setting`
--

CREATE TABLE `setting` (
  `id` int(11) NOT NULL,
  `nama_ramp` text DEFAULT NULL,
  `nomor_hp` varchar(20) DEFAULT NULL,
  `potongan_ramp` double DEFAULT NULL,
  `harga_buah` double DEFAULT NULL,
  `service_wa` int(11) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `setting`
--

INSERT INTO `setting` (`id`, `nama_ramp`, `nomor_hp`, `potongan_ramp`, `harga_buah`, `service_wa`) VALUES
(1, 'VW RAMP ABADI', '085332169724', 3.7, 2110, 1);

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

--
-- Table structure for table `user`
--

CREATE TABLE `user` (
  `id` int(11) NOT NULL,
  `username` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user`
--

INSERT INTO `user` (`id`, `username`, `password`) VALUES
(2, 'admin', 'admin');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `keluar`
--
ALTER TABLE `keluar`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `kendaraan`
--
ALTER TABLE `kendaraan`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `masuk`
--
ALTER TABLE `masuk`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `setting`
--
ALTER TABLE `setting`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `user`
--
ALTER TABLE `user`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `keluar`
--
ALTER TABLE `keluar`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `kendaraan`
--
ALTER TABLE `kendaraan`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `masuk`
--
ALTER TABLE `masuk`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `setting`
--
ALTER TABLE `setting`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `user`
--
ALTER TABLE `user`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;
COMMIT;

/*!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 */;
