-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Waktu pembuatan: 24 Bulan Mei 2023 pada 09.35
-- Versi server: 10.4.28-MariaDB
-- Versi PHP: 8.0.28

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: `azlogistik`
--

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

--
-- Struktur dari tabel `order_transportasi`
--

CREATE TABLE `order_transportasi` (
  `id` int(11) NOT NULL,
  `id_transportasi` int(11) NOT NULL,
  `tarif` int(100) NOT NULL,
  `jarak` int(100) NOT NULL,
  `kota` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data untuk tabel `order_transportasi`
--

INSERT INTO `order_transportasi` (`id`, `id_transportasi`, `tarif`, `jarak`, `kota`) VALUES
(5, 2, 280000, 700, 'Jakarta'),
(7, 2, 272000, 680, 'Bogor'),
(8, 1, 412500, 550, 'Bandung'),
(9, 1, 330000, 440, 'Salatiga');

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

--
-- Struktur dari tabel `tarif`
--

CREATE TABLE `tarif` (
  `id` int(11) NOT NULL,
  `jam_masuk` varchar(100) NOT NULL,
  `jam_keluar` varchar(100) NOT NULL,
  `tarif` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data untuk tabel `tarif`
--

INSERT INTO `tarif` (`id`, `jam_masuk`, `jam_keluar`, `tarif`) VALUES
(1, '19.00', '08.00', '275.000\r\n\r\n'),
(2, '10.00', '14.00', '21.000'),
(3, '18.00', '23.00', '46000'),
(5, '05.00', '12.00', '54000');

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

--
-- Struktur dari tabel `transportasi`
--

CREATE TABLE `transportasi` (
  `id` int(11) NOT NULL,
  `jenis_truk` varchar(100) NOT NULL,
  `jarak` varchar(100) NOT NULL,
  `harga` varchar(100) NOT NULL,
  `customid` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data untuk tabel `transportasi`
--

INSERT INTO `transportasi` (`id`, `jenis_truk`, `jarak`, `harga`, `customid`) VALUES
(1, 'Colt Diesel Los', '100', '75000', '0'),
(2, 'Colt Diesel Box', '100', '40000', '0'),
(3, 'Colt Diesel Tronton', '100', '100000', '0');

--
-- Indexes for dumped tables
--

--
-- Indeks untuk tabel `order_transportasi`
--
ALTER TABLE `order_transportasi`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `tarif`
--
ALTER TABLE `tarif`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `transportasi`
--
ALTER TABLE `transportasi`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT untuk tabel yang dibuang
--

--
-- AUTO_INCREMENT untuk tabel `order_transportasi`
--
ALTER TABLE `order_transportasi`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT untuk tabel `tarif`
--
ALTER TABLE `tarif`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT untuk tabel `transportasi`
--
ALTER TABLE `transportasi`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
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 */;
