subversion/libsvn_wc/wc-metadata.sql

47 CREATE TABLE REPOSITORY (
59 CREATE INDEX I_UUID ON REPOSITORY (uuid);
60 CREATE INDEX I_ROOT ON REPOSITORY (root);
65 CREATE TABLE WCROOT (
73 CREATE UNIQUE INDEX I_LOCAL_ABSPATH ON WCROOT (local_abspath);
85 CREATE TABLE PRISTINE (
110 CREATE INDEX I_PRISTINE_MD5 ON PRISTINE (md5_checksum);
130 CREATE TABLE ACTUAL_NODE (
184 CREATE UNIQUE INDEX I_ACTUAL_PARENT ON ACTUAL_NODE (wc_id, parent_relpath,
191 CREATE TABLE LOCK (
210 CREATE TABLE WORK_QUEUE (
221 CREATE TABLE WC_LOCK (
277 CREATE TABLE NODES (
473 CREATE UNIQUE INDEX I_NODES_PARENT ON NODES (wc_id, parent_relpath,
476 CREATE UNIQUE INDEX I_NODES_MOVED ON NODES (wc_id, moved_to, op_depth);
487 CREATE VIEW NODES_CURRENT AS
496 CREATE VIEW NODES_BASE AS
500 CREATE TRIGGER nodes_insert_trigger
508 CREATE TRIGGER nodes_delete_trigger
516 CREATE TRIGGER nodes_update_checksum_trigger
527 CREATE TABLE EXTERNALS (
561 CREATE UNIQUE INDEX I_EXTERNALS_DEFINED ON EXTERNALS (wc_id,
634 CREATE UNIQUE INDEX IF NOT EXISTS I_NODES_MOVED
637 CREATE INDEX IF NOT EXISTS I_PRISTINE_MD5 ON PRISTINE (md5_checksum);
674 CREATE UNIQUE INDEX I_NODES_PARENT ON NODES (wc_id, parent_relpath,
678 CREATE UNIQUE INDEX I_ACTUAL_PARENT ON ACTUAL_NODE (wc_id, parent_relpath,
723 CREATE TABLE ACTUAL_NODE_BACKUP (
743 CREATE TABLE ACTUAL_NODE (
758 CREATE UNIQUE INDEX I_ACTUAL_PARENT ON ACTUAL_NODE (wc_id, parent_relpath,