/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 80031 (8.0.31)
 Source Host           : localhost:3306
 Source Schema         : drweb_cms

 Target Server Type    : MySQL
 Target Server Version : 80031 (8.0.31)
 File Encoding         : 65001

 Date: 01/11/2024 16:19:15
*/


-- ----------------------------
-- Table structure for admin_modules
-- ----------------------------
CREATE TABLE `admin_modules`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `parent_id` bigint NULL DEFAULT 0,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `icon` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `route_durum` tinyint NOT NULL DEFAULT 0 COMMENT 'route durumu var ise 1 yok ise 0 yazınız',
  `route_link` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'route link adresi. route durumu 1 ise kullanılır 0 ise kullanılmaz',
  `route_parameters` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'routeya ait parametre varsa girilmelidir.',
  `order` int NOT NULL DEFAULT 0,
  `status` tinyint NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 36 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of admin_modules
-- ----------------------------
INSERT INTO `admin_modules` VALUES (1, 0, 'Anasayfa', 'anasayfa', 'icon-home', 1, 'admin.dashboard.index', NULL, 1, 1, '2024-08-09 15:25:23', NULL);
INSERT INTO `admin_modules` VALUES (2, 0, 'İçerikler', '', 'icon-grid', 1, 'admin.contents.index', NULL, 2, 1, '2024-08-09 15:25:25', NULL);
INSERT INTO `admin_modules` VALUES (5, 2, 'Tüm İçerikler', 'tüm içerikler', NULL, 1, 'admin.contents.index', NULL, 3, 1, '2024-08-09 15:25:28', NULL);
INSERT INTO `admin_modules` VALUES (6, 2, 'İçerik Kategorileri', 'içerik kategorileri', NULL, 1, 'admin.contents.categories.index', NULL, 4, 1, '2024-08-09 15:25:30', NULL);
INSERT INTO `admin_modules` VALUES (7, 2, 'Özellikler', 'içerik özellikler', NULL, 1, 'admin.contents.content_features.index', NULL, 5, 1, '2024-08-09 17:18:23', NULL);
INSERT INTO `admin_modules` VALUES (8, 0, 'Kullanıcılar', 'kullanıcılar', 'ft-users', 0, '', NULL, 26, 1, '2024-08-09 17:23:41', NULL);
INSERT INTO `admin_modules` VALUES (9, 8, 'Tüm Kullanıcılar', '', NULL, 1, 'admin.users.index', NULL, 7, 1, '2024-08-09 17:23:41', NULL);
INSERT INTO `admin_modules` VALUES (11, 0, 'Ürünler', '', 'ft-align-justify', 0, '', NULL, 5, 1, '2024-08-09 17:23:41', NULL);
INSERT INTO `admin_modules` VALUES (12, 11, 'Tüm Ürünler', '', NULL, 1, 'admin.product.index', NULL, 10, 1, '2024-08-09 17:23:41', NULL);
INSERT INTO `admin_modules` VALUES (13, 11, 'Ürün Kategorileri', '', NULL, 1, 'admin.product.categories.index', NULL, 11, 1, '2024-08-09 17:23:41', NULL);
INSERT INTO `admin_modules` VALUES (14, 11, 'Özellikler', 'ürün özellikleri', NULL, 1, 'admin.product.features.index', NULL, 12, 1, '2024-08-09 17:23:41', NULL);
INSERT INTO `admin_modules` VALUES (15, 0, 'Dosya Merkezi', '', 'ft-folder', 0, 'admin.file_center.index', NULL, 13, 1, '2024-08-09 17:23:41', NULL);
INSERT INTO `admin_modules` VALUES (16, 15, 'Tümü', 'tüm dosya merkezi', NULL, 1, 'admin.file_center.index', NULL, 14, 1, '2024-08-09 17:23:41', NULL);
INSERT INTO `admin_modules` VALUES (17, 0, 'Tema Yönetimi', '', 'icon-layers', 1, 'admin.themes.index', NULL, 17, 1, '2024-08-09 17:23:41', NULL);
INSERT INTO `admin_modules` VALUES (19, 0, 'Genel', '', 'ft-more-horizontal', 0, NULL, NULL, 16, 1, '2024-08-09 17:23:41', NULL);
INSERT INTO `admin_modules` VALUES (20, 19, 'Genel Ayarlar', '', NULL, 1, 'admin.general.settings.index', NULL, 16, 1, '2024-08-09 17:23:41', NULL);
INSERT INTO `admin_modules` VALUES (22, 19, 'İletişim Formu', '', NULL, 1, 'admin.general.contact_form.index', NULL, 22, 1, '2024-08-09 17:23:41', NULL);
INSERT INTO `admin_modules` VALUES (25, 19, 'Dil Yönetimi', '', NULL, 1, 'admin.general.languages.index', NULL, 25, 1, '2024-08-09 17:23:41', NULL);
INSERT INTO `admin_modules` VALUES (29, 19, 'Cache Yenileme', '', NULL, 1, 'admin.general.settings.cache_refresh.index', NULL, 26, 1, '2024-08-16 14:40:26', NULL);
INSERT INTO `admin_modules` VALUES (30, 17, 'Temalar', '', NULL, 1, 'admin.themes.index', NULL, 27, 1, '2024-08-16 15:45:11', NULL);
INSERT INTO `admin_modules` VALUES (32, 11, 'Markalar', '', NULL, 1, 'admin.product.brands.index', NULL, 29, 1, '2024-09-11 09:28:57', NULL);
INSERT INTO `admin_modules` VALUES (33, 19, 'Smtp Ayarları', '', NULL, 1, 'admin.general.settings.smtp_settings.index', NULL, 30, 1, '2024-09-13 14:38:16', NULL);
INSERT INTO `admin_modules` VALUES (34, 19, 'İletişim Bilgileri', '', NULL, 1, 'admin.general.contact_info.index', NULL, 31, 1, '2024-09-14 16:54:55', NULL);

