site_htmlsnippets

CREATE TABLE IF NOT EXISTS `{PREFIX}site_htmlsnippets` (
`id` int(10) NOT NULL auto_increment,
`name` varchar(50) NOT NULL default '',
`description` varchar(255) NOT NULL default 'Chunk',
`published` int(1) NOT NULL default '1',
`pub_date` int(20) NOT NULL default '0',
`unpub_date` int(20) NOT NULL default '0',
`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',
PRIMARY KEY (`id`)
) ENGINE=MyISAM COMMENT='Contains the site chunks.';