<?php
declare(strict_types=1);require __DIR__.'/connect.php';require __DIR__.'/schema.php';$check($dm&&$lane==='C','Only approved DM schema');$original=$schema('YOSHOP_EQUIPMENT');$check(count($original['columns'])===12&&!in_array('STATUS',array_column($original['columns'],'column_name'),true),'Original exact12 no STATUS');$check($q('SELECT COUNT(*) n FROM yoshop_equipment')[0]['n']==0&&$original['triggers']===[],'Original table empty no trigger');$collision=$q('SELECT CONSTRAINT_NAME FROM USER_CONSTRAINTS WHERE CONSTRAINT_NAME IN (?,?)',['CK_EQ_STATUS_U8_11E70B','CK_EQ_STATUS_TMP_11E70B']);$check($collision===[],'Fixed constraint names unused');$check($q('SELECT OBJECT_NAME FROM USER_OBJECTS WHERE OBJECT_NAME=?',['CDX_STATUS_PREFLIGHT_11E70B'])===[],'Temporary rehearsal name unused');$persist('equipment-schema-original.json',$original);$out=['lane'=>'C','HTTP'=>0,'DML'=>0,'DDL'=>0,'original_rows'=>0,'original_columns'=>12,'original_constraints'=>count($original['constraints']),'original_indexes'=>count($original['indexes']),'original_triggers'=>0,'collision_free'=>true,'original_metadata_sha256'=>hash('sha256',json_encode($original)),'single_DDL_sha256'=>hash_file('sha256',__DIR__.'/equipment-status-add.sql')];file_put_contents(__DIR__.'/ddl-baseline-C.json',json_encode($out,JSON_PRETTY_PRINT));echo json_encode($out),"\n";
