CREATE TABLE IF NOT EXISTS `photogallery_galleries` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(250) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `photogallery_images` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(250) NOT NULL,
  `position` int(11) NOT NULL,
  `galleryId` int(11) NOT NULL,
  `image` varchar(250) NOT NULL,
  `thumbnail` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

INSERT INTO `page_pages` (`parentId`, `keyword`, `status`, `type`, `route`, `template`, `created`, `updated`) VALUES
(0, 'Photo_Gallery', 'Enabled', 'Module', 'photogallery', 'inner', NOW(), NOW());

INSERT INTO `page_pages_i18n` (`id`, `label`, `locale`) VALUES (LAST_INSERT_ID(), 'Photo Gallery', 'en_US');