Index: openacs-4/packages/static-portlet/sql/oracle/static-core.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/static-portlet/sql/oracle/static-core.sql,v
diff -u -r1.7.6.1 -r1.7.6.2
--- openacs-4/packages/static-portlet/sql/oracle/static-core.sql	22 Jun 2004 19:28:49 -0000	1.7.6.1
+++ openacs-4/packages/static-portlet/sql/oracle/static-core.sql	19 Jul 2005 18:13:08 -0000	1.7.6.2
@@ -37,7 +37,10 @@
     pretty_name                 varchar2(100) 
                                 constraint static_p_c_pretty_name_nn
                                 not null,                            
-    body                        clob
+    body                        clob,
+    format                      varchar2(30)
+                                default 'text/html'
+                                constraint static_p_c_format_ck check (format in ('text/enhanced', 'text/plain', 'text/fixed-width', 'text/html'))
 );
 
 
@@ -70,6 +73,7 @@
         package_id     in static_portal_content.package_id%TYPE default null,
         pretty_name     in static_portal_content.pretty_name%TYPE default null,
         content         in varchar default null,
+        format          in varchar default 'text/html',
         object_type     in acs_objects.object_type%TYPE default 'static_portal_content',
         creation_date   in acs_objects.creation_date%TYPE default sysdate,
         creation_user   in acs_objects.creation_user%TYPE default null,
@@ -91,6 +95,7 @@
         package_id     in static_portal_content.package_id%TYPE default null,
         pretty_name     in static_portal_content.pretty_name%TYPE default null,
         content         in varchar default null,
+        format          in varchar default 'text/html',
         object_type     in acs_objects.object_type%TYPE default 'static_portal_content',
         creation_date   in acs_objects.creation_date%TYPE default sysdate,
         creation_user   in acs_objects.creation_user%TYPE default null,
@@ -109,9 +114,9 @@
 	);
 
         insert into static_portal_content
-        (content_id, package_id, pretty_name, body)
+        (content_id, package_id, pretty_name, body, format)
         values
-        (v_content_id, new.package_id, new.pretty_name, new.content);
+        (v_content_id, new.package_id, new.pretty_name, new.content, new.format);
 
         return v_content_id;        
     end new;
Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/packages/static-portlet/sql/oracle/upgrade/upgrade-2.1.2d1-2.1.2d2.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Index: openacs-4/packages/static-portlet/tcl/static-portal-content-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/static-portlet/tcl/static-portal-content-procs-oracle.xql,v
diff -u -r1.2 -r1.2.10.1
--- openacs-4/packages/static-portlet/tcl/static-portal-content-procs-oracle.xql	23 Jul 2002 13:40:45 -0000	1.2
+++ openacs-4/packages/static-portlet/tcl/static-portal-content-procs-oracle.xql	19 Jul 2005 18:14:15 -0000	1.2.10.1
@@ -10,6 +10,7 @@
                 :1 := static_portal_content_item.new(
                     package_id => :package_id,
                     content => :content,
+                    format => :format,
                     pretty_name => :pretty_name
                 );
             end;