CREATE TABLE `zest_activities` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `user_id` int(11) NOT NULL,
  `item_type` text,
  `item_id` int(11) NOT NULL,
  `activity_type` text,
  `item_old` text,
  `date` timestamp NOT NULL default CURRENT_TIMESTAMP,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `zest_addresses` (
  `id` int(11) NOT NULL auto_increment,
  `user_id` int(11) NOT NULL default '0',
  `company` text,
  `vat_no` varchar(32) default NULL,
  `address_one` text,
  `address_two` text,
  `address_three` text,
  `telephone` varchar(32) default NULL,
  `post_code` varchar(32) default NULL,
  `country_id` int(11) NOT NULL default '0',
  `date_added` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `name` varchar(150) default NULL,
  `title` varchar(32) default NULL,
  `fl_deleted` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `zest_attribute_definitions` (
  `id` int(11) NOT NULL auto_increment,
  `attribute_id` int(11) NOT NULL default '0',
  `language_id` int(11) NOT NULL default '0',
  `title` text,
  PRIMARY KEY  (`id`),
  KEY `attribute_id` (`attribute_id`),
  KEY `language_id` (`language_id`),
  CONSTRAINT `zest_attribute_definitions_ibfk_1` FOREIGN KEY (`attribute_id`) REFERENCES `zest_attributes` (`id`) ON DELETE CASCADE,
  CONSTRAINT `zest_attribute_definitions_ibfk_2` FOREIGN KEY (`language_id`) REFERENCES `zest_languages` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `zest_attributes` (
  `id` int(11) NOT NULL auto_increment,
  `title` text,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `zest_banners` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(32) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=219 DEFAULT CHARSET=latin1;

CREATE TABLE `zest_banners_medias` (
  `banner_id` int(11) default NULL,
  `media_id` int(11) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE `zest_banners_pages` (
  `banner_id` int(11) NOT NULL auto_increment,
  `page_id` int(11) default NULL,
  PRIMARY KEY  (`banner_id`)
) ENGINE=MyISAM AUTO_INCREMENT=219 DEFAULT CHARSET=latin1;

CREATE TABLE `zest_case_studies` (
  `id` int(11) NOT NULL auto_increment,
  `title` text,
  `description` text,
  `service_id` int(11) default NULL,
  `media_id` int(11) default NULL,
  `industry_id` int(11) default NULL,
  `views` int(11) default NULL,
  `display_orde` int(11) default NULL,
  `status_id` int(11) default NULL,
  `display_order` int(11) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=253 DEFAULT CHARSET=latin1;

CREATE TABLE `zest_case_studies_medias` (
  `case_study_id` int(11) default NULL,
  `media_id` int(11) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE `zest_comments` (
  `id` int(11) NOT NULL auto_increment,
  `user_id` int(11) default NULL,
  `feedpost_id` int(11) default NULL,
  `date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `title` text,
  `display_name` text,
  `email` text,
  `status_id` int(11) default NULL,
  `fl_deleted` tinyint(4) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;

CREATE TABLE `zest_countries` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `title` text NOT NULL,
  `zone_id` int(11) NOT NULL,
  `iso_code2` varchar(8) default NULL,
  `iso_code3` varchar(8) default NULL,
  `delivery_rate_id` int(11) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `zest_countries_products` (
  `country_id` int(11) NOT NULL default '0',
  `product_id` int(11) NOT NULL default '0',
  KEY `product_id` (`product_id`),
  CONSTRAINT `zest_countries_products_ibfk_1` FOREIGN KEY (`product_id`) REFERENCES `zest_products` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `zest_currencies` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(32) default NULL,
  `code` varchar(32) default NULL,
  `symbol_left` varchar(32) default NULL,
  `symbol_right` varchar(32) default NULL,
  `decimal_point` varchar(4) default NULL,
  `conversion_rate` varchar(32) NOT NULL default '1',
  `last_updated` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `zest_delivery_rates` (
  `id` int(11) NOT NULL auto_increment,
  `country_id` int(11) NOT NULL default '0',
  `single_value` varchar(32) NOT NULL default '0',
  `multiple_value` varchar(32) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `zest_discount_bands` (
  `id` int(11) NOT NULL auto_increment,
  `discount_id` int(11) NOT NULL default '0',
  `min_qty` int(11) NOT NULL default '0',
  `max_qty` int(11) NOT NULL default '0',
  `percentage` varchar(6) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `discount_id` (`discount_id`),
  CONSTRAINT `zest_discount_bands_ibfk_1` FOREIGN KEY (`discount_id`) REFERENCES `zest_discounts` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `zest_discounts` (
  `id` int(11) NOT NULL auto_increment,
  `code` varchar(4) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `zest_drafts` (
  `id` int(11) NOT NULL auto_increment,
  `user_id` int(11) default NULL,
  `date_posted` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `object_type` text,
  `object_id` int(11) default NULL,
  `object_serialized` text,
  `accepted` int(11) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1152 DEFAULT CHARSET=latin1;

CREATE TABLE `zest_event_categories` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(32) default NULL,
  `parent_id` int(11) default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

CREATE TABLE `zest_event_dates` (
  `id` int(11) NOT NULL auto_increment,
  `date_added` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `date` datetime default NULL,
  `event_id` int(11) default NULL,
  `location` text,
  `price` text,
  `spaces` text,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=53 DEFAULT CHARSET=latin1;

CREATE TABLE `zest_event_tickets` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `user_id` int(11) NOT NULL,
  `ticket_count` int(11) default NULL,
  `event_date_id` int(11) default NULL,
  `name` text,
  `email` text,
  `fl_confirmed` tinyint(4) default NULL,
  `date` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `contact_serialized` text,
  `basket_serialized` text,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `zest_events` (
  `id` int(11) NOT NULL auto_increment,
  `title` text,
  `date_added` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `description` text,
  `media_id` int(11) default NULL,
  `user_id` int(11) default NULL,
  `venue` text,
  `price` float(7,2) default NULL,
  `status_id` int(11) NOT NULL default '1',
  `date` datetime default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;


CREATE TABLE `zest_events_medias` (
  `event_id` int(11) default NULL,
  `media_id` int(11) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE `zest_events_users` (
  `event_id` int(11) default NULL,
  `user_id` int(11) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE `zest_external_feedposts` (
  `id` int(11) NOT NULL auto_increment,
  `external_feed_id` int(11) default NULL,
  `title` text,
  `text` text,
  `pubDate` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `permalink` text,
  `fl_deleted` int(11) default NULL,
  `status_id` int(11) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=737 DEFAULT CHARSET=latin1;

CREATE TABLE `zest_external_feeds` (
  `id` int(11) NOT NULL auto_increment,
  `title` text,
  `url` text,
  `favicon` text,
  `last_updated` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `snippet` text,
  `username` text,
  `password` text,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=83 DEFAULT CHARSET=latin1;

CREATE TABLE `zest_feedpost_definitions` (
  `id` int(11) NOT NULL auto_increment,
  `feedpost_id` int(11) NOT NULL default '1',
  `language_id` int(11) NOT NULL default '1',
  `title` text,
  `text` text,
  PRIMARY KEY  (`id`),
  KEY `definition_page_id` (`feedpost_id`),
  KEY `definition_language_id` (`language_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `zest_feedposts` (
  `id` int(11) NOT NULL auto_increment,
  `url` text,
  `title` text,
  `date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `text` text,
  `user_id` int(11) default NULL,
  `feed_id` int(11) default NULL,
  `media_id` int(11) default NULL,
  `status_id` int(11) NOT NULL default '1',
  `tweeted` int(11) default NULL,
  `views` int(11) default NULL,
  PRIMARY KEY  (`id`),
  KEY `feed_id` (`feed_id`),
  KEY `status_id` (`status_id`)
) ENGINE=MyISAM AUTO_INCREMENT=67 DEFAULT CHARSET=latin1;

CREATE TABLE `zest_feedposts_tags` (
  `feedpost_id` int(11) default NULL,
  `tag_id` int(11) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE `zest_feeds` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(32) default NULL,
  `tweet` int(11) default NULL,
  `tweet_desc` text,
  `description` text,
  `allow_comments` int(11) default NULL,
  PRIMARY KEY  (`id`),
  KEY `title` (`title`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;

CREATE TABLE `zest_form_submissions` (
  `id` int(11) NOT NULL auto_increment,
  `post` text,
  `form_id` int(11) default NULL,
  `date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

CREATE TABLE `zest_forms` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(32) default NULL,
  `view` varchar(32) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

CREATE TABLE `zest_industries` (
  `id` int(11) NOT NULL auto_increment,
  `title` text,
  `description` text,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=96 DEFAULT CHARSET=latin1;

CREATE TABLE `zest_languages` (
  `id` int(11) NOT NULL auto_increment,
  `title` text,
  `charset` text,
  `code` text,
  `fl_use` tinyint(4) NOT NULL default '0',
  `fl_default` tinyint(4) NOT NULL default '0',
  `locale` varchar(6) default NULL,
  `sort_order` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `fl_use` (`fl_use`),
  KEY `fl_default` (`fl_default`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `zest_logins` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `ip` varchar(15) NOT NULL,
  `success` tinyint(1) default NULL,
  `username` varchar(42) default NULL,
  `date` timestamp NOT NULL default CURRENT_TIMESTAMP,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `zest_media_types` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `name` varchar(32) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

CREATE TABLE `zest_medias` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `media_type_id` int(11) default NULL,
  `filename` text,
  `title` text,
  `category` varchar(32) default NULL,
  `banner_order` int(11) default NULL,
  PRIMARY KEY  (`id`),
  KEY `media_type_id` (`media_type_id`),
  KEY `banner_order` (`banner_order`),
  KEY `category` (`category`)
) ENGINE=MyISAM AUTO_INCREMENT=187 DEFAULT CHARSET=latin1;

CREATE TABLE `zest_medias_pages` (
  `media_id` int(11) default NULL,
  `page_id` int(11) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE `zest_medias_products` (
  `product_id` int(11) default NULL,
  `media_id` int(11) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE `zest_navbars` (
  `id` int(11) NOT NULL auto_increment,
  `title` text,
  `view` text,
  `show_subnav` tinyint(1) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

CREATE TABLE `zest_offers` (
  `id` int(11) NOT NULL auto_increment,
  `product_id` int(11) unsigned zerofill NOT NULL default '00000000001',
  `sale_price` varchar(32) default NULL,
  `status_id` int(11) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

CREATE TABLE `zest_order_products` (
  `id` int(11) NOT NULL auto_increment,
  `vat` varchar(32) default NULL,
  `vat_rate_id` int(11) NOT NULL default '0',
  `item_price` varchar(32) default NULL,
  `quantity` int(11) NOT NULL default '0',
  `order_id` int(11) NOT NULL default '0',
  `product_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `zest_order_products`
--

LOCK TABLES `zest_order_products` WRITE;
/*!40000 ALTER TABLE `zest_order_products` DISABLE KEYS */;
/*!40000 ALTER TABLE `zest_order_products` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `zest_order_status_definitions`
--

DROP TABLE IF EXISTS `zest_order_status_definitions`;
CREATE TABLE `zest_order_status_definitions` (
  `id` int(11) NOT NULL auto_increment,
  `order_status_id` int(11) NOT NULL default '0',
  `language_id` int(11) NOT NULL default '0',
  `title` text,
  PRIMARY KEY  (`id`),
  KEY `order_status_id` (`order_status_id`),
  KEY `language_id` (`language_id`),
  CONSTRAINT `zest_order_status_definitions_ibfk_1` FOREIGN KEY (`order_status_id`) REFERENCES `zest_order_statuses` (`id`) ON DELETE CASCADE,
  CONSTRAINT `zest_order_status_definitions_ibfk_2` FOREIGN KEY (`language_id`) REFERENCES `zest_languages` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `zest_order_status_definitions`
--

LOCK TABLES `zest_order_status_definitions` WRITE;
/*!40000 ALTER TABLE `zest_order_status_definitions` DISABLE KEYS */;
/*!40000 ALTER TABLE `zest_order_status_definitions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `zest_order_statuses`
--

DROP TABLE IF EXISTS `zest_order_statuses`;
CREATE TABLE `zest_order_statuses` (
  `id` int(11) NOT NULL auto_increment,
  `title` text,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `zest_order_statuses`
--

LOCK TABLES `zest_order_statuses` WRITE;
/*!40000 ALTER TABLE `zest_order_statuses` DISABLE KEYS */;
/*!40000 ALTER TABLE `zest_order_statuses` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `zest_orders`
--

DROP TABLE IF EXISTS `zest_orders`;
CREATE TABLE `zest_orders` (
  `id` int(11) NOT NULL auto_increment,
  `user_id` int(11) NOT NULL default '0',
  `purchase_order` varchar(32) default NULL,
  `basket_serialized` text,
  `product_quantity` int(11) NOT NULL default '0',
  `total_price` varchar(32) default NULL,
  `currency_id` int(11) NOT NULL default '0',
  `delivery_address_id` int(11) default NULL,
  `invoice_address_id` int(11) NOT NULL default '0',
  `delivery_type` varchar(32) default NULL,
  `extra_info` text,
  `payment_method_id` int(11) NOT NULL default '0',
  `order_status_id` int(11) NOT NULL default '0',
  `shipping_method` varchar(32) default NULL,
  `tracking_number` varchar(32) default NULL,
  `date_added` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `auth_code` text,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `zest_orders`
--

LOCK TABLES `zest_orders` WRITE;
/*!40000 ALTER TABLE `zest_orders` DISABLE KEYS */;
/*!40000 ALTER TABLE `zest_orders` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `zest_page_definitions`
--

DROP TABLE IF EXISTS `zest_page_definitions`;
CREATE TABLE `zest_page_definitions` (
  `id` int(11) NOT NULL auto_increment,
  `page_id` int(11) NOT NULL default '1',
  `language_id` int(11) NOT NULL default '1',
  `title` text,
  `seoTitle` text,
  `seoKeywords` text,
  `seoDescription` text,
  `bodyText` text,
  PRIMARY KEY  (`id`),
  KEY `definition_page_id` (`page_id`),
  KEY `definition_language_id` (`language_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `zest_page_definitions`
--

LOCK TABLES `zest_page_definitions` WRITE;
/*!40000 ALTER TABLE `zest_page_definitions` DISABLE KEYS */;
/*!40000 ALTER TABLE `zest_page_definitions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `zest_pages`
--

DROP TABLE IF EXISTS `zest_pages`;
CREATE TABLE `zest_pages` (
  `id` int(11) NOT NULL auto_increment,
  `template_id` int(11) NOT NULL default '1',
  `title` varchar(32) default NULL,
  `bodyText` text,
  `parent_id` int(11) NOT NULL default '0',
  `seoTitle` varchar(72) default NULL,
  `seoURL` varchar(32) default NULL,
  `seoKeywords` text,
  `seoDescription` text,
  `extraJS` text,
  `extraCSS` text,
  `status_id` int(11) NOT NULL default '1',
  `form_id` int(11) NOT NULL default '0',
  `showOnNav` tinyint(4) NOT NULL default '0',
  `display_order` int(11) default NULL,
  `navbar_id` int(11) default NULL,
  `order` int(11) default NULL,
  `views` int(11) default NULL,
  `date_updated` timestamp NOT NULL default '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP,
  `class` varchar(32) default NULL,
  `seoText` text,
  PRIMARY KEY  (`id`),
  KEY `status_id` (`status_id`),
  KEY `navbar_id` (`navbar_id`),
  KEY `showOnNav` (`showOnNav`),
  KEY `parent_id` (`parent_id`),
  KEY `display_order` (`display_order`),
  KEY `order` (`order`),
  KEY `seoURL` (`seoURL`)
) ENGINE=MyISAM AUTO_INCREMENT=50 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `zest_pages`
--

LOCK TABLES `zest_pages` WRITE;
/*!40000 ALTER TABLE `zest_pages` DISABLE KEYS */;
INSERT INTO `zest_pages` VALUES (1,1,'Home','
\n	Suspendisse vestibulum dignissim quam. Integer vel augue. Phasellus nulla purus, interdum ac, venenatis non, varius rutrum, leo. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Duis a eros.
\n
\n	Suspendisse vestibulum dignissim quam. Integer vel augue. Phasellus nulla purus, interdum ac, venenatis non, varius rutrum, leo. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Duis a eros.
\n',0,'','/','','','','',2,0,1,1,1,1,110,'2009-11-19 10:12:26',NULL,'');
/*!40000 ALTER TABLE `zest_pages` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `zest_pages_navbars`
--

DROP TABLE IF EXISTS `zest_pages_navbars`;
CREATE TABLE `zest_pages_navbars` (
  `page_id` int(11) default NULL,
  `navbar_id` int(11) default NULL,
  `id` int(11) NOT NULL auto_increment,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `zest_pages_navbars`
--

LOCK TABLES `zest_pages_navbars` WRITE;
/*!40000 ALTER TABLE `zest_pages_navbars` DISABLE KEYS */;
/*!40000 ALTER TABLE `zest_pages_navbars` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `zest_payment_method_definitions`
--

DROP TABLE IF EXISTS `zest_payment_method_definitions`;
CREATE TABLE `zest_payment_method_definitions` (
  `id` int(11) NOT NULL auto_increment,
  `payment_method_id` int(11) NOT NULL default '0',
  `language_id` int(11) NOT NULL default '0',
  `title` text,
  `description` text,
  PRIMARY KEY  (`id`),
  KEY `payment_method_id` (`payment_method_id`),
  KEY `language_id` (`language_id`),
  CONSTRAINT `zest_payment_method_definitions_ibfk_1` FOREIGN KEY (`payment_method_id`) REFERENCES `zest_payment_methods` (`id`) ON DELETE CASCADE,
  CONSTRAINT `zest_payment_method_definitions_ibfk_2` FOREIGN KEY (`language_id`) REFERENCES `zest_languages` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `zest_payment_method_definitions`
--

LOCK TABLES `zest_payment_method_definitions` WRITE;
/*!40000 ALTER TABLE `zest_payment_method_definitions` DISABLE KEYS */;
/*!40000 ALTER TABLE `zest_payment_method_definitions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `zest_payment_methods`
--

DROP TABLE IF EXISTS `zest_payment_methods`;
CREATE TABLE `zest_payment_methods` (
  `id` int(11) NOT NULL auto_increment,
  `title` text,
  `fl_payment_taken` tinyint(4) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `zest_payment_methods`
--

LOCK TABLES `zest_payment_methods` WRITE;
/*!40000 ALTER TABLE `zest_payment_methods` DISABLE KEYS */;
/*!40000 ALTER TABLE `zest_payment_methods` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `zest_product_attributes`
--

DROP TABLE IF EXISTS `zest_product_attributes`;
CREATE TABLE `zest_product_attributes` (
  `id` int(11) NOT NULL auto_increment,
  `product_id` int(11) NOT NULL default '0',
  `attribute_id` int(11) NOT NULL default '0',
  `value` varchar(32) NOT NULL default '0',
  `unit` varchar(32) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `product_id` (`product_id`),
  KEY `attribute_id` (`attribute_id`),
  CONSTRAINT `zest_product_attributes_ibfk_1` FOREIGN KEY (`product_id`) REFERENCES `zest_products` (`id`) ON DELETE CASCADE,
  CONSTRAINT `zest_product_attributes_ibfk_2` FOREIGN KEY (`attribute_id`) REFERENCES `zest_attributes` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `zest_product_attributes`
--

LOCK TABLES `zest_product_attributes` WRITE;
/*!40000 ALTER TABLE `zest_product_attributes` DISABLE KEYS */;
/*!40000 ALTER TABLE `zest_product_attributes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `zest_product_categories`
--

DROP TABLE IF EXISTS `zest_product_categories`;
CREATE TABLE `zest_product_categories` (
  `id` int(11) NOT NULL auto_increment,
  `parent_id` int(11) NOT NULL default '0',
  `title` varchar(32) default NULL,
  `description` text,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `zest_product_categories`
--

LOCK TABLES `zest_product_categories` WRITE;
/*!40000 ALTER TABLE `zest_product_categories` DISABLE KEYS */;
/*!40000 ALTER TABLE `zest_product_categories` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `zest_product_category_definitions`
--

DROP TABLE IF EXISTS `zest_product_category_definitions`;
CREATE TABLE `zest_product_category_definitions` (
  `id` int(11) NOT NULL auto_increment,
  `product_category_id` int(11) NOT NULL default '0',
  `language_id` int(11) NOT NULL default '0',
  `title` text,
  `description` text,
  PRIMARY KEY  (`id`),
  KEY `product_category_id` (`product_category_id`),
  KEY `language_id` (`language_id`),
  CONSTRAINT `zest_product_category_definitions_ibfk_1` FOREIGN KEY (`product_category_id`) REFERENCES `zest_product_categories` (`id`) ON DELETE CASCADE,
  CONSTRAINT `zest_product_category_definitions_ibfk_2` FOREIGN KEY (`language_id`) REFERENCES `zest_languages` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `zest_product_category_definitions`
--

LOCK TABLES `zest_product_category_definitions` WRITE;
/*!40000 ALTER TABLE `zest_product_category_definitions` DISABLE KEYS */;
/*!40000 ALTER TABLE `zest_product_category_definitions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `zest_product_definitions`
--

DROP TABLE IF EXISTS `zest_product_definitions`;
CREATE TABLE `zest_product_definitions` (
  `id` int(11) NOT NULL auto_increment,
  `product_id` int(11) NOT NULL default '0',
  `language_id` int(11) NOT NULL default '0',
  `title` text,
  `description` text,
  PRIMARY KEY  (`id`),
  KEY `product_id` (`product_id`),
  KEY `language_id` (`language_id`),
  CONSTRAINT `zest_product_definitions_ibfk_1` FOREIGN KEY (`product_id`) REFERENCES `zest_products` (`id`) ON DELETE CASCADE,
  CONSTRAINT `zest_product_definitions_ibfk_2` FOREIGN KEY (`language_id`) REFERENCES `zest_languages` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `zest_product_definitions`
--

LOCK TABLES `zest_product_definitions` WRITE;
/*!40000 ALTER TABLE `zest_product_definitions` DISABLE KEYS */;
/*!40000 ALTER TABLE `zest_product_definitions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `zest_products`
--

DROP TABLE IF EXISTS `zest_products`;
CREATE TABLE `zest_products` (
  `id` int(11) NOT NULL auto_increment,
  `product_category_id` int(11) NOT NULL default '1',
  `title` varchar(32) default NULL,
  `description` text,
  `date` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `price` varchar(32) default NULL,
  `ref` varchar(32) default NULL,
  `status_id` int(11) NOT NULL default '1',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `zest_products`
--

LOCK TABLES `zest_products` WRITE;
/*!40000 ALTER TABLE `zest_products` DISABLE KEYS */;
/*!40000 ALTER TABLE `zest_products` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `zest_products_tags`
--

DROP TABLE IF EXISTS `zest_products_tags`;
CREATE TABLE `zest_products_tags` (
  `product_id` int(11) default NULL,
  `tag_id` int(11) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `zest_products_tags`
--

LOCK TABLES `zest_products_tags` WRITE;
/*!40000 ALTER TABLE `zest_products_tags` DISABLE KEYS */;
/*!40000 ALTER TABLE `zest_products_tags` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `zest_related_product_categories`
--

DROP TABLE IF EXISTS `zest_related_product_categories`;
CREATE TABLE `zest_related_product_categories` (
  `product_category_id` int(11) default NULL,
  `related_category_id` int(11) default NULL,
  KEY `zest_related_product_categories_ibfk_1` (`product_category_id`),
  KEY `zest_related_product_categories_ibfk_2` (`related_category_id`),
  CONSTRAINT `zest_related_product_categories_ibfk_1` FOREIGN KEY (`product_category_id`) REFERENCES `zest_product_categories` (`id`) ON DELETE CASCADE,
  CONSTRAINT `zest_related_product_categories_ibfk_2` FOREIGN KEY (`related_category_id`) REFERENCES `zest_product_categories` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `zest_related_product_categories`
--

LOCK TABLES `zest_related_product_categories` WRITE;
/*!40000 ALTER TABLE `zest_related_product_categories` DISABLE KEYS */;
/*!40000 ALTER TABLE `zest_related_product_categories` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `zest_roles`
--

DROP TABLE IF EXISTS `zest_roles`;
CREATE TABLE `zest_roles` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `name` varchar(32) NOT NULL,
  `description` text NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `uniq_name` (`name`),
  KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `zest_roles`
--

LOCK TABLES `zest_roles` WRITE;
/*!40000 ALTER TABLE `zest_roles` DISABLE KEYS */;
INSERT INTO `zest_roles` VALUES (1,'superuser','Super Access'),(2,'admin','Has access to the admin tab'),(3,'users','Can manage users'),(4,'pages','Can manage pages'),(5,'media','Can manage media uploads'),(6,'feeds','can manage the feeds section'),(7,'forms','Can access the form submissions'),(8,'store','Has access to the store section of Zest'),(9,'public','Has access to the public members area'),(10,'publisher','Does not require authorisation before publishing anything'),(11,'templates','Can manage templates'),(12,'snippets','Can manage the snippets'),(13,'seo','Can manage the pages seo'),(14,'events','Can manage the events');
/*!40000 ALTER TABLE `zest_roles` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `zest_roles_users`
--

DROP TABLE IF EXISTS `zest_roles_users`;
CREATE TABLE `zest_roles_users` (
  `user_id` int(10) unsigned NOT NULL,
  `role_id` int(10) unsigned NOT NULL,
  KEY `user_id` (`user_id`),
  KEY `role_id` (`role_id`),
  CONSTRAINT `zest_roles_users_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `zest_users` (`id`) ON DELETE CASCADE,
  CONSTRAINT `zest_roles_users_ibfk_2` FOREIGN KEY (`role_id`) REFERENCES `zest_roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `zest_roles_users`
--

LOCK TABLES `zest_roles_users` WRITE;
/*!40000 ALTER TABLE `zest_roles_users` DISABLE KEYS */;
INSERT INTO `zest_roles_users` VALUES (1,1),(1,2),(1,3),(1,4),(1,5),(1,10),(1,11),(1,12),(1,13),(1,6),(1,7);
/*!40000 ALTER TABLE `zest_roles_users` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `zest_services`
--

DROP TABLE IF EXISTS `zest_services`;
CREATE TABLE `zest_services` (
  `id` int(11) NOT NULL auto_increment,
  `title` text,
  `description` text,
  `parent_id` int(11) default NULL,
  `seoTitle` text,
  `seoKeywords` text,
  `seoDescription` text,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=136 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `zest_services`
--

LOCK TABLES `zest_services` WRITE;
/*!40000 ALTER TABLE `zest_services` DISABLE KEYS */;
INSERT INTO `zest_services` VALUES (104,'Digital Marketing','
Promoting your site via organic Search Engine Optimisation (SEO), Pay Per Click (PPC), Social Media, Blogging and other online marketing activities, ensures that your website\'s message is delivered to the correct audience, in the most cost effective manner. Our expertise in search engine digital marketing has reaped excellent rewards for many of our clients.
',0,'digital marketing | SEM | search engine marketing','digital marketing search engine marketing sem',''),(100,'Web Design','
Our experience, creativity and technical know-how are all key to delivering the best website design for all of our clients, from large corporate sites with fully incorporated CMS (content management system), through to smaller SME\'s (small and medium enterprises) and sites that are wholly Flash based.
',0,'creative web design & website development','',''),(107,'Branding','
The concept of a brand extends far beyond your company logo, it encorporates your business\' core values and every interaction you have with customers and suppliers. In effect, your brand creates and maintains your reputation and so reflects your customers\' experience with your organisation. We can help you rebrand a tired image, or create a brand new one.
',0,'brand marketing & branding design','brand marketing logo design organisation re-branding company design',''),(108,'Print','
Design for print, including brochures, reports and POS material, is a key discipline at Marmalade. We are meticulous in our creation of eye-catching, well designed documents which provide beautiful and successful marketing pieces for our clients.
',0,'print advertising & printing design','print advertising printing design',''),(109,'Illustration','
Our focus is always on being the most creative we can for our clients. This includes pushing brand guidelines as far as possible to achieve the client\'s goals, and offering different creative approaches including illustration and photography.
',0,'illustration & design','illustration design graphic',''),(110,'Advertising','
By creating clear, concise and pertinent advertising messages, we create highly creative and successful digital and print campaigns, which help our clients achieve the best results using all advertising media.
',0,'print advertising & digital media advertising','print adertising digital media ppc paid search ads',''),(111,'Creative Illustration','
A drawn image can often say much more than a photographic one. We often use illustration to provide a unique and contemporary feel to our clients\' marketing campaigns.
',109,'creative illustration & unique design','illustration graphic design ',''),(112,'Photography','
A beautiful image makes a huge difference to any marketing campaign. Whether it be the key message on a website home page, or a distinct style for an ad campaign, we can create the perfect image for you.
',109,'photography illustration & photographic design','photography photo photographic design illustration',''),(132,'Website Usability','
 
\n
Usability can make or break your website. Always remember that the most important thing about any website is the people who use the website. There are a few simple questions to ask when questioning the design of a website:
\n
\n
Is it easy to use?
\n
Is it easy to navigate?
\n
Is it of interest?
\n
Does it look good?
\n
\n
When designing websites you always have to remember to design it for the right person. Often the site isnt for the person who owns the site, and very very rarely is it for the person who designs the site. Thats why, here at Marmalade on Toast, we try and put the user first. Their is nothing worse than going to a site that looks all pretty but then not knowing how to use it.
\n
Recently, users have began to understand good design, and the common thought is that you have 3 seconds to convince a user to stay on your site. The 3 second rule is a bit of a myth however it is a good thing to go buy. So to convince the user to stay on your site, a beautiful design certainly helps. However, often the problem with designing beautiful sites is that old browsers, such as Internet Explorer 6 does not render the site the same as more modern browsers. So we use a process called \'progressive enhancement\'. This means that in modern browsers it looks beautiful. However in older browsers it looks almost as good, but most importantly, it still \'works\' perfectly.
\n
One major factor with websites is loading time. We use various tools to make sure our sites load within an \'acceptable\' time. This helps keeping the users on the site and with SEO.
\n
 
',100,'website usability','web website usability ','
Is your website easy to use? If not you could be losing valuable customers. Contact Marmalade on Toast to rectify with our award winning web designs.
'),(133,'Web Accessibility','
 
\n
We make sure our code meets all the relevant standards. Making website\'s accessible is our aim. Their is nothing worse than sites that don\'t adhere to standards and are not at all accessible. What if a user were blind, and using a screen reader to render the site. They should be able to access the site as well, surely?
\n
Not only do we make sure our code meets current standards, we also try to make them future proof, by using the latest technologies and standards. We have adopted microformats to help our sites to be more machine readable than ever. Google have just started implementing some microformatted data (\'rich snippets\') in their search results, which gives users more  relevant information about your site, and you can be sure they will start implementing more in the future.
\n
 
',100,'website accessibility','web website accessability',''),(134,'The Mobile Web','
We are strong advocates of the mobile internet. We believe that the mobile web is the future. Just like our normal websites, we deliver beautiful mobile versions of our websites as well. 
\n
We have created an iPhone friendly version of our site here. Just point your iphone to http://www.marmaladeontoast.co.uk and see what we have done.
\n
 
',100,'mobile website design & the mobile web','mobile web website design',''),(135,'CMS (Content Management Systems)','
 
\n
We have developed our own CMS (Content Management System) using the very latest technologies to make it even easier than ever to manage your website. Not only is it easy to use, but we have integrated the latest marketing tools to enable you to market your site efficiently and effectively.
\n
We have included RSS feeds and Twitter integration as standard, and are always working on improving how it looks and how it works.
\n
For more information please contact us
\n
 
',100,'CMS | Content Management Systems | Web Development','','');
/*!40000 ALTER TABLE `zest_services` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `zest_sessions`
--

DROP TABLE IF EXISTS `zest_sessions`;
CREATE TABLE `zest_sessions` (
  `session_id` varchar(127) NOT NULL,
  `last_activity` int(10) unsigned NOT NULL,
  `data` text NOT NULL,
  PRIMARY KEY  (`session_id`),
  KEY `session_id` (`session_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `zest_sessions`
--

LOCK TABLES `zest_sessions` WRITE;
/*!40000 ALTER TABLE `zest_sessions` DISABLE KEYS */;
INSERT INTO `zest_sessions` VALUES ('2219e59f0cd58690dce97207369cbfa2',1257080122,'c2Vzc2lvbl9pZHxzOjMyOiIyMjE5ZTU5ZjBjZDU4NjkwZGNlOTcyMDczNjljYmZhMiI7dG90YWxfaGl0c3xpOjk3O19rZl9mbGFzaF98YTowOnt9dXNlcl9hZ2VudHxzOjEyMToiTW96aWxsYS81LjAgKE1hY2ludG9zaDsgVTsgSW50ZWwgTWFjIE9TIFggMTBfNl8xOyBlbi11cykgQXBwbGVXZWJLaXQvNTMxLjkgKEtIVE1MLCBsaWtlIEdlY2tvKSBWZXJzaW9uLzQuMC4zIFNhZmFyaS81MzEuOSI7aXBfYWRkcmVzc3xzOjc6IjAuMC4wLjAiO2xhc3RfYWN0aXZpdHl8aToxMjU3MDgwMTIyOw=='),('5df5e061658173adfaceaa0cdfd07301',1257080426,'c2Vzc2lvbl9pZHxzOjMyOiI1ZGY1ZTA2MTY1ODE3M2FkZmFjZWFhMGNkZmQwNzMwMSI7dG90YWxfaGl0c3xpOjY7X2tmX2ZsYXNoX3xhOjA6e311c2VyX2FnZW50fHM6MTIxOiJNb3ppbGxhLzUuMCAoTWFjaW50b3NoOyBVOyBJbnRlbCBNYWMgT1MgWCAxMF82XzE7IGVuLXVzKSBBcHBsZVdlYktpdC81MzEuOSAoS0hUTUwsIGxpa2UgR2Vja28pIFZlcnNpb24vNC4wLjMgU2FmYXJpLzUzMS45IjtpcF9hZGRyZXNzfHM6NzoiMC4wLjAuMCI7bGFzdF9hY3Rpdml0eXxpOjEyNTcwODA0MjU7'),('69caff5f804069d76a6d4bc4fb9f7d7c',1257080542,'c2Vzc2lvbl9pZHxzOjMyOiI2OWNhZmY1ZjgwNDA2OWQ3NmE2ZDRiYzRmYjlmN2Q3YyI7dG90YWxfaGl0c3xpOjI7X2tmX2ZsYXNoX3xhOjA6e311c2VyX2FnZW50fHM6MTIxOiJNb3ppbGxhLzUuMCAoTWFjaW50b3NoOyBVOyBJbnRlbCBNYWMgT1MgWCAxMF82XzE7IGVuLXVzKSBBcHBsZVdlYktpdC81MzEuOSAoS0hUTUwsIGxpa2UgR2Vja28pIFZlcnNpb24vNC4wLjMgU2FmYXJpLzUzMS45IjtpcF9hZGRyZXNzfHM6NzoiMC4wLjAuMCI7bGFzdF9hY3Rpdml0eXxpOjEyNTcwODA1NDA7'),('f07254cb0ccaea9163c17da4794cd255',1257080754,'c2Vzc2lvbl9pZHxzOjMyOiJmMDcyNTRjYjBjY2FlYTkxNjNjMTdkYTQ3OTRjZDI1NSI7dG90YWxfaGl0c3xpOjI7X2tmX2ZsYXNoX3xhOjA6e311c2VyX2FnZW50fHM6MTIxOiJNb3ppbGxhLzUuMCAoTWFjaW50b3NoOyBVOyBJbnRlbCBNYWMgT1MgWCAxMF82XzE7IGVuLXVzKSBBcHBsZVdlYktpdC81MzEuOSAoS0hUTUwsIGxpa2UgR2Vja28pIFZlcnNpb24vNC4wLjMgU2FmYXJpLzUzMS45IjtpcF9hZGRyZXNzfHM6NzoiMC4wLjAuMCI7bGFzdF9hY3Rpdml0eXxpOjEyNTcwODA3NTQ7'),('bdd303d320f2b47818d48ff648e4a2a5',1257082012,'c2Vzc2lvbl9pZHxzOjMyOiJiZGQzMDNkMzIwZjJiNDc4MThkNDhmZjY0OGU0YTJhNSI7dG90YWxfaGl0c3xpOjU7X2tmX2ZsYXNoX3xhOjA6e311c2VyX2FnZW50fHM6MTIxOiJNb3ppbGxhLzUuMCAoTWFjaW50b3NoOyBVOyBJbnRlbCBNYWMgT1MgWCAxMF82XzE7IGVuLXVzKSBBcHBsZVdlYktpdC81MzEuOSAoS0hUTUwsIGxpa2UgR2Vja28pIFZlcnNpb24vNC4wLjMgU2FmYXJpLzUzMS45IjtpcF9hZGRyZXNzfHM6NzoiMC4wLjAuMCI7bGFzdF9hY3Rpdml0eXxpOjEyNTcwODIwMTI7'),('c167181f4c8a285cf8bd1444121c5d67',1257083710,'c2Vzc2lvbl9pZHxzOjMyOiJjMTY3MTgxZjRjOGEyODVjZjhiZDE0NDQxMjFjNWQ2NyI7dG90YWxfaGl0c3xpOjQ1O19rZl9mbGFzaF98YTowOnt9dXNlcl9hZ2VudHxzOjEyMToiTW96aWxsYS81LjAgKE1hY2ludG9zaDsgVTsgSW50ZWwgTWFjIE9TIFggMTBfNl8xOyBlbi11cykgQXBwbGVXZWJLaXQvNTMxLjkgKEtIVE1MLCBsaWtlIEdlY2tvKSBWZXJzaW9uLzQuMC4zIFNhZmFyaS81MzEuOSI7aXBfYWRkcmVzc3xzOjc6IjAuMC4wLjAiO2xhc3RfYWN0aXZpdHl8aToxMjU3MDgzNzA5Ow=='),('b79e13a4509872f1682b51384debe29b',1257085664,'c2Vzc2lvbl9pZHxzOjMyOiJiNzllMTNhNDUwOTg3MmYxNjgyYjUxMzg0ZGViZTI5YiI7dG90YWxfaGl0c3xpOjM5O19rZl9mbGFzaF98YTowOnt9dXNlcl9hZ2VudHxzOjEyMToiTW96aWxsYS81LjAgKE1hY2ludG9zaDsgVTsgSW50ZWwgTWFjIE9TIFggMTBfNl8xOyBlbi11cykgQXBwbGVXZWJLaXQvNTMxLjkgKEtIVE1MLCBsaWtlIEdlY2tvKSBWZXJzaW9uLzQuMC4zIFNhZmFyaS81MzEuOSI7aXBfYWRkcmVzc3xzOjc6IjAuMC4wLjAiO2xhc3RfYWN0aXZpdHl8aToxMjU3MDg1NjYwOw=='),('1aaa99846ed785c0a0fc9f65d3cde07d',1257086868,'c2Vzc2lvbl9pZHxzOjMyOiIxYWFhOTk4NDZlZDc4NWMwYTBmYzlmNjVkM2NkZTA3ZCI7dG90YWxfaGl0c3xpOjI3O19rZl9mbGFzaF98YTowOnt9dXNlcl9hZ2VudHxzOjEyMToiTW96aWxsYS81LjAgKE1hY2ludG9zaDsgVTsgSW50ZWwgTWFjIE9TIFggMTBfNl8xOyBlbi11cykgQXBwbGVXZWJLaXQvNTMxLjkgKEtIVE1MLCBsaWtlIEdlY2tvKSBWZXJzaW9uLzQuMC4zIFNhZmFyaS81MzEuOSI7aXBfYWRkcmVzc3xzOjc6IjAuMC4wLjAiO2xhc3RfYWN0aXZpdHl8aToxMjU3MDg2ODY3Ow=='),('572fe2935da05ec75072cf2b59eef709',1257086932,'c2Vzc2lvbl9pZHxzOjMyOiI1NzJmZTI5MzVkYTA1ZWM3NTA3MmNmMmI1OWVlZjcwOSI7dG90YWxfaGl0c3xpOjk7X2tmX2ZsYXNoX3xhOjA6e311c2VyX2FnZW50fHM6MTIxOiJNb3ppbGxhLzUuMCAoTWFjaW50b3NoOyBVOyBJbnRlbCBNYWMgT1MgWCAxMF82XzE7IGVuLXVzKSBBcHBsZVdlYktpdC81MzEuOSAoS0hUTUwsIGxpa2UgR2Vja28pIFZlcnNpb24vNC4wLjMgU2FmYXJpLzUzMS45IjtpcF9hZGRyZXNzfHM6NzoiMC4wLjAuMCI7bGFzdF9hY3Rpdml0eXxpOjEyNTcwODY5MzI7'),('1aea85c8be92156e82dad8c29df44fdc',1257087125,'c2Vzc2lvbl9pZHxzOjMyOiIxYWVhODVjOGJlOTIxNTZlODJkYWQ4YzI5ZGY0NGZkYyI7dG90YWxfaGl0c3xpOjY7X2tmX2ZsYXNoX3xhOjA6e311c2VyX2FnZW50fHM6MTIxOiJNb3ppbGxhLzUuMCAoTWFjaW50b3NoOyBVOyBJbnRlbCBNYWMgT1MgWCAxMF82XzE7IGVuLXVzKSBBcHBsZVdlYktpdC81MzEuOSAoS0hUTUwsIGxpa2UgR2Vja28pIFZlcnNpb24vNC4wLjMgU2FmYXJpLzUzMS45IjtpcF9hZGRyZXNzfHM6NzoiMC4wLjAuMCI7bGFzdF9hY3Rpdml0eXxpOjEyNTcwODcxMjU7'),('e61adb0c8370e9ee5eb4296dda838777',1257087308,'c2Vzc2lvbl9pZHxzOjMyOiJlNjFhZGIwYzgzNzBlOWVlNWViNDI5NmRkYTgzODc3NyI7dG90YWxfaGl0c3xpOjI7X2tmX2ZsYXNoX3xhOjA6e311c2VyX2FnZW50fHM6MTIxOiJNb3ppbGxhLzUuMCAoTWFjaW50b3NoOyBVOyBJbnRlbCBNYWMgT1MgWCAxMF82XzE7IGVuLXVzKSBBcHBsZVdlYktpdC81MzEuOSAoS0hUTUwsIGxpa2UgR2Vja28pIFZlcnNpb24vNC4wLjMgU2FmYXJpLzUzMS45IjtpcF9hZGRyZXNzfHM6NzoiMC4wLjAuMCI7bGFzdF9hY3Rpdml0eXxpOjEyNTcwODczMDg7'),('895990938e30f0727763747ae17830cd',1257093956,'c2Vzc2lvbl9pZHxzOjMyOiI4OTU5OTA5MzhlMzBmMDcyNzc2Mzc0N2FlMTc4MzBjZCI7dG90YWxfaGl0c3xpOjEyO19rZl9mbGFzaF98YTowOnt9dXNlcl9hZ2VudHxzOjEyMToiTW96aWxsYS81LjAgKE1hY2ludG9zaDsgVTsgSW50ZWwgTWFjIE9TIFggMTBfNl8xOyBlbi11cykgQXBwbGVXZWJLaXQvNTMxLjkgKEtIVE1MLCBsaWtlIEdlY2tvKSBWZXJzaW9uLzQuMC4zIFNhZmFyaS81MzEuOSI7aXBfYWRkcmVzc3xzOjc6IjAuMC4wLjAiO2xhc3RfYWN0aXZpdHl8aToxMjU3MDkzOTU1Ow=='),('2d67d49d778045e6f07a648d9ef6a4eb',1257094108,'c2Vzc2lvbl9pZHxzOjMyOiIyZDY3ZDQ5ZDc3ODA0NWU2ZjA3YTY0OGQ5ZWY2YTRlYiI7dG90YWxfaGl0c3xpOjM7X2tmX2ZsYXNoX3xhOjA6e311c2VyX2FnZW50fHM6MTIxOiJNb3ppbGxhLzUuMCAoTWFjaW50b3NoOyBVOyBJbnRlbCBNYWMgT1MgWCAxMF82XzE7IGVuLXVzKSBBcHBsZVdlYktpdC81MzEuOSAoS0hUTUwsIGxpa2UgR2Vja28pIFZlcnNpb24vNC4wLjMgU2FmYXJpLzUzMS45IjtpcF9hZGRyZXNzfHM6NzoiMC4wLjAuMCI7bGFzdF9hY3Rpdml0eXxpOjEyNTcwOTQxMDc7'),('5a569573c9f5c96b85227a2b58d556ad',1257094480,'c2Vzc2lvbl9pZHxzOjMyOiI1YTU2OTU3M2M5ZjVjOTZiODUyMjdhMmI1OGQ1NTZhZCI7dG90YWxfaGl0c3xpOjY7X2tmX2ZsYXNoX3xhOjA6e311c2VyX2FnZW50fHM6MTIxOiJNb3ppbGxhLzUuMCAoTWFjaW50b3NoOyBVOyBJbnRlbCBNYWMgT1MgWCAxMF82XzE7IGVuLXVzKSBBcHBsZVdlYktpdC81MzEuOSAoS0hUTUwsIGxpa2UgR2Vja28pIFZlcnNpb24vNC4wLjMgU2FmYXJpLzUzMS45IjtpcF9hZGRyZXNzfHM6NzoiMC4wLjAuMCI7bGFzdF9hY3Rpdml0eXxpOjEyNTcwOTQ0Nzk7'),('3ae2f91c0ca3f7e8a5cd44848af8ca5c',1257094637,'c2Vzc2lvbl9pZHxzOjMyOiIzYWUyZjkxYzBjYTNmN2U4YTVjZDQ0ODQ4YWY4Y2E1YyI7dG90YWxfaGl0c3xpOjY7X2tmX2ZsYXNoX3xhOjA6e311c2VyX2FnZW50fHM6MTIxOiJNb3ppbGxhLzUuMCAoTWFjaW50b3NoOyBVOyBJbnRlbCBNYWMgT1MgWCAxMF82XzE7IGVuLXVzKSBBcHBsZVdlYktpdC81MzEuOSAoS0hUTUwsIGxpa2UgR2Vja28pIFZlcnNpb24vNC4wLjMgU2FmYXJpLzUzMS45IjtpcF9hZGRyZXNzfHM6NzoiMC4wLjAuMCI7bGFzdF9hY3Rpdml0eXxpOjEyNTcwOTQ2MzY7'),('36b8280b280c2200a1a85bef7b28eb65',1257095850,'c2Vzc2lvbl9pZHxzOjMyOiIzNmI4MjgwYjI4MGMyMjAwYTFhODViZWY3YjI4ZWI2NSI7dG90YWxfaGl0c3xpOjk7X2tmX2ZsYXNoX3xhOjA6e311c2VyX2FnZW50fHM6MTIxOiJNb3ppbGxhLzUuMCAoTWFjaW50b3NoOyBVOyBJbnRlbCBNYWMgT1MgWCAxMF82XzE7IGVuLXVzKSBBcHBsZVdlYktpdC81MzEuOSAoS0hUTUwsIGxpa2UgR2Vja28pIFZlcnNpb24vNC4wLjMgU2FmYXJpLzUzMS45IjtpcF9hZGRyZXNzfHM6NzoiMC4wLjAuMCI7bGFzdF9hY3Rpdml0eXxpOjEyNTcwOTU4NDk7'),('1a3b1d8cb327e8c919d4e8dc9e83d473',1257096261,'c2Vzc2lvbl9pZHxzOjMyOiIxYTNiMWQ4Y2IzMjdlOGM5MTlkNGU4ZGM5ZTgzZDQ3MyI7dG90YWxfaGl0c3xpOjU7X2tmX2ZsYXNoX3xhOjA6e311c2VyX2FnZW50fHM6MTIxOiJNb3ppbGxhLzUuMCAoTWFjaW50b3NoOyBVOyBJbnRlbCBNYWMgT1MgWCAxMF82XzE7IGVuLXVzKSBBcHBsZVdlYktpdC81MzEuOSAoS0hUTUwsIGxpa2UgR2Vja28pIFZlcnNpb24vNC4wLjMgU2FmYXJpLzUzMS45IjtpcF9hZGRyZXNzfHM6NzoiMC4wLjAuMCI7bGFzdF9hY3Rpdml0eXxpOjEyNTcwOTYyNjE7'),('7e507f84967983ef87218c7e7b250fc4',1257096703,'c2Vzc2lvbl9pZHxzOjMyOiI3ZTUwN2Y4NDk2Nzk4M2VmODcyMThjN2U3YjI1MGZjNCI7dG90YWxfaGl0c3xpOjY7X2tmX2ZsYXNoX3xhOjA6e311c2VyX2FnZW50fHM6MTIxOiJNb3ppbGxhLzUuMCAoTWFjaW50b3NoOyBVOyBJbnRlbCBNYWMgT1MgWCAxMF82XzE7IGVuLXVzKSBBcHBsZVdlYktpdC81MzEuOSAoS0hUTUwsIGxpa2UgR2Vja28pIFZlcnNpb24vNC4wLjMgU2FmYXJpLzUzMS45IjtpcF9hZGRyZXNzfHM6NzoiMC4wLjAuMCI7bGFzdF9hY3Rpdml0eXxpOjEyNTcwOTY3MDI7'),('52f2effa83df1f3ae3f13d5fa2a17a9b',1257096838,'c2Vzc2lvbl9pZHxzOjMyOiI1MmYyZWZmYTgzZGYxZjNhZTNmMTNkNWZhMmExN2E5YiI7dG90YWxfaGl0c3xpOjk7X2tmX2ZsYXNoX3xhOjA6e311c2VyX2FnZW50fHM6MTIxOiJNb3ppbGxhLzUuMCAoTWFjaW50b3NoOyBVOyBJbnRlbCBNYWMgT1MgWCAxMF82XzE7IGVuLXVzKSBBcHBsZVdlYktpdC81MzEuOSAoS0hUTUwsIGxpa2UgR2Vja28pIFZlcnNpb24vNC4wLjMgU2FmYXJpLzUzMS45IjtpcF9hZGRyZXNzfHM6NzoiMC4wLjAuMCI7bGFzdF9hY3Rpdml0eXxpOjEyNTcwOTY4Mzg7'),('9b3db18521ec73f64344460e6c47fe38',1257096905,'c2Vzc2lvbl9pZHxzOjMyOiI5YjNkYjE4NTIxZWM3M2Y2NDM0NDQ2MGU2YzQ3ZmUzOCI7dG90YWxfaGl0c3xpOjU7X2tmX2ZsYXNoX3xhOjA6e311c2VyX2FnZW50fHM6MTIxOiJNb3ppbGxhLzUuMCAoTWFjaW50b3NoOyBVOyBJbnRlbCBNYWMgT1MgWCAxMF82XzE7IGVuLXVzKSBBcHBsZVdlYktpdC81MzEuOSAoS0hUTUwsIGxpa2UgR2Vja28pIFZlcnNpb24vNC4wLjMgU2FmYXJpLzUzMS45IjtpcF9hZGRyZXNzfHM6NzoiMC4wLjAuMCI7bGFzdF9hY3Rpdml0eXxpOjEyNTcwOTY5MDU7'),('996c98826eba1d11b5f264431774be2b',1257097104,'c2Vzc2lvbl9pZHxzOjMyOiI5OTZjOTg4MjZlYmExZDExYjVmMjY0NDMxNzc0YmUyYiI7dG90YWxfaGl0c3xpOjI7X2tmX2ZsYXNoX3xhOjA6e311c2VyX2FnZW50fHM6MTIxOiJNb3ppbGxhLzUuMCAoTWFjaW50b3NoOyBVOyBJbnRlbCBNYWMgT1MgWCAxMF82XzE7IGVuLXVzKSBBcHBsZVdlYktpdC81MzEuOSAoS0hUTUwsIGxpa2UgR2Vja28pIFZlcnNpb24vNC4wLjMgU2FmYXJpLzUzMS45IjtpcF9hZGRyZXNzfHM6NzoiMC4wLjAuMCI7bGFzdF9hY3Rpdml0eXxpOjEyNTcwOTcwNTM7'),('1bd7d8892acb150bbdea6c5fb99fe516',1257098982,'c2Vzc2lvbl9pZHxzOjMyOiIxYmQ3ZDg4OTJhY2IxNTBiYmRlYTZjNWZiOTlmZTUxNiI7dG90YWxfaGl0c3xpOjYzO19rZl9mbGFzaF98YTowOnt9dXNlcl9hZ2VudHxzOjEyMToiTW96aWxsYS81LjAgKE1hY2ludG9zaDsgVTsgSW50ZWwgTWFjIE9TIFggMTBfNl8xOyBlbi11cykgQXBwbGVXZWJLaXQvNTMxLjkgKEtIVE1MLCBsaWtlIEdlY2tvKSBWZXJzaW9uLzQuMC4zIFNhZmFyaS81MzEuOSI7aXBfYWRkcmVzc3xzOjc6IjAuMC4wLjAiO2xhc3RfYWN0aXZpdHl8aToxMjU3MDk4OTgxOw=='),('548fb3ba18b6a22f6745de19b06e1032',1257099010,'c2Vzc2lvbl9pZHxzOjMyOiI1NDhmYjNiYTE4YjZhMjJmNjc0NWRlMTliMDZlMTAzMiI7dG90YWxfaGl0c3xpOjQ7X2tmX2ZsYXNoX3xhOjA6e311c2VyX2FnZW50fHM6MTIxOiJNb3ppbGxhLzUuMCAoTWFjaW50b3NoOyBVOyBJbnRlbCBNYWMgT1MgWCAxMF82XzE7IGVuLXVzKSBBcHBsZVdlYktpdC81MzEuOSAoS0hUTUwsIGxpa2UgR2Vja28pIFZlcnNpb24vNC4wLjMgU2FmYXJpLzUzMS45IjtpcF9hZGRyZXNzfHM6NzoiMC4wLjAuMCI7bGFzdF9hY3Rpdml0eXxpOjEyNTcwOTkwMDk7'),('e281163eb5ad211f3f6d4ad556dc26e8',1257100813,'c2Vzc2lvbl9pZHxzOjMyOiJlMjgxMTYzZWI1YWQyMTFmM2Y2ZDRhZDU1NmRjMjZlOCI7dG90YWxfaGl0c3xpOjQ4O19rZl9mbGFzaF98YTowOnt9dXNlcl9hZ2VudHxzOjEyMToiTW96aWxsYS81LjAgKE1hY2ludG9zaDsgVTsgSW50ZWwgTWFjIE9TIFggMTBfNl8xOyBlbi11cykgQXBwbGVXZWJLaXQvNTMxLjkgKEtIVE1MLCBsaWtlIEdlY2tvKSBWZXJzaW9uLzQuMC4zIFNhZmFyaS81MzEuOSI7aXBfYWRkcmVzc3xzOjc6IjAuMC4wLjAiO2xhc3RfYWN0aXZpdHl8aToxMjU3MTAwODEzOw=='),('52211b2292619ce35bd958f142787650',1257100849,'c2Vzc2lvbl9pZHxzOjMyOiI1MjIxMWIyMjkyNjE5Y2UzNWJkOTU4ZjE0Mjc4NzY1MCI7dG90YWxfaGl0c3xpOjY7X2tmX2ZsYXNoX3xhOjA6e311c2VyX2FnZW50fHM6MTIxOiJNb3ppbGxhLzUuMCAoTWFjaW50b3NoOyBVOyBJbnRlbCBNYWMgT1MgWCAxMF82XzE7IGVuLXVzKSBBcHBsZVdlYktpdC81MzEuOSAoS0hUTUwsIGxpa2UgR2Vja28pIFZlcnNpb24vNC4wLjMgU2FmYXJpLzUzMS45IjtpcF9hZGRyZXNzfHM6NzoiMC4wLjAuMCI7bGFzdF9hY3Rpdml0eXxpOjEyNTcxMDA4NDg7'),('e4599e1cc5cf172df63f854f6c992672',1257101075,'c2Vzc2lvbl9pZHxzOjMyOiJlNDU5OWUxY2M1Y2YxNzJkZjYzZjg1NGY2Yzk5MjY3MiI7dG90YWxfaGl0c3xpOjk7X2tmX2ZsYXNoX3xhOjA6e311c2VyX2FnZW50fHM6MTIxOiJNb3ppbGxhLzUuMCAoTWFjaW50b3NoOyBVOyBJbnRlbCBNYWMgT1MgWCAxMF82XzE7IGVuLXVzKSBBcHBsZVdlYktpdC81MzEuOSAoS0hUTUwsIGxpa2UgR2Vja28pIFZlcnNpb24vNC4wLjMgU2FmYXJpLzUzMS45IjtpcF9hZGRyZXNzfHM6NzoiMC4wLjAuMCI7bGFzdF9hY3Rpdml0eXxpOjEyNTcxMDEwNzM7'),('407ca7c5610aa6b5f9d50768703fa2a3',1257101280,'c2Vzc2lvbl9pZHxzOjMyOiI0MDdjYTdjNTYxMGFhNmI1ZjlkNTA3Njg3MDNmYTJhMyI7dG90YWxfaGl0c3xpOjEyO19rZl9mbGFzaF98YTowOnt9dXNlcl9hZ2VudHxzOjEyMToiTW96aWxsYS81LjAgKE1hY2ludG9zaDsgVTsgSW50ZWwgTWFjIE9TIFggMTBfNl8xOyBlbi11cykgQXBwbGVXZWJLaXQvNTMxLjkgKEtIVE1MLCBsaWtlIEdlY2tvKSBWZXJzaW9uLzQuMC4zIFNhZmFyaS81MzEuOSI7aXBfYWRkcmVzc3xzOjc6IjAuMC4wLjAiO2xhc3RfYWN0aXZpdHl8aToxMjU3MTAxMjc5Ow=='),('8c4cbd7f26ab6189b28d2ec51c82b0fe',1257101464,'c2Vzc2lvbl9pZHxzOjMyOiI4YzRjYmQ3ZjI2YWI2MTg5YjI4ZDJlYzUxYzgyYjBmZSI7dG90YWxfaGl0c3xpOjY7X2tmX2ZsYXNoX3xhOjA6e311c2VyX2FnZW50fHM6MTIxOiJNb3ppbGxhLzUuMCAoTWFjaW50b3NoOyBVOyBJbnRlbCBNYWMgT1MgWCAxMF82XzE7IGVuLXVzKSBBcHBsZVdlYktpdC81MzEuOSAoS0hUTUwsIGxpa2UgR2Vja28pIFZlcnNpb24vNC4wLjMgU2FmYXJpLzUzMS45IjtpcF9hZGRyZXNzfHM6NzoiMC4wLjAuMCI7bGFzdF9hY3Rpdml0eXxpOjEyNTcxMDE0NjQ7'),('42ebcd0fecd6ea4fe004df6b5f3e5993',1257101653,'c2Vzc2lvbl9pZHxzOjMyOiI0MmViY2QwZmVjZDZlYTRmZTAwNGRmNmI1ZjNlNTk5MyI7dG90YWxfaGl0c3xpOjEyO19rZl9mbGFzaF98YTowOnt9dXNlcl9hZ2VudHxzOjEyMToiTW96aWxsYS81LjAgKE1hY2ludG9zaDsgVTsgSW50ZWwgTWFjIE9TIFggMTBfNl8xOyBlbi11cykgQXBwbGVXZWJLaXQvNTMxLjkgKEtIVE1MLCBsaWtlIEdlY2tvKSBWZXJzaW9uLzQuMC4zIFNhZmFyaS81MzEuOSI7aXBfYWRkcmVzc3xzOjc6IjAuMC4wLjAiO2xhc3RfYWN0aXZpdHl8aToxMjU3MTAxNjUyOw=='),('661f3e391a8fc7f5111b34fe2f8dff5c',1257102448,'c2Vzc2lvbl9pZHxzOjMyOiI2NjFmM2UzOTFhOGZjN2Y1MTExYjM0ZmUyZjhkZmY1YyI7dG90YWxfaGl0c3xpOjU0O19rZl9mbGFzaF98YTowOnt9dXNlcl9hZ2VudHxzOjEyMToiTW96aWxsYS81LjAgKE1hY2ludG9zaDsgVTsgSW50ZWwgTWFjIE9TIFggMTBfNl8xOyBlbi11cykgQXBwbGVXZWJLaXQvNTMxLjkgKEtIVE1MLCBsaWtlIEdlY2tvKSBWZXJzaW9uLzQuMC4zIFNhZmFyaS81MzEuOSI7aXBfYWRkcmVzc3xzOjc6IjAuMC4wLjAiO2xhc3RfYWN0aXZpdHl8aToxMjU3MTAyNDQ4Ow=='),('bb23010a3c54ad7d7dbff49d36d885b8',1257102979,'c2Vzc2lvbl9pZHxzOjMyOiJiYjIzMDEwYTNjNTRhZDdkN2RiZmY0OWQzNmQ4ODViOCI7dG90YWxfaGl0c3xpOjE0O19rZl9mbGFzaF98YTowOnt9dXNlcl9hZ2VudHxzOjEyMToiTW96aWxsYS81LjAgKE1hY2ludG9zaDsgVTsgSW50ZWwgTWFjIE9TIFggMTBfNl8xOyBlbi11cykgQXBwbGVXZWJLaXQvNTMxLjkgKEtIVE1MLCBsaWtlIEdlY2tvKSBWZXJzaW9uLzQuMC4zIFNhZmFyaS81MzEuOSI7aXBfYWRkcmVzc3xzOjc6IjAuMC4wLjAiO2xhc3RfYWN0aXZpdHl8aToxMjU3MTAyOTc4Ow=='),('70ab2d7845ff8a4571b28ef0ef65dbc4',1257103411,'c2Vzc2lvbl9pZHxzOjMyOiI3MGFiMmQ3ODQ1ZmY4YTQ1NzFiMjhlZjBlZjY1ZGJjNCI7dG90YWxfaGl0c3xpOjk7X2tmX2ZsYXNoX3xhOjA6e311c2VyX2FnZW50fHM6MTIxOiJNb3ppbGxhLzUuMCAoTWFjaW50b3NoOyBVOyBJbnRlbCBNYWMgT1MgWCAxMF82XzE7IGVuLXVzKSBBcHBsZVdlYktpdC81MzEuOSAoS0hUTUwsIGxpa2UgR2Vja28pIFZlcnNpb24vNC4wLjMgU2FmYXJpLzUzMS45IjtpcF9hZGRyZXNzfHM6NzoiMC4wLjAuMCI7bGFzdF9hY3Rpdml0eXxpOjEyNTcxMDM0MTA7'),('4b5d3dca4748dec6722bbc82e76fc5e4',1257104331,'c2Vzc2lvbl9pZHxzOjMyOiI0YjVkM2RjYTQ3NDhkZWM2NzIyYmJjODJlNzZmYzVlNCI7dG90YWxfaGl0c3xpOjMzO19rZl9mbGFzaF98YTowOnt9dXNlcl9hZ2VudHxzOjEyMToiTW96aWxsYS81LjAgKE1hY2ludG9zaDsgVTsgSW50ZWwgTWFjIE9TIFggMTBfNl8xOyBlbi11cykgQXBwbGVXZWJLaXQvNTMxLjkgKEtIVE1MLCBsaWtlIEdlY2tvKSBWZXJzaW9uLzQuMC4zIFNhZmFyaS81MzEuOSI7aXBfYWRkcmVzc3xzOjc6IjAuMC4wLjAiO2xhc3RfYWN0aXZpdHl8aToxMjU3MTA0MzMxOw=='),('7f8924b5004baa9cc2d74e47d57c478c',1257104547,'c2Vzc2lvbl9pZHxzOjMyOiI3Zjg5MjRiNTAwNGJhYTljYzJkNzRlNDdkNTdjNDc4YyI7dG90YWxfaGl0c3xpOjk7X2tmX2ZsYXNoX3xhOjA6e311c2VyX2FnZW50fHM6MTIxOiJNb3ppbGxhLzUuMCAoTWFjaW50b3NoOyBVOyBJbnRlbCBNYWMgT1MgWCAxMF82XzE7IGVuLXVzKSBBcHBsZVdlYktpdC81MzEuOSAoS0hUTUwsIGxpa2UgR2Vja28pIFZlcnNpb24vNC4wLjMgU2FmYXJpLzUzMS45IjtpcF9hZGRyZXNzfHM6NzoiMC4wLjAuMCI7bGFzdF9hY3Rpdml0eXxpOjEyNTcxMDQ1NDc7'),('f74e852373bec5268dc47e0164756fe9',1257105665,'c2Vzc2lvbl9pZHxzOjMyOiJmNzRlODUyMzczYmVjNTI2OGRjNDdlMDE2NDc1NmZlOSI7dG90YWxfaGl0c3xpOjI2O19rZl9mbGFzaF98YTowOnt9dXNlcl9hZ2VudHxzOjEyMToiTW96aWxsYS81LjAgKE1hY2ludG9zaDsgVTsgSW50ZWwgTWFjIE9TIFggMTBfNl8xOyBlbi11cykgQXBwbGVXZWJLaXQvNTMxLjkgKEtIVE1MLCBsaWtlIEdlY2tvKSBWZXJzaW9uLzQuMC4zIFNhZmFyaS81MzEuOSI7aXBfYWRkcmVzc3xzOjc6IjAuMC4wLjAiO2xhc3RfYWN0aXZpdHl8aToxMjU3MTA1NjY1Ow=='),('c97ebbeaafba7ee4f7de0179323c6f6a',1257104996,'c2Vzc2lvbl9pZHxzOjMyOiJjOTdlYmJlYWFmYmE3ZWU0ZjdkZTAxNzkzMjNjNmY2YSI7dG90YWxfaGl0c3xpOjg7X2tmX2ZsYXNoX3xhOjA6e311c2VyX2FnZW50fHM6MTg6IkFwcGxlLVB1YlN1Yi82NS4xMSI7aXBfYWRkcmVzc3xzOjc6IjAuMC4wLjAiO2xhc3RfYWN0aXZpdHl8aToxMjU3MTA0OTk2Ow=='),('c33deda89ba8ca635a17b0a81d204db3',1257105236,'c2Vzc2lvbl9pZHxzOjMyOiJjMzNkZWRhODliYThjYTYzNWExN2IwYTgxZDIwNGRiMyI7dG90YWxfaGl0c3xpOjE7X2tmX2ZsYXNoX3xhOjA6e311c2VyX2FnZW50fHM6MTg6IkFwcGxlLVB1YlN1Yi82NS4xMSI7aXBfYWRkcmVzc3xzOjc6IjAuMC4wLjAiO2xhc3RfYWN0aXZpdHl8aToxMjU3MTA1MjM2Ow==');
/*!40000 ALTER TABLE `zest_sessions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `zest_settings`
--

DROP TABLE IF EXISTS `zest_settings`;
CREATE TABLE `zest_settings` (
  `id` int(11) NOT NULL auto_increment,
  `variable` varchar(32) default NULL,
  `value` text,
  PRIMARY KEY  (`id`),
  KEY `variable` (`variable`)
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `zest_settings`
--

LOCK TABLES `zest_settings` WRITE;
/*!40000 ALTER TABLE `zest_settings` DISABLE KEYS */;
INSERT INTO `zest_settings` VALUES (1,'PAYPAL_ID','syd@sydlawrence.com'),(2,'COMPANY_NAME','Zest CMS'),(3,'ANALYTICS_CODE','/* THIS IS JUST AN EXAMPLE  var gaJsHost = ((\"https:\" == document.location.protocol) ? \"https://ssl.\" : \"http://www.\");  document.write(unescape(\"%3Cscript src=\'\" + gaJsHost + \"google-analytics.com/ga.js\' type=\'text/javascript\'%3E%3Cscript%3E\"));    var pageTracker = _gat._getTracker(\"UA-XXXXX-X\");   pdqwdqwdqwdqdageTracker._initData();   pageTracker._trackPageview();  END OF EXAMPLE */'),(4,'UNDER_DEVELOPMENT',''),(5,'EXTRA_HEAD',''),(6,NULL,'marm_on_toast'),(7,NULL,'marmite'),(8,'bitly_login','marmalade'),(9,'bitly_api','R_ae99fbd581304c31e79f77989f524b67'),(10,NULL,'marm_on_toast'),(11,NULL,'marmite'),(12,'twitter_username','marm_on_toast'),(13,'twitter_password','marmite');
/*!40000 ALTER TABLE `zest_settings` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `zest_stat_summaries`
--

DROP TABLE IF EXISTS `zest_stat_summaries`;
CREATE TABLE `zest_stat_summaries` (
  `id` int(11) NOT NULL auto_increment,
  `object_type` varchar(32) default NULL,
  `object_id` int(11) default NULL,
  `views` int(11) default NULL,
  PRIMARY KEY  (`id`),
  KEY `object_type` (`object_type`),
  KEY `object_id` (`object_id`)
) ENGINE=MyISAM AUTO_INCREMENT=88 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `zest_stat_summaries`
--

LOCK TABLES `zest_stat_summaries` WRITE;
/*!40000 ALTER TABLE `zest_stat_summaries` DISABLE KEYS */;
INSERT INTO `zest_stat_summaries` VALUES (1,'page',23,61498),(2,'case_study',106,824),(3,'page',1,34118),(4,'page',19,2098),(5,'page',2,7681),(6,'page',18,1642),(7,'case_study',121,586),(8,'case_study',118,519),(9,'case_study',108,373),(10,'case_study',113,1865),(38,'case_study',115,616),(37,'case_study',112,454),(36,'case_study',109,82),(35,'case_study',116,713),(34,'case_study',125,786),(33,'case_study',120,626),(32,'case_study',122,829),(31,'page',21,2106),(30,'feedpost',41,10),(29,'feedpost',46,1117),(28,'case_study',119,374),(27,'page',20,2158),(26,'case_study',127,13),(39,'case_study',107,409),(40,'feedpost',48,1008),(41,'feedpost',47,763),(42,'page',27,20234),(43,'page',25,947),(44,'page',30,1),(45,'page',28,26),(46,'page',29,31),(47,'feedpost',49,787),(48,'feedpost',50,879),(49,'feedpost',42,583),(50,'case_study',128,16),(51,'case_study',111,511),(52,'case_study',110,507),(53,'page',31,2310),(54,'case_study',129,988),(55,'feedpost',51,844),(56,'feedpost',52,8),(57,'case_study',240,29),(58,'feedpost',55,1322),(59,'feedpost',56,788),(60,'feedpost',57,1303),(61,'page',32,75),(62,'page',26,3),(63,'feedpost',58,1243),(64,'feedpost',59,946),(65,'feedpost',61,1416),(66,'feedpost',62,569),(67,'feedpost',63,815),(68,'case_study',241,637),(69,'case_study',244,445),(70,'feedpost',64,438),(71,'case_study',251,62),(72,'case_study',248,80),(73,'case_study',252,74),(74,'page',34,29),(75,'case_study',249,52),(76,'feedpost',65,244),(77,'feedpost',66,124),(78,'case_study',243,12),(79,'case_study',247,5),(80,'case_study',242,9),(81,'case_study',245,6),(82,'case_study',250,3),(83,'case_study',246,4),(84,'page',37,3),(85,'page',43,8),(86,'page',44,43),(87,'page',36,1);
/*!40000 ALTER TABLE `zest_stat_summaries` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `zest_statistics`
--

DROP TABLE IF EXISTS `zest_statistics`;
CREATE TABLE `zest_statistics` (
  `id` int(11) NOT NULL auto_increment,
  `when_log` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `ip` text,
  `item_type` text,
  `item_id` int(11) default NULL,
  `referrer` text,
  `user_agent` text,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=166381 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `zest_statistics`
--

LOCK TABLES `zest_statistics` WRITE;
/*!40000 ALTER TABLE `zest_statistics` DISABLE KEYS */;
INSERT INTO `zest_statistics` VALUES (166376,'2009-11-19 20:12:37','0.0.0.0','page',1,'','Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10_6_2; en-us) AppleWebKit/531.21.8 (KHTML, like Gecko) Version/4.0.4 Safari/531.21.10'),(166377,'2009-11-19 20:13:28','0.0.0.0','page',1,'','Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10_6_2; en-us) AppleWebKit/531.21.8 (KHTML, like Gecko) Version/4.0.4 Safari/531.21.10'),(166378,'2009-11-19 20:14:01','0.0.0.0','page',1,'','Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10_6_2; en-us) AppleWebKit/531.21.8 (KHTML, like Gecko) Version/4.0.4 Safari/531.21.10'),(166379,'2009-11-19 20:14:08','0.0.0.0','page',1,'','Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10_6_2; en-us) AppleWebKit/531.21.8 (KHTML, like Gecko) Version/4.0.4 Safari/531.21.10'),(166380,'2009-11-19 20:14:11','0.0.0.0','page',1,'','Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10_6_2; en-us) AppleWebKit/531.21.8 (KHTML, like Gecko) Version/4.0.4 Safari/531.21.10');
/*!40000 ALTER TABLE `zest_statistics` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `zest_statuses`
--

DROP TABLE IF EXISTS `zest_statuses`;
CREATE TABLE `zest_statuses` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(32) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `zest_statuses`
--

LOCK TABLES `zest_statuses` WRITE;
/*!40000 ALTER TABLE `zest_statuses` DISABLE KEYS */;
INSERT INTO `zest_statuses` VALUES (1,'Unpublished'),(2,'Published');
/*!40000 ALTER TABLE `zest_statuses` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `zest_tags`
--

DROP TABLE IF EXISTS `zest_tags`;
CREATE TABLE `zest_tags` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(32) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=20 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `zest_tags`
--

LOCK TABLES `zest_tags` WRITE;
/*!40000 ALTER TABLE `zest_tags` DISABLE KEYS */;
/*!40000 ALTER TABLE `zest_tags` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `zest_templates`
--

DROP TABLE IF EXISTS `zest_templates`;
CREATE TABLE `zest_templates` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(32) default NULL,
  `url` varchar(32) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `zest_templates`
--

LOCK TABLES `zest_templates` WRITE;
/*!40000 ALTER TABLE `zest_templates` DISABLE KEYS */;
INSERT INTO `zest_templates` VALUES (1,'Main','main');
/*!40000 ALTER TABLE `zest_templates` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `zest_user_discounts`
--

DROP TABLE IF EXISTS `zest_user_discounts`;
CREATE TABLE `zest_user_discounts` (
  `id` int(11) NOT NULL auto_increment,
  `user_id` int(11) NOT NULL default '0',
  `product_category_id` int(11) NOT NULL default '0',
  `value` varchar(8) default NULL,
  PRIMARY KEY  (`id`),
  KEY `product_category_id` (`product_category_id`),
  CONSTRAINT `zest_user_discounts_ibfk_1` FOREIGN KEY (`product_category_id`) REFERENCES `zest_product_categories` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `zest_user_discounts`
--

LOCK TABLES `zest_user_discounts` WRITE;
/*!40000 ALTER TABLE `zest_user_discounts` DISABLE KEYS */;
/*!40000 ALTER TABLE `zest_user_discounts` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `zest_user_tokens`
--

DROP TABLE IF EXISTS `zest_user_tokens`;
CREATE TABLE `zest_user_tokens` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `user_id` int(11) unsigned NOT NULL,
  `user_agent` varchar(40) NOT NULL,
  `token` varchar(32) NOT NULL,
  `created` int(10) unsigned NOT NULL,
  `expires` int(10) unsigned NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `uniq_token` (`token`),
  KEY `fk_user_id` (`user_id`),
  CONSTRAINT `zest_user_tokens_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `zest_users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `zest_user_tokens`
--

LOCK TABLES `zest_user_tokens` WRITE;
/*!40000 ALTER TABLE `zest_user_tokens` DISABLE KEYS */;
/*!40000 ALTER TABLE `zest_user_tokens` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `zest_users`
--

DROP TABLE IF EXISTS `zest_users`;
CREATE TABLE `zest_users` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `email` varchar(127) NOT NULL,
  `username` varchar(32) NOT NULL default '',
  `password` char(50) NOT NULL,
  `logins` int(10) unsigned NOT NULL default '0',
  `last_login` int(10) unsigned default NULL,
  `openid` varchar(127) default NULL,
  `basecamp_username` text,
  `basecamp_password` text,
  `basecamp_user_id` int(11) default NULL,
  `first_name` text,
  `last_name` text,
  `login_attempts` int(11) default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `uniq_username` (`username`),
  UNIQUE KEY `uniq_email` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `zest_users`
--

LOCK TABLES `zest_users` WRITE;
/*!40000 ALTER TABLE `zest_users` DISABLE KEYS */;
INSERT INTO `zest_users` VALUES (1,'syd.lawrence@marmaladeontoast.co.uk','marmalade','8242c47ff12698f1bbbf07bd880cf838e24594b495226fb8f0',69,1258661516,'http://marmaladeontoast.myopenid.com','','',0,'Syd','Lawrence',0);
/*!40000 ALTER TABLE `zest_users` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `zest_vat_rates`
--

DROP TABLE IF EXISTS `zest_vat_rates`;
CREATE TABLE `zest_vat_rates` (
  `id` int(11) NOT NULL auto_increment,
  `code` varchar(32) default NULL,
  `value` varchar(32) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `zest_vat_rates`
--

LOCK TABLES `zest_vat_rates` WRITE;
/*!40000 ALTER TABLE `zest_vat_rates` DISABLE KEYS */;
/*!40000 ALTER TABLE `zest_vat_rates` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `zest_zones`
--

DROP TABLE IF EXISTS `zest_zones`;
CREATE TABLE `zest_zones` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `title` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `zest_zones`
--

LOCK TABLES `zest_zones` WRITE;
/*!40000 ALTER TABLE `zest_zones` DISABLE KEYS */;
/*!40000 ALTER TABLE `zest_zones` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2009-11-19 20:15:03