Index: openacs-4/packages/file-storage/sql/postgresql/file-storage-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/file-storage/sql/postgresql/file-storage-create.sql,v
diff -u -r1.15 -r1.16
--- openacs-4/packages/file-storage/sql/postgresql/file-storage-create.sql	4 Apr 2002 03:01:06 -0000	1.15
+++ openacs-4/packages/file-storage/sql/postgresql/file-storage-create.sql	7 Jul 2003 12:37:39 -0000	1.16
@@ -57,6 +57,39 @@
        'file_storage__get_title' -- name_method
 );
 
+create or replace function inline_0 ()
+returns integer as'
+declare
+    template_id integer;
+begin
+
+    -- Create the (default) file_storage_object content type template
+
+    template_id := content_template__new( 
+      ''file-storage-default'', -- name
+      ''<master>
+<property name="title">@title@</property>
+<property name="context">@context@</property>
+@text;noquote@'',               -- text
+      true                      -- is_live
+    );
+
+    -- Register the template for the file_storage_object content type
+
+    perform content_type__register_template(
+      ''file_storage_object'', -- content_type
+      template_id,             -- template_id
+      ''public'',              -- use_context
+      ''t''                    -- is_default
+    );
+
+    return null;
+end;' language 'plpgsql';
+
+select inline_0();
+drop function inline_0();
+
+
 \i file-storage-package-create.sql
 
 \i file-storage-simple-create.sql