Index: openacs-4/packages/imsld/sql/postgresql/imsld-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/imsld/sql/postgresql/imsld-create.sql,v
diff -u -r1.9 -r1.10
--- openacs-4/packages/imsld/sql/postgresql/imsld-create.sql	7 Nov 2005 18:13:07 -0000	1.9
+++ openacs-4/packages/imsld/sql/postgresql/imsld-create.sql	15 Nov 2005 11:01:23 -0000	1.10
@@ -125,10 +125,14 @@
     is_visible_p    char(1)
                     check (is_visible_p in ('t','f'))
                     default 't',
-    parameters      varchar(4000)
+    parameters      varchar(4000),
+    -- recursive queries support
+    imsld_tree_sortkey      varbit,
+    imsld_max_child_sortkey varbit
 );
 
 create index imsld_items_pid_idx on imsld_items(parent_item_id);
+create unique index imsld_items_tree_sortkey_un on imsld_items(imsld_tree_sortkey);
 
 comment on table imsld_items is '
 This table holds the imsld items of the unit of learning';
@@ -669,5 +673,5 @@
 Feedback are items that are mapped to this table with the imsld_feedback_rel.';
 
 \i imsld-cp-create.sql
-
-\i imsld-status-create.sql
\ No newline at end of file
+\i imsld-status-create.sql
+\i imsld-tree-create.sql