<?php
require __DIR__.'/common.php';
$fresh=$q('SELECT COLUMN_NAME,DATA_TYPE,DATA_LENGTH,DATA_PRECISION,DATA_SCALE,NULLABLE,DATA_DEFAULT FROM USER_TAB_COLUMNS WHERE TABLE_NAME=? ORDER BY COLUMN_ID',['YDY_MEAL_ORDER_SUPPLEMENT']);
$old=json_decode(file_get_contents(__DIR__.'/preflight-C.json'),true)['schema']['store']['meal_order_supplement'];
$changes=[];foreach($fresh as $i=>$r)foreach($r as $k=>$v)if($v!==$old[$i][$k])$changes[]=['column'=>$r['column_name'],'key'=>$k,'fresh'=>$v,'fresh_type'=>gettype($v),'old'=>$old[$i][$k],'old_type'=>gettype($old[$i][$k])];
$save('fresh-metadata-diagnostic.json',['fresh'=>$fresh,'old'=>$old,'differences'=>$changes,'native'=>$GLOBALS['FL_ORACLE']]);echo json_encode(['differences'=>$changes],JSON_UNESCAPED_UNICODE|JSON_PRESERVE_ZERO_FRACTION),"\n";