Changeset 133 in tracdarcs for README

Timestamp:

04/23/09 01:07:43 (4 years ago)

Author:

lele@…

Hash name:

20090422230743-97f81-2037480d2dc10db30992d01d32a2049aef19178b

Message:

Aligned README with current schema

File:

• README (modified) (10 diffs)

README

@@ -66 +66 @@
 
     create table darcs_changesets (
-        rev integer primary key,
+        repo_id text,
+        rev integer,
         hash text,
-        name text );
+        name text,
+        primary key (repo_id, rev));
+
+repo_id
+  repository containing this changeset
 
 rev
@@ -91 +96 @@
 
     create table darcs_nodes (
-        node_id integer primary key,
+        repo_id text,
+        node_id integer,
         node_type text,
         add_rev integer,
-        remove_rev integer );
+        remove_rev integer,
+        primary key (repo_id, node_id) );
 
 node_type
@@ -115 +122 @@
 
     create table darcs_node_changes (
+        repo_id text,
         node_id integer,
         rev integer,
@@ -120 +128 @@
         parent_id integer,
         the_change text,
-        primary key (node_id,rev) );
+        primary key (repo_id, node_id,rev) );
 
 
@@ -149 +157 @@
 
     create table darcs_cache (
+        repo_id text,
         node_id integer,
         rev integer,
         content blob,
-        primary key (node_id,rev) );
+        size integer,
+        primary key (repo_id, node_id,rev) );
 
 Some sample queries
@@ -166 +176 @@
     where dnc.node_id = dn.node_id
       and dnc.rev <= r
+      and dnc.repo_id = dn.repo_id and dnc.repo_id = 'somerepo'
       and (dn.remove_rev is null or dn.remove_rev > r)
     group by dnc.node_id
@@ -178 +189 @@
     where dnc.node_id = dn.node_id
       and dn.remove_rev is null
+      and dnc.repo_id = dn.repo_id and dnc.repo_id = 'somerepo'
     group by dnc.node_id
 
@@ -192 +204 @@
     where dnc.node_id = nr.node_id
       and dnc.rev = nr.rev
+      and dnc.repo_id = nr.repo_id and dnc.repo_id = 'somerepo'
       and dnc.path = p
 
@@ -201 +214 @@
     select * from darcs_node_changes as dnc
     where dnc.node_id = nid and dnc.rev <= r
+      and dnc.repo_id = 'somerepo'
 
 Get children of node_id nid, as of revision r
@@ -212 +226 @@
       and dnc.rev = nr.rev
       and dnc.parent_id = nid
+      and dnc.repo_id = nr.repo_id and dnc.repo_id = 'somerepo'