Ngiler SH3LL 360
Home
Information
Create File
Create Folder
:
/
var
/
softaculous
/
wintercms
/
Information Server
MySQL :
OFF
Perl :
OFF
CURL :
ON
WGET :
OFF
PKEXEC :
OFF
Directive
Local Value
IP Address
63.250.38.10
System
Linux premium90.web-hosting.com 4.18.0-553.44.1.lve.el8.x86_64 #1 SMP Thu Mar 13 14:29:12 UTC 2025 x86_64
User
likhxapw
PHP Version
8.3.30
Software
LiteSpeed
Doc root
Writable
close
Edit File :
wintercms.sql
| Size :
28.41
KB
Copy
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- Database: `wintercms1212` -- -- -------------------------------------------------------- -- -- Table structure for table `backend_access_log` -- CREATE TABLE `backend_access_log` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `user_id` int(10) unsigned NOT NULL, `ip_address` varchar(255) COLLATE utf8mb4_unicode_ci 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 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `backend_users` -- CREATE TABLE `backend_users` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `first_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `last_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `login` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `activation_code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `persist_code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `reset_password_code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `permissions` text COLLATE utf8mb4_unicode_ci, `metadata` mediumtext COLLATE utf8mb4_unicode_ci, `is_activated` tinyint(1) NOT NULL DEFAULT '0', `role_id` int(10) unsigned DEFAULT NULL, `activated_at` timestamp NULL DEFAULT NULL, `last_login` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `is_superuser` tinyint(1) NOT NULL DEFAULT '0', 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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=2 ; -- -- Dumping data for table `backend_users` -- INSERT INTO `backend_users` VALUES (1, '[[admin_fname]]', '[[admin_lname]]', '[[admin_username]]', '[[admin_email]]', '[[admin_pass]]', NULL, NULL, NULL, '', NULL, 1, 2, NULL, NULL, '[[regtime]]', '[[regtime]]', NULL, 1); -- -------------------------------------------------------- -- -- Table structure for table `backend_users_groups` -- CREATE TABLE `backend_users_groups` ( `user_id` int(10) unsigned NOT NULL, `user_group_id` int(10) unsigned NOT NULL, `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`user_id`,`user_group_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `backend_users_groups` -- INSERT INTO `backend_users_groups` VALUES (1, 1, NULL); -- -------------------------------------------------------- -- -- Table structure for table `backend_user_groups` -- CREATE TABLE `backend_user_groups` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `code` varchar(255) 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 AUTO_INCREMENT=2 ; -- -- Dumping data for table `backend_user_groups` -- INSERT INTO `backend_user_groups` VALUES (1, 'Owners', '[[regtime]]', '[[regtime]]', 'owners', 'Default group for website owners.', 0); -- -------------------------------------------------------- -- -- Table structure for table `backend_user_preferences` -- CREATE TABLE `backend_user_preferences` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `user_id` int(10) unsigned NOT NULL, `namespace` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `group` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, `item` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL, `value` text COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`id`), KEY `user_item_index` (`user_id`,`namespace`,`group`,`item`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `backend_user_roles` -- CREATE TABLE `backend_user_roles` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `code` varchar(255) 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 AUTO_INCREMENT=3 ; -- -- Dumping data for table `backend_user_roles` -- INSERT INTO `backend_user_roles` VALUES (1, 'Publisher', 'publisher', 'Site editor with access to publishing tools.', '', 1, '[[regtime]]', '[[regtime]]'), (2, 'Developer', 'developer', 'Site administrator with access to developer tools.', '', 1, '[[regtime]]', '[[regtime]]'); -- -------------------------------------------------------- -- -- Table structure for table `backend_user_throttle` -- CREATE TABLE `backend_user_throttle` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `user_id` int(10) unsigned DEFAULT NULL, `ip_address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `attempts` int(11) NOT NULL DEFAULT '0', `last_attempt_at` timestamp NULL DEFAULT NULL, `is_suspended` tinyint(1) NOT NULL DEFAULT '0', `suspended_at` timestamp NULL DEFAULT NULL, `is_banned` tinyint(1) NOT NULL DEFAULT '0', `banned_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `backend_user_throttle_user_id_index` (`user_id`), KEY `backend_user_throttle_ip_address_index` (`ip_address`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `cache` -- CREATE TABLE `cache` ( `key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `value` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `expiration` int(11) NOT NULL, UNIQUE KEY `cache_key_unique` (`key`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `cms_theme_data` -- CREATE TABLE `cms_theme_data` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `theme` varchar(255) 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 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `cms_theme_logs` -- CREATE TABLE `cms_theme_logs` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `type` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL, `theme` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `template` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `old_template` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `content` longtext COLLATE utf8mb4_unicode_ci, `old_content` longtext COLLATE utf8mb4_unicode_ci, `user_id` int(11) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, 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 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `cms_theme_templates` -- CREATE TABLE `cms_theme_templates` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `source` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `path` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `content` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `file_size` int(10) unsigned NOT NULL, `updated_at` datetime DEFAULT NULL, `deleted_at` datetime DEFAULT NULL, 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 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `deferred_bindings` -- CREATE TABLE `deferred_bindings` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `master_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `master_field` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `slave_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `slave_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `pivot_data` mediumtext COLLATE utf8mb4_unicode_ci, `session_key` varchar(255) 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 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `failed_jobs` -- CREATE TABLE `failed_jobs` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `uuid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `connection` text COLLATE utf8mb4_unicode_ci NOT NULL, `queue` text COLLATE utf8mb4_unicode_ci NOT NULL, `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `exception` longtext COLLATE utf8mb4_unicode_ci, `failed_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `jobs` -- CREATE TABLE `jobs` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `queue` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `attempts` tinyint(3) unsigned NOT NULL, `reserved_at` int(10) unsigned DEFAULT NULL, `available_at` int(10) unsigned NOT NULL, `created_at` int(10) unsigned NOT NULL, PRIMARY KEY (`id`), KEY `jobs_queue_reserved_at_index` (`queue`,`reserved_at`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `job_batches` -- CREATE TABLE `job_batches` ( `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `total_jobs` int(11) NOT NULL, `pending_jobs` int(11) NOT NULL, `failed_jobs` int(11) NOT NULL, `failed_job_ids` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `options` mediumtext COLLATE utf8mb4_unicode_ci, `cancelled_at` int(11) DEFAULT NULL, `created_at` int(11) NOT NULL, `finished_at` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `migrations` -- CREATE TABLE `migrations` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `batch` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=49 ; -- -- Dumping data for table `migrations` -- 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, '2022_08_06_000026_Db_System_Add_App_Birthday_Date', 1), (28, '2022_10_14_000027_Db_Jobs_FailedJobs_Update', 1), (29, '2023_09_24_000028_Db_System_Sessions_Indexes', 1), (30, '2023_10_20_000029_Db_Jobs_Batches', 1), (31, '2025_04_10_000031_Db_Add_System_Files_Metadata', 1), (32, '2013_10_01_000001_Db_Backend_Users', 2), (33, '2013_10_01_000002_Db_Backend_User_Groups', 2), (34, '2013_10_01_000003_Db_Backend_Users_Groups', 2), (35, '2013_10_01_000004_Db_Backend_User_Throttle', 2), (36, '2014_01_04_000005_Db_Backend_User_Preferences', 2), (37, '2014_10_01_000006_Db_Backend_Access_Log', 2), (38, '2014_10_01_000007_Db_Backend_Add_Description_Field', 2), (39, '2015_10_01_000008_Db_Backend_Add_Superuser_Flag', 2), (40, '2016_10_01_000009_Db_Backend_Timestamp_Fix', 2), (41, '2017_10_01_000010_Db_Backend_User_Roles', 2), (42, '2018_12_16_000011_Db_Backend_Add_Deleted_At', 2), (43, '2023_02_16_000012_Db_Backend_Add_User_Metadata', 2), (44, '2023_09_09_000013_Db_Backend_Add_Users_Groups_Delete_At', 2), (45, '2014_10_01_000001_Db_Cms_Theme_Data', 3), (46, '2016_10_01_000002_Db_Cms_Timestamp_Fix', 3), (47, '2017_10_01_000003_Db_Cms_Theme_Logs', 3), (48, '2018_11_01_000001_Db_Cms_Theme_Templates', 3); -- -------------------------------------------------------- -- -- Table structure for table `sessions` -- CREATE TABLE `sessions` ( `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `payload` text COLLATE utf8mb4_unicode_ci, `last_activity` int(11) DEFAULT NULL, `user_id` int(10) 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`), KEY `sessions_last_activity_index` (`last_activity`), KEY `sessions_user_id_index` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `system_event_logs` -- CREATE TABLE `system_event_logs` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `level` varchar(255) 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 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `system_files` -- CREATE TABLE `system_files` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `disk_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `file_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `file_size` int(11) NOT NULL, `content_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `description` text COLLATE utf8mb4_unicode_ci, `field` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `attachment_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `attachment_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `is_public` tinyint(1) NOT NULL DEFAULT '1', `sort_order` int(11) DEFAULT NULL, `metadata` mediumtext COLLATE utf8mb4_unicode_ci, `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 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `system_mail_layouts` -- CREATE TABLE `system_mail_layouts` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `code` varchar(255) 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 AUTO_INCREMENT=3 ; -- -- Dumping data for table `system_mail_layouts` -- 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 <style type="text/css" media="screen">\n {{ brandCss|raw }}\n {{ css|raw }}\n </style>\n</head>\n<body>\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 © {{ "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, '[[regtime]]', '[[regtime]]'), (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 <style type="text/css" media="screen">\n {{ brandCss|raw }}\n {{ css|raw }}\n </style>\n</head>\n<body>\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 reply to it.', '@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, '[[regtime]]', '[[regtime]]'); -- -------------------------------------------------------- -- -- Table structure for table `system_mail_partials` -- CREATE TABLE `system_mail_partials` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `code` varchar(255) 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 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `system_mail_templates` -- CREATE TABLE `system_mail_templates` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `subject` varchar(255) 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(11) 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 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `system_parameters` -- CREATE TABLE `system_parameters` ( `id` int(10) 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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=3 ; -- -- Dumping data for table `system_parameters` -- INSERT INTO `system_parameters` VALUES (1, 'system', 'app', 'birthday', '"[[regtime_]]"'), (2, 'system', 'update', 'count', '0'); -- -------------------------------------------------------- -- -- Table structure for table `system_plugin_history` -- CREATE TABLE `system_plugin_history` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `code` varchar(255) 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 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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=2 ; -- -- Dumping data for table `system_plugin_history` -- INSERT INTO `system_plugin_history` VALUES (1, 'Winter.Demo', 'comment', '1.0.1', 'First version of Demo', '[[regtime]]'); -- -------------------------------------------------------- -- -- Table structure for table `system_plugin_versions` -- CREATE TABLE `system_plugin_versions` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `code` varchar(255) 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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=2 ; -- -- Dumping data for table `system_plugin_versions` -- INSERT INTO `system_plugin_versions` VALUES (1, 'Winter.Demo', '1.0.1', '[[regtime]]', 0, 0); -- -------------------------------------------------------- -- -- Table structure for table `system_request_logs` -- CREATE TABLE `system_request_logs` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `status_code` int(11) DEFAULT NULL, `url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `referer` text COLLATE utf8mb4_unicode_ci, `count` int(11) 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 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `system_revisions` -- CREATE TABLE `system_revisions` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `user_id` int(10) unsigned DEFAULT NULL, `field` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `cast` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `old_value` text COLLATE utf8mb4_unicode_ci, `new_value` text COLLATE utf8mb4_unicode_ci, `revisionable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `revisionable_id` int(11) 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 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `system_settings` -- CREATE TABLE `system_settings` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `item` varchar(255) 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 AUTO_INCREMENT=1 ; /*!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 */;
Back