-- --------------------------------------------------------
-- Host:                         127.0.0.1
-- Server version:               5.1.41 - Source distribution
-- Server OS:                    Win32
-- HeidiSQL version:             7.0.0.4072
-- Date/time:                    2012-02-29 21:22:32
-- --------------------------------------------------------

-- Dumping structure for table mga_allowed_emails
DROP TABLE IF EXISTS `mga_allowed_emails`;
CREATE TABLE IF NOT EXISTS `mga_allowed_emails` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `email` varchar(250) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- Dumping structure for table mga_banned
DROP TABLE IF EXISTS `mga_banned`;
CREATE TABLE IF NOT EXISTS `mga_banned` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `address` varchar(250) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- Dumping structure for table mga_categories
DROP TABLE IF EXISTS `mga_categories`;
CREATE TABLE IF NOT EXISTS `mga_categories` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `catname` varchar(100) NOT NULL DEFAULT '',
  `comments` text NOT NULL,
  `keywords` text NOT NULL,
  `description` text NOT NULL,
  `en_cat` enum('0','1') NOT NULL DEFAULT '0',
  `en_comments` enum('0','1') NOT NULL DEFAULT '0',
  `en_slideshow` enum('0','1') NOT NULL DEFAULT '0',
  `en_watermarks` enum('0','1') NOT NULL DEFAULT '0',
  `parent` enum('0','1') NOT NULL DEFAULT '0',
  `child` int(7) NOT NULL DEFAULT '0',
  `folder` varchar(50) NOT NULL DEFAULT '',
  `mp3` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- Dumping structure for table mga_comments
DROP TABLE IF EXISTS `mga_comments`;
CREATE TABLE IF NOT EXISTS `mga_comments` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(200) NOT NULL DEFAULT '',
  `email` varchar(250) NOT NULL DEFAULT '',
  `ip_address` varchar(50) NOT NULL DEFAULT '',
  `addDate` date NOT NULL DEFAULT '0000-00-00',
  `catID` int(10) NOT NULL DEFAULT '0',
  `imageID` int(10) NOT NULL DEFAULT '0',
  `comments` mediumtext NOT NULL,
  `is_active` enum('0','1') NOT NULL DEFAULT '0',
  `is_approved` enum('0','1') NOT NULL DEFAULT '0',
  `verification_key` varchar(50) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- Dumping structure for table mga_images
