--
-- Database query file
-- For manual installation
--
-- @package    Content Templater
-- @version    0.4.2
-- @since      File available since Release 0.3.1
--
-- @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.
--

--
-- Table structure for table `jos_contenttemplater`
--
CREATE TABLE IF NOT EXISTS `jos_contenttemplater` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `name` text NOT NULL,
  `description` text NOT NULL,
  `content` text NOT NULL,
  `params` text NOT NULL,
  `published` tinyint(1) unsigned NOT NULL default '0',
  `ordering` int(11) NOT NULL default '0',
  `checked_out` int(11) unsigned NOT NULL default '0',
  `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`),
  KEY `id` (`id`,`published`)
) ENGINE=MyISAM CHARACTER SET 'utf8' COLLATE 'utf8_general_ci';

--
-- Insert the component record
--
INSERT INTO `jos_components` (`id`, `name`, `link`, `menuid`, `parent`, `admin_menu_link`, `admin_menu_alt`, `option`, `ordering`, `admin_menu_img`, `iscore`, `params`, `enabled`) VALUES
(NULL, 'Content Templater', '', 0, 0, 'option=com_contenttemplater', 'Content Templater', 'com_contenttemplater', 0, 'components/com_contenttemplater/images/icon-contenttemplater.png', 0, '', 1);

--
-- Insert the editor button plugin record
--
INSERT INTO `jos_plugins` (`id`, `name`, `element`, `folder`, `access`, `ordering`, `published`, `iscore`, `client_id`, `checked_out`, `checked_out_time`, `params`) VALUES
(NULL, 'Editor Button - Content Templater', 'contenttemplater', 'editors-xtd', 0, 0, 1, 0, 0, 0, '0000-00-00 00:00:00', '');