-- Register the existing test installation as the first tenant.
-- Run this file on: webdemoo_simple_saas_platform
-- The application path is intentionally not stored here; tenant resolution is
-- based on the hostname only.

USE `webdemoo_simple_saas_platform`;

START TRANSACTION;

INSERT INTO `platform_tenant_tb` (
  `uuid`,
  `request_code`,
  `name`,
  `slug`,
  `database_host`,
  `database_port`,
  `database_name`,
  `database_username`,
  `database_password_encrypted`,
  `schema_version`,
  `status`,
  `activated_at`
) VALUES (
  UUID(),
  'LEGACY-000001',
  'Simple Edu - Test',
  'simple-edu-test',
  'localhost',
  3306,
  'webdemoo_diemdanh',
  NULL,
  NULL,
  'legacy-current',
  'active',
  NOW()
)
ON DUPLICATE KEY UPDATE
  `id` = LAST_INSERT_ID(`id`),
  `name` = VALUES(`name`),
  `database_host` = VALUES(`database_host`),
  `database_port` = VALUES(`database_port`),
  `database_name` = VALUES(`database_name`),
  `schema_version` = VALUES(`schema_version`),
  `status` = VALUES(`status`),
  `activated_at` = COALESCE(`activated_at`, VALUES(`activated_at`));

SET @current_tenant_id = LAST_INSERT_ID();

INSERT INTO `platform_domain_tb` (
  `tenant_id`,
  `hostname`,
  `domain_type`,
  `is_primary`,
  `dns_status`,
  `ssl_status`,
  `status`,
  `verified_at`
) VALUES (
  @current_tenant_id,
  'se.webdemo258.io.vn',
  'subdomain',
  1,
  'verified',
  'active',
  'active',
  NOW()
)
ON DUPLICATE KEY UPDATE
  `tenant_id` = VALUES(`tenant_id`),
  `is_primary` = VALUES(`is_primary`),
  `dns_status` = VALUES(`dns_status`),
  `ssl_status` = VALUES(`ssl_status`),
  `status` = VALUES(`status`),
  `verified_at` = VALUES(`verified_at`);

INSERT INTO `platform_tenant_log_tb` (
  `tenant_id`, `action`, `actor_name`, `metadata_json`
) VALUES (
  @current_tenant_id,
  'legacy_tenant_registered',
  'manual_setup',
  '{"source":"existing_test_installation","hostname":"se.webdemo258.io.vn"}'
);

COMMIT;

SELECT
  t.`id`,
  t.`uuid`,
  t.`name`,
  t.`slug`,
  t.`database_name`,
  t.`status`,
  d.`hostname`,
  d.`status` AS `domain_status`
FROM `platform_tenant_tb` t
INNER JOIN `platform_domain_tb` d ON d.`tenant_id` = t.`id`
WHERE t.`request_code` = 'LEGACY-000001';