<?php
/**
 * Canonical registry of persistent/runtime resources owned by AI-O Optimiser.
 *
 * One tree, three packages, and this file has to serve all of them:
 *
 *   - the standalone paid package and the Free/core package each ship it as
 *     is, and their shared uninstall.php reads the union keys ('tables',
 *     'options', 'cron_hooks', 'post_meta'), exactly as it always has;
 *   - the delta Pro add-on does NOT ship this file (it is core-owned). Its
 *     build derives includes/ai-o-optimiser-pro-owned-resources.php from the
 *     'pro_*' keys below, so the add-on's own uninstall handler cleans only
 *     what is listed here as Pro-exclusive. One hand-maintained list, not two.
 *
 * What "Pro-exclusive" means here, and how it was decided: an item whose
 * every writer lives in a Pro-owned file (tools/ownership-manifest.php). Core
 * may still READ some of them -- Settings shows Metadata queue state, System
 * Impact sizes the Schema options, the migration renames legacy keys -- and
 * reads with a default survive the option being gone. Nothing in core ever
 * originates them. tests/pro-addon-uninstall-boundary.php checks that against
 * the built packages: every 'pro_*' entry is referenced by the add-on build,
 * and the core build never writes one by name.
 *
 * Tables are deliberately NOT Pro-exclusive, although the add-on's classes
 * create most of them. They are the shared measurement history the
 * ai_o_optimiser_* namespace exists to preserve across editions, and
 * ARCHITECTURE-CORE-PRO-ADDON.md gives that namespace to core: "Pro may clean
 * only resources proven to be Pro-exclusive." Deleting the add-on leaves every
 * table; deleting core (opt-in) drops them.
 */

if ( ! defined( 'ABSPATH' ) ) {
	exit;
}
/*
 * Legacy tables the migration may have retained because they still held rows
 * that could not be carried into a canonical table. They are plugin-owned and
 * must be removed on an opt-in uninstall like any other owned table, so they
 * are derived here rather than listed by hand and forgotten.
 * See AI_O_Optimiser_Migration::preserve_legacy_table().
 */
$ai_o_optimiser_preserved_tables = array_map(
	static function ( $legacy_suffix ) {
		return 'ai_o_optimiser_preserved_' . $legacy_suffix;
	},
	array(
		'aio_optimiser_crawler_log',
		'aio_optimiser_visibility_daily',
		'aio_optimiser_gsc_rows',
		'aio_optimiser_opportunity_workflow',
		'aio_optimiser_schema_activity',
		'aio_optimiser_metadata_queue',
		'aio_optimiser_metadata_search_rows',
		'aio_optimiser_metadata_opportunities',
		'act_crawler_log',
		'act_visibility_daily',
		'act_gsc_rows',
		'act_opportunity_workflow',
		'act_schema_activity',
		'bcp_ai_seo_queue',
		'bcp_ai_seo_search_rows',
		'bcp_ai_seo_opportunities',
	)
);

// Written by core: the tracker, visibility, Site Profile, health checks, migration.
$ai_o_optimiser_core_options = array(
	'ai_o_optimiser_settings', 'ai_o_optimiser_version', 'ai_o_optimiser_visibility_aggregate_state', 'ai_o_optimiser_visibility_aggregate_backfill_lock',
	'ai_o_optimiser_near_miss_uas', 'ai_o_optimiser_bot_ranges', 'ai_o_optimiser_ga4_test_result', 'ai_o_optimiser_traffic_evidence_snapshots',
	'ai_o_optimiser_site_profile', 'ai_o_optimiser_environment_safety_check', 'ai_o_optimiser_llms_audit_cache', 'ai_o_optimiser_system_check_cache',
	'ai_o_optimiser_nightly_health_check_cache', 'ai_o_optimiser_migration_1203',
	'ai_o_optimiser_email_report_settings', 'ai_o_optimiser_email_report_state',
);

// Written only by the Schema, Local/NAP and Metadata modules and the
// commercial subsystem -- the Pro-exclusive set the add-on's uninstall cleans.
$ai_o_optimiser_exclusive_options = array(
	'ai_o_optimiser_gsc_opportunities',
	'ai_o_optimiser_schema_review_cache', 'ai_o_optimiser_schema_fallbacks', 'ai_o_optimiser_schema_fallback_payloads', 'ai_o_optimiser_schema_fallbacks_meta_migrated',
	'ai_o_optimiser_schema_has_fallbacks', 'ai_o_optimiser_schema_review_scope', 'ai_o_optimiser_schema_review_scope_presets', 'ai_o_optimiser_schema_review_history',
	'ai_o_optimiser_schema_review_baseline', 'ai_o_optimiser_schema_scan_queue', 'ai_o_optimiser_schema_ai_semantic_assessment', 'ai_o_optimiser_schema_semantic_mappings',
	'ai_o_optimiser_schema_diagnostics',
	'ai_o_optimiser_local_business_identity', 'ai_o_optimiser_local_discovery_report',
	'ai_o_optimiser_local_google_evidence_enabled', 'ai_o_optimiser_local_gbp_identity', 'ai_o_optimiser_local_citation_nap_sources',
	'ai_o_optimiser_local_citation_nap_job', 'ai_o_optimiser_local_citation_nap_lock', 'ai_o_optimiser_local_profile_discovery',
	'ai_o_optimiser_metadata_settings', 'ai_o_optimiser_metadata_db_version', 'ai_o_optimiser_metadata_scan_job', 'ai_o_optimiser_metadata_scan_lock',
	'ai_o_optimiser_metadata_search_settings', 'ai_o_optimiser_metadata_google_tokens', 'ai_o_optimiser_metadata_search_db_version', 'ai_o_optimiser_metadata_competitor_topics',
	'ai_o_optimiser_metadata_category_settings', 'ai_o_optimiser_metadata_admin_messages', 'ai_o_optimiser_metadata_api_test',
	'ai_o_optimiser_metadata_digest_items', 'ai_o_optimiser_metadata_last_cron_result', 'ai_o_optimiser_metadata_last_external_cron',
	'ai_o_optimiser_metadata_last_external_cron_ts', 'ai_o_optimiser_metadata_last_generation_attempt_ts', 'ai_o_optimiser_metadata_queue_paused',
	'ai_o_optimiser_metadata_search_last_analysis', 'ai_o_optimiser_metadata_search_last_insight', 'ai_o_optimiser_metadata_search_last_sync',
	'ai_o_optimiser_licensing', 'ai_o_optimiser_site_report_state',
);
// (The add-on's own install marker is not listed here: this registry must not
// carry the add-on's prefix, per tests/edition-boundary.php. The add-on build
// appends it to the derived registry from the add-on runtime that defines it.)

