<?php
/**
 * Frozen schema contract.
 *
 * @package LoggedAI
 */

namespace LoggedAI;

defined( 'ABSPATH' ) || exit;

/** Frozen schema contract. Change this manifest with every installer schema change. */
final class MigrationsSchema {
	/**
	 * Assemble the frozen storage contract with current loaded network, account and privacy extensions.
	 *
	 * @return array Component table, column and index contracts used by migration and compatibility validation.
	 *
	 * @throws \JsonException When the fixed embedded schema manifest cannot be decoded.
	 */
	public static function contracts(): array {
		$contracts = json_decode(
			<<<'SCHEMA'
{"events":{"events":{"columns":{"id":{"type":"bigint unsigned","null":false,"auto":true},"uid":{"type":"char(36)","null":false,"auto":false},"schema_version":{"type":"smallint unsigned","null":false,"auto":false},"network_id":{"type":"bigint unsigned","null":false,"auto":false},"site_id":{"type":"bigint unsigned","null":false,"auto":false},"occurred_at":{"type":"datetime(6)","null":false,"auto":false},"ingested_at":{"type":"datetime(6)","null":false,"auto":false},"code":{"type":"varchar(80)","null":false,"auto":false},"category":{"type":"varchar(32)","null":false,"auto":false},"action":{"type":"varchar(32)","null":false,"auto":false},"outcome":{"type":"varchar(24)","null":false,"auto":false},"severity":{"type":"varchar(16)","null":false,"auto":false},"actor_kind":{"type":"varchar(24)","null":false,"auto":false},"actor_id":{"type":"bigint unsigned","null":true,"auto":false},"subject_id":{"type":"bigint unsigned","null":true,"auto":false},"object_type":{"type":"varchar(24)","null":false,"auto":false},"object_id":{"type":"bigint unsigned","null":false,"auto":false},"channel":{"type":"varchar(24)","null":false,"auto":false},"request_id":{"type":"char(36)","null":false,"auto":false},"operation_id":{"type":"char(36)","null":false,"auto":false},"processing_state":{"type":"varchar(16)","null":false,"auto":false},"alert_revision":{"type":"bigint unsigned","null":false,"auto":false},"alert_state":{"type":"varchar(16)","null":false,"auto":false},"payload":{"type":"longtext","null":false,"auto":false}},"indexes":{"PRIMARY":{"unique":true,"columns":["id"]},"uid":{"unique":true,"columns":["uid"]},"site_time":{"unique":false,"columns":["network_id","site_id","occurred_at","id"]},"actor_time":{"unique":false,"columns":["network_id","site_id","actor_id","occurred_at","id"]},"code_time":{"unique":false,"columns":["network_id","site_id","code","occurred_at","id"]},"object_time":{"unique":false,"columns":["network_id","site_id","object_type","object_id","occurred_at","id"]},"request_scope":{"unique":false,"columns":["network_id","site_id","request_id"]},"alerts_pending":{"unique":false,"columns":["network_id","site_id","alert_state","id"]},"processing":{"unique":false,"columns":["processing_state","id"]}}}},"auth":{"auth_windows":{"columns":{"network_id":{"type":"bigint unsigned","null":false,"auto":false},"site_id":{"type":"bigint unsigned","null":false,"auto":false},"window_start":{"type":"bigint unsigned","null":false,"auto":false},"observed_count":{"type":"int unsigned","null":false,"auto":false},"emitted":{"type":"tinyint unsigned","null":false,"auto":false}},"indexes":{"PRIMARY":{"unique":true,"columns":["network_id","site_id","window_start"]}}}},"requests":{"requests":{"columns":{"id":{"type":"bigint unsigned","null":false,"auto":true},"request_uid":{"type":"char(36)","null":false,"auto":false},"network_id":{"type":"bigint unsigned","null":false,"auto":false},"site_id":{"type":"bigint unsigned","null":false,"auto":false},"captured_at":{"type":"datetime","null":false,"auto":false},"ingested_at":{"type":"datetime","null":false,"auto":false},"response_at":{"type":"datetime","null":true,"auto":false},"sensor":{"type":"varchar(24)","null":false,"auto":false},"source":{"type":"varchar(24)","null":false,"auto":false},"parser_version":{"type":"varchar(40)","null":false,"auto":false},"family":{"type":"varchar(48)","null":false,"auto":false},"rule_id":{"type":"varchar(64)","null":false,"auto":false},"rule_revision":{"type":"int unsigned","null":false,"auto":false},"safe_path":{"type":"varchar(100)","null":false,"auto":false},"method":{"type":"varchar(12)","null":false,"auto":false},"reason":{"type":"varchar(160)","null":false,"auto":false},"confidence":{"type":"varchar(24)","null":false,"auto":false},"priority":{"type":"varchar(24)","null":false,"auto":false},"partial":{"type":"tinyint unsigned","null":false,"auto":false},"evidence":{"type":"varchar(4096)","null":false,"auto":false},"group_key":{"type":"char(64)","null":true,"auto":false},"client_mask":{"type":"varchar(48)","null":true,"auto":false},"ip_mode":{"type":"varchar(12)","null":false,"auto":false},"ip_expires_at":{"type":"bigint unsigned","null":true,"auto":false},"status":{"type":"smallint unsigned","null":true,"auto":false},"own_response":{"type":"varchar(32)","null":false,"auto":false},"policy_id":{"type":"char(32)","null":true,"auto":false},"policy_revision":{"type":"int unsigned","null":true,"auto":false},"effect":{"type":"varchar(24)","null":false,"auto":false},"source_derivation":{"type":"varchar(24)","null":false,"auto":false},"source_quality":{"type":"varchar(24)","null":false,"auto":false},"source_generation":{"type":"char(32)","null":false,"auto":false},"alert_revision":{"type":"bigint unsigned","null":false,"auto":false},"alert_state":{"type":"varchar(16)","null":false,"auto":false}},"indexes":{"PRIMARY":{"unique":true,"columns":["id"]},"request_uid":{"unique":true,"columns":["network_id","site_id","request_uid"]},"scope_time":{"unique":false,"columns":["network_id","site_id","captured_at","id"]},"peer_expiry":{"unique":false,"columns":["network_id","site_id","ip_mode","ip_expires_at","id"]},"family_time":{"unique":false,"columns":["network_id","site_id","family","captured_at"]},"alerts_pending":{"unique":false,"columns":["network_id","site_id","alert_state","id"]}}},"request_groups":{"columns":{"group_key":{"type":"char(64)","null":false,"auto":false},"network_id":{"type":"bigint unsigned","null":false,"auto":false},"site_id":{"type":"bigint unsigned","null":false,"auto":false},"window_start":{"type":"bigint unsigned","null":false,"auto":false},"source":{"type":"varchar(24)","null":false,"auto":false},"family":{"type":"varchar(48)","null":false,"auto":false},"first_at":{"type":"datetime","null":false,"auto":false},"last_at":{"type":"datetime","null":false,"auto":false},"admitted_count":{"type":"bigint unsigned","null":false,"auto":false},"partial_count":{"type":"bigint unsigned","null":false,"auto":false},"unknown_count":{"type":"bigint unsigned","null":false,"auto":false},"own_responses":{"type":"bigint unsigned","null":false,"auto":false},"sample_ids":{"type":"varchar(160)","null":false,"auto":false},"status_1xx":{"type":"bigint unsigned","null":false,"auto":false},"status_2xx":{"type":"bigint unsigned","null":false,"auto":false},"status_3xx":{"type":"bigint unsigned","null":false,"auto":false},"status_4xx":{"type":"bigint unsigned","null":false,"auto":false},"status_5xx":{"type":"bigint unsigned","null":false,"auto":false}},"indexes":{"PRIMARY":{"unique":true,"columns":["group_key"]},"scope_window":{"unique":false,"columns":["network_id","site_id","window_start"]},"scope_family":{"unique":false,"columns":["network_id","site_id","family","window_start"]}}},"request_limits":{"columns":{"network_id":{"type":"bigint unsigned","null":false,"auto":false},"site_id":{"type":"bigint unsigned","null":false,"auto":false},"minute_bucket":{"type":"bigint unsigned","null":false,"auto":false},"minute_used":{"type":"int unsigned","null":false,"auto":false},"day_bucket":{"type":"bigint unsigned","null":false,"auto":false},"day_used":{"type":"int unsigned","null":false,"auto":false},"retained_reserved":{"type":"int unsigned","null":false,"auto":false},"groups_reserved":{"type":"int unsigned","null":false,"auto":false},"dropped":{"type":"bigint unsigned","null":false,"auto":false},"last_drop":{"type":"bigint unsigned","null":false,"auto":false}},"indexes":{"PRIMARY":{"unique":true,"columns":["network_id","site_id"]}}},"response_state":{"columns":{"network_id":{"type":"bigint unsigned","null":false,"auto":false},"site_id":{"type":"bigint unsigned","null":false,"auto":false},"schema_version":{"type":"int unsigned","null":false,"auto":false},"enabled":{"type":"tinyint unsigned","null":false,"auto":false},"revision":{"type":"bigint unsigned","null":false,"auto":false},"degraded":{"type":"varchar(80)","null":false,"auto":false},"last_cleanup":{"type":"bigint unsigned","null":false,"auto":false},"last_change":{"type":"bigint unsigned","null":false,"auto":false}},"indexes":{"PRIMARY":{"unique":true,"columns":["network_id","site_id"]}}},"response_policies":{"columns":{"id":{"type":"char(32)","null":false,"auto":false},"network_id":{"type":"bigint unsigned","null":false,"auto":false},"site_id":{"type":"bigint unsigned","null":false,"auto":false},"creator":{"type":"bigint unsigned","null":false,"auto":false},"state":{"type":"varchar(16)","null":false,"auto":false},"origin":{"type":"varchar(16)","null":false,"auto":false},"revision":{"type":"int unsigned","null":false,"auto":false},"parser_version":{"type":"varchar(40)","null":false,"auto":false},"safe_path":{"type":"varchar(100)","null":false,"auto":false},"methods":{"type":"varchar(24)","null":false,"auto":false},"ttl":{"type":"int unsigned","null":false,"auto":false},"compiled_hash":{"type":"char(64)","null":false,"auto":false},"target_kind":{"type":"varchar(16)","null":false,"auto":false},"target_json":{"type":"varchar(2048)","null":true,"auto":false},"target_erased":{"type":"tinyint unsigned","null":false,"auto":false},"target_expires_at":{"type":"bigint unsigned","null":false,"auto":false},"target_captured_at":{"type":"bigint unsigned","null":false,"auto":false},"target_settings_revision":{"type":"bigint unsigned","null":false,"auto":false},"source_request_uid":{"type":"char(36)","null":true,"auto":false},"evidence_id":{"type":"bigint unsigned","null":false,"auto":false},"created_at":{"type":"bigint unsigned","null":false,"auto":false},"starts_at":{"type":"bigint unsigned","null":false,"auto":false},"expires_at":{"type":"bigint unsigned","null":false,"auto":false},"changed_at":{"type":"bigint unsigned","null":false,"auto":false},"target_source_generation":{"type":"char(32)","null":false,"auto":false}},"indexes":{"PRIMARY":{"unique":true,"columns":["id"]},"scope_state":{"unique":false,"columns":["network_id","site_id","state","expires_at"]},"scope_personal":{"unique":false,"columns":["network_id","site_id","target_kind","target_erased","target_expires_at"]},"scope_source_request":{"unique":false,"columns":["network_id","site_id","source_request_uid"]},"scope_creator":{"unique":false,"columns":["network_id","site_id","creator","state"]}}},"response_history":{"columns":{"id":{"type":"bigint unsigned","null":false,"auto":true},"network_id":{"type":"bigint unsigned","null":false,"auto":false},"site_id":{"type":"bigint unsigned","null":false,"auto":false},"policy_id":{"type":"char(32)","null":true,"auto":false},"actor_id":{"type":"bigint unsigned","null":false,"auto":false},"action":{"type":"varchar(40)","null":false,"auto":false},"happened_at":{"type":"bigint unsigned","null":false,"auto":false},"revision":{"type":"bigint unsigned","null":false,"auto":false}},"indexes":{"PRIMARY":{"unique":true,"columns":["id"]},"scope_time":{"unique":false,"columns":["network_id","site_id","happened_at","id"]}}}},"exports":{"export_jobs":{"columns":{"id":{"type":"char(36)","null":false,"auto":false},"network_id":{"type":"bigint unsigned","null":false,"auto":false},"site_id":{"type":"bigint unsigned","null":false,"auto":false},"principal":{"type":"bigint unsigned","null":false,"auto":false},"personal_subject":{"type":"bigint unsigned","null":true,"auto":false},"format":{"type":"varchar(8)","null":false,"auto":false},"filters":{"type":"longtext","null":false,"auto":false},"generation":{"type":"bigint unsigned","null":false,"auto":false},"state":{"type":"varchar(16)","null":false,"auto":false},"reason":{"type":"varchar(32)","null":false,"auto":false},"created_at":{"type":"datetime(6)","null":false,"auto":false},"expires_at":{"type":"datetime(6)","null":false,"auto":false},"membership_at":{"type":"datetime(6)","null":true,"auto":false},"completed_at":{"type":"datetime(6)","null":true,"auto":false},"purged_at":{"type":"datetime(6)","null":true,"auto":false},"lease_until":{"type":"datetime(6)","null":true,"auto":false},"cursor_id":{"type":"bigint unsigned","null":false,"auto":false},"chunks":{"type":"int unsigned","null":false,"auto":false},"membership_count":{"type":"bigint unsigned","null":false,"auto":false},"row_count":{"type":"bigint unsigned","null":false,"auto":false},"missing_count":{"type":"bigint unsigned","null":false,"auto":false},"byte_count":{"type":"bigint unsigned","null":false,"auto":false},"manifest":{"type":"longtext","null":true,"auto":false},"sha256":{"type":"char(64)","null":true,"auto":false}},"indexes":{"PRIMARY":{"unique":true,"columns":["id"]},"scope_owner":{"unique":false,"columns":["network_id","site_id","principal","created_at"]},"scope_state":{"unique":false,"columns":["network_id","site_id","state","created_at"]},"expiry":{"unique":false,"columns":["expires_at"]}}},"export_items":{"columns":{"job_id":{"type":"char(36)","null":false,"auto":false},"event_id":{"type":"bigint unsigned","null":false,"auto":false},"event_uid":{"type":"char(36)","null":false,"auto":false}},"indexes":{"PRIMARY":{"unique":true,"columns":["job_id","event_id"]}}}},"alerts":{"deliveries":{"columns":{"id":{"type":"char(32)","null":false,"auto":false},"logical_key":{"type":"char(64)","null":false,"auto":false},"network_id":{"type":"bigint unsigned","null":false,"auto":false},"site_id":{"type":"bigint unsigned","null":false,"auto":false},"event_uid":{"type":"char(36)","null":true,"auto":false},"event_id":{"type":"bigint unsigned","null":false,"auto":false},"rule_key":{"type":"varchar(32)","null":false,"auto":false},"config_revision":{"type":"bigint unsigned","null":false,"auto":false},"recipient_id":{"type":"bigint unsigned","null":false,"auto":false},"state":{"type":"varchar(24)","null":false,"auto":false},"synthetic":{"type":"tinyint unsigned","null":false,"auto":false},"attempts":{"type":"smallint unsigned","null":false,"auto":false},"next_attempt":{"type":"bigint unsigned","null":false,"auto":false},"created_at":{"type":"bigint unsigned","null":false,"auto":false},"expires_at":{"type":"bigint unsigned","null":false,"auto":false},"attempted_at":{"type":"bigint unsigned","null":false,"auto":false},"fact_kind":{"type":"varchar(12)","null":false,"auto":false}},"indexes":{"PRIMARY":{"unique":true,"columns":["id"]},"logical_key":{"unique":true,"columns":["logical_key"]},"scope_state":{"unique":false,"columns":["network_id","site_id","state","next_attempt"]},"state_queue":{"unique":false,"columns":["state","next_attempt"]},"scope_event":{"unique":false,"columns":["network_id","site_id","event_uid"]},"kind_state":{"unique":false,"columns":["fact_kind","state"]},"scope_kind_state":{"unique":false,"columns":["network_id","site_id","fact_kind","state","next_attempt"]}}},"alert_cooldowns":{"columns":{"id":{"type":"char(64)","null":false,"auto":false},"network_id":{"type":"bigint unsigned","null":false,"auto":false},"site_id":{"type":"bigint unsigned","null":false,"auto":false},"last_job":{"type":"char(32)","null":false,"auto":false},"eligible_at":{"type":"bigint unsigned","null":false,"auto":false}},"indexes":{"PRIMARY":{"unique":true,"columns":["id"]},"scope_expiry":{"unique":false,"columns":["network_id","site_id","eligible_at"]}}}}}
SCHEMA
			,
			true,
			32,
			JSON_THROW_ON_ERROR
		);
		if ( class_exists( NetworkPrivacy::class ) && method_exists( NetworkPrivacy::class, 'migration_manifest' ) ) { // @phpstan-ignore function.alreadyNarrowedType (Network privacy is an optional loaded module; retain its manifest capability check before extending the migration contract.)
			$contracts['network'] = NetworkPrivacy::migration_manifest(); }
		if ( class_exists( AccountAuthCollectors::class ) ) {
			$contracts['auth'] += AccountAuthCollectors::migration_manifest(); }
		$contracts['exports']['export_jobs']['columns']['storage_version'] = array( 'type' => 'tinyint unsigned', 'null' => false, 'auto' => false );
		$contracts['exports']['export_chunks'] = json_decode( '{"columns":{"job_id":{"type":"char(36)","null":false,"auto":false},"sequence":{"type":"int unsigned","null":false,"auto":false},"part":{"type":"smallint unsigned","null":false,"auto":false},"payload":{"type":"mediumblob","null":false,"auto":false}},"indexes":{"PRIMARY":{"unique":true,"columns":["job_id","sequence","part"]}}}', true, 8, JSON_THROW_ON_ERROR );
		$contracts['exports']['export_jobs']['columns']['personal_context_version'] = array(
			'type' => 'tinyint unsigned',
			'null' => false,
			'auto' => false,
		);
		foreach ( array(
			'baseline_decision_cursor' => 'bigint unsigned',
			'baseline_history_cursor'  => 'bigint unsigned',
			'baseline_done'            => 'tinyint unsigned',
			'personal_record_count'    => 'int unsigned',
			'incident_case_cursor'     => 'bigint unsigned',
			'incident_done'            => 'tinyint unsigned',
			'request_binding'          => 'char(64)',
			'report_search_cursor'     => 'bigint unsigned',
			'report_schedule_cursor'   => 'bigint unsigned',
			'report_job_cursor'        => 'bigint unsigned',
			'report_done'              => 'tinyint unsigned',
			'incident_runner_done'     => 'tinyint unsigned',
			'advanced_cursor'          => 'varchar(2048)',
			'advanced_binding'         => 'varchar(48)',
			'advanced_done'            => 'tinyint unsigned',
		) as $column => $type ) {
			$contracts['exports']['export_jobs']['columns'][ $column ] = array(
				'type' => $type,
				'null' => false,
				'auto' => false,
			); }
		$contracts['exports']['export_jobs']['columns']['request_valid_until'] = array(
			'type' => 'datetime(6)',
			'null' => true,
			'auto' => false,
		);
		$contracts['automatic'] = RequestsAutomaticSchema::migration_manifest();
		return $contracts;
	}
}