-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1:3306
-- Generation Time: Feb 12, 2025 at 07:43 AM
-- Server version: 8.3.0
-- PHP Version: 8.2.18

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

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

--
-- Table structure for table `admins`
--

DROP TABLE IF EXISTS `admins`;
CREATE TABLE IF NOT EXISTS `admins` (
  `id` int NOT NULL AUTO_INCREMENT,
  `username` varchar(50) NOT NULL,
  `password_hash` varchar(255) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `admins`
--

INSERT INTO `admins` (`id`, `username`, `password_hash`) VALUES
(5, 'admin', '$2y$10$xJp7PRGVhzrmg410irKFWuGS2Irp2.u86vOvPbXQVB7JNJMHGgo0u');

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

--
-- Table structure for table `daily_updates`
--

DROP TABLE IF EXISTS `daily_updates`;
CREATE TABLE IF NOT EXISTS `daily_updates` (
  `id` int NOT NULL AUTO_INCREMENT,
  `profile_link` varchar(255) NOT NULL,
  `update_text` text NOT NULL,
  `image_url` varchar(255) DEFAULT NULL,
  `update_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `profile_link` (`profile_link`(250))
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Table structure for table `users`
--

DROP TABLE IF EXISTS `users`;
CREATE TABLE IF NOT EXISTS `users` (
  `id` int NOT NULL AUTO_INCREMENT,
  `profile_link` varchar(200) NOT NULL,
  `battery` varchar(50) DEFAULT NULL,
  `keys_intelligent_key` varchar(50) DEFAULT NULL,
  `remote` varchar(50) DEFAULT NULL,
  `horn` varchar(50) DEFAULT NULL,
  `cigar_lighter` varchar(50) DEFAULT NULL,
  `cover_power_outlet` varchar(50) DEFAULT NULL,
  `washer_nipples` varchar(50) DEFAULT NULL,
  `original_carpets` varchar(50) DEFAULT NULL,
  `wiper_blades` varchar(50) DEFAULT NULL,
  `wiper_arms` varchar(50) DEFAULT NULL,
  `model_make_badges` varchar(50) DEFAULT NULL,
  `lights_head` varchar(50) DEFAULT NULL,
  `lights_parking` varchar(50) DEFAULT NULL,
  `lights_signal` varchar(50) DEFAULT NULL,
  `lights_reverse` varchar(50) DEFAULT NULL,
  `number_plates` varchar(50) DEFAULT NULL,
  `fogs` varchar(50) DEFAULT NULL,
  `fender` varchar(50) DEFAULT NULL,
  `hood` varchar(50) DEFAULT NULL,
  `brake_high_mounted_stop_light` varchar(50) DEFAULT NULL,
  `fuel_tank_cap` varchar(50) DEFAULT NULL,
  `wheels_alloy` varchar(50) DEFAULT NULL,
  `wheels_steel` varchar(50) DEFAULT NULL,
  `wheels_std` varchar(50) DEFAULT NULL,
  `full_wheel_covers` varchar(50) DEFAULT NULL,
  `wheel_center_caps` varchar(50) DEFAULT NULL,
  `inside_mirror` varchar(50) DEFAULT NULL,
  `mud_flaps` varchar(50) DEFAULT NULL,
  `side_mirrors_power` varchar(50) DEFAULT NULL,
  `side_mirrors_manual` varchar(50) DEFAULT NULL,
  `side_mirrors_retractable` varchar(50) DEFAULT NULL,
  `body_moldings` varchar(50) DEFAULT NULL,
  `radio` varchar(50) DEFAULT NULL,
  `cassette` varchar(50) DEFAULT NULL,
  `cd_player` varchar(50) DEFAULT NULL,
  `cd_changer` varchar(50) DEFAULT NULL,
  `usb` varchar(50) DEFAULT NULL,
  `mp3` varchar(50) DEFAULT NULL,
  `dicky_board` varchar(50) DEFAULT NULL,
  `carpet` varchar(50) DEFAULT NULL,
  `dvd` varchar(50) DEFAULT NULL,
  `remote_control` varchar(50) DEFAULT NULL,
  `hydraulic_jack` varchar(50) DEFAULT NULL,
  `mechanical` varchar(50) DEFAULT NULL,
  `screen` varchar(50) DEFAULT NULL,
  `monitor` varchar(50) DEFAULT NULL,
  `spanners` varchar(50) DEFAULT NULL,
  `pliers` varchar(50) DEFAULT NULL,
  `speaker` varchar(50) DEFAULT NULL,
  `spare_wheel` varchar(50) DEFAULT NULL,
  `ash_tray` varchar(50) DEFAULT NULL,
  `door_lock_knobs` varchar(50) DEFAULT NULL,
  `handle` varchar(50) DEFAULT NULL,
  `wheel` varchar(50) DEFAULT NULL,
  `fuse_box` varchar(50) DEFAULT NULL,
  `cover` varchar(50) DEFAULT NULL,
  `mats` varchar(50) DEFAULT NULL,
  `sun_visor` varchar(50) DEFAULT NULL,
  `vanity_mirrors` varchar(50) DEFAULT NULL,
  `reverse_sensors` varchar(50) DEFAULT NULL,
  `front_image` varchar(255) DEFAULT NULL,
  `back_image` varchar(255) DEFAULT NULL,
  `left_image` varchar(255) DEFAULT NULL,
  `right_image` varchar(255) DEFAULT NULL,
  `top_image` varchar(255) DEFAULT NULL,
  `bottom_image` varchar(255) DEFAULT NULL,
  `customer_name` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `make_model` varchar(255) DEFAULT NULL,
  `contact_no` varchar(255) DEFAULT NULL,
  `registration_no` varchar(255) DEFAULT NULL,
  `mileage` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `profile_link` (`profile_link`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `profile_link`, `battery`, `keys_intelligent_key`, `remote`, `horn`, `cigar_lighter`, `cover_power_outlet`, `washer_nipples`, `original_carpets`, `wiper_blades`, `wiper_arms`, `model_make_badges`, `lights_head`, `lights_parking`, `lights_signal`, `lights_reverse`, `number_plates`, `fogs`, `fender`, `hood`, `brake_high_mounted_stop_light`, `fuel_tank_cap`, `wheels_alloy`, `wheels_steel`, `wheels_std`, `full_wheel_covers`, `wheel_center_caps`, `inside_mirror`, `mud_flaps`, `side_mirrors_power`, `side_mirrors_manual`, `side_mirrors_retractable`, `body_moldings`, `radio`, `cassette`, `cd_player`, `cd_changer`, `usb`, `mp3`, `dicky_board`, `carpet`, `dvd`, `remote_control`, `hydraulic_jack`, `mechanical`, `screen`, `monitor`, `spanners`, `pliers`, `speaker`, `spare_wheel`, `ash_tray`, `door_lock_knobs`, `handle`, `wheel`, `fuse_box`, `cover`, `mats`, `sun_visor`, `vanity_mirrors`, `reverse_sensors`, `front_image`, `back_image`, `left_image`, `right_image`, `top_image`, `bottom_image`, `customer_name`, `address`, `date`, `make_model`, `contact_no`, `registration_no`, `mileage`) VALUES
(1, 'profile_67ac2c8c4eefa', 'No', NULL, 'Yes', 'Yes', 'No', NULL, 'Yes', NULL, 'Yes', 'Yes', NULL, NULL, NULL, NULL, NULL, 'Yes', 'Yes', 'Yes', 'Yes', NULL, 'Yes', NULL, NULL, NULL, 'Yes', 'Yes', 'Yes', 'Yes', NULL, NULL, NULL, 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', NULL, 'Yes', 'Yes', NULL, 'No', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'uploads/images/bottom_image_67ac2ca469b3d.jpg', 'uploads/images/bottom_image_67ac2ca469b3d.jpg', 'uploads/images/bottom_image_67ac2ca469b3d.jpg', 'uploads/images/bottom_image_67ac2ca469b3d.jpg', 'uploads/images/bottom_image_67ac2ca469b3d.jpg', 'uploads/images/bottom_image_67ac2ca469b3d.jpg', 'asas', 'asas', '0003-12-12', 'asSS', 'sS', 'asSA', '2313123'),
(2, 'profile_67ac33baeecac', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'sasa', 'asas', '0121-02-12', '211212', '12122', '12212', '122'),
(3, 'profile_67ac35057fab3', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'ද්ව්ද්ව්ද්', 'ව්ද්ව්ද්ව්', '0132-12-12', '1212', '121212', '121212', '1212'),
(4, 'profile_67ac352e62d55', 'No', NULL, 'Yes', 'Yes', 'Yes', NULL, 'Yes', NULL, 'Yes', 'Yes', NULL, NULL, NULL, NULL, NULL, 'Yes', 'Yes', 'Yes', 'Yes', NULL, 'Yes', NULL, NULL, NULL, 'Yes', 'Yes', 'Yes', 'Yes', NULL, NULL, NULL, 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', NULL, 'Yes', 'Yes', NULL, 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'No', 'Yes', 'uploads/images/bottom_image_67ac3543e8e93.jpg', 'uploads/images/bottom_image_67ac3543e8e93.jpg', 'uploads/images/bottom_image_67ac3543e8e93.jpg', 'uploads/images/bottom_image_67ac3543e8e93.jpg', 'uploads/images/bottom_image_67ac3543e8e93.jpg', 'uploads/images/bottom_image_67ac3543e8e93.jpg', 'ද්ව්ද්ව්ද්', 'ව්ද්ව්ද්ව්', '0132-12-12', '1212', '121212', '121212', '1212'),
(5, 'profile_67ac3fa4ddb67', 'No', NULL, 'Yes', 'Yes', 'Yes', NULL, 'Yes', NULL, 'Yes', 'Yes', NULL, NULL, NULL, NULL, NULL, 'Yes', 'Yes', 'Yes', 'Yes', NULL, 'Yes', NULL, NULL, NULL, 'Yes', 'Yes', 'Yes', 'Yes', NULL, NULL, NULL, 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', NULL, 'Yes', 'Yes', NULL, 'No', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'uploads/images/bottom_image_67ac3fbd2671b.jpg', 'uploads/images/bottom_image_67ac3fbd2671b.jpg', 'uploads/images/bottom_image_67ac3fbd2671b.jpg', 'uploads/images/bottom_image_67ac3fbd2671b.jpg', 'uploads/images/bottom_image_67ac3fbd2671b.jpg', 'uploads/images/bottom_image_67ac3fbd2671b.jpg', 'N A S LAKSHAN', 'NO,111 SAMAN SEWANA ALUTHWEWA AGUNAKOLAPELESSA', '2025-02-12', 'NISSAN SUNNY', '076734421', '301-6368', '2456779'),
(6, 'profile_67ac47af12676', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'SHEHAN LAKSHAN', 'NO NO', '2025-02-06', 'WWW', 'WWW', 'WWW', '2323'),
(7, 'profile_67ac480644f9e', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'SHEHAN LAKSHAN', 'NO NO', '2025-02-06', 'WWW', 'WWW', 'WWW', '2323'),
(8, 'profile_67ac4846d0383', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'SHEHAN LAKSHAN', 'NO NO', '2025-02-06', 'WWW', 'WWW', 'WWW', '2323'),
(9, 'profile_67ac4b2cc3d33', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'SHEHAN LAKSHAN', 'NO NO', '2025-02-04', 'WWW', 'WWW', 'WWW', '2323');
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 */;
