site_snippets

CREATE TABLE IF NOT EXISTS `{PREFIX}site_snippets` (
`id` int(10) NOT NULL auto_increment,
`name` varchar(50) NOT NULL default '',
`description` varchar(255) NOT NULL default 'Snippet',
`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',
`cache_type` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Cache option',
`snippet` mediumtext,
`locked` tinyint(4) NOT NULL default '0',
`properties` text COMMENT 'Default Properties',
`moduleguid` varchar(32) NOT NULL default '' COMMENT 'GUID of module from which to import shared parameters',
PRIMARY KEY (`id`)
) ENGINE=MyISAM COMMENT='Contains the site snippets.';