Index: openacs-4/packages/edit-this-page/www/etp-extlink-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/edit-this-page/www/etp-extlink-oracle.xql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/edit-this-page/www/etp-extlink-oracle.xql	31 Oct 2001 04:35:05 -0000	1.1
@@ -0,0 +1 @@

\ No newline at end of file
Index: openacs-4/packages/edit-this-page/www/etp-history-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/edit-this-page/www/etp-history-oracle.xql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/edit-this-page/www/etp-history-oracle.xql	31 Oct 2001 04:37:12 -0000	1.1
@@ -0,0 +1,26 @@
+<?xml version="1.0"?>
+<queryset>
+   <rdbms><type>postgresql</type><version>7.1</version></rdbms>
+
+<fullquery name="get_revisions">
+<querytext>
+
+select o.creation_user as creation_user_id,
+       person.name(o.creation_user) as creation_user_name,
+       to_char(o.creation_date, 'Mon DD') as creation_date,
+       o.modifying_user as publish_user_id, 
+       person.name(o.modifying_user) as publish_user_name,
+       to_char(r.publish_date, 'Mon DD') as publish_date,
+       r.revision_id, 
+       content_revision.get_number(r.revision_id) as version_number
+from cr_revisions r, cr_items i, acs_objects o
+where r.item_id = i.item_id
+and o.object_id = r.revision_id
+and i.parent_id = etp.get_folder_id(:package_id)
+and i.name = :name
+order by r.revision_id
+
+</querytext>
+</fullquery>
+ 
+</queryset>