<h2>Checkout-vs-repo Overview</h2>

An overview of info similar to that provided by <tt>fossil changes</tt> and similar commands:

<nowiki><pre>
SELECT
SELECT id,vid,vfile.mrid, deleted, chnged, uuid, size, mtime, pathname
        id,vid, mrid, deleted,
        chnged,
        datetime(mtime,'unixepoch','localtime') as local_time,
        size, uuid, origname, pathname
FROM vfile LEFT JOIN blob ON vfile.mrid=blob.rid
WHERE vid=BLOB_RID_OF_CHECKIN_VERSION
and chnged
ORDER BY pathname
WHERE vid=(SELECT value FROM vvar WHERE name='checkout')
AND chnged
ORDER BY pathname;
</pre></nowiki>


<h2>Ancestry of a File</h2>

An overview of info the ancestry of a file: