CREATE DATABASE IF NOT EXISTS `cukurcimenliler` CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
USE `cukurcimenliler`;

CREATE TABLE IF NOT EXISTS pv_admin_users (id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY, full_name VARCHAR(120) NOT NULL, email VARCHAR(190) NOT NULL UNIQUE, password_hash VARCHAR(255) NOT NULL, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE IF NOT EXISTS pv_settings (setting_key VARCHAR(100) PRIMARY KEY, setting_value TEXT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE IF NOT EXISTS pv_sliders (id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY, title VARCHAR(255) NOT NULL, description TEXT NULL, image_path VARCHAR(500) NOT NULL, button_text VARCHAR(100) NULL, button_url VARCHAR(500) NULL, sort_order INT NOT NULL DEFAULT 0, is_active TINYINT(1) NOT NULL DEFAULT 1, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE IF NOT EXISTS pv_content_blocks (block_key VARCHAR(100) PRIMARY KEY, title VARCHAR(255) NULL, subtitle VARCHAR(255) NULL, content TEXT NULL, image_path VARCHAR(500) NULL, button_text VARCHAR(100) NULL, button_url VARCHAR(500) NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE IF NOT EXISTS pv_about (id TINYINT UNSIGNED PRIMARY KEY, title VARCHAR(255) NOT NULL, subtitle VARCHAR(255) NULL, content TEXT NOT NULL, image_path VARCHAR(500) NULL, button_text VARCHAR(100) NULL, button_url VARCHAR(500) NULL, hero_image VARCHAR(500) NULL, video_url VARCHAR(500) NULL, video_cover_image VARCHAR(500) NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE IF NOT EXISTS pv_categories (id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY, name VARCHAR(120) NOT NULL, slug VARCHAR(140) NOT NULL UNIQUE, sort_order INT NOT NULL DEFAULT 0, is_active TINYINT(1) NOT NULL DEFAULT 1) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE IF NOT EXISTS pv_products (id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY, title VARCHAR(255) NOT NULL, description TEXT NULL, detail_content TEXT NULL, technical_features TEXT NULL, technical_drawing VARCHAR(500) NULL, category VARCHAR(140) NULL, cover_image VARCHAR(500) NOT NULL, sort_order INT NOT NULL DEFAULT 0, is_active TINYINT(1) NOT NULL DEFAULT 1, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE IF NOT EXISTS pv_product_images (id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY, product_id INT UNSIGNED NOT NULL, image_path VARCHAR(500) NOT NULL, sort_order INT NOT NULL DEFAULT 0, CONSTRAINT fk_pv_product_images_product FOREIGN KEY (product_id) REFERENCES pv_products(id) ON DELETE CASCADE) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE IF NOT EXISTS pv_gallery (id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY, image_path VARCHAR(500) NOT NULL, title VARCHAR(255) NULL, alt_text VARCHAR(255) NULL, sort_order INT NOT NULL DEFAULT 0, is_active TINYINT(1) NOT NULL DEFAULT 1) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE IF NOT EXISTS pv_messages (id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY, full_name VARCHAR(190) NOT NULL, email VARCHAR(190) NOT NULL, phone VARCHAR(80) NULL, message TEXT NOT NULL, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

INSERT INTO pv_settings(setting_key,setting_value) VALUES ('email','info@cdsdovme.com') ON DUPLICATE KEY UPDATE setting_value=VALUES(setting_value);