{"data":{"status":"fail","dialect":"postgres","transactionalDdl":true,"statements":[{"index":0,"kind":"ALTER","reversible":"yes","transactional":true,"hazards":[],"inverse":"ALTER TABLE users DROP COLUMN nickname"},{"index":1,"kind":"ALTER","reversible":"no","transactional":true,"hazards":[{"rule":"migration.drop-column","severity":"data-loss","detail":"DROP COLUMN legacy_flag destroys its data"}]}],"witnesses":[{"ruleId":"migration.drop-column","detail":"DROP COLUMN legacy_flag destroys its data","path":"sql","offset":44,"index":1,"expected":"reversible without a backup","actual":"no"}],"versions":{"engine":"migration-reversibility/1","postgres":"PostgreSQL current docs: sql-altertable, sql-createindex, as of 2026-11-04","mysql":"MySQL 8.4 reference: statements that cause an implicit commit, as of 2026-11-04","sqlite":"SQLite ALTER TABLE documentation, as of 2026-11-04"},"limits":["Row counts and data are unknown: a fail-on-data hazard means it fails if the data violates the rule.","Lock durations are not estimated; lock hazards are reported, not scored.","Statements other than DDL, INSERT, UPDATE, DELETE, TRUNCATE, GRANT, REVOKE and COMMENT are unsupported."],"deterministic":true},"_provenance":{"version":"writerslogic-provenance/1","issuer":"did:web:agents.writerslogic.com","verify":{"endpoint":"POST /api/v1/verify-provenance","did":"did:web:agents.writerslogic.com"},"manifest":{"format":"application/json","instance_id":"xmp:iid:419af75b-3701-49e2-ae18-7e19f2e356a1","claim_generator_info":[{"name":"WritersLogic x402 Agent Hub","version":"2.0.0"}],"title":"Migration DDL: data-loss and rollback hazards per dialect","assertions":[{"label":"c2pa.actions.v2","data":{"actions":[{"action":"c2pa.created","when":"2026-11-06T01:30:28.725Z","softwareAgent":{"name":"writerslogic-agent-hub/migration-reversibility","version":"2.0.0"},"digitalSourceType":"http://cv.iptc.org/newscodes/digitalsourcetype/algorithmicMedia","parameters":{"endpoint":"POST /api/v1/migration-reversibility","inputDigest":{"alg":"sha256","hash":"5276391f1c18000c3c81d579afe0803538e37a2f738c89236c0695fd0db1a466","canonicalization":"JCS"}}}]}},{"label":"c2pa.hash.data","data":{"alg":"sha256","hash":"5c95b970936c663cf8c2060d0d75779a591746149d4851bb4e4fcba729e8c8eb","name":"jcs-canonical-json(data)"}}]},"credential":{"@context":["https://www.w3.org/ns/credentials/v2"],"id":"urn:uuid:8950de00-517c-4d74-ad72-63650e846558","type":["VerifiableCredential","AgentOutputCredential"],"issuer":"did:web:agents.writerslogic.com","validFrom":"2026-11-06T01:30:28.725Z","credentialSubject":{"id":"urn:sha256:5c95b970936c663cf8c2060d0d75779a591746149d4851bb4e4fcba729e8c8eb","agent":"migration-reversibility","endpoint":"POST /api/v1/migration-reversibility","outputDigest":{"alg":"sha256","value":"5c95b970936c663cf8c2060d0d75779a591746149d4851bb4e4fcba729e8c8eb","canonicalization":"JCS"},"inputDigest":{"alg":"sha256","value":"5276391f1c18000c3c81d579afe0803538e37a2f738c89236c0695fd0db1a466","canonicalization":"JCS"},"manifestDigest":{"alg":"sha256","value":"ddde918b4443d665e9963948c56e699dfc0d58dfe156681cbe80c2597ad9f5c2","canonicalization":"JCS"},"ingredients":[],"payment":{"scheme":"api-key","network":"eip155:8453","payer":"sample"}},"proof":{"type":"DataIntegrityProof","cryptosuite":"eddsa-jcs-2022","created":"2026-11-06T01:30:28.725Z","verificationMethod":"did:web:agents.writerslogic.com#key-1","proofPurpose":"assertionMethod","proofValue":"z5f6cH3MsRjxua65Gh4S1Vvq5gQMo8J2anVgMvbhFBZQ82zgssVWJQWE1VwTmW7GFhsxfaDB8TB8RR83R76K1wFYZ"}},"ethSignature":{"type":"EIP-191","signer":"did:pkh:eip155:8453:0x3DBd42560cA7a7E448A2c7DfC9E785526189411f","address":"0x3DBd42560cA7a7E448A2c7DfC9E785526189411f","message":"writerslogic-provenance:2103443227807430874be8004eeb997fb119b1232863e5f21d3f4da9acbfe9a6","signature":"0xffffe80962fe888b274d8ba4337b8d46330fab7f36c588c7792f501c86254c45513f1acd69ee1ebee021d85863d3d0840a55af854456822897d9993934a704e31c"}}}