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');