SQLite format 3@ C-C-" JQUfile:///home/oleg/PE/Lab2/svn/repo7e60f734-9b68-4b54-954a-c54525993051 %Q file:///home/oleg/PE/Lab2/svn/repo !WORK_QUEUEj  WCROOT ! REPOSITORY 'U 7e60f734-9b68-4b54-954a-c54525993051 %Q file:///home/oleg/PE/Lab2/svn/repo    )&% ('2i$sha1$94b50d9f10eb86e5f2afdae19c860a9371aa7b3e GGkq!!tableREPOSITORYREPOSITORYCREATE TABLE REPOSITORY ( id INTEGER PRIMARY KEY AUTOINCREMENT, root TEXT UNIQUE NOT NULL, uuid TEXT NOT NULL )3G!indexsqlite_autoindex_REPOSITORY_1REPOSITORYP++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)D!]indexI_UUIDREPOSITORYCREATE INDEX I_UUID ON REPOSITORY (uuid)D!]indexI_ROOTREPOSITORYCREATE INDEX I_ROOT ON REPOSITORY (root)xKtableWCROOTWCROOTCREATE TABLE WCROOT ( id INTEGER PRIMARY KEY AUTOINCREMENT, local_abspath TEXT UNIQUE )+?indexsqlite_autoindex_WCROOT_1WCROOT_+indexI_LOCAL_ABSPATHWCROOT CREATE UNIQUE INDEX I_LOCAL_ABSPATH ON WCROOT (local_abspath)M mtablePRISTINEPRISTINE CREATE TABLE PRISTINE ( checksum TEXT NOT NULL PRIMARY KEY, compression INTEGER, size INTEGER NOT NULL, refcount INTEGER NOT NULL, md5_checksum TEXT NOT NULL )/ Cindexsqlite_autoindex_PRISTINE_1PRISTINE +**Y$md5 $579ccb172f431b64c6ba0b2c360cf742 yyIX )yindexI_PRISTINE_MD5PRISTINE CREATE INDEX I_PRISTINE_MD5 ON PRISTINE (md5_checksum)< ##?tableACTUAL_NODEACTUAL_NODECREATE TABLE ACTUAL_NODE ( wc_id INTEGER NOT NULL REFERENCES WCROOT (id), local_relpath TEXT NOT NULL, parent_relpath TEXT, properties BLOB, conflict_old TEXT, conflict_new TEXT, conflict_working TEXT, prop_reject TEXT, changelist TEXT, text_mod TEXT, tree_conflict_data TEXT, conflict_data BLOB, older_checksum TEXT REFERENCES PRISTINE (checksum), left_checksum TEXT REFERENCES PRISTINE (checksum), right_checksum TEXT REFERENCES PRISTINE (checksum), PRIMARY KEY (wc_id, local_relpath) )5 I#indexsqlite_autoindex_ACTUAL_NODE_1ACTUAL_NODE4+#'indexI_ACTUAL_PARENTACTUAL_NODECREATE UNIQUE INDEX I_ACTUAL_PARENT ON ACTUAL_NODE (wc_id, parent_relpath, local_relpath)-,  !Lab2/trunk /Lab2/trunk/C.java ?Lab2/trunk/7JKBZw37QU.KVq / Lab2/trunk/I.java aav !Lab2Lab2/trunk! !/Lab2/trunkLab2/trunk/C.java) !?Lab2/trunkLab2/trunk/7JKBZw37QU.KVq  !/ Lab2/trunkLab2/trunk/I.java   77Dm wtableLOCKLOCKCREATE TABLE LOCK ( repos_id INTEGER NOT NULL REFERENCES REPOSITORY (id), repos_relpath TEXT NOT NULL, lock_token TEXT NOT NULL, lock_owner TEXT, lock_comment TEXT, lock_date INTEGER, PRIMARY KEY (repos_id, repos_relpath) )';indexsqlite_autoindex_LOCK_1LOCK}!!EtableWORK_QUEUEWORK_QUEUECREATE TABLE WORK_QUEUE ( id INTEGER PRIMARY KEY AUTOINCREMENT, work BLOB NOT NULL )btableWC_LOCKWC_LOCKCREATE TABLE WC_LOCK ( wc_id INTEGER NOT NULL REFERENCES WCROOT (id), local_dir_relpath TEXT NOT NULL, locked_levels INTEGER NOT NULL DEFAULT -1, PRIMARY KEY (wc_id, local_dir_relpath) )-Aindexsqlite_autoindex_WC_LOCK_1WC_LOCK *kB_   $#^   -@y`  ?Lab2/trunk/j1d5qtyj0h.IeBc %Lab2/trunk/*_ ?Lab2/trunk/7JKBZw37QU.KVqa /Lab2/trunk/J.java` /Lab2/trunk/I.java^ /Lab2/trunk/C.java] /Lab2/trunk/B.java\  'Lab2/branches !Lab2/trunkb  Lab2 QQ)TU tableNODESNODESCREATE TABLE NODES ( wc_id INTEGER NOT NULL REFERENCES WCROOT (id), local_relpath TEXT NOT NULL, op_depth INTEGER NOT NULL, parent_relpath TEXT, repos_id INTEGER REFERENCES REPOSITORY (id), repos_path TEXT, revision INTEGER, presence TEXT NOT NULL, moved_here INTEGER, moved_to TEXT, kind TEXT NOT NULL, properties BLOB, depth TEXT, checksum TEXT REFERENCES PRISTINE (checksum), symlink_target TEXT, changed_revision INTEGER, changed_date INTEGER, changed_author TEXT, translated_size INTEGER, last_mod_time INTEGER, dav_cache BLOB, file_external INTEGER, inherited_props BLOB, PRIMARY KEY (wc_id, local_relpath, op_depth) ))=indexsqlite_autoindex_NODES_1NODES))indexI_NODES_PARENTNODESCREATE UNIQUE INDEX I_NODES_PARENT ON NODES (wc_id, parent_relpath, local_relpath, op_depth)  oK'+ !?Lab2/trunkLab2/trunk/j1d5qtyj0h.IeBc !%Lab2/trunkLab2/trunk/*_* !?Lab2/trunkLab2/trunk/7JKBZw37QU.KVqa" !/Lab2/trunkLab2/trunk/J.java`" !/Lab2/trunkLab2/trunk/I.java^" !/Lab2/trunkLab2/trunk/C.java]" !/Lab2/trunkLab2/trunk/B.java\  'Lab2Lab2/branches !Lab2Lab2/trunkb  Lab2   c _ a ` ^ ] \   b  vvL&e'indexI_NODES_MOVEDNODESCREATE UNIQUE INDEX I_NODES_MOVED ON NODES (wc_id, moved_to, op_depth)''QviewNODES_CURRENTNODES_CURRENTCREATE VIEW NODES_CURRENT AS SELECT * FROM nodes AS n WHERE op_depth = (SELECT MAX(op_depth) FROM nodes AS n2 WHERE n2.wc_id = n.wc_id AND n2.local_relpath = n.local_relpath)c!!viewNODES_BASENODES_BASECREATE VIEW NODES_BASE AS SELECT * FROM nodes WHERE op_depth = 0W5mtriggernodes_insert_triggernodesCREATE 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; ENDW5mtriggernodes_delete_triggernodesCREATE 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 'LGEtriggernodes_update_checksum_triggernodesCREATE 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; ENDV{tableEXTERNALSEXTERNALSCREATE TABLE EXTERNALS ( wc_id INTEGER NOT NULL REFERENCES WCROOT (id), local_relpath TEXT NOT NULL, parent_relpath TEXT NOT NULL, repos_id INTEGER NOT NULL REFERENCES REPOSITORY (id), presence TEXT NOT NULL, kind TEXT NOT NULL, def_local_relpath TEXT NOT NULL, def_repos_relpath TEXT NOT NULL, def_operational_revision TEXT, def_revision TEXT, PRIMARY KEY (wc_id, local_relpath) )     1Eindexsqlite_autoindex_EXTERNALS_1EXTERNALS s3!indexI_EXTERNALS_DEFINEDEXTERNALS!CREATE UNIQUE INDEX I_EXTERNALS_DEFINED ON EXTERNALS (wc_id, def_local_relpath, local_relpath) ee6gU ' '  Lab2/branchesLab2Lab2/branchesnormaldir()infinityg3oleg?    Lab2Lab2normaldir()infinityg3oleg7   normaldir()infinityg3oleg\ /! /iLab2/trunk/B.javaLab2/trunkLab2/trunk/B.javanormalfile()$sha1$ee60753fdef13e23b2daa06460509bcbed892a89olegJm] /! /iLab2/trunk/C.javaLab2/trunkLab2/trunk/C.javanormalfile()$sha1$087257e54e2ce596cf52704933c8d90151fd82ff ,olegGn#ρ^ /! /iLab2/trunk/I.javaLab2/trunkLab2/trunk/I.javanormalfile()$sha1$f1486cf31e522f5c388252c31d274213ba419e0c ,olegn# 2Wc ?! U\iLab2/trunk/j1d5qtyj0h.IeBLab2/trunkLab2/branches/Branch1/j1d5qtyj0h.IeBnormalfile(svn:mime-type application/octet-stream)$sha1$7f06e85e2e8a4ca3dad6874c0f6a659e54843e34 ԰olegdtQb ! !Lab2/trunkLab2Lab2/trunknormaldir()infinity ,oleg1_ %! %\iLab2/trunk/*Lab2/trunkLab2/trunk/*normalfile(svn:mime-type application/octet-stream)$sha1$5ef203f8607f1765783d453b9ec3a2a04b2a42c8 ,olegdnJ߁` /! /iLab2/trunk/J.javaLab2/trunkLab2/trunk/J.javanormalfile()$sha1$25f8a98ff4fff7a73e0b0906b93cf5e916ef106bolegHnJ߁Ka ?! ?\iLab2/trunk/7JKBZw37QU.KVqLab2/trunkLab2/trunk/7JKBZw37QU.KVqnormalfile(svn:mime-type application/octet-stream)$sha1$f50db3175755f7dcfd4b2ab8568b5eead40cbd02»olegdnq XF-qX\ i Y$sha1$f1486cf31e522f5c388252c31d274213ba419e0c$md5 $7110e6ffeeeebd5d2c658a1c61ad982f\ i Y$sha1$087257e54e2ce596cf52704933c8d90151fd82ffG$md5 $12cd6763f10e20cb7da88afb160a11bc[iY$sha1$94b50d9f10eb86e5f2afdae19c860a9371aa7b3ed$md5 $6025e9b208dbfb67966e464fbf731513\iY$sha1$b6cfed49ea8e9ab1664bc4caf40b2a21475bfb6d$md5 $496cdf61a19fd6657334b3e802b4f37a\iY$sha1$7cab340e092cd9539d3432362b24d57419c6b1b4$md5 $026107eb0abc56d1bbf08e64d5af5409[i Y$sha1$f50db3175755f7dcfd4b2ab8568b5eead40cbd02d$md5 $4fe1cd56eebc3eac43a78261458a3aaa\iY$sha1$d04a05b493f4f8d4e6fb74f8df0239fafc6e461b$md5 $137d1e28b6ba9c73292f34cc98577b76\iY$sha1$69d59e0196e377d90eb3957572444f4fbf68e511$md5 $4ace16d18344193b90bb2dd69080dc1a[i Y$sha1$ee60753fdef13e23b2daa06460509bcbed892a89J$md5 $4a7872c7d3af49293ebd404b40005df0[i Y$sha1$25f8a98ff4fff7a73e0b0906b93cf5e916ef106bH$md5 $de6639b80f851b93d8e7385a5730079d XE+qX[iY$sha1$a28f37149c795e3e54800e57add7eb559ef975f3e$md5 $3a2ea9453ba4d412f0f4226f8b9d8432\iY$sha1$349b15d4bd3f377fecd2abb75907a897357ce779$md5 $0cd992b9143c9d4376dce84b1422fe8e\iY$sha1$e197a5146b5ed99b7ac39a76351f77cbb9c90beb$md5 $c6108f95d8e42ef41835cf8283ea16dc[i Y$sha1$7f06e85e2e8a4ca3dad6874c0f6a659e54843e34d$md5 $52267c11428a8e23379a3fa9fdceb3ae[iY$sha1$7b3e9057448af8d3e3e2391f74473dd4c06cea29S$md5 $53cf296f14aa2ecf283871f541fcaf15\iY$sha1$b16d66cabffaa8be4e0008c13663827183846950$md5 $8e524591934614918017ad08da67abbb\iY$sha1$2cb0d41e776a94302b32a7d46d0c59a0ee62ba16$md5 $b5f2d310f4fc3674fa2fc0da3c800ad8\ iY$sha1$5efd3c1f75841bb305678399234e3909c515e6aa$md5 $ca55cc7c3393c87df3c0559969cfa701\ iY$sha1$bb14b17713758624897d06166d9671745ec7903fc$md5 $579ccb172f431b64c6ba0b2c360cf742[ i Y$sha1$5ef203f8607f1765783d453b9ec3a2a04b2a42c8d$md5 $69ea3cd1d97827059e408e18630646c5 6h4g2i$sha1$562a60e6b1256869cdbbba29de63dd0a17fceed82i$sha1$087257e54e2ce596cf52704933c8d90151fd82ff 1i $sha1$25f8a98ff4fff7a73e0b0906b93cf5e916ef106b2i$sha1$2cb0d41e776a94302b32a7d46d0c59a0ee62ba162i$sha1$349b15d4bd3f377fecd2abb75907a897357ce7792i$sha1$5ef203f8607f1765783d453b9ec3a2a04b2a42c8 2i$sha1$5efd3c1f75841bb305678399234e3909c515e6aa 2i$sha1$69d59e0196e377d90eb3957572444f4fbf68e5112i$sha1$7b3e9057448af8d3e3e2391f74473dd4c06cea292i$sha1$7cab340e092cd9539d3432362b24d57419c6b1b42i$sha1$7f06e85e2e8a4ca3dad6874c0f6a659e54843e34 65h4gi62i$sha1$ff46c3097bbaa35b661b3e36dd06f420125fd56b2i$sha1$f343bf4bea7d70b1258cb17b94635fbe8a9f303b2i$sha1$f99dccfdfa8506239c033c76e6065c8ea7cc5e042i$sha1$a7ddedc9616f8b2ffc83814c7f2a310788d066d62i$sha1$b7445a612c62681d2989d6f66783f5d85ddb7dbb2i$sha1$a28f37149c795e3e54800e57add7eb559ef975f32i$sha1$b16d66cabffaa8be4e0008c136638271838469502i$sha1$b6cfed49ea8e9ab1664bc4caf40b2a21475bfb6d2i$sha1$bb14b17713758624897d06166d9671745ec7903f 2i$sha1$d04a05b493f4f8d4e6fb74f8df0239fafc6e461b2i$sha1$e197a5146b5ed99b7ac39a76351f77cbb9c90beb2i$sha1$ee60753fdef13e23b2daa06460509bcbed892a892i$sha1$f1486cf31e522f5c388252c31d274213ba419e0c 2i$sha1$f50db3175755f7dcfd4b2ab8568b5eead40cbd02 E,\iY$sha1$ff46c3097bbaa35b661b3e36dd06f420125fd56b$md5 $3afded567b850a93b859eb906fce30e3[iY$sha1$f343bf4bea7d70b1258cb17b94635fbe8a9f303bd$md5 $11fa22ef07f818d699c108ef78fc6a17\iY$sha1$562a60e6b1256869cdbbba29de63dd0a17fceed8$md5 $d2a4521af6239c6d53af09d27d31a637\iY$sha1$f99dccfdfa8506239c033c76e6065c8ea7cc5e04$md5 $e78e256bcc598e10ae61a7d64e9c9331\iY$sha1$a7ddedc9616f8b2ffc83814c7f2a310788d066d6$md5 $b64926dfb66788c49d202d1e7556c108[iY$sha1$b7445a612c62681d2989d6f66783f5d85ddb7dbbQ$md5 $728ba4f03046ee04aba7115452ec267f 'R})T*Y$md5 $3afded567b850a93b859eb906fce30e3*Y$md5 $11fa22ef07f818d699c108ef78fc6a17*Y$md5 $026107eb0abc56d1bbf08e64d5af5409*Y$md5 $0cd992b9143c9d4376dce84b1422fe8e*Y$md5 $12cd6763f10e20cb7da88afb160a11bc *Y$md5 $137d1e28b6ba9c73292f34cc98577b76*Y$md5 $3a2ea9453ba4d412f0f4226f8b9d8432*Y$md5 $496cdf61a19fd6657334b3e802b4f37a*Y$md5 $4a7872c7d3af49293ebd404b40005df0*Y$md5 $4ace16d18344193b90bb2dd69080dc1a*Y$md5 $4fe1cd56eebc3eac43a78261458a3aaa*Y$md5 $52267c11428a8e23379a3fa9fdceb3ae*Y$md5 $53cf296f14aa2ecf283871f541fcaf15 (S~*U*Y$md5 $d2a4521af6239c6d53af09d27d31a637*Y$md5 $6025e9b208dbfb67966e464fbf731513*Y$md5 $69ea3cd1d97827059e408e18630646c5 *Y$md5 $7110e6ffeeeebd5d2c658a1c61ad982f *Y$md5 $728ba4f03046ee04aba7115452ec267f*Y$md5 $8e524591934614918017ad08da67abbb*Y$md5 $b5f2d310f4fc3674fa2fc0da3c800ad8*Y$md5 $b64926dfb66788c49d202d1e7556c108*Y$md5 $c6108f95d8e42ef41835cf8283ea16dc*Y$md5 $ca55cc7c3393c87df3c0559969cfa701 )Y $md5 $de6639b80f851b93d8e7385a5730079d*Y$md5 $e78e256bcc598e10ae61a7d64e9c9331 mmE:( /!TLab2/trunk/I.javaLab2/trunk((merge ((subversion file:///home/oleg/PE/Lab2/svn/repo 36 7e60f734-9b68-4b54-954a-c54525993051 Lab2/trunk/I.java 1 2 file) (subversion file:///home/oleg/PE/Lab2/svn/repo 36 7e60f734-9b68-4b54-954a-c54525993051 Lab2/branches/Branch1/I.java 2 17 file))) ((text (Lab2/trunk/I.java.merge-left.r2 Lab2/trunk/I.java.working Lab2/trunk/I.java.merge-right.r17))))  i ! Lab2/trunkLab2(svn:mergeinfo 55 /Lab2/branches/Branch1:3-17 /Lab2/branches/Branch2:5-15) /!TLab2/trunk/C.javaLab2/trunk((merge ((subversion file:///home/oleg/PE/Lab2/svn/repo 36 7e60f734-9b68-4b54-954a-c54525993051 Lab2/trunk/C.java 1 2 file) (subversion file:///home/oleg/PE/Lab2/svn/repo 36 7e60f734-9b68-4b54-954a-c54525993051 Lab2/branches/Branch1/C.java 2 17 file))) ((text (Lab2/trunk/C.java.merge-left.r2 Lab2/trunk/C.java.working Lab2/trunk/C.java.merge-right.r17))))^ ?!`Lab2/trunk/7JKBZw37QU.KVqLab2/trunk((merge ((subversion file:///home/oleg/PE/Lab2/svn/repo 36 7e60f734-9b68-4b54-954a-c54525993051 Lab2/trunk/7JKBZw37QU.KVq 1 2 file) (subversion file:///home/oleg/PE/Lab2/svn/repo 36 7e60f734-9b68-4b54-954a-c54525993051 Lab2/branches/Branch1/7JKBZw37QU.KVq 2 17 file))) ((tree () obstructed added)))