FlatlyPage

.htaccess .last_check admin/account.php admin/dashboard.php admin/easyedit.js admin/extensions.php admin/generate-hash.php admin/index.php admin/lang.php admin/login_tracking.php admin/logout.php admin/popups.php admin/preview.php admin/scripts.php admin/theme-edit/index.php admin/themes.php api/get-translate-config.php api/translate.php assets/fonts/inter/inter.css assets/fonts/space-grotesk/space-grotesk.css assets/js/admin-editor.js assets/js/admin-theme.js assets/js/translate.js config.php contact-handler.php contact.php css/admin.css css/contact.css css/styles.css css/theme.css css/translate.css data/.htaccess data/.index.php data/.settings.php data/private/.htaccess data/sitemap-config.php data/translate-api.xml engine/index.html engine/index.php engine/renderion.php extensions-loader.php favicons.txt functions.php index.php newsletter/.htaccess newsletter/confirm.php newsletter/manager.php newsletter/newsletter-form.js newsletter/newsletter-styles.css newsletter/newsletter-unavailable.php newsletter/newsletter.sql newsletter/settings.php newsletter/subscribe.php newsletter/unsubscribe.php page.php robots.txt.php sitemap.php updater/index.php version.txt

-- newsletter.sql - Database structure
-- Run this in phpMyAdmin SQL tab

CREATE TABLE IF NOT EXISTS `newsletter_subscribers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `email` varchar(255) NOT NULL,
  `token` varchar(64) NOT NULL,
  `confirmed` tinyint(1) DEFAULT 0,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `confirmed_at` timestamp NULL DEFAULT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `email` (`email`),
  KEY `idx_token` (`token`),
  KEY `idx_confirmed` (`confirmed`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;