site_templates
CREATE TABLE IF NOT EXISTS `{PREFIX}site_templates` (
`id` int(10) NOT NULL auto_increment,
`templatename` varchar(50) NOT NULL default '',
`description` varchar(255) NOT NULL default 'Template',
`editor_type` integer NOT NULL DEFAULT '0' COMMENT '0-plain text,1-rich text,2-code editor',
`category` integer NOT NULL DEFAULT '0' COMMENT 'category id',
`icon` varchar(255) NOT NULL default '' COMMENT 'url to icon file',
`template_type` integer NOT NULL DEFAULT '0' COMMENT '0-page,1-content',
`content` mediumtext,
`parent` int(10) NOT NULL default '0',
`locked` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM COMMENT='Contains the site templates.';