aboutsummaryrefslogtreecommitdiffstats
path: root/subversion/libsvn_wc/wc-queries.h
diff options
context:
space:
mode:
authorPeter Wemm <peter@FreeBSD.org>2018-05-08 03:44:38 +0000
committerPeter Wemm <peter@FreeBSD.org>2018-05-08 03:44:38 +0000
commit3faf8d6bffc5d0fb2525ba37bb504c53366caf9d (patch)
tree7e47911263e75034b767fe34b2f8d3d17e91f66d /subversion/libsvn_wc/wc-queries.h
parenta55fb3c0d5eca7d887798125d5b95942b1f01d4b (diff)
downloadsrc-3faf8d6bffc5d0fb2525ba37bb504c53366caf9d.tar.gz
src-3faf8d6bffc5d0fb2525ba37bb504c53366caf9d.zip
Import Subversion-1.10.0vendor/subversion/subversion-1.10.0
Notes
Notes: svn path=/vendor/subversion/dist/; revision=333347 svn path=/vendor/subversion/subversion-1.10.0/; revision=333348; tag=vendor/subversion/subversion-1.10.0
Diffstat (limited to 'subversion/libsvn_wc/wc-queries.h')
-rw-r--r--subversion/libsvn_wc/wc-queries.h617
1 files changed, 184 insertions, 433 deletions
diff --git a/subversion/libsvn_wc/wc-queries.h b/subversion/libsvn_wc/wc-queries.h
index 2a7594067ed6..b333e95ffdbe 100644
--- a/subversion/libsvn_wc/wc-queries.h
+++ b/subversion/libsvn_wc/wc-queries.h
@@ -1,4 +1,4 @@
-/* This file is automatically generated from wc-queries.sql and .dist_sandbox/subversion-1.9.7/subversion/libsvn_wc/token-map.h.
+/* This file is automatically generated from wc-queries.sql and subversion/libsvn_wc/token-map.h.
* Do not edit this file -- edit the source and rerun gen-make.py */
#define STMT_SELECT_NODE_INFO 0
@@ -23,7 +23,7 @@
" lock_token, lock_owner, lock_comment, lock_date " \
"FROM nodes " \
"LEFT OUTER JOIN lock ON nodes.repos_id = lock.repos_id " \
- " AND nodes.repos_path = lock.repos_relpath " \
+ " AND nodes.repos_path = lock.repos_relpath AND nodes.op_depth=0 " \
"WHERE wc_id = ?1 AND local_relpath = ?2 " \
"ORDER BY op_depth DESC " \
""
@@ -132,7 +132,7 @@
" lock_comment, lock_date, local_relpath, moved_here, moved_to, file_external " \
"FROM nodes " \
"LEFT OUTER JOIN lock ON nodes.repos_id = lock.repos_id " \
- " AND nodes.repos_path = lock.repos_relpath AND op_depth = 0 " \
+ " AND nodes.repos_path = lock.repos_relpath AND nodes.op_depth = 0 " \
"WHERE wc_id = ?1 AND parent_relpath = ?2 " \
"ORDER BY local_relpath DESC, op_depth DESC " \
""
@@ -146,7 +146,7 @@
" lock_comment, lock_date, local_relpath, moved_here, moved_to, file_external " \
"FROM nodes " \
"LEFT OUTER JOIN lock ON nodes.repos_id = lock.repos_id " \
- " AND nodes.repos_path = lock.repos_relpath AND op_depth = 0 " \
+ " AND nodes.repos_path = lock.repos_relpath " \
"WHERE wc_id = ?1 AND parent_relpath = ?2 AND op_depth = 0 " \
"ORDER BY local_relpath DESC " \
""
@@ -1627,37 +1627,44 @@
"PRAGMA journal_mode = DELETE " \
""
-#define STMT_INSERT_ACTUAL_NODE 152
-#define STMT_152_INFO {"STMT_INSERT_ACTUAL_NODE", NULL}
+#define STMT_FIND_REPOS_PATH_IN_WC 152
+#define STMT_152_INFO {"STMT_FIND_REPOS_PATH_IN_WC", NULL}
#define STMT_152 \
+ "SELECT local_relpath FROM nodes_current " \
+ " WHERE wc_id = ?1 AND repos_path = ?2 " \
+ ""
+
+#define STMT_INSERT_ACTUAL_NODE 153
+#define STMT_153_INFO {"STMT_INSERT_ACTUAL_NODE", NULL}
+#define STMT_153 \
"INSERT OR REPLACE INTO actual_node ( " \
" wc_id, local_relpath, parent_relpath, properties, changelist, conflict_data) " \
"VALUES (?1, ?2, ?3, ?4, ?5, ?6) " \
""
-#define STMT_SELECT_ALL_FILES 153
-#define STMT_153_INFO {"STMT_SELECT_ALL_FILES", NULL}
-#define STMT_153 \
+#define STMT_SELECT_ALL_FILES 154
+#define STMT_154_INFO {"STMT_SELECT_ALL_FILES", NULL}
+#define STMT_154 \
"SELECT local_relpath FROM nodes_current " \
"WHERE wc_id = ?1 AND parent_relpath = ?2 AND kind = 'file' " \
""
-#define STMT_UPDATE_NODE_PROPS 154
-#define STMT_154_INFO {"STMT_UPDATE_NODE_PROPS", NULL}
-#define STMT_154 \
+#define STMT_UPDATE_NODE_PROPS 155
+#define STMT_155_INFO {"STMT_UPDATE_NODE_PROPS", NULL}
+#define STMT_155 \
"UPDATE nodes SET properties = ?4 " \
"WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = ?3 " \
""
-#define STMT_PRAGMA_TABLE_INFO_NODES 155
-#define STMT_155_INFO {"STMT_PRAGMA_TABLE_INFO_NODES", NULL}
-#define STMT_155 \
+#define STMT_PRAGMA_TABLE_INFO_NODES 156
+#define STMT_156_INFO {"STMT_PRAGMA_TABLE_INFO_NODES", NULL}
+#define STMT_156 \
"PRAGMA table_info(\"NODES\") " \
""
-#define STMT_CREATE_TARGET_PROP_CACHE 156
-#define STMT_156_INFO {"STMT_CREATE_TARGET_PROP_CACHE", NULL}
-#define STMT_156 \
+#define STMT_CREATE_TARGET_PROP_CACHE 157
+#define STMT_157_INFO {"STMT_CREATE_TARGET_PROP_CACHE", NULL}
+#define STMT_157 \
"DROP TABLE IF EXISTS target_prop_cache; " \
"CREATE TEMPORARY TABLE target_prop_cache ( " \
" local_relpath TEXT NOT NULL PRIMARY KEY, " \
@@ -1666,9 +1673,9 @@
"); " \
""
-#define STMT_CACHE_TARGET_PROPS 157
-#define STMT_157_INFO {"STMT_CACHE_TARGET_PROPS", NULL}
-#define STMT_157 \
+#define STMT_CACHE_TARGET_PROPS 158
+#define STMT_158_INFO {"STMT_CACHE_TARGET_PROPS", NULL}
+#define STMT_158 \
"INSERT INTO target_prop_cache(local_relpath, kind, properties) " \
" SELECT n.local_relpath, n.kind, " \
" IFNULL((SELECT properties FROM actual_node AS a " \
@@ -1687,9 +1694,9 @@
" ORDER BY t.local_relpath " \
""
-#define STMT_CACHE_TARGET_PRISTINE_PROPS 158
-#define STMT_158_INFO {"STMT_CACHE_TARGET_PRISTINE_PROPS", NULL}
-#define STMT_158 \
+#define STMT_CACHE_TARGET_PRISTINE_PROPS 159
+#define STMT_159_INFO {"STMT_CACHE_TARGET_PRISTINE_PROPS", NULL}
+#define STMT_159 \
"INSERT INTO target_prop_cache(local_relpath, kind, properties) " \
" SELECT n.local_relpath, n.kind, " \
" CASE n.presence " \
@@ -1714,22 +1721,22 @@
" ORDER BY t.local_relpath " \
""
-#define STMT_SELECT_ALL_TARGET_PROP_CACHE 159
-#define STMT_159_INFO {"STMT_SELECT_ALL_TARGET_PROP_CACHE", NULL}
-#define STMT_159 \
+#define STMT_SELECT_ALL_TARGET_PROP_CACHE 160
+#define STMT_160_INFO {"STMT_SELECT_ALL_TARGET_PROP_CACHE", NULL}
+#define STMT_160 \
"SELECT local_relpath, properties FROM target_prop_cache " \
"ORDER BY local_relpath " \
""
-#define STMT_DROP_TARGET_PROP_CACHE 160
-#define STMT_160_INFO {"STMT_DROP_TARGET_PROP_CACHE", NULL}
-#define STMT_160 \
+#define STMT_DROP_TARGET_PROP_CACHE 161
+#define STMT_161_INFO {"STMT_DROP_TARGET_PROP_CACHE", NULL}
+#define STMT_161 \
"DROP TABLE target_prop_cache; " \
""
-#define STMT_CREATE_REVERT_LIST 161
-#define STMT_161_INFO {"STMT_CREATE_REVERT_LIST", NULL}
-#define STMT_161 \
+#define STMT_CREATE_REVERT_LIST 162
+#define STMT_162_INFO {"STMT_CREATE_REVERT_LIST", NULL}
+#define STMT_162 \
"DROP TABLE IF EXISTS revert_list; " \
"CREATE TEMPORARY TABLE revert_list ( " \
" local_relpath TEXT NOT NULL, " \
@@ -1787,26 +1794,26 @@
"END " \
""
-#define STMT_DROP_REVERT_LIST_TRIGGERS 162
-#define STMT_162_INFO {"STMT_DROP_REVERT_LIST_TRIGGERS", NULL}
-#define STMT_162 \
+#define STMT_DROP_REVERT_LIST_TRIGGERS 163
+#define STMT_163_INFO {"STMT_DROP_REVERT_LIST_TRIGGERS", NULL}
+#define STMT_163 \
"DROP TRIGGER trigger_revert_list_nodes; " \
"DROP TRIGGER trigger_revert_list_actual_delete; " \
"DROP TRIGGER trigger_revert_list_actual_update " \
""
-#define STMT_SELECT_REVERT_LIST 163
-#define STMT_163_INFO {"STMT_SELECT_REVERT_LIST", NULL}
-#define STMT_163 \
+#define STMT_SELECT_REVERT_LIST 164
+#define STMT_164_INFO {"STMT_SELECT_REVERT_LIST", NULL}
+#define STMT_164 \
"SELECT actual, notify, kind, op_depth, repos_id, conflict_data " \
"FROM revert_list " \
"WHERE local_relpath = ?1 " \
"ORDER BY actual DESC " \
""
-#define STMT_SELECT_REVERT_LIST_COPIED_CHILDREN 164
-#define STMT_164_INFO {"STMT_SELECT_REVERT_LIST_COPIED_CHILDREN", NULL}
-#define STMT_164 \
+#define STMT_SELECT_REVERT_LIST_COPIED_CHILDREN 165
+#define STMT_165_INFO {"STMT_SELECT_REVERT_LIST_COPIED_CHILDREN", NULL}
+#define STMT_165 \
"SELECT local_relpath, kind " \
"FROM revert_list " \
"WHERE (((local_relpath) > (CASE (?1) WHEN '' THEN '' ELSE (?1) || '/' END)) AND ((local_relpath) < CASE (?1) WHEN '' THEN X'FFFF' ELSE (?1) || '0' END)) " \
@@ -1815,15 +1822,15 @@
"ORDER BY local_relpath " \
""
-#define STMT_DELETE_REVERT_LIST 165
-#define STMT_165_INFO {"STMT_DELETE_REVERT_LIST", NULL}
-#define STMT_165 \
+#define STMT_DELETE_REVERT_LIST 166
+#define STMT_166_INFO {"STMT_DELETE_REVERT_LIST", NULL}
+#define STMT_166 \
"DELETE FROM revert_list WHERE local_relpath = ?1 " \
""
-#define STMT_SELECT_REVERT_LIST_RECURSIVE 166
-#define STMT_166_INFO {"STMT_SELECT_REVERT_LIST_RECURSIVE", NULL}
-#define STMT_166 \
+#define STMT_SELECT_REVERT_LIST_RECURSIVE 167
+#define STMT_167_INFO {"STMT_SELECT_REVERT_LIST_RECURSIVE", NULL}
+#define STMT_167 \
"SELECT p.local_relpath, n.kind, a.notify, a.kind " \
"FROM (SELECT DISTINCT local_relpath " \
" FROM revert_list " \
@@ -1834,32 +1841,32 @@
"ORDER BY p.local_relpath " \
""
-#define STMT_DELETE_REVERT_LIST_RECURSIVE 167
-#define STMT_167_INFO {"STMT_DELETE_REVERT_LIST_RECURSIVE", NULL}
-#define STMT_167 \
+#define STMT_DELETE_REVERT_LIST_RECURSIVE 168
+#define STMT_168_INFO {"STMT_DELETE_REVERT_LIST_RECURSIVE", NULL}
+#define STMT_168 \
"DELETE FROM revert_list " \
"WHERE (local_relpath = ?1 " \
" OR (((local_relpath) > (CASE (?1) WHEN '' THEN '' ELSE (?1) || '/' END)) AND ((local_relpath) < CASE (?1) WHEN '' THEN X'FFFF' ELSE (?1) || '0' END))) " \
""
-#define STMT_DROP_REVERT_LIST 168
-#define STMT_168_INFO {"STMT_DROP_REVERT_LIST", NULL}
-#define STMT_168 \
+#define STMT_DROP_REVERT_LIST 169
+#define STMT_169_INFO {"STMT_DROP_REVERT_LIST", NULL}
+#define STMT_169 \
"DROP TABLE IF EXISTS revert_list " \
""
-#define STMT_CREATE_DELETE_LIST 169
-#define STMT_169_INFO {"STMT_CREATE_DELETE_LIST", NULL}
-#define STMT_169 \
+#define STMT_CREATE_DELETE_LIST 170
+#define STMT_170_INFO {"STMT_CREATE_DELETE_LIST", NULL}
+#define STMT_170 \
"DROP TABLE IF EXISTS delete_list; " \
"CREATE TEMPORARY TABLE delete_list ( " \
" local_relpath TEXT PRIMARY KEY NOT NULL UNIQUE " \
" ) " \
""
-#define STMT_INSERT_DELETE_LIST 170
-#define STMT_170_INFO {"STMT_INSERT_DELETE_LIST", NULL}
-#define STMT_170 \
+#define STMT_INSERT_DELETE_LIST 171
+#define STMT_171_INFO {"STMT_INSERT_DELETE_LIST", NULL}
+#define STMT_171 \
"INSERT INTO delete_list(local_relpath) " \
"SELECT ?2 " \
"UNION ALL " \
@@ -1875,22 +1882,22 @@
"ORDER by local_relpath " \
""
-#define STMT_SELECT_DELETE_LIST 171
-#define STMT_171_INFO {"STMT_SELECT_DELETE_LIST", NULL}
-#define STMT_171 \
+#define STMT_SELECT_DELETE_LIST 172
+#define STMT_172_INFO {"STMT_SELECT_DELETE_LIST", NULL}
+#define STMT_172 \
"SELECT local_relpath FROM delete_list " \
"ORDER BY local_relpath " \
""
-#define STMT_FINALIZE_DELETE 172
-#define STMT_172_INFO {"STMT_FINALIZE_DELETE", NULL}
-#define STMT_172 \
+#define STMT_FINALIZE_DELETE 173
+#define STMT_173_INFO {"STMT_FINALIZE_DELETE", NULL}
+#define STMT_173 \
"DROP TABLE IF EXISTS delete_list " \
""
-#define STMT_CREATE_UPDATE_MOVE_LIST 173
-#define STMT_173_INFO {"STMT_CREATE_UPDATE_MOVE_LIST", NULL}
-#define STMT_173 \
+#define STMT_CREATE_UPDATE_MOVE_LIST 174
+#define STMT_174_INFO {"STMT_CREATE_UPDATE_MOVE_LIST", NULL}
+#define STMT_174 \
"DROP TABLE IF EXISTS update_move_list; " \
"CREATE TEMPORARY TABLE update_move_list ( " \
" local_relpath TEXT PRIMARY KEY NOT NULL UNIQUE, " \
@@ -1901,39 +1908,39 @@
" ) " \
""
-#define STMT_INSERT_UPDATE_MOVE_LIST 174
-#define STMT_174_INFO {"STMT_INSERT_UPDATE_MOVE_LIST", NULL}
-#define STMT_174 \
+#define STMT_INSERT_UPDATE_MOVE_LIST 175
+#define STMT_175_INFO {"STMT_INSERT_UPDATE_MOVE_LIST", NULL}
+#define STMT_175 \
"INSERT INTO update_move_list(local_relpath, action, kind, content_state, " \
" prop_state) " \
"VALUES (?1, ?2, ?3, ?4, ?5) " \
""
-#define STMT_SELECT_UPDATE_MOVE_LIST 175
-#define STMT_175_INFO {"STMT_SELECT_UPDATE_MOVE_LIST", NULL}
-#define STMT_175 \
+#define STMT_SELECT_UPDATE_MOVE_LIST 176
+#define STMT_176_INFO {"STMT_SELECT_UPDATE_MOVE_LIST", NULL}
+#define STMT_176 \
"SELECT local_relpath, action, kind, content_state, prop_state " \
"FROM update_move_list " \
"ORDER BY local_relpath " \
""
-#define STMT_FINALIZE_UPDATE_MOVE 176
-#define STMT_176_INFO {"STMT_FINALIZE_UPDATE_MOVE", NULL}
-#define STMT_176 \
+#define STMT_FINALIZE_UPDATE_MOVE 177
+#define STMT_177_INFO {"STMT_FINALIZE_UPDATE_MOVE", NULL}
+#define STMT_177 \
"DROP TABLE IF EXISTS update_move_list " \
""
-#define STMT_MOVE_NOTIFY_TO_REVERT 177
-#define STMT_177_INFO {"STMT_MOVE_NOTIFY_TO_REVERT", NULL}
-#define STMT_177 \
+#define STMT_MOVE_NOTIFY_TO_REVERT 178
+#define STMT_178_INFO {"STMT_MOVE_NOTIFY_TO_REVERT", NULL}
+#define STMT_178 \
"INSERT INTO revert_list (local_relpath, notify, kind, actual) " \
" SELECT local_relpath, 2, kind, 1 FROM update_move_list; " \
"DROP TABLE update_move_list " \
""
-#define STMT_SELECT_MIN_MAX_REVISIONS 178
-#define STMT_178_INFO {"STMT_SELECT_MIN_MAX_REVISIONS", NULL}
-#define STMT_178 \
+#define STMT_SELECT_MIN_MAX_REVISIONS 179
+#define STMT_179_INFO {"STMT_SELECT_MIN_MAX_REVISIONS", NULL}
+#define STMT_179 \
"SELECT MIN(revision), MAX(revision), " \
" MIN(changed_revision), MAX(changed_revision) FROM nodes " \
" WHERE wc_id = ?1 " \
@@ -1944,9 +1951,9 @@
" AND op_depth = 0 " \
""
-#define STMT_HAS_SPARSE_NODES 179
-#define STMT_179_INFO {"STMT_HAS_SPARSE_NODES", NULL}
-#define STMT_179 \
+#define STMT_HAS_SPARSE_NODES 180
+#define STMT_180_INFO {"STMT_HAS_SPARSE_NODES", NULL}
+#define STMT_180 \
"SELECT 1 FROM nodes " \
"WHERE wc_id = ?1 " \
" AND (local_relpath = ?2 " \
@@ -1958,9 +1965,9 @@
"LIMIT 1 " \
""
-#define STMT_SUBTREE_HAS_TREE_MODIFICATIONS 180
-#define STMT_180_INFO {"STMT_SUBTREE_HAS_TREE_MODIFICATIONS", NULL}
-#define STMT_180 \
+#define STMT_SUBTREE_HAS_TREE_MODIFICATIONS 181
+#define STMT_181_INFO {"STMT_SUBTREE_HAS_TREE_MODIFICATIONS", NULL}
+#define STMT_181 \
"SELECT 1 FROM nodes " \
"WHERE wc_id = ?1 " \
" AND (local_relpath = ?2 " \
@@ -1969,9 +1976,9 @@
"LIMIT 1 " \
""
-#define STMT_SUBTREE_HAS_PROP_MODIFICATIONS 181
-#define STMT_181_INFO {"STMT_SUBTREE_HAS_PROP_MODIFICATIONS", NULL}
-#define STMT_181 \
+#define STMT_SUBTREE_HAS_PROP_MODIFICATIONS 182
+#define STMT_182_INFO {"STMT_SUBTREE_HAS_PROP_MODIFICATIONS", NULL}
+#define STMT_182 \
"SELECT 1 FROM actual_node " \
"WHERE wc_id = ?1 " \
" AND (local_relpath = ?2 " \
@@ -1980,9 +1987,9 @@
"LIMIT 1 " \
""
-#define STMT_HAS_SWITCHED 182
-#define STMT_182_INFO {"STMT_HAS_SWITCHED", NULL}
-#define STMT_182 \
+#define STMT_HAS_SWITCHED 183
+#define STMT_183_INFO {"STMT_HAS_SWITCHED", NULL}
+#define STMT_183 \
"SELECT 1 " \
"FROM nodes " \
"WHERE wc_id = ?1 " \
@@ -1994,47 +2001,47 @@
"LIMIT 1 " \
""
-#define STMT_SELECT_MOVED_FROM_RELPATH 183
-#define STMT_183_INFO {"STMT_SELECT_MOVED_FROM_RELPATH", NULL}
-#define STMT_183 \
+#define STMT_SELECT_MOVED_FROM_RELPATH 184
+#define STMT_184_INFO {"STMT_SELECT_MOVED_FROM_RELPATH", NULL}
+#define STMT_184 \
"SELECT local_relpath, op_depth FROM nodes " \
"WHERE wc_id = ?1 AND moved_to = ?2 AND op_depth > 0 " \
""
-#define STMT_UPDATE_MOVED_TO_RELPATH 184
-#define STMT_184_INFO {"STMT_UPDATE_MOVED_TO_RELPATH", NULL}
-#define STMT_184 \
+#define STMT_UPDATE_MOVED_TO_RELPATH 185
+#define STMT_185_INFO {"STMT_UPDATE_MOVED_TO_RELPATH", NULL}
+#define STMT_185 \
"UPDATE nodes SET moved_to = ?4 " \
"WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = ?3 " \
""
-#define STMT_CLEAR_MOVED_TO_RELPATH 185
-#define STMT_185_INFO {"STMT_CLEAR_MOVED_TO_RELPATH", NULL}
-#define STMT_185 \
+#define STMT_CLEAR_MOVED_TO_RELPATH 186
+#define STMT_186_INFO {"STMT_CLEAR_MOVED_TO_RELPATH", NULL}
+#define STMT_186 \
"UPDATE nodes SET moved_to = NULL " \
"WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = ?3 " \
""
-#define STMT_CLEAR_MOVED_HERE_RECURSIVE 186
-#define STMT_186_INFO {"STMT_CLEAR_MOVED_HERE_RECURSIVE", NULL}
-#define STMT_186 \
+#define STMT_CLEAR_MOVED_HERE_RECURSIVE 187
+#define STMT_187_INFO {"STMT_CLEAR_MOVED_HERE_RECURSIVE", NULL}
+#define STMT_187 \
"UPDATE nodes SET moved_here = NULL " \
"WHERE wc_id = ?1 " \
" AND (local_relpath = ?2 OR (((local_relpath) > (CASE (?2) WHEN '' THEN '' ELSE (?2) || '/' END)) AND ((local_relpath) < CASE (?2) WHEN '' THEN X'FFFF' ELSE (?2) || '0' END))) " \
" AND op_depth = ?3 " \
""
-#define STMT_SELECT_MOVED_HERE_CHILDREN 187
-#define STMT_187_INFO {"STMT_SELECT_MOVED_HERE_CHILDREN", NULL}
-#define STMT_187 \
+#define STMT_SELECT_MOVED_HERE_CHILDREN 188
+#define STMT_188_INFO {"STMT_SELECT_MOVED_HERE_CHILDREN", NULL}
+#define STMT_188 \
"SELECT moved_to, local_relpath FROM nodes " \
"WHERE wc_id = ?1 AND op_depth > 0 " \
" AND (((moved_to) > (CASE (?2) WHEN '' THEN '' ELSE (?2) || '/' END)) AND ((moved_to) < CASE (?2) WHEN '' THEN X'FFFF' ELSE (?2) || '0' END)) " \
""
-#define STMT_SELECT_MOVED_FOR_DELETE 188
-#define STMT_188_INFO {"STMT_SELECT_MOVED_FOR_DELETE", NULL}
-#define STMT_188 \
+#define STMT_SELECT_MOVED_FOR_DELETE 189
+#define STMT_189_INFO {"STMT_SELECT_MOVED_FOR_DELETE", NULL}
+#define STMT_189 \
"SELECT local_relpath, moved_to, op_depth, " \
" (SELECT CASE WHEN r.moved_here THEN r.op_depth END FROM nodes r " \
" WHERE r.wc_id = ?1 " \
@@ -2048,9 +2055,9 @@
" AND op_depth >= ?3 " \
""
-#define STMT_SELECT_MOVED_FROM_FOR_DELETE 189
-#define STMT_189_INFO {"STMT_SELECT_MOVED_FROM_FOR_DELETE", NULL}
-#define STMT_189 \
+#define STMT_SELECT_MOVED_FROM_FOR_DELETE 190
+#define STMT_190_INFO {"STMT_SELECT_MOVED_FROM_FOR_DELETE", NULL}
+#define STMT_190 \
"SELECT local_relpath, op_depth, " \
" (SELECT CASE WHEN r.moved_here THEN r.op_depth END FROM nodes r " \
" WHERE r.wc_id = ?1 " \
@@ -2061,25 +2068,25 @@
"WHERE wc_id = ?1 AND moved_to = ?2 AND op_depth > 0 " \
""
-#define STMT_UPDATE_MOVED_TO_DESCENDANTS 190
-#define STMT_190_INFO {"STMT_UPDATE_MOVED_TO_DESCENDANTS", NULL}
-#define STMT_190 \
+#define STMT_UPDATE_MOVED_TO_DESCENDANTS 191
+#define STMT_191_INFO {"STMT_UPDATE_MOVED_TO_DESCENDANTS", NULL}
+#define STMT_191 \
"UPDATE nodes SET moved_to = (CASE WHEN (?2) = '' THEN (CASE WHEN (?3) = '' THEN (moved_to) WHEN (moved_to) = '' THEN (?3) ELSE (?3) || '/' || (moved_to) END) WHEN (?3) = '' THEN (CASE WHEN (?2) = '' THEN (moved_to) WHEN SUBSTR((moved_to), 1, LENGTH(?2)) = (?2) THEN CASE WHEN LENGTH(?2) = LENGTH(moved_to) THEN '' WHEN SUBSTR((moved_to), LENGTH(?2)+1, 1) = '/' THEN SUBSTR((moved_to), LENGTH(?2)+2) END END) WHEN SUBSTR((moved_to), 1, LENGTH(?2)) = (?2) THEN CASE WHEN LENGTH(?2) = LENGTH(moved_to) THEN (?3) WHEN SUBSTR((moved_to), LENGTH(?2)+1, 1) = '/' THEN (?3) || SUBSTR((moved_to), LENGTH(?2)+1) END END) " \
" WHERE wc_id = ?1 " \
" AND (((moved_to) > (CASE (?2) WHEN '' THEN '' ELSE (?2) || '/' END)) AND ((moved_to) < CASE (?2) WHEN '' THEN X'FFFF' ELSE (?2) || '0' END)) " \
""
-#define STMT_CLEAR_MOVED_TO_DESCENDANTS 191
-#define STMT_191_INFO {"STMT_CLEAR_MOVED_TO_DESCENDANTS", NULL}
-#define STMT_191 \
+#define STMT_CLEAR_MOVED_TO_DESCENDANTS 192
+#define STMT_192_INFO {"STMT_CLEAR_MOVED_TO_DESCENDANTS", NULL}
+#define STMT_192 \
"UPDATE nodes SET moved_to = NULL " \
" WHERE wc_id = ?1 " \
" AND (((moved_to) > (CASE (?2) WHEN '' THEN '' ELSE (?2) || '/' END)) AND ((moved_to) < CASE (?2) WHEN '' THEN X'FFFF' ELSE (?2) || '0' END)) " \
""
-#define STMT_SELECT_MOVED_PAIR3 192
-#define STMT_192_INFO {"STMT_SELECT_MOVED_PAIR3", NULL}
-#define STMT_192 \
+#define STMT_SELECT_MOVED_PAIR3 193
+#define STMT_193_INFO {"STMT_SELECT_MOVED_PAIR3", NULL}
+#define STMT_193 \
"SELECT n.local_relpath, d.moved_to, d.op_depth, n.kind " \
"FROM nodes n " \
"JOIN nodes d ON d.wc_id = ?1 AND d.local_relpath = n.local_relpath " \
@@ -2105,9 +2112,9 @@
"ORDER BY n.local_relpath " \
""
-#define STMT_SELECT_MOVED_OUTSIDE 193
-#define STMT_193_INFO {"STMT_SELECT_MOVED_OUTSIDE", NULL}
-#define STMT_193 \
+#define STMT_SELECT_MOVED_OUTSIDE 194
+#define STMT_194_INFO {"STMT_SELECT_MOVED_OUTSIDE", NULL}
+#define STMT_194 \
"SELECT local_relpath, moved_to, op_depth FROM nodes " \
"WHERE wc_id = ?1 " \
" AND (local_relpath = ?2 OR (((local_relpath) > (CASE (?2) WHEN '' THEN '' ELSE (?2) || '/' END)) AND ((local_relpath) < CASE (?2) WHEN '' THEN X'FFFF' ELSE (?2) || '0' END))) " \
@@ -2116,9 +2123,9 @@
" AND NOT (((moved_to) > (CASE (?2) WHEN '' THEN '' ELSE (?2) || '/' END)) AND ((moved_to) < CASE (?2) WHEN '' THEN X'FFFF' ELSE (?2) || '0' END)) " \
""
-#define STMT_SELECT_MOVED_DESCENDANTS_SRC 194
-#define STMT_194_INFO {"STMT_SELECT_MOVED_DESCENDANTS_SRC", NULL}
-#define STMT_194 \
+#define STMT_SELECT_MOVED_DESCENDANTS_SRC 195
+#define STMT_195_INFO {"STMT_SELECT_MOVED_DESCENDANTS_SRC", NULL}
+#define STMT_195 \
"SELECT s.op_depth, n.local_relpath, n.kind, n.repos_path, s.moved_to " \
"FROM nodes n " \
"JOIN nodes s ON s.wc_id = n.wc_id AND s.local_relpath = n.local_relpath " \
@@ -2132,9 +2139,9 @@
" AND s.moved_to IS NOT NULL " \
""
-#define STMT_COMMIT_UPDATE_ORIGIN 195
-#define STMT_195_INFO {"STMT_COMMIT_UPDATE_ORIGIN", NULL}
-#define STMT_195 \
+#define STMT_COMMIT_UPDATE_ORIGIN 196
+#define STMT_196_INFO {"STMT_COMMIT_UPDATE_ORIGIN", NULL}
+#define STMT_196 \
"UPDATE nodes SET repos_id = ?4, " \
" repos_path = (CASE WHEN (?2) = '' THEN (CASE WHEN (?5) = '' THEN (local_relpath) WHEN (local_relpath) = '' THEN (?5) ELSE (?5) || '/' || (local_relpath) END) WHEN (?5) = '' THEN (CASE WHEN (?2) = '' THEN (local_relpath) WHEN SUBSTR((local_relpath), 1, LENGTH(?2)) = (?2) THEN CASE WHEN LENGTH(?2) = LENGTH(local_relpath) THEN '' WHEN SUBSTR((local_relpath), LENGTH(?2)+1, 1) = '/' THEN SUBSTR((local_relpath), LENGTH(?2)+2) END END) WHEN SUBSTR((local_relpath), 1, LENGTH(?2)) = (?2) THEN CASE WHEN LENGTH(?2) = LENGTH(local_relpath) THEN (?5) WHEN SUBSTR((local_relpath), LENGTH(?2)+1, 1) = '/' THEN (?5) || SUBSTR((local_relpath), LENGTH(?2)+1) END END), " \
" revision = ?6 " \
@@ -2144,16 +2151,16 @@
" AND op_depth = ?3 " \
""
-#define STMT_HAS_LAYER_BETWEEN 196
-#define STMT_196_INFO {"STMT_HAS_LAYER_BETWEEN", NULL}
-#define STMT_196 \
+#define STMT_HAS_LAYER_BETWEEN 197
+#define STMT_197_INFO {"STMT_HAS_LAYER_BETWEEN", NULL}
+#define STMT_197 \
"SELECT 1 FROM NODES " \
"WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth > ?3 AND op_depth < ?4 " \
""
-#define STMT_SELECT_REPOS_PATH_REVISION 197
-#define STMT_197_INFO {"STMT_SELECT_REPOS_PATH_REVISION", NULL}
-#define STMT_197 \
+#define STMT_SELECT_REPOS_PATH_REVISION 198
+#define STMT_198_INFO {"STMT_SELECT_REPOS_PATH_REVISION", NULL}
+#define STMT_198 \
"SELECT local_relpath, repos_path, revision FROM nodes " \
"WHERE wc_id = ?1 " \
" AND (((local_relpath) > (CASE (?2) WHEN '' THEN '' ELSE (?2) || '/' END)) AND ((local_relpath) < CASE (?2) WHEN '' THEN X'FFFF' ELSE (?2) || '0' END)) " \
@@ -2161,17 +2168,17 @@
"ORDER BY local_relpath " \
""
-#define STMT_SELECT_HAS_NON_FILE_CHILDREN 198
-#define STMT_198_INFO {"STMT_SELECT_HAS_NON_FILE_CHILDREN", NULL}
-#define STMT_198 \
+#define STMT_SELECT_HAS_NON_FILE_CHILDREN 199
+#define STMT_199_INFO {"STMT_SELECT_HAS_NON_FILE_CHILDREN", NULL}
+#define STMT_199 \
"SELECT 1 FROM nodes " \
"WHERE wc_id = ?1 AND parent_relpath = ?2 AND op_depth = ?3 AND kind != 'file' " \
"LIMIT 1 " \
""
-#define STMT_SELECT_HAS_GRANDCHILDREN 199
-#define STMT_199_INFO {"STMT_SELECT_HAS_GRANDCHILDREN", NULL}
-#define STMT_199 \
+#define STMT_SELECT_HAS_GRANDCHILDREN 200
+#define STMT_200_INFO {"STMT_SELECT_HAS_GRANDCHILDREN", NULL}
+#define STMT_200 \
"SELECT 1 FROM nodes " \
"WHERE wc_id = ?1 " \
" AND (((parent_relpath) > (CASE (?2) WHEN '' THEN '' ELSE (?2) || '/' END)) AND ((parent_relpath) < CASE (?2) WHEN '' THEN X'FFFF' ELSE (?2) || '0' END)) " \
@@ -2180,20 +2187,11 @@
"LIMIT 1 " \
""
-#define STMT_SELECT_ALL_NODES 200
-#define STMT_200_INFO {"STMT_SELECT_ALL_NODES", NULL}
-#define STMT_200 \
- "SELECT op_depth, local_relpath, parent_relpath, file_external FROM nodes " \
- "WHERE wc_id = ?1 " \
- ""
-
-#define STMT_SELECT_IPROPS 201
-#define STMT_201_INFO {"STMT_SELECT_IPROPS", NULL}
+#define STMT_SELECT_ALL_NODES 201
+#define STMT_201_INFO {"STMT_SELECT_ALL_NODES", NULL}
#define STMT_201 \
- "SELECT inherited_props FROM nodes " \
+ "SELECT op_depth, local_relpath, parent_relpath, file_external FROM nodes " \
"WHERE wc_id = ?1 " \
- " AND local_relpath = ?2 " \
- " AND op_depth = 0 " \
""
#define STMT_UPDATE_IPROP 202
@@ -2303,14 +2301,6 @@
" locked_levels INTEGER NOT NULL DEFAULT -1, " \
" PRIMARY KEY (wc_id, local_dir_relpath) " \
" ); " \
- "PRAGMA user_version = " \
- APR_STRINGIFY(SVN_WC__VERSION) \
- "; " \
- ""
-
-#define STMT_CREATE_NODES 208
-#define STMT_208_INFO {"STMT_CREATE_NODES", NULL}
-#define STMT_208 \
"CREATE TABLE NODES ( " \
" wc_id INTEGER NOT NULL REFERENCES WCROOT (id), " \
" local_relpath TEXT NOT NULL, " \
@@ -2348,11 +2338,6 @@
"CREATE VIEW NODES_BASE AS " \
" SELECT * FROM nodes " \
" WHERE op_depth = 0; " \
- ""
-
-#define STMT_CREATE_NODES_TRIGGERS 209
-#define STMT_209_INFO {"STMT_CREATE_NODES_TRIGGERS", NULL}
-#define STMT_209 \
"CREATE TRIGGER nodes_insert_trigger " \
"AFTER INSERT ON nodes " \
"WHEN NEW.checksum IS NOT NULL " \
@@ -2376,11 +2361,6 @@
" UPDATE pristine SET refcount = refcount - 1 " \
" WHERE checksum = OLD.checksum; " \
"END; " \
- ""
-
-#define STMT_CREATE_EXTERNALS 210
-#define STMT_210_INFO {"STMT_CREATE_EXTERNALS", NULL}
-#define STMT_210 \
"CREATE TABLE EXTERNALS ( " \
" wc_id INTEGER NOT NULL REFERENCES WCROOT (id), " \
" local_relpath TEXT NOT NULL, " \
@@ -2397,11 +2377,14 @@
"CREATE UNIQUE INDEX I_EXTERNALS_DEFINED ON EXTERNALS (wc_id, " \
" def_local_relpath, " \
" local_relpath); " \
+ "PRAGMA user_version = " \
+ APR_STRINGIFY(SVN_WC__VERSION) \
+ "; " \
""
-#define STMT_INSTALL_SCHEMA_STATISTICS 211
-#define STMT_211_INFO {"STMT_INSTALL_SCHEMA_STATISTICS", NULL}
-#define STMT_211 \
+#define STMT_INSTALL_SCHEMA_STATISTICS 208
+#define STMT_208_INFO {"STMT_INSTALL_SCHEMA_STATISTICS", NULL}
+#define STMT_208 \
"ANALYZE sqlite_master; " \
"DELETE FROM sqlite_stat1 " \
"WHERE tbl in ('NODES', 'ACTUAL_NODE', 'LOCK', 'WC_LOCK', 'EXTERNALS'); " \
@@ -2426,183 +2409,9 @@
"ANALYZE sqlite_master; " \
""
-#define STMT_UPGRADE_TO_20 212
-#define STMT_212_INFO {"STMT_UPGRADE_TO_20", NULL}
-#define STMT_212 \
- "UPDATE BASE_NODE SET checksum = (SELECT checksum FROM pristine " \
- " WHERE md5_checksum = BASE_NODE.checksum) " \
- "WHERE EXISTS (SELECT 1 FROM pristine WHERE md5_checksum = BASE_NODE.checksum); " \
- "UPDATE WORKING_NODE SET checksum = (SELECT checksum FROM pristine " \
- " WHERE md5_checksum = WORKING_NODE.checksum) " \
- "WHERE EXISTS (SELECT 1 FROM pristine " \
- " WHERE md5_checksum = WORKING_NODE.checksum); " \
- "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 , parent_relpath, " \
- " repos_id, repos_relpath, revnum, " \
- " presence, depth, NULL , NULL , kind, " \
- " changed_rev, changed_date, changed_author, " \
- " checksum, properties, translated_size, last_mod_time, " \
- " dav_cache, symlink_target, file_external " \
- "FROM BASE_NODE; " \
- "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 , parent_relpath, " \
- " copyfrom_repos_id, copyfrom_repos_path, copyfrom_revnum, " \
- " presence, depth, NULL , NULL , kind, " \
- " changed_rev, changed_date, changed_author, " \
- " checksum, properties, translated_size, last_mod_time, " \
- " NULL , symlink_target, NULL " \
- "FROM WORKING_NODE; " \
- "DROP TABLE BASE_NODE; " \
- "DROP TABLE WORKING_NODE; " \
- "PRAGMA user_version = 20; " \
- ""
-
-#define STMT_UPGRADE_TO_21 213
-#define STMT_213_INFO {"STMT_UPGRADE_TO_21", NULL}
-#define STMT_213 \
- "PRAGMA user_version = 21; " \
- ""
-
-#define STMT_UPGRADE_21_SELECT_OLD_TREE_CONFLICT 214
-#define STMT_214_INFO {"STMT_UPGRADE_21_SELECT_OLD_TREE_CONFLICT", NULL}
-#define STMT_214 \
- "SELECT wc_id, local_relpath, tree_conflict_data " \
- "FROM actual_node " \
- "WHERE tree_conflict_data IS NOT NULL " \
- ""
-
-#define STMT_UPGRADE_21_ERASE_OLD_CONFLICTS 215
-#define STMT_215_INFO {"STMT_UPGRADE_21_ERASE_OLD_CONFLICTS", NULL}
-#define STMT_215 \
- "UPDATE actual_node SET tree_conflict_data = NULL " \
- ""
-
-#define STMT_UPGRADE_TO_22 216
-#define STMT_216_INFO {"STMT_UPGRADE_TO_22", NULL}
-#define STMT_216 \
- "UPDATE actual_node SET tree_conflict_data = conflict_data; " \
- "UPDATE actual_node SET conflict_data = NULL; " \
- "PRAGMA user_version = 22; " \
- ""
-
-#define STMT_UPGRADE_TO_23 217
-#define STMT_217_INFO {"STMT_UPGRADE_TO_23", NULL}
-#define STMT_217 \
- "PRAGMA user_version = 23; " \
- ""
-
-#define STMT_UPGRADE_23_HAS_WORKING_NODES 218
-#define STMT_218_INFO {"STMT_UPGRADE_23_HAS_WORKING_NODES", NULL}
-#define STMT_218 \
- "SELECT 1 FROM nodes WHERE op_depth > 0 " \
- "LIMIT 1 " \
- ""
-
-#define STMT_UPGRADE_TO_24 219
-#define STMT_219_INFO {"STMT_UPGRADE_TO_24", NULL}
-#define STMT_219 \
- "UPDATE pristine SET refcount = " \
- " (SELECT COUNT(*) FROM nodes " \
- " WHERE checksum = pristine.checksum ); " \
- "PRAGMA user_version = 24; " \
- ""
-
-#define STMT_UPGRADE_TO_25 220
-#define STMT_220_INFO {"STMT_UPGRADE_TO_25", NULL}
-#define STMT_220 \
- "DROP VIEW IF EXISTS NODES_CURRENT; " \
- "CREATE VIEW NODES_CURRENT AS " \
- " SELECT * FROM nodes " \
- " JOIN (SELECT wc_id, local_relpath, MAX(op_depth) AS op_depth FROM nodes " \
- " GROUP BY wc_id, local_relpath) AS filter " \
- " ON nodes.wc_id = filter.wc_id " \
- " AND nodes.local_relpath = filter.local_relpath " \
- " AND nodes.op_depth = filter.op_depth; " \
- "PRAGMA user_version = 25; " \
- ""
-
-#define STMT_UPGRADE_TO_26 221
-#define STMT_221_INFO {"STMT_UPGRADE_TO_26", NULL}
-#define STMT_221 \
- "DROP VIEW IF EXISTS NODES_BASE; " \
- "CREATE VIEW NODES_BASE AS " \
- " SELECT * FROM nodes " \
- " WHERE op_depth = 0; " \
- "PRAGMA user_version = 26; " \
- ""
-
-#define STMT_UPGRADE_TO_27 222
-#define STMT_222_INFO {"STMT_UPGRADE_TO_27", NULL}
-#define STMT_222 \
- "PRAGMA user_version = 27; " \
- ""
-
-#define STMT_UPGRADE_27_HAS_ACTUAL_NODES_CONFLICTS 223
-#define STMT_223_INFO {"STMT_UPGRADE_27_HAS_ACTUAL_NODES_CONFLICTS", NULL}
-#define STMT_223 \
- "SELECT 1 FROM actual_node " \
- "WHERE NOT ((prop_reject IS NULL) AND (conflict_old IS NULL) " \
- " AND (conflict_new IS NULL) AND (conflict_working IS NULL) " \
- " AND (tree_conflict_data IS NULL)) " \
- "LIMIT 1 " \
- ""
-
-#define STMT_UPGRADE_TO_28 224
-#define STMT_224_INFO {"STMT_UPGRADE_TO_28", NULL}
-#define STMT_224 \
- "UPDATE NODES SET checksum = (SELECT checksum FROM pristine " \
- " WHERE md5_checksum = nodes.checksum) " \
- "WHERE EXISTS (SELECT 1 FROM pristine WHERE md5_checksum = nodes.checksum); " \
- "PRAGMA user_version = 28; " \
- ""
-
-#define STMT_UPGRADE_TO_29 225
-#define STMT_225_INFO {"STMT_UPGRADE_TO_29", NULL}
-#define STMT_225 \
- "DROP TRIGGER IF EXISTS nodes_update_checksum_trigger; " \
- "DROP TRIGGER IF EXISTS nodes_insert_trigger; " \
- "DROP TRIGGER IF EXISTS nodes_delete_trigger; " \
- "CREATE TRIGGER nodes_update_checksum_trigger " \
- "AFTER UPDATE OF checksum ON nodes " \
- "WHEN NEW.checksum IS NOT OLD.checksum " \
- "BEGIN " \
- " UPDATE pristine SET refcount = refcount + 1 " \
- " WHERE checksum = NEW.checksum; " \
- " UPDATE pristine SET refcount = refcount - 1 " \
- " WHERE checksum = OLD.checksum; " \
- "END; " \
- "CREATE TRIGGER nodes_insert_trigger " \
- "AFTER INSERT ON nodes " \
- "WHEN NEW.checksum IS NOT NULL " \
- "BEGIN " \
- " UPDATE pristine SET refcount = refcount + 1 " \
- " WHERE checksum = NEW.checksum; " \
- "END; " \
- "CREATE TRIGGER nodes_delete_trigger " \
- "AFTER DELETE ON nodes " \
- "WHEN OLD.checksum IS NOT NULL " \
- "BEGIN " \
- " UPDATE pristine SET refcount = refcount - 1 " \
- " WHERE checksum = OLD.checksum; " \
- "END; " \
- "PRAGMA user_version = 29; " \
- ""
-
-#define STMT_UPGRADE_TO_30 226
-#define STMT_226_INFO {"STMT_UPGRADE_TO_30", NULL}
-#define STMT_226 \
+#define STMT_UPGRADE_TO_30 209
+#define STMT_209_INFO {"STMT_UPGRADE_TO_30", NULL}
+#define STMT_209 \
"CREATE UNIQUE INDEX IF NOT EXISTS I_NODES_MOVED " \
"ON NODES (wc_id, moved_to, op_depth); " \
"CREATE INDEX IF NOT EXISTS I_PRISTINE_MD5 ON PRISTINE (md5_checksum); " \
@@ -2610,9 +2419,9 @@
"UPDATE nodes SET file_external=1 WHERE file_external IS NOT NULL; " \
""
-#define STMT_UPGRADE_30_SELECT_CONFLICT_SEPARATE 227
-#define STMT_227_INFO {"STMT_UPGRADE_30_SELECT_CONFLICT_SEPARATE", NULL}
-#define STMT_227 \
+#define STMT_UPGRADE_30_SELECT_CONFLICT_SEPARATE 210
+#define STMT_210_INFO {"STMT_UPGRADE_30_SELECT_CONFLICT_SEPARATE", NULL}
+#define STMT_210 \
"SELECT wc_id, local_relpath, " \
" conflict_old, conflict_working, conflict_new, prop_reject, tree_conflict_data " \
"FROM actual_node " \
@@ -2624,24 +2433,19 @@
"ORDER by wc_id, local_relpath " \
""
-#define STMT_UPGRADE_30_SET_CONFLICT 228
-#define STMT_228_INFO {"STMT_UPGRADE_30_SET_CONFLICT", NULL}
-#define STMT_228 \
+#define STMT_UPGRADE_30_SET_CONFLICT 211
+#define STMT_211_INFO {"STMT_UPGRADE_30_SET_CONFLICT", NULL}
+#define STMT_211 \
"UPDATE actual_node SET conflict_data = ?3, conflict_old = NULL, " \
" conflict_working = NULL, conflict_new = NULL, prop_reject = NULL, " \
" tree_conflict_data = NULL " \
"WHERE wc_id = ?1 and local_relpath = ?2 " \
""
-#define STMT_UPGRADE_TO_31_ALTER_TABLE 229
-#define STMT_229_INFO {"STMT_UPGRADE_TO_31_ALTER_TABLE", NULL}
-#define STMT_229 \
+#define STMT_UPGRADE_TO_31 212
+#define STMT_212_INFO {"STMT_UPGRADE_TO_31", NULL}
+#define STMT_212 \
"ALTER TABLE NODES ADD COLUMN inherited_props BLOB; " \
- ""
-
-#define STMT_UPGRADE_TO_31_FINALIZE 230
-#define STMT_230_INFO {"STMT_UPGRADE_TO_31_FINALIZE", NULL}
-#define STMT_230 \
"DROP INDEX IF EXISTS I_ACTUAL_CHANGELIST; " \
"DROP INDEX IF EXISTS I_EXTERNALS_PARENT; " \
"DROP INDEX I_NODES_PARENT; " \
@@ -2653,9 +2457,9 @@
"PRAGMA user_version = 31; " \
""
-#define STMT_UPGRADE_31_SELECT_WCROOT_NODES 231
-#define STMT_231_INFO {"STMT_UPGRADE_31_SELECT_WCROOT_NODES", NULL}
-#define STMT_231 \
+#define STMT_UPGRADE_31_SELECT_WCROOT_NODES 213
+#define STMT_213_INFO {"STMT_UPGRADE_31_SELECT_WCROOT_NODES", NULL}
+#define STMT_213 \
"SELECT l.wc_id, l.local_relpath FROM nodes as l " \
"LEFT OUTER JOIN nodes as r " \
"ON l.wc_id = r.wc_id " \
@@ -2667,21 +2471,6 @@
" OR (l.repos_path IS NOT (CASE WHEN (r.local_relpath) = '' THEN (CASE WHEN (r.repos_path) = '' THEN (l.local_relpath) WHEN (l.local_relpath) = '' THEN (r.repos_path) ELSE (r.repos_path) || '/' || (l.local_relpath) END) WHEN (r.repos_path) = '' THEN (CASE WHEN (r.local_relpath) = '' THEN (l.local_relpath) WHEN SUBSTR((l.local_relpath), 1, LENGTH(r.local_relpath)) = (r.local_relpath) THEN CASE WHEN LENGTH(r.local_relpath) = LENGTH(l.local_relpath) THEN '' WHEN SUBSTR((l.local_relpath), LENGTH(r.local_relpath)+1, 1) = '/' THEN SUBSTR((l.local_relpath), LENGTH(r.local_relpath)+2) END END) WHEN SUBSTR((l.local_relpath), 1, LENGTH(r.local_relpath)) = (r.local_relpath) THEN CASE WHEN LENGTH(r.local_relpath) = LENGTH(l.local_relpath) THEN (r.repos_path) WHEN SUBSTR((l.local_relpath), LENGTH(r.local_relpath)+1, 1) = '/' THEN (r.repos_path) || SUBSTR((l.local_relpath), LENGTH(r.local_relpath)+1) END END))) " \
""
-#define STMT_UPGRADE_TO_32 232
-#define STMT_232_INFO {"STMT_UPGRADE_TO_32", NULL}
-#define STMT_232 \
- "DROP INDEX IF EXISTS I_ACTUAL_CHANGELIST; " \
- "DROP INDEX IF EXISTS I_EXTERNALS_PARENT; " \
- "CREATE INDEX I_EXTERNALS_PARENT ON EXTERNALS (wc_id, parent_relpath); " \
- "DROP INDEX I_NODES_PARENT; " \
- "CREATE UNIQUE INDEX I_NODES_PARENT ON NODES (wc_id, parent_relpath, " \
- " local_relpath, op_depth); " \
- "DROP INDEX I_ACTUAL_PARENT; " \
- "CREATE UNIQUE INDEX I_ACTUAL_PARENT ON ACTUAL_NODE (wc_id, parent_relpath, " \
- " local_relpath); " \
- "-- format: YYY " \
- ""
-
#define WC_QUERIES_SQL_99 \
"CREATE TABLE ACTUAL_NODE_BACKUP ( " \
" wc_id INTEGER NOT NULL, " \
@@ -2722,9 +2511,9 @@
"DROP TABLE ACTUAL_NODE_BACKUP; " \
""
-#define STMT_VERIFICATION_TRIGGERS 233
-#define STMT_233_INFO {"STMT_VERIFICATION_TRIGGERS", NULL}
-#define STMT_233 \
+#define STMT_VERIFICATION_TRIGGERS 214
+#define STMT_214_INFO {"STMT_VERIFICATION_TRIGGERS", NULL}
+#define STMT_214 \
"CREATE TEMPORARY TRIGGER no_repository_updates BEFORE UPDATE ON repository " \
"BEGIN " \
" SELECT RAISE(FAIL, 'Updates to REPOSITORY are not allowed.'); " \
@@ -2763,9 +2552,9 @@
"END; " \
""
-#define STMT_STATIC_VERIFY 234
-#define STMT_234_INFO {"STMT_STATIC_VERIFY", NULL}
-#define STMT_234 \
+#define STMT_STATIC_VERIFY 215
+#define STMT_215_INFO {"STMT_STATIC_VERIFY", NULL}
+#define STMT_215 \
"SELECT local_relpath, op_depth, 1, 'Invalid parent relpath set in NODES' " \
"FROM nodes n WHERE local_relpath != '' " \
" AND (parent_relpath IS NULL " \
@@ -3154,25 +2943,6 @@
STMT_213, \
STMT_214, \
STMT_215, \
- STMT_216, \
- STMT_217, \
- STMT_218, \
- STMT_219, \
- STMT_220, \
- STMT_221, \
- STMT_222, \
- STMT_223, \
- STMT_224, \
- STMT_225, \
- STMT_226, \
- STMT_227, \
- STMT_228, \
- STMT_229, \
- STMT_230, \
- STMT_231, \
- STMT_232, \
- STMT_233, \
- STMT_234, \
NULL \
}
@@ -3394,24 +3164,5 @@
STMT_213_INFO, \
STMT_214_INFO, \
STMT_215_INFO, \
- STMT_216_INFO, \
- STMT_217_INFO, \
- STMT_218_INFO, \
- STMT_219_INFO, \
- STMT_220_INFO, \
- STMT_221_INFO, \
- STMT_222_INFO, \
- STMT_223_INFO, \
- STMT_224_INFO, \
- STMT_225_INFO, \
- STMT_226_INFO, \
- STMT_227_INFO, \
- STMT_228_INFO, \
- STMT_229_INFO, \
- STMT_230_INFO, \
- STMT_231_INFO, \
- STMT_232_INFO, \
- STMT_233_INFO, \
- STMT_234_INFO, \
{NULL, NULL} \
}