# 
# 
# patch "schema.sql"
#  from [e98092bdf486d6d237a1e87f4ce6b404100ba6fd]
#    to [991307799dd4c8baa220ae52b4e465ebc0ef02a8]
# 
============================================================
--- schema.sql	e98092bdf486d6d237a1e87f4ce6b404100ba6fd
+++ schema.sql	991307799dd4c8baa220ae52b4e465ebc0ef02a8
@@ -9,6 +9,7 @@
 
 
 -- copyright (C) 2002, 2003, 2004 graydon hoare <address@hidden>
+-- copyright (C) 2006 Christof Petig <address@hidden>
 -- all rights reserved.
 -- licensed to the public under the terms of the GNU GPL 2.1+
 -- see the file COPYING for details
@@ -117,4 +118,21 @@ CREATE TABLE db_vars
         unique(domain, name)
         );
 
+-- revisions which are just above the horizon (partial pull)
+
+CREATE TABLE sentinels
+        (
+        id not null,  -- revision id of just missing nodes
+        unique(id)
+        );
+
+-- manifest+file_id for revisions just below the horizon (partial pull)
+
+CREATE TABLE horizon_manifests
+        (
+        id not null,       -- revision id
+        manifest_with_ids, -- compressed, like a roster without markings
+        unique(id)
+        );
+
 COMMIT;