--
-- Database query file
-- For manual update
--
-- @package    Content Templater
-- @version    0.4.2
-- @since      File available since Release 0.3.2
--
-- @author     Peter van Westen <peter@nonumber.nl>
-- @link       http://www.nonumber.nl/contenttemplater
-- @copyright  Copyright (C) 2009 NoNumber! All Rights Reserved
-- @license    http://www.gnu.org/licenses/gpl-2.0.html GNU/GPL
--

--
-- NOTE: The queries assume you are using 'jos_' as the prefix.
--       Please change that if you are using another prefix.
--

--
-- Repair old param name 'content_title' -> 'title'
--
UPDATE `jos_contenttemplater` set `params` = replace(`params`,'content_title=','title=');

--
-- Repair old param name 'content_alias' -> 'alias'
--
UPDATE `jos_contenttemplater` set `params` = replace(`params`,'content_alias=','alias=');

--
-- Repair old column name 'text' -> 'content'
-- Only needed if updating from version 0.1.0 (please uncomment to use it)
--
-- ALTER TABLE `jos_contenttemplater` CHANGE `text` `content` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;