Index: openacs-4/packages/acs-content-repository/sql/oracle/content-type.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/oracle/content-type.sql,v
diff -u -r1.11 -r1.12
--- openacs-4/packages/acs-content-repository/sql/oracle/content-type.sql	7 Dec 2009 20:19:03 -0000	1.11
+++ openacs-4/packages/acs-content-repository/sql/oracle/content-type.sql	7 Aug 2017 23:47:46 -0000	1.12
@@ -311,7 +311,7 @@
   -- Drop the attribute
   acs_attribute.drop_attribute(content_type, attribute_name);
 
-  -- Drop the column if neccessary
+  -- Drop the column if necessary
   if drop_column = 't' then
     begin
       execute immediate 'alter table ' || v_table || ' drop column ' ||
@@ -556,6 +556,7 @@
                    revision_id   => :new.revision_id,
                    title         => :new.title,
                    description   => :new.description,
+                   publish_date  => :new.publish_date,
                    mime_type     => :new.mime_type,
                    nls_language  => :new.nls_language,
                    item_id       => content_symlink.resolve(:new.item_id),
@@ -571,6 +572,7 @@
                    revision_id   => :new.revision_id,
                    title         => :new.title,
                    description   => :new.description,
+                   publish_date  => :new.publish_date,
                    mime_type     => :new.mime_type,
                    nls_language  => :new.nls_language,
                    item_id       => content_symlink.resolve(:new.item_id),