-- phpMyAdmin SQL Dump
-- version 5.2.2
-- https://www.phpmyadmin.net/
--
-- Anamakine: localhost:3306
-- Üretim Zamanı: 02 May 2026, 01:47:14
-- Sunucu sürümü: 8.0.45-cll-lve
-- PHP Sürümü: 8.4.20

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

--
-- Veritabanı: `lafelici_slider`
--

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

--
-- Tablo için tablo yapısı `sliders`
--

CREATE TABLE `sliders` (
  `id` int NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `media_type` enum('image','video') COLLATE utf8mb4_unicode_ci NOT NULL,
  `orientation` enum('landscape','portrait') COLLATE utf8mb4_unicode_ci DEFAULT 'landscape',
  `media_url` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL,
  `duration` int DEFAULT '7',
  `sort_order` int DEFAULT '0',
  `is_active` tinyint(1) DEFAULT '1',
  `screen_key` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Tablo döküm verisi `sliders`
--

INSERT INTO `sliders` (`id`, `title`, `media_type`, `orientation`, `media_url`, `duration`, `sort_order`, `is_active`, `screen_key`, `created_at`, `updated_at`) VALUES
(1, 'san Sebastian', 'image', 'landscape', '/uploads/sliders/sansebastian_be90d5997820d924.jpg', 7, 7, 1, 'altkat', '2026-02-28 13:11:39', '2026-05-01 22:18:37'),
(3, 'pizza', 'image', 'landscape', '/uploads/sliders/mortedella_849c12078066e582.jpg', 7, 8, 1, NULL, '2026-02-28 13:11:39', '2026-05-01 22:18:37'),
(5, 'Video', 'video', 'landscape', '/uploads/sliders/scala030625_fadc7a0232348f0f.mp4', 0, 6, 1, 'pergola', '2026-02-28 14:02:34', '2026-05-01 22:18:37'),
(6, NULL, 'image', 'landscape', '/uploads/sliders/a654b4cb62d2622eddd02eec39c932f5ff10c337d2cef6599c_46132752e39a8a52.jpg', 10, 5, 1, NULL, '2026-03-09 11:07:26', '2026-05-01 22:18:37'),
(7, 'video2', 'video', 'portrait', '/uploads/sliders/04035_6c6866ce5395dc9e.mp4', 0, 4, 1, 'pergola', '2026-04-02 22:23:10', '2026-05-01 22:18:37'),
(8, NULL, 'image', 'landscape', '/uploads/sliders/limonatacopy_e97806c93400a67a.jpg', 7, 3, 1, NULL, '2026-05-01 21:56:42', '2026-05-01 22:18:39'),
(9, NULL, 'image', 'landscape', '/uploads/sliders/Balksz-1copy_6a9706b4711fd079.jpg', 7, 2, 0, NULL, '2026-05-01 21:59:01', '2026-05-01 22:18:37'),
(10, NULL, 'video', 'landscape', '/uploads/sliders/GeneratedFileMay102025-1_24PM-2_e354a11dafc2e96c.mp4', 0, 1, 0, NULL, '2026-05-01 22:10:39', '2026-05-01 22:18:37');

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

--
-- Tablo için tablo yapısı `users`
--

CREATE TABLE `users` (
  `id` int NOT NULL,
  `username` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `password_hash` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_active` tinyint(1) DEFAULT '1',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `settings` (
  `skey` varchar(50) PRIMARY KEY,
  `svalue` text
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `settings` (`skey`, `svalue`) VALUES ('last_update', UNIX_TIMESTAMP());

--
-- Tablo döküm verisi `users`
--

INSERT INTO `users` (`id`, `username`, `email`, `password_hash`, `is_active`, `created_at`, `updated_at`) VALUES
(1, 'admin', 'admin@menuboard.local', '$2y$10$qZF94GAmQNJSLjRr5F1p2OZaqvEyrVKteULvC6TBBWD9te5Y3qbi.', 1, '2026-02-28 13:11:39', '2026-05-01 02:20:55');

--
-- Dökümü yapılmış tablolar için indeksler
--

--
-- Tablo için indeksler `sliders`
--
ALTER TABLE `sliders`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_is_active` (`is_active`),
  ADD KEY `idx_sort_order` (`sort_order`),
  ADD KEY `idx_screen_key` (`screen_key`),
  ADD KEY `idx_media_type` (`media_type`);

--
-- Tablo için indeksler `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `username` (`username`),
  ADD UNIQUE KEY `email` (`email`),
  ADD KEY `idx_username` (`username`),
  ADD KEY `idx_is_active` (`is_active`);

--
-- Dökümü yapılmış tablolar için AUTO_INCREMENT değeri
--

--
-- Tablo için AUTO_INCREMENT değeri `sliders`
--
ALTER TABLE `sliders`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- Tablo için AUTO_INCREMENT değeri `users`
--
ALTER TABLE `users`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
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 */;