getenv('POC_'.$db.'_SCHEMA'),'tables'=>array_map('strtolower',array_column($tables,'table_name'))];}saveOnce('metadata-tables.json',$meta);CoreGate::$metadataMap=$meta;$schema=[];foreach(['user','staff','user_bind','user_disease','habit','user_other_info','config_enum'] as $t){$name='yoshop_'.$t;$arg=$dm?strtoupper($name):$name;$cols=readNative('AI',$dm?'SELECT COLUMN_NAME,DATA_TYPE,NULLABLE,DATA_DEFAULT,DATA_LENGTH,DATA_PRECISION,DATA_SCALE FROM USER_TAB_COLUMNS WHERE TABLE_NAME=? ORDER BY COLUMN_ID':'SELECT COLUMN_NAME,DATA_TYPE,COLUMN_TYPE,IS_NULLABLE,COLUMN_DEFAULT,CHARACTER_MAXIMUM_LENGTH,NUMERIC_PRECISION,NUMERIC_SCALE,EXTRA FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA=DATABASE() AND TABLE_NAME=? ORDER BY ORDINAL_POSITION',[$arg]);ck(count($cols)>0,'Fresh actual columns '.$t);$indexes=readNative('AI',$dm?'SELECT i.INDEX_NAME,i.UNIQUENESS,c.COLUMN_NAME,c.COLUMN_POSITION FROM USER_INDEXES i JOIN USER_IND_COLUMNS c ON i.INDEX_NAME=c.INDEX_NAME WHERE i.TABLE_NAME=? ORDER BY i.INDEX_NAME,c.COLUMN_POSITION':'SELECT INDEX_NAME,NON_UNIQUE,SEQ_IN_INDEX,COLUMN_NAME,COLLATION,SUB_PART FROM INFORMATION_SCHEMA.STATISTICS WHERE TABLE_SCHEMA=DATABASE() AND TABLE_NAME=? ORDER BY INDEX_NAME,SEQ_IN_INDEX',[$arg]);$constraints=readNative('AI',$dm?'SELECT c.CONSTRAINT_NAME,c.CONSTRAINT_TYPE,c.SEARCH_CONDITION,c.R_CONSTRAINT_NAME,cc.COLUMN_NAME FROM USER_CONSTRAINTS c LEFT JOIN USER_CONS_COLUMNS cc ON c.CONSTRAINT_NAME=cc.CONSTRAINT_NAME WHERE c.TABLE_NAME=? ORDER BY c.CONSTRAINT_NAME,cc.POSITION':'SELECT TABLE_NAME,CONSTRAINT_NAME,COLUMN_NAME,REFERENCED_TABLE_SCHEMA,REFERENCED_TABLE_NAME,REFERENCED_COLUMN_NAME FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA=DATABASE() AND TABLE_NAME=? ORDER BY CONSTRAINT_NAME,ORDINAL_POSITION',[$arg]);$triggers=readNative('AI',$dm?'SELECT * FROM USER_TRIGGERS WHERE TABLE_NAME=?':'SELECT TRIGGER_NAME,EVENT_MANIPULATION,ACTION_TIMING,ACTION_STATEMENT FROM INFORMATION_SCHEMA.TRIGGERS WHERE TRIGGER_SCHEMA=DATABASE() AND EVENT_OBJECT_TABLE=?',[$arg]);ck($triggers===[],'No unknown triggers');$schema[$t]=compact('cols','indexes','constraints','triggers');$schema[$t]['columns']=$cols;unset($schema[$t]['cols']);}saveOnce('schema.json',$schema);$rows=newRows();foreach($rows as $t=>$r)ck($r===[],'Fresh exact own relation0 '.$t);$weight=weightProtect();ck(count($weight['weight9']['user_bind'])===1&&$weight['weight9']['user_bind'][0]['zhct_user_id']===0,'Whole own Bind0 remains');$catalog=[];foreach([2,14,15,16,17] as $type)$catalog[$type]=readNative('AI','SELECT * FROM yoshop_config_enum WHERE enum_type=? AND is_delete=0 ORDER BY '.($dm?'"ORDER"':'`order`'),[$type]);saveOnce('catalog-oracle.json',$catalog);saveOnce('preflight-state.json',['source'=>sourceProof(),'own_rows'=>$rows,'protection'=>$weight,'unrelated_hashes'=>relatedHashes(),'HTTP'=>0,'DML'=>0]);echo json_encode(['lane'=>$lane,'SQL'=>count(file($runtime.'/sql-budget.jsonl')),'fresh7schema'=>true,'own_related0'=>true,'HTTP'=>0,'DML'=>0]),"\n";