TPS_web_october/tps_from_serv.sql

-- MySQL dump 10.13  Distrib 8.0.36, for Linux (x86_64)
--
-- Host: localhost    Database: tps_new
-- ------------------------------------------------------
-- Server version	8.0.36-0ubuntu0.22.04.1

/*!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 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `akami_shift_services`
--

DROP TABLE IF EXISTS `akami_shift_services`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `akami_shift_services` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `icon` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `header` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `txt` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `akami_shift_services`
--

LOCK TABLES `akami_shift_services` WRITE;
/*!40000 ALTER TABLE `akami_shift_services` DISABLE KEYS */;
INSERT INTO `akami_shift_services` VALUES (1,'/services/bus.svg','Road Freight','Logistika pudagynda işleşýän kom paniýalarymyza berýän hyzmatlary myz we goldawymyz bilen gün-gün den tejribesini artdyrýan toparymyz bilen işleşiň.'),(2,'/services/ship.svg','Ocean Freight','Logistika pudagynda işleşýän kom paniýalarymyza berýän hyzmatlary myz we goldawymyz bilen gün-gün den tejribesini artdyrýan toparymyz bilen işleşiň.'),(3,'/services/train.svg','Rail Freight','Logistika pudagynda işleşýän kom paniýalarymyza berýän hyzmatlary myz we goldawymyz bilen gün-gün den tejribesini artdyrýan toparymyz bilen işleşiň.'),(4,'/services/plane.svg','Plane Freight','Logistika pudagynda işleşýän kom paniýalarymyza berýän hyzmatlary myz we goldawymyz bilen gün-gün den tejribesini artdyrýan toparymyz bilen işleşiň.');
/*!40000 ALTER TABLE `akami_shift_services` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `akami_shift_slider`
--

DROP TABLE IF EXISTS `akami_shift_slider`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `akami_shift_slider` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `img` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `txt` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `akami_shift_slider`
--

LOCK TABLES `akami_shift_slider` WRITE;
/*!40000 ALTER TABLE `akami_shift_slider` DISABLE KEYS */;
INSERT INTO `akami_shift_slider` VALUES (1,'/Slider/hero_bg.png','FAST, Certified <br> Flexible Solutions.'),(2,'/Slider/hero_bg.png','FAST, Certified <br> Flexible Solutions.'),(3,'/Slider/hero_bg.png','FAST, Certified <br> Flexible Solutions.'),(4,'/Slider/hero_bg.png','FAST, Certified <br> Flexible Solutions.');
/*!40000 ALTER TABLE `akami_shift_slider` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `akami_tps_about`
--

DROP TABLE IF EXISTS `akami_tps_about`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `akami_tps_about` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `header` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `txt` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `btn_txt` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `video_poster` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `video` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `akami_tps_about`
--

LOCK TABLES `akami_tps_about` WRITE;
/*!40000 ALTER TABLE `akami_tps_about` DISABLE KEYS */;
INSERT INTO `akami_tps_about` VALUES (1,'О компании','Рекламное агентство «TPS» - многопрофильная компания в сфере рекламы, Digital-услуг, продвижения, организации мероприятий, полиграфии, производства, дизайна, маркетинговых исследований рынка и пр. Преимущества агентства – обширный опыт на рынке и постоянное стремление к инновациям и успеху. Мы предлагаем только лучшие маркетинговые решения и рекламную продукцию.\r\n\r\nНаша миссия – влияние на рынок и создание эталона рекламно маркетингового\r\nобслуживания в Туркменистане. Предоставить каждому клиенту возможность заявить о себе.','Узнать больше','/video/video-img.png','/video/video.mp4');
/*!40000 ALTER TABLE `akami_tps_about` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `akami_tps_categories`
--

DROP TABLE IF EXISTS `akami_tps_categories`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `akami_tps_categories` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `note` text COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `akami_tps_categories`
--

LOCK TABLES `akami_tps_categories` WRITE;
/*!40000 ALTER TABLE `akami_tps_categories` DISABLE KEYS */;
INSERT INTO `akami_tps_categories` VALUES (1,'2023-08-30 06:50:18','2023-08-30 07:24:36',NULL,'Организация мероприятий',''),(2,'2023-08-30 06:50:23','2023-08-30 07:24:23',NULL,'Выставочные стенды','');
/*!40000 ALTER TABLE `akami_tps_categories` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `akami_tps_clients`
--

DROP TABLE IF EXISTS `akami_tps_clients`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `akami_tps_clients` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `img` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `note` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=90 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `akami_tps_clients`
--

LOCK TABLES `akami_tps_clients` WRITE;
/*!40000 ALTER TABLE `akami_tps_clients` DISABLE KEYS */;
INSERT INTO `akami_tps_clients` VALUES (38,'/clients/Embassies/european_union.png',''),(44,'/clients/International orgs/UNDP.png',''),(50,'/clients/International orgs/UNICEF.png',''),(51,'/clients/brands/Areti.png',''),(52,'/clients/brands/Belavia.png',''),(54,'/clients/brands/Dahua.png',''),(55,'/clients/brands/Bridgestone.png',''),(56,'/clients/brands/Grohe.png',''),(57,'/clients/brands/Burotime.png',''),(60,'/clients/brands/Enza Home.png',''),(61,'/clients/brands/Nokia.png',''),(62,'/clients/brands/Hitachi.png',''),(63,'/clients/brands/Grohe.png',''),(66,'/clients/brands/Villeroy  Boch.png',''),(67,'/clients/brands/UNV.png',''),(68,'/clients/brands/Vinci.png',''),(70,'/clients/brands/Unilever.png',''),(71,'/clients/brands/Setana Sports.png',''),(72,'/clients/brands/Schneider.png',''),(73,'/clients/brands/Roche.png',''),(74,'/clients/brands/Schlumberger.png',''),(75,'/clients/brands/totalenergies_logo_logotype.png',''),(76,'/clients/brands/Socar.png',''),(77,'/clients/brands/Shell.png',''),(78,'/clients/brands/wp4045305.png',''),(79,'/clients/brands/Jacobs.png',''),(80,'/clients/brands/Huawei.png',''),(81,'/clients/brands/PG.png',''),(82,'/clients/brands/LG international.png',''),(83,'/clients/brands/Nike.png',''),(84,'/clients/brands/Coca Cola-1.png',''),(85,'/clients/brands/Samsonite.png',''),(86,'/clients/brands/Mobil 1.png',''),(87,'/clients/brands/Toyota.png',''),(88,'/clients/brands/samsung.png',''),(89,'/clients/int org/b4034753b2963b2d6f843bcea1c3ecfc.png','');
/*!40000 ALTER TABLE `akami_tps_clients` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `akami_tps_portfolio`
--

DROP TABLE IF EXISTS `akami_tps_portfolio`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `akami_tps_portfolio` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `header` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `txt` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `img` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `category_id` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `akami_tps_portfolio`
--

LOCK TABLES `akami_tps_portfolio` WRITE;
/*!40000 ALTER TABLE `akami_tps_portfolio` DISABLE KEYS */;
INSERT INTO `akami_tps_portfolio` VALUES (16,'Организация мероприятий под ключ','','[{\"content\":\"\\/portfolio\\/eu\\/45128755611_7488afdbab_z.jpg\",\"name\":\"The 55th session of the ABU\"},{\"content\":\"\\/portfolio\\/eu\\/30154149807_f7b45dbf16_z.jpg\",\"name\":\"The 55th session of the ABU\"},{\"content\":\"\\/portfolio\\/eu\\/20211219174418_PASA9095.jpg\",\"name\":\"\\u0415\\u0436\\u0435\\u0433\\u043e\\u0434\\u043d\\u0430\\u044f \\u0438\\u043d\\u0442\\u0435\\u043b\\u043b\\u0435\\u043a\\u0442\\u0443\\u0430\\u043b\\u044c\\u043d\\u0430\\u044f \\u0438\\u0433\\u0440\\u0430 \\u0415\\u0432\\u0440\\u043e\\u043f\\u0435\\u0439\\u0441\\u043a\\u043e\\u0433\\u043e \\u0421\\u043e\\u044e\\u0437\\u0430\"},{\"content\":\"\\/portfolio\\/eu\\/20211219174756_PASA9122.jpg\",\"name\":\"\\u0415\\u0436\\u0435\\u0433\\u043e\\u0434\\u043d\\u0430\\u044f \\u0438\\u043d\\u0442\\u0435\\u043b\\u043b\\u0435\\u043a\\u0442\\u0443\\u0430\\u043b\\u044c\\u043d\\u0430\\u044f \\u0438\\u0433\\u0440\\u0430 \\u0415\\u0432\\u0440\\u043e\\u043f\\u0435\\u0439\\u0441\\u043a\\u043e\\u0433\\u043e \\u0421\\u043e\\u044e\\u0437\\u0430\"},{\"content\":\"\\/portfolio\\/eu\\/picturecompress-211zon.jpg\",\"name\":\"\\u0415\\u0436\\u0435\\u0433\\u043e\\u0434\\u043d\\u0430\\u044f \\u0438\\u043d\\u0442\\u0435\\u043b\\u043b\\u0435\\u043a\\u0442\\u0443\\u0430\\u043b\\u044c\\u043d\\u0430\\u044f \\u0438\\u0433\\u0440\\u0430 \\u0415\\u0432\\u0440\\u043e\\u043f\\u0435\\u0439\\u0441\\u043a\\u043e\\u0433\\u043e \\u0421\\u043e\\u044e\\u0437\\u0430\"},{\"content\":\"\\/portfolio\\/eu\\/picturecompress-111zon.jpg\",\"name\":\"\\u0415\\u0436\\u0435\\u0433\\u043e\\u0434\\u043d\\u0430\\u044f \\u0438\\u043d\\u0442\\u0435\\u043b\\u043b\\u0435\\u043a\\u0442\\u0443\\u0430\\u043b\\u044c\\u043d\\u0430\\u044f \\u0438\\u0433\\u0440\\u0430 \\u0415\\u0432\\u0440\\u043e\\u043f\\u0435\\u0439\\u0441\\u043a\\u043e\\u0433\\u043e \\u0421\\u043e\\u044e\\u0437\\u0430\"},{\"content\":\"\\/portfolio\\/eu\\/picturecompress-311zon.jpg\",\"name\":\"\\u0415\\u0436\\u0435\\u0433\\u043e\\u0434\\u043d\\u0430\\u044f \\u0438\\u043d\\u0442\\u0435\\u043b\\u043b\\u0435\\u043a\\u0442\\u0443\\u0430\\u043b\\u044c\\u043d\\u0430\\u044f \\u0438\\u0433\\u0440\\u0430 \\u0415\\u0432\\u0440\\u043e\\u043f\\u0435\\u0439\\u0441\\u043a\\u043e\\u0433\\u043e \\u0421\\u043e\\u044e\\u0437\\u0430\"},{\"content\":\"\\/portfolio\\/eu\\/img772011zon-1.jpg\",\"name\":\"\\u0414\\u0435\\u0442\\u0441\\u043a\\u043e\\u0435 \\u0441\\u043f\\u043e\\u0440\\u0442\\u0438\\u0432\\u043d\\u043e-\\u0440\\u0430\\u0437\\u0432\\u043b\\u0435\\u043a\\u0430\\u0442\\u0435\\u043b\\u044c\\u043d\\u043e\\u0435 \\u043c\\u0435\\u0440\\u043e\\u043f\\u0440\\u0438\\u044f\\u0442\\u0438\\u0435 \\u0432 \\u0427\\u0443\\u043b\\u0438\\/\\u0413\\u0451\\u043a\\u0434\\u0435\\u0440\\u0435\"},{\"content\":\"\\/portfolio\\/eu\\/cropped-images\\/IMG_7923_11zon-1138-26-5102-3344-1704431192.jpg\",\"name\":\"\\u0414\\u0435\\u0442\\u0441\\u043a\\u043e\\u0435 \\u0441\\u043f\\u043e\\u0440\\u0442\\u0438\\u0432\\u043d\\u043e-\\u0440\\u0430\\u0437\\u0432\\u043b\\u0435\\u043a\\u0430\\u0442\\u0435\\u043b\\u044c\\u043d\\u043e\\u0435 \\u043c\\u0435\\u0440\\u043e\\u043f\\u0440\\u0438\\u044f\\u0442\\u0438\\u0435 \\u0432 \\u0427\\u0443\\u043b\\u0438\\/\\u0413\\u0451\\u043a\\u0434\\u0435\\u0440\\u0435\"},{\"content\":\"\\/portfolio\\/eu\\/IMG_7854_11zon.jpg\",\"name\":\"\\u0414\\u0435\\u0442\\u0441\\u043a\\u043e\\u0435 \\u0441\\u043f\\u043e\\u0440\\u0442\\u0438\\u0432\\u043d\\u043e-\\u0440\\u0430\\u0437\\u0432\\u043b\\u0435\\u043a\\u0430\\u0442\\u0435\\u043b\\u044c\\u043d\\u043e\\u0435 \\u043c\\u0435\\u0440\\u043e\\u043f\\u0440\\u0438\\u044f\\u0442\\u0438\\u0435 \\u0432 \\u0427\\u0443\\u043b\\u0438\\/\\u0413\\u0451\\u043a\\u0434\\u0435\\u0440\\u0435\"},{\"content\":\"\\/portfolio\\/eu\\/IMG_8056_11zon.jpg\",\"name\":\"\\u0414\\u0435\\u0442\\u0441\\u043a\\u043e\\u0435 \\u0441\\u043f\\u043e\\u0440\\u0442\\u0438\\u0432\\u043d\\u043e-\\u0440\\u0430\\u0437\\u0432\\u043b\\u0435\\u043a\\u0430\\u0442\\u0435\\u043b\\u044c\\u043d\\u043e\\u0435 \\u043c\\u0435\\u0440\\u043e\\u043
/*!40000 ALTER TABLE `akami_tps_portfolio` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `akami_tps_service`
--

DROP TABLE IF EXISTS `akami_tps_service`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `akami_tps_service` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `header` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `txt` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `img` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `akami_tps_service`
--

LOCK TABLES `akami_tps_service` WRITE;
/*!40000 ALTER TABLE `akami_tps_service` DISABLE KEYS */;
INSERT INTO `akami_tps_service` VALUES (1,'Наружная реклама','Дизайн, размещение, монтаж конструкций, круглосуточное обслуживание. Работаем по всей стране.','/service/f12424553a7b506210cc0329380a62db.jpg'),(2,'Реклама в помещениях','Размещение в крупнейших ТЦ столицы и аэропорту с широким выбором рекламных носителей.','/service/4арар.jpg'),(3,'Застройка выставочных стендов','Проектирование, производство и монтаж уникальных выставочных стендов под любой бюджет «под ключ».','/service/3.jpg'),(4,'Организация мероприятий','Мероприятия «под ключ»: составление программы, бронирование отеля, трансфер и питание.','/service/org mer.jpg'),(5,'Реклама в СМИ','Реклама на государственных телеканалах, радио, в печатных изданиях и Интернет-СМИ.','/service/smi.jpg'),(6,'Производство','Оптимальное сочетание технологий, материалов и дизайна для компаний с любым бюджетом.','/service/bez-nazvaniya-1.jpg');
/*!40000 ALTER TABLE `akami_tps_service` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `akami_tps_service_page`
--

DROP TABLE IF EXISTS `akami_tps_service_page`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `akami_tps_service_page` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `header` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `img` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `txt` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `page` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `akami_tps_service_page`
--

LOCK TABLES `akami_tps_service_page` WRITE;
/*!40000 ALTER TABLE `akami_tps_service_page` DISABLE KEYS */;
INSERT INTO `akami_tps_service_page` VALUES (1,'Тривижены','/service_page/ на азс.png','[{\"content\":\"\\u0420\\u0430\\u0437\\u043c\\u0435\\u0449\\u0435\\u043d\\u0438\\u0435 \\u0440\\u0435\\u043a\\u043b\\u0430\\u043c\\u044b \\u043d\\u0435\\u0441\\u043a\\u043e\\u043b\\u044c\\u043a\\u0438\\u0445 \\u0442\\u043e\\u0432\\u0430\\u0440\\u043e\\u0432 \\u043e\\u0434\\u043d\\u043e\\u0432\\u0440\\u0435\\u043c\\u0435\\u043d\\u043d\\u043e.\"},{\"content\":\"\\u0412\\u043d\\u0435\\u0437\\u0430\\u043f\\u043d\\u0430\\u044f \\u0441\\u043c\\u0435\\u043d\\u0430 \\u0438\\u0437\\u043e\\u0431\\u0440\\u0430\\u0436\\u0435\\u043d\\u0438\\u044f \\u0430\\u0432\\u0442\\u043e\\u043c\\u0430\\u0442\\u0438\\u0447\\u0435\\u0441\\u043a\\u0438 \\u043f\\u0440\\u0438\\u0432\\u043b\\u0435\\u043a\\u0430\\u0435\\u0442 \\u0432\\u043d\\u0438\\u043c\\u0430\\u043d\\u0438\\u0435 \\u0430\\u0443\\u0434\\u0438\\u0442\\u043e\\u0440\\u0438\\u0438.\"},{\"content\":\"1\\/3 \\u0441\\u0443\\u0442\\u043e\\u0447\\u043d\\u043e\\u0433\\u043e \\u0432\\u0440\\u0435\\u043c\\u0435\\u043d\\u0438 \\u043f\\u0440\\u0438\\u0445\\u043e\\u0434\\u0438\\u0442\\u0441\\u044f \\u043d\\u0430 \\u043a\\u0430\\u0436\\u0434\\u043e\\u0433\\u043e \\u043a\\u043b\\u0438\\u0435\\u043d\\u0442\\u0430.\"}]','2'),(2,'LED-экраны','/service_page/advert-2.png','[{\"content\":\"\\u041a\\u0430\\u0447\\u0435\\u0441\\u0442\\u0432\\u0435\\u043d\\u043d\\u043e\\u0435 \\u0438\\u0437\\u043e\\u0431\\u0440\\u0430\\u0436\\u0435\\u043d\\u0438\\u0435 \\u0432 \\u043b\\u044e\\u0431\\u0443\\u044e \\u043f\\u043e\\u0433\\u043e\\u0434\\u0443 \\u0438 \\u0432\\u0440\\u0435\\u043c\\u044f \\u0441\\u0443\\u0442\\u043e\\u043a.\"},{\"content\":\"\\u041f\\u0440\\u0438\\u0432\\u043b\\u0435\\u043a\\u0430\\u044e\\u0442 \\u043d\\u0430 40% \\u0431\\u043e\\u043b\\u044c\\u0448\\u0435 \\u043a\\u043b\\u0438\\u0435\\u043d\\u0442\\u043e\\u0432, \\u043f\\u043e\\u0432\\u044b\\u0448\\u0430\\u044e\\u0442 \\u0441\\u0442\\u0430\\u0442\\u0443\\u0441 \\u0431\\u0440\\u0435\\u043d\\u0434\\u0430. \"},{\"content\":\"\\u041f\\u0440\\u0435\\u0438\\u043c\\u0443\\u0449\\u0435\\u0441\\u0442\\u0432\\u0430: \\u0432\\u044b\\u0441\\u043e\\u043a\\u0430\\u044f \\u0432\\u0438\\u0434\\u0438\\u043c\\u043e\\u0441\\u0442\\u044c, \\u043b\\u0435\\u0433\\u043a\\u043e\\u0435 \\u0432\\u043e\\u0441\\u043f\\u0440\\u0438\\u044f\\u0442\\u0438\\u0435, \\u0431\\u044b\\u0441\\u0442\\u0440\\u043e\\u0435 \\u043e\\u0431\\u043d\\u043e\\u0432\\u043b\\u0435\\u043d\\u0438\\u0435 \\u0440\\u0435\\u043a\\u043b\\u0430\\u043c\\u043d\\u044b\\u0445 \\u043c\\u0430\\u0442\\u0435\\u0440\\u0438\\u0430\\u043b\\u043e\\u0432.\"}]','2'),(3,'Реклама на АЗС','/1.jpg','[{\"content\":\"\\u0420\\u0430\\u0437\\u043c\\u0435\\u0449\\u0435\\u043d\\u0438\\u0435 \\u043d\\u0430 6 \\u043a\\u0440\\u0443\\u043f\\u043d\\u0435\\u0439\\u0448\\u0438\\u0445 \\u0430\\u0432\\u0442\\u043e\\u0437\\u0430\\u043f\\u0440\\u0430\\u0432\\u043e\\u0447\\u043d\\u044b\\u0445 \\u0441\\u0442\\u0430\\u043d\\u0446\\u0438\\u044f\\u0445 \\u0441\\u0442\\u043e\\u043b\\u0438\\u0446\\u044b \\u0438 11 \\u0440\\u0435\\u0433\\u0438\\u043e\\u043d\\u0430\\u043b\\u044c\\u043d\\u044b\\u0445 \\u0437\\u0430\\u043f\\u0440\\u0430\\u0432\\u043e\\u043a \\u0432\\u043e \\u0432\\u0441\\u0435\\u0445 \\u0432\\u0435\\u043b\\u0430\\u044f\\u0442\\u0430\\u0445. \"},{\"content\":\"\\u0411\\u043e\\u043b\\u0435\\u0435 15.000 \\u043f\\u043e\\u0441\\u0435\\u0442\\u0438\\u0442\\u0435\\u043b\\u0435\\u0439 \\u0435\\u0436\\u0435\\u0434\\u043d\\u0435\\u0432\\u043d\\u043e.\"},{\"content\":\"\\u0428\\u0438\\u0440\\u043e\\u043a\\u0430\\u044f \\u0430\\u0443\\u0434\\u0438\\u0442\\u043e\\u0440\\u0438\\u044f, \\u0432 \\u0442\\u043e\\u043c \\u0447\\u0438\\u0441\\u043b\\u0435 \\u0430\\u0432\\u0442\\u043e\\u043c\\u043e\\u0431\\u0438\\u043b\\u0438\\u0441\\u0442\\u044b \\u0432\\u0441\\u0435\\u0445 \\u0432\\u043e\\u0437\\u0440\\u0430\\u0441\\u0442\\u043e\\u0432 \\u0438 \\u043a\\u0430\\u0442\\u0435\\u0433\\u043e\\u0440\\u0438\\u0439.\"}]','2'),(6,'ТРЦ «Беркарар»','/service_page/berkarar.png','[{\"content\":\"\\u0421\\u0430\\u043c\\u044b\\u0439 \\u043f
/*!40000 ALTER TABLE `akami_tps_service_page` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `akami_tps_slider`
--

DROP TABLE IF EXISTS `akami_tps_slider`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `akami_tps_slider` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `img` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `header` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `txt` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `btn_txt` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `akami_tps_slider`
--

LOCK TABLES `akami_tps_slider` WRITE;
/*!40000 ALTER TABLE `akami_tps_slider` DISABLE KEYS */;
INSERT INTO `akami_tps_slider` VALUES (1,'/slider/main_banner.png','Агентство полного цикла, аналогов которому нет в стране.','Многопрофильная компания в сфере рекламы, Digital-услуг, продвижения, организации мероприятий, полиграфии, производства, дизайна, маркетинговых исследований рынка и пр.','Заказать звонок','2022-08-31 07:11:28','2022-08-31 07:11:28'),(2,'/slider/main_banner.png','Агентство полного цикла, аналогов которому нет в стране.','Многопрофильная компания в сфере рекламы, Digital-услуг, продвижения, организации мероприятий, полиграфии, производства, дизайна, маркетинговых исследований рынка и пр.','Заказать звонок','2022-08-31 07:11:59','2022-08-31 07:11:59');
/*!40000 ALTER TABLE `akami_tps_slider` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `backend_access_log`
--

DROP TABLE IF EXISTS `backend_access_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `backend_access_log` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int unsigned NOT NULL,
  `ip_address` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `backend_access_log`
--

LOCK TABLES `backend_access_log` WRITE;
/*!40000 ALTER TABLE `backend_access_log` DISABLE KEYS */;
INSERT INTO `backend_access_log` VALUES (1,1,'127.0.0.1','2022-07-03 06:15:03','2022-07-03 06:15:03'),(2,1,'127.0.0.1','2022-07-03 06:16:37','2022-07-03 06:16:37'),(3,1,'127.0.0.1','2022-08-31 05:39:05','2022-08-31 05:39:05'),(4,1,'95.85.108.178','2022-09-12 23:47:59','2022-09-12 23:47:59'),(5,1,'95.85.108.178','2022-09-13 00:13:44','2022-09-13 00:13:44'),(6,1,'95.85.108.178','2022-09-13 00:21:42','2022-09-13 00:21:42'),(7,1,'93.171.223.181','2022-11-12 01:00:08','2022-11-12 01:00:08'),(8,1,'93.171.223.181','2022-11-12 01:15:37','2022-11-12 01:15:37'),(9,1,'93.171.223.181','2022-11-18 00:52:08','2022-11-18 00:52:08'),(10,1,'93.171.223.181','2022-12-30 00:49:00','2022-12-30 00:49:00'),(11,1,'93.171.223.181','2023-01-13 06:06:01','2023-01-13 06:06:01'),(12,1,'119.235.118.26','2023-08-30 07:21:25','2023-08-30 07:21:25'),(13,1,'119.235.118.26','2023-09-06 09:51:35','2023-09-06 09:51:35'),(14,1,'95.85.112.106','2023-09-11 06:51:21','2023-09-11 06:51:21'),(15,1,'119.235.120.190','2023-09-11 11:07:02','2023-09-11 11:07:02'),(16,1,'119.235.120.190','2023-09-13 05:42:20','2023-09-13 05:42:20'),(17,1,'119.235.118.26','2023-09-18 07:26:31','2023-09-18 07:26:31'),(18,1,'119.235.120.190','2024-01-04 09:18:30','2024-01-04 09:18:30'),(19,1,'119.235.118.26','2024-01-24 08:22:44','2024-01-24 08:22:44'),(20,1,'119.235.120.190','2024-01-24 09:23:38','2024-01-24 09:23:38'),(21,1,'119.235.118.26','2024-02-29 06:26:13','2024-02-29 06:26:13'),(22,1,'119.235.118.26','2024-02-29 06:28:31','2024-02-29 06:28:31');
/*!40000 ALTER TABLE `backend_access_log` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `backend_user_groups`
--

DROP TABLE IF EXISTS `backend_user_groups`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `backend_user_groups` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `code` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `is_new_user_default` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name_unique` (`name`),
  KEY `code_index` (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `backend_user_groups`
--

LOCK TABLES `backend_user_groups` WRITE;
/*!40000 ALTER TABLE `backend_user_groups` DISABLE KEYS */;
INSERT INTO `backend_user_groups` VALUES (1,'Owners','2022-07-03 06:14:02','2022-07-03 06:14:02','owners','Default group for website owners.',0);
/*!40000 ALTER TABLE `backend_user_groups` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `backend_user_preferences`
--

DROP TABLE IF EXISTS `backend_user_preferences`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `backend_user_preferences` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int unsigned NOT NULL,
  `namespace` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `group` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `item` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `user_item_index` (`user_id`,`namespace`,`group`,`item`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `backend_user_preferences`
--

LOCK TABLES `backend_user_preferences` WRITE;
/*!40000 ALTER TABLE `backend_user_preferences` DISABLE KEYS */;
/*!40000 ALTER TABLE `backend_user_preferences` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `backend_user_roles`
--

DROP TABLE IF EXISTS `backend_user_roles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `backend_user_roles` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `permissions` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `is_system` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `role_unique` (`name`),
  KEY `role_code_index` (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `backend_user_roles`
--

LOCK TABLES `backend_user_roles` WRITE;
/*!40000 ALTER TABLE `backend_user_roles` DISABLE KEYS */;
INSERT INTO `backend_user_roles` VALUES (1,'Publisher','publisher','Site editor with access to publishing tools.','',1,'2022-07-03 06:14:02','2022-07-03 06:14:02'),(2,'Developer','developer','Site administrator with access to developer tools.','',1,'2022-07-03 06:14:02','2022-07-03 06:14:02');
/*!40000 ALTER TABLE `backend_user_roles` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `backend_user_throttle`
--

DROP TABLE IF EXISTS `backend_user_throttle`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `backend_user_throttle` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int unsigned DEFAULT NULL,
  `ip_address` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `attempts` int NOT NULL DEFAULT '0',
  `last_attempt_at` timestamp NULL DEFAULT NULL,
  `is_suspended` tinyint(1) NOT NULL DEFAULT '0',
  `suspended_at` timestamp NULL DEFAULT NULL,
  `is_banned` tinyint(1) NOT NULL DEFAULT '0',
  `banned_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `backend_user_throttle_user_id_index` (`user_id`),
  KEY `backend_user_throttle_ip_address_index` (`ip_address`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `backend_user_throttle`
--

LOCK TABLES `backend_user_throttle` WRITE;
/*!40000 ALTER TABLE `backend_user_throttle` DISABLE KEYS */;
INSERT INTO `backend_user_throttle` VALUES (1,1,'127.0.0.1',0,NULL,0,NULL,0,NULL),(2,1,'95.85.108.178',0,NULL,0,NULL,0,NULL),(3,1,'93.171.223.181',0,NULL,0,NULL,0,NULL),(4,1,'119.235.114.114',0,NULL,0,NULL,0,NULL),(5,1,'119.235.118.26',0,NULL,0,NULL,0,NULL),(6,1,'95.85.112.106',0,NULL,0,NULL,0,NULL),(7,1,'119.235.120.190',2,'2024-03-15 10:29:23',0,NULL,0,NULL),(8,1,'10.104.73.74',3,'2024-02-29 08:22:45',0,NULL,0,NULL),(9,1,'125.167.14.169',4,'2024-03-27 13:28:23',0,NULL,0,NULL),(10,1,'156.146.56.101',3,'2024-04-01 12:59:48',0,NULL,0,NULL);
/*!40000 ALTER TABLE `backend_user_throttle` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `backend_users`
--

DROP TABLE IF EXISTS `backend_users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `backend_users` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `first_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `last_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `login` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `password` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `activation_code` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `persist_code` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `reset_password_code` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `permissions` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `is_activated` tinyint(1) NOT NULL DEFAULT '0',
  `role_id` int unsigned DEFAULT NULL,
  `activated_at` timestamp NULL DEFAULT NULL,
  `last_login` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `is_superuser` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `login_unique` (`login`),
  UNIQUE KEY `email_unique` (`email`),
  KEY `act_code_index` (`activation_code`),
  KEY `reset_code_index` (`reset_password_code`),
  KEY `admin_role_index` (`role_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `backend_users`
--

LOCK TABLES `backend_users` WRITE;
/*!40000 ALTER TABLE `backend_users` DISABLE KEYS */;
INSERT INTO `backend_users` VALUES (1,'Admin','Person','admin','digital.tps2018@gmail.com','$2y$10$b.48iKZcttpTuyFn1QCluOFoq23I/CJxErK15Oc.lcYFOYEfnETy2',NULL,'$2y$10$Ywf.xSZsBc3/xoCTSNqWMeNg6gj7gURiwT5N5ArnpG0Y2i5cRq9Ki',NULL,'',1,2,NULL,'2024-02-29 06:28:31','2022-07-03 06:14:02','2024-02-29 06:28:31',NULL,1);
/*!40000 ALTER TABLE `backend_users` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `backend_users_groups`
--

DROP TABLE IF EXISTS `backend_users_groups`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `backend_users_groups` (
  `user_id` int unsigned NOT NULL,
  `user_group_id` int unsigned NOT NULL,
  PRIMARY KEY (`user_id`,`user_group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `backend_users_groups`
--

LOCK TABLES `backend_users_groups` WRITE;
/*!40000 ALTER TABLE `backend_users_groups` DISABLE KEYS */;
INSERT INTO `backend_users_groups` VALUES (1,1);
/*!40000 ALTER TABLE `backend_users_groups` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cache`
--

DROP TABLE IF EXISTS `cache`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `cache` (
  `key` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `expiration` int NOT NULL,
  UNIQUE KEY `cache_key_unique` (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cache`
--

LOCK TABLES `cache` WRITE;
/*!40000 ALTER TABLE `cache` DISABLE KEYS */;
/*!40000 ALTER TABLE `cache` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cms_theme_data`
--

DROP TABLE IF EXISTS `cms_theme_data`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `cms_theme_data` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `theme` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `data` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `cms_theme_data_theme_index` (`theme`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cms_theme_data`
--

LOCK TABLES `cms_theme_data` WRITE;
/*!40000 ALTER TABLE `cms_theme_data` DISABLE KEYS */;
/*!40000 ALTER TABLE `cms_theme_data` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cms_theme_logs`
--

DROP TABLE IF EXISTS `cms_theme_logs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `cms_theme_logs` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `theme` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `template` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `old_template` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `old_content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `user_id` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `cms_theme_logs_type_index` (`type`),
  KEY `cms_theme_logs_theme_index` (`theme`),
  KEY `cms_theme_logs_user_id_index` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cms_theme_logs`
--

LOCK TABLES `cms_theme_logs` WRITE;
/*!40000 ALTER TABLE `cms_theme_logs` DISABLE KEYS */;
/*!40000 ALTER TABLE `cms_theme_logs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cms_theme_templates`
--

DROP TABLE IF EXISTS `cms_theme_templates`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `cms_theme_templates` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `source` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `path` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `file_size` int unsigned NOT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `cms_theme_templates_source_index` (`source`),
  KEY `cms_theme_templates_path_index` (`path`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cms_theme_templates`
--

LOCK TABLES `cms_theme_templates` WRITE;
/*!40000 ALTER TABLE `cms_theme_templates` DISABLE KEYS */;
/*!40000 ALTER TABLE `cms_theme_templates` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `deferred_bindings`
--

DROP TABLE IF EXISTS `deferred_bindings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `deferred_bindings` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `master_type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `master_field` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `slave_type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `slave_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `pivot_data` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `session_key` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_bind` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `deferred_bindings_master_type_index` (`master_type`),
  KEY `deferred_bindings_master_field_index` (`master_field`),
  KEY `deferred_bindings_slave_type_index` (`slave_type`),
  KEY `deferred_bindings_slave_id_index` (`slave_id`),
  KEY `deferred_bindings_session_key_index` (`session_key`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `deferred_bindings`
--

LOCK TABLES `deferred_bindings` WRITE;
/*!40000 ALTER TABLE `deferred_bindings` DISABLE KEYS */;
/*!40000 ALTER TABLE `deferred_bindings` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `failed_jobs`
--

DROP TABLE IF EXISTS `failed_jobs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `failed_jobs` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `connection` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `failed_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `failed_jobs`
--

LOCK TABLES `failed_jobs` WRITE;
/*!40000 ALTER TABLE `failed_jobs` DISABLE KEYS */;
/*!40000 ALTER TABLE `failed_jobs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jobs`
--

DROP TABLE IF EXISTS `jobs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `queue` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `attempts` tinyint unsigned NOT NULL,
  `reserved_at` int unsigned DEFAULT NULL,
  `available_at` int unsigned NOT NULL,
  `created_at` int unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `jobs_queue_reserved_at_index` (`queue`,`reserved_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `jobs`
--

LOCK TABLES `jobs` WRITE;
/*!40000 ALTER TABLE `jobs` DISABLE KEYS */;
/*!40000 ALTER TABLE `jobs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `martin_forms_records`
--

DROP TABLE IF EXISTS `martin_forms_records`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `martin_forms_records` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `group` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '(Empty)',
  `form_data` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `ip` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `unread` tinyint(1) NOT NULL DEFAULT '1',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `martin_forms_records`
--

LOCK TABLES `martin_forms_records` WRITE;
/*!40000 ALTER TABLE `martin_forms_records` DISABLE KEYS */;
INSERT INTO `martin_forms_records` VALUES (1,'Contact Us','{\"fullname\":\"Shohrat Annamyradow\",\"company_name\":\"Shokki\",\"email\":\"shokkwi.a96@gmail.com\",\"message\":\"asdasd\"}','119.235.118.26',0,NULL,'2023-09-18 11:24:26','2024-02-21 12:47:35'),(2,'Contact Us','{\"fullname\":\"Inspector\",\"company_name\":\"Site Controller TM \",\"email\":\"contins@mail.ru\",\"message\":\"Hi,\\r\\nYou have an error on this page.\\r\\nhttps:\\/\\/www.ashgabatairport.gov.tm\\/privacy-policy\\r\\nThank you!\\r\\n (PS: Don\'t respond to this mail. This mail is automaticly generated.)\"}','10.153.114.69',0,NULL,'2023-10-17 08:48:42','2024-02-29 06:24:37'),(3,'Contact Us','{\"fullname\":\"\",\"company_name\":\"\",\"email\":\"\",\"message\":\"\"}','119.235.123.123',0,NULL,'2023-12-07 08:40:06','2024-02-21 12:47:22'),(4,'Contact Us','{\"fullname\":\"Сауле Сабалакова\",\"company_name\":\"Maximedia\",\"email\":\"saule.k@maximedia.kz\",\"message\":\"Здравствуйте, меня интересует размещение рекламы на тв, в кулинарном шоу. Подскажите у вас есть такая опция?\\r\\n\"}','46.34.131.30',0,NULL,'2024-01-24 03:55:22','2024-02-21 12:47:15'),(5,'Contact Us','{\"fullname\":\"Kushal Ghosh\",\"company_name\":\"Link Builder Team\",\"email\":\"kushal.wbseo@gmail.com\",\"message\":\"Hi,\\r\\n \\r\\nI am a guest blogger. I am offering paid guest posts with good DA\\/DR and affordable prices. All sites are Google indexed. I will give you an instant post with a do-follow link. Please check some\\r\\nsites:\\r\\n\\r\\nhttps:\\/\\/techbullion.com\\/ DA 73 DR 77 Traffic: 762K $30\\r\\nhttps:\\/\\/entrepreneursbreak.com\\/ DA 49 DR 63  Traffic 201K $40\\r\\nhttps:\\/\\/timebusinessnews.com\\/ DA 77 DR 71 Traffic: 329K  $30\\r\\nhttps:\\/\\/www.businesstomark.com\\/ DA 64 DR 67 Traffic 100K $35\\r\\nhttps:\\/\\/www.newsbreak.com\\/ DR 81 $20\\r\\n\\r\\nI have in my collection 10K+ sites with all niches.\\r\\nAlso, If you need a content writing service then I\'m available for you.\\r\\n\\r\\nLooking forward to hearing from you.\"}','202.142.114.158',0,NULL,'2024-02-08 07:46:45','2024-02-29 06:24:45'),(6,'Contact Us','{\"fullname\":\"Rahat Meredow\",\"company_name\":\"Berk galam hk\",\"email\":\"rahatmer@bk.ru\",\"message\":\"Naruznyy reklama \"}','185.69.186.218',0,NULL,'2024-02-29 05:25:06','2024-02-29 06:28:44'),(7,'Contact Us','{\"fullname\":\"test\",\"company_name\":\"test\",\"email\":\"test@test.com\",\"message\":\"test\"}','119.235.118.26',0,NULL,'2024-02-29 06:39:25','2024-02-29 06:39:38');
/*!40000 ALTER TABLE `martin_forms_records` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `migrations`
--

DROP TABLE IF EXISTS `migrations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `migrations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=42 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `migrations`
--

LOCK TABLES `migrations` WRITE;
/*!40000 ALTER TABLE `migrations` DISABLE KEYS */;
INSERT INTO `migrations` VALUES (1,'2013_10_01_000001_Db_Deferred_Bindings',1),(2,'2013_10_01_000002_Db_System_Files',1),(3,'2013_10_01_000003_Db_System_Plugin_Versions',1),(4,'2013_10_01_000004_Db_System_Plugin_History',1),(5,'2013_10_01_000005_Db_System_Settings',1),(6,'2013_10_01_000006_Db_System_Parameters',1),(7,'2013_10_01_000007_Db_System_Add_Disabled_Flag',1),(8,'2013_10_01_000008_Db_System_Mail_Templates',1),(9,'2013_10_01_000009_Db_System_Mail_Layouts',1),(10,'2014_10_01_000010_Db_Jobs',1),(11,'2014_10_01_000011_Db_System_Event_Logs',1),(12,'2014_10_01_000012_Db_System_Request_Logs',1),(13,'2014_10_01_000013_Db_System_Sessions',1),(14,'2015_10_01_000014_Db_System_Mail_Layout_Rename',1),(15,'2015_10_01_000015_Db_System_Add_Frozen_Flag',1),(16,'2015_10_01_000016_Db_Cache',1),(17,'2015_10_01_000017_Db_System_Revisions',1),(18,'2015_10_01_000018_Db_FailedJobs',1),(19,'2016_10_01_000019_Db_System_Plugin_History_Detail_Text',1),(20,'2016_10_01_000020_Db_System_Timestamp_Fix',1),(21,'2017_08_04_121309_Db_Deferred_Bindings_Add_Index_Session',1),(22,'2017_10_01_000021_Db_System_Sessions_Update',1),(23,'2017_10_01_000022_Db_Jobs_FailedJobs_Update',1),(24,'2017_10_01_000023_Db_System_Mail_Partials',1),(25,'2017_10_23_000024_Db_System_Mail_Layouts_Add_Options_Field',1),(26,'2021_10_01_000025_Db_Add_Pivot_Data_To_Deferred_Bindings',1),(27,'2013_10_01_000001_Db_Backend_Users',2),(28,'2013_10_01_000002_Db_Backend_User_Groups',2),(29,'2013_10_01_000003_Db_Backend_Users_Groups',2),(30,'2013_10_01_000004_Db_Backend_User_Throttle',2),(31,'2014_01_04_000005_Db_Backend_User_Preferences',2),(32,'2014_10_01_000006_Db_Backend_Access_Log',2),(33,'2014_10_01_000007_Db_Backend_Add_Description_Field',2),(34,'2015_10_01_000008_Db_Backend_Add_Superuser_Flag',2),(35,'2016_10_01_000009_Db_Backend_Timestamp_Fix',2),(36,'2017_10_01_000010_Db_Backend_User_Roles',2),(37,'2018_12_16_000011_Db_Backend_Add_Deleted_At',2),(38,'2014_10_01_000001_Db_Cms_Theme_Data',3),(39,'2016_10_01_000002_Db_Cms_Timestamp_Fix',3),(40,'2017_10_01_000003_Db_Cms_Theme_Logs',3),(41,'2018_11_01_000001_Db_Cms_Theme_Templates',3);
/*!40000 ALTER TABLE `migrations` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `rainlab_blog_categories`
--

DROP TABLE IF EXISTS `rainlab_blog_categories`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `rainlab_blog_categories` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slug` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `code` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `parent_id` int unsigned DEFAULT NULL,
  `nest_left` int DEFAULT NULL,
  `nest_right` int DEFAULT NULL,
  `nest_depth` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `rainlab_blog_categories_slug_index` (`slug`),
  KEY `rainlab_blog_categories_parent_id_index` (`parent_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `rainlab_blog_categories`
--

LOCK TABLES `rainlab_blog_categories` WRITE;
/*!40000 ALTER TABLE `rainlab_blog_categories` DISABLE KEYS */;
INSERT INTO `rainlab_blog_categories` VALUES (1,'Uncategorized','uncategorized',NULL,NULL,NULL,1,2,0,'2022-07-03 06:21:37','2022-07-03 06:21:37');
/*!40000 ALTER TABLE `rainlab_blog_categories` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `rainlab_blog_posts`
--

DROP TABLE IF EXISTS `rainlab_blog_posts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `rainlab_blog_posts` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int unsigned DEFAULT NULL,
  `title` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slug` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `excerpt` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `content_html` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `published_at` timestamp NULL DEFAULT NULL,
  `published` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `metadata` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `rainlab_blog_posts_user_id_index` (`user_id`),
  KEY `rainlab_blog_posts_slug_index` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `rainlab_blog_posts`
--

LOCK TABLES `rainlab_blog_posts` WRITE;
/*!40000 ALTER TABLE `rainlab_blog_posts` DISABLE KEYS */;
INSERT INTO `rainlab_blog_posts` VALUES (1,1,'First blog post','first-blog-post','The first ever blog post is here. It might be a good idea to update this post with some more relevant content.','This is your first ever **blog post**! It might be a good idea to update this post with some more relevant content.\n\nYou can edit this content by selecting **Blog** from the administration back-end menu.\n\n*Enjoy the good times!*','<p>This is your first ever <strong>blog post</strong>! It might be a good idea to update this post with some more relevant content.</p>\n<p>You can edit this content by selecting <strong>Blog</strong> from the administration back-end menu.</p>\n<p><em>Enjoy the good times!</em></p>','2022-07-03 06:21:37',1,'2022-07-03 06:21:37','2022-07-03 06:21:37',NULL);
/*!40000 ALTER TABLE `rainlab_blog_posts` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `rainlab_blog_posts_categories`
--

DROP TABLE IF EXISTS `rainlab_blog_posts_categories`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `rainlab_blog_posts_categories` (
  `post_id` int unsigned NOT NULL,
  `category_id` int unsigned NOT NULL,
  PRIMARY KEY (`post_id`,`category_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `rainlab_blog_posts_categories`
--

LOCK TABLES `rainlab_blog_posts_categories` WRITE;
/*!40000 ALTER TABLE `rainlab_blog_posts_categories` DISABLE KEYS */;
/*!40000 ALTER TABLE `rainlab_blog_posts_categories` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `rainlab_translate_attributes`
--

DROP TABLE IF EXISTS `rainlab_translate_attributes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `rainlab_translate_attributes` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `locale` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `model_type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `attribute_data` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `rainlab_translate_attributes_locale_index` (`locale`),
  KEY `rainlab_translate_attributes_model_id_index` (`model_id`),
  KEY `rainlab_translate_attributes_model_type_index` (`model_type`)
) ENGINE=InnoDB AUTO_INCREMENT=117 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `rainlab_translate_attributes`
--

LOCK TABLES `rainlab_translate_attributes` WRITE;
/*!40000 ALTER TABLE `rainlab_translate_attributes` DISABLE KEYS */;
INSERT INTO `rainlab_translate_attributes` VALUES (1,'en','1','Akami\\Tps\\Models\\About','{\"header\":\"\",\"txt\":\"\",\"btn_txt\":\"\"}'),(2,'tm','1','Akami\\Tps\\Models\\About','{\"header\":\"Kompaniýa barada\",\"txt\":\"“TPS” Mahabat agentligi – mahabat, sanly hyzmatlar, ilerletmek, çäreleri guramak, poligrafiýa, önümçilik, dizaýn, bazaryň marketing barlaglary we ş.m. pudaklarynda köp ugurly kompaniýa.\\r\\n\\r\\nBiziň missiýamyz – Türkmenistanda bazara täsir etmek we mahabat-marketing hyzmat ediş etalonyny döretmek. Her bir müşderä özi barada aýtmaga mümkinçilik bermek.\\r\\n\",\"btn_txt\":\"\"}'),(3,'en','5','Akami\\Tps\\Models\\Service','{\"header\":\"Media Advertising\",\"txt\":\"Advertising on state television channels, radio, in print publications, and online media.\"}'),(4,'tm','5','Akami\\Tps\\Models\\Service','{\"header\":\"Köpçülikleýin habar beriş serişdelerinde mahabat\",\"txt\":\"Döwlet tele-, radio- ýaýlymlarynda, metbugat neşirlerinde we internet neşirlerinde mahabat etmek.\"}'),(5,'en','6','Akami\\Tps\\Models\\Service','{\"header\":\"Production\",\"txt\":\"Optimal combination of technologies, materials, and design for companies of any budget.\"}'),(6,'tm','6','Akami\\Tps\\Models\\Service','{\"header\":\"Önümçilik\",\"txt\":\"Islendik býujetli kompaniýalar üçin tehnologiýalaryň, materiallaryň we dizaýnyň amatly utgaşmasy.\"}'),(7,'en','1','Akami\\Tps\\Models\\ServicePage','{\"header\":\"Trivisions\",\"txt\":[{\"content\":\"Placement of advertising for multiple products simultaneously.\"},{\"content\":\"Sudden image change automatically grabs the audience\'s attention.\"},{\"content\":\"Ability for independent monitoring of the advertising campaign online.\"}]}'),(8,'tm','1','Akami\\Tps\\Models\\ServicePage','{\"header\":\"Triwiženler\",\"txt\":[{\"content\":\"Bir wagtyň özünde birnäçe önümleriň mahabatyny ýerleşdirmek.\"},{\"content\":\"Şekiliň duýdansyz üýtgemegi auditoriýanyň ünsüni awtomatiki özüne çekýär.\"},{\"content\":\"Onlaýn görnüşde mahabat kampaniýasyny özbaşdak monitoring etmek mümkinçiligi.\"}]}'),(9,'en','2','Akami\\Tps\\Models\\ServicePage','{\"header\":\"LED Screens\",\"txt\":[{\"content\":\"High-quality image in any weather and at any time of day.\"},{\"content\":\"Attract 40% more customers and enhance brand status.\"},{\"content\":\"Advantages: high visibility, easy perception, quick updating of advertising materials.\"}]}'),(10,'tm','2','Akami\\Tps\\Models\\ServicePage','{\"header\":\"LED-ekranlar\",\"txt\":[{\"content\":\"Islendik howada we islendik wagtda ýokary hilli şekil.\"},{\"content\":\"40 %-e köp müşderini özüne çekýär we haryt nyşanynyň statusyny ýokarlandyrýar.\"},{\"content\":\"Artykmaçlyklary: ýokary görüşi, aňsat kabul etmek, mahabat materiallaryny çalt täzelemek.\"}]}'),(11,'en','3','Akami\\Tps\\Models\\ServicePage','{\"header\":\"Gas Station Advertising\",\"txt\":[{\"content\":\"Placement at the 6 largest gas stations in the capital and 11 regional gas stations in all provinces.\"},{\"content\":\"Over 15,000 visitors daily.\"},{\"content\":\"A broad audience, including motorists of all ages and categories.\"}]}'),(12,'tm','3','Akami\\Tps\\Models\\ServicePage','{\"header\":\"Ýangyç guýujy beketlerinde mahabat\",\"txt\":[{\"content\":\"Paýtagtyň iri 6 sany ýangyç guýujy beketlerinde we ähli welaýatlaryndaky 11 sany sebit ýangyç guýujy beketlerinde ýerleşdirmek.\"},{\"content\":\"Her gün 15 000-den gowrak adam görýär.\"},{\"content\":\"Giň auditoriýa, şol sanda ähli ýaşly we derejeli awtoulag sürüjileri.\"}]}'),(23,'en','1','Akami\\Tps\\Models\\Service','{\"header\":\"Outdoor Advertising\",\"txt\":\"Design, placement, installation of structures, round-the-clock maintenance. We work all over the country.\"}'),(24,'tm','1','Akami\\Tps\\Models\\Service','{\"header\":\"Daşarky mahabat\",\"txt\":\"Dizaýn, ýerleşdirmek, konstruksiýalary gurnamak, 24 sagat hyzmat ediş. Ýurduň hemme ýerinde işleýäris.\"}'),(25,'en','2','Akami\
/*!40000 ALTER TABLE `rainlab_translate_attributes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `rainlab_translate_indexes`
--

DROP TABLE IF EXISTS `rainlab_translate_indexes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `rainlab_translate_indexes` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `locale` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `model_type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `item` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `value` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `rainlab_translate_indexes_locale_index` (`locale`),
  KEY `rainlab_translate_indexes_model_id_index` (`model_id`),
  KEY `rainlab_translate_indexes_model_type_index` (`model_type`),
  KEY `rainlab_translate_indexes_item_index` (`item`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `rainlab_translate_indexes`
--

LOCK TABLES `rainlab_translate_indexes` WRITE;
/*!40000 ALTER TABLE `rainlab_translate_indexes` DISABLE KEYS */;
/*!40000 ALTER TABLE `rainlab_translate_indexes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `rainlab_translate_locales`
--

DROP TABLE IF EXISTS `rainlab_translate_locales`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `rainlab_translate_locales` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_default` tinyint(1) NOT NULL DEFAULT '0',
  `is_enabled` tinyint(1) NOT NULL DEFAULT '0',
  `sort_order` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `rainlab_translate_locales_code_index` (`code`),
  KEY `rainlab_translate_locales_name_index` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `rainlab_translate_locales`
--

LOCK TABLES `rainlab_translate_locales` WRITE;
/*!40000 ALTER TABLE `rainlab_translate_locales` DISABLE KEYS */;
INSERT INTO `rainlab_translate_locales` VALUES (1,'en','English',0,1,1),(2,'tm','Turkmen',0,1,2),(3,'ru','Russian',1,1,3);
/*!40000 ALTER TABLE `rainlab_translate_locales` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `rainlab_translate_messages`
--

DROP TABLE IF EXISTS `rainlab_translate_messages`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `rainlab_translate_messages` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `message_data` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `found` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `rainlab_translate_messages_code_index` (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `rainlab_translate_messages`
--

LOCK TABLES `rainlab_translate_messages` WRITE;
/*!40000 ALTER TABLE `rainlab_translate_messages` DISABLE KEYS */;
INSERT INTO `rainlab_translate_messages` VALUES (1,'','{\"x\":null}',1),(2,'slider.txt','{\"x\":\"slider.txt\",\"ru\":\"\\u041f\\u043e\\u0441\\u0435\\u0442\\u0438\\u0442\\u0435 \\u043d\\u0430\\u0448 \\u043e\\u0442\\u0434\\u0435\\u043b Digital\"}',1),(3,'home.clients.header','{\"x\":\"home.clients.header\",\"ru\":\" \\u041d\\u0430\\u0448\\u0438 \\u043a\\u043b\\u0438\\u0435\\u043d\\u0442\\u044b\",\"en\":\"Our clients\",\"tm\":\"Bizi\\u0148 m\\u00fc\\u015fderilerimiz\"}',1),(4,'footer.copyright','{\"x\":\"footer.copyright\",\"ru\":\"\\u00a9 2016-2024 TPS Advertising Agency, \\u0412\\u0441\\u0435 \\u043f\\u0440\\u0430\\u0432\\u0430 \\u0437\\u0430\\u0449\\u0438\\u0449\\u0435\\u043d\\u044b\",\"tm\":\"\\u00a9 2019-2022 TPS Advertising Agency\",\"en\":\"\\u00a9 2019-2022 TPS Advertising Agency\"}',1),(5,'contact.title','{\"x\":\"contact.title\",\"ru\":\"\\u0421\\u0432\\u044f\\u0436\\u0438\\u0442\\u0435\\u0441\\u044c \\u0441 \\u043d\\u0430\\u043c\\u0438\",\"en\":\"Contact Us\",\"tm\":\"Biz bilen habarla\\u015fy\\u0148\"}',1),(6,'contact.form.fullname','{\"x\":\"contact.form.fullname\",\"ru\":\"\\u0424\\u0418\\u041e\",\"en\":\"Full Name\",\"tm\":\"Famili\\u00fdasy, ady, atasyny\\u0148 ady\"}',1),(7,'contact.form.company.name','{\"x\":\"contact.form.company.name\",\"ru\":\"\\u041d\\u0430\\u0437\\u0432\\u0430\\u043d\\u0438\\u0435 \\u043a\\u043e\\u043c\\u043f\\u0430\\u043d\\u0438\\u0438 \",\"en\":\"Company Name\",\"tm\":\"Kompani\\u00fdany\\u0148 ady\"}',1),(8,'contact.form.email','{\"x\":\"contact.form.email\",\"ru\":\"\\u042d\\u043b\\u0435\\u043a\\u0442\\u0440\\u043e\\u043d\\u043d\\u0430\\u044f \\u043f\\u043e\\u0447\\u0442\\u0430 \",\"en\":\"Email\",\"tm\":\"Elektron po\\u00e7ta\"}',1),(9,'contact.form.message','{\"x\":\"contact.form.message\",\"ru\":\"\\u0421\\u043e\\u043e\\u0431\\u0449\\u0435\\u043d\\u0438\\u0435\",\"en\":\"Message\",\"tm\":\"Habar\"}',1),(10,'contact.form.send.btn','{\"x\":\"contact.form.send.btn\",\"ru\":\"\\u041e\\u0442\\u043f\\u0440\\u0430\\u0432\\u0438\\u0442\\u044c\",\"en\":\"Send\",\"tm\":\"Ibermek\"}',1),(11,'contact.address.title','{\"x\":\"contact.address.title\",\"ru\":\"\\u0410\\u0434\\u0440\\u0435\\u0441:\",\"en\":\"Address:\",\"tm\":\"Salgysy:\"}',1),(12,'contact.address','{\"x\":\"contact.address\",\"ru\":\" 18 Ankara Str. Ashgabat, Turkmenistan 744017\",\"en\":\"18 Ankara Str. Ashgabat, Turkmenistan 744017\",\"tm\":\"18 Ankara Str. Ashgabat, Turkmenistan 744017\"}',1),(13,'contact.phone.title','{\"x\":\"contact.phone.title\",\"ru\":\"\\u0422\\u0435\\u043b\\u0435\\u0444\\u043e\\u043d:\",\"en\":\"Phone:\",\"tm\":\"Telefon:\"}',1),(14,'contact.phone','{\"x\":\"contact.phone\",\"ru\":\"+99312 454111\",\"en\":\"+99312 454111\",\"tm\":\"+99312 454111\"}',1),(15,'contact.email.title','{\"x\":\"contact.email.title\",\"ru\":\"Email:\",\"en\":\"Email:\",\"tm\":\"Elektron po\\u00e7ta\"}',1),(16,'contact.email','{\"x\":\"contact.email\",\"ru\":\"info@tpsadvertising.com\",\"en\":\"info@tpsadvertising.com\",\"tm\":\"info@tpsadvertising.com\"}',1),(17,'your.form.was.successfully.submitted','{\"x\":\"Your form was successfully submitted\"}',1),(18,'all.categories','{\"x\":\"all.categories\",\"ru\":\"\\u0412\\u0441\\u0435 \\u043a\\u0430\\u0442\\u0435\\u0433\\u043e\\u0440\\u0438\\u0438\",\"en\":\"All Categories\",\"tm\":\"\\u00c4hli derejeler\"}',1);
/*!40000 ALTER TABLE `rainlab_translate_messages` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sessions`
--

DROP TABLE IF EXISTS `sessions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sessions` (
  `id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `last_activity` int DEFAULT NULL,
  `user_id` int unsigned DEFAULT NULL,
  `ip_address` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_agent` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  UNIQUE KEY `sessions_id_unique` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sessions`
--

LOCK TABLES `sessions` WRITE;
/*!40000 ALTER TABLE `sessions` DISABLE KEYS */;
/*!40000 ALTER TABLE `sessions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `system_event_logs`
--

DROP TABLE IF EXISTS `system_event_logs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `system_event_logs` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `level` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `details` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `system_event_logs_level_index` (`level`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `system_event_logs`
--

LOCK TABLES `system_event_logs` WRITE;
/*!40000 ALTER TABLE `system_event_logs` DISABLE KEYS */;
INSERT INTO `system_event_logs` VALUES (1,'error','Twig\\Error\\SyntaxError: Unknown \"slider\" tag in \"/Users/tmstore/Desktop/tps2022/TPS adv/TPS oct/themes/tps/partials/home/slider.htm\" at line 48. in /Users/tmstore/Desktop/tps2022/TPS adv/TPS oct/vendor/twig/twig/src/Parser.php:174\nStack trace:\n#0 /Users/tmstore/Desktop/tps2022/TPS adv/TPS oct/vendor/twig/twig/src/Parser.php(97): Twig\\Parser->subparse(NULL, false)\n#1 /Users/tmstore/Desktop/tps2022/TPS adv/TPS oct/vendor/twig/twig/src/Environment.php(562): Twig\\Parser->parse(Object(Twig\\TokenStream))\n#2 /Users/tmstore/Desktop/tps2022/TPS adv/TPS oct/vendor/twig/twig/src/Environment.php(594): Twig\\Environment->parse(Object(Twig\\TokenStream))\n#3 /Users/tmstore/Desktop/tps2022/TPS adv/TPS oct/vendor/twig/twig/src/Environment.php(408): Twig\\Environment->compileSource(Object(Twig\\Source))\n#4 /Users/tmstore/Desktop/tps2022/TPS adv/TPS oct/vendor/twig/twig/src/Environment.php(381): Twig\\Environment->loadClass(\'__TwigTemplate_...\', \'/Users/tmstore/...\', NULL)\n#5 /Users/tmstore/Desktop/tps2022/TPS adv/TPS oct/modules/cms/Classes/Controller.php(1087): Twig\\Environment->loadTemplate(\'/Users/tmstore/...\')\n#6 /Users/tmstore/Desktop/tps2022/TPS adv/TPS oct/modules/cms/Twig/Extension.php(102): Cms\\Classes\\Controller->renderPartial(\'builderList\', Array, true)\n#7 /Users/tmstore/Desktop/tps2022/TPS adv/TPS oct/storage/cms/twig/15/159429c3ad27fc0666d538994bdca23cc92aca73eed4491ae2189f4fccebc565.php(40): Cms\\Twig\\Extension->partialFunction(\'home/slider\', Array, true)\n#8 /Users/tmstore/Desktop/tps2022/TPS adv/TPS oct/vendor/twig/twig/src/Template.php(405): __TwigTemplate_e5ccfaebb7cfd147d5431dc097f7580af227da9a93767ed7339ea9f0d0a28aab->doDisplay(Array, Array)\n#9 /Users/tmstore/Desktop/tps2022/TPS adv/TPS oct/vendor/twig/twig/src/Template.php(378): Twig\\Template->displayWithErrorHandling(Array, Array)\n#10 /Users/tmstore/Desktop/tps2022/TPS adv/TPS oct/vendor/twig/twig/src/Template.php(390): Twig\\Template->display(Array)\n#11 /Users/tmstore/Desktop/tps2022/TPS adv/TPS oct/modules/cms/Classes/Controller.php(425): Twig\\Template->render(Array)\n#12 /Users/tmstore/Desktop/tps2022/TPS adv/TPS oct/modules/cms/Classes/Controller.php(225): Cms\\Classes\\Controller->runPage(Object(Cms\\Classes\\Page))\n#13 /Users/tmstore/Desktop/tps2022/TPS adv/TPS oct/modules/cms/Classes/CmsController.php(50): Cms\\Classes\\Controller->run(\'/\')\n#14 /Users/tmstore/Desktop/tps2022/TPS adv/TPS oct/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): Cms\\Classes\\CmsController->run(\'/\')\n#15 /Users/tmstore/Desktop/tps2022/TPS adv/TPS oct/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(45): Illuminate\\Routing\\Controller->callAction(\'run\', Array)\n#16 /Users/tmstore/Desktop/tps2022/TPS adv/TPS oct/vendor/laravel/framework/src/Illuminate/Routing/Route.php(219): Illuminate\\Routing\\ControllerDispatcher->dispatch(Object(Illuminate\\Routing\\Route), Object(Cms\\Classes\\CmsController), \'run\')\n#17 /Users/tmstore/Desktop/tps2022/TPS adv/TPS oct/vendor/laravel/framework/src/Illuminate/Routing/Route.php(176): Illuminate\\Routing\\Route->runController()\n#18 /Users/tmstore/Desktop/tps2022/TPS adv/TPS oct/vendor/laravel/framework/src/Illuminate/Routing/Router.php(681): Illuminate\\Routing\\Route->run()\n#19 /Users/tmstore/Desktop/tps2022/TPS adv/TPS oct/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(130): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request))\n#20 /Users/tmstore/Desktop/tps2022/TPS adv/TPS oct/plugins/rainlab/translate/classes/LocaleMiddleware.php(29): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))\n#21 /Users/tmstore/Desktop/tps2022/TPS adv/TPS oct/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): RainLab\\Translate\\Classes\\LocaleMiddleware->handle(Object(Illuminate\\Http\\Request), Object(Closure))\n#22 /Users/tmstore/Desktop/tps2022/TPS adv/TPS oct/vendor/laravel/framework/src/Illuminate/Routin
/*!40000 ALTER TABLE `system_event_logs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `system_files`
--

DROP TABLE IF EXISTS `system_files`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `system_files` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `disk_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `file_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `file_size` int NOT NULL,
  `content_type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `field` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `attachment_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `attachment_type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_public` tinyint(1) NOT NULL DEFAULT '1',
  `sort_order` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `system_files_field_index` (`field`),
  KEY `system_files_attachment_id_index` (`attachment_id`),
  KEY `system_files_attachment_type_index` (`attachment_type`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `system_files`
--

LOCK TABLES `system_files` WRITE;
/*!40000 ALTER TABLE `system_files` DISABLE KEYS */;
INSERT INTO `system_files` VALUES (1,'63200c688ffd8804142074.png','tps-logo1.png',40202,'image/png',NULL,NULL,'logo','2','Backend\\Models\\BrandSetting',1,1,'2022-09-12 23:51:52','2022-09-12 23:51:54');
/*!40000 ALTER TABLE `system_files` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `system_mail_layouts`
--

DROP TABLE IF EXISTS `system_mail_layouts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `system_mail_layouts` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `code` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `content_html` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `content_text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `content_css` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `is_locked` tinyint(1) NOT NULL DEFAULT '0',
  `options` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `system_mail_layouts`
--

LOCK TABLES `system_mail_layouts` WRITE;
/*!40000 ALTER TABLE `system_mail_layouts` DISABLE KEYS */;
INSERT INTO `system_mail_layouts` VALUES (1,'Default layout','default','<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">\n<html xmlns=\"http://www.w3.org/1999/xhtml\">\n<head>\n    <meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\" />\n    <meta http-equiv=\"Content-Type\" content=\"text/html; charset=UTF-8\" />\n</head>\n<body>\n    <style type=\"text/css\" media=\"screen\">\n        {{ brandCss|raw }}\n        {{ css|raw }}\n    </style>\n\n    <table class=\"wrapper layout-default\" width=\"100%\" cellpadding=\"0\" cellspacing=\"0\">\n\n        <!-- Header -->\n        {% partial \'header\' body %}\n            {{ subject|raw }}\n        {% endpartial %}\n\n        <tr>\n            <td align=\"center\">\n                <table class=\"content\" width=\"100%\" cellpadding=\"0\" cellspacing=\"0\">\n                    <!-- Email Body -->\n                    <tr>\n                        <td class=\"body\" width=\"100%\" cellpadding=\"0\" cellspacing=\"0\">\n                            <table class=\"inner-body\" align=\"center\" width=\"570\" cellpadding=\"0\" cellspacing=\"0\">\n                                <!-- Body content -->\n                                <tr>\n                                    <td class=\"content-cell\">\n                                        {{ content|raw }}\n                                    </td>\n                                </tr>\n                            </table>\n                        </td>\n                    </tr>\n                </table>\n            </td>\n        </tr>\n\n        <!-- Footer -->\n        {% partial \'footer\' body %}\n            &copy; {{ \"now\"|date(\"Y\") }} {{ appName }}. All rights reserved.\n        {% endpartial %}\n\n    </table>\n\n</body>\n</html>','{{ content|raw }}','@media only screen and (max-width: 600px) {\n    .inner-body {\n        width: 100% !important;\n    }\n\n    .footer {\n        width: 100% !important;\n    }\n}\n\n@media only screen and (max-width: 500px) {\n    .button {\n        width: 100% !important;\n    }\n}',1,NULL,'2022-07-03 06:14:02','2022-07-03 06:14:02'),(2,'System layout','system','<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">\n<html xmlns=\"http://www.w3.org/1999/xhtml\">\n<head>\n    <meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\" />\n    <meta http-equiv=\"Content-Type\" content=\"text/html; charset=UTF-8\" />\n</head>\n<body>\n    <style type=\"text/css\" media=\"screen\">\n        {{ brandCss|raw }}\n        {{ css|raw }}\n    </style>\n\n    <table class=\"wrapper layout-system\" width=\"100%\" cellpadding=\"0\" cellspacing=\"0\">\n        <tr>\n            <td align=\"center\">\n                <table class=\"content\" width=\"100%\" cellpadding=\"0\" cellspacing=\"0\">\n                    <!-- Email Body -->\n                    <tr>\n                        <td class=\"body\" width=\"100%\" cellpadding=\"0\" cellspacing=\"0\">\n                            <table class=\"inner-body\" align=\"center\" width=\"570\" cellpadding=\"0\" cellspacing=\"0\">\n                                <!-- Body content -->\n                                <tr>\n                                    <td class=\"content-cell\">\n                                        {{ content|raw }}\n\n                                        <!-- Subcopy -->\n                                        {% partial \'subcopy\' body %}\n                                            **This is an automatic message. Please do not reply to it.**\n                                        {% endpartial %}\n                                    </td>\n                                </tr>\n                            </table>\n                        </td>\n                    </tr>\n                </table>\n            </td>\n        </tr>\n    </table>\n\n</body>\n</html>','{{ content|raw }}\n\n\n---\nThis is an automatic message. Please do not
/*!40000 ALTER TABLE `system_mail_layouts` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `system_mail_partials`
--

DROP TABLE IF EXISTS `system_mail_partials`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `system_mail_partials` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `code` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `content_html` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `content_text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `is_custom` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `system_mail_partials`
--

LOCK TABLES `system_mail_partials` WRITE;
/*!40000 ALTER TABLE `system_mail_partials` DISABLE KEYS */;
INSERT INTO `system_mail_partials` VALUES (1,'Header','header','<tr>\n    <td class=\"header\">\n        {% if url %}\n            <a href=\"{{ url }}\">\n                {{ body }}\n            </a>\n        {% else %}\n            <span>\n                {{ body }}\n            </span>\n        {% endif %}\n    </td>\n</tr>','*** {{ body|trim }} <{{ url }}>',0,'2024-02-29 06:18:23','2024-02-29 06:18:23'),(2,'Footer','footer','<tr>\n    <td>\n        <table class=\"footer\" align=\"center\" width=\"570\" cellpadding=\"0\" cellspacing=\"0\">\n            <tr>\n                <td class=\"content-cell\" align=\"center\">\n                    {{ body|md_safe }}\n                </td>\n            </tr>\n        </table>\n    </td>\n</tr>','-------------------\n{{ body|trim }}',0,'2024-02-29 06:18:23','2024-02-29 06:18:23'),(3,'Button','button','<table class=\"action\" align=\"center\" width=\"100%\" cellpadding=\"0\" cellspacing=\"0\">\n    <tr>\n        <td align=\"center\">\n            <table width=\"100%\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\n                <tr>\n                    <td align=\"center\">\n                        <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\n                            <tr>\n                                <td>\n                                    <a href=\"{{ url }}\" class=\"button button-{{ type ?: \'primary\' }}\" target=\"_blank\">\n                                        {{ body }}\n                                    </a>\n                                </td>\n                            </tr>\n                        </table>\n                    </td>\n                </tr>\n            </table>\n        </td>\n    </tr>\n</table>','{{ body|trim }} <{{ url }}>',0,'2024-02-29 06:18:23','2024-02-29 06:18:23'),(4,'Panel','panel','<table class=\"panel break-all\" width=\"100%\" cellpadding=\"0\" cellspacing=\"0\">\n    <tr>\n        <td class=\"panel-content\">\n            <table width=\"100%\" cellpadding=\"0\" cellspacing=\"0\">\n                <tr>\n                    <td class=\"panel-item\">\n                        {{ body|md_safe }}\n                    </td>\n                </tr>\n            </table>\n        </td>\n    </tr>\n</table>','{{ body|trim }}',0,'2024-02-29 06:18:23','2024-02-29 06:18:23'),(5,'Table','table','<div class=\"table\">\n    {{ body|md_safe }}\n</div>','{{ body|trim }}',0,'2024-02-29 06:18:23','2024-02-29 06:18:23'),(6,'Subcopy','subcopy','<table class=\"subcopy\" width=\"100%\" cellpadding=\"0\" cellspacing=\"0\">\n    <tr>\n        <td>\n            {{ body|md_safe }}\n        </td>\n    </tr>\n</table>','-----\n{{ body|trim }}',0,'2024-02-29 06:18:23','2024-02-29 06:18:23'),(7,'Promotion','promotion','<table class=\"promotion break-all\" align=\"center\" width=\"100%\" cellpadding=\"0\" cellspacing=\"0\">\n    <tr>\n        <td align=\"center\">\n            {{ body|md_safe }}\n        </td>\n    </tr>\n</table>','{{ body|trim }}',0,'2024-02-29 06:18:23','2024-02-29 06:18:23');
/*!40000 ALTER TABLE `system_mail_partials` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `system_mail_templates`
--

DROP TABLE IF EXISTS `system_mail_templates`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `system_mail_templates` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `subject` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `content_html` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `content_text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `layout_id` int DEFAULT NULL,
  `is_custom` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `system_mail_templates_layout_id_index` (`layout_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `system_mail_templates`
--

LOCK TABLES `system_mail_templates` WRITE;
/*!40000 ALTER TABLE `system_mail_templates` DISABLE KEYS */;
INSERT INTO `system_mail_templates` VALUES (1,'martin.forms::mail.notification',NULL,NULL,NULL,NULL,1,0,'2024-02-29 06:18:23','2024-02-29 06:18:23'),(2,'martin.forms::mail.autoresponse',NULL,NULL,NULL,NULL,1,0,'2024-02-29 06:18:23','2024-02-29 06:18:23'),(3,'backend::mail.invite',NULL,'Invite new admin to the site',NULL,NULL,2,0,'2024-02-29 06:18:23','2024-02-29 06:18:23'),(4,'backend::mail.restore',NULL,'Reset an admin password',NULL,NULL,2,0,'2024-02-29 06:18:23','2024-02-29 06:18:23');
/*!40000 ALTER TABLE `system_mail_templates` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `system_parameters`
--

DROP TABLE IF EXISTS `system_parameters`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `system_parameters` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `namespace` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `group` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `item` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `item_index` (`namespace`,`group`,`item`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `system_parameters`
--

LOCK TABLES `system_parameters` WRITE;
/*!40000 ALTER TABLE `system_parameters` DISABLE KEYS */;
INSERT INTO `system_parameters` VALUES (1,'system','update','count','0'),(2,'system','update','retry','1709273876'),(3,'cms','theme','active','\"tps\"');
/*!40000 ALTER TABLE `system_parameters` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `system_plugin_history`
--

DROP TABLE IF EXISTS `system_plugin_history`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `system_plugin_history` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `version` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `detail` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `system_plugin_history_code_index` (`code`),
  KEY `system_plugin_history_type_index` (`type`)
) ENGINE=InnoDB AUTO_INCREMENT=387 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `system_plugin_history`
--

LOCK TABLES `system_plugin_history` WRITE;
/*!40000 ALTER TABLE `system_plugin_history` DISABLE KEYS */;
INSERT INTO `system_plugin_history` VALUES (1,'October.Demo','comment','1.0.1','First version of Demo','2022-07-03 06:14:02'),(2,'RainLab.Builder','comment','1.0.1','Initialize plugin.','2022-07-03 06:17:38'),(3,'RainLab.Builder','comment','1.0.2','Fixes the problem with selecting a plugin. Minor localization corrections. Configuration files in the list and form behaviors are now autocomplete.','2022-07-03 06:17:38'),(4,'RainLab.Builder','comment','1.0.3','Improved handling of the enum data type.','2022-07-03 06:17:38'),(5,'RainLab.Builder','comment','1.0.4','Added user permissions to work with the Builder.','2022-07-03 06:17:38'),(6,'RainLab.Builder','comment','1.0.5','Fixed permissions registration.','2022-07-03 06:17:38'),(7,'RainLab.Builder','comment','1.0.6','Fixed front-end record ordering in the Record List component.','2022-07-03 06:17:38'),(8,'RainLab.Builder','comment','1.0.7','Builder settings are now protected with user permissions. The database table column list is scrollable now. Minor code cleanup.','2022-07-03 06:17:38'),(9,'RainLab.Builder','comment','1.0.8','Added the Reorder Controller behavior.','2022-07-03 06:17:38'),(10,'RainLab.Builder','comment','1.0.9','Minor API and UI updates.','2022-07-03 06:17:38'),(11,'RainLab.Builder','comment','1.0.10','Minor styling update.','2022-07-03 06:17:38'),(12,'RainLab.Builder','comment','1.0.11','Fixed a bug where clicking placeholder in a repeater would open Inspector. Fixed a problem with saving forms with repeaters in tabs. Minor style fix.','2022-07-03 06:17:38'),(13,'RainLab.Builder','comment','1.0.12','Added support for the Trigger property to the Media Finder widget configuration. Names of form fields and list columns definition files can now contain underscores.','2022-07-03 06:17:38'),(14,'RainLab.Builder','comment','1.0.13','Minor styling fix on the database editor.','2022-07-03 06:17:38'),(15,'RainLab.Builder','comment','1.0.14','Added support for published_at timestamp field','2022-07-03 06:17:38'),(16,'RainLab.Builder','comment','1.0.15','Fixed a bug where saving a localization string in Inspector could cause a JavaScript error. Added support for Timestamps and Soft Deleting for new models.','2022-07-03 06:17:38'),(17,'RainLab.Builder','comment','1.0.16','Fixed a bug when saving a form with the Repeater widget in a tab could create invalid fields in the form\'s outside area. Added a check that prevents creating localization strings inside other existing strings.','2022-07-03 06:17:38'),(18,'RainLab.Builder','comment','1.0.17','Added support Trigger attribute support for RecordFinder and Repeater form widgets.','2022-07-03 06:17:38'),(19,'RainLab.Builder','comment','1.0.18','Fixes a bug where \'::class\' notations in a model class definition could prevent the model from appearing in the Builder model list. Added emptyOption property support to the dropdown form control.','2022-07-03 06:17:38'),(20,'RainLab.Builder','comment','1.0.19','Added a feature allowing to add all database columns to a list definition. Added max length validation for database table and column names.','2022-07-03 06:17:38'),(21,'RainLab.Builder','comment','1.0.20','Fixes a bug where form the builder could trigger the \"current.hasAttribute is not a function\" error.','2022-07-03 06:17:38'),(22,'RainLab.Builder','comment','1.0.21','Back-end navigation sort order updated.','2022-07-03 06:17:38'),(23,'RainLab.Builder','comment','1.0.22','Added scopeValue property to the RecordList component.','2022-07-03 06:17:38'),(24,'RainLab.Builder','comment','1.0.23','Added support for balloon-selector field type, added Brazilian Portuguese translation, fixed some bugs','2022-07-03 06:17:38'),(25,'RainLab.Builder','comment','1.0.24','Added support for tag list field type, added read only toggle for fields. Prevent plugins from using reserved PHP keywords for class names and namespaces','2022-07-03 06:17:38'),(26,'RainLab.Builder','comment','1.0.25','Allow editing of migration code in the \"Migration\" popup when saving changes in the database editor.','2022-07-03 06:17:38'),(27,'RainLab.Builde
/*!40000 ALTER TABLE `system_plugin_history` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `system_plugin_versions`
--

DROP TABLE IF EXISTS `system_plugin_versions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `system_plugin_versions` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `version` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `is_disabled` tinyint(1) NOT NULL DEFAULT '0',
  `is_frozen` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `system_plugin_versions_code_index` (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `system_plugin_versions`
--

LOCK TABLES `system_plugin_versions` WRITE;
/*!40000 ALTER TABLE `system_plugin_versions` DISABLE KEYS */;
INSERT INTO `system_plugin_versions` VALUES (1,'October.Demo','1.0.1','2022-07-03 06:14:02',0,0),(2,'RainLab.Builder','1.2.2','2022-07-03 06:17:38',0,0),(3,'Martin.Forms','1.5.1','2022-07-03 06:18:13',0,0),(4,'Indikator.DevTools','1.2.3','2022-07-03 06:19:08',0,0),(5,'RainLab.Pages','1.5.4','2022-07-03 06:20:08',0,0),(6,'RainLab.Translate','1.11.1','2022-07-03 06:20:37',0,0),(7,'RainLab.Blog','1.5.6','2022-07-03 06:21:37',0,0),(9,'Akami.Tps','1.0.12','2023-08-30 06:53:17',0,0);
/*!40000 ALTER TABLE `system_plugin_versions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `system_request_logs`
--

DROP TABLE IF EXISTS `system_request_logs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `system_request_logs` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `status_code` int DEFAULT NULL,
  `url` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `referer` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `count` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `system_request_logs`
--

LOCK TABLES `system_request_logs` WRITE;
/*!40000 ALTER TABLE `system_request_logs` DISABLE KEYS */;
/*!40000 ALTER TABLE `system_request_logs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `system_revisions`
--

DROP TABLE IF EXISTS `system_revisions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `system_revisions` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int unsigned DEFAULT NULL,
  `field` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cast` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `old_value` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `new_value` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `revisionable_type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `revisionable_id` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `system_revisions_revisionable_id_revisionable_type_index` (`revisionable_id`,`revisionable_type`),
  KEY `system_revisions_user_id_index` (`user_id`),
  KEY `system_revisions_field_index` (`field`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `system_revisions`
--

LOCK TABLES `system_revisions` WRITE;
/*!40000 ALTER TABLE `system_revisions` DISABLE KEYS */;
/*!40000 ALTER TABLE `system_revisions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `system_settings`
--

DROP TABLE IF EXISTS `system_settings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `system_settings` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `item` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `value` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `system_settings_item_index` (`item`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `system_settings`
--

LOCK TABLES `system_settings` WRITE;
/*!40000 ALTER TABLE `system_settings` DISABLE KEYS */;
INSERT INTO `system_settings` VALUES (1,'rainlab_builder_settings','{\"author_name\":\"AKAMI\",\"author_namespace\":\"Akami\"}'),(2,'backend_brand_settings','{\"app_name\":\"TPS Advertising\",\"app_tagline\":\"Tapylgysyz Mahabat\",\"primary_color\":\"#34495e\",\"secondary_color\":\"#006cb6\",\"accent_color\":\"#3498db\",\"menu_mode\":\"inline\",\"custom_css\":\"\"}'),(3,'system_mail_settings','{\"send_mode\":\"smtp\",\"sender_name\":\"TPS Advertising\",\"sender_email\":\"noreply@tpsadvertising.com\",\"sendmail_path\":\"\\/usr\\/sbin\\/sendmail -bs\",\"smtp_address\":\"send.one.com\",\"smtp_port\":\"465\",\"smtp_user\":\"noreply@tpsadvertising.com\",\"smtp_password\":\"noreply2023**\",\"smtp_authorization\":\"1\",\"smtp_encryption\":\"ssl\",\"mailgun_domain\":\"\",\"mailgun_secret\":\"\",\"mandrill_secret\":\"\",\"ses_key\":\"\",\"ses_secret\":\"\",\"ses_region\":\"\",\"sparkpost_secret\":\"\"}');
/*!40000 ALTER TABLE `system_settings` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!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 */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2024-04-03 13:15:51