subversion/libsvn_wc/wc-metadata.sql

81    any number of rows in the NODES and ACTUAL_NODE tables.
100   /* The number of rows in the NODES table that have a 'checksum' column
115    on each node in the WC, relative to the NODES table row for the
116    same path. (A NODES row must exist if this node exists, but an
123    NODES row. ("Is known" because a text change on disk may not yet
234 /* The NODES table describes the way WORKING nodes are layered on top of
264    , these are the NODES table rows for the path foo/bar:
266    (0)  "BASE" --->  NODES (op_depth == 0)
267    (1)               NODES (op_depth == 1)
268    (2)               NODES (op_depth == 2)
274    An 'svn revert foo/bar' would remove the NODES of (2).
277 CREATE TABLE NODES (
473 CREATE UNIQUE INDEX I_NODES_PARENT ON NODES (wc_id, parent_relpath,
476 CREATE UNIQUE INDEX I_NODES_MOVED ON NODES (wc_id, moved_to, op_depth);
528   /* Working copy location related fields (like NODES)*/
583    of the NODES and ACTUAL_NODE table is usually a single value, so queries
586    The current hints describe NODES+ACTUAL_NODE as a working copy with
597 WHERE tbl in ('NODES', 'ACTUAL_NODE', 'LOCK', 'WC_LOCK', 'EXTERNALS');
600     ('NODES', 'sqlite_autoindex_NODES_1',               '8000 8000 2 1');
602     ('NODES', 'I_NODES_PARENT',                         '8000 8000 10 2 1');
605     ('NODES', 'I_NODES_MOVED',                          '8000 8000 1 1');
629 /* Format 30 creates a new NODES index for move information, and a new
635 ON NODES (wc_id, moved_to, op_depth);
664 /* Format 31 adds the inherited_props column to the NODES table. C code then
668 ALTER TABLE NODES ADD COLUMN inherited_props BLOB;
674 CREATE UNIQUE INDEX I_NODES_PARENT ON NODES (wc_id, parent_relpath,
719    never will. It's not interesting like in the NODES table: the external's
777  * ACTUAL_NODE.right_checksum, NODES.checksum.