-- ----------------------------
-- Table structure for contact_forms
-- ----------------------------
CREATE TABLE `contact_forms`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `lang_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `subject` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `phone` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `ip` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `browser` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `browser_languages` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `browser_version` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `os` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of contact_forms
-- ----------------------------
INSERT INTO `contact_forms` VALUES (8, 'tr', 'MUSTERI AD SOYAD', 'musteri1@hotmail.com', 'Misyonumuz, müşterilerimizin', 'Misyonumuz, müşterilerimizin ihtiyaçlarına uygun, kaliteli ve yenilikçi çözümler sunarak onların iş süreçlerini daha verimli ve kârlı hale getirmektir. Vizyonumuz ise, sürekli gelişen global pazarda öncü bir rol üstlenmek ve müşteri odaklı yaklaşımlarımızla sektörde fark yaratan bir şirket olmaktır.', '111-111-1111', '127.0.0.1', 'Chrome', '[\"tr\",\"en-us\",\"en\",\"tr-tr\"]', '128.0.0.0', 'Windows', '2024-09-17 16:50:03', '2024-09-17 16:50:03');

-- ----------------------------
-- Table structure for contact_infos
-- ----------------------------
CREATE TABLE `contact_infos`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `lang_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `contact_info` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `map` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `footer_contact` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `header_contact` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `contact_infos_lang_code_foreign`(`lang_code` ASC) USING BTREE,
  CONSTRAINT `contact_infos_lang_code_foreign` FOREIGN KEY (`lang_code`) REFERENCES `languages` (`code`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of contact_infos
-- ----------------------------
INSERT INTO `contact_infos` VALUES (7, 'tr', '<p>tr iletişim</p>', '<p>tr harita</p>', '2024-09-19 14:25:36', '2024-11-01 10:59:19', '<p>Alt kısım İletişim Bilgisi</p>', '<ul>\r\n	<li>\r\n	<h4><a href=\"tel:+4733378901\">(+00)888.666.88</a></h4>\r\n	Free Call</li>\r\n	<li>\r\n	<h4>08:00 AM - 06:00 PM</h4>\r\n	Monday - Friday</li>\r\n	<li>\r\n	<h4>183 Donato Parkways</h4>\r\n	CA, United State</li>\r\n</ul>');
INSERT INTO `contact_infos` VALUES (8, 'en', NULL, NULL, '2024-09-19 14:25:36', '2024-09-19 14:25:36', NULL, NULL);
INSERT INTO `contact_infos` VALUES (9, 'fr', NULL, NULL, '2024-09-19 14:25:36', '2024-09-19 14:25:36', NULL, NULL);
INSERT INTO `contact_infos` VALUES (10, 'de', NULL, NULL, '2024-09-19 14:25:36', '2024-09-19 14:25:36', NULL, NULL);

-- ----------------------------
-- Table structure for content_categories
-- ----------------------------
CREATE TABLE `content_categories`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `lang_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `order` int NOT NULL DEFAULT 0,
  `status` tinyint NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `banner_image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `seo_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `seo_keywords` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `seo_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `content_categories_slug_unique`(`slug` ASC) USING BTREE,
  INDEX `content_categories_lang_code_foreign`(`lang_code` ASC) USING BTREE,
  CONSTRAINT `content_categories_lang_code_foreign` FOREIGN KEY (`lang_code`) REFERENCES `languages` (`code`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 33 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of content_categories
-- ----------------------------
INSERT INTO `content_categories` VALUES (15, 'tr', 'ARSA', 'ARSA KATEGORİSİ', 'arsa', 1, 1, '2024-09-10 10:16:43', '2024-09-11 09:15:04', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `content_categories` VALUES (16, 'tr', 'OTOMOBİL', NULL, 'otomobil', 2, 1, '2024-09-10 10:16:53', '2024-09-10 10:16:53', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `content_categories` VALUES (17, 'tr', 'BİLGİSAYAR', NULL, 'bilgisayar', 3, 1, '2024-09-10 10:17:00', '2024-09-10 10:17:00', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `content_categories` VALUES (21, 'en', 'EN CAT 2', NULL, 'en-cat-', 1, 1, '2024-09-10 10:18:57', '2024-09-10 10:18:57', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `content_categories` VALUES (22, 'en', 'EN CAT3', NULL, 'en-cat', 2, 1, '2024-09-10 10:19:38', '2024-09-10 10:19:38', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `content_categories` VALUES (23, 'tr', 'EV', NULL, 'ev', 4, 1, '2024-09-10 10:20:36', '2024-09-10 10:20:36', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `content_categories` VALUES (24, 'tr', 'BLOG', NULL, 'blog', 5, 1, '2024-09-13 14:52:01', '2024-09-17 11:54:49', 'upload/content_images/content_category_banner_3452464308.png', 'upload/content_images/content_category_1726232116.png', 'BLOG YAZILARI', 'blog', 'blog içerik');
INSERT INTO `content_categories` VALUES (25, 'tr', '1', NULL, 'asdasd', 6, 1, '2024-09-13 15:43:34', '2024-09-13 15:43:34', 'upload/content_images/content_category_1726231414.jpg', 'C:\\wamp64\\tmp\\php274.tmp', NULL, NULL, NULL);
INSERT INTO `content_categories` VALUES (26, 'tr', 'dasdasd', NULL, 'dasdasd', 7, 1, '2024-09-13 15:44:15', '2024-09-13 15:44:15', 'upload/content_images/content_category_1726231455.jpg', 'upload/content_images/content_category_1726231455.jpg', NULL, NULL, NULL);
INSERT INTO `content_categories` VALUES (28, 'tr', 'HABERLER', NULL, 'haberler', 9, 1, '2024-09-14 12:44:31', '2024-09-14 15:19:06', 'upload/content_images/content_category_banner_3452632692.jpg', 'upload/content_images/content_category_1726316346.jpg', NULL, NULL, NULL);
INSERT INTO `content_categories` VALUES (29, 'tr', 'GALERİ', NULL, 'galeri', 10, 1, '2024-09-14 16:46:45', '2024-09-17 11:53:05', NULL, NULL, 's1', 'sk2', 'sd3');
INSERT INTO `content_categories` VALUES (30, 'tr', 'Cat Başlık', 'Cat İçerik', 'cat-baslik', 11, 1, '2024-09-17 11:51:43', '2024-09-17 11:52:59', NULL, NULL, 'Seo Cat Başlık-2', 'seo keyword-1,seo keyword-2,seo keyword3', 'Seo Desc Kat');
INSERT INTO `content_categories` VALUES (31, 'tr', 'Tamamlanan Projeler', NULL, 'tamamlanan-projeler', 12, 1, '2024-09-17 16:23:54', '2024-09-17 16:23:54', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `content_categories` VALUES (32, 'tr', 'Kat Test', NULL, 'kat-test', 13, 1, '2024-10-24 15:11:11', '2024-10-24 15:11:11', NULL, NULL, NULL, NULL, NULL);

-- ----------------------------
-- Table structure for content_feature_relationals
-- ----------------------------
CREATE TABLE `content_feature_relationals`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `content_id` bigint UNSIGNED NOT NULL,
  `content_feature_id` bigint UNSIGNED NOT NULL,
  `value` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `order` int NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `content_feature_relationals_content_id_foreign`(`content_id` ASC) USING BTREE,
  INDEX `content_feature_relationals_content_feature_id_foreign`(`content_feature_id` ASC) USING BTREE,
  CONSTRAINT `content_feature_relationals_content_feature_id_foreign` FOREIGN KEY (`content_feature_id`) REFERENCES `content_features` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT,
  CONSTRAINT `content_feature_relationals_content_id_foreign` FOREIGN KEY (`content_id`) REFERENCES `contents` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 28 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of content_feature_relationals
-- ----------------------------

-- ----------------------------
-- Table structure for content_features
-- ----------------------------
CREATE TABLE `content_features`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `lang_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `order` int NOT NULL DEFAULT 0,
  `status` tinyint NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `content_features_lang_code_foreign`(`lang_code` ASC) USING BTREE,
  CONSTRAINT `content_features_lang_code_foreign` FOREIGN KEY (`lang_code`) REFERENCES `languages` (`code`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 16 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of content_features
-- ----------------------------
INSERT INTO `content_features` VALUES (10, 'en', 'BAŞLAMA TARİHİ', NULL, 'text', 1, 1, '2024-09-09 14:36:28', '2024-09-09 14:36:28');
INSERT INTO `content_features` VALUES (11, 'tr', 'Müşteri', NULL, 'text', 3, 1, '2024-09-14 12:35:40', '2024-09-17 11:35:56');
INSERT INTO `content_features` VALUES (12, 'tr', 'Özellik-1', NULL, 'text', 1, 1, '2024-09-14 12:35:47', '2024-09-17 11:35:56');
INSERT INTO `content_features` VALUES (13, 'tr', 'Özellik-2', NULL, 'date', 2, 1, '2024-09-14 12:35:55', '2024-09-17 11:35:56');
INSERT INTO `content_features` VALUES (14, 'tr', 'Özellik-3', NULL, 'input', 0, 1, '2024-09-14 12:36:03', '2024-09-17 11:35:56');
INSERT INTO `content_features` VALUES (15, 'tr', 'Başlama Tarihi', NULL, 'date', 4, 1, '2024-09-17 16:24:11', '2024-09-17 16:24:11');

-- ----------------------------
-- Table structure for content_images
-- ----------------------------
CREATE TABLE `content_images`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `content_id` bigint UNSIGNED NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `extension` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `order` int NOT NULL DEFAULT 0,
  `default` tinyint NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `content_images_content_id_foreign`(`content_id` ASC) USING BTREE,
  CONSTRAINT `content_images_content_id_foreign` FOREIGN KEY (`content_id`) REFERENCES `contents` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 110 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of content_images
-- ----------------------------
INSERT INTO `content_images` VALUES (96, 31, '', 'upload/content_images/1726568353-66e957a1f4157.jpg', 'jpg', 1, 1, '2024-09-17 13:19:14', '2024-09-17 13:19:14');
INSERT INTO `content_images` VALUES (97, 33, '', 'upload/content_images/1726579403-66e982cb42cc2.jpg', 'jpg', 1, 1, '2024-09-17 16:23:23', '2024-09-17 16:23:23');
INSERT INTO `content_images` VALUES (98, 33, '', 'upload/content_images/1726579403-66e982cbee981.png', 'png', 1, 0, '2024-09-17 16:23:24', '2024-09-17 16:23:24');
INSERT INTO `content_images` VALUES (99, 33, '', 'upload/content_images/1726579404-66e982cc7a071.jpg', 'jpg', 1, 0, '2024-09-17 16:23:24', '2024-09-17 16:23:24');
INSERT INTO `content_images` VALUES (100, 33, '', 'upload/content_images/1726579405-66e982cd559d8.jpg', 'jpg', 1, 0, '2024-09-17 16:23:25', '2024-09-17 16:23:25');
INSERT INTO `content_images` VALUES (101, 34, '', 'upload/content_images/1726746839-66ec10d76e3b9.jpg', 'jpg', 1, 1, '2024-09-19 14:53:59', '2024-09-19 14:53:59');
INSERT INTO `content_images` VALUES (102, 31, '', 'upload/content_images/1729750555-6719e61bc5fdf.png', 'png', 2, 0, '2024-10-24 09:15:55', '2024-10-24 09:15:55');
INSERT INTO `content_images` VALUES (103, 31, '', 'upload/content_images/1729751224-6719e8b8bff3c.png', 'png', 3, 0, '2024-10-24 09:27:04', '2024-10-24 09:27:04');
INSERT INTO `content_images` VALUES (104, 31, '', 'upload/content_images/1729751282-6719e8f28a4dc.png', 'png', 4, 0, '2024-10-24 09:28:02', '2024-10-24 09:28:02');
INSERT INTO `content_images` VALUES (105, 31, '', 'upload/content_images/1729751730-6719eab26b0c0.png', 'png', 5, 0, '2024-10-24 09:35:30', '2024-10-24 09:35:30');
INSERT INTO `content_images` VALUES (106, 31, '', 'upload/content_images/1729751772-6719eadc2b039.png', 'png', 6, 0, '2024-10-24 09:36:12', '2024-10-24 09:36:12');
INSERT INTO `content_images` VALUES (107, 35, '', 'upload/content_images/1729753834-6719f2ea7d4ad.png', 'png', 1, 1, '2024-10-24 10:10:34', '2024-10-24 10:10:34');
INSERT INTO `content_images` VALUES (108, 36, '', 'upload/content_images/1729753884-6719f31cbb4c5.png', 'png', 1, 1, '2024-10-24 10:11:24', '2024-10-24 10:11:24');
INSERT INTO `content_images` VALUES (109, 38, '', 'upload/content_images/1729771976-671a39c83455c.png', 'png', 1, 1, '2024-10-24 15:12:56', '2024-10-24 15:12:56');

-- ----------------------------
-- Table structure for contents
-- ----------------------------
CREATE TABLE `contents`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `lang_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `short_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `order` int NOT NULL DEFAULT 0,
  `status` tinyint NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `category_id` int NULL DEFAULT NULL,
  `detail_image_status` tinyint NULL DEFAULT 0,
  `file_center_id` int NULL DEFAULT 0,
  `seo_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `seo_keywords` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `seo_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `contents_slug_unique`(`slug` ASC) USING BTREE,
  INDEX `contents_lang_code_foreign`(`lang_code` ASC) USING BTREE,
  INDEX `contents_category_id_index`(`category_id` ASC) USING BTREE,
  CONSTRAINT `contents_lang_code_foreign` FOREIGN KEY (`lang_code`) REFERENCES `languages` (`code`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 39 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of contents
-- ----------------------------
INSERT INTO `contents` VALUES (31, 'tr', 'İş Yerinde Verimliliğinizi Artırmanın 5 Yolu', 'Günümüzün hızlı tempolu dünyasında, iş yerinde verimli kalmak oldukça zor olabilir. Sürekli gelen e-postalar, toplantılar ve dikkat dağıtan unsurlar arasında, bazen günün saatleri yetersiz kalıyor gibi hissedebiliriz. Ancak, doğru stratejilerle, verimliliğinizi en üst düzeye çıkarabilir ve daha az zamanda daha fazla iş yapabilirsiniz. İşte iş yerinde verimliliğinizi artırmanın beş etkili yolu:', '<p>G&uuml;n&uuml;m&uuml;z&uuml;n hızlı tempolu d&uuml;nyasında, iş yerinde verimli kalmak olduk&ccedil;a zor olabilir. S&uuml;rekli gelen e-postalar, toplantılar ve dikkat dağıtan unsurlar arasında, bazen g&uuml;n&uuml;n saatleri yetersiz kalıyor gibi hissedebiliriz. Ancak, doğru stratejilerle, verimliliğinizi en &uuml;st d&uuml;zeye &ccedil;ıkarabilir ve daha az zamanda daha fazla iş yapabilirsiniz. İşte iş yerinde verimliliğinizi artırmanın beş etkili yolu:</p>\r\n\r\n<h3>1. <strong>G&ouml;revlerinizi &Ouml;nceliklendirin</strong></h3>\r\n\r\n<p>Verimli olmanın en &ouml;nemli yollarından biri, yapılacak işleri &ouml;nceliklendirmektir. Her g&uuml;ne başlamadan &ouml;nce, yapılacaklar listenizi oluşturun ve bu g&ouml;revleri aciliyet ve &ouml;nem derecesine g&ouml;re sıralayın. <strong>Eisenhower Matrisi</strong> gibi ara&ccedil;lar, acil olan işleri daha az &ouml;nemli olanlardan ayırmanıza yardımcı olabilir.</p>\r\n\r\n<h3>2. <strong>Pomodoro Tekniğini Kullanın</strong></h3>\r\n\r\n<p>Pomodoro Tekniği, verimli &ccedil;alışmak i&ccedil;in olduk&ccedil;a etkili bir y&ouml;ntemdir. Bu teknikte, 25 dakika boyunca kesintisiz bir şekilde &ccedil;alıştıktan sonra 5 dakikalık bir ara verirsiniz. Her 4 Pomodoro d&ouml;ng&uuml;s&uuml;nden sonra ise 15-30 dakikalık daha uzun bir ara verirsiniz. Bu y&ouml;ntem, odaklanmayı artırır ve zihninizi din&ccedil; tutar.</p>\r\n\r\n<h3>&nbsp;</h3>', 'is-yerinde-verimliliginizi-artirmanin-yolu', 1, 1, '2024-09-17 13:18:14', '2024-09-17 13:18:14', 24, 1, NULL, 'Görevlerinizi Önceliklendirin', 'telefon', 'Telefon bildirimleri, sosyal medya ve e-postalar, çalışma sürecinizde büyük dikkat dağıtıcılar olabilir');
INSERT INTO `contents` VALUES (32, 'tr', 'Kurumsal', NULL, NULL, 'kurumsal', 2, 1, '2024-09-17 16:22:41', '2024-09-17 16:22:41', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `contents` VALUES (33, 'tr', 'Galeri', NULL, NULL, 'galeri', 3, 1, '2024-09-17 16:22:58', '2024-09-17 16:22:58', NULL, 0, NULL, NULL, NULL, NULL);
INSERT INTO `contents` VALUES (34, 'tr', 'Basit Yaşam Sanatı', 'Günümüzün hızlı tempolu dünyasında sadelik genellikle göz ardı ediliyor. Basit yaşam sanatı, gerçekten önemli olanı kucaklamak ve hem fiziksel hem de zihinsel alanlarımızı sadeleştirmekle ilgilidir. Peki bunu nasıl başarırız?', '<h4>1. Alanınızı D&uuml;zenleyin</h4>\r\n\r\n<p>Basit bir yaşama doğru atılan ilk adım, evinizden başlar. Gereksiz eşyaları ortadan kaldırın. İster dolup taşan bir gardırop, ister dağınık bir &ccedil;alışma alanı olsun, fazlalıklardan kurtulmak huzur getirecektir. İşte bazı &ouml;neriler:</p>\r\n\r\n<ul>\r\n	<li>Eşyalarınızı sınıflandırın: Sık kullanmadığınız ve ger&ccedil;ekten ihtiyacınız olmayanları ayıklayın.</li>\r\n	<li>Geri d&ouml;n&uuml;ş&uuml;m ve bağış: Kullanmadığınız eşyaları ihtiyacı olanlara verin veya geri d&ouml;n&uuml;şt&uuml;r&uuml;n.</li>\r\n</ul>\r\n\r\n<h4>2. Zihinsel Sadeleşme</h4>\r\n\r\n<p>Sadece fiziksel değil, zihinsel sadeleşme de &ouml;nemlidir. Stres ve kaygılardan arınmak i&ccedil;in şu adımları atabilirsiniz:</p>\r\n\r\n<ul>\r\n	<li><strong>Meditasyon yapın:</strong> G&uuml;nde sadece 10 dakika ayırarak zihninizi dinlendirin.</li>\r\n	<li><strong>Teknoloji detoksu yapın:</strong> Sosyal medyaya ara verin ve anın tadını &ccedil;ıkarın.</li>\r\n</ul>\r\n\r\n<h4>&nbsp;</h4>', 'a-projesi', 4, 1, '2024-09-17 16:24:52', '2024-09-19 14:53:48', 31, 1, NULL, NULL, NULL, NULL);
INSERT INTO `contents` VALUES (35, 'tr', 'Başarılı Olmanın 5 Temel Alışkanlığı', NULL, NULL, 'basarili-olmanin-temel-aliskanligi', 5, 1, '2024-10-24 10:10:10', '2024-10-24 10:10:10', 24, 1, NULL, NULL, NULL, NULL);
INSERT INTO `contents` VALUES (36, 'tr', '1. Minimalizmin Hayatınıza Katacağı 4 Önemli Değer', NULL, NULL, 'minimalizmin-hayatiniza-katacagi-onemli-deger', 6, 1, '2024-10-24 10:11:04', '2024-10-24 10:11:04', 24, 1, NULL, NULL, NULL, NULL);
INSERT INTO `contents` VALUES (37, 'tr', '2. Uzaktan Çalışmanın Avantajları ve Zorlukları', NULL, NULL, 'uzaktan-calismanin-avantajlari-ve-zorluklari', 7, 1, '2024-10-24 10:11:15', '2024-10-24 10:11:15', 24, 1, NULL, NULL, NULL, NULL);
INSERT INTO `contents` VALUES (38, 'tr', 'What is Lorem Ipsum?', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.', NULL, 'what-is-lorem-ipsum', 8, 1, '2024-10-24 15:12:02', '2024-10-24 15:12:02', NULL, 1, NULL, NULL, NULL, NULL);

-- ----------------------------
-- Table structure for failed_jobs
-- ----------------------------
CREATE TABLE `failed_jobs`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `connection` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `queue` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `exception` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `failed_jobs_uuid_unique`(`uuid` ASC) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of failed_jobs
-- ----------------------------

-- ----------------------------
-- Table structure for file_center
-- ----------------------------
CREATE TABLE `file_center`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `lang_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `order` int NOT NULL DEFAULT 0,
  `status` tinyint NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `seo_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `seo_keywords` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `seo_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `file_center_lang_code_foreign`(`lang_code` ASC) USING BTREE,
  CONSTRAINT `file_center_lang_code_foreign` FOREIGN KEY (`lang_code`) REFERENCES `languages` (`code`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of file_center
-- ----------------------------

-- ----------------------------
-- Table structure for file_center_files
-- ----------------------------
CREATE TABLE `file_center_files`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `file_center_id` bigint UNSIGNED NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `file` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `extension` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `order` int NOT NULL DEFAULT 0,
  `default` tinyint NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `file_center_files_file_center_id_foreign`(`file_center_id` ASC) USING BTREE,
  CONSTRAINT `file_center_files_file_center_id_foreign` FOREIGN KEY (`file_center_id`) REFERENCES `file_center` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of file_center_files
-- ----------------------------

-- ----------------------------
-- Table structure for general_setting_language_relationals
-- ----------------------------
CREATE TABLE `general_setting_language_relationals`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `general_setting_id` bigint UNSIGNED NULL DEFAULT NULL,
  `lang_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `value` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `general_setting_language_relationals_lang_code_foreign`(`lang_code` ASC) USING BTREE,
  INDEX `general_setting_language_relationals_general_setting_id_index`(`general_setting_id` ASC) USING BTREE,
  CONSTRAINT `general_setting_language_relationals_general_setting_id_foreign` FOREIGN KEY (`general_setting_id`) REFERENCES `general_settings` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT,
  CONSTRAINT `general_setting_language_relationals_lang_code_foreign` FOREIGN KEY (`lang_code`) REFERENCES `languages` (`code`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 40 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of general_setting_language_relationals
-- ----------------------------
INSERT INTO `general_setting_language_relationals` VALUES (1, 3, 'tr', 'Seo Anahtar Kelimeler', '2024-09-13 14:31:45', '2024-09-13 14:31:45');
INSERT INTO `general_setting_language_relationals` VALUES (3, 1, 'tr', 'TR Seo Title', '2024-09-13 14:31:45', '2024-09-13 14:48:00');
INSERT INTO `general_setting_language_relationals` VALUES (4, 2, 'tr', 'Seo Description tr', '2024-09-13 14:31:45', '2024-09-13 14:49:55');
INSERT INTO `general_setting_language_relationals` VALUES (5, 3, 'en', 'Seo Anahtar Kelimeler', '2024-09-13 14:31:45', '2024-09-13 14:31:45');
INSERT INTO `general_setting_language_relationals` VALUES (7, 1, 'en', 'EN Seo Title', '2024-09-13 14:31:45', '2024-09-13 14:48:01');
INSERT INTO `general_setting_language_relationals` VALUES (8, 2, 'en', 'en seo desc', '2024-09-13 14:31:45', '2024-09-13 14:31:45');
INSERT INTO `general_setting_language_relationals` VALUES (9, 3, 'fr', 'Seo Anahtar Kelimeler', '2024-09-13 14:31:45', '2024-09-13 14:31:45');
INSERT INTO `general_setting_language_relationals` VALUES (11, 1, 'fr', 'FR Seo Title', '2024-09-13 14:31:45', '2024-09-13 14:48:01');
INSERT INTO `general_setting_language_relationals` VALUES (12, 2, 'fr', 'FR SEO DESC tr', '2024-09-13 14:31:45', '2024-09-13 14:49:55');
INSERT INTO `general_setting_language_relationals` VALUES (13, 5, 'tr', '<!--header code tr-->', '2024-09-13 14:33:19', '2024-09-13 14:33:19');
INSERT INTO `general_setting_language_relationals` VALUES (14, 6, 'tr', '<!--footer code tr-->', '2024-09-13 14:33:19', '2024-09-13 14:33:19');
INSERT INTO `general_setting_language_relationals` VALUES (15, 5, 'en', '<!--header code-->', '2024-09-13 14:33:19', '2024-09-13 14:33:19');
INSERT INTO `general_setting_language_relationals` VALUES (16, 6, 'en', '<!--footer code-->', '2024-09-13 14:33:19', '2024-09-13 14:33:19');
INSERT INTO `general_setting_language_relationals` VALUES (17, 5, 'fr', '<!--header code fr-->', '2024-09-13 14:33:19', '2024-09-13 14:33:19');
INSERT INTO `general_setting_language_relationals` VALUES (18, 6, 'fr', '<!--footer code fr-->', '2024-09-13 14:33:19', '2024-09-13 14:33:19');
INSERT INTO `general_setting_language_relationals` VALUES (19, 17, 'tr', 'Meta Robosts', '2024-09-17 13:43:40', '2024-09-17 13:43:40');
INSERT INTO `general_setting_language_relationals` VALUES (20, 16, 'tr', 'Meta Author', '2024-09-17 13:43:40', '2024-09-17 13:43:40');
INSERT INTO `general_setting_language_relationals` VALUES (21, 19, 'tr', '#facebook', '2024-09-17 13:43:40', '2024-09-17 13:43:40');
INSERT INTO `general_setting_language_relationals` VALUES (22, 20, 'tr', '#twitter', '2024-09-17 13:43:40', '2024-09-17 13:43:40');
INSERT INTO `general_setting_language_relationals` VALUES (23, 21, 'tr', '#instagram', '2024-09-17 13:43:40', '2024-09-17 13:43:40');
INSERT INTO `general_setting_language_relationals` VALUES (24, 22, 'tr', '#youtube', '2024-09-17 13:43:40', '2024-09-17 13:43:40');
INSERT INTO `general_setting_language_relationals` VALUES (25, 23, 'tr', '#linkedin', '2024-09-17 13:43:40', '2024-09-17 13:43:40');
INSERT INTO `general_setting_language_relationals` VALUES (26, 17, 'en', 'Meta Robosts', '2024-09-17 13:43:40', '2024-09-17 13:43:40');
INSERT INTO `general_setting_language_relationals` VALUES (27, 16, 'en', 'Meta Author', '2024-09-17 13:43:40', '2024-09-17 13:43:40');
INSERT INTO `general_setting_language_relationals` VALUES (28, 19, 'en', '#', '2024-09-17 13:43:40', '2024-09-17 13:43:40');
INSERT INTO `general_setting_language_relationals` VALUES (29, 20, 'en', '#', '2024-09-17 13:43:40', '2024-09-17 13:43:40');
INSERT INTO `general_setting_language_relationals` VALUES (30, 21, 'en', '#', '2024-09-17 13:43:40', '2024-09-17 13:43:40');
INSERT INTO `general_setting_language_relationals` VALUES (31, 22, 'en', '#', '2024-09-17 13:43:40', '2024-09-17 13:43:40');
INSERT INTO `general_setting_language_relationals` VALUES (32, 23, 'en', '#', '2024-09-17 13:43:40', '2024-09-17 13:43:40');
INSERT INTO `general_setting_language_relationals` VALUES (33, 17, 'fr', 'Meta Robosts', '2024-09-17 13:43:41', '2024-09-17 13:43:41');
INSERT INTO `general_setting_language_relationals` VALUES (34, 16, 'fr', 'Meta Author', '2024-09-17 13:43:41', '2024-09-17 13:43:41');
INSERT INTO `general_setting_language_relationals` VALUES (35, 19, 'fr', '#', '2024-09-17 13:43:41', '2024-09-17 13:43:41');
INSERT INTO `general_setting_language_relationals` VALUES (36, 20, 'fr', '#', '2024-09-17 13:43:41', '2024-09-17 13:43:41');
INSERT INTO `general_setting_language_relationals` VALUES (37, 21, 'fr', '#', '2024-09-17 13:43:41', '2024-09-17 13:43:41');
INSERT INTO `general_setting_language_relationals` VALUES (38, 22, 'fr', '#', '2024-09-17 13:43:41', '2024-09-17 13:43:41');
INSERT INTO `general_setting_language_relationals` VALUES (39, 23, 'fr', '#', '2024-09-17 13:43:41', '2024-09-17 13:43:41');

-- ----------------------------
-- Table structure for language_translations
-- ----------------------------
CREATE TABLE `language_translations`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `lang_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `translation_id` bigint UNSIGNED NULL DEFAULT NULL,
  `value` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `language_translations_lang_code_foreign`(`lang_code` ASC) USING BTREE,
  INDEX `language_translations_translation_id_index`(`translation_id` ASC) USING BTREE,
  CONSTRAINT `language_translations_lang_code_foreign` FOREIGN KEY (`lang_code`) REFERENCES `languages` (`code`) ON DELETE CASCADE ON UPDATE RESTRICT,
  CONSTRAINT `language_translations_translation_id_foreign` FOREIGN KEY (`translation_id`) REFERENCES `translations` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 46 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of language_translations
-- ----------------------------
INSERT INTO `language_translations` VALUES (4, 'fr', 1, 'Tous droits réservés.', '2024-08-19 17:50:53', '2024-08-19 17:50:53');
INSERT INTO `language_translations` VALUES (5, 'tr', 2, 'Devamı.', '2024-09-10 10:56:57', '2024-09-10 10:56:57');
INSERT INTO `language_translations` VALUES (6, 'tr', 42, 'İletişim', '2024-09-17 16:28:54', '2024-09-17 16:28:54');
INSERT INTO `language_translations` VALUES (7, 'tr', 3, 'Devamı.', '2024-09-17 16:28:54', '2024-09-17 16:28:54');
INSERT INTO `language_translations` VALUES (8, 'tr', 4, 'Ana Sayfa', '2024-09-17 16:28:55', '2024-09-17 16:28:55');
INSERT INTO `language_translations` VALUES (9, 'tr', 5, 'Özellikler', '2024-09-17 16:28:55', '2024-09-17 16:28:55');
INSERT INTO `language_translations` VALUES (10, 'tr', 6, 'Devamı', '2024-09-17 16:28:55', '2024-09-17 16:28:55');
INSERT INTO `language_translations` VALUES (11, 'tr', 7, 'Ürünler', '2024-09-17 16:28:55', '2024-09-17 16:28:55');
INSERT INTO `language_translations` VALUES (12, 'tr', 8, 'Ürünler', '2024-09-17 16:28:55', '2024-09-17 16:28:55');
INSERT INTO `language_translations` VALUES (13, 'tr', 9, 'Ürün Kategorileri', '2024-09-17 16:28:55', '2024-09-17 16:28:55');
INSERT INTO `language_translations` VALUES (14, 'tr', 10, 'Marka', '2024-09-17 16:28:55', '2024-09-17 16:28:55');
INSERT INTO `language_translations` VALUES (15, 'tr', 11, 'Kategori', '2024-09-17 16:28:55', '2024-09-17 16:28:55');
INSERT INTO `language_translations` VALUES (16, 'tr', 12, 'Marka', '2024-09-17 16:28:55', '2024-09-17 16:28:55');
INSERT INTO `language_translations` VALUES (17, 'tr', 13, 'İçerik', '2024-09-17 16:28:55', '2024-09-17 16:28:55');
INSERT INTO `language_translations` VALUES (18, 'tr', 14, 'Resimler', '2024-09-17 16:28:55', '2024-09-17 16:28:55');
INSERT INTO `language_translations` VALUES (19, 'tr', 15, 'Özellikler', '2024-09-17 16:28:55', '2024-09-17 16:28:55');
INSERT INTO `language_translations` VALUES (20, 'tr', 16, 'Dosyalar', '2024-09-17 16:28:55', '2024-09-17 16:28:55');
INSERT INTO `language_translations` VALUES (21, 'tr', 17, 'Görüntüle', '2024-09-17 16:28:55', '2024-09-17 16:28:55');
INSERT INTO `language_translations` VALUES (22, 'tr', 18, 'Ürün Dosyaları', '2024-09-17 16:28:55', '2024-09-17 16:28:55');
INSERT INTO `language_translations` VALUES (23, 'tr', 21, 'Görüntüle', '2024-09-17 16:28:55', '2024-09-17 16:28:55');
INSERT INTO `language_translations` VALUES (24, 'tr', 19, 'İçerik Dosyaları', '2024-09-17 16:28:55', '2024-09-17 16:28:55');
INSERT INTO `language_translations` VALUES (25, 'tr', 20, 'İndir', '2024-09-17 16:28:55', '2024-09-17 16:28:55');
INSERT INTO `language_translations` VALUES (26, 'tr', 22, 'İletişim', '2024-09-17 16:28:55', '2024-09-17 16:28:55');
INSERT INTO `language_translations` VALUES (27, 'tr', 23, 'İletişim Bilgileri', '2024-09-17 16:28:55', '2024-09-17 16:28:55');
INSERT INTO `language_translations` VALUES (28, 'tr', 24, 'İletişim Formu', '2024-09-17 16:28:55', '2024-09-17 16:28:55');
INSERT INTO `language_translations` VALUES (29, 'tr', 25, 'Bilgi Mesajı Gelecektir.', '2024-09-17 16:28:55', '2024-09-17 16:28:55');
INSERT INTO `language_translations` VALUES (30, 'tr', 26, 'Ad Soyad', '2024-09-17 16:28:55', '2024-09-17 16:28:55');
INSERT INTO `language_translations` VALUES (31, 'tr', 27, 'E-mail', '2024-09-17 16:28:55', '2024-09-17 16:28:55');
INSERT INTO `language_translations` VALUES (32, 'tr', 28, 'Konu', '2024-09-17 16:28:55', '2024-09-17 16:28:55');
INSERT INTO `language_translations` VALUES (33, 'tr', 29, 'Mesajınız', '2024-09-17 16:28:55', '2024-09-17 16:28:55');
INSERT INTO `language_translations` VALUES (34, 'tr', 39, 'Telefon', '2024-09-17 16:28:55', '2024-09-17 16:28:55');
INSERT INTO `language_translations` VALUES (35, 'tr', 30, 'Gönder', '2024-09-17 16:28:55', '2024-09-17 16:28:55');
INSERT INTO `language_translations` VALUES (36, 'tr', 31, 'İşlem Yapılıyor.', '2024-09-17 16:28:55', '2024-09-17 16:28:55');
INSERT INTO `language_translations` VALUES (37, 'tr', 32, 'Ad Soyadı Boş Geçmeyiniz.', '2024-09-17 16:28:55', '2024-09-17 16:28:55');
INSERT INTO `language_translations` VALUES (38, 'tr', 33, 'Konuyu Boş Geçmeyiniz.', '2024-09-17 16:28:55', '2024-09-17 16:28:55');
INSERT INTO `language_translations` VALUES (39, 'tr', 34, 'Mesajı Boş Geçmeyiniz.', '2024-09-17 16:28:55', '2024-09-17 16:28:55');
INSERT INTO `language_translations` VALUES (40, 'tr', 35, 'E-mail Adresini Boş Geçmeyiniz.', '2024-09-17 16:28:55', '2024-09-17 16:28:55');
INSERT INTO `language_translations` VALUES (41, 'tr', 36, 'Geçersiz E-mail Formatı.', '2024-09-17 16:28:55', '2024-09-17 16:28:55');
INSERT INTO `language_translations` VALUES (42, 'tr', 40, 'Telefon Numarasını Boş Geçmeyiniz.', '2024-09-17 16:28:55', '2024-09-17 16:28:55');
INSERT INTO `language_translations` VALUES (43, 'tr', 41, 'Geçersiz Telefon Formatı.Başınad 0 olmadan 111-111-11-11 şeklinde giriniz.', '2024-09-17 16:28:55', '2024-09-17 16:28:55');
INSERT INTO `language_translations` VALUES (44, 'tr', 37, 'İletişim Formu Kayıt Altına Alınmadı. Bilgileri Kontrol Edip Tekrar Deneyiniz.', '2024-09-17 16:28:55', '2024-09-17 16:28:55');
INSERT INTO `language_translations` VALUES (45, 'tr', 38, 'Bilgileriniz Kayıt Altına Alınmıştır. Kontrol Edilip Geri Dönüş Yapılacaktır.', '2024-09-17 16:28:55', '2024-09-17 16:28:55');

-- ----------------------------
-- Table structure for languages
-- ----------------------------
CREATE TABLE `languages`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `code` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `order` int NULL DEFAULT 0,
  `status` tinyint NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `default` tinyint NULL DEFAULT 0,
  `image` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `languages_code_unique`(`code` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 18 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of languages
-- ----------------------------
INSERT INTO `languages` VALUES (1, 'tr', 'Türkçe', 'türkçe', 0, 1, NULL, '2024-09-16 10:14:04', 1, 'upload/languages/tr_1726229442.png');
INSERT INTO `languages` VALUES (15, 'en', 'English', 'english', 1, 1, '2024-08-16 15:39:50', '2024-09-16 10:14:09', 0, NULL);
INSERT INTO `languages` VALUES (16, 'fr', 'Fransızca', 'fransızca', 2, 1, '2024-08-19 17:50:22', '2024-09-16 10:14:09', 0, NULL);
INSERT INTO `languages` VALUES (17, 'de', 'Almanca', NULL, 3, 1, '2024-09-17 16:21:51', '2024-09-17 16:21:51', 0, NULL);

-- ----------------------------
-- Table structure for menus
-- ----------------------------
CREATE TABLE `menus`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `theme_id` bigint UNSIGNED NULL DEFAULT NULL,
  `lang_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `menu_type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'menü tipi',
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `route_type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'route tipi',
  `route_status` tinyint NOT NULL DEFAULT 0,
  `constant_route` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'sabit link',
  `dynamic_route` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'dinamik route',
  `dynamic_route_val` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'dynamic route value değeri',
  `target_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'target type',
  `status` tinyint NOT NULL DEFAULT 0,
  `order` int NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `parent` int NULL DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `menus_lang_code_foreign`(`lang_code` ASC) USING BTREE,
  INDEX `menus_theme_id_index`(`theme_id` ASC) USING BTREE,
  CONSTRAINT `menus_lang_code_foreign` FOREIGN KEY (`lang_code`) REFERENCES `languages` (`code`) ON DELETE CASCADE ON UPDATE RESTRICT,
  CONSTRAINT `menus_theme_id_foreign` FOREIGN KEY (`theme_id`) REFERENCES `themes` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 38 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of menus
-- ----------------------------
INSERT INTO `menus` VALUES (22, 1, 'tr', 'header', 'İletişim', 'dynamic', 1, NULL, 'theme.contact.index', NULL, '_self', 1, 6, '2024-09-13 12:30:31', '2024-09-19 13:29:40', 0);
INSERT INTO `menus` VALUES (23, 1, 'tr', 'header', 'Ürünler', 'dynamic', 1, NULL, 'theme.product.index', NULL, '_self', 1, 1, '2024-09-13 12:35:53', '2024-09-17 13:30:38', 27);
INSERT INTO `menus` VALUES (24, 1, 'tr', 'header', 'Anasayfa', 'constant', 1, '/', NULL, NULL, '_self', 1, 1, '2024-09-13 14:51:47', '2024-09-13 14:51:51', 0);
INSERT INTO `menus` VALUES (25, 1, 'tr', 'header', 'Blog', 'dynamic', 1, NULL, 'theme.content.categories.index', 'blog', '_self', 1, 5, '2024-09-13 14:52:12', '2024-09-19 13:29:40', 0);
INSERT INTO `menus` VALUES (26, 1, 'tr', 'header', 'Kurumsal', 'dynamic', 1, NULL, 'theme.content.index', 'kurumsal', '_self', 1, 4, '2024-09-14 12:50:40', '2024-09-19 13:29:40', 0);
INSERT INTO `menus` VALUES (27, 1, 'tr', 'header', 'Vizyon', 'dynamic', 1, NULL, 'theme.content.index', 'vizyon', '_self', 1, 1, '2024-09-14 12:51:34', '2024-09-19 13:29:40', 26);
INSERT INTO `menus` VALUES (28, 1, 'tr', 'footer', 'Anasayfa', 'constant', 1, '/', NULL, NULL, '_self', 1, 1, '2024-09-14 12:59:19', '2024-09-19 14:29:05', 0);
INSERT INTO `menus` VALUES (29, 1, 'tr', 'footer', 'İletişim', 'dynamic', 1, NULL, 'theme.contact.index', NULL, '_self', 1, 2, '2024-09-14 12:59:33', '2024-09-19 14:29:05', 0);
INSERT INTO `menus` VALUES (30, 1, 'tr', 'header', 'Galeri', 'dynamic', 1, NULL, 'theme.content.categories.index', 'galeri', '_self', 1, 3, '2024-09-14 16:47:45', '2024-09-19 13:29:40', 0);
INSERT INTO `menus` VALUES (32, 1, 'tr', 'header', 'Katalog', 'dynamic', 1, NULL, 'theme.file_center.index', 'lorem-ipsum', '_self', 1, 1, '2024-09-16 11:59:26', '2024-09-19 13:29:27', 33);
INSERT INTO `menus` VALUES (33, 1, 'tr', 'header', 'Tamamlanan Projeler', 'dynamic', 1, NULL, 'theme.content.categories.index', 'tamamlanan-projeler', '_self', 1, 1, '2024-09-17 16:25:35', '2024-09-19 13:29:25', 25);
INSERT INTO `menus` VALUES (34, 1, 'tr', 'header', 'Yedek Parça', 'dynamic', 1, NULL, 'theme.product.categories.index', 'yedek-parca', '_self', 1, 2, '2024-09-17 16:37:11', '2024-09-17 16:37:17', 0);
INSERT INTO `menus` VALUES (35, 1, 'tr', 'header', 'Yedekparça', 'dynamic', 0, NULL, 'theme.product.categories.index', 'yedek-parca', '_self', 1, 8, '2024-09-19 14:28:42', '2024-09-19 14:28:42', 0);
INSERT INTO `menus` VALUES (37, 1, 'tr', 'footer', 'Kurumsal', 'dynamic', 1, NULL, 'theme.content.index', 'kurumsal', '_self', 1, 1, '2024-09-19 14:31:42', '2024-09-19 14:31:46', 28);

-- ----------------------------
-- Table structure for migrations
-- ----------------------------
CREATE TABLE `migrations`  (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `batch` int NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 90 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of migrations
-- ----------------------------
INSERT INTO `migrations` VALUES (1, '2014_10_12_000000_create_users_table', 1);
INSERT INTO `migrations` VALUES (2, '2014_10_12_100000_create_password_reset_tokens_table', 1);
INSERT INTO `migrations` VALUES (3, '2019_08_19_000000_create_failed_jobs_table', 1);
INSERT INTO `migrations` VALUES (4, '2019_12_14_000001_create_personal_access_tokens_table', 1);
INSERT INTO `migrations` VALUES (5, '2024_08_07_160034_create_languages_table', 1);
INSERT INTO `migrations` VALUES (6, '2024_08_07_160039_create_themes_table', 1);
INSERT INTO `migrations` VALUES (7, '2024_08_09_145832_module_table', 2);
INSERT INTO `migrations` VALUES (8, '2024_08_10_143937_create_theme_settings', 3);
INSERT INTO `migrations` VALUES (9, '2024_08_10_150323_theme_alanlar', 4);
INSERT INTO `migrations` VALUES (10, '2024_08_10_155425_create_theme_global_settings_alanlar', 5);
INSERT INTO `migrations` VALUES (11, '2024_08_10_160555_create_theme_global_settings_alanlar', 6);
INSERT INTO `migrations` VALUES (12, '2024_08_10_163300_create_theme_global_settings_alanlar', 7);
INSERT INTO `migrations` VALUES (13, '2024_08_12_151205_create_theme_components', 8);
INSERT INTO `migrations` VALUES (14, '2024_08_12_162445_theme_components', 9);
INSERT INTO `migrations` VALUES (15, '2024_08_13_104823_create_theme_component_relationals', 10);
INSERT INTO `migrations` VALUES (16, '2024_08_13_131147_create_languages', 11);
INSERT INTO `migrations` VALUES (17, '2024_08_13_131452_create_languages', 12);
INSERT INTO `migrations` VALUES (19, '2024_08_14_094141_create_theme_component_relationals', 14);
INSERT INTO `migrations` VALUES (20, '2024_08_14_145327_create_theme_component_relationals', 15);
INSERT INTO `migrations` VALUES (21, '2024_08_14_150040_create_theme_component_relationals', 16);
INSERT INTO `migrations` VALUES (24, '2024_08_15_121954_create_theme_component_relationals', 18);
INSERT INTO `migrations` VALUES (26, '2024_08_15_114748_create_theme_component_slider_image', 20);
INSERT INTO `migrations` VALUES (27, '2024_08_15_124441_create_theme_component_relationals', 21);
INSERT INTO `migrations` VALUES (28, '2024_08_15_132409_create_theme_component_relationals', 22);
INSERT INTO `migrations` VALUES (32, '2024_08_15_165251_create_theme_component_constants', 23);
INSERT INTO `migrations` VALUES (35, '2024_08_16_140902_create_language_translations', 24);
INSERT INTO `migrations` VALUES (38, '2024_08_13_141710_create_contents_table', 25);
INSERT INTO `migrations` VALUES (39, '2024_08_17_130248_create_content_categories', 26);
INSERT INTO `migrations` VALUES (40, '2024_08_17_135710_create_contents_fields', 27);
INSERT INTO `migrations` VALUES (42, '2024_08_21_154433_create_content_features_table', 28);
INSERT INTO `migrations` VALUES (43, '2024_09_09_174432_create_theme_component_relationals_table', 29);
INSERT INTO `migrations` VALUES (44, '2024_09_09_175249_create_theme_component_relationals_table', 30);
INSERT INTO `migrations` VALUES (45, '2024_09_11_091815_create_products_table', 31);
INSERT INTO `migrations` VALUES (46, '2024_09_11_101842_create_products_table', 32);
INSERT INTO `migrations` VALUES (47, '2024_09_11_131304_create_products_table', 33);
INSERT INTO `migrations` VALUES (48, '2024_09_11_161713_product_features_options', 34);
INSERT INTO `migrations` VALUES (49, '2024_09_12_102454_create_product_table', 35);
INSERT INTO `migrations` VALUES (50, '2024_09_12_132237_create_theme_component_relational', 36);
INSERT INTO `migrations` VALUES (51, '2024_09_12_155133_create_menu_table', 36);
INSERT INTO `migrations` VALUES (52, '2024_09_12_165819_create_menu_table', 37);
INSERT INTO `migrations` VALUES (53, '2024_09_12_172808_create_menu_table', 37);
INSERT INTO `migrations` VALUES (54, '2024_09_13_130611_create_general_settings', 38);
INSERT INTO `migrations` VALUES (55, '2024_09_13_134442_create_general_settings', 39);
INSERT INTO `migrations` VALUES (56, '2024_09_13_153448_content_categories_image', 40);
INSERT INTO `migrations` VALUES (57, '2024_09_14_151533_create_product_table', 41);
INSERT INTO `migrations` VALUES (58, '2024_09_14_165141_create_content_table', 42);
INSERT INTO `migrations` VALUES (63, '2024_09_16_093621_create_file_centers', 43);
INSERT INTO `migrations` VALUES (64, '2024_09_16_123722_create_file_center', 44);
INSERT INTO `migrations` VALUES (65, '2024_09_16_132306_create_contact_info', 45);
INSERT INTO `migrations` VALUES (69, '2024_09_16_134542_create_contact_form', 46);
INSERT INTO `migrations` VALUES (72, '2024_09_16_151829_create_smtp_settings', 47);
INSERT INTO `migrations` VALUES (75, '2024_09_16_170458_theme_component_contents', 48);
INSERT INTO `migrations` VALUES (77, '2024_09_17_104444_theme_color', 49);
INSERT INTO `migrations` VALUES (78, '2024_09_17_114722_create_content_categories_seo', 50);
INSERT INTO `migrations` VALUES (79, '2024_09_17_115512_create_content_categories_seo', 51);
INSERT INTO `migrations` VALUES (80, '2024_09_17_122253_create_theme_component_relationals_contents', 52);
INSERT INTO `migrations` VALUES (81, '2024_09_19_142236_create_contact_info', 53);
INSERT INTO `migrations` VALUES (82, '2024_09_25_102348_create_theme_component_constants', 54);
INSERT INTO `migrations` VALUES (83, '2024_09_25_173010_theme_component_relationals', 55);
INSERT INTO `migrations` VALUES (84, '2024_10_24_104305_contact_infos', 56);
INSERT INTO `migrations` VALUES (85, '2024_10_24_123434_theme_component_relationals', 57);
INSERT INTO `migrations` VALUES (86, '2024_10_24_124619_theme_component_relationals', 58);
INSERT INTO `migrations` VALUES (87, '2024_10_24_161944_theme_component_relationals', 59);
INSERT INTO `migrations` VALUES (88, '2024_11_01_155325_theme_component_slider_images', 60);
INSERT INTO `migrations` VALUES (89, '2024_11_01_155403_theme_component_slider_images', 61);

-- ----------------------------
-- Records of personal_access_tokens
-- ----------------------------

-- ----------------------------
-- Table structure for product_brands
-- ----------------------------
CREATE TABLE `product_brands`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `lang_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `order` int NOT NULL DEFAULT 0,
  `status` tinyint NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `image` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `product_brands_slug_unique`(`slug` ASC) USING BTREE,
  INDEX `product_brands_lang_code_foreign`(`lang_code` ASC) USING BTREE,
  CONSTRAINT `product_brands_lang_code_foreign` FOREIGN KEY (`lang_code`) REFERENCES `languages` (`code`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of product_brands
-- ----------------------------
INSERT INTO `product_brands` VALUES (8, 'tr', 'asdasd', NULL, 'asdasd', 1, 1, '2024-09-12 13:59:24', '2024-09-12 13:59:24', NULL);

-- ----------------------------
-- Table structure for product_categories
-- ----------------------------
CREATE TABLE `product_categories`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `lang_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `order` int NOT NULL DEFAULT 0,
  `status` tinyint NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `parent` int NULL DEFAULT 0,
  `banner_image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `seo_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `seo_keywords` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `seo_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `product_categories_slug_unique`(`slug` ASC) USING BTREE,
  INDEX `product_categories_lang_code_foreign`(`lang_code` ASC) USING BTREE,
  CONSTRAINT `product_categories_lang_code_foreign` FOREIGN KEY (`lang_code`) REFERENCES `languages` (`code`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 21 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of product_categories
-- ----------------------------
INSERT INTO `product_categories` VALUES (19, 'tr', 'Yedek Parça', NULL, 'yedek-parca', 1, 1, '2024-09-17 16:36:17', '2024-09-17 16:36:17', 0, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `product_categories` VALUES (20, 'tr', 'Özel Maşonlu Çelik Kolon Borusu Aktif', NULL, 'ozel-masonlu-celik-kolon-borusu-aktif', 2, 1, '2024-10-22 17:44:00', '2024-10-22 17:44:00', 0, NULL, NULL, NULL, NULL, NULL);

-- ----------------------------
-- Table structure for product_categories_relationals
-- ----------------------------
CREATE TABLE `product_categories_relationals`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `product_id` bigint UNSIGNED NOT NULL,
  `product_categories_id` bigint UNSIGNED NOT NULL,
  `order` int NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `product_categories_relationals_product_id_foreign`(`product_id` ASC) USING BTREE,
  INDEX `product_categories_relationals_product_categories_id_foreign`(`product_categories_id` ASC) USING BTREE,
  CONSTRAINT `product_categories_relationals_product_categories_id_foreign` FOREIGN KEY (`product_categories_id`) REFERENCES `product_categories` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT,
  CONSTRAINT `product_categories_relationals_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 34 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of product_categories_relationals
-- ----------------------------
INSERT INTO `product_categories_relationals` VALUES (28, 19, 19, 1, '2024-09-17 16:38:33', '2024-09-17 16:38:33');
INSERT INTO `product_categories_relationals` VALUES (33, 20, 19, 1, '2024-10-24 10:22:33', '2024-10-24 10:22:33');

-- ----------------------------
-- Table structure for product_feature_relationals
-- ----------------------------
CREATE TABLE `product_feature_relationals`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `product_id` bigint UNSIGNED NOT NULL,
  `product_feature_id` bigint UNSIGNED NOT NULL,
  `value` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `order` int NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `product_feature_relationals_product_id_foreign`(`product_id` ASC) USING BTREE,
  INDEX `product_feature_relationals_product_feature_id_foreign`(`product_feature_id` ASC) USING BTREE,
  CONSTRAINT `product_feature_relationals_product_feature_id_foreign` FOREIGN KEY (`product_feature_id`) REFERENCES `product_features` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT,
  CONSTRAINT `product_feature_relationals_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 37 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of product_feature_relationals
-- ----------------------------
INSERT INTO `product_feature_relationals` VALUES (35, 19, 8, 'Sıfır', 0, '2024-09-17 16:40:32', '2024-09-17 16:40:32');
INSERT INTO `product_feature_relationals` VALUES (36, 19, 10, '18.09.2024', 0, '2024-09-17 16:40:32', '2024-09-17 16:40:32');

-- ----------------------------
-- Table structure for product_features
-- ----------------------------
CREATE TABLE `product_features`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `lang_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `order` int NOT NULL DEFAULT 0,
  `status` tinyint NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `select_options` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `product_features_lang_code_foreign`(`lang_code` ASC) USING BTREE,
  CONSTRAINT `product_features_lang_code_foreign` FOREIGN KEY (`lang_code`) REFERENCES `languages` (`code`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 13 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of product_features
-- ----------------------------
INSERT INTO `product_features` VALUES (8, 'tr', 'Araç Tipi', 'araç tipi seçenekleri', 'select', 2, 1, '2024-09-12 15:18:08', '2024-09-17 11:23:54', '[\"S\\u0131f\\u0131r\",\"2.El\",\"Yar\\u0131 Otomatik\"]');
INSERT INTO `product_features` VALUES (9, 'tr', 'Tipler #select', NULL, 'select', 0, 1, '2024-09-12 15:18:21', '2024-09-17 11:23:54', '[\"tip-1\",\"tip-2\"]');
INSERT INTO `product_features` VALUES (10, 'tr', '#tarih', NULL, 'date', 1, 1, '2024-09-12 15:18:46', '2024-09-17 11:23:54', '[]');
INSERT INTO `product_features` VALUES (11, 'tr', '#text', NULL, 'text', 3, 1, '2024-09-12 15:18:53', '2024-09-17 11:23:54', '[]');
INSERT INTO `product_features` VALUES (12, 'tr', '#input', NULL, 'input', 4, 1, '2024-09-12 15:19:00', '2024-09-17 11:23:54', '[]');

-- ----------------------------
-- Table structure for product_images
-- ----------------------------
CREATE TABLE `product_images`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `product_id` bigint UNSIGNED NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `extension` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `order` int NOT NULL DEFAULT 0,
  `default` tinyint NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `product_images_product_id_foreign`(`product_id` ASC) USING BTREE,
  CONSTRAINT `product_images_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 27 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of product_images
-- ----------------------------
INSERT INTO `product_images` VALUES (25, 19, '', 'upload/product/1726580364-66e9868ce9eb6.jpg', 'jpg', 1, 1, '2024-09-17 16:39:24', '2024-09-17 16:39:24');
INSERT INTO `product_images` VALUES (26, 20, '', 'upload/product/1729754482-6719f5726685e.png', 'png', 1, 1, '2024-10-24 10:21:22', '2024-10-24 10:21:22');

-- ----------------------------
-- Table structure for products
-- ----------------------------
CREATE TABLE `products`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `lang_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `short_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `order` int NOT NULL DEFAULT 0,
  `status` tinyint NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `brand_id` int NULL DEFAULT NULL,
  `file_center_id` int NULL DEFAULT 0,
  `seo_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `seo_keywords` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `seo_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `products_slug_unique`(`slug` ASC) USING BTREE,
  INDEX `products_lang_code_foreign`(`lang_code` ASC) USING BTREE,
  CONSTRAINT `products_lang_code_foreign` FOREIGN KEY (`lang_code`) REFERENCES `languages` (`code`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 21 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of products
-- ----------------------------
INSERT INTO `products` VALUES (19, 'tr', 'İTHAL 13360795S | Opel Astra J Otomatik Vites Topuzu Nikelajlı Siyah Renkli', 'Opel astra j otomatik vitesli araçlara uygun siyah renkli vites topuzudur. Ürün ithal malzeme olup kalitelidir.', NULL, 'opel-astra-otomatik-vites', 1, 1, '2024-09-17 16:38:33', '2024-09-17 16:38:33', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `products` VALUES (20, 'tr', 'test', NULL, NULL, 'test', 2, 1, '2024-10-24 10:21:13', '2024-10-24 10:22:33', NULL, NULL, NULL, NULL, NULL);

-- ----------------------------
-- Table structure for theme_color_relationals
-- ----------------------------
CREATE TABLE `theme_color_relationals`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `theme_id` bigint UNSIGNED NULL DEFAULT NULL,
  `theme_color_parameter_id` bigint UNSIGNED NULL DEFAULT NULL,
  `val` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `order` int NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `theme_color_relationals_theme_id_index`(`theme_id` ASC) USING BTREE,
  INDEX `theme_color_relationals_theme_color_parameter_id_index`(`theme_color_parameter_id` ASC) USING BTREE,
  CONSTRAINT `theme_color_relationals_theme_color_parameter_id_foreign` FOREIGN KEY (`theme_color_parameter_id`) REFERENCES `theme_color_parameters` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT,
  CONSTRAINT `theme_color_relationals_theme_id_foreign` FOREIGN KEY (`theme_id`) REFERENCES `themes` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 15 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of theme_color_relationals
-- ----------------------------
INSERT INTO `theme_color_relationals` VALUES (1, 1, 1, '#ed0000', 0, '2024-09-17 11:14:25', '2024-09-17 16:21:29');
INSERT INTO `theme_color_relationals` VALUES (2, 1, 3, '#361515', 0, '2024-09-17 11:14:25', '2024-09-17 16:21:29');
INSERT INTO `theme_color_relationals` VALUES (3, 1, 4, '#7300ff', 0, '2024-09-17 11:14:25', '2024-09-17 11:21:16');
INSERT INTO `theme_color_relationals` VALUES (4, 1, 5, '#919191', 0, '2024-09-17 11:14:25', '2024-09-17 16:21:29');
INSERT INTO `theme_color_relationals` VALUES (5, 1, 6, '#c97171', 0, '2024-09-17 11:14:25', '2024-09-17 11:14:25');
INSERT INTO `theme_color_relationals` VALUES (6, 1, 7, '#c97171', 0, '2024-09-17 11:14:25', '2024-09-17 11:14:25');
INSERT INTO `theme_color_relationals` VALUES (7, 1, 8, '#c97171', 0, '2024-09-17 11:14:25', '2024-09-17 11:14:25');
INSERT INTO `theme_color_relationals` VALUES (8, 1, 9, '#c9c971', 0, '2024-09-17 11:14:25', '2024-09-17 11:14:40');
INSERT INTO `theme_color_relationals` VALUES (9, 1, 10, '#c97171', 0, '2024-09-17 11:14:25', '2024-09-17 11:14:25');
INSERT INTO `theme_color_relationals` VALUES (10, 1, 11, '#c97171', 0, '2024-09-17 11:14:25', '2024-09-17 11:14:25');
INSERT INTO `theme_color_relationals` VALUES (11, 1, 12, '#c97171', 0, '2024-09-17 11:14:25', '2024-09-17 11:14:25');
INSERT INTO `theme_color_relationals` VALUES (12, 1, 13, '#c97171', 0, '2024-09-17 11:14:25', '2024-09-17 11:14:25');
INSERT INTO `theme_color_relationals` VALUES (13, 1, 14, '#c97171', 0, '2024-09-17 11:14:25', '2024-09-17 11:14:25');

-- ----------------------------
-- Table structure for theme_component_constants
-- ----------------------------
CREATE TABLE `theme_component_constants`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `theme_id` bigint UNSIGNED NULL DEFAULT NULL,
  `theme_component_rel_id` bigint UNSIGNED NULL DEFAULT NULL,
  `lang_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `extension` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `link` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `image_position` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `position` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `link_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `theme_component_constants_lang_code_foreign`(`lang_code` ASC) USING BTREE,
  INDEX `theme_component_constants_theme_id_index`(`theme_id` ASC) USING BTREE,
  INDEX `theme_component_constants_theme_component_rel_id_index`(`theme_component_rel_id` ASC) USING BTREE,
  CONSTRAINT `theme_component_constants_lang_code_foreign` FOREIGN KEY (`lang_code`) REFERENCES `languages` (`code`) ON DELETE CASCADE ON UPDATE RESTRICT,
  CONSTRAINT `theme_component_constants_theme_component_rel_id_foreign` FOREIGN KEY (`theme_component_rel_id`) REFERENCES `theme_component_relationals` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT,
  CONSTRAINT `theme_component_constants_theme_id_foreign` FOREIGN KEY (`theme_id`) REFERENCES `themes` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 67 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of theme_component_constants
-- ----------------------------
INSERT INTO `theme_component_constants` VALUES (59, 1, 96, 'tr', 'test2', NULL, NULL, NULL, '#link', '2024-10-24 16:17:39', '2024-10-24 16:23:35', 'left', 'container', 'linkBaşlıktr');
INSERT INTO `theme_component_constants` VALUES (60, 1, 96, 'en', NULL, NULL, NULL, NULL, NULL, '2024-10-24 16:17:39', '2024-10-24 16:22:27', 'left', 'full', 'linkaşlıken');
INSERT INTO `theme_component_constants` VALUES (61, 1, 96, 'fr', NULL, NULL, NULL, NULL, NULL, '2024-10-24 16:17:39', '2024-10-24 16:17:39', 'left', 'full', NULL);
INSERT INTO `theme_component_constants` VALUES (62, 1, 96, 'de', NULL, NULL, NULL, NULL, NULL, '2024-10-24 16:17:39', '2024-10-24 16:17:39', 'left', 'full', NULL);
INSERT INTO `theme_component_constants` VALUES (63, 1, 100, 'tr', 'asd', '<p><strong>G&ouml;khan Şap&ccedil;ıoğlu Boru</strong></p>\r\n\r\n<p>G&ouml;khan Şap&ccedil;ıoğlu Sondaj Boru Firması olarak, yılların deneyimi ve bilgi birikimiyle sondaj boruları sekt&ouml;r&uuml;nde &ouml;nc&uuml; konumdayız. Kuruluşumuzdan bu yana, m&uuml;şteri memnuniyetini en &uuml;st seviyede tutarak, kaliteli, dayanıklı ve g&uuml;venilir &uuml;r&uuml;nler sunmayı ilke edindik. Modern &uuml;retim tesislerimiz ve alanında uzman ekibimizle, sekt&ouml;rdeki taleplere en iyi &ccedil;&ouml;z&uuml;mleri sunmayı hedefliyoruz.</p>\r\n\r\n<h3><strong>Misyonumuz</strong></h3>\r\n\r\n<p>Doğal kaynakların verimli ve s&uuml;rd&uuml;r&uuml;lebilir kullanımını desteklemek amacıyla, sekt&ouml;re yenilik&ccedil;i ve &ccedil;evre dostu &ccedil;&ouml;z&uuml;mler sunuyoruz. Kaliteli ve g&uuml;venilir &uuml;r&uuml;nlerimizle, m&uuml;şterilerimize su temini konusunda en iyi hizmeti sağlamayı ama&ccedil;lıyoruz. Misyonumuz, su kaynaklarını koruma ve verimli kullanma konusundaki s&uuml;rekli gelişim &ccedil;abalarımızla sekt&ouml;re &ouml;nc&uuml;l&uuml;k etmektir.</p>\r\n\r\n<h3><strong>Vizyonumuz</strong></h3>\r\n\r\n<p>Ulusal ve uluslararası arenada sondaj boruları sekt&ouml;r&uuml;nde tanınan ve tercih edilen bir marka olmayı hedefliyoruz. M&uuml;şteri memnuniyetini ve kaliteyi her zaman &ouml;n planda tutarak, &ccedil;evreye duyarlı &uuml;retim anlayışımızla gelecek nesillere daha yaşanabilir bir d&uuml;nya bırakmayı ama&ccedil;lıyoruz. Vizyonumuz, yenilik&ccedil;i &ccedil;&ouml;z&uuml;mlerle sekt&ouml;rde y&ouml;n belirleyen bir g&uuml;&ccedil; olmaktır.</p>', 'upload/themes/components/1730455059_tr_1728137177_tr_sondajboru.jpg', NULL, '#link', '2024-11-01 12:43:23', '2024-11-01 13:02:06', 'right', 'full', 'linkBaşlık');
INSERT INTO `theme_component_constants` VALUES (64, 1, 100, 'en', NULL, NULL, NULL, NULL, NULL, '2024-11-01 12:43:23', '2024-11-01 12:43:23', 'left', 'full', NULL);
INSERT INTO `theme_component_constants` VALUES (65, 1, 100, 'fr', NULL, NULL, NULL, NULL, NULL, '2024-11-01 12:43:23', '2024-11-01 12:43:23', 'left', 'full', NULL);
INSERT INTO `theme_component_constants` VALUES (66, 1, 100, 'de', NULL, NULL, NULL, NULL, NULL, '2024-11-01 12:43:23', '2024-11-01 12:43:23', 'left', 'full', NULL);

-- ----------------------------
-- Table structure for theme_component_contents
-- ----------------------------
CREATE TABLE `theme_component_contents`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `theme_id` bigint UNSIGNED NULL DEFAULT NULL,
  `theme_component_rel_id` bigint UNSIGNED NULL DEFAULT NULL,
  `lang_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `content_id` int NULL DEFAULT NULL,
  `order` int NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `theme_component_contents_lang_code_foreign`(`lang_code` ASC) USING BTREE,
  INDEX `theme_component_contents_theme_id_index`(`theme_id` ASC) USING BTREE,
  INDEX `theme_component_contents_theme_component_rel_id_index`(`theme_component_rel_id` ASC) USING BTREE,
  INDEX `theme_component_contents_content_id_index`(`content_id` ASC) USING BTREE,
  CONSTRAINT `theme_component_contents_lang_code_foreign` FOREIGN KEY (`lang_code`) REFERENCES `languages` (`code`) ON DELETE CASCADE ON UPDATE RESTRICT,
  CONSTRAINT `theme_component_contents_theme_component_rel_id_foreign` FOREIGN KEY (`theme_component_rel_id`) REFERENCES `theme_component_relationals` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT,
  CONSTRAINT `theme_component_contents_theme_id_foreign` FOREIGN KEY (`theme_id`) REFERENCES `themes` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 15 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of theme_component_contents
-- ----------------------------
INSERT INTO `theme_component_contents` VALUES (14, 1, 99, 'tr', 31, 1, '2024-11-01 12:36:30', '2024-11-01 12:36:30');

-- ----------------------------
-- Table structure for theme_component_relationals
-- ----------------------------
CREATE TABLE `theme_component_relationals`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `theme_id` bigint UNSIGNED NULL DEFAULT NULL,
  `theme_component_id` bigint UNSIGNED NULL DEFAULT NULL,
  `status` tinyint NOT NULL DEFAULT 0,
  `order` int NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `component_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `limit` int NULL DEFAULT NULL,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `link` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `content_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `slider_width` int NULL DEFAULT NULL,
  `slider_height` int NULL DEFAULT NULL,
  `category_list` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `component_settings` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `margin_top` int NULL DEFAULT 0,
  `margin_right` int NULL DEFAULT 0,
  `margin_bottom` int NULL DEFAULT 0,
  `margin_left` int NULL DEFAULT 0,
  `padding_top` int NULL DEFAULT 0,
  `padding_right` int NULL DEFAULT 0,
  `padding_bottom` int NULL DEFAULT 0,
  `padding_left` int NULL DEFAULT 0,
  `bg_color` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `theme_component_relationals_theme_id_index`(`theme_id` ASC) USING BTREE,
  INDEX `theme_component_relationals_theme_component_id_index`(`theme_component_id` ASC) USING BTREE,
  CONSTRAINT `theme_component_relationals_theme_component_id_foreign` FOREIGN KEY (`theme_component_id`) REFERENCES `theme_components` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT,
  CONSTRAINT `theme_component_relationals_theme_id_foreign` FOREIGN KEY (`theme_id`) REFERENCES `themes` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 103 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of theme_component_relationals
-- ----------------------------
INSERT INTO `theme_component_relationals` VALUES (95, 1, 20, 1, 1, '2024-10-24 16:00:00', '2024-11-01 12:42:14', 'slider', 'Başlık - Galeri', NULL, 5, NULL, NULL, NULL, NULL, 220, 240, NULL, '{\"tr\":{\"title\":\"Make events even better.\",\"description\":\"Planning to carrying out every event in an organized manner, using professional staff is our expertise.\",\"link\":null,\"link_text\":\"testLinkBa\\u015fl\\u0131k\"},\"en\":{\"title\":null,\"description\":null,\"link\":null,\"link_text\":null},\"fr\":{\"title\":null,\"description\":null,\"link\":null,\"link_text\":null},\"de\":{\"title\":null,\"description\":null,\"link\":null,\"link_text\":null}}', 0, 0, 0, 0, 100, 0, 100, 0, '#d65e5e');
INSERT INTO `theme_component_relationals` VALUES (96, 1, 21, 1, 2, '2024-10-24 16:16:06', '2024-10-24 16:38:43', 'constant', 'Sabit İçerik-2', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '[]', 10, 0, 10, 0, 50, 0, 50, 0, '#2e5e1f');
INSERT INTO `theme_component_relationals` VALUES (97, 1, 20, 1, 3, '2024-11-01 12:34:21', '2024-11-01 12:34:21', 'slider', 'Slider Galeri', NULL, 5, NULL, NULL, NULL, NULL, 1920, 600, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL);
INSERT INTO `theme_component_relationals` VALUES (98, 1, 21, 1, 4, '2024-11-01 12:34:42', '2024-11-01 12:34:42', 'constant', 'aa', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL);
INSERT INTO `theme_component_relationals` VALUES (99, 1, 12, 1, 5, '2024-11-01 12:36:19', '2024-11-01 12:39:12', 'content', 'a', NULL, 5, NULL, NULL, NULL, 'content', NULL, NULL, NULL, '{\"tr\":{\"title\":\"content\",\"description\":\"a\\u0131klama\",\"link\":\"#link\",\"link_text\":\"#linkText\"},\"en\":{\"title\":null,\"description\":null,\"link\":null,\"link_text\":null},\"fr\":{\"title\":null,\"description\":null,\"link\":null,\"link_text\":null},\"de\":{\"title\":null,\"description\":null,\"link\":null,\"link_text\":null}}', 0, 0, 0, 0, 0, 0, 0, 0, NULL);
INSERT INTO `theme_component_relationals` VALUES (100, 1, 9, 1, 6, '2024-11-01 12:43:10', '2024-11-01 12:43:10', 'constant', 'Sabit', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL);
INSERT INTO `theme_component_relationals` VALUES (101, 1, 22, 1, 0, '2024-11-01 13:52:37', '2024-11-01 13:53:26', 'slider', 'Video Slider', NULL, 5, NULL, NULL, NULL, NULL, 1920, 600, NULL, '{\"tr\":{\"title\":\"Video Slider\",\"description\":\"Video Slider\",\"link\":null,\"link_text\":null},\"en\":{\"title\":null,\"description\":null,\"link\":null,\"link_text\":null},\"fr\":{\"title\":null,\"description\":null,\"link\":null,\"link_text\":null},\"de\":{\"title\":null,\"description\":null,\"link\":null,\"link_text\":null}}', 0, 0, 0, 0, 0, 0, 0, 0, NULL);
INSERT INTO `theme_component_relationals` VALUES (102, 1, 22, 1, 7, '2024-11-01 15:34:05', '2024-11-01 15:34:05', 'slider', 'Video Slider', NULL, 5, NULL, NULL, NULL, NULL, 1920, 600, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL);

-- ----------------------------
-- Table structure for theme_component_slider_images
-- ----------------------------
CREATE TABLE `theme_component_slider_images`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `theme_id` bigint UNSIGNED NULL DEFAULT NULL,
  `theme_component_rel_id` bigint UNSIGNED NULL DEFAULT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `extension` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `order` int NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `lang_id` bigint UNSIGNED NOT NULL,
  `link` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `video_link` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `theme_component_slider_images_theme_id_index`(`theme_id` ASC) USING BTREE,
  INDEX `theme_component_slider_images_theme_component_rel_id_index`(`theme_component_rel_id` ASC) USING BTREE,
  INDEX `theme_component_slider_images_lang_id_foreign`(`lang_id` ASC) USING BTREE,
  CONSTRAINT `theme_component_slider_images_lang_id_foreign` FOREIGN KEY (`lang_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT,
  CONSTRAINT `theme_component_slider_images_theme_component_rel_id_foreign` FOREIGN KEY (`theme_component_rel_id`) REFERENCES `theme_component_relationals` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT,
  CONSTRAINT `theme_component_slider_images_theme_id_foreign` FOREIGN KEY (`theme_id`) REFERENCES `themes` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 45 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of theme_component_slider_images
-- ----------------------------
INSERT INTO `theme_component_slider_images` VALUES (42, 1, 95, NULL, NULL, 'upload/themes/components/slider_1729775185.jpg', 'jpg', 1, '2024-10-24 16:06:25', '2024-10-24 16:06:25', 1, NULL, NULL);
INSERT INTO `theme_component_slider_images` VALUES (44, 1, 102, 'Tarım', NULL, 'upload/themes/components/slider_1730465854.jpg', 'jpg', 2, '2024-11-01 15:57:35', '2024-11-01 15:57:35', 1, NULL, 'nURLuN3C60A');

-- ----------------------------
-- Table structure for theme_components
-- ----------------------------
CREATE TABLE `theme_components`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `theme_id` bigint UNSIGNED NULL DEFAULT NULL,
  `component` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'component tipi',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `preview_image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `theme_components_theme_id_index`(`theme_id` ASC) USING BTREE,
  CONSTRAINT `theme_components_theme_id_foreign` FOREIGN KEY (`theme_id`) REFERENCES `themes` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 23 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of theme_components
-- ----------------------------
INSERT INTO `theme_components` VALUES (8, 1, 'banner1', 'banner', NULL, NULL, 'Banner', 'banner-component.png');
INSERT INTO `theme_components` VALUES (9, 1, 'sabit-icerik', 'constant', NULL, NULL, 'Sabit', 'sabit-icerik.png');
INSERT INTO `theme_components` VALUES (10, 1, 'slider1', 'slider', NULL, NULL, 'Slider', 'slider1.png');
INSERT INTO `theme_components` VALUES (11, 1, 'categories-content-1', 'categories-content', NULL, NULL, 'Kategori İçerik', 'kategori-icerik-1.png');
INSERT INTO `theme_components` VALUES (12, 1, 'content-1', 'content', NULL, NULL, 'İçerik', 'icerik-1.png');
INSERT INTO `theme_components` VALUES (13, 1, 'banner-slider-1', 'slider', NULL, NULL, 'Banner Slider', 'banner-slider-1.png');
INSERT INTO `theme_components` VALUES (14, 1, 'slider-categories-content-1', 'categories-content', NULL, NULL, 'Slider - Kategori İçerik', 'slider-categories-content-1.png');
INSERT INTO `theme_components` VALUES (15, 1, 'slider-categories-content-2', 'categories-content', NULL, NULL, 'Slider - Kategori İçerik 2', 'slider-categories-content-2.png');
INSERT INTO `theme_components` VALUES (16, 1, 'slider-categories-content-3', 'categories-content', NULL, NULL, 'Slider - Kategori İçerik 3', 'slider-categories-content-3.png');
INSERT INTO `theme_components` VALUES (17, 1, 'slider-categories-content-4', 'categories-content', NULL, NULL, 'Slider - Kategori İçerik 4', 'slider-categories-content-4.png');
INSERT INTO `theme_components` VALUES (18, 1, 'content-2', 'content', NULL, NULL, 'İçerik-2', 'icerik-2.png');
INSERT INTO `theme_components` VALUES (19, 1, 'content-3', 'content', NULL, NULL, 'İçerik-3 Full / 2 \'li ', 'icerik-3.png');
INSERT INTO `theme_components` VALUES (20, 1, 'galeri-slider-1', 'slider', NULL, NULL, 'Galeri Slider', 'galeri-slider-1.png');
INSERT INTO `theme_components` VALUES (21, 1, 'sabit-icerik-2', 'constant', NULL, NULL, 'Sabit İçerik-2', 'sabit-icerik-2.png');
INSERT INTO `theme_components` VALUES (22, 1, 'video-slider-1', 'slider', NULL, NULL, 'Video Slider', 'video-slider-1.png');

-- ----------------------------
-- Table structure for theme_settings
-- ----------------------------
CREATE TABLE `theme_settings`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `theme_id` bigint UNSIGNED NULL DEFAULT NULL,
  `theme_global_setting_id` bigint UNSIGNED NULL DEFAULT NULL,
  `value` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `theme_settings_theme_id_index`(`theme_id` ASC) USING BTREE,
  INDEX `theme_settings_theme_global_setting_id_index`(`theme_global_setting_id` ASC) USING BTREE,
  CONSTRAINT `theme_settings_theme_global_setting_id_foreign` FOREIGN KEY (`theme_global_setting_id`) REFERENCES `theme_global_settings` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT,
  CONSTRAINT `theme_settings_theme_id_foreign` FOREIGN KEY (`theme_id`) REFERENCES `themes` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 38 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of theme_settings
-- ----------------------------
INSERT INTO `theme_settings` VALUES (4, 1, 5, '260', '2024-08-12 12:15:29', '2024-08-14 10:41:20');
INSERT INTO `theme_settings` VALUES (5, 1, 6, '80', '2024-08-12 12:15:29', '2024-08-14 10:41:20');
INSERT INTO `theme_settings` VALUES (8, 1, 1, 'upload/themes/logo_6720dd9daf4c9_1730207133.jpg', '2024-08-12 12:45:29', '2024-10-29 16:05:33');
INSERT INTO `theme_settings` VALUES (9, 1, 8, '32', '2024-08-12 12:47:43', '2024-08-14 10:30:08');
INSERT INTO `theme_settings` VALUES (10, 1, 9, '32', '2024-08-12 12:47:43', '2024-08-14 10:30:08');
INSERT INTO `theme_settings` VALUES (11, 1, 7, 'upload/themes/favicon_6720ddfdd7f3d_1730207229.jpg', '2024-08-12 12:47:44', '2024-10-29 16:07:10');
INSERT INTO `theme_settings` VALUES (15, 1, 13, 'header5', '2024-08-14 10:33:19', '2024-10-24 16:24:59');
INSERT INTO `theme_settings` VALUES (16, 1, 14, 'footer4', '2024-08-14 10:34:01', '2024-09-24 10:35:20');
INSERT INTO `theme_settings` VALUES (17, 1, 18, '100', '2024-08-16 14:53:23', '2024-08-16 14:53:23');
INSERT INTO `theme_settings` VALUES (18, 1, 19, '150', '2024-08-16 14:53:23', '2024-08-16 14:53:23');
INSERT INTO `theme_settings` VALUES (20, 1, 20, 'gosterme', '2024-09-14 14:54:07', '2024-09-17 16:37:47');
INSERT INTO `theme_settings` VALUES (22, 1, 17, 'upload/themes/footer_logo_6720ddfe3ba26_1730207230.png', '2024-09-17 13:36:08', '2024-10-29 16:07:10');
INSERT INTO `theme_settings` VALUES (23, 1, 22, '#tel1', '2024-09-19 13:08:14', '2024-09-19 13:21:07');
INSERT INTO `theme_settings` VALUES (24, 1, 23, '#tel2', '2024-09-19 13:16:55', '2024-09-19 13:21:07');
INSERT INTO `theme_settings` VALUES (25, 1, 24, 'bilgi@codegrafi.com', '2024-09-19 13:20:52', '2024-09-19 13:21:42');
INSERT INTO `theme_settings` VALUES (28, 1, 26, '1920', '2024-10-29 15:56:56', '2024-10-29 15:56:56');
INSERT INTO `theme_settings` VALUES (29, 1, 27, '100', '2024-10-29 15:56:56', '2024-10-29 16:10:01');
INSERT INTO `theme_settings` VALUES (30, 1, 25, 'upload/themes/product_header_bg_6720e13744307_1730208055.png', '2024-10-29 15:57:08', '2024-10-29 16:20:55');
INSERT INTO `theme_settings` VALUES (31, 1, 29, '1920', '2024-10-29 16:00:30', '2024-10-29 16:00:30');
INSERT INTO `theme_settings` VALUES (32, 1, 30, '100', '2024-10-29 16:00:30', '2024-10-29 16:10:01');
INSERT INTO `theme_settings` VALUES (33, 1, 28, 'upload/themes/content_header_bg_6720deaa3ec66_1730207402.png', '2024-10-29 16:00:31', '2024-10-29 16:10:02');
INSERT INTO `theme_settings` VALUES (37, 1, 34, 'loader5', '2024-11-01 12:32:35', '2024-11-01 12:33:19');

-- ----------------------------
-- Table structure for themes
-- ----------------------------
CREATE TABLE `themes`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `path` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `order` int NOT NULL DEFAULT 0,
  `status` tinyint NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `default` tinyint NOT NULL DEFAULT 0,
  `preview_image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of themes
-- ----------------------------
INSERT INTO `themes` VALUES (1, 'Default', 'Default Theme', 'default', 1, 1, NULL, NULL, 1, '1.png');

