dump.sql - master - denispirit/otbor

dump.sql
418 строк16 KB
denispirit
без JS и с админкой
04 фев 2025, 13:39
04 фев 2025, 13:39394a32f
-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Хост: localhost
-- Время создания: Фев 04 2025 г., 13:22
-- Версия сервера: 8.0.40
-- Версия PHP: 8.2.18

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

--
-- База данных: `module`
--

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

--
-- Структура таблицы `ads`
--

CREATE TABLE `ads` (
  `id` bigint UNSIGNED NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `category_id` bigint UNSIGNED NOT NULL,
  `is_active` tinyint(1) 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;

--
-- Дамп данных таблицы `ads`
--

INSERT INTO `ads` (`id`, `title`, `description`, `user_id`, `category_id`, `is_active`, `created_at`, `updated_at`) VALUES
(1, 'Aut vitae aliquip nemo nihil mol', 'Commodo architecto adipisicing ad aliquip doloremque est non', 6, 5, 1, '2025-01-31 06:34:50', '2025-01-31 06:34:50'),
(2, 'Aliqua Ut ab aspernatur saepe n', 'Sapiente cum et dolor obcaecati ut', 6, 3, 1, '2025-01-31 06:34:59', '2025-01-31 06:34:59'),
(3, 'Laborum Aute voluptas id ipsum', 'Aperiam cumque dolorem quos illum ut totam ipsam illo itaque ip', 6, 5, 1, '2025-01-31 06:35:04', '2025-01-31 06:35:04'),
(4, 'Saepe labore accusamus est volup', 'Soluta eos dicta ipsum vel nisi enim modi cupiditate tempore', 6, 1, 1, '2025-01-31 06:35:13', '2025-01-31 06:35:13'),
(5, 'Earum do mollit enim quaerat vol', 'Eius fuga Sapiente ut eum voluptatem architecto sunt quam quae', 6, 5, 1, '2025-01-31 06:35:17', '2025-01-31 06:35:17'),
(6, 'Quia do consequatur sed omnis ni', 'Sed quae amet quia expedita id provident', 4, 2, 1, '2025-01-31 06:42:36', '2025-01-31 06:42:36'),
(7, 'Itaque ab expedita harum reprehe', 'Sit est tempore aut ipsam quo sint lorem quia', 8, 3, 1, '2025-01-31 07:07:07', '2025-01-31 07:07:07'),
(8, 'Aliquip voluptas sunt ut est si', 'Ut ad dolore consequatur Ex incidunt laborum natus est ipsam o', 8, 1, 1, '2025-01-31 07:20:43', '2025-01-31 07:21:12'),
(9, 'Quia pariatur Enim rem voluptas', 'Autem id asperiores dolores sed mollit deleniti repellendus Sin', 8, 2, 1, '2025-01-31 09:37:16', '2025-01-31 09:37:16'),
(10, 'Dolores unde eum id similique o', 'Optio pariatur Eiusmod pariatur Accusamus est nisi consectetu', 8, 2, 1, '2025-01-31 09:37:24', '2025-01-31 09:37:24'),
(11, 'Consequuntur cillum maxime ad so', 'Duis labore ea dolorem esse quo et beatae corrupti velit rem', 8, 3, 1, '2025-01-31 09:37:29', '2025-01-31 09:37:29'),
(12, 'Quia eos molestiae duis dolore v', 'Voluptatum quia consequatur porro qui esse do rerum expedita lab', 8, 4, 1, '2025-01-31 09:37:33', '2025-01-31 09:37:33'),
(13, 'Ut nisi adipisci blanditiis anim', 'Quam quos et deserunt quia aut consectetur consequatur nesciun', 8, 2, 1, '2025-02-03 03:27:22', '2025-02-03 03:27:22'),
(14, 'Suscipit maxime lorem consequat', 'Quod assumenda esse omnis sunt exercitation aut tempore velit', 8, 4, 1, '2025-02-03 03:27:29', '2025-02-03 03:27:29'),
(15, 'Necessitatibus dolorum aut verit', 'Blanditiis sint reprehenderit ut aut incididunt minim qui aut e', 8, 3, 1, '2025-02-03 03:27:37', '2025-02-03 03:27:37'),
(16, 'Quisquam cupiditate sint ut mol', 'Labore magnam sequi explicabo Blanditiis excepturi in minim qui', 8, 5, 1, '2025-02-03 03:27:43', '2025-02-03 03:27:43'),
(17, 'Lorem quidem cupidatat ratione a', 'Ad fuga Quas qui quia mollit saepe', 8, 2, 1, '2025-02-03 03:27:46', '2025-02-03 03:27:46'),
(18, 'Omnis quis perferendis aut unde', 'Vel sapiente pariatur Sunt iure sunt in aliquip illo rerum reru', 8, 2, 1, '2025-02-03 03:27:48', '2025-02-04 06:03:17'),
(19, 'Occaecat aute ut reprehenderit r', 'Eos rerum accusamus porro reiciendis aliquip dolore in similiqu', 8, 3, 1, '2025-02-03 03:27:54', '2025-02-04 06:03:22'),
(20, 'Enim quia voluptas eum elit nem', 'Eu debitis sed provident dolor deleniti nihil harum maiores sed', 9, 5, 1, '2025-02-04 06:03:37', '2025-02-04 06:06:02');

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

--
-- Структура таблицы `cache`
--

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

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

--
-- Структура таблицы `cache_locks`
--

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

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

--
-- Структура таблицы `categories`
--

CREATE TABLE `categories` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Дамп данных таблицы `categories`
--

INSERT INTO `categories` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, 'Category 1', NULL, NULL),
(2, 'Category 2', NULL, NULL),
(3, 'Category 3', NULL, NULL),
(4, 'Category 4', NULL, NULL),
(5, 'Category 5', NULL, NULL),
(6, 'Category 6', '2025-02-04 04:23:46', '2025-02-04 04:23:46');

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

