-- Burgermeister Kaş / MySQL 8+ / utf8mb4
-- phpMyAdmin içinde xnkagta_burger veritabanını seçip bu dosyayı içe aktarın.

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

DROP TABLE IF EXISTS `failed_jobs`;
DROP TABLE IF EXISTS `job_batches`;
DROP TABLE IF EXISTS `jobs`;
DROP TABLE IF EXISTS `cache_locks`;
DROP TABLE IF EXISTS `cache`;
DROP TABLE IF EXISTS `sessions`;
DROP TABLE IF EXISTS `password_reset_tokens`;
DROP TABLE IF EXISTS `products`;
DROP TABLE IF EXISTS `categories`;
DROP TABLE IF EXISTS `site_settings`;
DROP TABLE IF EXISTS `users`;
DROP TABLE IF EXISTS `migrations`;

CREATE TABLE `migrations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) NOT NULL,
  `batch` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `users` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) NOT NULL,
  `remember_token` varchar(100) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `password_reset_tokens` (
  `email` varchar(255) NOT NULL,
  `token` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `sessions` (
  `id` varchar(255) NOT NULL,
  `user_id` bigint unsigned DEFAULT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `user_agent` text,
  `payload` longtext NOT NULL,
  `last_activity` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `sessions_user_id_index` (`user_id`),
  KEY `sessions_last_activity_index` (`last_activity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `cache` (
  `key` varchar(255) NOT NULL,
  `value` mediumtext NOT NULL,
  `expiration` bigint NOT NULL,
  PRIMARY KEY (`key`),
  KEY `cache_expiration_index` (`expiration`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `cache_locks` (
  `key` varchar(255) NOT NULL,
  `owner` varchar(255) NOT NULL,
  `expiration` bigint NOT NULL,
  PRIMARY KEY (`key`),
  KEY `cache_locks_expiration_index` (`expiration`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `queue` varchar(255) NOT NULL,
  `payload` longtext NOT NULL,
  `attempts` smallint unsigned NOT NULL,
  `reserved_at` int unsigned DEFAULT NULL,
  `available_at` int unsigned NOT NULL,
  `created_at` int unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `jobs_queue_index` (`queue`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `job_batches` (
  `id` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `total_jobs` int NOT NULL,
  `pending_jobs` int NOT NULL,
  `failed_jobs` int NOT NULL,
  `failed_job_ids` longtext NOT NULL,
  `options` mediumtext,
  `cancelled_at` int DEFAULT NULL,
  `created_at` int NOT NULL,
  `finished_at` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `failed_jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) NOT NULL,
  `connection` varchar(255) NOT NULL,
  `queue` varchar(255) NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`),
  KEY `failed_jobs_connection_queue_failed_at_index` (`connection`,`queue`,`failed_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `categories` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `slug` varchar(255) NOT NULL,
  `name_tr` varchar(255) NOT NULL,
  `name_en` varchar(255) NOT NULL,
  `image` varchar(255) DEFAULT NULL,
  `sort_order` int unsigned NOT NULL DEFAULT 0,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `categories_slug_unique` (`slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `products` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `category_id` bigint unsigned NOT NULL,
  `name_tr` varchar(255) NOT NULL,
  `name_en` varchar(255) DEFAULT NULL,
  `description_tr` text,
  `description_en` text,
  `price` decimal(10,2) NOT NULL,
  `image` varchar(255) DEFAULT NULL,
  `sort_order` int unsigned NOT NULL DEFAULT 0,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `products_category_id_foreign` (`category_id`),
  CONSTRAINT `products_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `site_settings` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `site_title` varchar(255) NOT NULL DEFAULT 'Burgermeister',
  `phone` varchar(255) DEFAULT NULL,
  `instagram_url` varchar(255) DEFAULT NULL,
  `logo_path` varchar(255) DEFAULT NULL,
  `footer_text_tr` varchar(255) DEFAULT NULL,
  `footer_text_en` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `migrations` (`migration`, `batch`) VALUES
('0001_01_01_000000_create_users_table', 1),
('0001_01_01_000001_create_cache_table', 1),
('0001_01_01_000002_create_jobs_table', 1),
('2026_09_23_120736_create_categories_table', 1),
('2026_09_23_120737_create_products_table', 1),
('2026_09_23_120738_create_site_settings_table', 1);

INSERT INTO `users` (`id`, `name`, `email`, `password`, `created_at`, `updated_at`) VALUES
(1, 'Burgermeister Yönetici', 'admin@kasburgermeister.com', '$2y$12$Yh35TxRlIZFJKLq7hsB6G.CA1gbdTMGINv6rMbDUlUUANKudcY5F2', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);

INSERT INTO `categories` (`id`, `slug`, `name_tr`, `name_en`, `image`, `sort_order`, `is_active`, `created_at`, `updated_at`) VALUES
(1, 'burgers', 'Burgerler', 'Burgers', NULL, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
(2, 'sides', 'Yancılar', 'Sides', NULL, 2, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
(3, 'extras', 'Ekstralar', 'Extras', NULL, 3, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
(4, 'beverages', 'İçecekler', 'Beverages', NULL, 4, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);

INSERT INTO `products` (`id`, `category_id`, `name_tr`, `name_en`, `description_tr`, `description_en`, `price`, `image`, `sort_order`, `is_active`, `created_at`, `updated_at`) VALUES
(1, 1, 'MEXICAN BURGER', 'MEXICAN BURGER', 'Ev yapımı burger ekmeği, 140 g burger köftesi, Meister sos, ev yapımı acı sos, guacamole sos, kaşar peyniri, çedar sos.', 'Homemade burger bun, 140 g burger patty, Meister sauce, homemade hot sauce, guacamole sauce, kashar cheese, cheddar sauce.', 620.00, NULL, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
(2, 1, 'MEISTER PRO', 'MEISTER PRO', 'Ev yapımı burger ekmeği, 140 g burger köftesi, Meister sos, karamelize soğan, tiftik et, barbekü sos, burger peyniri.', 'Homemade burger bun, 140 g beef burger patty, Meister sauce, caramelized onions, pulled beef, barbecue sauce, burger cheese.', 720.00, NULL, 2, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
(3, 1, 'DOUBLE THREE CHEESEBURGER', 'DOUBLE THREE CHEESEBURGER', 'Ev yapımı burger ekmeği, 2 adet 140 g burger köftesi, Meister sos, karamelize soğan, krem peynir, kaşar peyniri, burger peyniri.', 'Homemade burger bun, two 140 g beef burger patties, Meister sauce, caramelized onions, cream cheese, kashar cheese, burger cheese.', 770.00, NULL, 3, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
(4, 1, 'BLUECHEESE BURGER', 'BLUE CHEESE BURGER', 'Ev yapımı burger ekmeği, 140 g burger köftesi, Meister sos, karamelize soğan, blue cheese sos, marul, domates.', 'Homemade burger bun, 140 g burger patty, Meister sauce, caramelized onion, blue cheese sauce, lettuce, tomato.', 740.00, NULL, 4, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
(5, 1, 'MAGIC MUSHROOM BURGER', 'MAGIC MUSHROOM BURGER', 'Ev yapımı burger ekmeği, 140 g burger köftesi, Meister sos, karamelize soğan, demi-glace, ızgara mantar, kaşar peyniri, çedar sos.', 'Homemade burger bun, 140 g burger patty, Meister sauce, caramelized onion, demi-glace, grilled mushroom, kashar cheese, cheddar sauce.', 620.00, NULL, 5, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
(6, 1, 'MEISTER BURGER', 'MEISTER BURGER', 'Ev yapımı burger ekmeği, 140 g burger köftesi, Meister sos, karamelize soğan, füme et, kaşar pane, barbekü sos, çedar sos, rende patates.', 'Homemade burger bun, 140 g burger patty, Meister sauce, caramelized onion, smoked beef, breaded kashar cheese, barbecue sauce, cheddar sauce, shredded potato.', 620.00, NULL, 6, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
(7, 1, 'KÖZ PATLICAN BEĞENDİLİ BURGER', 'ROASTED EGGPLANT BEĞENDİ BURGER', 'Ev yapımı burger ekmeği, 140 g burger köftesi, Meister sos, karamelize soğan, patlıcan beğendi, kaşar peyniri.', 'Homemade burger bun, 140 g burger patty, Meister sauce, caramelized onion, roasted eggplant purée, kashar cheese.', 620.00, NULL, 7, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
(8, 1, 'AŞNAVIŞNE BURGER', 'AŞNAVIŞNE BURGER', 'Ev yapımı burger ekmeği, 140 g burger köftesi, mayonez, tulum peyniri, vişne reçeli.', 'Homemade burger bun, 140 g burger patty, mayonnaise, tulum cheese, sour cherry jam.', 620.00, NULL, 8, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
(9, 1, 'HANGOVER', 'HANGOVER', 'Ev yapımı burger ekmeği, 140 g burger köftesi, Meister sos, karamelize soğan, füme et, yumurta, barbekü sos, burger peyniri.', 'Homemade burger bun, 140 g beef burger patty, Meister sauce, caramelized onions, smoked beef, egg, barbecue sauce, burger cheese.', 650.00, NULL, 9, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
(10, 1, 'CHEESEBURGER', 'CHEESEBURGER', 'Ev yapımı burger ekmeği, 140 g burger köftesi, Meister sos, karamelize soğan, krem peynir, kaşar peyniri, çedar sos.', 'Homemade burger bun, 140 g burger patty, Meister sauce, caramelized onion, cream cheese, kashar cheese, cheddar sauce.', 590.00, NULL, 10, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
(11, 1, 'VEGGIE', 'VEGGIE', 'Ev yapımı burger ekmeği, falafel köfte, tahinli sotelenmiş ıspanak, kızarmış hellim peyniri.', 'Homemade burger bun, falafel patty, sautéed spinach with tahini, fried halloumi cheese.', 620.00, NULL, 11, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
(12, 2, 'Çıtır Tavuk (6 Adet)', 'Crispy Chicken (6 pcs)', NULL, NULL, 320.00, NULL, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
(13, 2, 'Karışık Tabak', 'Mix Plate', NULL, NULL, 450.00, NULL, 2, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
(14, 2, 'Patates Kızartması', 'French Fries', NULL, NULL, 190.00, NULL, 3, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
(15, 2, 'Soğan Halkası', 'Onion Rings', NULL, NULL, 190.00, NULL, 4, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
(16, 3, '140 g Köfte', '140 g Burger Patty', NULL, NULL, 200.00, NULL, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
(17, 3, '40 g Dana Füme', '40 g Smoked Beef', NULL, NULL, 240.00, NULL, 2, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
(18, 3, 'Burger Peyniri', 'Burger Cheese', NULL, NULL, 40.00, NULL, 3, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
(19, 3, 'Kaşar Peyniri', 'Kashar Cheese', NULL, NULL, 30.00, NULL, 4, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
(20, 4, 'Meşrubatlar', 'Soft Drinks · Cola, Fanta, Sprite, Fuse Tea', NULL, NULL, 110.00, NULL, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
(21, 4, 'Ayran', 'Ayran', NULL, NULL, 70.00, NULL, 2, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
(22, 4, 'Soda', 'Mineral Water', NULL, NULL, 50.00, NULL, 3, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
(23, 4, 'Su', 'Water', NULL, NULL, 50.00, NULL, 4, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);

INSERT INTO `site_settings` (`id`, `site_title`, `phone`, `instagram_url`, `logo_path`, `footer_text_tr`, `footer_text_en`, `created_at`, `updated_at`) VALUES
(1, 'Burgermeister', '+90 542 836 4090', NULL, NULL, 'Artisan burger · Kaş', 'Artisan burger · Kaş', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);

SET FOREIGN_KEY_CHECKS = 1;