Index: openacs-4/packages/edit-this-page/sql/oracle/edit-this-page-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/edit-this-page/sql/oracle/edit-this-page-create.sql,v
diff -u -r1.7 -r1.8
--- openacs-4/packages/edit-this-page/sql/oracle/edit-this-page-create.sql	17 May 2003 10:30:52 -0000	1.7
+++ openacs-4/packages/edit-this-page/sql/oracle/edit-this-page-create.sql	28 Aug 2003 09:41:53 -0000	1.8
@@ -442,3 +442,19 @@
 end;
 /
 show errors;
+
+
+-- create a default content_type etp_page_revision
+-- DaveB
+-- this references a non-existant table
+-- which I might have to change...
+
+select content_type__create_type (
+        content_type => 'etp_page_revision',        -- content_type
+	supertype => 'content_revision',         -- supertype
+	pretty_name => 'ETP managed page',       -- pretty_name
+	pretty_plural => 'ETP managed pages',      -- pretty_plural
+	table_name => 'etp_page_revisions',            -- table_name
+	id_column => 'etp_page_revision_id',              -- id_column
+	name_method => 'content_revision__revision_name'  -- name_method
+);
