<?php
declare(strict_types=1);$_SERVER['HTTP_HOST']='owned-scale-date.invalid';require __DIR__.'/app.php';require __DIR__.'/data.php';require __DIR__.'/scope.php';$app=coreApp('PREFLIGHT');ck(!file_exists($runtime.'/preflight-state.json'),'Fresh exact read batch');$meta=[];foreach(['AI','ZHCT'] as $db){$id=readNative($db,$dm?"SELECT SYS_CONTEXT('USERENV','CURRENT_SCHEMA') schema_name FROM DUAL":'SELECT DATABASE() schema_name,VERSION() version');ck($id[0]['schema_name']===getenv('POC_'.$db.'_SCHEMA'),'Actual independent schema');if(!$dm)ck(strpos($id[0]['version'],'5.6.')===0,'MySQL5.6 exact');$tables=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");$meta[$db]=['schema'=>getenv('POC_'.$db.'_SCHEMA'),'tables'=>array_map('strtolower',array_column($tables,'table_name'))];}saveOnce('metadata-tables.json',$meta);CoreGate::$metadataMap=$meta;$fsp=readNative('ZHCT',$dm?'SELECT COLUMN_NAME,DATA_TYPE,DATA_SCALE FROM USER_TAB_COLUMNS WHERE TABLE_NAME=? AND COLUMN_NAME IN (?,?) ORDER BY COLUMN_ID':'SELECT COLUMN_NAME,DATA_TYPE,COLUMN_TYPE,DATETIME_PRECISION FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA=DATABASE() AND TABLE_NAME=? AND COLUMN_NAME IN (?,?) ORDER BY ORDINAL_POSITION',$dm?['YDY_MEASUREMENT_SESSION','START_TIME','END_TIME']:['ydy_measurement_session','start_time','end_time']);ck(count($fsp)===2,'Exact fresh start/end columns');if(!$dm)foreach($fsp as $c)ck($c['data_type']==='datetime'&&$c['column_type']==='datetime'&&(int)$c['datetime_precision']===0,'Fresh MySQL start/end actual DATETIME_PRECISION0');saveOnce('fresh-date-precision.json',['columns'=>$fsp,'B_expected_fsp0'=>!$dm,'no_physical_change'=>true]);$rows=scaleRows();ck($rows===json_decode(file_get_contents($runtime.'/scale-baseline.json'),true),'All10 marked measurement fullrows unchanged from old seal');ck(count($rows['sessions'])===2&&count($rows['raw'])===2&&count($rows['records'])===6,'Exactly10 existing measurement rows');$expected=$lane==='B'?[374,375]:[344,345];ck(array_column($rows['sessions'],'session_id')===$expected,'Exact Root-authorized two existing session IDs');saveOnce('preflight-state.json',['source'=>sourceProof(),'protection'=>protection(),'scale'=>$rows,'unrelated_hashes'=>scaleHashes(),'HTTP'=>0,'DML'=>0]);echo json_encode(['lane'=>$lane,'own10rows'=>true,'fresh_date_metadata'=>true,'SQL'=>count(file($runtime.'/sql-budget.jsonl')),'HTTP'=>0,'DML'=>0]),"\n";