$ai_o_optimiser_core_cron_hooks = array(
	'ai_o_optimiser_daily_cleanup', 'ai_o_optimiser_nightly_health_check', 'ai_o_optimiser_visibility_aggregate_backfill',
	'ai_o_optimiser_email_report_send',
);
$ai_o_optimiser_exclusive_cron_hooks = array(
	'ai_o_optimiser_gsc_weekly_sync', 'ai_o_optimiser_local_citation_nap_batch_event', 'ai_o_optimiser_local_profile_discovery_event',
	'ai_o_optimiser_metadata_generate_queue_event', 'ai_o_optimiser_metadata_daily_digest_event', 'ai_o_optimiser_metadata_scan_batch_event',
	'ai_o_optimiser_metadata_search_weekly_event', 'ai_o_optimiser_external_cron_tick', 'ai_o_optimiser_site_report_send',
);

// Post meta. All of it is written by Schema and Metadata workflows, so all of
// it is Pro-exclusive; the union is kept for uninstall.php's sake.
$ai_o_optimiser_exclusive_post_meta = array(
	'_ai_o_optimiser_schema_fallbacks',
	'_ai_o_optimiser_schema_fallback_payloads',
	'_ai_o_optimiser_ai_refresh_opportunity',
	'_ai_o_optimiser_ai_refresh_query',
	'_ai_o_optimiser_ai_refresh_at',
);

return array(
	'tables' => array_merge(
		array(
			'ai_o_optimiser_crawler_log',
			'ai_o_optimiser_visibility_daily',
			'ai_o_optimiser_gsc_rows',
			'ai_o_optimiser_opportunity_workflow',
			'ai_o_optimiser_schema_activity',
			'ai_o_optimiser_metadata_queue',
			'ai_o_optimiser_metadata_search_rows',
			'ai_o_optimiser_metadata_opportunities',
		),
		$ai_o_optimiser_preserved_tables
	),
	'options'    => array_merge( $ai_o_optimiser_core_options, $ai_o_optimiser_exclusive_options ),
	'cron_hooks' => array_merge( $ai_o_optimiser_core_cron_hooks, $ai_o_optimiser_exclusive_cron_hooks ),
	'post_meta'  => $ai_o_optimiser_exclusive_post_meta,
	'material_options' => array(
		'ai_o_optimiser_schema_review_cache', 'ai_o_optimiser_schema_review_history', 'ai_o_optimiser_schema_review_baseline', 'ai_o_optimiser_schema_scan_queue', 'ai_o_optimiser_schema_diagnostics',
		'ai_o_optimiser_local_business_identity', 'ai_o_optimiser_local_discovery_report', 'ai_o_optimiser_local_gbp_identity', 'ai_o_optimiser_local_citation_nap_sources',
		'ai_o_optimiser_local_citation_nap_job', 'ai_o_optimiser_local_profile_discovery', 'ai_o_optimiser_schema_ai_semantic_assessment', 'ai_o_optimiser_schema_semantic_mappings',
	),

	/*
	 * The Pro-exclusive subsets. tools/build-pro-addon.php writes exactly
	 * these into the add-on's own registry; core's uninstall.php subtracts
	 * them from the unions above while the add-on is installed, because then
	 * the add-on owns their removal.
	 */
	'pro_options'    => $ai_o_optimiser_exclusive_options,
	'pro_cron_hooks' => $ai_o_optimiser_exclusive_cron_hooks,
	'pro_post_meta'  => $ai_o_optimiser_exclusive_post_meta,
	// Transient NAME prefixes (the handler expands them to _transient_ and
	// _transient_timeout_ rows) and plain option-name prefixes, all written
	// only by Pro modules. ai_o_optimiser_runtime_lock_ is shared and stays
	// with core's generic sweep.
	'pro_transient_prefixes' => array( 'ai_o_optimiser_metadata_', 'ai_o_optimiser_schema_', 'ai_o_optimiser_gsc_', 'ai_o_optimiser_local_' ),
	'pro_option_prefixes'    => array( 'ai_o_optimiser_schema_scan_rows_' ),
);