database.sql

-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Oct 08, 2025 at 06:33 PM
-- Server version: 10.4.32-MariaDB
-- PHP Version: 8.2.12

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

--


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

--
-- Table structure for table `admin`
--

CREATE TABLE `admin` (
  `admin_id` int(11) NOT NULL,
  `username` varchar(50) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `admin`
--

INSERT INTO `admin` (`admin_id`, `username`, `password`) VALUES
(1, 'aiml', 'aiml');

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

--
-- Table structure for table `bookings`
--

CREATE TABLE `bookings` (
  `booking_id` int(11) NOT NULL,
  `car_id` int(11) DEFAULT NULL,
  `registration_number` varchar(50) DEFAULT NULL,
  `customer_id` int(11) DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `booking_time` datetime DEFAULT current_timestamp(),
  `status` enum('Pending Payment','Awaiting Approval','Approved','Declined','Cancelled','Expired') DEFAULT 'Pending Payment',
  `transaction_id` varchar(100) DEFAULT NULL,
  `inventory_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `bookings`
--

INSERT INTO `bookings` (`booking_id`, `car_id`, `registration_number`, `customer_id`, `start_date`, `end_date`, `booking_time`, `status`, `transaction_id`, `inventory_id`) VALUES
(25, 2, NULL, 6, '2025-10-03', '2025-10-06', '2025-10-03 14:49:14', 'Cancelled', '189', NULL),
(26, 2, NULL, 7, '2025-10-17', '2025-10-18', '2025-10-03 14:51:25', 'Cancelled', '85558', NULL),
(27, 6, NULL, 7, '2025-10-03', '2025-10-05', '2025-10-03 16:12:42', 'Cancelled', '1345634556', NULL),
(28, 4, NULL, 7, '2025-10-08', '2025-10-11', '2025-10-03 16:13:49', 'Cancelled', '5452643', NULL),
(29, 5, NULL, 7, '2025-10-03', '2025-10-10', '2025-10-03 16:15:15', 'Cancelled', NULL, NULL),
(30, 1, NULL, 7, '2025-10-03', '2025-10-04', '2025-10-03 16:40:55', 'Cancelled', '4891', NULL),
(31, 5, NULL, 7, '2025-10-03', '2025-10-04', '2025-10-03 16:45:32', 'Cancelled', '515', NULL),
(32, 5, NULL, 7, '2025-10-03', '2025-10-04', '2025-10-03 16:55:34', 'Cancelled', NULL, NULL),
(33, 5, NULL, 7, '2025-10-03', '2025-10-04', '2025-10-03 16:55:47', 'Cancelled', NULL, NULL),
(34, 5, NULL, 7, '2025-10-10', '2025-10-17', '2025-10-03 16:58:18', 'Cancelled', NULL, NULL),
(35, 5, NULL, 7, '2025-10-04', '2025-10-05', '2025-10-04 12:21:33', 'Cancelled', '14515', NULL),
(36, 5, NULL, 7, '2025-10-04', '2025-10-05', '2025-10-04 12:26:55', 'Cancelled', NULL, NULL),
(37, 5, NULL, 7, '2025-10-04', '2025-10-05', '2025-10-04 12:28:18', 'Cancelled', '1556', NULL),
(38, 5, NULL, 7, '2025-10-04', '2025-10-06', '2025-10-04 12:33:49', 'Cancelled', '51', NULL),
(39, 1, NULL, 7, '2025-10-04', '2025-10-06', '2025-10-04 12:34:29', 'Cancelled', '51515', NULL),
(40, 5, NULL, 7, '2025-10-10', '2025-10-17', '2025-10-04 12:38:41', 'Cancelled', NULL, NULL),
(41, 5, NULL, 7, '2025-10-04', '2025-10-06', '2025-10-04 12:48:40', 'Cancelled', NULL, NULL),
(42, 5, NULL, 7, '2025-10-04', '2025-10-06', '2025-10-04 12:53:01', 'Cancelled', NULL, NULL),
(43, 5, NULL, 7, '2025-10-04', '2025-10-06', '2025-10-04 13:02:34', 'Cancelled', NULL, NULL),
(44, 5, NULL, 6, '2025-10-09', '2025-10-14', '2025-10-04 17:05:58', 'Cancelled', '5818515', NULL),
(45, 5, NULL, 6, '2025-10-10', '2025-10-16', '2025-10-04 17:11:50', 'Cancelled', '156', NULL),
(46, 5, NULL, 6, '2025-10-10', '2025-10-22', '2025-10-04 17:13:04', 'Cancelled', '48487', NULL),
(47, 5, NULL, 6, '2025-10-09', '2025-10-15', '2025-10-04 17:13:29', 'Cancelled', '4846515', NULL),
(48, 5, NULL, 7, '2025-10-04', '2025-10-10', '2025-10-04 17:14:59', 'Cancelled', '78784', NULL),
(49, 5, NULL, 6, '2025-10-09', '2025-10-10', '2025-10-04 17:25:36', 'Cancelled', '4848', NULL),
(50, 5, NULL, 6, '2025-10-04', '2025-10-08', '2025-10-04 17:27:44', 'Cancelled', NULL, NULL),
(51, 6, NULL, 6, '2025-10-04', '2025-10-08', '2025-10-04 17:37:01', 'Cancelled', '478', NULL),
(52, 6, NULL, 6, '2025-10-21', '2025-10-23', '2025-10-04 17:37:49', 'Cancelled', '8741', NULL),
(53, 7, NULL, 6, '2025-10-07', '2025-10-08', '2025-10-04 17:38:32', 'Cancelled', '7478', NULL),
(54, 3, NULL, 6, '2025-10-05', '2025-10-28', '2025-10-04 17:42:12', 'Cancelled', '78815', NULL),
(55, 5, 'REG-5-001', 6, '2025-10-04', '2025-10-13', '2025-10-04 18:35:05', 'Cancelled', NULL, NULL),
(56, 5, 'REG-5-002', 6, '2025-10-23', '2025-10-25', '2025-10-04 18:39:28', 'Cancelled', NULL, NULL),
(57, 5, NULL, 6, '2025-10-04', '2025-10-08', '2025-10-04 18:50:37', 'Cancelled', '14155', 129),
(58, 6, NULL, 6, '2025-10-04', '2025-10-14', '2025-10-04 18:52:53', 'Cancelled', '14115', 130),
(59, 6, NULL, 6, '2025-10-06', '2025-10-13', '2025-10-06 11:05:42', 'Cancelled', '155', 131),
(60, 5, NULL, 6, '2025-10-06', '2025-10-07', '2025-10-06 11:07:10', 'Cancelled', '15151', 129),
(61, 5, NULL, 6, '2025-10-06', '2025-10-07', '2025-10-06 11:07:36', 'Cancelled', '8915', 129),
(62, 5, NULL, 6, '2025-10-06', '2025-10-07', '2025-10-06 11:07:49', 'Cancelled', '74814', 129),
(63, 5, NULL, 6, '2025-10-08', '2025-10-09', '2025-10-06 11:08:03', 'Cancelled', '7151', 129),
(64, 5, NULL, 6, '2025-10-08', '2025-10-09', '2025-10-06 11:15:56', 'Cancelled', '7418518', 127),
(65, 5, NULL, 6, '2025-10-06', '2025-10-08', '2025-10-06 11:17:05', 'Approved', '7415481', 127),
(66, 5, NULL, 6, '2025-10-06', '2025-10-08', '2025-10-06 11:17:18', 'Approved', '815', 128),
(67, 5, NULL, 6, '2025-10-06', '2025-10-08', '2025-10-06 11:17:33', 'Approved', '714', 129),
(68, 5, NULL, 6, '2025-10-09', '2025-10-11', '2025-10-06 11:18:52', 'Approved', '714', 127),
(69, 5, NULL, 6, '2025-10-10', '2025-10-17', '2025-10-06 11:19:09', 'Approved', '74141', 128),
(70, 5, NULL, 6, '2025-10-09', '2025-10-09', '2025-10-06 11:28:25', 'Cancelled', NULL, 127),
(71, 5, NULL, 8, '2025-10-10', '2025-10-12', '2025-10-06 11:29:51', 'Approved', '7415', 129),
(72, 5, NULL, 8, '2025-10-09', '2025-10-09', '2025-10-06 11:30:06', 'Cancelled', '7418', 128),
(73, 1, NULL, 8, '2025-10-06', '2025-10-14', '2025-10-06 11:32:07', 'Cancelled', '989', 1),
(74, 2, NULL, 8, '2025-10-09', '2025-10-10', '2025-10-06 11:37:36', 'Approved', '21515', 44),
(75, 2, NULL, 8, '2025-10-06', '2025-10-07', '2025-10-06 11:40:46', 'Cancelled', '7481', 44);

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

--
-- Table structure for table `cars`
--

CREATE TABLE `cars` (
  `car_id` int(11) NOT NULL,
  `car_name` varchar(100) NOT NULL,
  `car_model` varchar(100) DEFAULT NULL,
  `price_per_day` decimal(10,2) DEFAULT NULL,
  `image_url` varchar(255) DEFAULT NULL,
  `quantity` int(11) DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `cars`
--

INSERT INTO `cars` (`car_id`, `car_name`, `car_model`, `price_per_day`, `image_url`, `quantity`) VALUES
(1, 'Maruti Swift', '2020', 1500.00, 'car1.jpeg', 43),
(2, 'Hyundai i20', '2019', 1600.00, 'car2.jpeg', 56),
(3, 'Honda City', '2018', 2200.00, 'car3.jpeg', 23),
(4, 'Toyota Innova', '2023', 3000.00, 'car4.jpeg', 4),
(5, 'Hyundai Creta EV', '2025', 2500.00, 'car5.jpeg', 3),
(6, 'Tata Safari', '2024', 3100.00, 'car6.jpeg', 9),
(7, 'Tata Punch CNG', '2024', 2400.00, 'car7.jpeg', 17);

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

--
-- Table structure for table `car_inventory`
--

CREATE TABLE `car_inventory` (
  `inventory_id` int(11) NOT NULL,
  `car_id` int(11) NOT NULL,
  `car_name` varchar(100) DEFAULT NULL,
  `car_model` year(4) DEFAULT NULL,
  `registration_number` varchar(20) DEFAULT NULL,
  `price_per_day` decimal(10,2) DEFAULT NULL,
  `image_url` varchar(255) DEFAULT NULL,
  `status` enum('Available','Booked') DEFAULT 'Available'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `car_inventory`
--

INSERT INTO `car_inventory` (`inventory_id`, `car_id`, `car_name`, `car_model`, `registration_number`, `price_per_day`, `image_url`, `status`) VALUES
(1, 1, 'Maruti Swift', '2020', 'REG-1-001', 1500.00, 'car1.jpeg', 'Available'),
(2, 1, 'Maruti Swift', '2020', 'REG-1-002', 1500.00, 'car1.jpeg', 'Available'),
(3, 1, 'Maruti Swift', '2020', 'REG-1-003', 1500.00, 'car1.jpeg', 'Available'),
(4, 1, 'Maruti Swift', '2020', 'REG-1-004', 1500.00, 'car1.jpeg', 'Available'),
(5, 1, 'Maruti Swift', '2020', 'REG-1-005', 1500.00, 'car1.jpeg', 'Available'),
(6, 1, 'Maruti Swift', '2020', 'REG-1-006', 1500.00, 'car1.jpeg', 'Available'),
(7, 1, 'Maruti Swift', '2020', 'REG-1-007', 1500.00, 'car1.jpeg', 'Available'),
(8, 1, 'Maruti Swift', '2020', 'REG-1-008', 1500.00, 'car1.jpeg', 'Available'),
(9, 1, 'Maruti Swift', '2020', 'REG-1-009', 1500.00, 'car1.jpeg', 'Available'),
(10, 1, 'Maruti Swift', '2020', 'REG-1-010', 1500.00, 'car1.jpeg', 'Available'),
(11, 1, 'Maruti Swift', '2020', 'REG-1-011', 1500.00, 'car1.jpeg', 'Available'),
(12, 1, 'Maruti Swift', '2020', 'REG-1-012', 1500.00, 'car1.jpeg', 'Available'),
(13, 1, 'Maruti Swift', '2020', 'REG-1-013', 1500.00, 'car1.jpeg', 'Available'),
(14, 1, 'Maruti Swift', '2020', 'REG-1-014', 1500.00, 'car1.jpeg', 'Available'),
(15, 1, 'Maruti Swift', '2020', 'REG-1-015', 1500.00, 'car1.jpeg', 'Available'),
(16, 1, 'Maruti Swift', '2020', 'REG-1-016', 1500.00, 'car1.jpeg', 'Available'),
(17, 1, 'Maruti Swift', '2020', 'REG-1-017', 1500.00, 'car1.jpeg', 'Available'),
(18, 1, 'Maruti Swift', '2020', 'REG-1-018', 1500.00, 'car1.jpeg', 'Available'),
(19, 1, 'Maruti Swift', '2020', 'REG-1-019', 1500.00, 'car1.jpeg', 'Available'),
(20, 1, 'Maruti Swift', '2020', 'REG-1-020', 1500.00, 'car1.jpeg', 'Available'),
(21, 1, 'Maruti Swift', '2020', 'REG-1-021', 1500.00, 'car1.jpeg', 'Available'),
(22, 1, 'Maruti Swift', '2020', 'REG-1-022', 1500.00, 'car1.jpeg', 'Available'),
(23, 1, 'Maruti Swift', '2020', 'REG-1-023', 1500.00, 'car1.jpeg', 'Available'),
(24, 1, 'Maruti Swift', '2020', 'REG-1-024', 1500.00, 'car1.jpeg', 'Available'),
(25, 1, 'Maruti Swift', '2020', 'REG-1-025', 1500.00, 'car1.jpeg', 'Available'),
(26, 1, 'Maruti Swift', '2020', 'REG-1-026', 1500.00, 'car1.jpeg', 'Available'),
(27, 1, 'Maruti Swift', '2020', 'REG-1-027', 1500.00, 'car1.jpeg', 'Available'),
(28, 1, 'Maruti Swift', '2020', 'REG-1-028', 1500.00, 'car1.jpeg', 'Available'),
(29, 1, 'Maruti Swift', '2020', 'REG-1-029', 1500.00, 'car1.jpeg', 'Available'),
(30, 1, 'Maruti Swift', '2020', 'REG-1-030', 1500.00, 'car1.jpeg', 'Available'),
(31, 1, 'Maruti Swift', '2020', 'REG-1-031', 1500.00, 'car1.jpeg', 'Available'),
(32, 1, 'Maruti Swift', '2020', 'REG-1-032', 1500.00, 'car1.jpeg', 'Available'),
(33, 1, 'Maruti Swift', '2020', 'REG-1-033', 1500.00, 'car1.jpeg', 'Available'),
(34, 1, 'Maruti Swift', '2020', 'REG-1-034', 1500.00, 'car1.jpeg', 'Available'),
(35, 1, 'Maruti Swift', '2020', 'REG-1-035', 1500.00, 'car1.jpeg', 'Available'),
(36, 1, 'Maruti Swift', '2020', 'REG-1-036', 1500.00, 'car1.jpeg', 'Available'),
(37, 1, 'Maruti Swift', '2020', 'REG-1-037', 1500.00, 'car1.jpeg', 'Available'),
(38, 1, 'Maruti Swift', '2020', 'REG-1-038', 1500.00, 'car1.jpeg', 'Available'),
(39, 1, 'Maruti Swift', '2020', 'REG-1-039', 1500.00, 'car1.jpeg', 'Available'),
(40, 1, 'Maruti Swift', '2020', 'REG-1-040', 1500.00, 'car1.jpeg', 'Available'),
(41, 1, 'Maruti Swift', '2020', 'REG-1-041', 1500.00, 'car1.jpeg', 'Available'),
(42, 1, 'Maruti Swift', '2020', 'REG-1-042', 1500.00, 'car1.jpeg', 'Available'),
(43, 1, 'Maruti Swift', '2020', 'REG-1-043', 1500.00, 'car1.jpeg', 'Available'),
(44, 2, 'Hyundai i20', '2019', 'REG-2-001', 1600.00, 'car2.jpeg', 'Available'),
(45, 2, 'Hyundai i20', '2019', 'REG-2-002', 1600.00, 'car2.jpeg', 'Available'),
(46, 2, 'Hyundai i20', '2019', 'REG-2-003', 1600.00, 'car2.jpeg', 'Available'),
(47, 2, 'Hyundai i20', '2019', 'REG-2-004', 1600.00, 'car2.jpeg', 'Available'),
(48, 2, 'Hyundai i20', '2019', 'REG-2-005', 1600.00, 'car2.jpeg', 'Available'),
(49, 2, 'Hyundai i20', '2019', 'REG-2-006', 1600.00, 'car2.jpeg', 'Available'),
(50, 2, 'Hyundai i20', '2019', 'REG-2-007', 1600.00, 'car2.jpeg', 'Available'),
(51, 2, 'Hyundai i20', '2019', 'REG-2-008', 1600.00, 'car2.jpeg', 'Available'),
(52, 2, 'Hyundai i20', '2019', 'REG-2-009', 1600.00, 'car2.jpeg', 'Available'),
(53, 2, 'Hyundai i20', '2019', 'REG-2-010', 1600.00, 'car2.jpeg', 'Available'),
(54, 2, 'Hyundai i20', '2019', 'REG-2-011', 1600.00, 'car2.jpeg', 'Available'),
(55, 2, 'Hyundai i20', '2019', 'REG-2-012', 1600.00, 'car2.jpeg', 'Available'),
(56, 2, 'Hyundai i20', '2019', 'REG-2-013', 1600.00, 'car2.jpeg', 'Available'),
(57, 2, 'Hyundai i20', '2019', 'REG-2-014', 1600.00, 'car2.jpeg', 'Available'),
(58, 2, 'Hyundai i20', '2019', 'REG-2-015', 1600.00, 'car2.jpeg', 'Available'),
(59, 2, 'Hyundai i20', '2019', 'REG-2-016', 1600.00, 'car2.jpeg', 'Available'),
(60, 2, 'Hyundai i20', '2019', 'REG-2-017', 1600.00, 'car2.jpeg', 'Available'),
(61, 2, 'Hyundai i20', '2019', 'REG-2-018', 1600.00, 'car2.jpeg', 'Available'),
(62, 2, 'Hyundai i20', '2019', 'REG-2-019', 1600.00, 'car2.jpeg', 'Available'),
(63, 2, 'Hyundai i20', '2019', 'REG-2-020', 1600.00, 'car2.jpeg', 'Available'),
(64, 2, 'Hyundai i20', '2019', 'REG-2-021', 1600.00, 'car2.jpeg', 'Available'),
(65, 2, 'Hyundai i20', '2019', 'REG-2-022', 1600.00, 'car2.jpeg', 'Available'),
(66, 2, 'Hyundai i20', '2019', 'REG-2-023', 1600.00, 'car2.jpeg', 'Available'),
(67, 2, 'Hyundai i20', '2019', 'REG-2-024', 1600.00, 'car2.jpeg', 'Available'),
(68, 2, 'Hyundai i20', '2019', 'REG-2-025', 1600.00, 'car2.jpeg', 'Available'),
(69, 2, 'Hyundai i20', '2019', 'REG-2-026', 1600.00, 'car2.jpeg', 'Available'),
(70, 2, 'Hyundai i20', '2019', 'REG-2-027', 1600.00, 'car2.jpeg', 'Available'),
(71, 2, 'Hyundai i20', '2019', 'REG-2-028', 1600.00, 'car2.jpeg', 'Available'),
(72, 2, 'Hyundai i20', '2019', 'REG-2-029', 1600.00, 'car2.jpeg', 'Available'),
(73, 2, 'Hyundai i20', '2019', 'REG-2-030', 1600.00, 'car2.jpeg', 'Available'),
(74, 2, 'Hyundai i20', '2019', 'REG-2-031', 1600.00, 'car2.jpeg', 'Available'),
(75, 2, 'Hyundai i20', '2019', 'REG-2-032', 1600.00, 'car2.jpeg', 'Available'),
(76, 2, 'Hyundai i20', '2019', 'REG-2-033', 1600.00, 'car2.jpeg', 'Available'),
(77, 2, 'Hyundai i20', '2019', 'REG-2-034', 1600.00, 'car2.jpeg', 'Available'),
(78, 2, 'Hyundai i20', '2019', 'REG-2-035', 1600.00, 'car2.jpeg', 'Available'),
(79, 2, 'Hyundai i20', '2019', 'REG-2-036', 1600.00, 'car2.jpeg', 'Available'),
(80, 2, 'Hyundai i20', '2019', 'REG-2-037', 1600.00, 'car2.jpeg', 'Available'),
(81, 2, 'Hyundai i20', '2019', 'REG-2-038', 1600.00, 'car2.jpeg', 'Available'),
(82, 2, 'Hyundai i20', '2019', 'REG-2-039', 1600.00, 'car2.jpeg', 'Available'),
(83, 2, 'Hyundai i20', '2019', 'REG-2-040', 1600.00, 'car2.jpeg', 'Available'),
(84, 2, 'Hyundai i20', '2019', 'REG-2-041', 1600.00, 'car2.jpeg', 'Available'),
(85, 2, 'Hyundai i20', '2019', 'REG-2-042', 1600.00, 'car2.jpeg', 'Available'),
(86, 2, 'Hyundai i20', '2019', 'REG-2-043', 1600.00, 'car2.jpeg', 'Available'),
(87, 2, 'Hyundai i20', '2019', 'REG-2-044', 1600.00, 'car2.jpeg', 'Available'),
(88, 2, 'Hyundai i20', '2019', 'REG-2-045', 1600.00, 'car2.jpeg', 'Available'),
(89, 2, 'Hyundai i20', '2019', 'REG-2-046', 1600.00, 'car2.jpeg', 'Available'),
(90, 2, 'Hyundai i20', '2019', 'REG-2-047', 1600.00, 'car2.jpeg', 'Available'),
(91, 2, 'Hyundai i20', '2019', 'REG-2-048', 1600.00, 'car2.jpeg', 'Available'),
(92, 2, 'Hyundai i20', '2019', 'REG-2-049', 1600.00, 'car2.jpeg', 'Available'),
(93, 2, 'Hyundai i20', '2019', 'REG-2-050', 1600.00, 'car2.jpeg', 'Available'),
(94, 2, 'Hyundai i20', '2019', 'REG-2-051', 1600.00, 'car2.jpeg', 'Available'),
(95, 2, 'Hyundai i20', '2019', 'REG-2-052', 1600.00, 'car2.jpeg', 'Available'),
(96, 2, 'Hyundai i20', '2019', 'REG-2-053', 1600.00, 'car2.jpeg', 'Available'),
(97, 2, 'Hyundai i20', '2019', 'REG-2-054', 1600.00, 'car2.jpeg', 'Available'),
(98, 2, 'Hyundai i20', '2019', 'REG-2-055', 1600.00, 'car2.jpeg', 'Available'),
(99, 2, 'Hyundai i20', '2019', 'REG-2-056', 1600.00, 'car2.jpeg', 'Available'),
(100, 3, 'Honda City', '2018', 'REG-3-001', 2200.00, 'car3.jpeg', 'Available'),
(101, 3, 'Honda City', '2018', 'REG-3-002', 2200.00, 'car3.jpeg', 'Available'),
(102, 3, 'Honda City', '2018', 'REG-3-003', 2200.00, 'car3.jpeg', 'Available'),
(103, 3, 'Honda City', '2018', 'REG-3-004', 2200.00, 'car3.jpeg', 'Available'),
(104, 3, 'Honda City', '2018', 'REG-3-005', 2200.00, 'car3.jpeg', 'Available'),
(105, 3, 'Honda City', '2018', 'REG-3-006', 2200.00, 'car3.jpeg', 'Available'),
(106, 3, 'Honda City', '2018', 'REG-3-007', 2200.00, 'car3.jpeg', 'Available'),
(107, 3, 'Honda City', '2018', 'REG-3-008', 2200.00, 'car3.jpeg', 'Available'),
(108, 3, 'Honda City', '2018', 'REG-3-009', 2200.00, 'car3.jpeg', 'Available'),
(109, 3, 'Honda City', '2018', 'REG-3-010', 2200.00, 'car3.jpeg', 'Available'),
(110, 3, 'Honda City', '2018', 'REG-3-011', 2200.00, 'car3.jpeg', 'Available'),
(111, 3, 'Honda City', '2018', 'REG-3-012', 2200.00, 'car3.jpeg', 'Available'),
(112, 3, 'Honda City', '2018', 'REG-3-013', 2200.00, 'car3.jpeg', 'Available'),
(113, 3, 'Honda City', '2018', 'REG-3-014', 2200.00, 'car3.jpeg', 'Available'),
(114, 3, 'Honda City', '2018', 'REG-3-015', 2200.00, 'car3.jpeg', 'Available'),
(115, 3, 'Honda City', '2018', 'REG-3-016', 2200.00, 'car3.jpeg', 'Available'),
(116, 3, 'Honda City', '2018', 'REG-3-017', 2200.00, 'car3.jpeg', 'Available'),
(117, 3, 'Honda City', '2018', 'REG-3-018', 2200.00, 'car3.jpeg', 'Available'),
(118, 3, 'Honda City', '2018', 'REG-3-019', 2200.00, 'car3.jpeg', 'Available'),
(119, 3, 'Honda City', '2018', 'REG-3-020', 2200.00, 'car3.jpeg', 'Available'),
(120, 3, 'Honda City', '2018', 'REG-3-021', 2200.00, 'car3.jpeg', 'Available'),
(121, 3, 'Honda City', '2018', 'REG-3-022', 2200.00, 'car3.jpeg', 'Available'),
(122, 3, 'Honda City', '2018', 'REG-3-023', 2200.00, 'car3.jpeg', 'Available'),
(123, 4, 'Toyota Innova', '2023', 'REG-4-001', 3000.00, 'car4.jpeg', 'Available'),
(124, 4, 'Toyota Innova', '2023', 'REG-4-002', 3000.00, 'car4.jpeg', 'Available'),
(125, 4, 'Toyota Innova', '2023', 'REG-4-003', 3000.00, 'car4.jpeg', 'Available'),
(126, 4, 'Toyota Innova', '2023', 'REG-4-004', 3000.00, 'car4.jpeg', 'Available'),
(127, 5, 'Hyundai Creta EV', '2025', 'REG-5-001', 2500.00, 'car5.jpeg', 'Available'),
(128, 5, 'Hyundai Creta EV', '2025', 'REG-5-002', 2500.00, 'car5.jpeg', 'Booked'),
(129, 5, 'Hyundai Creta EV', '2025', 'REG-5-003', 2500.00, 'car5.jpeg', 'Available'),
(130, 6, 'Tata Safari', '2024', 'REG-6-001', 3100.00, 'car6.jpeg', 'Available'),
(131, 6, 'Tata Safari', '2024', 'REG-6-002', 3100.00, 'car6.jpeg', 'Available'),
(132, 6, 'Tata Safari', '2024', 'REG-6-003', 3100.00, 'car6.jpeg', 'Available'),
(133, 6, 'Tata Safari', '2024', 'REG-6-004', 3100.00, 'car6.jpeg', 'Available'),
(134, 6, 'Tata Safari', '2024', 'REG-6-005', 3100.00, 'car6.jpeg', 'Available'),
(135, 6, 'Tata Safari', '2024', 'REG-6-006', 3100.00, 'car6.jpeg', 'Available'),
(136, 6, 'Tata Safari', '2024', 'REG-6-007', 3100.00, 'car6.jpeg', 'Available'),
(137, 6, 'Tata Safari', '2024', 'REG-6-008', 3100.00, 'car6.jpeg', 'Available'),
(138, 6, 'Tata Safari', '2024', 'REG-6-009', 3100.00, 'car6.jpeg', 'Available'),
(139, 7, 'Tata Punch CNG', '2024', 'REG-7-001', 2400.00, 'car7.jpeg', 'Available'),
(140, 7, 'Tata Punch CNG', '2024', 'REG-7-002', 2400.00, 'car7.jpeg', 'Available'),
(141, 7, 'Tata Punch CNG', '2024', 'REG-7-003', 2400.00, 'car7.jpeg', 'Available'),
(142, 7, 'Tata Punch CNG', '2024', 'REG-7-004', 2400.00, 'car7.jpeg', 'Available'),
(143, 7, 'Tata Punch CNG', '2024', 'REG-7-005', 2400.00, 'car7.jpeg', 'Available'),
(144, 7, 'Tata Punch CNG', '2024', 'REG-7-006', 2400.00, 'car7.jpeg', 'Available'),
(145, 7, 'Tata Punch CNG', '2024', 'REG-7-007', 2400.00, 'car7.jpeg', 'Available'),
(146, 7, 'Tata Punch CNG', '2024', 'REG-7-008', 2400.00, 'car7.jpeg', 'Available'),
(147, 7, 'Tata Punch CNG', '2024', 'REG-7-009', 2400.00, 'car7.jpeg', 'Available'),
(148, 7, 'Tata Punch CNG', '2024', 'REG-7-010', 2400.00, 'car7.jpeg', 'Available'),
(149, 7, 'Tata Punch CNG', '2024', 'REG-7-011', 2400.00, 'car7.jpeg', 'Available'),
(150, 7, 'Tata Punch CNG', '2024', 'REG-7-012', 2400.00, 'car7.jpeg', 'Available'),
(151, 7, 'Tata Punch CNG', '2024', 'REG-7-013', 2400.00, 'car7.jpeg', 'Available'),
(152, 7, 'Tata Punch CNG', '2024', 'REG-7-014', 2400.00, 'car7.jpeg', 'Available'),
(153, 7, 'Tata Punch CNG', '2024', 'REG-7-015', 2400.00, 'car7.jpeg', 'Available'),
(154, 7, 'Tata Punch CNG', '2024', 'REG-7-016', 2400.00, 'car7.jpeg', 'Available'),
(155, 7, 'Tata Punch CNG', '2024', 'REG-7-017', 2400.00, 'car7.jpeg', 'Available');

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

--
-- Table structure for table `customers`
--

CREATE TABLE `customers` (
  `customer_id` int(11) NOT NULL,
  `name` varchar(100) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `customers`
--

INSERT INTO `customers` (`customer_id`, `name`, `email`, `phone`, `password`) VALUES
(6, 'Shreyasi Mitra', 'shreyasi@gmail.com', '7439509442', '123'),
(7, 'Shubhojeet Ghosh', 'sg@gmail.com', '7439013721', '123'),
(8, 'Monu', 'm@gmail.com', '999999999', '123');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `admin`
--
ALTER TABLE `admin`
  ADD PRIMARY KEY (`admin_id`),
  ADD UNIQUE KEY `username` (`username`);

--
-- Indexes for table `bookings`
--
ALTER TABLE `bookings`
  ADD PRIMARY KEY (`booking_id`),
  ADD KEY `car_id` (`car_id`),
  ADD KEY `customer_id` (`customer_id`);

--
-- Indexes for table `cars`
--
ALTER TABLE `cars`
  ADD PRIMARY KEY (`car_id`);

--
-- Indexes for table `car_inventory`
--
ALTER TABLE `car_inventory`
  ADD PRIMARY KEY (`inventory_id`),
  ADD UNIQUE KEY `registration_number` (`registration_number`),
  ADD KEY `car_id` (`car_id`);

--
-- Indexes for table `customers`
--
ALTER TABLE `customers`
  ADD PRIMARY KEY (`customer_id`),
  ADD UNIQUE KEY `email` (`email`);

--
-- AUTO_INCREMENT for dumped tables
--

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

--
-- AUTO_INCREMENT for table `bookings`
--
ALTER TABLE `bookings`
  MODIFY `booking_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=76;

--
-- AUTO_INCREMENT for table `cars`
--
ALTER TABLE `cars`
  MODIFY `car_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `car_inventory`
--
ALTER TABLE `car_inventory`
  MODIFY `inventory_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=156;

--
-- AUTO_INCREMENT for table `customers`
--
ALTER TABLE `customers`
  MODIFY `customer_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `bookings`
--
ALTER TABLE `bookings`
  ADD CONSTRAINT `bookings_ibfk_1` FOREIGN KEY (`car_id`) REFERENCES `cars` (`car_id`),
  ADD CONSTRAINT `bookings_ibfk_2` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`customer_id`);

--
-- Constraints for table `car_inventory`
--
ALTER TABLE `car_inventory`
  ADD CONSTRAINT `car_inventory_ibfk_1` FOREIGN KEY (`car_id`) REFERENCES `cars` (`car_id`);
--
-- Database: `phpmyadmin`
--
CREATE DATABASE IF NOT EXISTS `phpmyadmin` DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
USE `phpmyadmin`;

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

--
-- Table structure for table `pma__bookmark`
--

CREATE TABLE `pma__bookmark` (
  `id` int(10) UNSIGNED NOT NULL,
  `dbase` varchar(255) NOT NULL DEFAULT '',
  `user` varchar(255) NOT NULL DEFAULT '',
  `label` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
  `query` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Bookmarks';

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

--
-- Table structure for table `pma__central_columns`
--

CREATE TABLE `pma__central_columns` (
  `db_name` varchar(64) NOT NULL,
  `col_name` varchar(64) NOT NULL,
  `col_type` varchar(64) NOT NULL,
  `col_length` text DEFAULT NULL,
  `col_collation` varchar(64) NOT NULL,
  `col_isNull` tinyint(1) NOT NULL,
  `col_extra` varchar(255) DEFAULT '',
  `col_default` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Central list of columns';

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

--
-- Table structure for table `pma__column_info`
--

CREATE TABLE `pma__column_info` (
  `id` int(5) UNSIGNED NOT NULL,
  `db_name` varchar(64) NOT NULL DEFAULT '',
  `table_name` varchar(64) NOT NULL DEFAULT '',
  `column_name` varchar(64) NOT NULL DEFAULT '',
  `comment` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
  `mimetype` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
  `transformation` varchar(255) NOT NULL DEFAULT '',
  `transformation_options` varchar(255) NOT NULL DEFAULT '',
  `input_transformation` varchar(255) NOT NULL DEFAULT '',
  `input_transformation_options` varchar(255) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Column information for phpMyAdmin';

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

--
-- Table structure for table `pma__designer_settings`
--

CREATE TABLE `pma__designer_settings` (
  `username` varchar(64) NOT NULL,
  `settings_data` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Settings related to Designer';

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

--
-- Table structure for table `pma__export_templates`
--

CREATE TABLE `pma__export_templates` (
  `id` int(5) UNSIGNED NOT NULL,
  `username` varchar(64) NOT NULL,
  `export_type` varchar(10) NOT NULL,
  `template_name` varchar(64) NOT NULL,
  `template_data` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Saved export templates';

--
-- Dumping data for table `pma__export_templates`
--

INSERT INTO `pma__export_templates` (`id`, `username`, `export_type`, `template_name`, `template_data`) VALUES
(1, 'root', 'server', 'car_rental', '{\"quick_or_custom\":\"quick\",\"what\":\"sql\",\"db_select[]\":[\"car_rental\",\"phpmyadmin\",\"test\"],\"aliases_new\":\"\",\"output_format\":\"sendit\",\"filename_template\":\"@SERVER@\",\"remember_template\":\"on\",\"charset\":\"utf-8\",\"compression\":\"none\",\"maxsize\":\"\",\"codegen_structure_or_data\":\"data\",\"codegen_format\":\"0\",\"csv_separator\":\",\",\"csv_enclosed\":\"\\\"\",\"csv_escaped\":\"\\\"\",\"csv_terminated\":\"AUTO\",\"csv_null\":\"NULL\",\"csv_columns\":\"something\",\"csv_structure_or_data\":\"data\",\"excel_null\":\"NULL\",\"excel_columns\":\"something\",\"excel_edition\":\"win\",\"excel_structure_or_data\":\"data\",\"json_structure_or_data\":\"data\",\"json_unicode\":\"something\",\"latex_caption\":\"something\",\"latex_structure_or_data\":\"structure_and_data\",\"latex_structure_caption\":\"Structure of table @TABLE@\",\"latex_structure_continued_caption\":\"Structure of table @TABLE@ (continued)\",\"latex_structure_label\":\"tab:@TABLE@-structure\",\"latex_relation\":\"something\",\"latex_comments\":\"something\",\"latex_mime\":\"something\",\"latex_columns\":\"something\",\"latex_data_caption\":\"Content of table @TABLE@\",\"latex_data_continued_caption\":\"Content of table @TABLE@ (continued)\",\"latex_data_label\":\"tab:@TABLE@-data\",\"latex_null\":\"\\\\textit{NULL}\",\"mediawiki_structure_or_data\":\"data\",\"mediawiki_caption\":\"something\",\"mediawiki_headers\":\"something\",\"htmlword_structure_or_data\":\"structure_and_data\",\"htmlword_null\":\"NULL\",\"ods_null\":\"NULL\",\"ods_structure_or_data\":\"data\",\"odt_structure_or_data\":\"structure_and_data\",\"odt_relation\":\"something\",\"odt_comments\":\"something\",\"odt_mime\":\"something\",\"odt_columns\":\"something\",\"odt_null\":\"NULL\",\"pdf_report_title\":\"\",\"pdf_structure_or_data\":\"data\",\"phparray_structure_or_data\":\"data\",\"sql_include_comments\":\"something\",\"sql_header_comment\":\"\",\"sql_use_transaction\":\"something\",\"sql_compatibility\":\"NONE\",\"sql_structure_or_data\":\"structure_and_data\",\"sql_create_table\":\"something\",\"sql_auto_increment\":\"something\",\"sql_create_view\":\"something\",\"sql_create_trigger\":\"something\",\"sql_backquotes\":\"something\",\"sql_type\":\"INSERT\",\"sql_insert_syntax\":\"both\",\"sql_max_query_size\":\"50000\",\"sql_hex_for_binary\":\"something\",\"sql_utc_time\":\"something\",\"texytext_structure_or_data\":\"structure_and_data\",\"texytext_null\":\"NULL\",\"yaml_structure_or_data\":\"data\",\"\":null,\"as_separate_files\":null,\"csv_removeCRLF\":null,\"excel_removeCRLF\":null,\"json_pretty_print\":null,\"htmlword_columns\":null,\"ods_columns\":null,\"sql_dates\":null,\"sql_relation\":null,\"sql_mime\":null,\"sql_disable_fk\":null,\"sql_views_as_tables\":null,\"sql_metadata\":null,\"sql_drop_database\":null,\"sql_drop_table\":null,\"sql_if_not_exists\":null,\"sql_simple_view_export\":null,\"sql_view_current_user\":null,\"sql_or_replace_view\":null,\"sql_procedure_function\":null,\"sql_truncate\":null,\"sql_delayed\":null,\"sql_ignore\":null,\"texytext_columns\":null}');

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

--
-- Table structure for table `pma__favorite`
--

CREATE TABLE `pma__favorite` (
  `username` varchar(64) NOT NULL,
  `tables` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Favorite tables';

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

--
-- Table structure for table `pma__history`
--

CREATE TABLE `pma__history` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `username` varchar(64) NOT NULL DEFAULT '',
  `db` varchar(64) NOT NULL DEFAULT '',
  `table` varchar(64) NOT NULL DEFAULT '',
  `timevalue` timestamp NOT NULL DEFAULT current_timestamp(),
  `sqlquery` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='SQL history for phpMyAdmin';

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

--
-- Table structure for table `pma__navigationhiding`
--

CREATE TABLE `pma__navigationhiding` (
  `username` varchar(64) NOT NULL,
  `item_name` varchar(64) NOT NULL,
  `item_type` varchar(64) NOT NULL,
  `db_name` varchar(64) NOT NULL,
  `table_name` varchar(64) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Hidden items of navigation tree';

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

--
-- Table structure for table `pma__pdf_pages`
--

CREATE TABLE `pma__pdf_pages` (
  `db_name` varchar(64) NOT NULL DEFAULT '',
  `page_nr` int(10) UNSIGNED NOT NULL,
  `page_descr` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='PDF relation pages for phpMyAdmin';

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

--
-- Table structure for table `pma__recent`
--

CREATE TABLE `pma__recent` (
  `username` varchar(64) NOT NULL,
  `tables` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Recently accessed tables';

--
-- Dumping data for table `pma__recent`
--

INSERT INTO `pma__recent` (`username`, `tables`) VALUES
('root', '[{\"db\":\"car_rental\",\"table\":\"cars\"},{\"db\":\"car_rental\",\"table\":\"bookings\"},{\"db\":\"car_rental\",\"table\":\"car_inventory\"},{\"db\":\"car_rental\",\"table\":\"customers\"},{\"db\":\"car_rental\",\"table\":\"admin\"}]');

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

--
-- Table structure for table `pma__relation`
--

CREATE TABLE `pma__relation` (
  `master_db` varchar(64) NOT NULL DEFAULT '',
  `master_table` varchar(64) NOT NULL DEFAULT '',
  `master_field` varchar(64) NOT NULL DEFAULT '',
  `foreign_db` varchar(64) NOT NULL DEFAULT '',
  `foreign_table` varchar(64) NOT NULL DEFAULT '',
  `foreign_field` varchar(64) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Relation table';

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

--
-- Table structure for table `pma__savedsearches`
--

CREATE TABLE `pma__savedsearches` (
  `id` int(5) UNSIGNED NOT NULL,
  `username` varchar(64) NOT NULL DEFAULT '',
  `db_name` varchar(64) NOT NULL DEFAULT '',
  `search_name` varchar(64) NOT NULL DEFAULT '',
  `search_data` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Saved searches';

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

--
-- Table structure for table `pma__table_coords`
--

CREATE TABLE `pma__table_coords` (
  `db_name` varchar(64) NOT NULL DEFAULT '',
  `table_name` varchar(64) NOT NULL DEFAULT '',
  `pdf_page_number` int(11) NOT NULL DEFAULT 0,
  `x` float UNSIGNED NOT NULL DEFAULT 0,
  `y` float UNSIGNED NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Table coordinates for phpMyAdmin PDF output';

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

--
-- Table structure for table `pma__table_info`
--

CREATE TABLE `pma__table_info` (
  `db_name` varchar(64) NOT NULL DEFAULT '',
  `table_name` varchar(64) NOT NULL DEFAULT '',
  `display_field` varchar(64) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Table information for phpMyAdmin';

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

--
-- Table structure for table `pma__table_uiprefs`
--

CREATE TABLE `pma__table_uiprefs` (
  `username` varchar(64) NOT NULL,
  `db_name` varchar(64) NOT NULL,
  `table_name` varchar(64) NOT NULL,
  `prefs` text NOT NULL,
  `last_update` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Tables'' UI preferences';

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

--
-- Table structure for table `pma__tracking`
--

CREATE TABLE `pma__tracking` (
  `db_name` varchar(64) NOT NULL,
  `table_name` varchar(64) NOT NULL,
  `version` int(10) UNSIGNED NOT NULL,
  `date_created` datetime NOT NULL,
  `date_updated` datetime NOT NULL,
  `schema_snapshot` text NOT NULL,
  `schema_sql` text DEFAULT NULL,
  `data_sql` longtext DEFAULT NULL,
  `tracking` set('UPDATE','REPLACE','INSERT','DELETE','TRUNCATE','CREATE DATABASE','ALTER DATABASE','DROP DATABASE','CREATE TABLE','ALTER TABLE','RENAME TABLE','DROP TABLE','CREATE INDEX','DROP INDEX','CREATE VIEW','ALTER VIEW','DROP VIEW') DEFAULT NULL,
  `tracking_active` int(1) UNSIGNED NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Database changes tracking for phpMyAdmin';

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

--
-- Table structure for table `pma__userconfig`
--

CREATE TABLE `pma__userconfig` (
  `username` varchar(64) NOT NULL,
  `timevalue` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `config_data` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='User preferences storage for phpMyAdmin';

--
-- Dumping data for table `pma__userconfig`
--

INSERT INTO `pma__userconfig` (`username`, `timevalue`, `config_data`) VALUES
('root', '2025-10-08 15:34:39', '{\"Console\\/Mode\":\"collapse\"}');

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

--
-- Table structure for table `pma__usergroups`
--

CREATE TABLE `pma__usergroups` (
  `usergroup` varchar(64) NOT NULL,
  `tab` varchar(64) NOT NULL,
  `allowed` enum('Y','N') NOT NULL DEFAULT 'N'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='User groups with configured menu items';

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

--
-- Table structure for table `pma__users`
--

CREATE TABLE `pma__users` (
  `username` varchar(64) NOT NULL,
  `usergroup` varchar(64) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Users and their assignments to user groups';

--
-- Indexes for dumped tables
--

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

--
-- Indexes for table `pma__central_columns`
--
ALTER TABLE `pma__central_columns`
  ADD PRIMARY KEY (`db_name`,`col_name`);

--
-- Indexes for table `pma__column_info`
--
ALTER TABLE `pma__column_info`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `db_name` (`db_name`,`table_name`,`column_name`);

--
-- Indexes for table `pma__designer_settings`
--
ALTER TABLE `pma__designer_settings`
  ADD PRIMARY KEY (`username`);

--
-- Indexes for table `pma__export_templates`
--
ALTER TABLE `pma__export_templates`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `u_user_type_template` (`username`,`export_type`,`template_name`);

--
-- Indexes for table `pma__favorite`
--
ALTER TABLE `pma__favorite`
  ADD PRIMARY KEY (`username`);

--
-- Indexes for table `pma__history`
--
ALTER TABLE `pma__history`
  ADD PRIMARY KEY (`id`),
  ADD KEY `username` (`username`,`db`,`table`,`timevalue`);

--
-- Indexes for table `pma__navigationhiding`
--
ALTER TABLE `pma__navigationhiding`
  ADD PRIMARY KEY (`username`,`item_name`,`item_type`,`db_name`,`table_name`);

--
-- Indexes for table `pma__pdf_pages`
--
ALTER TABLE `pma__pdf_pages`
  ADD PRIMARY KEY (`page_nr`),
  ADD KEY `db_name` (`db_name`);

--
-- Indexes for table `pma__recent`
--
ALTER TABLE `pma__recent`
  ADD PRIMARY KEY (`username`);

--
-- Indexes for table `pma__relation`
--
ALTER TABLE `pma__relation`
  ADD PRIMARY KEY (`master_db`,`master_table`,`master_field`),
  ADD KEY `foreign_field` (`foreign_db`,`foreign_table`);

--
-- Indexes for table `pma__savedsearches`
--
ALTER TABLE `pma__savedsearches`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `u_savedsearches_username_dbname` (`username`,`db_name`,`search_name`);

--
-- Indexes for table `pma__table_coords`
--
ALTER TABLE `pma__table_coords`
  ADD PRIMARY KEY (`db_name`,`table_name`,`pdf_page_number`);

--
-- Indexes for table `pma__table_info`
--
ALTER TABLE `pma__table_info`
  ADD PRIMARY KEY (`db_name`,`table_name`);

--
-- Indexes for table `pma__table_uiprefs`
--
ALTER TABLE `pma__table_uiprefs`
  ADD PRIMARY KEY (`username`,`db_name`,`table_name`);

--
-- Indexes for table `pma__tracking`
--
ALTER TABLE `pma__tracking`
  ADD PRIMARY KEY (`db_name`,`table_name`,`version`);

--
-- Indexes for table `pma__userconfig`
--
ALTER TABLE `pma__userconfig`
  ADD PRIMARY KEY (`username`);

--
-- Indexes for table `pma__usergroups`
--
ALTER TABLE `pma__usergroups`
  ADD PRIMARY KEY (`usergroup`,`tab`,`allowed`);

--
-- Indexes for table `pma__users`
--
ALTER TABLE `pma__users`
  ADD PRIMARY KEY (`username`,`usergroup`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `pma__bookmark`
--
ALTER TABLE `pma__bookmark`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `pma__column_info`
--
ALTER TABLE `pma__column_info`
  MODIFY `id` int(5) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `pma__export_templates`
--
ALTER TABLE `pma__export_templates`
  MODIFY `id` int(5) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

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

--
-- AUTO_INCREMENT for table `pma__pdf_pages`
--
ALTER TABLE `pma__pdf_pages`
  MODIFY `page_nr` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `pma__savedsearches`
--
ALTER TABLE `pma__savedsearches`
  MODIFY `id` int(5) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- Database: `test`
--
CREATE DATABASE IF NOT EXISTS `test` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `test`;
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 */;