/* wc-metadata.sql -- schema used in the wc-metadata SQLite database
* This is intended for use with SQLite 3
*
* ====================================================================
* Copyright (c) 2008 CollabNet. All rights reserved.
*
* This software is licensed as described in the file COPYING, which
* you should have received as part of this distribution. The terms
* are also available at http://subversion.tigris.org/license-1.html.
* If newer versions of this license are posted there, you may use a
* newer version instead, at your option.
*
* This software consists of voluntary contributions made by many
* individuals. For exact contribution history, see the revision
* history and logs, available at http://subversion.tigris.org/.
* ====================================================================
*/
/*
* the KIND column in these tables has one of six values:
* DIRECTORY
* FILE
* SYMLINK
* (absent) DIRECTORY
* (absent) FILE
* (absent) SYMLINK
*/
/* ------------------------------------------------------------------------- */
CREATE TABLE REPOSITORY (
id INTEGER PRIMARY KEY AUTOINCREMENT,
/* the root URL of the repository */
root TEXT NOT NULL,
/* the UUID of the repository */
uuid TEXT NOT NULL
);
/* ------------------------------------------------------------------------- */
CREATE TABLE WCROOT (
id INTEGER PRIMARY KEY AUTOINCREMENT,
/* absolute path in the local filesystem. NULL if storing metadata in the wc */
local_abspath TEXT
);
CREATE UNIQUE INDEX I_LOCAL_ABSPATH ON WCROOT (local_abspath);
/* ------------------------------------------------------------------------- */
CREATE TABLE BASE_NODE (
id INTEGER PRIMARY KEY AUTOINCREMENT,
/* the WCROOT that we are part of. NULL if the metadata is stored in
{wcroot}/.svn/ */
wc_id INTEGER,
/* relative path from wcroot. this will be "" for the wcroot. */
local_relpath TEXT NOT NULL,
/* the repository this node is part of, and the relative path [to its
root] within that repository. these may be NULL, implying it should
be derived from the parent and local_relpath. non-NULL typically
indicates a switched node. */
repos_id INTEGER,
repos_relpath TEXT,
/* parent node. used to aggregate all child nodes of a given parent.
NULL if this is the wcroot node. */
parent_id INTEGER,
revnum INTEGER NOT NULL,
/* file/dir/special. none says this node is NOT present at this REV. */
kind TEXT NOT NULL,
/* if this node is a file, then the checksum and its translated size
(given the properties on this file) are specified by the following
two fields. */
checksum TEXT,
translated_size INTEGER,
/* Information about the last change to this node */
changed_rev INTEGER NOT NULL,
changed_date INTEGER NOT NULL, /* an APR date/time (usec since 1970) */
changed_author TEXT NOT NULL,
/* NULL depth means "default" (typically svn_depth_infinity) */
depth TEXT,
/* ### Do we need this? We've currently got various mod time APIs
### internal to libsvn_wc, but those might be used in answering some
### question which is better answered some other way. */
last_mod_time INTEGER, /* an APR date/time (usec since 1970) */
/* serialized skel of this node's properties. */
properties BLOB NOT NULL,
/* this node is a directory, and all of its child nodes have not (yet)
been created [for this revision number]. Note: boolean value. */
incomplete_children INTEGER
);
CREATE UNIQUE INDEX I_PATH ON BASE_NODE (wc_id, local_relpath);
CREATE INDEX I_PARENT ON BASE_NODE (parent_id);
/* ------------------------------------------------------------------------- */
CREATE TABLE PRISTINE (
/* ### the hash algorithm (MD5 or SHA-1) is encoded in this value */
checksum TEXT NOT NULL PRIMARY KEY,
/* ### enumerated values specifying type of compression. NULL implies
### that no compression has been applied. */
compression INTEGER,
/* ### used to verify the pristine file is "proper". NULL if unknown,
### and (thus) the pristine copy is incomplete/unusable. */
size INTEGER,
refcount INTEGER NOT NULL
);
/* ------------------------------------------------------------------------- */
CREATE TABLE WORKING_NODE (
id INTEGER PRIMARY KEY AUTOINCREMENT,
/* specifies the location of this node in the local filesystem */
wc_id INTEGER,
local_relpath TEXT NOT NULL,
/* parent's local_relpath for aggregating children of a given parent.
this will be "" if the parent is the wcroot. */
parent_relpath TEXT NOT NULL,
/* kind==none implies this node was deleted or moved (see moved_to).
other kinds:
if a BASE_NODE exists at the same local_relpath, then this is a
replaced item (possibly copied or moved here), which implies the
base node should be deleted or moved (see moved_to). */
kind TEXT NOT NULL,
/* Where this node was copied from. Set only on the root of the copy,
and implied for all children. */
copyfrom_repos_id INTEGER,
copyfrom_repos_path TEXT,
copyfrom_revnum INTEGER,
/* If this node was moved (rather than just copied), this specifies
the local_relpath of the source of the move. */
moved_from TEXT,
/* If this node was moved (rather than just deleted), this specifies
where the BASE node was moved to. */
moved_to TEXT,
/* if this node was added-with-history AND is a file, then the checksum
and its translated size (given the properties on this file) are
specified by the following two fields. */
checksum TEXT,
translated_size INTEGER,
/* if this node was added-with-history, then the following fields will
be NOT NULL */
changed_rev INTEGER,
changed_date INTEGER, /* an APR date/time (usec since 1970) */
changed_author TEXT,
/* NULL depth means "default" (typically svn_depth_infinity) */
depth TEXT,
/* ### Do we need this? We've currently got various mod time APIs
### internal to libsvn_wc, but those might be used in answering some
### question which is better answered some other way. */
last_mod_time INTEGER, /* an APR date/time (usec since 1970) */
/* serialized skel of this node's properties. */
properties BLOB NOT NULL,
/* if not NULL, this node is part of a changelist. */
changelist_id INTEGER,
/* if a directory, serialized data for all of tree conflicts therein. */
tree_conflict_data TEXT
);
CREATE UNIQUE INDEX I_WORKING_PATH ON WORKING_NODE (wc_id, local_relpath);
CREATE INDEX I_WORKING_PARENT ON WORKING_NODE (parent_relpath);
/* ------------------------------------------------------------------------- */
CREATE TABLE ACTUAL_NODE (
id INTEGER PRIMARY KEY AUTOINCREMENT,
/* specifies the location of this node in the local filesystem */
wc_id INTEGER,
local_relpath TEXT NOT NULL,
/* serialized skel of this node's properties. NULL implies no change to
the properties, relative to WORKING/BASE as appropriate. */
properties BLOB,
/* ### do we want to record the revnums which caused this? */
conflict_old TEXT,
conflict_new TEXT,
conflict_working TEXT,
prop_reject TEXT, /* ### is this right? */
changelist_id INTEGER
);
/* ------------------------------------------------------------------------- */
CREATE TABLE CHANGELIST (
id INTEGER PRIMARY KEY AUTOINCREMENT,
/* what WCROOT is this changelist part of, or NULL if the metadata is
in the wcroot. */
wc_id INTEGER,
name TEXT NOT NULL
);
CREATE UNIQUE INDEX I_CHANGELIST ON CHANGELIST (wc_id, name);
CREATE UNIQUE INDEX I_CL_LIST ON CHANGELIST (wc_id);
/* ------------------------------------------------------------------------- */
CREATE TABLE LOCK (
/* URL of the node which is locked */
url TEXT NOT NULL PRIMARY KEY,
/* Information about the lock. Note: these values are just caches from
the server, and are not authoritative. */
lock_token TEXT NOT NULL,
/* ### make the following fields NOT NULL ? */
lock_owner TEXT,
lock_comment TEXT,
lock_date INTEGER /* an APR date/time (usec since 1970) */
);
/* ------------------------------------------------------------------------- */