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

CREATE TABLE WORK_QUEUE ... twice?

From: Julian Foad <julian.foad_at_wandisco.com>
Date: Tue, 09 Feb 2010 17:42:54 +0000

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 18:43:35 CET

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