diff options
Diffstat (limited to 'subversion/libsvn_wc/wc-queries.h')
| -rw-r--r-- | subversion/libsvn_wc/wc-queries.h | 617 |
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} \ } |