Index: openacs-4/packages/static-pages/sql/oracle/upgrade/upgrade-4.2a-4.3.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/static-pages/sql/oracle/upgrade/upgrade-4.2a-4.3.sql,v
diff -u -N
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/static-pages/sql/oracle/upgrade/upgrade-4.2a-4.3.sql	16 Jan 2003 13:59:38 -0000	1.2
@@ -0,0 +1,45 @@
+--
+-- @cvs-id $Id: upgrade-4.2a-4.3.sql,v 1.2 2003/01/16 13:59:38 jeffd Exp $ 
+--
+
+
+-- Note: Slight differences will exist between an old upgraded
+-- installation and a newly created one:
+--
+-- For an old upgraded installation, the one old package instance will
+-- have the OLD 'sp_root' folder name rather than the new
+-- 'sp_root_package_id_PACKAGEID' style name, but this should not
+-- matter.  The names are still all unique from each other, which is
+-- all that matters.  --atp@piskorski.com, 2002/12/12 13:59 EST
+
+@static-page-ph.sql
+@static-page-pb.sql
+
+update apm_package_types  set singleton_p = 'f'
+where package_key = 'static-pages' ;
+commit;
+
+-- This converts any old static_pages.filename values in the db to be
+-- relative to the server rather than page root.  See also comment in
+-- tcl/static-pages-init.tcl re. CR_LOCATIONS STATIC_PAGES:
+-- --atp@piskorski.com, 2002/12/12 16:17 EST
+
+update static_pages  set filename = '/www' || filename;
+
+
+-- Note: If you want to check that the non-html mime types are being
+-- set correctly, try this query: --atp@piskorski.com, 2002/12/15
+-- 22:19 EST
+-- 
+-- column filename  format a60
+-- select  s.folder_id  ,s.static_page_id
+--   ,c.item_id
+--   ,s.filename
+--   ,r.mime_type
+-- from static_pages s, cr_items c
+--   ,cr_revisions r
+-- where s.static_page_id = c.item_id
+--   and s.folder_id = c.parent_id
+--   and c.item_id = r.item_id
+--   --and r.mime_type != 'text/html'
+-- order by s.folder_id, s.filename ;