You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@subversion.apache.org by Julian Foad <ju...@wandisco.com> on 2010/02/09 17:42:54 UTC
CREATE TABLE WORK_QUEUE ... twice?
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
Re: CREATE TABLE WORK_QUEUE ... twice?
Posted by Julian Foad <ju...@wandisco.com>.
Greg Stein wrote:
> The first one is part of STMT_CREATE_SCHEMA, and the second is part of
> STMT_UPGRADE_TO_13.
Oh, good. Thanks for explaining.
- Julian
Re: CREATE TABLE WORK_QUEUE ... twice?
Posted by Greg Stein <gs...@gmail.com>.
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 <ju...@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
>
>
>