<?php
declare(strict_types=1);require __DIR__.'/app.php';require __DIR__.'/data.php';$app=coreApp('PREFLIGHT_FINAL');ck(!file_exists($runtime.'/preflight-read.json'),'Final preflight once');$meta=[];foreach(['AI','ZHCT'] as $db){$identity=readNative($db,$dm?"SELECT SYS_CONTEXT('USERENV','CURRENT_SCHEMA') schema_name FROM DUAL":'SELECT DATABASE() schema_name,VERSION() version');ck($identity[0]['schema_name']===getenv('POC_'.$db.'_SCHEMA'),'Exact approved live schema');if(!$dm)ck(strpos($identity[0]['version'],'5.6.')===0,'Original MySQL5.6');$rows=readNative($db,$dm?'SELECT TABLE_NAME FROM USER_TABLES ORDER BY TABLE_NAME':"SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA=DATABASE() AND TABLE_TYPE='BASE TABLE' ORDER BY TABLE_NAME");$names=array_map('strtolower',array_column($rows,'table_name'));ck(count($names)>0&&count(array_unique($names))===count($names),'Actual unique existing table names');$meta[$db]=['schema'=>getenv('POC_'.$db.'_SCHEMA'),'tables'=>$names];}saveOnce('metadata-tables.json',$meta);CoreGate::$metadataMap=$meta;$u=actorId();$user=readNative('AI','SELECT * FROM yoshop_user WHERE user_id=? AND store_id=?',[$u,10001]);$weights=readNative('AI','SELECT * FROM yoshop_user_weight WHERE user_id=? AND store_id=? ORDER BY date DESC',[$u,10001]);ck(count($user)===1&&(int)$user[0]['is_delete']===0&&$weights===[],'Original real marked actor and frozen typed empty oracle');$protect=protection();saveOnce('preflight-read.json',['actor'=>$u,'tenant'=>10001,'user_fullrows'=>$user,'weight_fullrows'=>$weights,'protection'=>$protect,'source'=>sourceProof(),'HTTP'=>0,'DML'=>0]);echo json_encode(['lane'=>$lane,'preflight'=>true,'cumulative_SQL'=>count(file($runtime.'/sql-budget.jsonl')),'metadata_tables'=>array_map(static function($v){return count($v['tables']);},$meta),'HTTP'=>0,'DML'=>0]),"\n";
