CREATE TABLE `qs_WideSlide` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `title` varchar(255) NOT NULL, `image` varchar(255) DEFAULT NULL, `description` text NOT NULL, `linkType` enum('none','url','cms') NOT NULL, `pageId` int(11) NOT NULL, `url` varchar(255) NOT NULL, `linkText` varchar(255) NOT NULL, `enabled` enum('y','n') NOT NULL, `sorter` int(11) NOT NULL, `added` datetime NOT NULL, `changed` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ; INSERT INTO `qs_Application` (`class`, `role`, `title`, `sorter`) VALUES ('App\\WideSlide\\Admin\\View', 'admin', 'Wide Slides', '400') ; INSERT INTO `qs_DPageItemType` (`id`, `type`, `title`, `sorter`) VALUES (NULL, 'WideSlide\\', 'Wide Slides', '300');