The version rows and the blobs MUST have no row id and a key whose conflict rule ignores a second row (PRIMARY KEY (id, sum) ON CONFLICT IGNORE and the digest as the key of the blobs, both WITHOUT ROWID), MUST have no unique column, auto-increment or foreign key, and the heads, the names, the siblings and the vector MUST be views; a trigger MUST refuse a row of a replica the database does not trust.
Enforced (check): .github: cd commons/anyfs-sql && bun run verify — suite/schema.test.ts
Proved by: anyfs-sql/suite/schema.test.ts
Written in: anyfs-sql/src/physical/schema.ts
Tests: passed: suite/schema.test.ts the version rows and the blobs have no row id and a key whose conflict rule ignores a seco