DROP TABLE IF EXISTS `mga_images`;
CREATE TABLE IF NOT EXISTS `mga_images` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(200) NOT NULL DEFAULT '',
  `addDate` date DEFAULT '0000-00-00',
  `cat` varchar(10) NOT NULL DEFAULT '0',
  `comments` text NOT NULL,
  `keywords` text NOT NULL,
  `description` text NOT NULL,
  `isize` int(10) NOT NULL DEFAULT '0',
  `tsize` int(10) NOT NULL DEFAULT '0',
  `imagepath` varchar(250) NOT NULL DEFAULT '',
  `thumbpath` varchar(250) NOT NULL DEFAULT '',
  `visits` int(10) unsigned NOT NULL DEFAULT '0',
  `details` text NOT NULL,
  `sale_item` enum('0','1') NOT NULL DEFAULT '0',
  `rss_date` varchar(35) NOT NULL DEFAULT '',
  `enabled` enum('0','1') NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `imagepath` (`imagepath`),
  UNIQUE KEY `thumbpath` (`thumbpath`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- Dumping structure for table mga_ipndata
DROP TABLE IF EXISTS `mga_ipndata`;
CREATE TABLE IF NOT EXISTS `mga_ipndata` (
  `id` int(7) NOT NULL AUTO_INCREMENT,
  `first_name` varchar(64) NOT NULL DEFAULT '',
  `last_name` varchar(64) NOT NULL DEFAULT '',
  `pay_date` date NOT NULL DEFAULT '0000-00-00',
  `address` text NOT NULL,
  `email` varchar(127) NOT NULL DEFAULT '',
  `memo` text NOT NULL,
  `payment_status` varchar(20) NOT NULL DEFAULT '',
  `pending_reason` varchar(20) NOT NULL DEFAULT '',
  `gross` varchar(10) NOT NULL DEFAULT '',
  `fee` varchar(10) NOT NULL DEFAULT '',
  `txn_id` varchar(17) NOT NULL DEFAULT '',
  `invoice` varchar(127) NOT NULL DEFAULT '',
  `cartID` varchar(32) NOT NULL DEFAULT '',
  `pictureShipping` varchar(100) NOT NULL DEFAULT '',
  `activeCart` enum('0','1') NOT NULL DEFAULT '0',
  `status` enum('0','1','2') NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- Dumping structure for table mga_paypal
DROP TABLE IF EXISTS `mga_paypal`;
CREATE TABLE IF NOT EXISTS `mga_paypal` (
  `id` tinyint(2) NOT NULL AUTO_INCREMENT,
  `ppEmail` varchar(250) NOT NULL DEFAULT '',
  `ppLog` enum('0','1') NOT NULL DEFAULT '0',
  `ppSandbox` enum('0','1') NOT NULL DEFAULT '0',
  `ppStyle` varchar(100) NOT NULL DEFAULT '',
  `ppCurrency` char(3) NOT NULL DEFAULT 'GBP',
  `ppSSL` enum('0','1') NOT NULL DEFAULT '0',
  `ppShipDefault` varchar(10) NOT NULL DEFAULT '',
  `ppShipSingle` varchar(10) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

-- Dumping data for table mga_paypal: 1 rows
INSERT INTO `mga_paypal` (`id`, `ppEmail`, `ppLog`, `ppSandbox`, `ppStyle`, `ppCurrency`, `ppSSL`, `ppShipDefault`, `ppShipSingle`) VALUES
	(1, 'you@yoursite.com', '0', '0', '', 'GBP', '0', '0', '0');

-- Dumping structure for table mga_purchases
DROP TABLE IF EXISTS `mga_purchases`;
CREATE TABLE IF NOT EXISTS `mga_purchases` (
  `id` int(7) NOT NULL AUTO_INCREMENT,
  `pictureID` int(7) NOT NULL DEFAULT '0',
  `pictureSize` varchar(100) NOT NULL DEFAULT '',
  `pictureCost` varchar(100) NOT NULL DEFAULT '',
  `pictureItem` varchar(100) NOT NULL DEFAULT '',
  `pictureQty` int(7) NOT NULL DEFAULT '0',
  `cartID` varchar(32) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- Dumping structure for table mga_settings
DROP TABLE IF EXISTS `mga_settings`;
CREATE TABLE IF NOT EXISTS `mga_settings` (
  `id` tinyint(1) NOT NULL AUTO_INCREMENT,
  `website` varchar(100) NOT NULL DEFAULT '',
  `email` varchar(100) NOT NULL DEFAULT '',
  `homepage` varchar(250) NOT NULL DEFAULT '',
  `folder` varchar(250) NOT NULL DEFAULT '',
  `folder_name` varchar(250) NOT NULL DEFAULT '',
  `date_format` varchar(25) NOT NULL DEFAULT '',
  `mysql_date` varchar(25) NOT NULL DEFAULT '',
  `date_ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `theme` varchar(50) NOT NULL DEFAULT '',
  `themeswitcher` enum('0','1') NOT NULL DEFAULT '0',
  `language` varchar(40) NOT NULL DEFAULT '',
  `modr` enum('0','1') NOT NULL DEFAULT '0',
  `captcha` enum('0','1') NOT NULL DEFAULT '0',
  `aboutsite` mediumtext NOT NULL,
  `licence` mediumtext NOT NULL,
  `thumbpage` tinyint(3) NOT NULL DEFAULT '0',
  `comthumbpage` tinyint(3) NOT NULL DEFAULT '0',
  `commentsorder` enum('0','1') NOT NULL DEFAULT '0',
  `cart` enum('0','1') NOT NULL DEFAULT '0',
  `comments` enum('0','1') NOT NULL DEFAULT '0',
  `approve` enum('0','1') NOT NULL DEFAULT '0',
  `verification` enum('0','1') NOT NULL DEFAULT '0',
  `slideshow` enum('0','1') NOT NULL DEFAULT '0',
  `slidespeeds` varchar(100) NOT NULL DEFAULT '',
  `slidewindow` varchar(10) NOT NULL DEFAULT '',
  `mp3` text NOT NULL,
  `greybox` enum('0','1') NOT NULL DEFAULT '0',
  `watermarks` enum('0','1') NOT NULL DEFAULT '0',
  `watertext` varchar(50) NOT NULL DEFAULT '',
  `waterhspace` int(3) NOT NULL DEFAULT '0',
  `watervspace` int(3) NOT NULL DEFAULT '0',
  `waterfont` varchar(7) NOT NULL DEFAULT '',
  `watersize` int(2) NOT NULL DEFAULT '0',
  `watertextr` int(3) NOT NULL DEFAULT '0',
  `watertextg` int(3) NOT NULL DEFAULT '0',
  `watertextb` int(3) NOT NULL DEFAULT '0',
  `waterangle` int(2) NOT NULL DEFAULT '0',
  `autothumb` enum('0','1') NOT NULL DEFAULT '0',
  `autowidth` varchar(3) NOT NULL DEFAULT '0',
  `autoheight` varchar(3) NOT NULL DEFAULT '0',
  `thumbwidth` varchar(3) NOT NULL DEFAULT '0',
  `thumbheight` varchar(3) NOT NULL DEFAULT '0',
  `imgwidth` varchar(3) NOT NULL DEFAULT '0',
  `imgheight` varchar(3) NOT NULL DEFAULT '0',
  `pagedisplaysize` varchar(3) NOT NULL DEFAULT '540',
  `windowsizes` varchar(15) NOT NULL DEFAULT '',
  `keywords` text NOT NULL,
  `description` text NOT NULL,
  `reset` enum('0','1') NOT NULL DEFAULT '0',
  `smtp` enum('0','1') NOT NULL DEFAULT '0',
  `smtp_host` varchar(100) NOT NULL DEFAULT 'localhost',
  `smtp_user` varchar(100) NOT NULL DEFAULT '',
  `smtp_pass` varchar(100) NOT NULL DEFAULT '',
  `smtp_port` varchar(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

-- Dumping data for table mga_settings: 1 rows

INSERT INTO `mga_settings` (`id`, `website`, `email`, `homepage`, `folder`, `folder_name`, `date_format`, `mysql_date`, `date_ts`, `theme`, `themeswitcher`, `language`, `modr`, `captcha`, `aboutsite`, `licence`, `thumbpage`, `comthumbpage`, `commentsorder`, `cart`, `comments`, `approve`, `verification`, `slideshow`, `slidespeeds`, `slidewindow`, `mp3`, `greybox`, `watermarks`, `watertext`, `waterhspace`, `watervspace`, `waterfont`, `watersize`, `watertextr`, `watertextg`, `watertextb`, `waterangle`, `autothumb`, `autowidth`, `autoheight`, `thumbwidth`, `thumbheight`, `imgwidth`, `imgheight`, `pagedisplaysize`, `windowsizes`, `keywords`, `description`, `reset`, `smtp`, `smtp_host`, `smtp_user`, `smtp_pass`, `smtp_port`) VALUES
	(1, 'My Photo Gallery', 'you@youremail.com', 'http://www.yoursite.co.uk', 'http://www.yoursite.co.uk/gallery', 'categories', 'j F Y', '%e %b %Y', '2012-02-29 22:21:59', 'standard', '0', 'english.php', '0', '1', '', '', 12, 10, '1', '0', '1', '1', '0', '1', '20000,15000,9000', '575,470', '', '1', '0', 'Watermark', 150, 150, 'arial', 12, 255, 255, 255, 30, '1', '90', '60', '0', '0', '640', '480', '540', '680,540', '', '', '0', '0', 'localhost', '', '', '25');
