CREATE TABLE IF NOT EXISTS `apw_PwxSlide` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(255) NOT NULL, `image` varchar(255) DEFAULT NULL, `linkType` enum('none','url','cms') NOT NULL, `pageId` int(11) DEFAULT NULL, `url` varchar(255) NOT NULL, `linkText` varchar(255) NOT NULL, `show` enum('y','n') NOT NULL, `sorter` int(11) NOT NULL, `added` datetime NOT NULL, `changed` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; INSERT INTO `apw_DPageItemType` (`id`, `type`, `title`, `sorter`) VALUES (NULL, 'PwxSlide_', 'PWX Slides ', '60'); INSERT INTO `apw_DPageItemType` (`id`, `type`, `title`, `sorter`) VALUES (NULL, 'PageRedirect\\', 'Page Redirect', '25');