You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@subversion.apache.org by ju...@apache.org on 2010/10/06 14:40:42 UTC
svn commit: r1005008 - /subversion/trunk/subversion/libsvn_wc/wc-metadata.sql
Author: julianfoad
Date: Wed Oct 6 12:40:42 2010
New Revision: 1005008
URL: http://svn.apache.org/viewvc?rev=1005008&view=rev
Log:
* subversion/libsvn_wc/wc-metadata.sql
(DISABLED_STMT_UPGRADE_TO_20): Use named columns in the insertion, so the
order of columns in the table doesn't matter.
Modified:
subversion/trunk/subversion/libsvn_wc/wc-metadata.sql
Modified: subversion/trunk/subversion/libsvn_wc/wc-metadata.sql
URL: http://svn.apache.org/viewvc/subversion/trunk/subversion/libsvn_wc/wc-metadata.sql?rev=1005008&r1=1005007&r2=1005008&view=diff
==============================================================================
--- subversion/trunk/subversion/libsvn_wc/wc-metadata.sql (original)
+++ subversion/trunk/subversion/libsvn_wc/wc-metadata.sql Wed Oct 6 12:40:42 2010
@@ -991,7 +991,13 @@ PRAGMA user_version = 18;
-- DISABLED_STMT_UPGRADE_TO_20
-INSERT INTO NODES
+INSERT INTO NODES (
+ wc_id, local_relpath, op_depth, parent_relpath,
+ repos_id, repos_path, revision,
+ presence, depth, moved_here, moved_to, kind,
+ changed_revision, changed_date, changed_author,
+ checksum, properties, translated_size, last_mod_time,
+ dav_cache, symlink_target, file_external )
SELECT wc_id, local_relpath, 0 AS op_depth, parent_relpath,
repos_id, repos_relpath, revnum,
presence, depth, NULL AS moved_here, NULL AS moved_to, kind,
@@ -999,7 +1005,13 @@ SELECT wc_id, local_relpath, 0 AS op_dep
checksum, properties, translated_size, last_mod_time,
dav_cache, symlink_target, file_external
FROM BASE_NODE;
-INSERT INTO NODES
+INSERT INTO NODES (
+ wc_id, local_relpath, op_depth, parent_relpath,
+ repos_id, repos_path, revision,
+ presence, depth, moved_here, moved_to, kind,
+ changed_revision, changed_date, changed_author,
+ checksum, properties, translated_size, last_mod_time,
+ dav_cache, symlink_target, file_external )
SELECT wc_id, local_relpath, 2 AS op_depth, parent_relpath,
copyfrom_repos_id, copyfrom_repos_path, copyfrom_revnum,
presence, depth, NULL AS moved_here, NULL AS moved_to, kind,