-- Copy this file, replace every CHANGE_ME value, then run it on the PLATFORM database.
-- Never commit the filled-in copy because it contains infrastructure metadata.

START TRANSACTION;

INSERT INTO `platform_tenant_tb` (
  `uuid`, `request_code`, `name`, `slug`,
  `database_host`, `database_port`, `database_name`, `database_username`,
  `schema_version`, `status`, `activated_at`
) VALUES (
  'CHANGE_ME_UUID',
  'LEGACY-000001',
  'CHANGE_ME_CENTER_NAME',
  'CHANGE_ME_SLUG',
  'localhost',
  3306,
  'CHANGE_ME_DATABASE_NAME',
  NULL,
  '20260923',
  'active',
  NOW()
);

SET @legacy_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 (
  @legacy_tenant_id,
  'CHANGE_ME_HOSTNAME',
  'subdomain',
  1,
  'verified',
  'active',
  'active',
  NOW()
);

INSERT INTO `platform_tenant_log_tb` (`tenant_id`, `action`, `actor_name`, `metadata_json`)
VALUES (@legacy_tenant_id, 'legacy_tenant_registered', 'manual_setup', '{"source":"existing_database"}');

COMMIT;