CREATE TABLE `md_SlideBlock` (
 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
 `title` varchar(255) NOT NULL,
 `image` varchar(255) DEFAULT NULL,
 `content` text NOT NULL,
 `linkType` char(16) DEFAULT NULL,
 `linkText` varchar(255) DEFAULT NULL,
 `pageId` int(11) DEFAULT NULL,
 `url` varchar(255) DEFAULT NULL,
 `enabled` enum('y','n') NOT NULL,
 `sorter` int(11) NOT NULL DEFAULT 0,
 `added` datetime NOT NULL,
 `changed` datetime NOT NULL,
 PRIMARY KEY (`id`),
 KEY `sorter` (`sorter`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;


CREATE TABLE IF NOT EXISTS `md_SlideBlockLinkType` (
  `id` char(16) NOT NULL,
  `title` varchar(255) NOT NULL,
  `sorter` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `md_SlideBlockLinkType` (`id`, `title`, `sorter`) VALUES
('url', 'URL', 1),
('cms', 'Site Page', 2);

INSERT INTO `md_zz_DPageItemType` (`id`, `type`, `title`, `sorter`) VALUES (NULL, 'SlideBlock_', 'Home Slide Blocks', '260');
