The first one is part of STMT_CREATE_SCHEMA, and the second is part of
STMT_UPGRADE_TO_13.
On Tue, Feb 9, 2010 at 12:42, Julian Foad <julian.foad_at_wandisco.com> wrote:
> subversion/libsvn_wc/wc-metadata.sql contains CREATE TABLE WORK_QUEUE
> (...) twice, the same each time. Intentional?
>
> Here is that section of the file in full:
> [[[
> CREATE TABLE WORK_QUEUE (
> /* Work items are identified by this value. */
> id INTEGER PRIMARY KEY AUTOINCREMENT,
>
> /* A serialized skel specifying the work item. */
> work BLOB NOT NULL
> );
>
>
> /* ------------------------------------------------------------------------- */
>
> CREATE TABLE WC_LOCK (
> /* specifies the location of this node in the local filesystem */
> wc_id INTEGER NOT NULL REFERENCES WCROOT (id),
> local_dir_relpath TEXT NOT NULL,
>
> locked_levels INTEGER NOT NULL DEFAULT -1,
>
> PRIMARY KEY (wc_id, local_dir_relpath)
> );
>
>
> PRAGMA user_version = 16;
>
>
> /* ------------------------------------------------------------------------- */
>
> /* Format 13 introduces the work queue, and erases a few columns from the
> original schema. */
> -- STMT_UPGRADE_TO_13
>
> CREATE TABLE WORK_QUEUE (
> /* Work items are identified by this value. */
> id INTEGER PRIMARY KEY AUTOINCREMENT,
>
> /* A serialized skel specifying the work item. */
> work BLOB NOT NULL
> );
>
> /* The contents of dav_cache are suspect in format 12, so it is best to just
> erase anything there. */
> UPDATE BASE_NODE SET incomplete_children=null, dav_cache=null;
>
> PRAGMA user_version = 13;
> ]]]
>
> - Julian
>
>
>
Received on 2010-02-09 19:58:37 CET