-- -- 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.1 2007/01/03 21:00:29 daveb Exp $ -- update cr_revisions set content = '@text;noquote@' where revision_id = (select template_id from cr_type_template_map where content_type = 'content_revision' and use_context = 'public' and is_default = 't');