161 lines
13 KiB
SQL
161 lines
13 KiB
SQL
-- -------------------------------------------------------------
|
||
-- TablePlus 4.7.1(428)
|
||
--
|
||
-- https://tableplus.com/
|
||
--
|
||
-- Database: tehnika
|
||
-- Generation Time: 2023-06-26 15:02:06.1970
|
||
-- -------------------------------------------------------------
|
||
|
||
|
||
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
|
||
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
|
||
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
|
||
/*!40101 SET NAMES utf8 */;
|
||
/*!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 */;
|
||
|
||
|
||
DROP TABLE IF EXISTS `tps_airport_banners`;
|
||
CREATE TABLE `tps_airport_banners` (
|
||
`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,
|
||
`img` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
||
`note` text COLLATE utf8mb4_unicode_ci,
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
||
|
||
DROP TABLE IF EXISTS `tps_airport_content_card`;
|
||
CREATE TABLE `tps_airport_content_card` (
|
||
`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,
|
||
`header` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
||
`short_txt` text COLLATE utf8mb4_unicode_ci,
|
||
`description` text COLLATE utf8mb4_unicode_ci,
|
||
`btn_txt` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
||
`note` text COLLATE utf8mb4_unicode_ci,
|
||
`img` text COLLATE utf8mb4_unicode_ci,
|
||
`img_side` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'left',
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
||
|
||
DROP TABLE IF EXISTS `tps_airport_contents`;
|
||
CREATE TABLE `tps_airport_contents` (
|
||
`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,
|
||
`data` text COLLATE utf8mb4_unicode_ci,
|
||
`note` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
||
`menu_slug` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
||
|
||
DROP TABLE IF EXISTS `tps_airport_headers`;
|
||
CREATE TABLE `tps_airport_headers` (
|
||
`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,
|
||
`img` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
||
`header` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
||
`short_txt` text COLLATE utf8mb4_unicode_ci,
|
||
`has_file` tinyint(1) DEFAULT '0',
|
||
`note` text COLLATE utf8mb4_unicode_ci,
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
||
|
||
DROP TABLE IF EXISTS `tps_airport_home_header`;
|
||
CREATE TABLE `tps_airport_home_header` (
|
||
`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,
|
||
`main_img` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
||
`logos` text COLLATE utf8mb4_unicode_ci,
|
||
`main_title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
||
`main_txt` text COLLATE utf8mb4_unicode_ci,
|
||
`note` text COLLATE utf8mb4_unicode_ci NOT NULL,
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
||
|
||
DROP TABLE IF EXISTS `tps_airport_menu`;
|
||
CREATE TABLE `tps_airport_menu` (
|
||
`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,
|
||
`sub_menu` text COLLATE utf8mb4_unicode_ci,
|
||
`note` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
||
`order` int DEFAULT NULL,
|
||
`menu_slug` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
||
`status` tinyint(1) DEFAULT '1',
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
||
|
||
DROP TABLE IF EXISTS `tps_airport_page`;
|
||
CREATE TABLE `tps_airport_page` (
|
||
`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,
|
||
`menu_id` int NOT NULL,
|
||
`content_id` int NOT NULL,
|
||
`note` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
||
|
||
DROP TABLE IF EXISTS `tps_airport_partners`;
|
||
CREATE TABLE `tps_airport_partners` (
|
||
`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,
|
||
`img` text COLLATE utf8mb4_unicode_ci,
|
||
`note` text COLLATE utf8mb4_unicode_ci,
|
||
`header` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
||
|
||
INSERT INTO `tps_airport_banners` (`id`, `created_at`, `updated_at`, `deleted_at`, `img`, `note`) VALUES
|
||
(1, '2023-06-25 18:36:59', '2023-06-26 05:25:10', NULL, '/home/banner/home_itcc.jpg', '');
|
||
|
||
INSERT INTO `tps_airport_content_card` (`id`, `created_at`, `updated_at`, `deleted_at`, `header`, `short_txt`, `description`, `btn_txt`, `note`, `img`, `img_side`) VALUES
|
||
(1, '2023-06-25 18:14:04', '2023-06-26 05:23:17', NULL, 'Информация для пассажиров', 'Здесь вы найдете полезную информацию для беззаботного прибытия в аэропорт и беззаботного отъезда.', '', 'Узнать больше', '', '/home/home_about.jpg', NULL),
|
||
(2, '2023-06-26 05:24:24', '2023-06-26 05:34:30', NULL, 'Информация для партнеров', 'Здесь вы найдете полезную информацию для сотрудничества.', '', 'Узнать больше', '', '/home/home_partner_card.jpg', 'right'),
|
||
(3, '2023-06-26 05:34:15', '2023-06-26 05:35:07', NULL, 'Услуги аэропорта Ашхабад', 'Здесь вы найдете полезную информацию для беззаботного прибытия в аэропорт и беззаботного отъезда.', '', 'Узнать больше', '', '/home/uslugi_hom.jpg', 'left'),
|
||
(4, '2023-06-26 05:35:56', '2023-06-26 05:35:56', NULL, 'О Международном аэропорте Ашхабад', 'Здесь вы найдете информацию о нас, Международном аэропорте Ашхабад', '', 'Узнать больше', '', '/home/home_banner2.jpg', 'right');
|
||
|
||
INSERT INTO `tps_airport_contents` (`id`, `created_at`, `updated_at`, `deleted_at`, `data`, `note`, `menu_slug`) VALUES
|
||
(1, '2023-06-26 04:42:17', '2023-06-26 06:23:02', NULL, '[{\"section\":\"tps_airport_home_header\",\"section_id\":1,\"limit\":null},{\"section\":\"content_card\",\"section_id\":1,\"limit\":null},{\"section\":\"banner\",\"section_id\":1,\"limit\":null},{\"section\":\"posts\",\"section_id\":null,\"limit\":8},{\"section\":\"content_card\",\"section_id\":3,\"limit\":null},{\"section\":\"content_card\",\"section_id\":4,\"limit\":null}]', 'Home Page', 'glavnaya'),
|
||
(2, '2023-06-26 05:53:11', '2023-06-26 05:53:11', NULL, '[]', 'skdjfnksdf', 'o-nas');
|
||
|
||
INSERT INTO `tps_airport_home_header` (`id`, `created_at`, `updated_at`, `deleted_at`, `main_img`, `logos`, `main_title`, `main_txt`, `note`) VALUES
|
||
(1, '2023-06-25 18:00:28', '2023-06-25 18:00:28', NULL, '/main/MainImg.jpg', '[{\"main_logo\":\"\\/main_logos\\/main_1.png\",\"note\":\"\"},{\"main_logo\":\"\\/main_logos\\/main_2.png\",\"note\":\"\"},{\"main_logo\":\"\\/main_logos\\/main_3.png\",\"note\":\"\"}]', 'Международный аэропорт Ашхабад —', 'это современные терминалы, мультиязычный персонал и комфорт пассажира. Является главным в стране и базовым туркменским аэропортом для крупнейших авиакомпаний мира. Внесен в Книгу рекордов Гиннесса и обладатель международных премий.', '');
|
||
|
||
INSERT INTO `tps_airport_menu` (`id`, `created_at`, `updated_at`, `deleted_at`, `name`, `sub_menu`, `note`, `order`, `menu_slug`, `status`) VALUES
|
||
(1, '2023-06-25 17:39:46', '2023-06-26 05:06:41', NULL, 'Пассажерам', '[{\"menu_title\":\"\\u041e\\u043d\\u043b\\u0430\\u0439\\u043d-\\u0442\\u0430\\u0431\\u043b\\u043e\",\"sub_slug\":\"online-table\"},{\"menu_title\":\"\\u0420\\u0430\\u0441\\u043f\\u0438\\u0441\\u0430\\u043d\\u0438\\u0435 \\u0440\\u0435\\u0439\\u0441\\u043e\\u0432\",\"sub_slug\":\"raspisania\"},{\"menu_title\":\"\\u041d\\u043e\\u0440\\u043c\\u044b \\u043f\\u0440\\u043e\\u0432\\u043e\\u0437\\u0430 \\u0431\\u0430\\u0433\\u0430\\u0436\\u0430\",\"sub_slug\":\"normy-provoza\"},{\"menu_title\":\"\\u0411\\u0438\\u0437\\u043d\\u0435\\u0441-\\u0437\\u0430\\u043b\",\"sub_slug\":\"biznes-zal\"}]', '', 1, 'passazhir', 1),
|
||
(2, '2023-06-26 05:05:38', '2023-06-26 05:11:28', NULL, 'Партнерам', '[{\"menu_title\":\"\\u041e\\u043d\\u043b\\u0430\\u0439\\u043d-\\u0442\\u0430\\u0431\\u043b\\u043e\",\"sub_slug\":\"online-table-partnery\"},{\"menu_title\":\"\\u0420\\u0430\\u0441\\u043f\\u0438\\u0441\\u0430\\u043d\\u0438\\u0435 \\u0440\\u0435\\u0439\\u0441\\u043e\\u0432\",\"sub_slug\":\"raspisania-partnery\"},{\"menu_title\":\"\\u0410\\u0432\\u0438\\u0430\\u043a\\u043e\\u043c\\u043f\\u0430\\u043d\\u0438\\u044f\\u043c\",\"sub_slug\":\"aviakompaniyam\"},{\"menu_title\":\"\\u0421\\u043b\\u0443\\u0436\\u0431\\u0430 \\u0441\\u043f\\u0435\\u0446\\u0442\\u0435\\u0445\\u043d\\u0438\\u043a\\u0438\",\"sub_slug\":\"sluzhba-spes\"},{\"menu_title\":\"\\u0410\\u0432\\u0430\\u0440\\u0438\\u0439\\u043d\\u043e-\\u0441\\u043f\\u0430\\u0441\\u0430\\u0442\\u0435\\u043b\\u044c\\u043d\\u0430\\u044f \\u0441\\u043b\\u0443\\u0436\\u0431\\u0430\",\"sub_slug\":\"avariyno-spasatel\"}]', '', 4, 'partnery', 1),
|
||
(3, '2023-06-26 05:12:11', '2023-06-26 05:12:21', NULL, 'О нас', '[{\"menu_title\":\"\\u0418\\u0441\\u0442\\u043e\\u0440\\u0438\\u044f \\u0430\\u044d\\u0440\\u043e\\u043f\\u043e\\u0440\\u0442\\u0430\",\"sub_slug\":\"istoriya\"},{\"menu_title\":\"\\u0410\\u0434\\u043c\\u0438\\u043d\\u0438\\u0441\\u0442\\u0440\\u0430\\u0446\\u0438\\u044f \\u0438 \\u0441\\u0442\\u0440\\u0443\\u043a\\u0442\\u0443\\u0440\\u0430 \\u0430\\u044d\\u0440\\u043e\\u043f\\u043e\\u0440\\u0442\\u0430\",\"sub_slug\":\"administrasiya-struktura\"}]', '', 2, 'o-nas', 1),
|
||
(4, '2023-06-26 05:14:07', '2023-06-26 05:14:07', NULL, 'Услуги', '[{\"menu_title\":\"\\u041c\\u0430\\u0433\\u0430\\u0437\\u0438\\u043d\\u044b \\u0438 \\u043a\\u0430\\u0444\\u0435\",\"sub_slug\":\"magaziny\"},{\"menu_title\":\"\\u0414\\u0435\\u0442\\u0441\\u043a\\u0430\\u044f \\u0438\\u0433\\u0440\\u043e\\u0432\\u0430\\u044f \\u0437\\u043e\\u043d\\u0430\",\"sub_slug\":\"detskaya\"},{\"menu_title\":\"CIP-\\u0437\\u0430\\u043b\",\"sub_slug\":\"cip-zal\"},{\"menu_title\":\"\\u041e\\u0442\\u0435\\u043b\\u0438\",\"sub_slug\":\"oteli\"},{\"menu_title\":\"\\u041f\\u0430\\u0440\\u043a\\u043e\\u0432\\u043a\\u0430 \\u043c\\u0430\\u0448\\u0438\\u043d\",\"sub_slug\":\"parkovka\"},{\"menu_title\":\"\\u041c\\u0435\\u0434\\u0438\\u0446\\u0438\\u043d\\u0441\\u043a\\u0430\\u044f \\u043f\\u043e\\u043c\\u043e\\u0449\\u044c\",\"sub_slug\":\"medsinskaya\"},{\"menu_title\":\"\\u041a\\u0430\\u043c\\u0435\\u0440\\u0430 \\u0445\\u0440\\u0430\\u043d\\u0435\\u043d\\u0438\\u044f\",\"sub_slug\":\"kamera\"}]', '', 3, 'uslugi', 1),
|
||
(5, '2023-06-26 05:15:52', '2023-06-26 05:17:27', NULL, 'Главная', '[]', '', 0, 'glavnaya', 0);
|
||
|
||
INSERT INTO `tps_airport_partners` (`id`, `created_at`, `updated_at`, `deleted_at`, `img`, `note`, `header`) VALUES
|
||
(1, '2023-06-25 18:36:30', '2023-06-26 05:38:11', NULL, '[{\"logo\":\"\\/partners\\/partners.png\",\"logo_note\":\"1\"},{\"logo\":\"\\/partners\\/partner2.png\",\"logo_note\":\"\"},{\"logo\":\"\\/partners\\/partner3.png\",\"logo_note\":\"\"},{\"logo\":\"\\/partners\\/partner4.png\",\"logo_note\":\"\"},{\"logo\":\"\\/partners\\/partner5.png\",\"logo_note\":\"\"},{\"logo\":\"\\/partners\\/partner6.png\",\"logo_note\":\"\"}]', 'Наши партнеры', 'Наши партнеры');
|
||
|
||
|
||
|
||
/*!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 */; |