-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Хост: localhost
-- Время создания: Июн 10 2024 г., 12:33
-- Версия сервера: 5.7.39
-- Версия PHP: 7.4.33

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

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

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

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

CREATE TABLE `ls_articles` (
  `articleId` int(10) UNSIGNED NOT NULL,
  `sectionId` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  `orderBy` int(6) NOT NULL DEFAULT '0',
  `typeContent` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'articles',
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `alias` mediumtext COLLATE utf8mb4_unicode_ci,
  `fileName` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `status` char(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'H',
  `summary` longtext COLLATE utf8mb4_unicode_ci,
  `content` longtext COLLATE utf8mb4_unicode_ci,
  `publishedOn` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `publicationEnd` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `keywords` mediumtext COLLATE utf8mb4_unicode_ci,
  `description` mediumtext COLLATE utf8mb4_unicode_ci,
  `url` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `isFeatured` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
  `popularityLast7days` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  `popularityLast14days` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  `popularityLast30days` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  `popularityLastMonth` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  `popularityYesterday` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  `commentsEnabled` tinyint(1) NOT NULL DEFAULT '0',
  `totalComments` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  `addedBy` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `addedOn` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `modifiedBy` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `modifiedOn` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `counter` int(11) UNSIGNED NOT NULL DEFAULT '0',
  `rating` float(3,1) DEFAULT '0.0',
  `votes` int(11) DEFAULT '0',
  `enableGallery` tinyint(1) NOT NULL DEFAULT '0',
  `course_length` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `course_price` decimal(18,2) NOT NULL DEFAULT '0.00',
  `course_instalment` decimal(18,2) NOT NULL DEFAULT '0.00'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

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

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

CREATE TABLE `ls_article_images` (
  `imageId` int(10) UNSIGNED NOT NULL,
  `articleId` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `fileId` int(12) NOT NULL DEFAULT '0',
  `orderBy` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `type` enum('general','gallery','songs','docs') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'general',
  `title` varchar(1024) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `alias` mediumtext COLLATE utf8mb4_unicode_ci,
  `description` mediumtext COLLATE utf8mb4_unicode_ci,
  `link` varchar(1024) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `position` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `ls_article_visits` (
  `visitId` int(10) UNSIGNED NOT NULL,
  `articleId` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `visitorIp` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `ls_banners` (
  `bannerId` int(10) UNSIGNED NOT NULL COMMENT 'ID банера',
  `groupId` smallint(4) NOT NULL DEFAULT '0' COMMENT 'ID группы банеров',
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `alias` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `text` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `url` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `summary` mediumtext COLLATE utf8mb4_unicode_ci,
  `status` char(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'V',
  `orderBy` int(6) NOT NULL,
  `fileId` int(12) DEFAULT '0',
  `addedBy` int(10) NOT NULL DEFAULT '0',
  `addedOn` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `modifiedBy` int(10) NOT NULL DEFAULT '0',
  `modifiedOn` datetime NOT NULL DEFAULT '1970-01-01 00:00:00'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `ls_banners_group` (
  `groupId` int(11) NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `orderBy` int(11) NOT NULL DEFAULT '0',
  `status` char(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'V',
  `show_all_pages` tinyint(1) NOT NULL DEFAULT '0',
  `pages` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `addedBy` int(10) NOT NULL DEFAULT '0',
  `addedOn` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `modifiedBy` int(10) NOT NULL DEFAULT '0',
  `modifiedOn` datetime NOT NULL DEFAULT '1970-01-01 00:00:00'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `ls_banner_images` (
  `imageId` int(10) UNSIGNED NOT NULL,
  `bannerId` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `fileId` int(12) NOT NULL DEFAULT '0',
  `orderBy` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `type` enum('general','gallery','docs') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'general',
  `title` varchar(1024) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `alias` varchar(1024) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` mediumtext COLLATE utf8mb4_unicode_ci,
  `link` mediumtext COLLATE utf8mb4_unicode_ci,
  `position` enum('default','banner','block','carousel','modal','pdf') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'default'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `ls_banner_tracking` (
  `groupId` int(10) UNSIGNED NOT NULL,
  `sectionId` int(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `ls_blocks` (
  `blockId` int(10) UNSIGNED NOT NULL COMMENT 'ID блока',
  `sectionId` mediumint(8) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'ID раздела',
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `alias` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `content` longtext COLLATE utf8mb4_unicode_ci,
  `status` char(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'V',
  `position` char(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'C',
  `enableGallery` tinyint(1) NOT NULL DEFAULT '0',
  `orderBy` int(6) NOT NULL DEFAULT '0',
  `addedBy` int(10) NOT NULL DEFAULT '0',
  `addedOn` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `modifiedBy` int(10) NOT NULL DEFAULT '0',
  `modifiedOn` datetime NOT NULL DEFAULT '1970-01-01 00:00:00'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

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

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

CREATE TABLE `ls_block_images` (
  `imageId` int(10) UNSIGNED NOT NULL,
  `blockId` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `fileId` int(12) NOT NULL DEFAULT '0',
  `orderBy` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `type` enum('general','gallery') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'general',
  `title` varchar(1024) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `alias` mediumtext COLLATE utf8mb4_unicode_ci,
  `description` mediumtext COLLATE utf8mb4_unicode_ci,
  `link` varchar(1024) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `position` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `ls_clients` (
  `articleId` int(10) UNSIGNED NOT NULL,
  `sectionId` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  `companyIds` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `orderBy` int(6) NOT NULL DEFAULT '0',
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `alias` mediumtext COLLATE utf8mb4_unicode_ci,
  `fileName` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `status` char(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'H',
  `summary` longtext COLLATE utf8mb4_unicode_ci,
  `content` longtext COLLATE utf8mb4_unicode_ci,
  `publishedOn` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `keywords` mediumtext COLLATE utf8mb4_unicode_ci,
  `description` mediumtext COLLATE utf8mb4_unicode_ci,
  `url` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `isFeatured` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
  `addedBy` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `addedOn` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `modifiedBy` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `modifiedOn` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `enableGallery` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

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

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

CREATE TABLE `ls_client_images` (
  `imageId` int(10) UNSIGNED NOT NULL,
  `articleId` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `fileId` int(12) NOT NULL DEFAULT '0',
  `orderBy` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `type` enum('general','gallery') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'general',
  `title` varchar(1024) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `alias` mediumtext COLLATE utf8mb4_unicode_ci,
  `description` mediumtext COLLATE utf8mb4_unicode_ci,
  `link` varchar(1024) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `position` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `ls_colors` (
  `colorId` int(11) NOT NULL,
  `colorName` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT 'Название цвета',
  `colorCode` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'Код цвета (#000000)',
  `fileName` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `status` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'V',
  `orderBy` mediumint(8) NOT NULL DEFAULT '0',
  `addedBy` int(10) NOT NULL DEFAULT '0',
  `addedOn` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `modifiedBy` int(10) NOT NULL DEFAULT '0',
  `modifiedOn` datetime NOT NULL DEFAULT '1970-01-01 00:00:00'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Цвет кузова и салона';

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

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

CREATE TABLE `ls_comments` (
  `commentId` int(10) UNSIGNED NOT NULL,
  `answerId` int(12) NOT NULL DEFAULT '0',
  `articleId` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `visitorId` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `userId` int(12) NOT NULL DEFAULT '0',
  `content` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `authorName` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `authorEmail` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `authorIp` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `status` enum('pending','approved','spam','unconfirmed') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `addedOn` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `modifiedBy` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `modifiedOn` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `rating` float(3,1) NOT NULL DEFAULT '0.0',
  `checkRating` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `ls_faq` (
  `faqId` int(11) NOT NULL COMMENT 'ID',
  `question` text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Вопрос',
  `answer` text COLLATE utf8mb4_unicode_ci COMMENT 'Ответ',
  `status` char(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'V',
  `orderBy` int(11) NOT NULL DEFAULT '0',
  `addedBy` int(10) NOT NULL DEFAULT '0',
  `addedOn` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `modifiedBy` int(10) NOT NULL DEFAULT '0',
  `modifiedOn` datetime NOT NULL DEFAULT '1970-01-01 00:00:00'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='часто задаваемые вопросы';

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

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

CREATE TABLE `ls_feedback` (
  `id` int(11) NOT NULL,
  `status` enum('pending','approved','spam') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `fullName` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `subject` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `message` mediumtext COLLATE utf8mb4_unicode_ci,
  `created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Обратная связь';

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

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

CREATE TABLE `ls_files` (
  `fileId` int(10) UNSIGNED NOT NULL,
  `directory` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'uploads',
  `path` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fileName` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `size` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL,
  `mime_type` varchar(90) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `addedBy` int(11) UNSIGNED NOT NULL DEFAULT '0',
  `addedOn` datetime NOT NULL DEFAULT '1970-01-01 00:00:00'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Загруженные файлы';

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

INSERT INTO `ls_files` (`fileId`, `directory`, `path`, `fileName`, `size`, `mime_type`, `addedBy`, `addedOn`) VALUES
(3, 'admin', '/uploads/admin/', '242e48c9a2d5.webp', '116776', 'image/jpeg', 1, '2022-08-29 10:43:54'),
(4, 'admin', '/uploads/admin/', '4176b4c215a6.webp', '78753', 'image/jpeg', 1, '2022-08-29 10:43:55'),
(5, 'admin', '/uploads/admin/', '49bb9fc32977.webp', '237930', 'image/jpeg', 1, '2022-08-29 10:44:07'),
(6, 'admin', '/uploads/admin/', 'dd9f20ffe562.webp', '192742', 'image/jpeg', 1, '2022-08-29 10:44:27'),
(7, 'admin', '/uploads/admin/', '1092cd8dbca2.webp', '99573', 'image/jpeg', 1, '2022-08-29 10:44:29'),
(8, 'admin', '/uploads/admin/', '7c395a306c4a.webp', '150965', 'image/jpeg', 1, '2022-08-29 10:44:38'),
(9, 'admin', '/uploads/admin/', '2b01599153e9.jpg', '143948', 'image/jpeg', 1, '2023-10-25 11:58:14'),
(10, 'admin', '/uploads/admin/', '2268abfec674.webp', '37096', 'image/jpeg', 1, '2024-06-10 07:32:13');

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

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

CREATE TABLE `ls_geo_countries` (
  `id` int(11) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `alias` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fileName` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `code` mediumint(4) NOT NULL DEFAULT '0',
  `coordinates` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `price` decimal(18,2) NOT NULL DEFAULT '0.00',
  `status` char(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'V',
  `orderBy` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  `addedBy` int(10) NOT NULL DEFAULT '0',
  `addedOn` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `modifiedBy` int(10) NOT NULL DEFAULT '0',
  `modifiedOn` datetime NOT NULL DEFAULT '1970-01-01 00:00:00'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Страны';

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

INSERT INTO `ls_geo_countries` (`id`, `name`, `alias`, `fileName`, `code`, `coordinates`, `price`, `status`, `orderBy`, `addedBy`, `addedOn`, `modifiedBy`, `modifiedOn`) VALUES
(1, 'Ташкент', 'Ташкент', 'tashkent', 9788, '40.716780, 72.348436', 0.00, 'V', 2, 0, '1970-01-01 00:00:00', 1, '2023-05-16 11:23:06'),
(2, 'Самарканд', 'Самарканд', 'samarkand', 9796, '39.675906, 66.959712', 50000.00, 'V', 3, 0, '1970-01-01 00:00:00', 1, '2024-03-13 12:02:34'),
(3, 'Бухара', 'Бухара', 'bukhara', 9806, '40.430181, 67.592117', 70000.00, 'H', 4, 0, '1970-01-01 00:00:00', 1, '2023-05-06 08:07:32'),
(4, 'Хива', 'Хива', 'khiva', 9825, '38.681237, 66.130504', 100000.00, 'H', 5, 0, '1970-01-01 00:00:00', 1, '2023-05-06 08:07:22');

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

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

CREATE TABLE `ls_languages` (
  `languageId` smallint(5) UNSIGNED NOT NULL,
  `languageName` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `codename` char(2) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `url` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `isDefault` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
  `status` char(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'V',
  `sortOrder` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  `addedBy` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `addedOn` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `modifiedBy` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `modifiedOn` datetime NOT NULL DEFAULT '1970-01-01 00:00:00'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `ls_languages` (`languageId`, `languageName`, `codename`, `url`, `isDefault`, `status`, `sortOrder`, `addedBy`, `addedOn`, `modifiedBy`, `modifiedOn`) VALUES
(126, 'Russian', 'ru', 'https://solarnature.loc/', 1, 'V', 1, 1, '2023-11-28 21:13:04', 1, '2023-11-28 21:13:03');

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

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

CREATE TABLE `ls_log` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `userId` int(10) UNSIGNED NOT NULL,
  `message` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `type_log` enum('info','error','log') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'log',
  `date_log` datetime NOT NULL DEFAULT '2010-01-01 01:00:00',
  `user_ip` varchar(18) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0.0.0.0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci PACK_KEYS=1;

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

INSERT INTO `ls_log` (`id`, `userId`, `message`, `type_log`, `date_log`, `user_ip`) VALUES
(1, 1, 'Добавлен новый менеджер «Pulat» ', 'info', '2024-06-10 07:30:52', ''),
(2, 1, 'Менеджер «Pulat» отредактирован', 'info', '2024-06-10 07:30:55', ''),
(3, 1, 'Менеджер «Pulat» отредактирован', 'info', '2024-06-10 07:31:19', ''),
(4, 1, 'Менеджер «Закир Мавлянов» отредактирован', 'info', '2024-06-10 07:32:19', ''),
(5, 1, 'Менеджер «Пулат» отредактирован', 'info', '2024-06-10 07:32:34', '');

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

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

CREATE TABLE `ls_maps` (
  `codename` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `value` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `ls_maps` (`codename`, `value`) VALUES
('maps_height', '410px'),
('coordinates', '41.316258, 69.312256'),
('zoom', '16'),
('fillColor', '#5697e3'),
('api_key', 'b6a870ec-d914-424a-a003-b2d702a5d3db'),
('scale', '0.55'),
('fillOpacity', '1'),
('maps_wight', '100%'),
('isMaps', '1'),
('type', 'yandex');

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

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

CREATE TABLE `ls_notice` (
  `id` mediumint(8) NOT NULL,
  `userId` int(11) NOT NULL DEFAULT '0',
  `notice` text COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Заметки';

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

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

CREATE TABLE `ls_options` (
  `optionId` bigint(20) NOT NULL COMMENT 'ID опции',
  `parentId` int(11) DEFAULT NULL COMMENT 'ID родительской опции',
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'Название свойства',
  `hardware` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `type` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `orderBy` smallint(4) NOT NULL DEFAULT '0' COMMENT 'Сортировка',
  `status` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'V' COMMENT 'Статус',
  `addedBy` int(10) NOT NULL DEFAULT '0',
  `addedOn` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `modifiedBy` int(10) NOT NULL DEFAULT '0',
  `modifiedOn` datetime NOT NULL DEFAULT '1970-01-01 00:00:00'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Свойства';

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

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

CREATE TABLE `ls_products` (
  `productId` int(10) UNSIGNED NOT NULL,
  `sectionId` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  `orderBy` int(6) NOT NULL DEFAULT '0',
  `brand` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `alias` mediumtext COLLATE utf8mb4_unicode_ci,
  `sku` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Артикул',
  `ikpu` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Универсальный код товара',
  `quantity` int(4) NOT NULL DEFAULT '0' COMMENT 'Количество',
  `price` decimal(18,2) NOT NULL DEFAULT '0.00' COMMENT 'Цена',
  `old_price` decimal(18,2) NOT NULL DEFAULT '0.00' COMMENT 'Старая цена',
  `fileName` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `status` char(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'H',
  `summary` longtext COLLATE utf8mb4_unicode_ci,
  `content` longtext COLLATE utf8mb4_unicode_ci,
  `apps` text COLLATE utf8mb4_unicode_ci,
  `inPackage` text COLLATE utf8mb4_unicode_ci,
  `special` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `subtract` tinyint(1) NOT NULL DEFAULT '0',
  `shipping` tinyint(1) NOT NULL DEFAULT '0',
  `stock_status_id` tinyint(1) NOT NULL DEFAULT '0',
  `publishedOn` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `keywords` mediumtext COLLATE utf8mb4_unicode_ci,
  `description` mediumtext COLLATE utf8mb4_unicode_ci,
  `url` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `isFeatured` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
  `popularityLast7days` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  `popularityLast14days` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  `popularityLast30days` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  `popularityLastMonth` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  `popularityYesterday` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  `commentsEnabled` tinyint(1) NOT NULL DEFAULT '0',
  `totalComments` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  `addedBy` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `addedOn` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `modifiedBy` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `modifiedOn` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `counter` int(11) UNSIGNED NOT NULL DEFAULT '0',
  `rating` float(3,1) DEFAULT '0.0',
  `votes` int(11) DEFAULT '0',
  `enableGallery` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

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

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

CREATE TABLE `ls_product_blocks` (
  `blockId` int(10) UNSIGNED NOT NULL,
  `productId` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `video` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` char(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'V',
  `content` longtext COLLATE utf8mb4_unicode_ci,
  `position` char(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'C',
  `background` char(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'L',
  `orderBy` int(6) NOT NULL DEFAULT '0',
  `addedBy` int(10) NOT NULL DEFAULT '0',
  `addedOn` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `modifiedBy` int(10) NOT NULL DEFAULT '0',
  `modifiedOn` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `enableGallery` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

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

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

CREATE TABLE `ls_product_block_images` (
  `imageId` int(10) UNSIGNED NOT NULL,
  `blockId` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `fileId` int(12) NOT NULL DEFAULT '0',
  `orderBy` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `type` enum('general','gallery') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'general',
  `title` varchar(1024) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `alias` mediumtext COLLATE utf8mb4_unicode_ci,
  `description` mediumtext COLLATE utf8mb4_unicode_ci,
  `link` varchar(1024) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `position` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `ls_product_colors` (
  `imageId` int(11) NOT NULL,
  `productId` int(11) NOT NULL DEFAULT '0' COMMENT 'ID продукта',
  `colorId` int(11) NOT NULL DEFAULT '0' COMMENT 'ID цвета',
  `fileId` int(10) NOT NULL DEFAULT '0',
  `price` decimal(18,2) NOT NULL DEFAULT '0.00',
  `orderBy` int(10) NOT NULL DEFAULT '0',
  `status` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'V'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Промежуточная таблица цветов';

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

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

CREATE TABLE `ls_product_comments` (
  `commentId` int(10) UNSIGNED NOT NULL,
  `answerId` int(12) NOT NULL DEFAULT '0',
  `productId` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `visitorId` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `userId` int(12) NOT NULL DEFAULT '0',
  `content` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `authorName` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `authorEmail` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `authorIp` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `status` enum('pending','approved','spam','unconfirmed') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `addedOn` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `modifiedBy` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `modifiedOn` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `rating` float(3,1) NOT NULL DEFAULT '0.0',
  `checkRating` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `ls_product_features` (
  `id` bigint(20) NOT NULL,
  `parentId` int(11) DEFAULT NULL,
  `sectionIds` text COLLATE utf8mb4_unicode_ci,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fileName` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `orderBy` int(11) NOT NULL,
  `status` char(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'V',
  `isFilter` tinyint(1) NOT NULL DEFAULT '0',
  `content` longtext COLLATE utf8mb4_unicode_ci,
  `addedBy` int(10) NOT NULL DEFAULT '0',
  `addedOn` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `modifiedBy` int(10) NOT NULL DEFAULT '0',
  `modifiedOn` datetime NOT NULL DEFAULT '1970-01-01 00:00:00'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `ls_product_feature_value` (
  `productId` int(11) NOT NULL DEFAULT '0',
  `featureId` int(11) NOT NULL DEFAULT '0',
  `value` varchar(1024) COLLATE utf8mb4_unicode_ci NOT NULL,
  `icon` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `ls_product_images` (
  `imageId` int(10) UNSIGNED NOT NULL,
  `productId` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `fileId` int(12) NOT NULL DEFAULT '0',
  `orderBy` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `type` enum('general','gallery') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'general',
  `title` varchar(1024) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `alias` mediumtext COLLATE utf8mb4_unicode_ci,
  `description` mediumtext COLLATE utf8mb4_unicode_ci,
  `link` varchar(1024) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `position` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `ls_product_option` (
  `product_option_id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `option_id` int(11) NOT NULL,
  `value` text NOT NULL,
  `required` tinyint(1) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

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

CREATE TABLE `ls_product_option_value` (
  `product_option_value_id` int(11) NOT NULL,
  `product_option_id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `option_id` int(11) NOT NULL,
  `option_value_id` int(11) NOT NULL,
  `quantity` int(3) NOT NULL,
  `subtract` tinyint(1) NOT NULL,
  `price` decimal(18,2) NOT NULL,
  `price_prefix` varchar(1) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

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

CREATE TABLE `ls_product_related` (
  `relatedId` int(10) UNSIGNED NOT NULL,
  `productId` int(11) NOT NULL DEFAULT '0',
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Связанные с продуктом';

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

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

CREATE TABLE `ls_product_stock_status` (
  `stock_status_id` int(11) NOT NULL,
  `name` varchar(32) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

INSERT INTO `ls_product_stock_status` (`stock_status_id`, `name`) VALUES
(1, 'В наличии'),
(3, 'Предзаказ'),
(2, 'Нет в наличии');

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

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

CREATE TABLE `ls_sections` (
  `sectionId` mediumint(8) UNSIGNED NOT NULL,
  `parentId` mediumint(8) UNSIGNED DEFAULT NULL,
  `sitemap` char(2) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Y',
  `sortOrder` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `alias` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fileName` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` char(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `typeContent` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'articles',
  `url` mediumtext COLLATE utf8mb4_unicode_ci,
  `content` longtext COLLATE utf8mb4_unicode_ci,
  `status` char(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'V',
  `keywords` mediumtext COLLATE utf8mb4_unicode_ci,
  `description` mediumtext COLLATE utf8mb4_unicode_ci,
  `templateName` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `subTemplateName` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `artTemplateName` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `isCached` tinyint(1) NOT NULL DEFAULT '0',
  `cacheTime` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  `cachePeriod` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  `commentsEnabled` tinyint(1) NOT NULL DEFAULT '0',
  `subIsCached` tinyint(1) NOT NULL DEFAULT '0',
  `subCacheTime` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  `subCachePeriod` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  `subCommentsEnabled` tinyint(1) NOT NULL DEFAULT '0',
  `artIsCached` tinyint(1) NOT NULL DEFAULT '0',
  `artCacheTime` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  `artCachePeriod` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  `addedBy` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `addedOn` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `modifiedBy` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `modifiedOn` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `showMainPage` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Показать как блок на главной странице',
  `topMenu` tinyint(1) DEFAULT NULL COMMENT 'Показать в основном меню',
  `footerMenu` tinyint(1) DEFAULT NULL COMMENT 'Показать в нижнем меню сайта',
  `enableIndex` tinyint(1) NOT NULL DEFAULT '0',
  `enableGallery` tinyint(1) DEFAULT NULL COMMENT 'Показать галерею в этом разделе',
  `enableIcon` tinyint(1) DEFAULT NULL COMMENT 'Показать иконку в этом разделе',
  `icon` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `urlType` enum('default','modal','external') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'default' COMMENT 'Тип ссылки',
  `externalLink` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Внешняя ссылка'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Разделы';

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

INSERT INTO `ls_sections` (`sectionId`, `parentId`, `sitemap`, `sortOrder`, `name`, `alias`, `fileName`, `type`, `typeContent`, `url`, `content`, `status`, `keywords`, `description`, `templateName`, `subTemplateName`, `artTemplateName`, `isCached`, `cacheTime`, `cachePeriod`, `commentsEnabled`, `subIsCached`, `subCacheTime`, `subCachePeriod`, `subCommentsEnabled`, `artIsCached`, `artCacheTime`, `artCachePeriod`, `addedBy`, `addedOn`, `modifiedBy`, `modifiedOn`, `showMainPage`, `topMenu`, `footerMenu`, `enableIndex`, `enableGallery`, `enableIcon`, `icon`, `urlType`, `externalLink`) VALUES
(1, 0, 'Y', 1, 'Главная', 'Главная', 'index', 'plain', 'articles', '/', NULL, 'V', NULL, NULL, 'index.tpl', '', '', 0, 1, 86400, 0, 0, 1, 86400, 0, 0, 1, 86400, 1, '2018-08-10 07:29:18', 1, '2024-04-15 12:00:04', 0, 0, 0, 0, 1, 0, '', 'default', NULL);

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

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

CREATE TABLE `ls_section_images` (
  `imageId` int(10) UNSIGNED NOT NULL,
  `sectionId` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `fileId` int(12) NOT NULL DEFAULT '0',
  `orderBy` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `type` enum('general','gallery','docs') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'general',
  `title` varchar(1024) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `alias` varchar(1024) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` mediumtext COLLATE utf8mb4_unicode_ci,
  `link` mediumtext COLLATE utf8mb4_unicode_ci,
  `position` enum('default','banner','block','carousel','modal','gallery','logo','collection','station') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'default'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `ls_settings` (
  `codename` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `value` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `ls_settings` (`codename`, `value`) VALUES
('bot_id_strings', 'bot\r\ncrawl\r\nslurp\r\narchive\r\nsearch\r\nspider\r\nteoma\r\nsleuth\r\nlink_verification\r\nmediapartners\r\ngrub\r\nichiro\r\nvalidator\r\nchecker\r\nverifier'),
('cache_enabled_section', '0'),
('cache_enabled_article', '0'),
('save_thumbnail_image', '0'),
('mail_bcc', '0'),
('cache_enabled_index', '0'),
('comments_convert_links', '0'),
('keep_original_image_name', '0'),
('google_analytics', ''),
('statistics_enabled', '1'),
('query_fields', 'text|q|query|searchfor|qkw|qt|qry|googlesearch|keywords|string|p|va'),
('query_fields_strings', 'text\r\nq\r\nquery\r\nsearchfor\r\nqkw\r\nqt\r\nqry\r\ngooglesearch\r\nkeywords\r\nstring\r\np\r\nva'),
('old_site_url', ''),
('site_url', 'https://admin.panel.loc'),
('comments_whitelist_enabled', '0'),
('comments_blacklist_enabled', '0'),
('comments_editors_may_approve', '0'),
('comments_captcha_enabled', '0'),
('yandex_metrika', ''),
('cache_period_sitemap', '86400'),
('cache_enabled_sitemap', '0'),
('cache_time_sitemap', '1'),
('cache_period_rss', '86400'),
('cache_time_rss', '1'),
('cache_period_section', '60'),
('cache_time_section', '1'),
('cache_period_article', '60'),
('cache_time_article', '1'),
('filename_word_separator', '-'),
('convert_filename_to_lowercase', '0'),
('file_extension', 'htm'),
('mod_headers', '0'),
('mod_deflate', '0'),
('comments_spam_words', ''),
('comments_hold_words', ''),
('comments_must_be_approved', '0'),
('comments_email_confirmation_required', '0'),
('comments_strip_html', '0'),
('comments_enabled', '0'),
('save_original_image', '0'),
('thumbnail_quality', '95'),
('large_thumb', '1200'),
('medium_thumb', '600'),
('small_thumb', '250'),
('force_webp', '1'),
('methodAuth', 'phone'),
('maxUserDay', '0'),
('sms_endpoint', 'http://91.204.239.44/broker-api/send'),
('sms_login', 'lifestyle'),
('sms_password', 's0$EfPK#'),
('telegram_send', '0'),
('telegram_token', '5343149863:AAFVzts9ZNHwz259x2LKe-AGpKd2YDUs0KQ'),
('telegram_chat_id', '33612524'),
('image_library', '0'),
('smtp_mail', ''),
('smtp_secure', 'ssl'),
('smtp_port', '465'),
('smtp_pass', 'bqmtbtcpgeywfwor'),
('smtp_user', 'smtp@life-style.uz'),
('smtp_server', 'smtp.yandex.ru'),
('email', 'nikolay@life-style.uz'),
('smtp_subject', 'Письмо с сайта'),
('mail_transport', 'smtp'),
('smtp_debug', '0'),
('phone', '+998 (99) 882-11-33, +998 (90) 345-11-33'),
('address', 'Узбекистан, г.Ташкент, ул.Садыка Азимова, 68 (5 этаж, офис №514)'),
('operating_mode', ''),
('company_name', 'Life Style'),
('recaptcha_private_key', ''),
('recaptcha_public_key', ''),
('allow_recaptcha', '1'),
('feedback_captcha_enabled', '1'),
('error_test', '1'),
('check_banned_ips', '0'),
('listIp', ''),
('maintenance_message', '<h1>Сайт временно заблокирован!</h1>\r\n<p>Для выяснения причины блокировки свяжитесь по номеру :</p>\r\n<p><a href=\"tel:+998903451133\"><big>+99890 345 11 33</big></a> </p>\r\n<p>или напишите на <a href=\"mailto:info@life-style.uz\">info@life-style.uz</a></p> \r\n'),
('date_format_custom', '%d.%m.%Y'),
('timezone', 'Asia/Tashkent'),
('use_24_hours', '1'),
('admin_language', 'ru'),
('charset', 'utf-8'),
('website_language', 'ru'),
('theme', 'template-ru'),
('website_name', 'Admin Panel - 11.0.01v'),
('app_store', ''),
('http_redirect', '1'),
('cache_enabled_rss', '0'),
('website_down', '1'),
('compress_js_css', '0'),
('bot_id_regexp', 'bot|crawl|slurp|archive|search|spider|teoma|sleuth|link_verification|mediapartners|grub|ichiro|validator|checker|verifier'),
('twoFactorAuth', '0'),
('hour_adjustment', '5'),
('minute_adjustment', '0'),
('rewrite', '795dbdeaba386399b21b192fd8bdabdf'),
('phone_mask', '+### ## ###-##-##'),
('allow_watermark', '0'),
('max_watermark', '100'),
('watermark_type', '1'),
('watermark_text', 'Powered by Life Style ©'),
('watermark_position', 'CENTER CENTER'),
('mod_expires', '0'),
('watermark_font', '16'),
('watermark_color_dark', '#000000'),
('watermark_rotate', '0'),
('watermark_color_light', '#FFFFFF'),
('watermark_opacity', '50'),
('support_email', 'info@life-style.uz'),
('max_file_size', '128'),
('max_up_size', '20'),
('last_article_popularityLast7days_update', '2023-11-05'),
('only_ssl', '1'),
('image_generation', 'imagine'),
('telegram_status', 'V'),
('telegram_message', 'on'),
('telegram_timeout', ''),
('telegram_proxy', 'no'),
('hotline_phone', ''),
('google_play', ''),
('www_redirect', '1');

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

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

CREATE TABLE `ls_shop_cart` (
  `cartId` int(11) UNSIGNED NOT NULL,
  `userId` int(11) UNSIGNED DEFAULT '0',
  `productId` int(11) NOT NULL DEFAULT '0',
  `options` mediumtext COLLATE utf8mb4_unicode_ci,
  `quantity` int(10) NOT NULL DEFAULT '1',
  `token` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `addedBy` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Корзина';

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

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

CREATE TABLE `ls_shop_currency` (
  `id` int(11) NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `codeName` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `course` decimal(18,2) NOT NULL DEFAULT '0.00',
  `cent` int(1) NOT NULL DEFAULT '2',
  `thousands_separator` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `isDefault` tinyint(1) NOT NULL DEFAULT '0',
  `addedBy` int(10) NOT NULL DEFAULT '0',
  `addedOn` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `modifiedBy` int(10) NOT NULL DEFAULT '0',
  `modifiedOn` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `orderBy` mediumint(4) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Курсы валют';

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

INSERT INTO `ls_shop_currency` (`id`, `title`, `codeName`, `course`, `cent`, `thousands_separator`, `isDefault`, `addedBy`, `addedOn`, `modifiedBy`, `modifiedOn`, `orderBy`) VALUES
(1, 'USD', '$', 11400.00, 2, ' ', 0, 0, '1970-01-01 00:00:00', 1, '2023-05-03 21:09:00', 0),
(3, 'СУМ', 'сум', 1.00, 0, ' ', 1, 0, '1970-01-01 00:00:00', 1, '2023-05-03 21:08:52', 0),
(4, 'RUB', '₽', 78.49, 2, ',', 0, 0, '1970-01-01 00:00:00', 0, '1970-01-01 00:00:00', 0),
(5, 'EUR', '€', 1.11, 2, ' ', 0, 0, '1970-01-01 00:00:00', 0, '1970-01-01 00:00:00', 0);

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

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

CREATE TABLE `ls_shop_orders` (
  `order_id` int(11) NOT NULL COMMENT 'ID заказа',
  `userId` int(11) NOT NULL COMMENT 'ID пользователя (если есть регистрация на сайте)',
  `fullName` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Ф.И.О.',
  `firstName` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `middleName` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `lastName` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(96) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'email',
  `phone` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Номер телефона',
  `address` mediumtext COLLATE utf8mb4_unicode_ci COMMENT 'Адрес доставки',
  `createdBy` datetime NOT NULL COMMENT 'Дата заказа',
  `modifiedOn` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `message` mediumtext COLLATE utf8mb4_unicode_ci COMMENT 'Сообщение от заказчика',
  `payment_choice` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Способ оплаты',
  `payment_method` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Метод оплаты',
  `shipping_zone` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Город доставки',
  `shipping_date` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Дата доставки',
  `shipping_method` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Метод досавки',
  `shipping_coordinates` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shipping_amount` decimal(18,2) NOT NULL DEFAULT '0.00' COMMENT 'Стоимость доставки',
  `products_amount` decimal(18,2) NOT NULL DEFAULT '0.00' COMMENT 'Общая сумма за товар',
  `amount` decimal(18,2) NOT NULL DEFAULT '0.00' COMMENT 'Общая сумма к оплате',
  `click_trans_id` int(11) NOT NULL COMMENT 'CLICK',
  `click_paydoc_id` int(11) NOT NULL COMMENT 'CLICK',
  `merchant_trans_id` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'CLICK',
  `error` int(11) DEFAULT NULL COMMENT 'CLICK',
  `error_note` mediumtext COLLATE utf8mb4_unicode_ci COMMENT 'CLICK',
  `status` enum('waiting','rejected','confirmed') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'waiting' COMMENT 'Статус оплаты',
  `state` tinyint(1) NOT NULL,
  `order_status_id` int(11) NOT NULL DEFAULT '2'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Заказы';

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

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

CREATE TABLE `ls_shop_order_option` (
  `order_option_id` int(11) NOT NULL,
  `order_id` int(11) NOT NULL,
  `order_product_id` int(11) NOT NULL,
  `product_option_id` int(11) NOT NULL,
  `product_option_value_id` int(11) NOT NULL DEFAULT '0',
  `name` varchar(255) NOT NULL,
  `value` text NOT NULL,
  `type` varchar(32) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

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

CREATE TABLE `ls_shop_order_product` (
  `order_product_id` int(11) NOT NULL,
  `order_id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `brand` varchar(128) DEFAULT NULL,
  `sku` varchar(64) NOT NULL,
  `ikpu` varchar(64) DEFAULT NULL,
  `quantity` int(4) NOT NULL,
  `price` decimal(18,2) NOT NULL DEFAULT '0.00',
  `total` decimal(18,2) NOT NULL DEFAULT '0.00',
  `reward` int(8) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

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

CREATE TABLE `ls_shop_order_shipment` (
  `order_shipment_id` int(11) NOT NULL,
  `order_id` int(11) NOT NULL,
  `date_added` datetime NOT NULL,
  `shipping_courier_id` varchar(255) NOT NULL DEFAULT '',
  `tracking_number` varchar(255) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

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

CREATE TABLE `ls_shop_order_status` (
  `order_status_id` int(11) NOT NULL,
  `name` varchar(32) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

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

CREATE TABLE `ls_shop_order_total` (
  `order_total_id` int(10) NOT NULL,
  `order_id` int(11) NOT NULL,
  `code` varchar(32) NOT NULL,
  `title` varchar(255) NOT NULL,
  `value` decimal(15,4) NOT NULL DEFAULT '0.0000',
  `sort_order` int(3) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

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

CREATE TABLE `ls_shop_payments` (
  `paymentId` int(10) UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `fileName` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `status` char(1) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'H',
  `summary` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `settings` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `addedBy` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `addedOn` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `modifiedBy` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `modifiedOn` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `orderBy` mediumint(4) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Способы оплаты' ROW_FORMAT=DYNAMIC;

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

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

CREATE TABLE `ls_shop_transactions` (
  `id` int(11) NOT NULL,
  `paycom_transaction_id` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `paycom_time` varchar(13) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `paycom_time_datetime` datetime NOT NULL,
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `perform_time` datetime DEFAULT '1970-01-01 00:00:00',
  `cancel_time` datetime DEFAULT '1970-01-01 00:00:00',
  `amount` int(11) NOT NULL,
  `state` tinyint(2) NOT NULL,
  `reason` tinyint(2) DEFAULT NULL,
  `receivers` varchar(500) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'JSON array of receivers',
  `order_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Транзакции для PayMe';

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

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

CREATE TABLE `ls_socials` (
  `socialId` int(11) NOT NULL,
  `name` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL,
  `url` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `icon` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `fileName` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` char(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'V',
  `orderBy` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  `addedBy` int(10) NOT NULL DEFAULT '0',
  `addedOn` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `modifiedBy` int(10) NOT NULL DEFAULT '0',
  `modifiedOn` datetime NOT NULL DEFAULT '1970-01-01 00:00:00'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Соц.сети';

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

INSERT INTO `ls_socials` (`socialId`, `name`, `url`, `icon`, `fileName`, `status`, `orderBy`, `addedBy`, `addedOn`, `modifiedBy`, `modifiedOn`) VALUES
(1, 'Телеграм', 'https://t.me/uzbekmarketing', 'telegram', 'telegram', 'V', 1, 1, '2023-01-09 23:23:36', 173, '2024-03-18 07:04:09'),
(2, 'Facebook', 'https://facebook.com/uzbekmarketing', 'facebook', 'facebook', 'V', 3, 1, '2023-01-09 23:23:36', 173, '2024-03-18 07:04:29'),
(3, 'Instagram', 'https://www.instagram.com/uzbekmarketing/', 'instagram', 'instagram', 'V', 2, 1, '2023-01-09 23:23:36', 173, '2024-03-18 07:04:21'),
(5, 'Twitter', 'https://twitter.com/', 'twitter', 'twitter', 'H', 5, 1, '2023-01-09 23:23:36', 1, '2023-03-18 12:13:19'),
(6, 'YouTube', 'https://www.youtube.com/', 'youtube', 'youtube', 'H', 4, 1, '2023-01-09 23:23:36', 1, '2023-03-15 18:01:36'),
(4, 'Одноклассники', 'https://ok.ru/', 'ok', 'ok', 'H', 6, 1, '2023-01-09 23:23:36', 1, '2023-03-20 22:58:34');

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

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

CREATE TABLE `ls_stats_ad_clicks` (
  `visitId` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `destination` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `srcVisitId` int(10) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `ls_stats_article_visits` (
  `visitId` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `articleId` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  `visitorIp` varchar(90) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `ls_stats_cache_daily` (
  `cacheDate` date NOT NULL DEFAULT '1970-01-01',
  `newVisitors` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  `retVisitors` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  `sectionVisits` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  `productVisits` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  `articleVisits` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  `searchVisits` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  `errorVisits` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  `rssVisits` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  `pageGenTime100` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  `pageGenTime250` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  `pageGenTime500` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  `pageGenTime1000` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  `pageGenTime2000` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  `pageGenTimeMore` mediumint(8) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `ls_stats_error_visits` (
  `visitId` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `errorCode` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
  `requestUri` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `referer` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `ls_stats_product_visits` (
  `visitId` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `productId` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  `visitorIp` varchar(90) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `ls_stats_rss_visits` (
  `visitId` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `sectionId` mediumint(8) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `ls_stats_search_visits` (
  `visitId` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `searchQuery` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `searchPage` tinyint(3) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `ls_stats_section_visits` (
  `visitId` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `sectionId` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  `page` tinyint(3) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `ls_stats_user_agents` (
  `userAgentId` mediumint(8) UNSIGNED NOT NULL,
  `userAgent` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `isBot` tinyint(1) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `ls_stats_visitors` (
  `visitorId` int(10) UNSIGNED NOT NULL,
  `firstVisitOn` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `referer` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `refid` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  `visitorIp` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `userAgentId` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  `userOs` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `userBrowser` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `userDevice` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `ls_stats_visits` (
  `visitId` int(10) UNSIGNED NOT NULL,
  `visitDate` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `visitorId` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `typeId` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  `isFirst` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
  `loadTime` float(5,4) UNSIGNED NOT NULL DEFAULT '0.0000'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `ls_subscribe` (
  `userId` int(10) UNSIGNED NOT NULL,
  `email` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `registered` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `ls_telegram_notifications` (
  `codename` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `value` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `ls_telegram_notifications` (`codename`, `value`) VALUES
('timeout', '5'),
('webhook', 'potential'),
('trim_messages', '0'),
('telegram_key', '5343149863:AAFVzts9ZNHwz259x2LKe-AGpKd2YDUs0KQ'),
('status', 'V'),
('proxy', '0'),
('logs', '1'),
('telegram_user_data', '{\"1\":{\"id_telegram\":\"-4066694072\",\"checked\":\"on\"},\"2\":{\"id_telegram\":\"\"},\"3\":{\"id_telegram\":\"\"},\"173\":{\"id_telegram\":\"\"}}'),
('telegram_proxy_data', '[{\"ip\":\"\",\"port\":\"\",\"login\":\"\",\"password\":\"\"}]'),
('telegram_langdata', '{\"call_me_telegram\":\"#\\u041e\\u0431\\u0440\\u0430\\u0442\\u043d\\u044b\\u0439_\\u0437\\u0432\\u043e\\u043d\\u043e\\u043a\\r\\n\\u0424.\\u0418.\\u041e. {fullName}, \\r\\n\\u0422\\u0435\\u043b\\u0435\\u0444\\u043e\\u043d {phone},\\r\\n\\u0414\\u0430\\u0442\\u0430 \\u0438 \\u0432\\u0440\\u0435\\u043c\\u044f \\u0434\\u043e\\u0431\\u0430\\u0432\\u043b\\u0435\\u043d\\u0438\\u044f {date_added}, \",\"feedback_telegram\":\"#\\u041d\\u043e\\u0432\\u043e\\u0435_\\u0441\\u043e\\u043e\\u0431\\u0449\\u0435\\u043d\\u0438\\u0435\\r\\n\\u0424.\\u0418.\\u041e. {fullName}, \\r\\n\\u0422\\u0435\\u043b\\u0435\\u0444\\u043e\\u043d: {phone},\\r\\n\\u0421\\u043e\\u043e\\u0431\\u0449\\u0435\\u043d\\u0438\\u0435:{message}\",\"question_telegram\":\"\",\"service_telegram\":\"#\\u0417\\u0430\\u044f\\u0432\\u043a\\u0430_\\u0432_\\u0441\\u0435\\u0440\\u0432\\u0438\\u0441\\r\\n\\u0424.\\u0418.\\u041e.: {fullName}, \\r\\n\\u0422\\u0435\\u043b\\u0435\\u0444\\u043e\\u043d: {phone},\\r\\nE-mail: {email},\\r\\n\\u041a\\u0443\\u0440\\u0441: {course}.\\r\\n\",\"quickOrder_telegram\":\"\",\"agreePurchase_telegram\":\"\",\"order_telegram\":\"\"}'),
('telegram_user_groupdata', '');

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

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

CREATE TABLE `ls_type_content` (
  `typeId` int(10) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `fileName` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` char(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'V',
  `content` longtext COLLATE utf8mb4_unicode_ci,
  `addedBy` int(10) NOT NULL DEFAULT '0',
  `addedOn` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `modifiedBy` int(10) NOT NULL DEFAULT '0',
  `modifiedOn` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `orderBy` smallint(3) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

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

INSERT INTO `ls_type_content` (`typeId`, `name`, `fileName`, `status`, `content`, `addedBy`, `addedOn`, `modifiedBy`, `modifiedOn`, `orderBy`) VALUES
(1, 'Контент', 'articles', 'V', NULL, 1, '2023-04-06 14:03:03', 1, '2023-10-25 11:55:15', 1);

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

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

CREATE TABLE `ls_type_content_fields` (
  `fieldId` int(10) UNSIGNED NOT NULL,
  `typeId` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `fileName` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` char(1) COLLATE utf8mb4_unicode_ci DEFAULT 'I',
  `position` char(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'M',
  `radio_group_position` char(1) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type_sql` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` char(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'V',
  `addedBy` int(10) NOT NULL DEFAULT '0',
  `addedOn` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `modifiedBy` int(10) NOT NULL DEFAULT '0',
  `modifiedOn` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `class` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `wrapper_class` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `orderBy` int(6) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

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

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

CREATE TABLE `ls_type_content_field_data` (
  `articleId` int(10) NOT NULL,
  `fileName` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

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

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

CREATE TABLE `ls_type_content_field_property` (
  `propertyId` int(10) NOT NULL,
  `fieldId` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `propertyKey` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `orderBy` int(6) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

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

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

CREATE TABLE `ls_users` (
  `userId` int(10) UNSIGNED NOT NULL,
  `userType` char(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'C' COMMENT 'Тип пользователя',
  `loginName` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Логин',
  `email` varchar(249) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Емайл',
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Пароль',
  `code` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `receiveEmails` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Не получать писем',
  `status` tinyint(2) UNSIGNED NOT NULL DEFAULT '0',
  `verified` tinyint(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Подтверждение через email',
  `resettable` tinyint(1) UNSIGNED NOT NULL DEFAULT '1',
  `accessLevel` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Уровень доступа',
  `registered` int(10) UNSIGNED NOT NULL COMMENT 'Дата регистрации',
  `last_login` int(10) UNSIGNED DEFAULT NULL COMMENT 'Последний вход',
  `force_logout` mediumint(7) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Принудительные выходы из системы',
  `gender` int(1) DEFAULT '0' COMMENT 'Пол',
  `fullName` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Ф.И.О.',
  `firstName` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Имя',
  `middleName` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Отчество',
  `lastName` varchar(90) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Фамилия',
  `phone` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Номер телефона',
  `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Адрес',
  `fileId` int(12) DEFAULT NULL COMMENT 'ID картинки',
  `addedBy` int(10) NOT NULL DEFAULT '0',
  `addedOn` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `modifiedBy` int(10) DEFAULT NULL,
  `modifiedOn` datetime DEFAULT '1970-01-01 00:00:00',
  `subscribe` enum('yes','no') COLLATE utf8mb4_unicode_ci DEFAULT 'no' COMMENT 'Подписка на новости',
  `paid` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Статус оплаты',
  `favorites` mediumtext COLLATE utf8mb4_unicode_ci COMMENT 'Избранные',
  `compares` mediumtext COLLATE utf8mb4_unicode_ci COMMENT 'Сравнение'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Пользователи';

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

INSERT INTO `ls_users` (`userId`, `userType`, `loginName`, `email`, `password`, `code`, `receiveEmails`, `status`, `verified`, `resettable`, `accessLevel`, `registered`, `last_login`, `force_logout`, `gender`, `fullName`, `firstName`, `middleName`, `lastName`, `phone`, `address`, `fileId`, `addedBy`, `addedOn`, `modifiedBy`, `modifiedOn`, `subscribe`, `paid`, `favorites`, `compares`) VALUES
(1, 'D', 'nikolaimv', 'nikolay@life-style.uz', '$2y$10$oasSFhqCim.OLAt/31HwOOja3n6xyAYkukm6P.jXUNDygjGlXW94a', NULL, 1, 1, 1, 1, 1, 1628887319, 1718003674, 161, 0, 'Николай', 'Николай', 'Владимирович', NULL, NULL, 'Узбекистан, г. Ташкент,ул. Садыка Азимова 68', NULL, 1, '2021-08-13 20:41:59', 1, '2023-10-25 11:58:19', 'no', 0, NULL, NULL),
(2, 'D', 'zakir', 'info@life-style.uz', '$2y$10$4XODpX57HeOKb.SoE4KXD.SJiutexp.wvDoOGVb/xvpcWcdQlttOe', NULL, 1, 1, 1, 1, 1, 1649949967, 1706090786, 0, 0, 'Закир Мавлянов', NULL, NULL, NULL, '+998 (99) 882-11-33', '', NULL, 1, '2022-04-14 15:26:07', 1, '2024-06-10 07:32:19', 'no', 0, NULL, NULL),
(3, 'A', 'admin', 'admin@life-style.uz', '$2y$10$vLATycnLzvZBOjRuvYOt6uK8qinaCFVp0rrrDU5hmos7t3x9ZJq3C', NULL, 1, 1, 1, 1, 6, 1627487969, 1707805086, 1, 0, 'admin', 'Иван', 'Иванович', 'Иванов', '+998 (99) 882-11-33', 'Узбекистан, г. Ташкент,ул. Садыка Азимова 68', NULL, 2, '2015-06-12 01:00:00', 173, '2024-01-30 06:46:43', 'no', 0, NULL, NULL),
(173, 'D', 'dmitriy', NULL, '$2y$10$b6CpDW30trI5pCLTTZipIeNJ2mzXrK2aV2JCkGrVRhvlFLn3sSOCW', NULL, 1, 1, 1, 1, 1, 1682065581, 1710844172, 0, 0, 'Дмитрий', NULL, NULL, NULL, '', '', NULL, 1, '2023-04-21 08:26:21', 1, '2023-12-15 05:31:50', 'no', 0, NULL, NULL),
(176, 'C', '+998 (97) 155-71-75', 'nikolay@life-style.uz', '$2y$10$ZQuIdlZuf930xKXOJTRRmOToQ7QGVNyCcf6xhztJFJnl26HRSqr7W', NULL, 0, 1, 1, 1, 0, 1698760471, 1700196256, 5, 0, 'Иван Иванов', 'Иван', NULL, 'Иванов', '+998 (97) 155-71-75', '{\"city\":\"Ташкент\",\"street\":\"qweq\",\"house\":\"12\",\"flat\":\"1\",\"porch\":\"1\",\"floor\":\"1\"}', NULL, 0, '1970-01-01 00:00:00', NULL, '1970-01-01 00:00:00', 'no', 0, NULL, NULL),
(177, 'A', 'nikolayfad', NULL, '$2y$10$IZ1VLGUg0kYuG54PU6dd6OhYLdLni1N1/WJyERvxQs6YEKskKcOmy', NULL, 0, 1, 1, 1, 2, 1704866259, 1704866322, 0, 0, 'nikolayfad', NULL, NULL, NULL, '', '', NULL, 173, '2024-01-10 05:57:39', 173, '2024-01-10 05:57:39', 'no', 0, NULL, NULL),
(178, 'D', 'pulat', NULL, '$2y$10$br4fRjyOFN9FwJOjDeakb.B9j/Rpaw/w97JQ2YlbF2OyJu2p8I096', NULL, 1, 1, 1, 1, 1, 1718004652, 1718004652, 0, 0, 'Пулат', NULL, NULL, NULL, '', 'ул. Садык Азимова 68', NULL, 1, '2024-06-10 07:30:52', 1, '2024-06-10 07:32:34', 'no', 0, NULL, NULL);

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

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

CREATE TABLE `ls_users_banned_ips` (
  `visitorIp` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `bannedOn` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `expiresOn` datetime NOT NULL DEFAULT '1970-01-01 00:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Блокировка пользователей по IP';

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

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

CREATE TABLE `ls_users_confirmations` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `email` varchar(249) COLLATE utf8mb4_unicode_ci NOT NULL,
  `selector` varchar(16) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `expires` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Подтверждения пользователей';

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

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

CREATE TABLE `ls_users_remembered` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user` int(10) UNSIGNED NOT NULL,
  `selector` varchar(24) CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL,
  `token` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL,
  `expires` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Запомнить пользователя';

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

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

CREATE TABLE `ls_users_resets` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user` int(10) UNSIGNED NOT NULL,
  `selector` varchar(20) CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL,
  `token` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL,
  `expires` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Сбросить пользователя';

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

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

CREATE TABLE `ls_users_throttling` (
  `bucket` varchar(44) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tokens` float UNSIGNED NOT NULL,
  `replenished_at` int(10) UNSIGNED NOT NULL,
  `expires_at` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='регулирование пользователей';

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

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

CREATE TABLE `ls_user_group` (
  `groupId` mediumint(8) UNSIGNED NOT NULL,
  `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'V',
  `groupName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `fileName` varchar(30) NOT NULL,
  `letter` char(1) DEFAULT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `addedBy` int(10) NOT NULL DEFAULT '0',
  `addedOn` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `modifiedBy` int(10) NOT NULL DEFAULT '0',
  `modifiedOn` datetime NOT NULL DEFAULT '1970-01-01 00:00:00'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

INSERT INTO `ls_user_group` (`groupId`, `status`, `groupName`, `fileName`, `letter`, `description`, `addedBy`, `addedOn`, `modifiedBy`, `modifiedOn`) VALUES
(1, 'V', 'Разработчик', 'developer', 'D', 'Группа исключительно для разработчиков сайта', 1, '2023-03-07 07:12:37', 1, '2024-05-10 08:05:55'),
(2, 'V', 'Администратор', 'admin', 'A', 'Группа исключительно для администраторов сайта', 1, '2023-03-07 07:12:37', 1, '2024-03-13 13:09:42'),
(6, 'V', 'Mенеджер', 'manager', 'M', '', 1, '2023-03-07 07:12:37', 1, '2024-03-13 13:09:48');

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

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

CREATE TABLE `ls_user_group_privileges` (
  `groupId` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  `privilege` varchar(32) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

INSERT INTO `ls_user_group_privileges` (`groupId`, `privilege`) VALUES
(1, 'articles'),
(1, 'bannergroups'),
(1, 'banners'),
(1, 'blocks'),
(1, 'bots'),
(1, 'errors'),
(1, 'faqs'),
(1, 'favicon'),
(1, 'feedbacks'),
(1, 'filemanager'),
(1, 'inivars'),
(1, 'langs'),
(1, 'logo'),
(1, 'logs'),
(1, 'lowerrors'),
(1, 'managergroups'),
(1, 'managers'),
(1, 'maps'),
(1, 'news'),
(1, 'overview'),
(1, 'programs'),
(1, 'referer'),
(1, 'robots'),
(1, 'sections'),
(1, 'serverinfo'),
(1, 'settings'),
(1, 'socials'),
(1, 'syserrors'),
(1, 'telegrams'),
(1, 'template'),
(1, 'visitors'),
(2, 'articles'),
(2, 'bannergroups'),
(2, 'banners'),
(2, 'blocks'),
(2, 'countries'),
(2, 'features'),
(2, 'feedbacks'),
(2, 'langs'),
(2, 'logo'),
(2, 'managers'),
(2, 'maps'),
(2, 'news'),
(2, 'products'),
(2, 'programs'),
(2, 'sections'),
(2, 'settings'),
(2, 'socials'),
(2, 'stations'),
(2, 'teams'),
(6, 'articles'),
(6, 'bannergroups'),
(6, 'banners'),
(6, 'blocks'),
(6, 'features'),
(6, 'feedbacks'),
(6, 'logo'),
(6, 'maps'),
(6, 'news'),
(6, 'products'),
(6, 'programs'),
(6, 'sections'),
(6, 'settings'),
(6, 'socials'),
(6, 'stations'),
(6, 'teams');

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

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

CREATE TABLE `ls_user_history` (
  `eventOn` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `userId` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `loginName` varchar(255) NOT NULL DEFAULT '',
  `visitorIp` varchar(255) NOT NULL DEFAULT '',
  `action` enum('login','logout') NOT NULL DEFAULT 'login',
  `status` enum('ok','error') NOT NULL DEFAULT 'error'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='История входа и выхода пользователей из админ панели';

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

INSERT INTO `ls_user_history` (`eventOn`, `userId`, `loginName`, `visitorIp`, `action`, `status`) VALUES
('2024-03-13 04:08:17', 0, 'nikolaimv1', '::1', 'login', 'error'),
('2024-03-13 04:08:34', 1, 'nikolaimv', '::1', 'login', 'ok'),
('2024-03-14 07:08:11', 1, 'nikolaimv', '::1', 'login', 'ok'),
('2024-03-15 09:48:36', 1, 'nikolaimv', '::1', 'login', 'ok'),
('2024-03-16 10:22:04', 1, 'nikolaimv', '82.215.101.16', 'login', 'ok'),
('2024-03-18 06:04:19', 173, 'dmitriy', '213.230.127.237', 'login', 'ok'),
('2024-04-07 08:50:36', 1, 'nikolaimv', '::1', 'login', 'ok'),
('2024-04-15 05:23:15', 1, 'nikolaimv', '::1', 'login', 'ok'),
('2024-05-10 06:52:58', 1, 'nikolaimv', '::1', 'login', 'ok'),
('2024-05-10 06:53:46', 1, 'nikolaimv', '::1', 'login', 'ok'),
('2024-05-10 06:55:16', 1, 'nikolaimv', '::1', 'login', 'ok'),
('2024-05-17 09:57:29', 1, 'nikolaimv', '::1', 'login', 'ok'),
('2024-05-17 10:12:22', 1, 'nikolaimv', '::1', 'login', 'ok');

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

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

CREATE TABLE `ls_user_images` (
  `imageId` int(10) UNSIGNED NOT NULL,
  `userId` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `fileId` int(12) NOT NULL DEFAULT '0',
  `orderBy` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `type` enum('general','gallery','docs') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'general',
  `title` varchar(1024) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `ls_user_images` (`imageId`, `userId`, `fileId`, `orderBy`, `type`, `title`) VALUES
(3, 2, 10, 0, 'general', NULL),
(5, 3, 5, 0, 'general', NULL),
(14, 173, 7, 0, 'general', NULL),
(62, 1, 9, 0, 'general', NULL),
(63, 178, 6, 0, 'general', NULL);

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

--
-- Индексы таблицы `ls_articles`
--
ALTER TABLE `ls_articles`
  ADD PRIMARY KEY (`articleId`),
  ADD KEY `status` (`status`),
  ADD KEY `isFeatured` (`isFeatured`),
  ADD KEY `publishedOn` (`publishedOn`),
  ADD KEY `sectionId` (`sectionId`),
  ADD KEY `fileName` (`fileName`(250)),
  ADD KEY `popularityLast7days` (`popularityLast7days`),
  ADD KEY `popularityLast14days` (`popularityLast14days`),
  ADD KEY `popularityLast30days` (`popularityLast30days`),
  ADD KEY `popularityLastMonth` (`popularityLastMonth`),
  ADD KEY `popularityYesterday` (`popularityYesterday`),
  ADD KEY `addedBy` (`addedBy`),
  ADD KEY `orderBy` (`orderBy`),
  ADD KEY `typeContent` (`typeContent`),
  ADD KEY `enableGallery` (`enableGallery`);
ALTER TABLE `ls_articles` ADD FULLTEXT KEY `fulltextIndex` (`title`,`content`,`keywords`);

--
-- Индексы таблицы `ls_article_images`
--
ALTER TABLE `ls_article_images`
  ADD PRIMARY KEY (`imageId`),
  ADD KEY `articleId` (`articleId`),
  ADD KEY `sortOrder` (`orderBy`),
  ADD KEY `fileId` (`fileId`),
  ADD KEY `brandId` (`articleId`);

--
-- Индексы таблицы `ls_article_visits`
--
ALTER TABLE `ls_article_visits`
  ADD PRIMARY KEY (`visitId`),
  ADD KEY `articleId` (`articleId`(250));

--
-- Индексы таблицы `ls_banners`
--
ALTER TABLE `ls_banners`
  ADD PRIMARY KEY (`bannerId`),
  ADD KEY `status` (`status`),
  ADD KEY `orderBy` (`orderBy`);
ALTER TABLE `ls_banners` ADD FULLTEXT KEY `fulltextIndex` (`title`);

--
-- Индексы таблицы `ls_banners_group`
--
ALTER TABLE `ls_banners_group`
  ADD PRIMARY KEY (`groupId`) USING BTREE,
  ADD KEY `position` (`orderBy`),
  ADD KEY `visible` (`status`),
  ADD KEY `pages` (`pages`),
  ADD KEY `addedBy` (`addedBy`),
  ADD KEY `modifiedBy` (`modifiedBy`);

--
-- Индексы таблицы `ls_banner_images`
--
ALTER TABLE `ls_banner_images`
  ADD PRIMARY KEY (`imageId`),
  ADD KEY `fileId` (`fileId`),
  ADD KEY `orderBy` (`orderBy`),
  ADD KEY `sectionId` (`bannerId`) USING BTREE;

--
-- Индексы таблицы `ls_banner_tracking`
--
ALTER TABLE `ls_banner_tracking`
  ADD PRIMARY KEY (`groupId`,`sectionId`) USING BTREE,
  ADD KEY `userId` (`groupId`),
  ADD KEY `sectionId` (`sectionId`) USING BTREE;

--
-- Индексы таблицы `ls_blocks`
--
ALTER TABLE `ls_blocks`
  ADD PRIMARY KEY (`blockId`),
  ADD KEY `status` (`status`),
  ADD KEY `sectionId` (`sectionId`),
  ADD KEY `addedBy` (`addedBy`),
  ADD KEY `modifiedBy` (`modifiedBy`);

--
-- Индексы таблицы `ls_block_images`
--
ALTER TABLE `ls_block_images`
  ADD PRIMARY KEY (`imageId`),
  ADD KEY `sortOrder` (`orderBy`),
  ADD KEY `fileId` (`fileId`),
  ADD KEY `brandId` (`blockId`),
  ADD KEY `blockId` (`blockId`) USING BTREE;

--
-- Индексы таблицы `ls_clients`
--
ALTER TABLE `ls_clients`
  ADD PRIMARY KEY (`articleId`),
  ADD KEY `status` (`status`),
  ADD KEY `isFeatured` (`isFeatured`),
  ADD KEY `publishedOn` (`publishedOn`),
  ADD KEY `sectionId` (`sectionId`),
  ADD KEY `fileName` (`fileName`(250)),
  ADD KEY `addedBy` (`addedBy`),
  ADD KEY `orderBy` (`orderBy`),
  ADD KEY `enableGallery` (`enableGallery`),
  ADD KEY `companyId` (`companyIds`(250));
ALTER TABLE `ls_clients` ADD FULLTEXT KEY `fulltextIndex` (`title`,`content`,`keywords`);

--
-- Индексы таблицы `ls_client_images`
--
ALTER TABLE `ls_client_images`
  ADD PRIMARY KEY (`imageId`),
  ADD KEY `articleId` (`articleId`),
  ADD KEY `sortOrder` (`orderBy`),
  ADD KEY `fileId` (`fileId`),
  ADD KEY `brandId` (`articleId`);

--
-- Индексы таблицы `ls_colors`
--
ALTER TABLE `ls_colors`
  ADD PRIMARY KEY (`colorId`),
  ADD KEY `addedBy` (`addedBy`),
  ADD KEY `modifiedBy` (`modifiedBy`),
  ADD KEY `orderBy` (`orderBy`),
  ADD KEY `status` (`status`),
  ADD KEY `colorCode` (`colorCode`);

--
-- Индексы таблицы `ls_comments`
--
ALTER TABLE `ls_comments`
  ADD PRIMARY KEY (`commentId`),
  ADD KEY `articleId` (`articleId`);

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

--
-- Индексы таблицы `ls_feedback`
--
ALTER TABLE `ls_feedback`
  ADD PRIMARY KEY (`id`),
  ADD KEY `status` (`status`),
  ADD KEY `fullName` (`fullName`(250)),
  ADD KEY `email` (`email`),
  ADD KEY `phone` (`phone`);

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

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

--
-- Индексы таблицы `ls_languages`
--
ALTER TABLE `ls_languages`
  ADD PRIMARY KEY (`languageId`),
  ADD KEY `sortOrder` (`sortOrder`),
  ADD KEY `status` (`status`),
  ADD KEY `codename` (`codename`),
  ADD KEY `isDefault` (`isDefault`);

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

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

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

--
-- Индексы таблицы `ls_options`
--
ALTER TABLE `ls_options`
  ADD PRIMARY KEY (`optionId`) USING BTREE,
  ADD KEY `orderBy` (`orderBy`),
  ADD KEY `featureId` (`optionId`),
  ADD KEY `status` (`status`),
  ADD KEY `addedBy` (`addedBy`),
  ADD KEY `modifiedBy` (`modifiedBy`),
  ADD KEY `parentId` (`parentId`);

--
-- Индексы таблицы `ls_products`
--
ALTER TABLE `ls_products`
  ADD PRIMARY KEY (`productId`) USING BTREE,
  ADD KEY `status` (`status`),
  ADD KEY `isFeatured` (`isFeatured`),
  ADD KEY `publishedOn` (`publishedOn`),
  ADD KEY `sectionId` (`sectionId`),
  ADD KEY `fileName` (`fileName`(250)),
  ADD KEY `popularityLast7days` (`popularityLast7days`),
  ADD KEY `popularityLast14days` (`popularityLast14days`),
  ADD KEY `popularityLast30days` (`popularityLast30days`),
  ADD KEY `popularityLastMonth` (`popularityLastMonth`),
  ADD KEY `popularityYesterday` (`popularityYesterday`),
  ADD KEY `addedBy` (`addedBy`),
  ADD KEY `orderBy` (`orderBy`),
  ADD KEY `enableGallery` (`enableGallery`),
  ADD KEY `modifiedBy` (`modifiedBy`);
ALTER TABLE `ls_products` ADD FULLTEXT KEY `fulltextIndex` (`title`,`content`,`keywords`);

--
-- Индексы таблицы `ls_product_blocks`
--
ALTER TABLE `ls_product_blocks`
  ADD PRIMARY KEY (`blockId`),
  ADD KEY `status` (`status`),
  ADD KEY `orderBy` (`orderBy`),
  ADD KEY `productId` (`productId`) USING BTREE;
ALTER TABLE `ls_product_blocks` ADD FULLTEXT KEY `fulltextIndex` (`title`,`content`);

--
-- Индексы таблицы `ls_product_block_images`
--
ALTER TABLE `ls_product_block_images`
  ADD PRIMARY KEY (`imageId`),
  ADD KEY `sortOrder` (`orderBy`),
  ADD KEY `fileId` (`fileId`),
  ADD KEY `brandId` (`blockId`),
  ADD KEY `blockId` (`blockId`) USING BTREE;

--
-- Индексы таблицы `ls_product_colors`
--
ALTER TABLE `ls_product_colors`
  ADD PRIMARY KEY (`imageId`),
  ADD KEY `colorId` (`colorId`) USING BTREE,
  ADD KEY `fileId` (`fileId`),
  ADD KEY `productId` (`productId`) USING BTREE;

--
-- Индексы таблицы `ls_product_comments`
--
ALTER TABLE `ls_product_comments`
  ADD PRIMARY KEY (`commentId`),
  ADD KEY `productId` (`productId`) USING BTREE;

--
-- Индексы таблицы `ls_product_features`
--
ALTER TABLE `ls_product_features`
  ADD PRIMARY KEY (`id`),
  ADD KEY `orderBy` (`orderBy`),
  ADD KEY `sectionIds` (`sectionIds`(250)),
  ADD KEY `parentId` (`parentId`);

--
-- Индексы таблицы `ls_product_feature_value`
--
ALTER TABLE `ls_product_feature_value`
  ADD PRIMARY KEY (`productId`,`featureId`),
  ADD KEY `value` (`value`(250)),
  ADD KEY `product_id` (`productId`),
  ADD KEY `feature_id` (`featureId`);

--
-- Индексы таблицы `ls_product_images`
--
ALTER TABLE `ls_product_images`
  ADD PRIMARY KEY (`imageId`),
  ADD KEY `sortOrder` (`orderBy`),
  ADD KEY `fileId` (`fileId`),
  ADD KEY `brandId` (`productId`),
  ADD KEY `productId` (`productId`) USING BTREE;

--
-- Индексы таблицы `ls_product_option`
--
ALTER TABLE `ls_product_option`
  ADD PRIMARY KEY (`product_option_id`),
  ADD KEY `product_id` (`product_id`);

--
-- Индексы таблицы `ls_product_option_value`
--
ALTER TABLE `ls_product_option_value`
  ADD PRIMARY KEY (`product_option_value_id`),
  ADD KEY `product_id` (`product_id`);

--
-- Индексы таблицы `ls_product_related`
--
ALTER TABLE `ls_product_related`
  ADD PRIMARY KEY (`relatedId`,`productId`) USING BTREE,
  ADD KEY `relatedId` (`relatedId`) USING BTREE,
  ADD KEY `productId` (`productId`) USING BTREE;

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

--
-- Индексы таблицы `ls_sections`
--
ALTER TABLE `ls_sections`
  ADD PRIMARY KEY (`sectionId`),
  ADD KEY `sortOrder` (`sortOrder`),
  ADD KEY `parentId` (`parentId`),
  ADD KEY `fileName` (`fileName`(250)),
  ADD KEY `status` (`status`),
  ADD KEY `typeContent` (`typeContent`);
ALTER TABLE `ls_sections` ADD FULLTEXT KEY `name` (`name`);
ALTER TABLE `ls_sections` ADD FULLTEXT KEY `fulltextIndex` (`name`,`content`);

--
-- Индексы таблицы `ls_section_images`
--
ALTER TABLE `ls_section_images`
  ADD PRIMARY KEY (`imageId`),
  ADD KEY `sectionId` (`sectionId`),
  ADD KEY `fileId` (`fileId`),
  ADD KEY `orderBy` (`orderBy`);

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

--
-- Индексы таблицы `ls_shop_cart`
--
ALTER TABLE `ls_shop_cart`
  ADD PRIMARY KEY (`cartId`) USING BTREE,
  ADD KEY `userId` (`userId`),
  ADD KEY `productId` (`productId`);

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

--
-- Индексы таблицы `ls_shop_orders`
--
ALTER TABLE `ls_shop_orders`
  ADD PRIMARY KEY (`order_id`) USING BTREE,
  ADD KEY `userId` (`userId`);

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

--
-- Индексы таблицы `ls_shop_order_product`
--
ALTER TABLE `ls_shop_order_product`
  ADD PRIMARY KEY (`order_product_id`),
  ADD KEY `order_id` (`order_id`);

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

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

--
-- Индексы таблицы `ls_shop_order_total`
--
ALTER TABLE `ls_shop_order_total`
  ADD PRIMARY KEY (`order_total_id`),
  ADD KEY `order_id` (`order_id`);

--
-- Индексы таблицы `ls_shop_payments`
--
ALTER TABLE `ls_shop_payments`
  ADD PRIMARY KEY (`paymentId`),
  ADD KEY `status` (`status`),
  ADD KEY `addedBy` (`addedBy`);
ALTER TABLE `ls_shop_payments` ADD FULLTEXT KEY `fulltextIndex` (`name`);

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

--
-- Индексы таблицы `ls_socials`
--
ALTER TABLE `ls_socials`
  ADD PRIMARY KEY (`socialId`),
  ADD KEY `fileName` (`fileName`);

--
-- Индексы таблицы `ls_stats_ad_clicks`
--
ALTER TABLE `ls_stats_ad_clicks`
  ADD KEY `visitId` (`visitId`),
  ADD KEY `srcVisitId` (`srcVisitId`),
  ADD KEY `destination` (`destination`(250));

--
-- Индексы таблицы `ls_stats_article_visits`
--
ALTER TABLE `ls_stats_article_visits`
  ADD PRIMARY KEY (`visitId`),
  ADD KEY `articleId` (`articleId`),
  ADD KEY `visitId` (`visitId`);

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

--
-- Индексы таблицы `ls_stats_error_visits`
--
ALTER TABLE `ls_stats_error_visits`
  ADD KEY `visitId` (`visitId`),
  ADD KEY `errorCode` (`errorCode`),
  ADD KEY `requestUri` (`requestUri`(250));

--
-- Индексы таблицы `ls_stats_product_visits`
--
ALTER TABLE `ls_stats_product_visits`
  ADD PRIMARY KEY (`visitId`),
  ADD KEY `visitId` (`visitId`),
  ADD KEY `productId` (`productId`) USING BTREE;

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

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

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

--
-- Индексы таблицы `ls_stats_user_agents`
--
ALTER TABLE `ls_stats_user_agents`
  ADD PRIMARY KEY (`userAgentId`),
  ADD UNIQUE KEY `userAgent` (`userAgent`),
  ADD KEY `isBot` (`isBot`);

--
-- Индексы таблицы `ls_stats_visitors`
--
ALTER TABLE `ls_stats_visitors`
  ADD PRIMARY KEY (`visitorId`),
  ADD KEY `firstVisitOn` (`firstVisitOn`),
  ADD KEY `userAgentId` (`userAgentId`),
  ADD KEY `visitorIp` (`visitorIp`(250)),
  ADD KEY `refid` (`refid`);

--
-- Индексы таблицы `ls_stats_visits`
--
ALTER TABLE `ls_stats_visits`
  ADD PRIMARY KEY (`visitId`),
  ADD KEY `visitorId` (`visitorId`),
  ADD KEY `isFirst` (`isFirst`),
  ADD KEY `visitDate` (`visitDate`),
  ADD KEY `typeId` (`typeId`);

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

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

--
-- Индексы таблицы `ls_type_content`
--
ALTER TABLE `ls_type_content`
  ADD PRIMARY KEY (`typeId`),
  ADD KEY `status` (`status`);
ALTER TABLE `ls_type_content` ADD FULLTEXT KEY `fulltextIndex` (`name`,`content`);

--
-- Индексы таблицы `ls_type_content_fields`
--
ALTER TABLE `ls_type_content_fields`
  ADD PRIMARY KEY (`fieldId`),
  ADD KEY `status` (`status`),
  ADD KEY `typeId` (`typeId`);

--
-- Индексы таблицы `ls_type_content_field_data`
--
ALTER TABLE `ls_type_content_field_data`
  ADD PRIMARY KEY (`articleId`,`fileName`) USING BTREE,
  ADD KEY `fieldName` (`fileName`),
  ADD KEY `articleId` (`articleId`);

--
-- Индексы таблицы `ls_type_content_field_property`
--
ALTER TABLE `ls_type_content_field_property`
  ADD PRIMARY KEY (`propertyId`) USING BTREE,
  ADD KEY `fieldId` (`fieldId`);

--
-- Индексы таблицы `ls_users`
--
ALTER TABLE `ls_users`
  ADD PRIMARY KEY (`userId`) USING BTREE,
  ADD UNIQUE KEY `loginName` (`loginName`) USING BTREE,
  ADD KEY `accessLevel` (`accessLevel`),
  ADD KEY `userType` (`userType`),
  ADD KEY `email` (`email`) USING BTREE;

--
-- Индексы таблицы `ls_users_banned_ips`
--
ALTER TABLE `ls_users_banned_ips`
  ADD PRIMARY KEY (`visitorIp`),
  ADD KEY `expiresOn` (`expiresOn`);

--
-- Индексы таблицы `ls_users_confirmations`
--
ALTER TABLE `ls_users_confirmations`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `selector` (`selector`),
  ADD KEY `email_expires` (`email`,`expires`),
  ADD KEY `user_id` (`user_id`);

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

--
-- Индексы таблицы `ls_users_resets`
--
ALTER TABLE `ls_users_resets`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `selector` (`selector`),
  ADD KEY `user_expires` (`user`,`expires`);

--
-- Индексы таблицы `ls_users_throttling`
--
ALTER TABLE `ls_users_throttling`
  ADD PRIMARY KEY (`bucket`),
  ADD KEY `expires_at` (`expires_at`);

--
-- Индексы таблицы `ls_user_group`
--
ALTER TABLE `ls_user_group`
  ADD PRIMARY KEY (`groupId`) USING BTREE,
  ADD KEY `status` (`status`);

--
-- Индексы таблицы `ls_user_group_privileges`
--
ALTER TABLE `ls_user_group_privileges`
  ADD PRIMARY KEY (`groupId`,`privilege`) USING BTREE;

--
-- Индексы таблицы `ls_user_history`
--
ALTER TABLE `ls_user_history`
  ADD KEY `userId` (`userId`),
  ADD KEY `eventOn` (`eventOn`),
  ADD KEY `visitorIp` (`visitorIp`),
  ADD KEY `status` (`status`),
  ADD KEY `action` (`action`);

--
-- Индексы таблицы `ls_user_images`
--
ALTER TABLE `ls_user_images`
  ADD PRIMARY KEY (`imageId`),
  ADD KEY `sectionId` (`userId`),
  ADD KEY `fileId` (`fileId`),
  ADD KEY `orderBy` (`orderBy`);

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

--
-- AUTO_INCREMENT для таблицы `ls_articles`
--
ALTER TABLE `ls_articles`
  MODIFY `articleId` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT для таблицы `ls_article_images`
--
ALTER TABLE `ls_article_images`
  MODIFY `imageId` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT для таблицы `ls_article_visits`
--
ALTER TABLE `ls_article_visits`
  MODIFY `visitId` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT для таблицы `ls_banners`
--
ALTER TABLE `ls_banners`
  MODIFY `bannerId` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID банера';

--
-- AUTO_INCREMENT для таблицы `ls_banners_group`
--
ALTER TABLE `ls_banners_group`
  MODIFY `groupId` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT для таблицы `ls_banner_images`
--
ALTER TABLE `ls_banner_images`
  MODIFY `imageId` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT для таблицы `ls_blocks`
--
ALTER TABLE `ls_blocks`
  MODIFY `blockId` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID блока';

--
-- AUTO_INCREMENT для таблицы `ls_block_images`
--
ALTER TABLE `ls_block_images`
  MODIFY `imageId` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT для таблицы `ls_clients`
--
ALTER TABLE `ls_clients`
  MODIFY `articleId` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT для таблицы `ls_client_images`
--
ALTER TABLE `ls_client_images`
  MODIFY `imageId` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT для таблицы `ls_colors`
--
ALTER TABLE `ls_colors`
  MODIFY `colorId` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT для таблицы `ls_comments`
--
ALTER TABLE `ls_comments`
  MODIFY `commentId` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT для таблицы `ls_faq`
--
ALTER TABLE `ls_faq`
  MODIFY `faqId` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID';

--
-- AUTO_INCREMENT для таблицы `ls_feedback`
--
ALTER TABLE `ls_feedback`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT для таблицы `ls_files`
--
ALTER TABLE `ls_files`
  MODIFY `fileId` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT для таблицы `ls_geo_countries`
--
ALTER TABLE `ls_geo_countries`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT для таблицы `ls_languages`
--
ALTER TABLE `ls_languages`
  MODIFY `languageId` smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=135;

--
-- AUTO_INCREMENT для таблицы `ls_log`
--
ALTER TABLE `ls_log`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT для таблицы `ls_notice`
--
ALTER TABLE `ls_notice`
  MODIFY `id` mediumint(8) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT для таблицы `ls_options`
--
ALTER TABLE `ls_options`
  MODIFY `optionId` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID опции';

--
-- AUTO_INCREMENT для таблицы `ls_products`
--
ALTER TABLE `ls_products`
  MODIFY `productId` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT для таблицы `ls_product_blocks`
--
ALTER TABLE `ls_product_blocks`
  MODIFY `blockId` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT для таблицы `ls_product_block_images`
--
ALTER TABLE `ls_product_block_images`
  MODIFY `imageId` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT для таблицы `ls_product_colors`
--
ALTER TABLE `ls_product_colors`
  MODIFY `imageId` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT для таблицы `ls_product_comments`
--
ALTER TABLE `ls_product_comments`
  MODIFY `commentId` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT для таблицы `ls_product_features`
--
ALTER TABLE `ls_product_features`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT для таблицы `ls_product_images`
--
ALTER TABLE `ls_product_images`
  MODIFY `imageId` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT для таблицы `ls_product_option`
--
ALTER TABLE `ls_product_option`
  MODIFY `product_option_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT для таблицы `ls_product_option_value`
--
ALTER TABLE `ls_product_option_value`
  MODIFY `product_option_value_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT для таблицы `ls_product_stock_status`
--
ALTER TABLE `ls_product_stock_status`
  MODIFY `stock_status_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT для таблицы `ls_sections`
--
ALTER TABLE `ls_sections`
  MODIFY `sectionId` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT для таблицы `ls_section_images`
--
ALTER TABLE `ls_section_images`
  MODIFY `imageId` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT для таблицы `ls_shop_cart`
--
ALTER TABLE `ls_shop_cart`
  MODIFY `cartId` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT для таблицы `ls_shop_currency`
--
ALTER TABLE `ls_shop_currency`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT для таблицы `ls_shop_orders`
--
ALTER TABLE `ls_shop_orders`
  MODIFY `order_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID заказа';

--
-- AUTO_INCREMENT для таблицы `ls_shop_order_option`
--
ALTER TABLE `ls_shop_order_option`
  MODIFY `order_option_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT для таблицы `ls_shop_order_product`
--
ALTER TABLE `ls_shop_order_product`
  MODIFY `order_product_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT для таблицы `ls_shop_order_shipment`
--
ALTER TABLE `ls_shop_order_shipment`
  MODIFY `order_shipment_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT для таблицы `ls_shop_order_status`
--
ALTER TABLE `ls_shop_order_status`
  MODIFY `order_status_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT для таблицы `ls_shop_order_total`
--
ALTER TABLE `ls_shop_order_total`
  MODIFY `order_total_id` int(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT для таблицы `ls_shop_payments`
--
ALTER TABLE `ls_shop_payments`
  MODIFY `paymentId` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT для таблицы `ls_shop_transactions`
--
ALTER TABLE `ls_shop_transactions`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT для таблицы `ls_socials`
--
ALTER TABLE `ls_socials`
  MODIFY `socialId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;

--
-- AUTO_INCREMENT для таблицы `ls_stats_user_agents`
--
ALTER TABLE `ls_stats_user_agents`
  MODIFY `userAgentId` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT для таблицы `ls_stats_visitors`
--
ALTER TABLE `ls_stats_visitors`
  MODIFY `visitorId` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT для таблицы `ls_stats_visits`
--
ALTER TABLE `ls_stats_visits`
  MODIFY `visitId` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT для таблицы `ls_subscribe`
--
ALTER TABLE `ls_subscribe`
  MODIFY `userId` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT для таблицы `ls_type_content`
--
ALTER TABLE `ls_type_content`
  MODIFY `typeId` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT для таблицы `ls_type_content_fields`
--
ALTER TABLE `ls_type_content_fields`
  MODIFY `fieldId` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT для таблицы `ls_type_content_field_property`
--
ALTER TABLE `ls_type_content_field_property`
  MODIFY `propertyId` int(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT для таблицы `ls_users`
--
ALTER TABLE `ls_users`
  MODIFY `userId` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=179;

--
-- AUTO_INCREMENT для таблицы `ls_users_confirmations`
--
ALTER TABLE `ls_users_confirmations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

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

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

--
-- AUTO_INCREMENT для таблицы `ls_user_group`
--
ALTER TABLE `ls_user_group`
  MODIFY `groupId` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- AUTO_INCREMENT для таблицы `ls_user_images`
--
ALTER TABLE `ls_user_images`
  MODIFY `imageId` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=64;

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