subversion/libsvn_wc/wc-queries.sql

30 SELECT op_depth, repos_id, repos_path, presence, kind, revision, checksum,
40   checksum, translated_size, changed_revision, changed_date, changed_author,
54 SELECT repos_id, repos_path, presence, kind, revision, checksum,
62   checksum, translated_size, changed_revision, changed_date, changed_author,
83 SELECT op_depth, presence, kind, checksum, translated_size,
93 SELECT repos_id, repos_path, presence, kind, revision, checksum,
124   checksum, translated_size, changed_revision, changed_date, changed_author,
158   changed_author, checksum, properties, translated_size, last_mod_time,
175 SELECT local_relpath, kind, checksum, translated_size, last_mod_time
262     changed_author, checksum, properties, translated_size, last_mod_time,
268     changed_date, changed_author, checksum, properties, translated_size,
812 INSERT OR IGNORE INTO pristine (checksum, md5_checksum, size, refcount)
816 INSERT INTO pristine (checksum, md5_checksum, size, refcount)
822 WHERE checksum = ?1
827 WHERE checksum = ?1 LIMIT 1
830 SELECT checksum
835 SELECT checksum
841 WHERE checksum = ?1 AND refcount = 0
845 SELECT n.checksum, md5_checksum, size
847 LEFT JOIN pristine p ON n.checksum = p.checksum
850   AND n.checksum IS NOT NULL
853 SELECT n.checksum, md5_checksum, size
855 LEFT JOIN pristine p ON n.checksum = p.checksum
860   AND n.checksum IS NOT NULL
917   changed_author, checksum, properties, dav_cache, symlink_target,
971     changed_author, checksum, properties, translated_size, last_mod_time,
975     changed_date, changed_author, checksum, properties, translated_size,
1025     changed_date, changed_author, checksum, properties, translated_size,
1030     changed_author, checksum, properties, translated_size,
1043     changed_date, changed_author, checksum, properties, translated_size,
1048     changed_author, checksum, properties, translated_size,