Index: openacs-4/packages/layout-managed-subsite/www/admin/layouts/manage-includelets-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/layout-managed-subsite/www/admin/layouts/manage-includelets-oracle.xql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/layout-managed-subsite/www/admin/layouts/manage-includelets-oracle.xql	20 Jan 2010 01:30:58 -0000	1.1
@@ -0,0 +1,33 @@
+<?xml version="1.0"?>
+
+<queryset>
+  <rdbms><type>oracle</type><version>8.1.6</version></rdbms>
+
+  <fullquery name="get_elements">
+    <querytext>
+      select le.*
+      from layout_elements le, layout_pages lp, layout_includelets li
+      where le.package_id = :package_id
+        and lp.page_id = le.page_id
+        and lp.pageset_id = :pageset_id
+        and le.includelet_name = li.name
+        and apm_package.is_child(li.application, :package_key) = 1
+      order by le.title
+    </querytext>
+  </fullquery>
+
+  <fullquery name="get_includelets">
+    <querytext>
+      select li.*
+      from layout_includelets li
+      where apm_package.is_child(li.application, :package_key) = 1
+        and li.internally_managed_p = 'f'
+        and not exists (select 1
+                        from layout_elements le
+                        where le.package_id = :package_id
+                          and le.includelet_name = li.name
+                          and li.singleton_p = 't')
+      order by li.name
+    </querytext>
+  </fullquery>
+</queryset>
Index: openacs-4/packages/layout-managed-subsite/www/admin/layouts/manage-includelets-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/layout-managed-subsite/www/admin/layouts/manage-includelets-postgresql.xql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/layout-managed-subsite/www/admin/layouts/manage-includelets-postgresql.xql	20 Jan 2010 01:30:58 -0000	1.1
@@ -0,0 +1,33 @@
+<?xml version="1.0"?>
+
+<queryset>
+  <rdbms><type>postgresql</type><version>7.2</version></rdbms>
+
+  <fullquery name="get_elements">
+    <querytext>
+      select le.*
+      from layout_elements le, layout_pages lp, layout_includelets li
+      where le.package_id = :package_id
+        and lp.page_id = le.page_id
+        and lp.pageset_id = :pageset_id
+        and le.includelet_name = li.name
+        and apm_package__is_child(li.application, :package_key)
+      order by le.title
+    </querytext>
+  </fullquery>
+
+  <fullquery name="get_includelets">
+    <querytext>
+      select li.*
+      from layout_includelets li
+      where apm_package__is_child(li.application, :package_key)
+        and li.internally_managed_p = 'f'
+        and not exists (select 1
+                        from layout_elements le
+                        where le.package_id = :package_id
+                          and le.includelet_name = li.name
+                          and li.singleton_p = 't')
+      order by li.name
+    </querytext>
+  </fullquery>
+</queryset>
Fisheye: Tag 1.4 refers to a dead (removed) revision in file `openacs-4/packages/layout-managed-subsite/www/admin/layouts/manage-includelets.xql'.
Fisheye: No comparison available.  Pass `N' to diff?