Shohrat
/
tehnika
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
tehnika/october1.1.sql

947 lines
73 KiB
MySQL
Raw Permalink Normal View History

Add all my files
2022-10-24 05:35:18 +00:00
-- -------------------------------------------------------------
-- TablePlus 4.7.1(428)
--
-- https://tableplus.com/
--
-- Database: tehnika
-- Generation Time: 2022-10-24 09:22:16.4670
-- -------------------------------------------------------------
/*!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 `backend_access_log`;
CREATE TABLE `backend_access_log` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`user_id` int unsigned NOT NULL,
`ip_address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
DROP TABLE IF EXISTS `backend_user_groups`;
CREATE TABLE `backend_user_groups` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`code` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`description` text COLLATE utf8mb4_unicode_ci,
`is_new_user_default` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `name_unique` (`name`),
KEY `code_index` (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
DROP TABLE IF EXISTS `backend_user_preferences`;
CREATE TABLE `backend_user_preferences` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`user_id` int unsigned NOT NULL,
`namespace` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
`group` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
`item` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
`value` text COLLATE utf8mb4_unicode_ci,
PRIMARY KEY (`id`),
KEY `user_item_index` (`user_id`,`namespace`,`group`,`item`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
DROP TABLE IF EXISTS `backend_user_roles`;
CREATE TABLE `backend_user_roles` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`code` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`description` text COLLATE utf8mb4_unicode_ci,
`permissions` text COLLATE utf8mb4_unicode_ci,
`is_system` tinyint(1) NOT NULL DEFAULT '0',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `role_unique` (`name`),
KEY `role_code_index` (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
DROP TABLE IF EXISTS `backend_user_throttle`;
CREATE TABLE `backend_user_throttle` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`user_id` int unsigned DEFAULT NULL,
`ip_address` varchar(191) 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=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
DROP TABLE IF EXISTS `backend_users`;
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;
DROP TABLE IF EXISTS `backend_users_groups`;
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;
DROP TABLE IF EXISTS `cache`;
CREATE TABLE `cache` (
`key` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`value` longtext 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;
DROP TABLE IF EXISTS `cms_theme_data`;
CREATE TABLE `cms_theme_data` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`theme` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`data` mediumtext COLLATE utf8mb4_unicode_ci,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `cms_theme_data_theme_index` (`theme`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
DROP TABLE IF EXISTS `cms_theme_logs`;
CREATE TABLE `cms_theme_logs` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`type` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
`theme` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`template` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`old_template` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`content` longtext COLLATE utf8mb4_unicode_ci,
`old_content` longtext COLLATE utf8mb4_unicode_ci,
`user_id` int 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;
DROP TABLE IF EXISTS `cms_theme_templates`;
CREATE TABLE `cms_theme_templates` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`source` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`path` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`content` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`file_size` int 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;
DROP TABLE IF EXISTS `deferred_bindings`;
CREATE TABLE `deferred_bindings` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`master_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`master_field` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`slave_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`slave_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`pivot_data` mediumtext COLLATE utf8mb4_unicode_ci,
`session_key` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`is_bind` tinyint(1) NOT NULL DEFAULT '1',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
DROP TABLE IF EXISTS `failed_jobs`;
CREATE TABLE `failed_jobs` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
`queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
`payload` text COLLATE utf8mb4_unicode_ci NOT NULL,
`exception` longtext COLLATE utf8mb4_unicode_ci,
`failed_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
DROP TABLE IF EXISTS `jobs`;
CREATE TABLE `jobs` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`queue` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`payload` text 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;
DROP TABLE IF EXISTS `martin_forms_records`;
CREATE TABLE `martin_forms_records` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`group` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '(Empty)',
`form_data` text COLLATE utf8mb4_unicode_ci,
`ip` varchar(191) 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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
DROP TABLE IF EXISTS `migrations`;
CREATE TABLE `migrations` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`migration` varchar(191) 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;
DROP TABLE IF EXISTS `rainlab_blog_categories`;
CREATE TABLE `rainlab_blog_categories` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`slug` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`code` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`description` text 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;
DROP TABLE IF EXISTS `rainlab_blog_posts`;
CREATE TABLE `rainlab_blog_posts` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`user_id` int unsigned DEFAULT NULL,
`title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`slug` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`excerpt` text COLLATE utf8mb4_unicode_ci,
`content` longtext COLLATE utf8mb4_unicode_ci,
`content_html` longtext 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 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;
DROP TABLE IF EXISTS `rainlab_blog_posts_categories`;
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;
DROP TABLE IF EXISTS `rainlab_translate_attributes`;
CREATE TABLE `rainlab_translate_attributes` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`locale` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`model_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`model_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`attribute_data` mediumtext 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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
DROP TABLE IF EXISTS `rainlab_translate_indexes`;
CREATE TABLE `rainlab_translate_indexes` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`locale` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`model_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`model_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`item` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`value` mediumtext 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;
DROP TABLE IF EXISTS `rainlab_translate_locales`;
CREATE TABLE `rainlab_translate_locales` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`name` varchar(191) 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=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
DROP TABLE IF EXISTS `rainlab_translate_messages`;
CREATE TABLE `rainlab_translate_messages` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`code` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`message_data` mediumtext COLLATE utf8mb4_unicode_ci,
`found` tinyint(1) NOT NULL DEFAULT '1',
PRIMARY KEY (`id`),
KEY `rainlab_translate_messages_code_index` (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
DROP TABLE IF EXISTS `sessions`;
CREATE TABLE `sessions` (
`id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`payload` text COLLATE utf8mb4_unicode_ci,
`last_activity` int DEFAULT NULL,
`user_id` int unsigned DEFAULT NULL,
`ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`user_agent` text COLLATE utf8mb4_unicode_ci,
UNIQUE KEY `sessions_id_unique` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
DROP TABLE IF EXISTS `system_event_logs`;
CREATE TABLE `system_event_logs` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`level` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`message` text COLLATE utf8mb4_unicode_ci,
`details` mediumtext 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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
DROP TABLE IF EXISTS `system_files`;
CREATE TABLE `system_files` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`disk_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`file_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`file_size` int NOT NULL,
`content_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`description` text COLLATE utf8mb4_unicode_ci,
`field` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`attachment_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`attachment_type` varchar(191) 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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
DROP TABLE IF EXISTS `system_mail_layouts`;
CREATE TABLE `system_mail_layouts` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`code` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`content_html` text COLLATE utf8mb4_unicode_ci,
`content_text` text COLLATE utf8mb4_unicode_ci,
`content_css` text COLLATE utf8mb4_unicode_ci,
`is_locked` tinyint(1) NOT NULL DEFAULT '0',
`options` text COLLATE utf8mb4_unicode_ci,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
DROP TABLE IF EXISTS `system_mail_partials`;
CREATE TABLE `system_mail_partials` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`code` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`content_html` text COLLATE utf8mb4_unicode_ci,
`content_text` text 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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
DROP TABLE IF EXISTS `system_mail_templates`;
CREATE TABLE `system_mail_templates` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`code` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`subject` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`description` text COLLATE utf8mb4_unicode_ci,
`content_html` text COLLATE utf8mb4_unicode_ci,
`content_text` text 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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
DROP TABLE IF EXISTS `system_parameters`;
CREATE TABLE `system_parameters` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`namespace` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
`group` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
`item` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
`value` text COLLATE utf8mb4_unicode_ci,
PRIMARY KEY (`id`),
KEY `item_index` (`namespace`,`group`,`item`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
DROP TABLE IF EXISTS `system_plugin_history`;
CREATE TABLE `system_plugin_history` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`type` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
`version` varchar(50) 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=366 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
DROP TABLE IF EXISTS `system_plugin_versions`;
CREATE TABLE `system_plugin_versions` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`version` varchar(50) 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=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
DROP TABLE IF EXISTS `system_request_logs`;
CREATE TABLE `system_request_logs` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`status_code` int DEFAULT NULL,
`url` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`referer` text 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;
DROP TABLE IF EXISTS `system_revisions`;
CREATE TABLE `system_revisions` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`user_id` int unsigned DEFAULT NULL,
`field` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`cast` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`old_value` text COLLATE utf8mb4_unicode_ci,
`new_value` text COLLATE utf8mb4_unicode_ci,
`revisionable_type` varchar(191) 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;
DROP TABLE IF EXISTS `system_settings`;
CREATE TABLE `system_settings` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`item` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`value` mediumtext COLLATE utf8mb4_unicode_ci,
PRIMARY KEY (`id`),
KEY `system_settings_item_index` (`item`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
INSERT INTO `backend_access_log` (`id`, `user_id`, `ip_address`, `created_at`, `updated_at`) VALUES
(1, 1, '127.0.0.1', '2022-10-24 04:12:42', '2022-10-24 04:12:42');
INSERT INTO `backend_user_throttle` (`id`, `user_id`, `ip_address`, `attempts`, `last_attempt_at`, `is_suspended`, `suspended_at`, `is_banned`, `banned_at`) VALUES
(1, 1, '127.0.0.1', 0, NULL, 0, NULL, 0, NULL);
INSERT INTO `backend_users` (`id`, `first_name`, `last_name`, `login`, `email`, `password`, `activation_code`, `persist_code`, `reset_password_code`, `permissions`, `is_activated`, `role_id`, `activated_at`, `last_login`, `created_at`, `updated_at`, `deleted_at`, `is_superuser`) VALUES
(1, 'Admin', 'Person', 'admin', 'admin@domain.tld', '$2y$10$fGfsIo38M1WniqiIBeWtIe5jRnbAlufPqvbHZcIo45PZmvu/FIagS', NULL, '$2y$10$t/gbpSsY2rQzFcXD.UygduuexyU5YXOuY3TDldEnZz6m3CU2THvXy', NULL, '', 1, 2, NULL, '2022-10-24 04:12:42', '2022-06-24 12:15:58', '2022-10-24 04:12:42', NULL, 1);
INSERT INTO `migrations` (`id`, `migration`, `batch`) 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);
INSERT INTO `rainlab_blog_categories` (`id`, `name`, `slug`, `code`, `description`, `parent_id`, `nest_left`, `nest_right`, `nest_depth`, `created_at`, `updated_at`) VALUES
(1, 'Uncategorized', 'uncategorized', NULL, NULL, NULL, 1, 2, 0, '2022-10-24 04:13:20', '2022-10-24 04:13:20');
INSERT INTO `rainlab_blog_posts` (`id`, `user_id`, `title`, `slug`, `excerpt`, `content`, `content_html`, `published_at`, `published`, `created_at`, `updated_at`, `metadata`) 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-10-24 04:13:20', 1, '2022-10-24 04:13:20', '2022-10-24 04:13:20', NULL);
INSERT INTO `rainlab_translate_locales` (`id`, `code`, `name`, `is_default`, `is_enabled`, `sort_order`) VALUES
(1, 'en', 'English', 1, 1, 1);
INSERT INTO `system_parameters` (`id`, `namespace`, `group`, `item`, `value`) VALUES
(1, 'system', 'update', 'count', '0'),
(2, 'system', 'update', 'retry', '1666671165');
INSERT INTO `system_plugin_history` (`id`, `code`, `type`, `version`, `detail`, `created_at`) VALUES
(1, 'October.Demo', 'comment', '1.0.1', 'First version of Demo', '2022-10-23 16:11:38'),
(2, 'RainLab.Blog', 'script', '1.0.1', 'create_posts_table.php', '2022-10-24 04:13:20'),
(3, 'RainLab.Blog', 'script', '1.0.1', 'create_categories_table.php', '2022-10-24 04:13:20'),
(4, 'RainLab.Blog', 'script', '1.0.1', 'seed_all_tables.php', '2022-10-24 04:13:20'),
(5, 'RainLab.Blog', 'comment', '1.0.1', 'Initialize plugin.', '2022-10-24 04:13:20'),
(6, 'RainLab.Blog', 'comment', '1.0.2', 'Added the processed HTML content column to the posts table.', '2022-10-24 04:13:20'),
(7, 'RainLab.Blog', 'comment', '1.0.3', 'Category component has been merged with Posts component.', '2022-10-24 04:13:20'),
(8, 'RainLab.Blog', 'comment', '1.0.4', 'Improvements to the Posts list management UI.', '2022-10-24 04:13:20'),
(9, 'RainLab.Blog', 'comment', '1.0.5', 'Removes the Author column from blog post list.', '2022-10-24 04:13:20'),
(10, 'RainLab.Blog', 'comment', '1.0.6', 'Featured images now appear in the Post component.', '2022-10-24 04:13:20'),
(11, 'RainLab.Blog', 'comment', '1.0.7', 'Added support for the Static Pages menus.', '2022-10-24 04:13:20'),
(12, 'RainLab.Blog', 'comment', '1.0.8', 'Added total posts to category list.', '2022-10-24 04:13:20'),
(13, 'RainLab.Blog', 'comment', '1.0.9', 'Added support for the Sitemap plugin.', '2022-10-24 04:13:20'),
(14, 'RainLab.Blog', 'comment', '1.0.10', 'Added permission to prevent users from seeing posts they did not create.', '2022-10-24 04:13:20'),
(15, 'RainLab.Blog', 'comment', '1.0.11', 'Deprecate \"idParam\" component property in favour of \"slug\" property.', '2022-10-24 04:13:20'),
(16, 'RainLab.Blog', 'comment', '1.0.12', 'Fixes issue where images cannot be uploaded caused by latest Markdown library.', '2022-10-24 04:13:20'),
(17, 'RainLab.Blog', 'comment', '1.0.13', 'Fixes problem with providing pages to Sitemap and Pages plugins.', '2022-10-24 04:13:20'),
(18, 'RainLab.Blog', 'comment', '1.0.14', 'Add support for CSRF protection feature added to core.', '2022-10-24 04:13:20'),
(19, 'RainLab.Blog', 'comment', '1.1.0', 'Replaced the Post editor with the new core Markdown editor.', '2022-10-24 04:13:20'),
(20, 'RainLab.Blog', 'comment', '1.1.1', 'Posts can now be imported and exported.', '2022-10-24 04:13:20'),
(21, 'RainLab.Blog', 'comment', '1.1.2', 'Posts are no longer visible if the published date has not passed.', '2022-10-24 04:13:20'),
(22, 'RainLab.Blog', 'comment', '1.1.3', 'Added a New Post shortcut button to the blog menu.', '2022-10-24 04:13:20'),
(23, 'RainLab.Blog', 'script', '1.2.0', 'categories_add_nested_fields.php', '2022-10-24 04:13:20'),
(24, 'RainLab.Blog', 'comment', '1.2.0', 'Categories now support nesting.', '2022-10-24 04:13:20'),
(25, 'RainLab.Blog', 'comment', '1.2.1', 'Post slugs now must be unique.', '2022-10-24 04:13:20'),
(26, 'RainLab.Blog', 'comment', '1.2.2', 'Fixes issue on new installs.', '2022-10-24 04:13:20'),
(27, 'RainLab.Blog', 'comment', '1.2.3', 'Minor user interface update.', '2022-10-24 04:13:20'),
(28, 'RainLab.Blog', 'script', '1.2.4', 'update_timestamp_nullable.php', '2022-10-24 04:13:20'),
(29, 'RainLab.Blog', 'comment', '1.2.4', 'Database maintenance. Updated all timestamp columns to be nullable.', '2022-10-24 04:13:20'),
(30, 'RainLab.Blog', 'comment', '1.2.5', 'Added translation support for blog posts.', '2022-10-24 04:13:20'),
(31, 'RainLab.Blog', 'comment', '1.2.6', 'The published field can now supply a time with the date.', '2022-10-24 04:13:20'),
(32, 'RainLab.Blog', 'comment', '1.2.7', 'Introduced a new RSS feed component.', '2022-10-24 04:13:20'),
(33, 'RainLab.Blog', 'comment', '1.2.8', 'Fixes issue with translated `content_html` attribute on blog posts.', '2022-10-24 04:13:20'),
(34, 'RainLab.Blog', 'comment', '1.2.9', 'Added translation support for blog categories.', '2022-10-24 04:13:20'),
(35, 'RainLab.Blog', 'comment', '1.2.10', 'Added translation support for post slugs.', '2022-10-24 04:13:20'),
(36, 'RainLab.Blog', 'comment', '1.2.11', 'Fixes bug where excerpt is not translated.', '2022-10-24 04:13:20'),
(37, 'RainLab.Blog', 'comment', '1.2.12', 'Description field added to category form.', '2022-10-24 04:13:20'),
(38, 'RainLab.Blog', 'comment', '1.2.13', 'Improved support for Static Pages menus, added a blog post and all blog posts.', '2022-10-24 04:13:20'),
(39, 'RainLab.Blog', 'comment', '1.2.14', 'Added post exception property to the post list component, useful for showing related posts.', '2022-10-24 04:13:20'),
(40, 'RainLab.Blog', 'comment', '1.2.15', 'Back-end navigation sort order updated.', '2022-10-24 04:13:20'),
(41, 'RainLab.Blog', 'comment', '1.2.16', 'Added `nextPost` and `previousPost` to the blog post component.', '2022-10-24 04:13:20'),
(42, 'RainLab.Blog', 'comment', '1.2.17', 'Improved the next and previous logic to sort by the published date.', '2022-10-24 04:13:20'),
(43, 'RainLab.Blog', 'comment', '1.2.18', 'Minor change to internals.', '2022-10-24 04:13:20'),
(44, 'RainLab.Blog', 'comment', '1.2.19', 'Improved support for Build 420+', '2022-10-24 04:13:20'),
(45, 'RainLab.Blog', 'script', '1.3.0', 'posts_add_metadata.php', '2022-10-24 04:13:20'),
(46, 'RainLab.Blog', 'comment', '1.3.0', 'Added metadata column for plugins to store data in', '2022-10-24 04:13:20'),
(47, 'RainLab.Blog', 'comment', '1.3.1', 'Fixed metadata column not being jsonable', '2022-10-24 04:13:20'),
(48, 'RainLab.Blog', 'comment', '1.3.2', 'Allow custom slug name for components, add 404 handling for missing blog posts, allow exporting of blog images.', '2022-10-24 04:13:20'),
(49, 'RainLab.Blog', 'comment', '1.3.3', 'Fixed \'excluded categories\' filter from being run when value is empty.', '2022-10-24 04:13:20'),
(50, 'RainLab.Blog', 'comment', '1.3.4', 'Allow post author to be specified. Improved translations.', '2022-10-24 04:13:20'),
(51, 'RainLab.Blog', 'comment', '1.3.5', 'Fixed missing user info from breaking initial seeder in migrations. Fixed a PostgreSQL issue with blog exports.', '2022-10-24 04:13:20'),
(52, 'RainLab.Blog', 'comment', '1.3.6', 'Improved French translations.', '2022-10-24 04:13:20'),
(53, 'RainLab.Blog', 'comment', '1.4.0', 'Stability improvements. Rollback custom slug names for components', '2022-10-24 04:13:20'),
(54, 'RainLab.Blog', 'comment', '1.4.1', 'Fixes potential security issue with unsafe Markdown. Allow blog bylines to be translated.', '2022-10-24 04:13:20'),
(55, 'RainLab.Blog', 'comment', '1.4.2', 'Fix 404 redirects for missing blog posts. Assign current category to the listed posts when using the Posts component on a page with the category parameter available.', '2022-10-24 04:13:20'),
(56, 'RainLab.Blog', 'comment', '1.4.3', 'Fixes incompatibility with locale switching when plugin is used in conjunction with the Translate plugin. Fixes undefined category error.', '2022-10-24 04:13:20'),
(57, 'RainLab.Blog', 'comment', '1.4.4', 'Rollback translated bylines, please move or override the default component markup instead.', '2022-10-24 04:13:20'),
(58, 'RainLab.Blog', 'comment', '1.5.0', 'Implement support for October CMS v2.0', '2022-10-24 04:13:20'),
(59, 'RainLab.Blog', 'comment', '1.5.1', 'Fixes interaction with Translate plugin', '2022-10-24 04:13:20'),
(60, 'RainLab.Blog', 'comment', '1.5.2', 'Minor styling improvements', '2022-10-24 04:13:20'),
(61, 'RainLab.Blog', 'comment', '1.5.3', 'Adds setting to use legacy markdown editor', '2022-10-24 04:13:20'),
(62, 'RainLab.Blog', 'comment', '1.5.4', 'Compatibility with October CMS v2.2', '2022-10-24 04:13:20'),
(63, 'RainLab.Blog', 'comment', '1.5.6', 'Compatibility with October CMS v3.0', '2022-10-24 04:13:20'),
(64, 'RainLab.Blog', 'comment', '1.6.0', 'Adds preview CMS page to settings and preview button to posts page', '2022-10-24 04:13:20'),
(65, 'RainLab.Blog', 'comment', '1.6.1', 'Fixes JS error when uploading images in newer versions', '2022-10-24 04:13:20'),
(66, 'RainLab.Blog', 'comment', '1.6.2', 'Fixes content_html attribute compatibility with Translate', '2022-10-24 04:13:20'),
(67, 'RainLab.Pages', 'comment', '1.0.1', 'Implemented the static pages management and the Static Page component.', '2022-10-24 04:13:47'),
(68, 'RainLab.Pages', 'comment', '1.0.2', 'Fixed the page preview URL.', '2022-10-24 04:13:47'),
(69, 'RainLab.Pages', 'comment', '1.0.3', 'Implemented menus.', '2022-10-24 04:13:47'),
(70, 'RainLab.Pages', 'comment', '1.0.4', 'Implemented the content block management and placeholder support.', '2022-10-24 04:13:47'),
(71, 'RainLab.Pages', 'comment', '1.0.5', 'Added support for the Sitemap plugin.', '2022-10-24 04:13:47'),
(72, 'RainLab.Pages', 'comment', '1.0.6', 'Minor updates to the internal API.', '2022-10-24 04:13:47'),
(73, 'RainLab.Pages', 'comment', '1.0.7', 'Added the Snippets feature.', '2022-10-24 04:13:47'),
(74, 'RainLab.Pages', 'comment', '1.0.8', 'Minor improvements to the code.', '2022-10-24 04:13:47'),
(75, 'RainLab.Pages', 'comment', '1.0.9', 'Fixes issue where Snippet tab is missing from the Partials form.', '2022-10-24 04:13:47'),
(76, 'RainLab.Pages', 'comment', '1.0.10', 'Add translations for various locales.', '2022-10-24 04:13:47'),
(77, 'RainLab.Pages', 'comment', '1.0.11', 'Fixes issue where placeholders tabs were missing from Page form.', '2022-10-24 04:13:47'),
(78, 'RainLab.Pages', 'comment', '1.0.12', 'Implement Media Manager support.', '2022-10-24 04:13:47'),
(79, 'RainLab.Pages', 'script', '1.1.0', 'snippets_rename_viewbag_properties.php', '2022-10-24 04:13:47'),
(80, 'RainLab.Pages', 'comment', '1.1.0', 'Adds meta title and description to pages. Adds |staticPage filter.', '2022-10-24 04:13:47'),
(81, 'RainLab.Pages', 'comment', '1.1.1', 'Add support for Syntax Fields.', '2022-10-24 04:13:47'),
(82, 'RainLab.Pages', 'comment', '1.1.2', 'Static Breadcrumbs component now respects the hide from navigation setting.', '2022-10-24 04:13:47'),
(83, 'RainLab.Pages', 'comment', '1.1.3', 'Minor back-end styling fix.', '2022-10-24 04:13:47'),
(84, 'RainLab.Pages', 'comment', '1.1.4', 'Minor fix to the StaticPage component API.', '2022-10-24 04:13:47'),
(85, 'RainLab.Pages', 'comment', '1.1.5', 'Fixes bug when using syntax fields.', '2022-10-24 04:13:47'),
(86, 'RainLab.Pages', 'comment', '1.1.6', 'Minor styling fix to the back-end UI.', '2022-10-24 04:13:47'),
(87, 'RainLab.Pages', 'comment', '1.1.7', 'Improved menu item form to include CSS class, open in a new window and hidden flag.', '2022-10-24 04:13:47'),
(88, 'RainLab.Pages', 'comment', '1.1.8', 'Improved the output of snippet partials when saved.', '2022-10-24 04:13:47'),
(89, 'RainLab.Pages', 'comment', '1.1.9', 'Minor update to snippet inspector internal API.', '2022-10-24 04:13:47'),
(90, 'RainLab.Pages', 'comment', '1.1.10', 'Fixes a bug where selecting a layout causes permanent unsaved changes.', '2022-10-24 04:13:47'),
(91, 'RainLab.Pages', 'comment', '1.1.11', 'Add support for repeater syntax field.', '2022-10-24 04:13:47'),
(92, 'RainLab.Pages', 'comment', '1.2.0', 'Added support for translations, UI updates.', '2022-10-24 04:13:47'),
(93, 'RainLab.Pages', 'comment', '1.2.1', 'Use nice titles when listing the content files.', '2022-10-24 04:13:48'),
(94, 'RainLab.Pages', 'comment', '1.2.2', 'Minor styling update.', '2022-10-24 04:13:48'),
(95, 'RainLab.Pages', 'comment', '1.2.3', 'Snippets can now be moved by dragging them.', '2022-10-24 04:13:48'),
(96, 'RainLab.Pages', 'comment', '1.2.4', 'Fixes a bug where the cursor is misplaced when editing text files.', '2022-10-24 04:13:48'),
(97, 'RainLab.Pages', 'comment', '1.2.5', 'Fixes a bug where the parent page is lost upon changing a page layout.', '2022-10-24 04:13:48'),
(98, 'RainLab.Pages', 'comment', '1.2.6', 'Shared view variables are now passed to static pages.', '2022-10-24 04:13:48'),
(99, 'RainLab.Pages', 'comment', '1.2.7', 'Fixes issue with duplicating properties when adding multiple snippets on the same page.', '2022-10-24 04:13:48'),
(100, 'RainLab.Pages', 'comment', '1.2.8', 'Fixes a bug where creating a content block without extension doesn\'t save the contents to file.', '2022-10-24 04:13:48'),
(101, 'RainLab.Pages', 'comment', '1.2.9', 'Add conditional support for translating page URLs.', '2022-10-24 04:13:48'),
(102, 'RainLab.Pages', 'comment', '1.2.10', 'Streamline generation of URLs to use the new Cms::url helper.', '2022-10-24 04:13:48'),
(103, 'RainLab.Pages', 'comment', '1.2.11', 'Implements repeater usage with translate plugin.', '2022-10-24 04:13:48'),
(104, 'RainLab.Pages', 'comment', '1.2.12', 'Fixes minor issue when using snippets and switching the application locale.', '2022-10-24 04:13:48'),
(105, 'RainLab.Pages', 'comment', '1.2.13', 'Fixes bug when AJAX is used on a page that does not yet exist.', '2022-10-24 04:13:48'),
(106, 'RainLab.Pages', 'comment', '1.2.14', 'Add theme logging support for changes made to menus.', '2022-10-24 04:13:48'),
(107, 'RainLab.Pages', 'comment', '1.2.15', 'Back-end navigation sort order updated.', '2022-10-24 04:13:48'),
(108, 'RainLab.Pages', 'comment', '1.2.16', 'Fixes a bug when saving a template that has been modified outside of the CMS (mtime mismatch).', '2022-10-24 04:13:48'),
(109, 'RainLab.Pages', 'comment', '1.2.17', 'Changes locations of custom fields to secondary tabs instead of the primary Settings area. New menu search ability on adding menu items', '2022-10-24 04:13:48'),
(110, 'RainLab.Pages', 'comment', '1.2.18', 'Fixes cache-invalidation issues when RainLab.Translate is not installed. Added Greek & Simplified Chinese translations. Removed deprecated calls. Allowed saving HTML in snippet properties. Added support for the MediaFinder in menu items.', '2022-10-24 04:13:48'),
(111, 'RainLab.Pages', 'comment', '1.2.19', 'Catch exception with corrupted menu file.', '2022-10-24 04:13:48'),
(112, 'RainLab.Pages', 'comment', '1.2.20', 'StaticMenu component now exposes menuName property; added pages.menu.referencesGenerated event.', '2022-10-24 04:13:48'),
(113, 'RainLab.Pages', 'comment', '1.2.21', 'Fixes a bug where last Static Menu item cannot be deleted. Improved Persian, Slovak and Turkish translations.', '2022-10-24 04:13:48'),
(114, 'RainLab.Pages', 'comment', '1.3.0', 'Added support for using Database-driven Themes when enabled in the CMS configuration.', '2022-10-24 04:13:48'),
(115, 'RainLab.Pages', 'comment', '1.3.1', 'Added ChildPages Component, prevent hidden pages from being returned via menu item resolver.', '2022-10-24 04:13:48'),
(116, 'RainLab.Pages', 'comment', '1.3.2', 'Fixes error when creating a subpage whose parent has no layout set.', '2022-10-24 04:13:48'),
(117, 'RainLab.Pages', 'comment', '1.3.3', 'Improves user experience for users with only partial access through permissions', '2022-10-24 04:13:48'),
(118, 'RainLab.Pages', 'comment', '1.3.4', 'Fix error where large menus were being truncated due to the PHP \"max_input_vars\" configuration value. Improved Slovenian translation.', '2022-10-24 04:13:48'),
(119, 'RainLab.Pages', 'comment', '1.3.5', 'Minor fix to bust the browser cache for JS assets. Prevent duplicate property fields in snippet inspector.', '2022-10-24 04:13:48'),
(120, 'RainLab.Pages', 'comment', '1.3.6', 'ChildPages component now displays localized page titles from Translate plugin.', '2022-10-24 04:13:48'),
(121, 'RainLab.Pages', 'comment', '1.3.7', 'Adds MenuPicker formwidget. Adds future support for v2.0 of October CMS.', '2022-10-24 04:13:48'),
(122, 'RainLab.Pages', 'comment', '1.4.0', 'Fixes bug when adding menu items in October CMS v2.0.', '2022-10-24 04:13:48'),
(123, 'RainLab.Pages', 'comment', '1.4.1', 'Fixes support for configuration values.', '2022-10-24 04:13:48'),
(124, 'RainLab.Pages', 'comment', '1.4.3', 'Fixes page deletion is newer platform builds.', '2022-10-24 04:13:48'),
(125, 'RainLab.Pages', 'comment', '1.4.4', 'Disable touch device detection', '2022-10-24 04:13:48'),
(126, 'RainLab.Pages', 'comment', '1.4.5', 'Minor styling improvements', '2022-10-24 04:13:48'),
(127, 'RainLab.Pages', 'comment', '1.4.6', 'Minor styling improvements', '2022-10-24 04:13:48'),
(128, 'RainLab.Pages', 'comment', '1.4.7', 'Minor layout fix in the Page editor', '2022-10-24 04:13:48'),
(129, 'RainLab.Pages', 'comment', '1.4.8', 'Fixes rich editor usage inside repeaters. Adds getProcessedMarkup event.', '2022-10-24 04:13:48'),
(130, 'RainLab.Pages', 'comment', '1.4.9', 'Fixes a lifecycle issue when switching the page layout.', '2022-10-24 04:13:48'),
(131, 'RainLab.Pages', 'comment', '1.4.10', 'Fixes maintenance mode when using static pages.', '2022-10-24 04:13:48'),
(132, 'RainLab.Pages', 'comment', '1.4.11', 'Adds type hidden to content placeholders.', '2022-10-24 04:13:48'),
(133, 'RainLab.Pages', 'comment', '1.4.12', 'Improve support with October v2.2', '2022-10-24 04:13:48'),
(134, 'RainLab.Pages', 'comment', '1.5.0', 'Improve support with October v3.0', '2022-10-24 04:13:48'),
(135, 'RainLab.Pages', 'comment', '1.5.4', 'Compatibility updates', '2022-10-24 04:13:48'),
(136, 'RainLab.Pages', 'comment', '1.5.5', 'Fixes media finder added to menu in October v2', '2022-10-24 04:13:48'),
(137, 'RainLab.Translate', 'script', '1.0.1', 'create_messages_table.php', '2022-10-24 04:14:14'),
(138, 'RainLab.Translate', 'script', '1.0.1', 'create_attributes_table.php', '2022-10-24 04:14:14'),
(139, 'RainLab.Translate', 'script', '1.0.1', 'create_locales_table.php', '2022-10-24 04:14:15'),
(140, 'RainLab.Translate', 'comment', '1.0.1', 'First version of Translate', '2022-10-24 04:14:15'),
(141, 'RainLab.Translate', 'comment', '1.0.2', 'Languages and Messages can now be deleted.', '2022-10-24 04:14:15'),
(142, 'RainLab.Translate', 'comment', '1.0.3', 'Minor updates for latest October release.', '2022-10-24 04:14:15'),
(143, 'RainLab.Translate', 'comment', '1.0.4', 'Locale cache will clear when updating a language.', '2022-10-24 04:14:15'),
(144, 'RainLab.Translate', 'comment', '1.0.5', 'Add Spanish language and fix plugin config.', '2022-10-24 04:14:15'),
(145, 'RainLab.Translate', 'comment', '1.0.6', 'Minor improvements to the code.', '2022-10-24 04:14:15'),
(146, 'RainLab.Translate', 'comment', '1.0.7', 'Fixes major bug where translations are skipped entirely!', '2022-10-24 04:14:15'),
(147, 'RainLab.Translate', 'comment', '1.0.8', 'Minor bug fixes.', '2022-10-24 04:14:15'),
(148, 'RainLab.Translate', 'comment', '1.0.9', 'Fixes an issue where newly created models lose their translated values.', '2022-10-24 04:14:15'),
(149, 'RainLab.Translate', 'comment', '1.0.10', 'Minor fix for latest build.', '2022-10-24 04:14:15'),
(150, 'RainLab.Translate', 'comment', '1.0.11', 'Fix multilingual rich editor when used in stretch mode.', '2022-10-24 04:14:15'),
(151, 'RainLab.Translate', 'comment', '1.1.0', 'Introduce compatibility with RainLab.Pages plugin.', '2022-10-24 04:14:15'),
(152, 'RainLab.Translate', 'comment', '1.1.1', 'Minor UI fix to the language picker.', '2022-10-24 04:14:15'),
(153, 'RainLab.Translate', 'comment', '1.1.2', 'Add support for translating Static Content files.', '2022-10-24 04:14:15'),
(154, 'RainLab.Translate', 'comment', '1.1.3', 'Improved support for the multilingual rich editor.', '2022-10-24 04:14:15'),
(155, 'RainLab.Translate', 'comment', '1.1.4', 'Adds new multilingual markdown editor.', '2022-10-24 04:14:15'),
(156, 'RainLab.Translate', 'comment', '1.1.5', 'Minor update to the multilingual control API.', '2022-10-24 04:14:15'),
(157, 'RainLab.Translate', 'comment', '1.1.6', 'Minor improvements in the message editor.', '2022-10-24 04:14:15'),
(158, 'RainLab.Translate', 'comment', '1.1.7', 'Fixes bug not showing content when first loading multilingual textarea controls.', '2022-10-24 04:14:15'),
(159, 'RainLab.Translate', 'comment', '1.2.0', 'CMS pages now support translating the URL.', '2022-10-24 04:14:15'),
(160, 'RainLab.Translate', 'comment', '1.2.1', 'Minor update in the rich editor and code editor language control position.', '2022-10-24 04:14:15'),
(161, 'RainLab.Translate', 'comment', '1.2.2', 'Static Pages now support translating the URL.', '2022-10-24 04:14:15'),
(162, 'RainLab.Translate', 'comment', '1.2.3', 'Fixes Rich Editor when inserting a page link.', '2022-10-24 04:14:15'),
(163, 'RainLab.Translate', 'script', '1.2.4', 'create_indexes_table.php', '2022-10-24 04:14:15'),
(164, 'RainLab.Translate', 'comment', '1.2.4', 'Translatable attributes can now be declared as indexes.', '2022-10-24 04:14:15'),
(165, 'RainLab.Translate', 'comment', '1.2.5', 'Adds new multilingual repeater form widget.', '2022-10-24 04:14:15'),
(166, 'RainLab.Translate', 'comment', '1.2.6', 'Fixes repeater usage with static pages plugin.', '2022-10-24 04:14:15'),
(167, 'RainLab.Translate', 'comment', '1.2.7', 'Fixes placeholder usage with static pages plugin.', '2022-10-24 04:14:15'),
(168, 'RainLab.Translate', 'comment', '1.2.8', 'Improvements to code for latest October build compatibility.', '2022-10-24 04:14:15'),
(169, 'RainLab.Translate', 'comment', '1.2.9', 'Fixes context for translated strings when used with Static Pages.', '2022-10-24 04:14:15'),
(170, 'RainLab.Translate', 'comment', '1.2.10', 'Minor UI fix to the multilingual repeater.', '2022-10-24 04:14:15'),
(171, 'RainLab.Translate', 'comment', '1.2.11', 'Fixes translation not working with partials loaded via AJAX.', '2022-10-24 04:14:15'),
(172, 'RainLab.Translate', 'comment', '1.2.12', 'Add support for translating the new grouped repeater feature.', '2022-10-24 04:14:15'),
(173, 'RainLab.Translate', 'comment', '1.3.0', 'Added search to the translate messages page.', '2022-10-24 04:14:15'),
(174, 'RainLab.Translate', 'script', '1.3.1', 'builder_table_update_rainlab_translate_locales.php', '2022-10-24 04:14:15'),
(175, 'RainLab.Translate', 'script', '1.3.1', 'seed_all_tables.php', '2022-10-24 04:14:15'),
(176, 'RainLab.Translate', 'comment', '1.3.1', 'Added reordering to languages', '2022-10-24 04:14:15'),
(177, 'RainLab.Translate', 'comment', '1.3.2', 'Improved compatibility with RainLab.Pages, added ability to scan Mail Messages for translatable variables.', '2022-10-24 04:14:15'),
(178, 'RainLab.Translate', 'comment', '1.3.3', 'Fix to the locale picker session handling in Build 420 onwards.', '2022-10-24 04:14:15'),
(179, 'RainLab.Translate', 'comment', '1.3.4', 'Add alternate hreflang elements and adds prefixDefaultLocale setting.', '2022-10-24 04:14:15'),
(180, 'RainLab.Translate', 'comment', '1.3.5', 'Fix MLRepeater bug when switching locales.', '2022-10-24 04:14:15'),
(181, 'RainLab.Translate', 'comment', '1.3.6', 'Fix Middleware to use the prefixDefaultLocale setting introduced in 1.3.4', '2022-10-24 04:14:15'),
(182, 'RainLab.Translate', 'comment', '1.3.7', 'Fix config reference in LocaleMiddleware', '2022-10-24 04:14:15'),
(183, 'RainLab.Translate', 'comment', '1.3.8', 'Keep query string when switching locales', '2022-10-24 04:14:15'),
(184, 'RainLab.Translate', 'comment', '1.4.0', 'Add importer and exporter for messages', '2022-10-24 04:14:15'),
(185, 'RainLab.Translate', 'comment', '1.4.1', 'Updated Hungarian translation. Added Arabic translation. Fixed issue where default texts are overwritten by import. Fixed issue where the language switcher for repeater fields would overlap with the first repeater row.', '2022-10-24 04:14:15'),
(186, 'RainLab.Translate', 'comment', '1.4.2', 'Add multilingual MediaFinder', '2022-10-24 04:14:15'),
(187, 'RainLab.Translate', 'comment', '1.4.3', '!!! Please update OctoberCMS to Build 444 before updating this plugin. Added ability to translate CMS Pages fields (e.g. title, description, meta-title, meta-description)', '2022-10-24 04:14:15'),
(188, 'RainLab.Translate', 'comment', '1.4.4', 'Minor improvements to compatibility with Laravel framework.', '2022-10-24 04:14:15'),
(189, 'RainLab.Translate', 'comment', '1.4.5', 'Fixed issue when using the language switcher', '2022-10-24 04:14:15'),
(190, 'RainLab.Translate', 'comment', '1.5.0', 'Compatibility fix with Build 451', '2022-10-24 04:14:15'),
(191, 'RainLab.Translate', 'comment', '1.6.0', 'Make File Upload widget properties translatable. Merge Repeater core changes into MLRepeater widget. Add getter method to retrieve original translate data.', '2022-10-24 04:14:15'),
(192, 'RainLab.Translate', 'comment', '1.6.1', 'Add ability for models to provide translated computed data, add option to disable locale prefix routing', '2022-10-24 04:14:15'),
(193, 'RainLab.Translate', 'comment', '1.6.2', 'Implement localeUrl filter, add per-locale theme configuration support', '2022-10-24 04:14:15'),
(194, 'RainLab.Translate', 'comment', '1.6.3', 'Add eager loading for translations, restore support for accessors & mutators', '2022-10-24 04:14:15'),
(195, 'RainLab.Translate', 'comment', '1.6.4', 'Fixes PHP 7.4 compatibility', '2022-10-24 04:14:15'),
(196, 'RainLab.Translate', 'comment', '1.6.5', 'Fixes compatibility issue when other plugins use a custom model morph map', '2022-10-24 04:14:15'),
(197, 'RainLab.Translate', 'script', '1.6.6', 'migrate_morphed_attributes.php', '2022-10-24 04:14:15'),
(198, 'RainLab.Translate', 'comment', '1.6.6', 'Introduce migration to patch existing translations using morph map', '2022-10-24 04:14:15'),
(199, 'RainLab.Translate', 'script', '1.6.7', 'migrate_morphed_indexes.php', '2022-10-24 04:14:15'),
(200, 'RainLab.Translate', 'comment', '1.6.7', 'Introduce migration to patch existing indexes using morph map', '2022-10-24 04:14:15'),
(201, 'RainLab.Translate', 'comment', '1.6.8', 'Add support for transOrderBy; Add translation support for ThemeData; Update russian localization.', '2022-10-24 04:14:15'),
(202, 'RainLab.Translate', 'comment', '1.6.9', 'Clear Static Page menu cache after saving the model; CSS fix for Text/Textarea input fields language selector.', '2022-10-24 04:14:15'),
(203, 'RainLab.Translate', 'script', '1.6.10', 'update_messages_table.php', '2022-10-24 04:14:15'),
(204, 'RainLab.Translate', 'comment', '1.6.10', 'Add option to purge deleted messages when scanning messages, Add Scan error column on Messages page, Fix translations that were lost when clicking locale twice while holding ctrl key, Fix error with nested fields default locale value, Escape Message translate params value.', '2022-10-24 04:14:15'),
(205, 'RainLab.Translate', 'comment', '1.7.0', '!!! Breaking change for the Message::trans() method (params are now escaped), fix message translation documentation, fix string translation key for scan errors column header.', '2022-10-24 04:14:15'),
(206, 'RainLab.Translate', 'comment', '1.7.1', 'Fix YAML issue with previous tag/release.', '2022-10-24 04:14:15'),
(207, 'RainLab.Translate', 'comment', '1.7.2', 'Fix regex when \"|_\" filter is followed by another filter, Try locale without country before returning default translation, Allow exporting default locale, Fire \'rainlab.translate.themeScanner.afterScan\' event in the theme scanner for extendability.', '2022-10-24 04:14:15'),
(208, 'RainLab.Translate', 'comment', '1.7.3', 'Make plugin ready for Laravel 6 update, Add support for translating RainLab.Pages MenuItem properties (requires RainLab.Pages v1.3.6), Restore multilingual button position for textarea, Fix translatableAttributes.', '2022-10-24 04:14:15'),
(209, 'RainLab.Translate', 'comment', '1.7.4', 'Faster version of transWhere, Mail templates/views can now be localized, Fix messages table layout on mobile, Fix scopeTransOrderBy duplicates, Polish localization updates, Turkish localization updates, Add Greek language localization.', '2022-10-24 04:14:15'),
(210, 'RainLab.Translate', 'comment', '1.8.0', 'Adds initial support for October v2.0', '2022-10-24 04:14:15'),
(211, 'RainLab.Translate', 'comment', '1.8.1', 'Minor bugfix', '2022-10-24 04:14:15'),
(212, 'RainLab.Translate', 'comment', '1.8.2', 'Fixes translated file models and theme data for v2.0. The parent model must implement translatable behavior for their related file models to be translated.', '2022-10-24 04:14:15'),
(213, 'RainLab.Translate', 'comment', '1.8.4', 'Fixes the multilingual mediafinder to work with the media module.', '2022-10-24 04:14:15'),
(214, 'RainLab.Translate', 'comment', '1.8.6', 'Fixes invisible checkboxes when scanning for messages.', '2022-10-24 04:14:15'),
(215, 'RainLab.Translate', 'comment', '1.8.7', 'Fixes Markdown editor translation.', '2022-10-24 04:14:15'),
(216, 'RainLab.Translate', 'comment', '1.8.8', 'Fixes Laravel compatibility in custom Repeater.', '2022-10-24 04:14:15'),
(217, 'RainLab.Translate', 'comment', '1.9.0', 'Restores ability to translate URLs with CMS Editor in October v2.0', '2022-10-24 04:14:15'),
(218, 'RainLab.Translate', 'comment', '1.9.1', 'Minor styling improvements', '2022-10-24 04:14:15'),
(219, 'RainLab.Translate', 'comment', '1.9.2', 'Fixes issue creating new content in CMS Editor', '2022-10-24 04:14:15'),
(220, 'RainLab.Translate', 'comment', '1.9.3', 'Improves support when using child themes', '2022-10-24 04:14:15'),
(221, 'RainLab.Translate', 'comment', '1.10.0', 'Adds new multilingual nested form widget. Adds withFallbackLocale method.', '2022-10-24 04:14:15'),
(222, 'RainLab.Translate', 'comment', '1.10.1', 'Improve support with October v2.0', '2022-10-24 04:14:15'),
(223, 'RainLab.Translate', 'comment', '1.10.2', 'Improve support with October v2.2', '2022-10-24 04:14:15'),
(224, 'RainLab.Translate', 'comment', '1.10.3', 'Multilingual control improvements', '2022-10-24 04:14:15'),
(225, 'RainLab.Translate', 'comment', '1.10.4', 'Improve media finder support with October v2.2', '2022-10-24 04:14:15'),
(226, 'RainLab.Translate', 'comment', '1.10.5', 'Fixes media finder when only 1 locale is available', '2022-10-24 04:14:15'),
(227, 'RainLab.Translate', 'comment', '1.11.0', 'Update to latest Media Finder changes in October v2.2', '2022-10-24 04:14:15'),
(228, 'RainLab.Translate', 'comment', '1.11.1', 'Improve support with October v3.0', '2022-10-24 04:14:15'),
(229, 'RainLab.Translate', 'comment', '1.12.0', 'Adds scopeTransWhereNoFallback method', '2022-10-24 04:14:15'),
(230, 'Indikator.DevTools', 'comment', '1.0.0', 'First version of Developer Tools.', '2022-10-24 04:14:44'),
(231, 'Indikator.DevTools', 'comment', '1.1.0', 'Edit plugins with the code editor.', '2022-10-24 04:14:44'),
(232, 'Indikator.DevTools', 'comment', '1.1.1', 'Translate some English texts.', '2022-10-24 04:14:44'),
(233, 'Indikator.DevTools', 'comment', '1.1.2', 'Fixed the Create file issue.', '2022-10-24 04:14:44'),
(234, 'Indikator.DevTools', 'comment', '1.1.3', 'Added new icon for main navigation.', '2022-10-24 04:14:44'),
(235, 'Indikator.DevTools', 'comment', '1.1.4', 'Show the PHP\'s configuration.', '2022-10-24 04:14:44'),
(236, 'Indikator.DevTools', 'comment', '1.1.5', 'Minor code improvements and bugfix.', '2022-10-24 04:14:44'),
(237, 'Indikator.DevTools', 'comment', '1.1.6', 'The top menu icon shows again.', '2022-10-24 04:14:44'),
(238, 'Indikator.DevTools', 'comment', '1.1.7', 'Fixed the Create folder issue.', '2022-10-24 04:14:44'),
(239, 'Indikator.DevTools', 'comment', '1.1.8', '!!! Updated for October 420+.', '2022-10-24 04:14:44'),
(240, 'Indikator.DevTools', 'comment', '1.1.9', 'Updated the main navigation icon.', '2022-10-24 04:14:44'),
(241, 'Indikator.DevTools', 'comment', '1.1.9', 'Added last modified date.', '2022-10-24 04:14:44'),
(242, 'Indikator.DevTools', 'comment', '1.2.0', 'The syntax highlighting works again!', '2022-10-24 04:14:44'),
(243, 'Indikator.DevTools', 'comment', '1.2.1', 'Help links open in a new window.', '2022-10-24 04:14:44'),
(244, 'Indikator.DevTools', 'comment', '1.2.2', 'Fixed the dependency bug in asset list.', '2022-10-24 04:14:44'),
(245, 'Indikator.DevTools', 'comment', '1.2.3', 'The file delete operation works again.', '2022-10-24 04:14:44'),
(246, 'RainLab.Builder', 'comment', '1.0.1', 'Initialize plugin.', '2022-10-24 04:15:19'),
(247, '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-10-24 04:15:19'),
(248, 'RainLab.Builder', 'comment', '1.0.3', 'Improved handling of the enum data type.', '2022-10-24 04:15:19'),
(249, 'RainLab.Builder', 'comment', '1.0.4', 'Added user permissions to work with the Builder.', '2022-10-24 04:15:19'),
(250, 'RainLab.Builder', 'comment', '1.0.5', 'Fixed permissions registration.', '2022-10-24 04:15:19'),
(251, 'RainLab.Builder', 'comment', '1.0.6', 'Fixed front-end record ordering in the Record List component.', '2022-10-24 04:15:19'),
(252, '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-10-24 04:15:19'),
(253, 'RainLab.Builder', 'comment', '1.0.8', 'Added the Reorder Controller behavior.', '2022-10-24 04:15:19'),
(254, 'RainLab.Builder', 'comment', '1.0.9', 'Minor API and UI updates.', '2022-10-24 04:15:19'),
(255, 'RainLab.Builder', 'comment', '1.0.10', 'Minor styling update.', '2022-10-24 04:15:19'),
(256, '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-10-24 04:15:19'),
(257, '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-10-24 04:15:19'),
(258, 'RainLab.Builder', 'comment', '1.0.13', 'Minor styling fix on the database editor.', '2022-10-24 04:15:19'),
(259, 'RainLab.Builder', 'comment', '1.0.14', 'Added support for published_at timestamp field', '2022-10-24 04:15:19'),
(260, '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-10-24 04:15:19'),
(261, '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-10-24 04:15:19'),
(262, 'RainLab.Builder', 'comment', '1.0.17', 'Added support Trigger attribute support for RecordFinder and Repeater form widgets.', '2022-10-24 04:15:19'),
(263, '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-10-24 04:15:19'),
(264, '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-10-24 04:15:19'),
(265, 'RainLab.Builder', 'comment', '1.0.20', 'Fixes a bug where form the builder could trigger the \"current.hasAttribute is not a function\" error.', '2022-10-24 04:15:19'),
(266, 'RainLab.Builder', 'comment', '1.0.21', 'Back-end navigation sort order updated.', '2022-10-24 04:15:19'),
(267, 'RainLab.Builder', 'comment', '1.0.22', 'Added scopeValue property to the RecordList component.', '2022-10-24 04:15:19'),
(268, 'RainLab.Builder', 'comment', '1.0.23', 'Added support for balloon-selector field type, added Brazilian Portuguese translation, fixed some bugs', '2022-10-24 04:15:19'),
(269, '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-10-24 04:15:19'),
(270, 'RainLab.Builder', 'comment', '1.0.25', 'Allow editing of migration code in the \"Migration\" popup when saving changes in the database editor.', '2022-10-24 04:15:19'),
(271, 'RainLab.Builder', 'comment', '1.0.26', 'Allow special default values for columns and added new \"Add ID column\" button to database editor.', '2022-10-24 04:15:19'),
(272, 'RainLab.Builder', 'comment', '1.0.27', 'Added ability to use \'scope\' in a form relation field, added ability to change the sort order of versions and added additional properties for repeater widget in form builder. Added Polish translation.', '2022-10-24 04:15:19'),
(273, 'RainLab.Builder', 'comment', '1.0.28', 'Fixes support for PHP 8', '2022-10-24 04:15:19'),
(274, 'RainLab.Builder', 'comment', '1.0.29', 'Disable touch device detection', '2022-10-24 04:15:19'),
(275, 'RainLab.Builder', 'comment', '1.0.30', 'Minor styling improvements', '2022-10-24 04:15:19'),
(276, 'RainLab.Builder', 'comment', '1.0.31', 'Added support for more rich editor and file upload properties', '2022-10-24 04:15:19'),
(277, 'RainLab.Builder', 'comment', '1.0.32', 'Minor styling improvements', '2022-10-24 04:15:19'),
(278, 'RainLab.Builder', 'comment', '1.1.0', 'Adds feature for adding database fields to a form definition.', '2022-10-24 04:15:19'),
(279, 'RainLab.Builder', 'comment', '1.1.1', 'Adds DBAL timestamp column type. Adds database prefix support. Fixes various bugs.', '2022-10-24 04:15:19'),
(280, 'RainLab.Builder', 'comment', '1.1.2', 'Compatibility with October CMS v2.2', '2022-10-24 04:15:19'),
(281, 'RainLab.Builder', 'comment', '1.1.3', 'Adds comment support to database tables.', '2022-10-24 04:15:19'),
(282, 'RainLab.Builder', 'comment', '1.1.4', 'Fixes duplication bug saving backend menu permissions.', '2022-10-24 04:15:19'),
(283, 'RainLab.Builder', 'comment', '1.2.0', 'Improve support with October v3.0', '2022-10-24 04:15:19'),
(284, 'RainLab.Builder', 'comment', '1.2.2', 'Compatibility updates.', '2022-10-24 04:15:19'),
(285, 'RainLab.Builder', 'comment', '1.2.3', 'Fixes issue when removing items from permissions and menus.', '2022-10-24 04:15:19'),
(286, 'RainLab.Builder', 'comment', '1.2.5', 'Fixes validator conflict with other plugins.', '2022-10-24 04:15:19'),
(287, 'Martin.Forms', 'script', '1.0.0', 'create_records_table.php', '2022-10-24 04:21:36'),
(288, 'Martin.Forms', 'comment', '1.0.0', 'First version of Magic Forms', '2022-10-24 04:21:36'),
(289, 'Martin.Forms', 'comment', '1.0.1', 'Added CSRF protection', '2022-10-24 04:21:36'),
(290, 'Martin.Forms', 'comment', '1.1.0', 'Added reCAPTCHA', '2022-10-24 04:21:36'),
(291, 'Martin.Forms', 'comment', '1.1.1', 'Fix when using reCAPTCHA + allowed fields', '2022-10-24 04:21:36'),
(292, 'Martin.Forms', 'script', '1.1.2', 'add_group_field.php', '2022-10-24 04:21:36'),
(293, 'Martin.Forms', 'comment', '1.1.2', 'Filter forms records', '2022-10-24 04:21:36'),
(294, 'Martin.Forms', 'comment', '1.1.2', 'Search inside stored data', '2022-10-24 04:21:36'),
(295, 'Martin.Forms', 'comment', '1.1.2', 'Organize your forms on custom groups', '2022-10-24 04:21:36'),
(296, 'Martin.Forms', 'comment', '1.2.0', 'Export stored data in CSV format', '2022-10-24 04:21:36'),
(297, 'Martin.Forms', 'comment', '1.2.1', 'Auto-response email on form submit', '2022-10-24 04:21:36'),
(298, 'Martin.Forms', 'comment', '1.2.1', 'Added Turkish language', '2022-10-24 04:21:36'),
(299, 'Martin.Forms', 'comment', '1.2.2', 'Override notifications and auto-response email subjects', '2022-10-24 04:21:36'),
(300, 'Martin.Forms', 'comment', '1.2.3', 'New option to reset form after successfully submit', '2022-10-24 04:21:36'),
(301, 'Martin.Forms', 'comment', '1.2.3', 'Fixed Empty AJAX Form template', '2022-10-24 04:21:36'),
(302, 'Martin.Forms', 'comment', '1.2.3', 'Support for Translate plugin', '2022-10-24 04:21:36'),
(303, 'Martin.Forms', 'comment', '1.2.3', 'Added plugin documentation', '2022-10-24 04:21:36'),
(304, 'Martin.Forms', 'comment', '1.2.4', 'Added detailed reCAPTCHA help', '2022-10-24 04:21:36'),
(305, 'Martin.Forms', 'comment', '1.3.0', 'AJAX file uploads', '2022-10-24 04:21:36'),
(306, 'Martin.Forms', 'comment', '1.3.1', 'Added lang pt-br', '2022-10-24 04:21:36'),
(307, 'Martin.Forms', 'comment', '1.3.2', 'Fixed multiples reCAPTCHAs on same page', '2022-10-24 04:21:36'),
(308, 'Martin.Forms', 'comment', '1.3.3', 'Fixed record detail page when form data contains an array', '2022-10-24 04:21:36'),
(309, 'Martin.Forms', 'comment', '1.3.3', 'Updated documentations', '2022-10-24 04:21:36'),
(310, 'Martin.Forms', 'comment', '1.3.4', 'New \"Anonymize IP\" option', '2022-10-24 04:21:36'),
(311, 'Martin.Forms', 'comment', '1.3.5', 'New option \"Redirect on successful submit\"', '2022-10-24 04:21:36'),
(312, 'Martin.Forms', 'comment', '1.3.6', 'French translation', '2022-10-24 04:21:36'),
(313, 'Martin.Forms', 'comment', '1.3.6', 'Support Translate plugin on reCAPTCHA', '2022-10-24 04:21:36'),
(314, 'Martin.Forms', 'comment', '1.3.6', 'reCAPTCHA validation enhancements', '2022-10-24 04:21:36'),
(315, 'Martin.Forms', 'comment', '1.3.7', 'Displaying errors with fields (inline errors)', '2022-10-24 04:21:36'),
(316, 'Martin.Forms', 'comment', '1.3.7', 'Show uploads as list', '2022-10-24 04:21:36'),
(317, 'Martin.Forms', 'comment', '1.3.8', 'Fixed handling arrays (radio inputs) in notification email', '2022-10-24 04:21:36'),
(318, 'Martin.Forms', 'comment', '1.3.9', 'Use custom mail templates', '2022-10-24 04:21:36'),
(319, 'Martin.Forms', 'comment', '1.3.9', 'Execute custom JavaScript on form success or error', '2022-10-24 04:21:36'),
(320, 'Martin.Forms', 'comment', '1.4.0', 'Added Events (please, refer to docs) [thanks to therealkevinard]', '2022-10-24 04:21:36'),
(321, 'Martin.Forms', 'comment', '1.4.1', 'New option \"Reply To\"', '2022-10-24 04:21:36'),
(322, 'Martin.Forms', 'comment', '1.4.2', 'Escape HTML characters on the view records page [thanks to Andre]', '2022-10-24 04:21:36'),
(323, 'Martin.Forms', 'comment', '1.4.2', 'New option to sanitize form data (check security docs for more info)', '2022-10-24 04:21:36'),
(324, 'Martin.Forms', 'comment', '1.4.2', 'Added option to send blind carbon copy in notifications email', '2022-10-24 04:21:36'),
(325, 'Martin.Forms', 'script', '1.4.3', 'add_unread_field.php', '2022-10-24 04:21:36'),
(326, 'Martin.Forms', 'comment', '1.4.3', 'Fixes related to October Build 420', '2022-10-24 04:21:36'),
(327, 'Martin.Forms', 'comment', '1.4.3', 'Added \"Unread Records\" counter', '2022-10-24 04:21:36'),
(328, 'Martin.Forms', 'comment', '1.4.3', 'Fixed errors when only BCC addresses are supplied', '2022-10-24 04:21:36'),
(329, 'Martin.Forms', 'comment', '1.4.3', 'New setting \"hide navigation item\"', '2022-10-24 04:21:36'),
(330, 'Martin.Forms', 'comment', '1.4.4', 'Use custom partials for Success and Error messages', '2022-10-24 04:21:36'),
(331, 'Martin.Forms', 'comment', '1.4.4.1', 'Fix with notifications emails', '2022-10-24 04:21:36'),
(332, 'Martin.Forms', 'comment', '1.4.5', 'Mail class code refactoring', '2022-10-24 04:21:36'),
(333, 'Martin.Forms', 'comment', '1.4.5', 'Access submited data on auto-response email template', '2022-10-24 04:21:36'),
(334, 'Martin.Forms', 'comment', '1.4.5.1', 'Store form data without escaping unicode [thanks to panakour]', '2022-10-24 04:21:36'),
(335, 'Martin.Forms', 'comment', '1.4.6', 'New option to skip saving forms data on database.', '2022-10-24 04:21:36'),
(336, 'Martin.Forms', 'comment', '1.4.6', 'Possibility to change the text on the remove file popup [thanks to ShiroeSama]', '2022-10-24 04:21:36'),
(337, 'Martin.Forms', 'comment', '1.4.6.1', 'Changed database field from json to text to support MySQL 5.5', '2022-10-24 04:21:36'),
(338, 'Martin.Forms', 'comment', '1.4.7', 'you can use your form variables on notification mail subject [thanks to Alex360hd]', '2022-10-24 04:21:36'),
(339, 'Martin.Forms', 'comment', '1.4.7', 'fix custom subject on email template [Thanks to matteotrubini]', '2022-10-24 04:21:36'),
(340, 'Martin.Forms', 'comment', '1.4.7', 'fix email bug when not storing on db [Thanks JurekRaben]', '2022-10-24 04:21:36'),
(341, 'Martin.Forms', 'comment', '1.4.7', 'skip url redirect validation [Thanks to EleRam]', '2022-10-24 04:21:36'),
(342, 'Martin.Forms', 'comment', '1.4.8', 'added GDPR cleanup feature [thanks to Alex360hd]', '2022-10-24 04:21:36'),
(343, 'Martin.Forms', 'comment', '1.4.9', 'fix on replaceToken function when replacement is null [thanks to leonaze]', '2022-10-24 04:21:36'),
(344, 'Martin.Forms', 'comment', '1.4.9.1', 'fix a nullable type error on PHP 7.0', '2022-10-24 04:21:36'),
(345, 'Martin.Forms', 'comment', '1.4.9.2', 'bugfix when a form field array has more than 2 levels of depth', '2022-10-24 04:21:36'),
(346, 'Martin.Forms', 'comment', '1.4.10', 'improvements related to event functionality', '2022-10-24 04:21:36'),
(347, 'Martin.Forms', 'comment', '1.4.11', 'added Laravel custom attributes to form validation [thanks to geekfil]', '2022-10-24 04:21:36'),
(348, 'Martin.Forms', 'comment', '1.4.11', 'updated french translation [thanks to FelixINX]', '2022-10-24 04:21:36'),
(349, 'Martin.Forms', 'comment', '1.4.12', 'use form variables on auto-response mail subject [thanks to jiargei]', '2022-10-24 04:21:36'),
(350, 'Martin.Forms', 'comment', '1.4.13', 'pass an array with form errors to JavaScript [thanks to multiwebinc]', '2022-10-24 04:21:36'),
(351, 'Martin.Forms', 'comment', '1.4.14', 'fixed error with empty auto-response subject', '2022-10-24 04:21:36'),
(352, 'Martin.Forms', 'comment', '1.4.15', 'enhancements related to saving record and events [thanks to boxxroom]', '2022-10-24 04:21:36'),
(353, 'Martin.Forms', 'comment', '1.4.16', 'added chinese translation [thanks to everyx]', '2022-10-24 04:21:36'),
(354, 'Martin.Forms', 'comment', '1.4.17', 'allowing sanitize to work recursively [thanks to multiwebinc]', '2022-10-24 04:21:36'),
(355, 'Martin.Forms', 'comment', '1.4.18', 'export records enhancements [thanks to Fosphatic]', '2022-10-24 04:21:36'),
(356, 'Martin.Forms', 'comment', '1.4.18', 'recaptcha locale fix [thanks to MaTToX3]', '2022-10-24 04:21:36'),
(357, 'Martin.Forms', 'comment', '1.4.19', 'added russian translation [thanks to FlusherDock1]', '2022-10-24 04:21:36'),
(358, 'Martin.Forms', 'comment', '1.4.19', 'sort records by date fix [thanks to mjauvin]', '2022-10-24 04:21:36'),
(359, 'Martin.Forms', 'comment', '1.4.20', 'added invisible reCAPTCHA [thanks to mjauvin]', '2022-10-24 04:21:36'),
(360, 'Martin.Forms', 'comment', '1.4.20', 'new option to set custom date format on emails subject', '2022-10-24 04:21:36'),
(361, 'Martin.Forms', 'comment', '1.5.0', 'fixes related to October Build 469 [thanks to mjauvin]', '2022-10-24 04:21:36'),
(362, 'Martin.Forms', 'comment', '1.5.0', 'fix when CSRF check is disabled [thanks to rechik]', '2022-10-24 04:21:36'),
(363, 'Martin.Forms', 'comment', '1.5.0', 'php linting and cleanup', '2022-10-24 04:21:36'),
(364, 'Martin.Forms', 'comment', '1.5.1', 'email templates improvemenrs [thanks to mjauvin]', '2022-10-24 04:21:36'),
(365, 'Martin.Forms', 'comment', '1.5.1', 'added german translation [thanks to Fosphatic]', '2022-10-24 04:21:36');
INSERT INTO `system_plugin_versions` (`id`, `code`, `version`, `created_at`, `is_disabled`, `is_frozen`) VALUES
(1, 'October.Demo', '1.0.1', '2022-10-23 16:11:38', 0, 0),
(2, 'RainLab.Blog', '1.6.2', '2022-10-24 04:13:20', 0, 0),
(3, 'RainLab.Pages', '1.5.5', '2022-10-24 04:13:48', 0, 0),
(4, 'RainLab.Translate', '1.12.0', '2022-10-24 04:14:15', 0, 0),
(5, 'Indikator.DevTools', '1.2.3', '2022-10-24 04:14:44', 0, 0),
(6, 'RainLab.Builder', '1.2.5', '2022-10-24 04:15:19', 0, 0),
(7, 'Martin.Forms', '1.5.1', '2022-10-24 04:21:36', 0, 0);
/*!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 */;