CREATE TABLE `mc_Gallery` (
 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
 `title` varchar(255) NOT NULL,
 `alias` varchar(255) NOT NULL,
 `metaTitle` varchar(255) NOT NULL DEFAULT '',
 `metaKeywords` text NOT NULL,
 `metaDescription` text NOT NULL,
 `image` varchar(255) DEFAULT NULL,
 `description` text NOT NULL,
 `rawDescription` text NOT NULL,
 `enabled` enum('y','n') NOT NULL DEFAULT 'y',
 `sorter` int(11) NOT NULL,
 `added` datetime NOT NULL,
 `changed` datetime NOT NULL,
 PRIMARY KEY (`id`),
 UNIQUE KEY `alias` (`alias`),
 KEY `sorter` (`sorter`),
 KEY `show` (`enabled`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `mc_GalleryImage` (
 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
 `galleryId` int(11) unsigned NOT NULL,
 `title` varchar(255) NOT NULL,
 `image` varchar(255) DEFAULT NULL,
 `description` text NOT NULL,
 `enabled` enum('y','n') NOT NULL DEFAULT 'y',
 `sorter` int(11) NOT NULL,
 `added` datetime NOT NULL,
 `changed` datetime NOT NULL,
 PRIMARY KEY (`id`),
 KEY `galleryId_show_sorter` (`galleryId`,`enabled`,`sorter`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


INSERT INTO `mc_DPageItemType` (`id`, `type`, `title`, `sorter`) VALUES (NULL, 'Gallery\\', 'Gallery', '320');

-- manually create page "For SPCC Members" / "Photo Gallery"