--
-- Структура таблицы `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint UNSIGNED NOT NULL,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Структура таблицы `jobs`
--

CREATE TABLE `jobs` (
  `id` bigint UNSIGNED NOT NULL,
  `queue` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `attempts` tinyint UNSIGNED NOT NULL,
  `reserved_at` int UNSIGNED DEFAULT NULL,
  `available_at` int UNSIGNED NOT NULL,
  `created_at` int UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Структура таблицы `job_batches`
--

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

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

--
-- Структура таблицы `migrations`
--

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

--
-- Дамп данных таблицы `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '0001_01_01_000000_create_users_table', 1),
(2, '0001_01_01_000001_create_cache_table', 1),
(3, '0001_01_01_000002_create_jobs_table', 1),
(4, '2025_01_31_090237_create_categories_table', 1),
(5, '2025_01_31_090241_create_ads_table', 1),
(6, '2025_02_03_115945_create_personal_access_tokens_table', 2);

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

--
-- Структура таблицы `password_reset_tokens`
--

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

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

--
-- Структура таблицы `personal_access_tokens`
--

CREATE TABLE `personal_access_tokens` (
  `id` bigint UNSIGNED NOT NULL,
  `tokenable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tokenable_id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
  `abilities` text COLLATE utf8mb4_unicode_ci,
  `last_used_at` timestamp NULL DEFAULT NULL,
  `expires_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;

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

--
-- Структура таблицы `sessions`
--

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

--
-- Дамп данных таблицы `sessions`
--

INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES
('OJ80AgMHtq3NEDwwgXRsu4oFkPwddmZNw7oDm5FG', 8, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 YaBrowser/23.7.1.1266 (corp) Yowser/2.5 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiZTRrcUNJb3liNmZ1NmtpbXlBd1VZdm5UMVJ3MmNENW0xM0xiYVJYbCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjU6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9hZHMiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX1zOjUwOiJsb2dpbl93ZWJfNTliYTM2YWRkYzJiMmY5NDAxNTgwZjAxNGM3ZjU4ZWE0ZTMwOTg5ZCI7aTo4O30=', 1738664388);

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

--
-- Структура таблицы `users`
--

CREATE TABLE `users` (
  `id` bigint UNSIGNED NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Дамп данных таблицы `users`
--

INSERT INTO `users` (`id`, `email`, `password`, `created_at`, `updated_at`) VALUES
(1, 'pedycemopa@mail.com', '$2y$12$CR/BzBeG7Ocmdgo58JYyqOv9TtI9jTbQTkeJV676lHw5/.r146FhG', '2025-01-31 06:15:32', '2025-01-31 06:15:32'),
(2, 'pujixycije@mail.com', '$2y$12$27j0sWTRw0Ux9Ejy9Y3Mru9Fpe4VMeQTFPuyllugrlvWITOcGFtKK', '2025-01-31 06:23:13', '2025-01-31 06:23:13'),
(3, 'pyqozir@mail.com', '$2y$12$kNAZr9gUHzftuGN33gBmYOV5b20ZOLVBcJn44rNofmoQArYCr6Wt.', '2025-01-31 06:23:59', '2025-01-31 06:23:59'),
(4, 'tajyvi@mail.com', '$2y$12$4D46kaS3JbGblhD2TEfEtOli5BBdC5RnpKyV6X.ngcPaj3XYHkooC', '2025-01-31 06:26:27', '2025-01-31 06:26:27'),
(5, 'rijamer@mail.com', '$2y$12$HDH75H7Ew2o5hvEf18a3dO5D7TXAGsyVH61U0FQLExngyTy5RmFpu', '2025-01-31 06:27:35', '2025-01-31 06:27:35'),
(6, 'fuhijyzoz@mail.com', '$2y$12$Joigc5kZzbroZksmTYYcYOsbTMnQorA0PvtSxS.CwSN9X6xKEgoca', '2025-01-31 06:28:51', '2025-01-31 06:28:51'),
(7, 'qumifiz@mail.com', '$2y$12$qaA0eiIYotgpLdZR.rl0fOZE5nLWFZvBk1HwE2DhncsHFK7b736ai', '2025-01-31 06:39:18', '2025-01-31 06:39:18'),
(8, 'user@user.com', '$2y$12$qGGrpWT48h2cX7AnJF7zNehnBG2VIogr4Tf4YH0.jfh6CT9XjPMLm', '2025-01-31 07:06:54', '2025-01-31 07:06:54'),
(9, 'admin@admin.com', '$2y$12$2tLuJ77Dk.h/z26ndtfVFOefTwZzdZ0ZYmhj8UUlfPNIT/KXIx7ja', '2025-02-04 04:11:23', '2025-02-04 04:11:23');

--
-- Индексы сохранённых таблиц
--

--
-- Индексы таблицы `ads`
--
ALTER TABLE `ads`
  ADD PRIMARY KEY (`id`),
  ADD KEY `ads_user_id_foreign` (`user_id`),
  ADD KEY `ads_category_id_foreign` (`category_id`);

--
-- Индексы таблицы `cache`
--
ALTER TABLE `cache`
  ADD PRIMARY KEY (`key`);

--
-- Индексы таблицы `cache_locks`
--
ALTER TABLE `cache_locks`
  ADD PRIMARY KEY (`key`);

--
-- Индексы таблицы `categories`
--
ALTER TABLE `categories`
  ADD PRIMARY KEY (`id`);

--
-- Индексы таблицы `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

--
-- Индексы таблицы `jobs`
--
ALTER TABLE `jobs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `jobs_queue_index` (`queue`);

--
-- Индексы таблицы `job_batches`
--
ALTER TABLE `job_batches`
  ADD PRIMARY KEY (`id`);

--
-- Индексы таблицы `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Индексы таблицы `password_reset_tokens`
--
ALTER TABLE `password_reset_tokens`
  ADD PRIMARY KEY (`email`);

--
-- Индексы таблицы `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`);

--
-- Индексы таблицы `sessions`
--
ALTER TABLE `sessions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sessions_user_id_index` (`user_id`),
  ADD KEY `sessions_last_activity_index` (`last_activity`);

--
-- Индексы таблицы `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `users_email_unique` (`email`);

--
-- AUTO_INCREMENT для сохранённых таблиц
--

--
-- AUTO_INCREMENT для таблицы `ads`
--
ALTER TABLE `ads`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- AUTO_INCREMENT для таблицы `categories`
--
ALTER TABLE `categories`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT для таблицы `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT для таблицы `jobs`
--
ALTER TABLE `jobs`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT для таблицы `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT для таблицы `personal_access_tokens`
--
ALTER TABLE `personal_access_tokens`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT для таблицы `users`
--
ALTER TABLE `users`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- Ограничения внешнего ключа сохраненных таблиц
--

--
-- Ограничения внешнего ключа таблицы `ads`
--
ALTER TABLE `ads`
  ADD CONSTRAINT `ads_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`),
  ADD CONSTRAINT `ads_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`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 */;