Файловый менеджер

Файловый менеджер - Редактировать - /home/lmsyaran/public_html/administrator/components/com_notifly/sql/install.mysql.utf8.sql

Назад
-- -- Table structure for table `#__notifly_templates` -- CREATE TABLE IF NOT EXISTS `#__notifly_templates` ( `id` int(11) NOT NULL AUTO_INCREMENT, `asset_id` int(11) NOT NULL, `extension_id` int(11) NOT NULL, `name` varchar(255) NOT NULL DEFAULT '', `alias` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '', `message` text, `markdown` tinyint(3) NOT NULL DEFAULT 0, `avatar` tinyint(3) NOT NULL DEFAULT 1, `image_disable` tinyint(3) NOT NULL DEFAULT 0, `image_url` varchar(255) DEFAULT NULL, `state` TINYINT NULL DEFAULT NULL, `published` tinyint(1) NOT NULL DEFAULT 0, `checked_out` int(10) unsigned NOT NULL DEFAULT 0, `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `ordering` int(11) NOT NULL DEFAULT 0, `attribs` text NOT NULL, `params` text NOT NULL, `access` int(10) unsigned NOT NULL DEFAULT 0, `language` char(7) NOT NULL, `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `xreference` varchar(50) NOT NULL COMMENT 'A reference to enable linkages to external data sets.', `publish_up` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `publish_down` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `version` int(10) unsigned NOT NULL DEFAULT 1, `hits` int(10) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`id`), KEY `idx_access` (`access`), KEY `idx_checkout` (`checked_out`), KEY `idx_state` (`published`), KEY `idx_language` (`language`), KEY `idx_xreference` (`xreference`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci; -- -- Table structure for table `#__notifly_events` -- CREATE TABLE IF NOT EXISTS `#__notifly_events` ( `id` int(11) NOT NULL AUTO_INCREMENT, `template_id` int(11) NOT NULL, `extension_id` int(11) NOT NULL, `url` varchar(255) NOT NULL DEFAULT '', `image_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '', `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '', `name` varchar(255) NOT NULL DEFAULT '', `email` varchar(255) NOT NULL DEFAULT '', `ip` varchar(255) NOT NULL DEFAULT '', `city` varchar(255) DEFAULT NULL, `state` varchar(100) DEFAULT NULL, `country` varchar(255) NOT NULL DEFAULT '', `published` tinyint(1) NOT NULL DEFAULT 0, `checked_out` int(10) unsigned NOT NULL DEFAULT 0, `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `attribs` text NOT NULL, `params` text NOT NULL, `access` int(10) unsigned NOT NULL DEFAULT 0, `language` char(7) NOT NULL, `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `xreference` varchar(50) NOT NULL COMMENT 'A reference to enable linkages to external data sets.', `publish_up` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `publish_down` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `version` int(10) unsigned NOT NULL DEFAULT 1, `hits` int(10) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`id`), KEY `idx_access` (`access`), KEY `idx_checkout` (`checked_out`), KEY `idx_state` (`published`), KEY `idx_language` (`language`), KEY `idx_xreference` (`xreference`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci; CREATE TABLE IF NOT EXISTS `#__notifly_logs` ( `id` int(11) NOT NULL AUTO_INCREMENT, `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `view` int(11) NOT NULL, `click` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

| ver. 1.4 | Github | . | PHP 8.1.33 | Генерация страницы: 0 | proxy | phpinfo | Настройка