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.f...@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 > > >
