-- --------------------------------------------------------
-- Host:                         127.0.0.1
-- Server version:               10.4.32-MariaDB - mariadb.org binary distribution
-- Server OS:                    Win64
-- HeidiSQL Version:             12.11.0.7065
-- --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

-- Dumping structure for table auto_web_dv.brands
CREATE TABLE IF NOT EXISTS `brands` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Brand ID',
  `name` varchar(50) NOT NULL COMMENT 'Brand name',
  `description` text NOT NULL COMMENT 'Info about brand',
  `views` int(11) NOT NULL DEFAULT 0 COMMENT 'How many users viewed this brand',
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Stores all car brands';

-- Dumping data for table auto_web_dv.brands: ~2 rows (approximately)
INSERT INTO `brands` (`id`, `name`, `description`, `views`, `created_at`) VALUES
	(1, 'BMW', 'German performance brand', 0, '2026-02-01 19:10:49'),
	(2, 'Audi', 'Premium German automaker', 0, '2026-02-01 19:11:02'),
	(3, '	Mercedes', 'Luxury German manufacturer', 0, '2026-02-01 19:11:08');

-- Dumping structure for table auto_web_dv.comments
CREATE TABLE IF NOT EXISTS `comments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `brand_id` int(11) NOT NULL COMMENT 'Which brand is the comment meant for',
  `model_id` int(11) NOT NULL COMMENT 'Which model is the comment meant for',
  `image_url` varchar(255) DEFAULT NULL COMMENT 'Image of the provided vechicle',
  `username` varchar(50) DEFAULT NULL,
  `comment_text` text NOT NULL COMMENT 'User provided comment',
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `FK_comments_brands` (`brand_id`),
  KEY `FK_comments_models` (`model_id`),
  CONSTRAINT `FK_comments_brands` FOREIGN KEY (`brand_id`) REFERENCES `brands` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `FK_comments_models` FOREIGN KEY (`model_id`) REFERENCES `models` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='User submited comments with their posted images';

-- Dumping data for table auto_web_dv.comments: ~5 rows (approximately)
INSERT INTO `comments` (`id`, `brand_id`, `model_id`, `image_url`, `username`, `comment_text`, `created_at`) VALUES
	(2, 1, 1, 'NULL', 'Janis', 'Ļoti labs auto!', '2026-02-01 19:15:50'),
	(3, 2, 1, NULL, 'Laura', 'RS6 ir zvērs', '2026-02-01 19:16:12'),
	(4, 3, 4, NULL, 'Andris', 'AMG skaņa ir neprātīga', '2026-02-01 19:17:01'),
	(5, 3, 4, NULL, 'Anonīms', ';lool', '2026-02-01 19:37:13'),
	(6, 2, 3, NULL, 'Anonīms', 'fawfaw', '2026-03-09 23:02:53');

-- Dumping structure for table auto_web_dv.featured_cars
CREATE TABLE IF NOT EXISTS `featured_cars` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `model_id` int(11) NOT NULL COMMENT 'Which specific car was chosen',
  `added_by` varchar(50) NOT NULL COMMENT 'Person/Manager who chose the vechicle',
  `reason` text DEFAULT NULL COMMENT 'Why the person/manager chose this specific car',
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `FK__models` (`model_id`),
  CONSTRAINT `FK__models` FOREIGN KEY (`model_id`) REFERENCES `models` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Cars chosen by one of the website managers';

-- Dumping data for table auto_web_dv.featured_cars: ~2 rows (approximately)
INSERT INTO `featured_cars` (`id`, `model_id`, `added_by`, `reason`, `created_at`) VALUES
	(1, 1, 'Admin', '	Legendary performance', '2026-02-01 19:12:48'),
	(2, 3, 'Admin', 'Brutal acceleration', '2026-02-01 19:13:03');

-- Dumping structure for table auto_web_dv.home_highlights
CREATE TABLE IF NOT EXISTS `home_highlights` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `model_id` int(11) NOT NULL COMMENT 'Car shown on the main/home page',
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `FK_home_highlights_models` (`model_id`),
  CONSTRAINT `FK_home_highlights_models` FOREIGN KEY (`model_id`) REFERENCES `models` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Shows which cars/vechicles are currently shown on the main page';

-- Dumping data for table auto_web_dv.home_highlights: ~2 rows (approximately)
INSERT INTO `home_highlights` (`id`, `model_id`, `created_at`) VALUES
	(1, 1, '2026-02-01 19:12:48'),
	(2, 3, '2026-02-01 19:32:48');

-- Dumping structure for table auto_web_dv.models
CREATE TABLE IF NOT EXISTS `models` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Model ID',
  `brand_id` int(11) NOT NULL COMMENT 'Brand name',
  `name` varchar(50) NOT NULL COMMENT 'Model name',
  `year` int(11) NOT NULL COMMENT 'Release year',
  `description` text DEFAULT NULL COMMENT 'Description about the model',
  `image_url` varchar(255) NOT NULL COMMENT 'Car model image',
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `FK__brands` (`brand_id`),
  CONSTRAINT `FK__brands` FOREIGN KEY (`brand_id`) REFERENCES `brands` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Models for each car brand';

-- Dumping data for table auto_web_dv.models: ~4 rows (approximately)
INSERT INTO `models` (`id`, `brand_id`, `name`, `year`, `description`, `image_url`, `created_at`) VALUES
	(1, 1, 'BMW M3', 2020, 'High‑performance sedan', '	img/m3.jpg', '2026-02-01 19:11:36'),
	(2, 1, 'BMW X5', 2019, 'Luxury SUV', 'img/x5.jpg', '2026-02-01 19:11:52'),
	(3, 2, 'Audi RS6', 2021, 'Powerful family wagon', '	img/rs6.jpg', '2026-02-01 19:12:07'),
	(4, 3, '	Mercedes C63', 2018, 'AMG performance sedan', 'img/c63.jpg', '2026-02-01 19:12:22');

-- Dumping structure for table auto_web_dv.models_views
CREATE TABLE IF NOT EXISTS `models_views` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `model_id` int(11) NOT NULL COMMENT 'Which model was looked at',
  `viewed_at` datetime NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `FK_models_views_models` (`model_id`),
  CONSTRAINT `FK_models_views_models` FOREIGN KEY (`model_id`) REFERENCES `models` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Used to see user activity';

-- Dumping data for table auto_web_dv.models_views: ~2 rows (approximately)
INSERT INTO `models_views` (`id`, `model_id`, `viewed_at`) VALUES
	(1, 1, '2026-02-01 19:17:11'),
	(2, 3, '2026-02-01 19:17:17'),
	(3, 3, '2026-02-01 19:17:22');

/*!40103 SET TIME_ZONE=IFNULL(@OLD_TIME_ZONE, 'system') */;
/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IFNULL(@OLD_FOREIGN_KEY_CHECKS, 1) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40111 SET SQL_NOTES=IFNULL(@OLD_SQL_NOTES, 1) */;