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


Download 126 Kb.
bet1/10
Sana07.09.2023
Hajmi126 Kb.
#1673779
  1   2   3   4   5   6   7   8   9   10
Bog'liq
9b3a25f9160622ead339988eba78172c8d96


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', 'admin@domain.tld', '$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', '

Download 126 Kb.

Do'stlaringiz bilan baham:
  1   2   3   4   5   6   7   8   9   10




Ma'lumotlar bazasi mualliflik huquqi bilan himoyalangan ©fayllar.org 2024
ma'muriyatiga murojaat qiling