-- phpMyAdmin SQL Dump
-- version 5.2.0
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Jan 26, 2023 at 07:24 AM
-- Server version: 10.4.27-MariaDB
-- PHP Version: 7.4.33
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: `kai`
--
-- --------------------------------------------------------
--
-- Table structure for table `reservasibarang`
--
CREATE TABLE `reservasibarang` (
`id_barang` int(11) NOT NULL,
`id_pemesanBarang` int(11) NOT NULL,
`jenisBarang` varchar(250) NOT NULL,
`asalBarang` varchar(250) NOT NULL,
`tujuanBarang` varchar(250) NOT NULL,
`beratBarang` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data for table `reservasibarang`
--
INSERT INTO `reservasibarang` (`id_barang`, `id_pemesanBarang`, `jenisBarang`,
`asalBarang`, `tujuanBarang`, `beratBarang`) VALUES
(12, 7, 'ELEKTRONIK', 'ASAHAN', 'BANYUWANGI(Kota)', 20);
-- --------------------------------------------------------
--
-- Table structure for table `reservasitiket`
--
CREATE TABLE `reservasitiket` (
`id_tiket` int(11) NOT NULL,
`id_pemesan` int(11) NOT NULL,
`stasiunAsal` varchar(11) NOT NULL,
`stasiunTujuan` varchar(11) NOT NULL,
`tanggalKeberangkatan` date NOT NULL,
`jumlahPenumpang` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data for table `reservasitiket`
--
INSERT INTO `reservasitiket` (`id_tiket`, `id_pemesan`, `stasiunAsal`,
`stasiunTujuan`, `tanggalKeberangkatan`, `jumlahPenumpang`) VALUES
(2, 14, 'HAJI PEMANG', 'KOTABUMI ', '2023-01-10', 4),
(3, 11, 'SULUSUBAN ', 'HAJI PEMANG', '2023-01-28', 2),
(4, 11, 'REJOSARI', 'TANJUNG KAR', '2023-01-28', 2),
(9, 11, 'BEKRI B', 'TEGINENENG ', '2023-01-06', 2);
-- --------------------------------------------------------
--
-- Table structure for table `userbarang`
--
CREATE TABLE `userbarang` (
`id_pemesanBarang` int(11) NOT NULL,
`NIK` int(150) NOT NULL,
`nama` varchar(250) NOT NULL,
`email` varchar(250) NOT NULL,
`password` varchar(250) NOT NULL,
`level` int(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data for table `userbarang`
--
INSERT INTO `userbarang` (`id_pemesanBarang`, `NIK`, `nama`, `email`, `password`,
`level`) VALUES
(7, 315646868, 'firli juan', 'firli@gmail.com',
'40bd001563085fc35165329ea1ff5c5ecbdbbeef', 0),
(8, 2147483647, 'admin', 'admin@gmail.com',
'd033e22ae348aeb5660fc2140aec35850c4da997', 1),
(10, 2147483647, 'Aisyah Nabila Zahra', 'nabila@gmail.com', '123', 0);
-- --------------------------------------------------------
--
-- Table structure for table `usertiket`
--
CREATE TABLE `usertiket` (
`id_pemesan` int(11) NOT NULL,
`NIK` int(150) NOT NULL,
`nama` varchar(250) NOT NULL,
`email` varchar(250) NOT NULL,
`password` varchar(250) NOT NULL,
`level` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data for table `usertiket`
--
INSERT INTO `usertiket` (`id_pemesan`, `NIK`, `nama`, `email`, `password`, `level`)
VALUES
(11, 2147483647, 'Dwi Lutfi Taufiq Ihsani', 'lutfid955@gmail.com',
'40bd001563085fc35165329ea1ff5c5ecbdbbeef', 0),
(12, 2147483647, 'admin', 'admin@gmail.com',
'd033e22ae348aeb5660fc2140aec35850c4da997', 1),
(13, 2147483647, 'karina', 'karina@gmail.com',
'40bd001563085fc35165329ea1ff5c5ecbdbbeef', 0),
(14, 23414144, 'Joko Alando', 'joko@gmail.com',
'40bd001563085fc35165329ea1ff5c5ecbdbbeef', 0);
--
-- Indexes for dumped tables
--
--
-- Indexes for table `reservasibarang`
--
ALTER TABLE `reservasibarang`
ADD PRIMARY KEY (`id_barang`),
ADD UNIQUE KEY `id_barang` (`id_pemesanBarang`);
--
-- Indexes for table `reservasitiket`
--
ALTER TABLE `reservasitiket`
ADD PRIMARY KEY (`id_tiket`),
ADD KEY `reservasitiket_ibfk_1` (`id_pemesan`);
--
-- Indexes for table `userbarang`
--
ALTER TABLE `userbarang`
ADD PRIMARY KEY (`id_pemesanBarang`);
--
-- Indexes for table `usertiket`
--
ALTER TABLE `usertiket`
ADD PRIMARY KEY (`id_pemesan`);
--
-- AUTO_INCREMENT for dumped tables
--
--
-- AUTO_INCREMENT for table `reservasibarang`
--
ALTER TABLE `reservasibarang`
MODIFY `id_barang` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;
--
-- AUTO_INCREMENT for table `reservasitiket`
--
ALTER TABLE `reservasitiket`
MODIFY `id_tiket` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
--
-- AUTO_INCREMENT for table `userbarang`
--
ALTER TABLE `userbarang`
MODIFY `id_pemesanBarang` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
--
-- AUTO_INCREMENT for table `usertiket`
--
ALTER TABLE `usertiket`
MODIFY `id_pemesan` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;
--
-- Constraints for dumped tables
--
--
-- Constraints for table `reservasibarang`
--
ALTER TABLE `reservasibarang`
ADD CONSTRAINT `reservasibarang_ibfk_1` FOREIGN KEY (`id_pemesanBarang`)
REFERENCES `userbarang` (`id_pemesanBarang`);
--
-- Constraints for table `reservasitiket`
--
ALTER TABLE `reservasitiket`
ADD CONSTRAINT `reservasitiket_ibfk_1` FOREIGN KEY (`id_pemesan`) REFERENCES
`usertiket` (`id_pemesan`);
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 */;
