[svn.haxx.se] · SVN Dev · SVN Users · SVN Org · TSVN Dev · TSVN Users · Subclipse Dev · Subclipse Users · this month's index

Re: CREATE TABLE WORK_QUEUE ... twice?

From: Greg Stein <gstein_at_gmail.com>
Date: Tue, 9 Feb 2010 13:58:03 -0500

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

This is an archived mail posted to the Subversion Dev mailing list.

This site is subject to the Apache Privacy Policy and the Apache Public Forum Archive Policy.