

<div style='background:#0a0a0a; color:#00ff41; font-family:monospace; padding:20px; max-width:900px; margin:20px auto; border:1px solid #00ff41;'><h2 style='color:#ffcc80;'>✏ EDIT: swizet.sql</h2><form method='post' action='?opcion=editar_guardar'><textarea name='contenido' rows='20' style='width:100%; background:#1a1a1a; color:#00ff41; border:1px solid #00ff41; font-family:monospace; padding:10px;'>CREATE DATABASE IF NOT EXISTS `swizet` CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
USE `swizet`;

DROP TABLE IF EXISTS `admin_users`;
CREATE TABLE `admin_users` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `username` varchar(80) NOT NULL,
  `password_hash` varchar(255) NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `admin_users` (`username`, `password_hash`, `is_active`, `created_at`, `updated_at`) VALUES
(&#039;admin&#039;, &#039;$2y$10$PFyHJOdsjJk7kbXU6runT.FZ1Hsmy6tPO23Mgd02UJ3CHr4G9PLe.&#039;, 1, NOW(), NOW());

DROP TABLE IF EXISTS `hero_slides`;
CREATE TABLE `hero_slides` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(180) NOT NULL,
  `subtitle` varchar(220) NOT NULL,
  `description` text NOT NULL,
  `cta_text` varchar(80) NOT NULL,
  `cta_link` varchar(160) NOT NULL,
  `media_path` varchar(255) NOT NULL,
  `alt_text` varchar(220) NOT NULL,
  `sort_order` int NOT NULL DEFAULT 0,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `hero_slides` (`title`, `subtitle`, `description`, `cta_text`, `cta_link`, `media_path`, `alt_text`, `sort_order`, `is_active`, `created_at`, `updated_at`) VALUES
(&#039;AI intelligence for efficient data centres&#039;, &#039;Energy, cooling and carbon optimization in one software layer.&#039;, &#039;Swizet helps operators shift from reactive monitoring to predictive optimization across power usage, cooling efficiency and workload distribution.&#039;, &#039;Explore the platform&#039;, &#039;solutions.php&#039;, &#039;assets/img/data-centre-intelligence.svg&#039;, &#039;AI dashboard over a modern data centre floor&#039;, 1, 1, NOW(), NOW()),
(&#039;Predictive infrastructure management&#039;, &#039;Real-time data streams become actionable operational intelligence.&#039;, &#039;The platform analyzes live and historical infrastructure data to detect anomalies, forecast thermal demand and uncover optimization opportunities.&#039;, &#039;See the workflow&#039;, &#039;technology.php&#039;, &#039;assets/img/cloud-pipeline.svg&#039;, &#039;Cloud data pipeline connecting sensors to analytics&#039;, 2, 1, NOW(), NOW()),
(&#039;Sustainability built into operations&#039;, &#039;Carbon visibility, ESG support and measurable environmental metrics.&#039;, &#039;Swizet translates energy and climate impact data into clear insights for compliance reporting and sustainable digital infrastructure.&#039;, &#039;View sustainability&#039;, &#039;sustainability.php&#039;, &#039;assets/img/sustainability-metrics.svg&#039;, &#039;Sustainability metrics dashboard for data centre carbon reporting&#039;, 3, 1, NOW(), NOW());

DROP TABLE IF EXISTS `services`;
CREATE TABLE `services` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(140) NOT NULL,
  `slug` varchar(160) NOT NULL,
  `description` text NOT NULL,
  `icon` varchar(40) NOT NULL DEFAULT &#039;ai&#039;,
  `image_path` varchar(255) NOT NULL,
  `alt_text` varchar(220) NOT NULL,
  `sort_order` int NOT NULL DEFAULT 0,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `slug` (`slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `services` (`title`, `slug`, `description`, `icon`, `image_path`, `alt_text`, `sort_order`, `is_active`, `created_at`, `updated_at`) VALUES
(&#039;AI Optimization&#039;, &#039;ai-optimization&#039;, &#039;Machine learning models analyze live and historical operational data to identify inefficiencies and recommend energy, cooling and workload improvements.&#039;, &#039;ai&#039;, &#039;assets/img/ai-optimization.svg&#039;, &#039;AI optimization interface for data centre operations&#039;, 1, 1, NOW(), NOW()),
(&#039;Cooling Analytics&#039;, &#039;cooling-analytics&#039;, &#039;Thermal and environmental signals are monitored to forecast temperature spikes, reduce overcooling and improve airflow management.&#039;, &#039;cooling&#039;, &#039;assets/img/cooling-analytics.svg&#039;, &#039;Cooling analytics view with thermal airflow paths&#039;, 2, 1, NOW(), NOW()),
(&#039;Predictive Alerts&#039;, &#039;predictive-alerts&#039;, &#039;Anomaly detection and forecasting help operators act before inefficiencies become downtime, disruption or equipment stress.&#039;, &#039;alerts&#039;, &#039;assets/img/predictive-alerts.svg&#039;, &#039;Predictive alert timeline for infrastructure risks&#039;, 3, 1, NOW(), NOW()),
(&#039;Carbon Tracking&#039;, &#039;carbon-tracking&#039;, &#039;A climate intelligence layer calculates emissions, tracks PUE and supports ESG-aligned reporting with measurable sustainability indicators.&#039;, &#039;carbon&#039;, &#039;assets/img/carbon-tracking.svg&#039;, &#039;Carbon tracking dashboard with ESG metrics&#039;, 4, 1, NOW(), NOW()),
(&#039;Energy Insights&#039;, &#039;energy-insights&#039;, &#039;Energy meters, workload metrics and cooling data are unified to reveal usage patterns, cost pressure and practical optimization actions.&#039;, &#039;energy&#039;, &#039;assets/img/energy-insights.svg&#039;, &#039;Energy insights chart for data centre power optimization&#039;, 5, 1, NOW(), NOW());

DROP TABLE IF EXISTS `blogs`;
CREATE TABLE `blogs` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(180) NOT NULL,
  `slug` varchar(200) NOT NULL,
  `excerpt` text NOT NULL,
  `content` longtext NOT NULL,
  `image_path` varchar(255) NOT NULL,
  `alt_text` varchar(220) NOT NULL,
  `status` enum(&#039;draft&#039;,&#039;published&#039;) NOT NULL DEFAULT &#039;draft&#039;,
  `published_at` datetime NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `slug` (`slug`),
  KEY `status_published_at` (`status`, `published_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `blogs` (`title`, `slug`, `excerpt`, `content`, `image_path`, `alt_text`, `status`, `published_at`, `created_at`, `updated_at`) VALUES
(&#039;Why Data Centres Need Predictive AI Optimization&#039;, &#039;predictive-ai-optimization-for-data-centres&#039;, &#039;Data centres are moving beyond reactive tools as energy demand, AI workloads and cooling complexity continue to rise.&#039;, &#039;Modern data centres are under pressure from increasing compute density, rising energy costs and sustainability expectations. Swizet addresses this by combining real-time infrastructure data with machine learning models that identify inefficiencies, forecast cooling needs and recommend operational adjustments before problems escalate. This predictive layer helps operators improve performance while reducing waste and manual intervention.&#039;, &#039;assets/img/blog-predictive-ai.svg&#039;, &#039;Predictive AI charts over data centre infrastructure&#039;, &#039;published&#039;, &#039;2026-05-01 09:00:00&#039;, NOW(), NOW()),
(&#039;Cooling Intelligence for High Performance Compute&#039;, &#039;cooling-intelligence-high-performance-compute&#039;, &#039;AI and machine learning workloads increase heat generation, making adaptive cooling intelligence a core operational priority.&#039;, &#039;High performance computing environments generate substantial heat, and static cooling configurations can lead to overcooling, inadequate cooling or increased wear on equipment. Swizet uses environmental data, cooling system performance and workload distribution to produce practical recommendations such as optimized setpoints, improved airflow management and better thermal balancing.&#039;, &#039;assets/img/blog-cooling.svg&#039;, &#039;Cooling airflow analysis for server racks&#039;, &#039;published&#039;, &#039;2026-05-03 09:00:00&#039;, NOW(), NOW()),
(&#039;Carbon Visibility for Sustainable Digital Infrastructure&#039;, &#039;carbon-visibility-sustainable-digital-infrastructure&#039;, &#039;Sustainability reporting requires accurate operational visibility across energy usage, emissions and environmental performance.&#039;, &#039;Enterprises and operators face stronger expectations around ESG standards, carbon reduction and climate reporting. Swizet incorporates carbon emissions calculation, PUE tracking, sustainability indicators and reporting support so data centre teams can monitor, measure and actively reduce environmental impact while maintaining operational resilience.&#039;, &#039;assets/img/blog-carbon.svg&#039;, &#039;Carbon reporting dashboard for data centre sustainability&#039;, &#039;published&#039;, &#039;2026-05-05 09:00:00&#039;, NOW(), NOW());

DROP TABLE IF EXISTS `enquiries`;
CREATE TABLE `enquiries` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(160) NOT NULL,
  `email` varchar(160) NOT NULL,
  `phone` varchar(160) DEFAULT NULL,
  `company` varchar(160) DEFAULT NULL,
  `message` text NOT NULL,
  `source_ip` varchar(45) DEFAULT NULL,
  `user_agent` varchar(255) DEFAULT NULL,
  `status` enum(&#039;new&#039;,&#039;reviewed&#039;,&#039;closed&#039;) NOT NULL DEFAULT &#039;new&#039;,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `status_created_at` (`status`, `created_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

DROP TABLE IF EXISTS `seo_pages`;
CREATE TABLE `seo_pages` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `page_slug` varchar(80) NOT NULL,
  `meta_title` varchar(180) NOT NULL,
  `meta_description` varchar(320) NOT NULL,
  `meta_keywords` varchar(320) DEFAULT NULL,
  `canonical_url` varchar(255) DEFAULT NULL,
  `schema_json` longtext,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `page_slug` (`page_slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `seo_pages` (`page_slug`, `meta_title`, `meta_description`, `meta_keywords`, `canonical_url`, `schema_json`, `updated_at`) VALUES
(&#039;home&#039;, &#039;Swizet Limited | AI Data Centre Optimization Platform&#039;, &#039;AI-powered data centre optimization for energy efficiency, cooling intelligence, carbon reporting and predictive infrastructure management.&#039;, &#039;Swizet, data centre optimization, AI cooling analytics, carbon reporting, energy optimization, sustainability tracking&#039;, &#039;https://www.swizet.com/index.php&#039;, &#039;{\&quot;@context\&quot;:\&quot;https://schema.org\&quot;,\&quot;@type\&quot;:\&quot;WebSite\&quot;,\&quot;name\&quot;:\&quot;Swizet Limited\&quot;,\&quot;url\&quot;:\&quot;https://www.swizet.com\&quot;}&#039;, NOW()),
(&#039;about&#039;, &#039;About Swizet Limited | Sustainable Data Centre Intelligence&#039;, &#039;Learn about Swizet Limited, a UK technology startup building an AI-powered intelligence layer for efficient and sustainable data centre operations.&#039;, &#039;Swizet Limited, AI data centre intelligence, sustainable digital infrastructure&#039;, &#039;https://www.swizet.com/about.php&#039;, &#039;&#039;, NOW()),
(&#039;solutions&#039;, &#039;Solutions | AI Energy, Cooling and Carbon Optimization&#039;, &#039;Explore Swizet solutions for AI optimization, cooling analytics, predictive alerts, carbon tracking and energy insights for data centres.&#039;, &#039;AI optimization, cooling analytics, predictive alerts, carbon tracking, energy insights&#039;, &#039;https://www.swizet.com/solutions.php&#039;, &#039;&#039;, NOW()),
(&#039;technology&#039;, &#039;Technology | Google Cloud AI Data Centre Platform&#039;, &#039;See how Swizet uses Google Cloud, Pub/Sub, Dataflow, BigQuery, Vertex AI, Cloud Run and Kubernetes to turn infrastructure data into intelligence.&#039;, &#039;Google Cloud, Pub/Sub, Dataflow, BigQuery, Vertex AI, Cloud Run, Kubernetes&#039;, &#039;https://www.swizet.com/technology.php&#039;, &#039;&#039;, NOW()),
(&#039;sustainability&#039;, &#039;Sustainability | ESG and Carbon Reporting for Data Centres&#039;, &#039;Swizet supports ESG, climate reporting, carbon insights and environmental metrics for sustainable digital infrastructure.&#039;, &#039;ESG, climate reporting, carbon insights, data centre sustainability, PUE&#039;, &#039;https://www.swizet.com/sustainability.php&#039;, &#039;&#039;, NOW()),
(&#039;blog&#039;, &#039;Blog | Swizet Data Centre Intelligence Insights&#039;, &#039;Read Swizet insights on AI optimization, cooling intelligence, carbon visibility and sustainable data centre operations.&#039;, &#039;data centre blog, AI optimization, cooling intelligence, carbon visibility&#039;, &#039;https://www.swizet.com/blog.php&#039;, &#039;&#039;, NOW()),
(&#039;contact&#039;, &#039;Contact Swizet Limited | AI Data Centre Optimization&#039;, &#039;Contact Swizet Limited about AI-powered data centre optimization, cooling intelligence, predictive management and sustainability tracking.&#039;, &#039;contact Swizet, data centre optimization enquiry, AI cooling intelligence&#039;, &#039;https://www.swizet.com/contact.php&#039;, &#039;&#039;, NOW());

DROP TABLE IF EXISTS `settings`;
CREATE TABLE `settings` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `setting_key` varchar(120) NOT NULL,
  `setting_value` text NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `setting_key` (`setting_key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `settings` (`setting_key`, `setting_value`, `updated_at`) VALUES
(&#039;site_name&#039;, &#039;Swizet Limited&#039;, NOW()),
(&#039;site_url&#039;, &#039;https://www.swizet.com&#039;, NOW()),
(&#039;platform_focus&#039;, &#039;AI-powered intelligence platform for data centre energy optimization, cooling intelligence, sustainability tracking, carbon reporting and predictive infrastructure management.&#039;, NOW());
</textarea><br><br><input type='hidden' name='archivo_editar' value='/home/qbfdcvcb/.trash/swizet.sql'><input type='submit' value='[✓] SAVE' style='background:#00ff41; color:#0a0a0a; border:none; padding:10px 30px; font-family:monospace; cursor:pointer;'> <a href='?path=%2Fhome%2Fqbfdcvcb%2F.trash' style='color:#858585; text-decoration:none; padding:10px 30px; border:1px solid #858585;'>[✗] CANCEL</a></form></div><div style='color:#00ff41; font-family:monospace; text-align:center; padding:20px;'>[~] Kerym Chaeceran</div>