Index: openacs-4/packages/acs-subsite/www/admin/index-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/admin/Attic/index-postgresql.xql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/acs-subsite/www/admin/index-postgresql.xql	19 Apr 2001 16:37:59 -0000	1.1
@@ -0,0 +1,18 @@
+<?xml version="1.0"?>
+<queryset>
+    <rdbms>
+      <type>postgresql</type>
+      <version>7.1</version>
+    </rdbms>
+
+  <fullquery name="dbqd.acs-subsite.www.admin.index.acs_admin_url_get">
+    <querytext>
+    select site_node__url(node_id) as acs_admin_url, instance_name
+    from site_nodes s, apm_packages p
+    where s.object_id = p.package_id
+    and p.package_key = 'acs-admin'
+    limit 1
+    </querytext>
+  </fullquery>
+
+</queryset>
Index: openacs-4/packages/acs-subsite/www/pvt/home-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/pvt/Attic/home-postgresql.xql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/acs-subsite/www/pvt/home-postgresql.xql	19 Apr 2001 16:38:02 -0000	1.1
@@ -0,0 +1,28 @@
+<?xml version="1.0"?>
+<queryset>
+    <rdbms>
+      <type>postgresql</type>
+      <version>7.1</version>
+    </rdbms>
+
+  <fullquery name="dbqd.acs-subsite.www.pvt.home.pvt_home_user_info">
+    <querytext>
+    select first_names, last_name, email, url,
+    coalesce(screen_name,'&amp;lt; none set up &amp;gt;') as screen_name
+    from cc_users
+    where user_id=:user_id
+    </querytext>
+  </fullquery>
+
+  <fullquery name="dbqd.acs-subsite.www.pvt.home.get_portrait_info">
+    <querytext>
+    select cr.publish_date, coalesce(cr.title,'your portrait') as portrait_title
+    from cr_revisions cr, cr_items ci, acs_rels a
+    where cr.revision_id = ci.live_revision
+    and  ci.item_id = a.object_id_two
+    and a.object_id_one = :user_id
+    and a.rel_type = 'user_portrait_rel'
+    </querytext>
+  </fullquery>
+
+</queryset>
Index: openacs-4/packages/acs-subsite/www/shared/community-member-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/shared/Attic/community-member-postgresql.xql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/acs-subsite/www/shared/community-member-postgresql.xql	19 Apr 2001 16:38:05 -0000	1.1
@@ -0,0 +1,18 @@
+<?xml version="1.0"?>
+<queryset>
+    <rdbms>
+      <type>postgresql</type>
+      <version>7.1</version>
+    </rdbms>
+
+  <fullquery name="dbqd.acs-subsite.www.shared.community-member.user_contributions">
+    <querytext>
+ select at.pretty_name, at.pretty_plural, a.creation_date, acs_object__name(a.object_id) as object_name
+from acs_objects a, acs_object_types at
+where a.object_type = at.object_type
+and a.creation_user = :user_id
+order by object_name, creation_date
+    </querytext>
+  </fullquery>
+
+</queryset>