Електрон кутубхона

Deponentlanadigan materiallarning titul varag‘i
EHM uchun dastur (Ma’lumotlar bazasi) nomi:
“Електрон кутубхона”

Huquq ega(lar)si :

1. 
   Alimov Zokir Chori o’g’li
   
2. 
   _________________________________________________________
   
3. 
   _________________________________________________________
   

Muallif(lar):

1. 
   Mahmanov Orif Qudratovich
   
2. 
   _________________________________________________________
   

EHM uchun dasturni identifikatsiya qiluvchi materiallar dastlabki matni (Dastur kodi)

« Електрон кутубхона »

Муаллиф: Маҳманов Ориф Қудратович

Тошкент -2022
ЭҲМ учун дастур ёки маълумотлар базасининг номи:
« Електрон кутубхона »


дастурининг листинги
-- phpMyAdmin SQL Dump
-- version 4.9.5
-- https://www.phpmyadmin.net/
--
-- Хост: localhost:3306
-- Время создания: Янв 24 2021 г., 14:51
-- Версия сервера: 5.7.27-30
-- Версия PHP: 7.3.6

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
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 */;

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

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

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

CREATE TABLE `backend_access_log` (
`id` int(10) UNSIGNED NOT NULL,
`user_id` int(10) UNSIGNED NOT NULL,
`ip_address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `backend_access_log` (`id`, `user_id`, `ip_address`, `created_at`, `updated_at`) VALUES
(1, 1, '217.30.164.118', '2021-01-21 14:44:09', '2021-01-21 14:44:09'),
(2, 1, '91.203.173.115', '2021-01-22 11:54:08', '2021-01-22 11:54:08');

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

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

--

CREATE TABLE `backend_users` (
`id` int(10) UNSIGNED NOT NULL,
`first_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`last_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`login` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`activation_code` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`persist_code` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`reset_password_code` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`permissions` text COLLATE utf8mb4_unicode_ci,
`is_activated` tinyint(1) NOT NULL DEFAULT '0',
`role_id` int(10) UNSIGNED DEFAULT NULL,
`activated_at` timestamp NULL DEFAULT NULL,
`last_login` timestamp NULL DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
`is_superuser` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `backend_users` (`id`, `first_name`, `last_name`, `login`, `email`, `password`, `activation_code`, `persist_code`, `reset_password_code`, `permissions`, `is_activated`, `role_id`, `activated_at`, `last_login`, `created_at`, `updated_at`, `deleted_at`, `is_superuser`) VALUES
(1, 'Admin', 'Person', 'admin', '[e-mail]', '$2y$10$QmnKj.1WTVhtTXiMWZ1Iv.CtMjv8pZKuhl.IFYmWucsgaXg6lQJXa', NULL, '$2y$10$qleVdCbUrNMejSlflRH9Q.4SKdiFWXcRp0wFwxCN3stMb8ia2P6eK', NULL, '', 1, 2, NULL, '2021-01-22 11:54:08', '2021-01-21 14:43:55', '2021-01-22 11:54:08', NULL, 1);

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

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

--

CREATE TABLE `backend_users_groups` (
`user_id` int(10) UNSIGNED NOT NULL,
`user_group_id` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `backend_users_groups` (`user_id`, `user_group_id`) VALUES
(1, 1);

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

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

--

CREATE TABLE `backend_user_groups` (
`id` int(10) UNSIGNED NOT NULL,
`name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`code` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`description` text COLLATE utf8mb4_unicode_ci,
`is_new_user_default` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `backend_user_groups` (`id`, `name`, `created_at`, `updated_at`, `code`, `description`, `is_new_user_default`) VALUES
(1, 'Owners', '2021-01-21 14:43:54', '2021-01-21 14:43:54', 'owners', 'Default group for website owners.', 0);

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

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

--

CREATE TABLE `backend_user_preferences` (
`id` int(10) UNSIGNED NOT NULL,
`user_id` int(10) UNSIGNED NOT NULL,
`namespace` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
`group` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
`item` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
`value` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `backend_user_preferences` (`id`, `user_id`, `namespace`, `group`, `item`, `value`) VALUES
(1, 1, 'backend', 'backend', 'preferences', '{\"locale\":\"ru\",\"fallback_locale\":\"en\",\"timezone\":\"Asia\\/Tashkent\",\"editor_font_size\":\"12\",\"editor_word_wrap\":\"fluid\",\"editor_code_folding\":\"markbeginend\",\"editor_tab_size\":\"4\",\"editor_theme\":\"twilight\",\"editor_show_invisibles\":\"0\",\"editor_highlight_active_line\":\"1\",\"editor_use_hard_tabs\":\"1\",\"editor_show_gutter\":\"1\",\"editor_auto_closing\":\"1\",\"editor_autocompletion\":\"live\",\"editor_enable_snippets\":\"1\",\"editor_display_indent_guides\":\"0\",\"editor_show_print_margin\":\"0\",\"user_id\":1}'),
(2, 1, 'backend', 'hints', 'hidden', '{\"builder-version-rollback\":1,\"builder-version-apply\":1,\"builder-version-save-unapplied\":1}');

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

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

--

CREATE TABLE `backend_user_roles` (
`id` int(10) UNSIGNED NOT NULL,
`name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`code` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`description` text COLLATE utf8mb4_unicode_ci,
`permissions` text COLLATE utf8mb4_unicode_ci,
`is_system` tinyint(1) NOT NULL DEFAULT '0',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `backend_user_roles` (`id`, `name`, `code`, `description`, `permissions`, `is_system`, `created_at`, `updated_at`) VALUES
(1, 'Publisher', 'publisher', 'Site editor with access to publishing tools.', '', 1, '2021-01-21 14:43:54', '2021-01-21 14:43:54'),
(2, 'Developer', 'developer', 'Site administrator with access to developer tools.', '', 1, '2021-01-21 14:43:54', '2021-01-21 14:43:54');

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

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

--

CREATE TABLE `backend_user_throttle` (
`id` int(10) UNSIGNED NOT NULL,
`user_id` int(10) UNSIGNED DEFAULT NULL,
`ip_address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`attempts` int(11) NOT NULL DEFAULT '0',
`last_attempt_at` timestamp NULL DEFAULT NULL,
`is_suspended` tinyint(1) NOT NULL DEFAULT '0',
`suspended_at` timestamp NULL DEFAULT NULL,
`is_banned` tinyint(1) NOT NULL DEFAULT '0',
`banned_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `backend_user_throttle` (`id`, `user_id`, `ip_address`, `attempts`, `last_attempt_at`, `is_suspended`, `suspended_at`, `is_banned`, `banned_at`) VALUES
(1, 1, '217.30.164.118', 0, NULL, 0, NULL, 0, NULL),
(2, 1, '91.203.173.115', 0, NULL, 0, NULL, 0, NULL),
(3, 1, '185.87.51.57', 0, NULL, 0, NULL, 0, NULL);

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

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

--

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

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

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

--

CREATE TABLE `cms_theme_data` (
`id` int(10) UNSIGNED NOT NULL,
`theme` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`data` mediumtext COLLATE utf8mb4_unicode_ci,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

--

CREATE TABLE `cms_theme_logs` (
`id` int(10) UNSIGNED NOT NULL,
`type` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
`theme` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`template` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`old_template` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`content` longtext COLLATE utf8mb4_unicode_ci,
`old_content` longtext COLLATE utf8mb4_unicode_ci,
`user_id` int(11) DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

--

CREATE TABLE `cms_theme_templates` (
`id` int(10) UNSIGNED NOT NULL,
`source` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`path` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`content` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`file_size` int(10) UNSIGNED NOT NULL,
`updated_at` datetime DEFAULT NULL,
`deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

--

CREATE TABLE `deferred_bindings` (
`id` int(10) UNSIGNED NOT NULL,
`master_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`master_field` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`slave_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`slave_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`session_key` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`is_bind` 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;

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

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

--

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

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

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

--

CREATE TABLE `farrukh_lessons_books` (
`id` int(10) UNSIGNED NOT NULL,
`title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`plan` text COLLATE utf8mb4_unicode_ci,
`content` longtext COLLATE utf8mb4_unicode_ci,
`questions` text COLLATE utf8mb4_unicode_ci,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
`sort_order` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `farrukh_lessons_books` (`id`, `title`, `plan`, `content`, `questions`, `created_at`, `updated_at`, `deleted_at`, `sort_order`) VALUES
(1, 'Kompyuter grafikasining rivojlanish tarixi. Uch o’lchovli grafikaning imkoniyatlari, afzallik va kamchiliklari. 3 d texnologiyalarining apparat vositalari', '