-- -- packages/acs-content-repository/sql/postgresql/upgrade/upgrade-5.3.0b1-5.3.0b2.sql -- -- @author Dave Bauer (dave@thedesignexperience.org) -- @creation-date 2007-01-03 -- @cvs-id $Id: upgrade-5.3.0b1-5.3.0b2.sql,v 1.1.2.4 2007/01/10 17:32:35 daveb Exp $ -- update cr_revisions set content = '@text;noquote@' where revision_id = (select live_revision from cr_items ci, cr_type_template_map cm where cm.content_type = 'content_revision' and cm.use_context = 'public' and cm.is_default = 't' and ci.item_id=cm.template_id);