--
-- Host: localhost    Database: Package_11005_empty_domain_pt
-- ------------------------------------------------------


--
-- Table structure for table `AccountProfileContact`
--

CREATE TABLE `AccountProfileContact` (
  `account_id` int(11) NOT NULL,
  `username` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `first_name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `last_name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `nickname` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `friendly_url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `image_id` int(11) NOT NULL,
  `facebook_image` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `facebook_image_height` int(11) NOT NULL,
  `facebook_image_width` int(11) NOT NULL,
  `has_profile` varchar(1) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`account_id`),
  KEY `image_id` (`image_id`,`has_profile`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `AccountProfileContact`
--


--
-- Table structure for table `AppAdvert`
--

CREATE TABLE `AppAdvert` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(25) COLLATE utf8_unicode_ci NOT NULL,
  `image_id` int(11) NOT NULL,
  `url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `device` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
  `expiration_date` date NOT NULL,
  `status` char(1) COLLATE utf8_unicode_ci NOT NULL,
  `entered` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `AppAdvert`
--


--
-- Table structure for table `AppCustomPages`
--

CREATE TABLE `AppCustomPages` (
  `id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `icon` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `json` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `AppCustomPages`
--


--
-- Table structure for table `AppNotification`
--

CREATE TABLE `AppNotification` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(25) COLLATE utf8_unicode_ci NOT NULL,
  `description` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `expiration_date` date NOT NULL,
  `status` char(1) COLLATE utf8_unicode_ci NOT NULL,
  `entered` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `AppNotification`
--


--
-- Table structure for table `Article`
--

CREATE TABLE `Article` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `account_id` int(11) NOT NULL DEFAULT '0',
  `image_id` int(11) NOT NULL DEFAULT '0',
  `thumb_id` int(11) NOT NULL DEFAULT '0',
  `cover_id` int(11) NOT NULL DEFAULT '0',
  `updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `entered` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `renewal_date` date NOT NULL DEFAULT '0000-00-00',
  `discount_id` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `seo_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `friendly_url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `author` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `author_url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `publication_date` date NOT NULL DEFAULT '0000-00-00',
  `abstract` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `seo_abstract` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `keywords` text COLLATE utf8_unicode_ci NOT NULL,
  `seo_keywords` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `fulltextsearch_keyword` text COLLATE utf8_unicode_ci NOT NULL,
  `fulltextsearch_where` text COLLATE utf8_unicode_ci NOT NULL,
  `content` text COLLATE utf8_unicode_ci NOT NULL,
  `status` char(1) COLLATE utf8_unicode_ci NOT NULL,
  `suspended_sitemgr` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'n',
  `level` tinyint(3) NOT NULL DEFAULT '0',
  `number_views` int(11) NOT NULL DEFAULT '0',
  `avg_review` int(11) NOT NULL DEFAULT '0',
  `random_number` bigint(15) NOT NULL DEFAULT '0',
  `cat_1_id` int(11) NOT NULL DEFAULT '0',
  `parcat_1_level1_id` int(11) NOT NULL DEFAULT '0',
  `parcat_1_level2_id` int(11) NOT NULL DEFAULT '0',
  `parcat_1_level3_id` int(11) NOT NULL DEFAULT '0',
  `parcat_1_level4_id` int(11) NOT NULL DEFAULT '0',
  `cat_2_id` int(11) NOT NULL DEFAULT '0',
  `parcat_2_level1_id` int(11) NOT NULL DEFAULT '0',
  `parcat_2_level2_id` int(11) NOT NULL DEFAULT '0',
  `parcat_2_level3_id` int(11) NOT NULL DEFAULT '0',
  `parcat_2_level4_id` int(11) NOT NULL DEFAULT '0',
  `cat_3_id` int(11) NOT NULL DEFAULT '0',
  `parcat_3_level1_id` int(11) NOT NULL DEFAULT '0',
  `parcat_3_level2_id` int(11) NOT NULL DEFAULT '0',
  `parcat_3_level3_id` int(11) NOT NULL DEFAULT '0',
  `parcat_3_level4_id` int(11) NOT NULL DEFAULT '0',
  `cat_4_id` int(11) NOT NULL DEFAULT '0',
  `parcat_4_level1_id` int(11) NOT NULL DEFAULT '0',
  `parcat_4_level2_id` int(11) NOT NULL DEFAULT '0',
  `parcat_4_level3_id` int(11) NOT NULL DEFAULT '0',
  `parcat_4_level4_id` int(11) NOT NULL DEFAULT '0',
  `cat_5_id` int(11) NOT NULL DEFAULT '0',
  `parcat_5_level1_id` int(11) NOT NULL DEFAULT '0',
  `parcat_5_level2_id` int(11) NOT NULL DEFAULT '0',
  `parcat_5_level3_id` int(11) NOT NULL DEFAULT '0',
  `parcat_5_level4_id` int(11) NOT NULL DEFAULT '0',
  `package_id` int(11) NOT NULL,
  `package_price` decimal(10,2) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `title` (`title`),
  KEY `publication_date` (`publication_date`),
  KEY `status` (`status`),
  KEY `level` (`level`),
  KEY `account_id` (`account_id`),
  KEY `friendly_url` (`friendly_url`),
  KEY `random_number` (`random_number`),
  KEY `entered` (`entered`),
  KEY `updated` (`updated`),
  KEY `cat_1_id` (`cat_1_id`),
  KEY `parcat_1_level1_id` (`parcat_1_level1_id`),
  KEY `cat_2_id` (`cat_2_id`),
  KEY `parcat_2_level1_id` (`parcat_2_level1_id`),
  KEY `cat_3_id` (`cat_3_id`),
  KEY `parcat_3_level1_id` (`parcat_3_level1_id`),
  KEY `cat_4_id` (`cat_4_id`),
  KEY `parcat_4_level1_id` (`parcat_4_level1_id`),
  KEY `cat_5_id` (`cat_5_id`),
  KEY `parcat_5_level1_id` (`parcat_5_level1_id`),
  FULLTEXT KEY `fulltextsearch_keyword` (`fulltextsearch_keyword`),
  FULLTEXT KEY `fulltextsearch_where` (`fulltextsearch_where`),
  FULLTEXT KEY `fulltextsearch_title` (`title`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Article`
--


--
-- Table structure for table `ArticleCategory`
--

CREATE TABLE `ArticleCategory` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `category_id` int(11) NOT NULL DEFAULT '0',
  `thumb_id` int(11) NOT NULL DEFAULT '0',
  `image_id` int(11) NOT NULL DEFAULT '0',
  `featured` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'n',
  `summary_description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `seo_description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `page_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `friendly_url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `keywords` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `seo_keywords` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `content` text COLLATE utf8_unicode_ci,
  `active_article` int(11) NOT NULL DEFAULT '0',
  `enabled` char(1) COLLATE utf8_unicode_ci NOT NULL,
  `count_sub` int(5) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `category_id` (`category_id`),
  KEY `active_article` (`active_article`),
  KEY `title2` (`title`),
  KEY `friendly_url2` (`friendly_url`),
  FULLTEXT KEY `keywords` (`keywords`,`title`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ArticleCategory`
--


--
-- Table structure for table `ArticleLevel`
--

CREATE TABLE `ArticleLevel` (
  `value` int(3) NOT NULL DEFAULT '0',
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `defaultlevel` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'n',
  `detail` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'y',
  `images` int(3) NOT NULL DEFAULT '0',
  `price` decimal(10,2) NOT NULL DEFAULT '0.00',
  `active` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'y',
  `content` text COLLATE utf8_unicode_ci NOT NULL,
  `featured` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'y',
  PRIMARY KEY (`value`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ArticleLevel`
--

INSERT INTO `ArticleLevel` VALUES (50,'artigo','y','y',5,30.00,'y','','y');

--
-- Table structure for table `Banner`
--

CREATE TABLE `Banner` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `account_id` int(11) NOT NULL DEFAULT '0',
  `image_id` int(11) NOT NULL DEFAULT '0',
  `category_id` int(11) NOT NULL DEFAULT '0',
  `renewal_date` date NOT NULL DEFAULT '0000-00-00',
  `discount_id` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `caption` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `status` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'P',
  `suspended_sitemgr` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'n',
  `random_number` bigint(15) NOT NULL DEFAULT '0',
  `target_window` tinyint(1) NOT NULL DEFAULT '1',
  `type` tinyint(1) NOT NULL DEFAULT '0',
  `section` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'general',
  `content_line1` varchar(35) COLLATE utf8_unicode_ci NOT NULL,
  `content_line2` varchar(35) COLLATE utf8_unicode_ci NOT NULL,
  `destination_protocol` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `display_url` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `destination_url` text COLLATE utf8_unicode_ci NOT NULL,
  `unpaid_impressions` int(11) NOT NULL DEFAULT '0',
  `impressions` int(11) NOT NULL DEFAULT '0',
  `unlimited_impressions` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'n',
  `expiration_setting` char(1) COLLATE utf8_unicode_ci NOT NULL,
  `updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `entered` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `show_type` tinyint(4) NOT NULL DEFAULT '0',
  `script` text COLLATE utf8_unicode_ci,
  `package_id` int(11) NOT NULL,
  `package_price` decimal(10,2) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `status` (`status`),
  KEY `type` (`type`),
  KEY `section` (`section`),
  KEY `expiration_setting` (`expiration_setting`),
  KEY `impressions` (`impressions`),
  KEY `account_id` (`account_id`),
  KEY `category_id` (`category_id`),
  KEY `random_number` (`random_number`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Banner`
--


--
-- Table structure for table `BannerLevel`
--

CREATE TABLE `BannerLevel` (
  `value` int(3) NOT NULL DEFAULT '0',
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `defaultlevel` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'n',
  `price` decimal(10,2) NOT NULL DEFAULT '0.00',
  `width` int(11) NOT NULL DEFAULT '0',
  `height` int(11) NOT NULL DEFAULT '0',
  `impression_block` mediumint(9) NOT NULL DEFAULT '0',
  `impression_price` decimal(10,2) NOT NULL DEFAULT '0.00',
  `active` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'y',
  `popular` char(1) COLLATE utf8_unicode_ci NOT NULL,
  `content` text COLLATE utf8_unicode_ci NOT NULL,
  `displayName` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`value`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `BannerLevel`
--

INSERT INTO `BannerLevel` VALUES (1,'leaderboard','y',50.00,728,90,1000,50.00,'y','n','','leaderboard'),(2,'large mobile ','n',20.00,320,100,1000,20.00,'y','n','','large mobile banner'),(3,'square','n',40.00,250,250,1000,40.00,'y','n','','square'),(4,'wide skyscraper','n',40.00,160,600,1000,40.00,'y','n','','wide skyscraper'),(50,'sponsored links','n',10.00,320,100,1000,10.00,'y','n','','sponsored links');

--
-- Table structure for table `BlogCategory`
--

CREATE TABLE `BlogCategory` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `root_id` int(11) NOT NULL DEFAULT '0',
  `left` int(11) NOT NULL DEFAULT '0',
  `right` int(11) NOT NULL DEFAULT '0',
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `category_id` int(11) NOT NULL DEFAULT '0',
  `thumb_id` int(11) NOT NULL DEFAULT '0',
  `image_id` int(11) NOT NULL DEFAULT '0',
  `featured` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'n',
  `summary_description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `seo_description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `page_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `friendly_url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `keywords` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `seo_keywords` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `content` text COLLATE utf8_unicode_ci,
  `active_post` int(11) NOT NULL DEFAULT '0',
  `full_friendly_url` text COLLATE utf8_unicode_ci,
  `level` tinyint(3) NOT NULL DEFAULT '0',
  `legacy_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `enabled` char(1) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `legacy_id` (`legacy_id`),
  KEY `category_id` (`category_id`),
  KEY `active_post` (`active_post`),
  KEY `title2` (`title`),
  KEY `friendly_url2` (`friendly_url`),
  KEY `level` (`level`),
  FULLTEXT KEY `keywords` (`keywords`,`title`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `BlogCategory`
--


--
-- Table structure for table `Blog_Category`
--

CREATE TABLE `Blog_Category` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `category_id` int(11) NOT NULL,
  `post_id` int(11) NOT NULL,
  `category_root_id` int(11) NOT NULL,
  `category_node_left` int(11) NOT NULL,
  `category_node_right` int(11) NOT NULL,
  `status` varchar(1) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `post_id` (`post_id`),
  KEY `category_id` (`category_id`),
  KEY `status` (`status`),
  KEY `category_status` (`category_id`,`status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Blog_Category`
--


--
-- Table structure for table `CheckIn`
--

CREATE TABLE `CheckIn` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `item_id` int(11) NOT NULL DEFAULT '0',
  `item_type` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'listing' COMMENT 'listing/event',
  `member_id` int(11) NOT NULL,
  `added` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `ip` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `quick_tip` text COLLATE utf8_unicode_ci,
  `checkin_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `listing_id` (`item_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `CheckIn`
--


--
-- Table structure for table `Claim`
--

CREATE TABLE `Claim` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `account_id` int(11) NOT NULL,
  `username` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `listing_id` int(11) NOT NULL,
  `listing_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `date_time` datetime NOT NULL,
  `step` char(1) COLLATE utf8_unicode_ci NOT NULL,
  `status` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `old_location_1` int(11) NOT NULL,
  `new_location_1` int(11) NOT NULL,
  `old_location_2` int(11) NOT NULL,
  `new_location_2` int(11) NOT NULL,
  `old_location_3` int(11) NOT NULL,
  `new_location_3` int(11) NOT NULL,
  `old_location_4` int(11) NOT NULL,
  `new_location_4` int(11) NOT NULL,
  `old_location_5` int(11) NOT NULL,
  `new_location_5` int(11) NOT NULL,
  `old_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `new_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `old_friendly_url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `new_friendly_url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `old_email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `new_email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `old_url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `new_url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `old_phone` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `new_phone` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `old_fax` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `new_fax` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `old_address` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `new_address` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `old_address2` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `new_address2` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `old_zip_code` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `new_zip_code` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `old_level` tinyint(3) NOT NULL,
  `new_level` tinyint(3) NOT NULL,
  `old_listingtemplate_id` int(11) NOT NULL DEFAULT '0',
  `new_listingtemplate_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Claim`
--


--
-- Table structure for table `Classified`
--

CREATE TABLE `Classified` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `account_id` int(11) NOT NULL DEFAULT '0',
  `image_id` int(11) NOT NULL DEFAULT '0',
  `thumb_id` int(11) NOT NULL DEFAULT '0',
  `cover_id` int(11) NOT NULL DEFAULT '0',
  `entered` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `renewal_date` date NOT NULL DEFAULT '0000-00-00',
  `discount_id` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `seo_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `friendly_url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `contactname` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `address` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `address2` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `phone` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `fax` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `summarydesc` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `seo_summarydesc` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `detaildesc` text COLLATE utf8_unicode_ci NOT NULL,
  `keywords` text COLLATE utf8_unicode_ci NOT NULL,
  `seo_keywords` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `fulltextsearch_keyword` text COLLATE utf8_unicode_ci NOT NULL,
  `fulltextsearch_where` text COLLATE utf8_unicode_ci NOT NULL,
  `zip_code` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `zip5` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  `latitude` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `longitude` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `maptuning` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `maptuning_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `location_1` int(11) NOT NULL DEFAULT '0',
  `location_2` int(11) NOT NULL DEFAULT '0',
  `location_3` int(11) NOT NULL DEFAULT '0',
  `location_4` int(11) NOT NULL DEFAULT '0',
  `location_5` int(11) NOT NULL DEFAULT '0',
  `level` int(3) NOT NULL DEFAULT '0',
  `status` char(1) COLLATE utf8_unicode_ci NOT NULL,
  `suspended_sitemgr` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'n',
  `random_number` bigint(15) NOT NULL DEFAULT '0',
  `cat_1_id` int(11) NOT NULL DEFAULT '0',
  `parcat_1_level1_id` int(11) NOT NULL DEFAULT '0',
  `parcat_1_level2_id` int(11) NOT NULL DEFAULT '0',
  `parcat_1_level3_id` int(11) NOT NULL DEFAULT '0',
  `parcat_1_level4_id` int(11) NOT NULL DEFAULT '0',
  `cat_2_id` int(11) NOT NULL DEFAULT '0',
  `parcat_2_level1_id` int(11) NOT NULL DEFAULT '0',
  `parcat_2_level2_id` int(11) NOT NULL DEFAULT '0',
  `parcat_2_level3_id` int(11) NOT NULL DEFAULT '0',
  `parcat_2_level4_id` int(11) NOT NULL DEFAULT '0',
  `cat_3_id` int(11) NOT NULL DEFAULT '0',
  `parcat_3_level1_id` int(11) NOT NULL DEFAULT '0',
  `parcat_3_level2_id` int(11) NOT NULL DEFAULT '0',
  `parcat_3_level3_id` int(11) NOT NULL DEFAULT '0',
  `parcat_3_level4_id` int(11) NOT NULL DEFAULT '0',
  `cat_4_id` int(11) NOT NULL DEFAULT '0',
  `parcat_4_level1_id` int(11) NOT NULL DEFAULT '0',
  `parcat_4_level2_id` int(11) NOT NULL DEFAULT '0',
  `parcat_4_level3_id` int(11) NOT NULL DEFAULT '0',
  `parcat_4_level4_id` int(11) NOT NULL DEFAULT '0',
  `cat_5_id` int(11) NOT NULL DEFAULT '0',
  `parcat_5_level1_id` int(11) NOT NULL DEFAULT '0',
  `parcat_5_level2_id` int(11) NOT NULL DEFAULT '0',
  `parcat_5_level3_id` int(11) NOT NULL DEFAULT '0',
  `parcat_5_level4_id` int(11) NOT NULL DEFAULT '0',
  `classified_price` double(9,2) DEFAULT NULL,
  `number_views` int(11) NOT NULL DEFAULT '0',
  `map_zoom` int(11) NOT NULL,
  `package_id` int(11) NOT NULL,
  `package_price` decimal(10,2) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `country_id` (`location_1`),
  KEY `state_id` (`location_2`),
  KEY `region_id` (`location_3`),
  KEY `latitude` (`latitude`),
  KEY `longitude` (`longitude`),
  KEY `level` (`level`),
  KEY `status` (`status`),
  KEY `account_id` (`account_id`),
  KEY `city_id` (`location_4`),
  KEY `area_id` (`location_5`),
  KEY `title` (`title`),
  KEY `friendly_url` (`friendly_url`),
  KEY `random_number` (`random_number`),
  KEY `cat_1_id` (`cat_1_id`),
  KEY `parcat_1_level1_id` (`parcat_1_level1_id`),
  FULLTEXT KEY `fulltextsearch_keyword` (`fulltextsearch_keyword`),
  FULLTEXT KEY `fulltextsearch_where` (`fulltextsearch_where`),
  FULLTEXT KEY `fulltextsearch_title` (`title`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Classified`
--


--
-- Table structure for table `ClassifiedCategory`
--

CREATE TABLE `ClassifiedCategory` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `category_id` int(11) NOT NULL DEFAULT '0',
  `thumb_id` int(11) NOT NULL DEFAULT '0',
  `image_id` int(11) NOT NULL DEFAULT '0',
  `featured` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'n',
  `summary_description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `seo_description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `page_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `friendly_url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `keywords` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `seo_keywords` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `content` text COLLATE utf8_unicode_ci,
  `active_classified` int(11) NOT NULL DEFAULT '0',
  `enabled` char(1) COLLATE utf8_unicode_ci NOT NULL,
  `count_sub` int(5) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `category_id` (`category_id`),
  KEY `active_classified` (`active_classified`),
  KEY `title2` (`title`),
  KEY `friendly_url2` (`friendly_url`),
  FULLTEXT KEY `keywords` (`keywords`,`title`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ClassifiedCategory`
--


--
-- Table structure for table `ClassifiedLevel`
--

CREATE TABLE `ClassifiedLevel` (
  `value` int(3) NOT NULL DEFAULT '0',
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `defaultlevel` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'n',
  `detail` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'y',
  `images` int(3) NOT NULL DEFAULT '0',
  `price` decimal(10,2) NOT NULL DEFAULT '0.00',
  `active` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'y',
  `popular` char(1) COLLATE utf8_unicode_ci NOT NULL,
  `featured` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `content` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`value`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ClassifiedLevel`
--

INSERT INTO `ClassifiedLevel` VALUES (50,'prata','n','n',0,0.00,'y','','',''),(30,'ouro','n','y',3,25.00,'y','','y',''),(10,'diamante','y','y',7,50.00,'y','y','y','');

--
-- Table structure for table `ClassifiedLevel_Field`
--

CREATE TABLE `ClassifiedLevel_Field` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `level` int(3) NOT NULL,
  `field` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `theme` (`level`)
) ENGINE=MyISAM AUTO_INCREMENT=106 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ClassifiedLevel_Field`
--

INSERT INTO `ClassifiedLevel_Field` VALUES (64,10,'contact_name'),(65,30,'contact_name'),(68,10,'fax'),(70,10,'url'),(72,10,'long_description'),(73,30,'long_description'),(76,10,'main_image'),(77,30,'main_image'),(78,50,'main_image'),(85,10,'summary_description'),(86,30,'summary_description'),(87,50,'summary_description'),(91,10,'contact_phone'),(92,30,'contact_phone'),(93,50,'contact_phone'),(97,10,'contact_email'),(98,30,'contact_email'),(99,50,'contact_email'),(103,10,'price'),(104,30,'price'),(105,50,'price');

--
-- Table structure for table `Classified_LocationCounter`
--

CREATE TABLE `Classified_LocationCounter` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `location_level` int(11) NOT NULL,
  `location_id` int(11) NOT NULL,
  `count` int(11) NOT NULL,
  `title` varchar(255) CHARACTER SET utf8 NOT NULL,
  `full_friendly_url` varchar(255) CHARACTER SET utf8 NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Classified_LocationCounter`
--


--
-- Table structure for table `Comments`
--

CREATE TABLE `Comments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `post_id` int(11) NOT NULL DEFAULT '0',
  `reply_id` int(11) NOT NULL DEFAULT '0',
  `member_id` int(11) NOT NULL,
  `member_name` tinytext COLLATE utf8_unicode_ci NOT NULL,
  `added` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `description` text COLLATE utf8_unicode_ci,
  `approved` int(1) NOT NULL,
  `legacy_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `legacy_id` (`legacy_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Comments`
--


--
-- Table structure for table `Content`
--

CREATE TABLE `Content` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci NOT NULL,
  `keywords` text COLLATE utf8_unicode_ci NOT NULL,
  `url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `section` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'general',
  `content` longtext COLLATE utf8_unicode_ci NOT NULL,
  `sitemap` int(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `section` (`section`)
) ENGINE=MyISAM AUTO_INCREMENT=81 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Content`
--

INSERT INTO `Content` VALUES (1,'0000-00-00 00:00:00','Home Page','Página Inicial','','','','general','',0),(2,'0000-00-00 00:00:00','Home Page Bottom','Home Page Bottom','','','','general','',0),(3,'0000-00-00 00:00:00','Directory Results','Resultados','','','','general','',0),(4,'0000-00-00 00:00:00','Directory Results Bottom','Directory Results Bottom','','','','general','',0),(5,'0000-00-00 00:00:00','Advertise with Us','Anuncie Conosco','','','','advertise_general','<h1>Cadastre-se já - É rápido e fácil!</h1>\r\n<p>eDirectory tem o orgulho de anunciar o seu novo serviço de diretório que já está disponível on-line para os visitantes e novos anunciantes. Oferecemos infinitas possibilidades de recursos para visitantes e anunciantes.</p><p>Os seus itens do diretório também são controlados inteiramente por você. Temos uma interface de membros onde voc&ecirc; pode entrar e mudar todos os detalhes, adicionar promocões especiais para os clientes e muito mais!',0),(6,'0000-00-00 00:00:00','Advertise with Us Bottom','Advertise with Us Bottom','','','','advertise_general','',0),(7,'0000-00-00 00:00:00','Contact Us','Contato','','','','general','<h1>Contato</h1>\r\n<p>Precisa de ajuda? Entre em contato conosco, responderemos o mais rápido possível.</p>',0),(8,'0000-00-00 00:00:00','Terms of Use','Termos de Uso','','','','general','<h2>Termos de Uso</h2>\r\n<p>&nbsp;</p>\r\n<p>Pellentesque nulla sem, suscipit quis mattis et, imperdiet nec massa. Mauris faucibus fermentum aliquam. Aliquam commodo egestas iaculis. Pellentesque ut mauris nisi, commodo gravida elit. Phasellus eget diam eros. Donec ante velit, dignissim in congue eget, congue in quam. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Sed ut ipsum nisi, ut pulvinar augue. Quisque blandit facilisis velit non ornare. Cras et urna nunc. Praesent non ante urna. Sed vehicula nulla sit amet lacus mattis scelerisque. Sed non felis arcu. Morbi congue aliquet ante, quis vestibulum ipsum gravida non. Sed ante felis, lobortis ac pharetra fermentum, aliquet id elit.<br /><br />Maecenas lobortis eleifend turpis, eu luctus sapien ultricies vitae. Aliquam erat volutpat. Nullam dolor odio, dapibus sed pellentesque nec, adipiscing eget quam. Integer mi sem, pharetra ac convallis eget, sodales in mauris. Suspendisse quis urna non nisl ullamcorper imperdiet a quis eros. Vivamus egestas posuere consequat. Nulla a commodo nunc. Morbi ut enim lectus, vitae pretium dui. Phasellus lacinia, lorem id malesuada luctus, enim augue fermentum augue, eu luctus dolor magna et turpis. Praesent vitae ornare mauris.<br /><br />Nam eget libero at tortor auctor placerat at vitae orci. Fusce tempus luctus dolor. Vivamus pharetra erat vitae ipsum pharetra ut tincidunt lacus pharetra. Sed viverra interdum fringilla. Aenean cursus nulla at neque luctus et pellentesque ante dignissim. Ut luctus odio et velit suscipit imperdiet. Cras semper, leo quis venenatis elementum, nibh diam blandit nulla, ut dictum ipsum lectus non diam. Vivamus ac convallis velit. Nulla est magna, bibendum eu luctus sed, dignissim in libero. Etiam sit amet purus ut odio mollis varius. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Donec non velit vel augue mollis blandit eu eu metus. Morbi dapibus porttitor scelerisque. Praesent ultricies erat ac nisi laoreet sit amet consequat leo fringilla. Fusce egestas neque ut nisl mattis eget dignissim elit accumsan. Phasellus mollis dapibus tristique. Sed ut velit non nibh sagittis ornare sed feugiat nibh.</p>',0),(9,'0000-00-00 00:00:00','Listing Advertisement','Listing Advertisement','','','','advertise_listing','',0),(10,'0000-00-00 00:00:00','Listing Home','Empresas','','','','listing','',0),(11,'0000-00-00 00:00:00','Listing Home Bottom','Listing Home Bottom','','','','listing','',0),(12,'0000-00-00 00:00:00','Listing Results','Busca por Empresas','','','','listing','',0),(13,'0000-00-00 00:00:00','Listing Results Bottom','Listing Results Bottom','','','','listing','',0),(14,'0000-00-00 00:00:00','Listing View All Categories','Categorias de Empresas','','','','listing','',0),(15,'0000-00-00 00:00:00','Listing View All Categories Bottom','Listing View All Categories Bottom','','','','listing','',0),(16,'0000-00-00 00:00:00','Listing View All Locations','Localidades de Empresas','','','','listing','',0),(17,'0000-00-00 00:00:00','Listing View All Locations Bottom','Listing View All Locations Bottom','','','','listing','',0),(18,'0000-00-00 00:00:00','Deal Home','Ofertas','','','','deal','',0),(19,'0000-00-00 00:00:00','Deal Home Bottom','Deal Home Bottom','','','','deal','',0),(20,'0000-00-00 00:00:00','Deal Results','Busca por Ofertas','','','','deal','',0),(21,'0000-00-00 00:00:00','Deal Results Bottom','Deal Results Bottom','','','','deal','',0),(22,'0000-00-00 00:00:00','Deal View All Categories','Categorias de Ofertas','','','','deal','',0),(23,'0000-00-00 00:00:00','Deal View All Categories Bottom','Deal View All Categories Bottom','','','','deal','',0),(24,'0000-00-00 00:00:00','Deal View All Locations','Localidades de Ofertas','','','','deal','',0),(25,'0000-00-00 00:00:00','Deal View All Locations Bottom','Deal View All Locations Bottom','','','','deal','',0),(26,'0000-00-00 00:00:00','Event Advertisement','Event Advertisement','','','','advertise_event','',0),(27,'0000-00-00 00:00:00','Event Home','Eventos','','','','event','',0),(28,'0000-00-00 00:00:00','Event Home Bottom','Event Home Bottom','','','','event','',0),(29,'0000-00-00 00:00:00','Event Results','Busca por Eventos','','','','event','',0),(30,'0000-00-00 00:00:00','Event Results Bottom','Event Results Bottom','','','','event','',0),(31,'0000-00-00 00:00:00','Event View All Categories','Categorias de Eventos','','','','event','',0),(32,'0000-00-00 00:00:00','Event View All Categories Bottom','Event View All Categories Bottom','','','','event','',0),(33,'0000-00-00 00:00:00','Event View All Locations','Localidades de Eventos','','','','event','',0),(34,'0000-00-00 00:00:00','Event View All Locations Bottom','Event View All Locations Bottom','','','','event','',0),(35,'0000-00-00 00:00:00','Banner Advertisement','','','','','advertise_banner','<ul>\r\n<li>Adicione anúncios de acordo com o conteúdo do diretório</li>\r\n<li>Encontre novos clientes em busca de serviços e produtos</li><li>Divulgue sua marca</li><li>Retorno Imediato - Ganhe novos clientes em minutos!</li>\r\n</ul>',0),(36,'0000-00-00 00:00:00','Classified Advertisement','Classified Advertisement','','','','advertise_classified','',0),(37,'0000-00-00 00:00:00','Classified Home','Classificados','','','','classified','',0),(38,'0000-00-00 00:00:00','Classified Home Bottom','Classified Home Bottom','','','','classified','',0),(39,'0000-00-00 00:00:00','Classified Results','Busca por Classificados','','','','classified','',0),(40,'0000-00-00 00:00:00','Classified Results Bottom','Classified Results Bottom','','','','classified','',0),(41,'0000-00-00 00:00:00','Classified View All Categories','Categorias de Classificados','','','','classified','',0),(42,'0000-00-00 00:00:00','Classified View All Categories Bottom','Classified View All Categories Bottom','','','','classified','',0),(43,'0000-00-00 00:00:00','Classified View All Locations','Localidades de Classificados','','','','classified','',0),(44,'0000-00-00 00:00:00','Classified View All Locations Bottom','Classified View All Locations Bottom','','','','classified','',0),(45,'0000-00-00 00:00:00','Article Advertisement','','','','','advertise_article','<p>Adicione seu artigo e seja conhecido por potenciais clientes e consumidores.</p>',0),(46,'0000-00-00 00:00:00','Article Home','Artigos','','','','article','',0),(47,'0000-00-00 00:00:00','Article Home Bottom','Article Home Bottom','','','','article','',0),(48,'0000-00-00 00:00:00','Article Results','Busca por Artigos','','','','article','',0),(49,'0000-00-00 00:00:00','Article Results Bottom','Article Results Bottom','','','','article','',0),(50,'0000-00-00 00:00:00','Article View All Categories','Categorias de Artigos','','','','article','',0),(51,'0000-00-00 00:00:00','Article View All Categories Bottom','Article View All Categories Bottom','','','','article','',0),(52,'0000-00-00 00:00:00','Sponsor Home','Sponsor Home','','','','member','',0),(53,'0000-00-00 00:00:00','Sponsor Home Bottom','Sponsor Home Bottom','','','','member','',0),(54,'0000-00-00 00:00:00','Manage Account','Manage Account','','','','member','',0),(55,'0000-00-00 00:00:00','Manage Account Bottom','Manage Account Bottom','','','','member','',0),(56,'0000-00-00 00:00:00','Sponsor Help','Sponsor Help','','','','member','',0),(57,'0000-00-00 00:00:00','Sponsor Help Bottom','Sponsor Help Bottom','','','','member','',0),(58,'0000-00-00 00:00:00','Event Change Level','Alterar nível do Evento','','','','member','',0),(59,'0000-00-00 00:00:00','Listing Change Level','Alterar nível da Empresa','','','','member','',0),(60,'0000-00-00 00:00:00','Transaction','Transaction','','','','member','',0),(61,'0000-00-00 00:00:00','Transaction Bottom','Transaction Bottom','','','','member','',0),(62,'0000-00-00 00:00:00','Sitemap','Mapa do Site','','','','general','',0),(63,'0000-00-00 00:00:00','Error Page','Página não encontrada','Página não encontrada','','','general','<h1 style=\"text-align: center;\"><span style=\"color: #efefef; font-size: 300px;\">404</span></h1><p style=\"text-align: center;\">&nbsp;</p><h2 style=\"text-align: center;\"><span style=\"color: #cdcdcd; font-size: 50px;\">Oops</span></h2><p style=\"text-align: center;\"><span style=\"color: #999999;\">&nbsp;</span></p><p style=\"text-align: center;\"><span style=\"color: #999999; font-size: 24px;\">Não encontramos a página que você está procurando.</span></p><p style=\"text-align: center;\"><span style=\"color: #999999;\">&nbsp;</span></p><p style=\"text-align: center;\"><span style=\"color: #999999; font-size: 16px;\">Você tentou utilizar nossa busca para encontrar facilmente o que procura?﻿</span></p><p style=\"text-align: center;\"><span style=\"color: #999999;\">...</span></p>',0),(64,'0000-00-00 00:00:00','Maintenance Page','Página em manutenção','','','','general','<p style=\"color: #efefef; font-size: 150px; text-align: center;\"><span class=\"fa-stack fa-lg\"> <em class=\"fa fa-circle fa-stack-2x\"></em>&nbsp; <em class=\"fa fa-coffee fa-stack-1x fa-inverse\"></em></span></p><h1 style=\"text-align: center;\"><span style=\"color: #cdcdcd; font-size: 30px; text-transform: uppercase;\">Estamos em manutenção</span></h1><p style=\"text-align: center;\"><span style=\"color: #999999;\">&nbsp;</span></p><p style=\"text-align: center;\"><span style=\"color: #999999; font-size: 16px;\">Voltaremos em breve</span></p>',0),(65,'0000-00-00 00:00:00','Profile Page','Perfil','','','','general','',0),(66,'0000-00-00 00:00:00','Profile Page Login','Área do visitante','','','','general','<h2>Bem-vindo de volta! É sempre bom recebê-lo de volta!</h2><p>&nbsp;</p><p style=\"color: #eeeeee; font-size: 150px; text-align: center;\"><span class=\"fa-stack\"><em class=\"fa fa-circle fa-stack-2x\"></em>&nbsp;<em class=\"fa fa-sign-in fa-stack-1x fa-inverse\"></em></span>&nbsp;</p><p style=\"font-size: 1.2em;\">Junte-se à nossa comunidade hoje mesmo. <span>Você pode acessar a qualquer hora do seu computador, tablet, telefone ou pelo nosso aplicativo!</span></p><p>&nbsp;</p><p>&nbsp;</p>',0),(67,'0000-00-00 00:00:00','Profile Page Bottom','Profile Page Bottom','','','','general','',0),(68,'0000-00-00 00:00:00','Add Profile Page','Adicionar Perfil','','','','general','<h2>Cadastre-se já e participe da nossa comunidade!</h2><p>&nbsp;</p><p style=\"color: #eeeeee; font-size: 150px; text-align: center;\"><span class=\"fa-stack\"><em class=\"fa fa-circle fa-stack-2x\"></em>&nbsp;<em class=\"fa fa-users fa-stack-1x fa-inverse\"></em></span>&nbsp;</p><p style=\"font-size: 1.2em;\">Junte-se à nossa comunidade hoje mesmo. <span>Você pode acessar a qualquer hora do seu computador, tablet, telefone ou pelo nosso aplicativo!</span></p><p>&nbsp;</p><p>&nbsp;</p>',0),(69,'0000-00-00 00:00:00','Packages Offer','Packages Offer','','','','advertise_general','',0),(70,'0000-00-00 00:00:00','Blog Home','Blog','','','','blog','',0),(71,'0000-00-00 00:00:00','Blog Home Bottom','Blog Home Bottom','','','','blog','',0),(72,'0000-00-00 00:00:00','Blog Results','Busca por Posts','','','','blog','',0),(73,'0000-00-00 00:00:00','Blog Results Bottom','Blog Results Bottom','','','','blog','',0),(74,'0000-00-00 00:00:00','Blog View All Categories','Categorias de Posts','','','','blog','',0),(75,'0000-00-00 00:00:00','Blog View All Categories Bottom','Blog View All Categories Bottom','','','','blog','',0),(76,'0000-00-00 00:00:00','Classified Change Level','Alterar nível do Classificado','','','','member','',0),(77,'0000-00-00 00:00:00','Leads Form','Pedido','','','','general','<h1>Não encontrou o que estava procurando?</h1> \r\n<p>Preencha o formulário abaixo com mais informações que entraremos em contato com as melhores opções para você.</p>',0),(78,'0000-00-00 00:00:00','Privacy Policy','Política de Privacidade','','','','general','<h2>Política de Privacidade</h2>\r\n<p>&nbsp;</p>\r\n<p>Pellentesque nulla sem, suscipit quis mattis et, imperdiet nec massa. Mauris faucibus fermentum aliquam. Aliquam commodo egestas iaculis. Pellentesque ut mauris nisi, commodo gravida elit. Phasellus eget diam eros. Donec ante velit, dignissim in congue eget, congue in quam. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Sed ut ipsum nisi, ut pulvinar augue. Quisque blandit facilisis velit non ornare. Cras et urna nunc. Praesent non ante urna. Sed vehicula nulla sit amet lacus mattis scelerisque. Sed non felis arcu. Morbi congue aliquet ante, quis vestibulum ipsum gravida non. Sed ante felis, lobortis ac pharetra fermentum, aliquet id elit.<br /><br />Maecenas lobortis eleifend turpis, eu luctus sapien ultricies vitae. Aliquam erat volutpat. Nullam dolor odio, dapibus sed pellentesque nec, adipiscing eget quam. Integer mi sem, pharetra ac convallis eget, sodales in mauris. Suspendisse quis urna non nisl ullamcorper imperdiet a quis eros. Vivamus egestas posuere consequat. Nulla a commodo nunc. Morbi ut enim lectus, vitae pretium dui. Phasellus lacinia, lorem id malesuada luctus, enim augue fermentum augue, eu luctus dolor magna et turpis. Praesent vitae ornare mauris.<br /><br />Nam eget libero at tortor auctor placerat at vitae orci. Fusce tempus luctus dolor. Vivamus pharetra erat vitae ipsum pharetra ut tincidunt lacus pharetra. Sed viverra interdum fringilla. Aenean cursus nulla at neque luctus et pellentesque ante dignissim. Ut luctus odio et velit suscipit imperdiet. Cras semper, leo quis venenatis elementum, nibh diam blandit nulla, ut dictum ipsum lectus non diam. Vivamus ac convallis velit. Nulla est magna, bibendum eu luctus sed, dignissim in libero. Etiam sit amet purus ut odio mollis varius. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Donec non velit vel augue mollis blandit eu eu metus. Morbi dapibus porttitor scelerisque. Praesent ultricies erat ac nisi laoreet sit amet consequat leo fringilla. Fusce egestas neque ut nisl mattis eget dignissim elit accumsan. Phasellus mollis dapibus tristique. Sed ut velit non nibh sagittis ornare sed feugiat nibh.</p>',0),(79,'0000-00-00 00:00:00','Footer','','','','','general','<div style=\"padding:40px 0; background: url(/assets/images/bg-downloadapps.png) no-repeat center bottom; \"><div class=\"container\"><div class=\"row\"><div class=\"col-sm-2 text-right text-center-sm\"><br><a href=\"https://play.google.com/store/apps/details?id=br.com.arcasolutions\" style=\"font-size:20px; font-weight:300; line-height:1;\">Disponível na Play Store</a></div><div class=\"col-sm-8\"><br><p class=\"text-uppercase text-center\" style=\"font-size:24px; font-weight:300;\">Baixe nosso Aplicativo</p></div><div class=\"col-sm-2 text-left text-center-sm\"><br><a href=\"https://itunes.apple.com/br/app/edirectory/id337135168?mt=8\" style=\"font-size:20px; font-weight:300; line-height:1;\">Disponível na Apple Store</a></div></div></div></div>',0),(80,'0000-00-00 00:00:00','FAQ','Perguntas Frequentes','','','','faq','',0);

--
-- Table structure for table `CustomInvoice`
--

CREATE TABLE `CustomInvoice` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `account_id` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `title` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `sent_date` text COLLATE utf8_unicode_ci NOT NULL,
  `subtotal` decimal(10,2) NOT NULL DEFAULT '0.00',
  `tax` decimal(10,2) NOT NULL DEFAULT '0.00',
  `amount` decimal(10,2) NOT NULL DEFAULT '0.00',
  `paid` char(1) COLLATE utf8_unicode_ci NOT NULL,
  `sent` char(1) COLLATE utf8_unicode_ci NOT NULL,
  `completed` char(1) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `account_id` (`account_id`),
  KEY `paid` (`paid`),
  KEY `sent` (`sent`),
  KEY `completed` (`completed`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `CustomInvoice`
--


--
-- Table structure for table `CustomInvoice_Items`
--

CREATE TABLE `CustomInvoice_Items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `custominvoice_id` int(11) NOT NULL DEFAULT '0',
  `description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `price` decimal(10,2) NOT NULL DEFAULT '0.00',
  PRIMARY KEY (`id`),
  KEY `custominvoice_id` (`custominvoice_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `CustomInvoice_Items`
--


--
-- Table structure for table `CustomText`
--

CREATE TABLE `CustomText` (
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `value` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `CustomText`
--

INSERT INTO `CustomText` VALUES ('claim_textlink','Esta empresa é sua?'),('payment_tax_label','Taxa'),('promotion_default_conditions','Limite de uma oferta por pessoa. O valor promocional expira em 30 dias. O cupom deve ser apresentado para receber o desconto. Não é válido para devolução de dinheiro. Pode ser usado uma única vez. Não cobre impostos ou descontos. Não pode ser combinado com outras ofertas.'),('header_title','Demodirectory Brasil'),('header_author','Arca Solutions'),('header_description',''),('header_keywords',''),('footer_copyright','');

--
-- Table structure for table `Discount_Code`
--

CREATE TABLE `Discount_Code` (
  `id` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `amount` decimal(10,2) NOT NULL DEFAULT '0.00',
  `type` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
  `status` char(1) COLLATE utf8_unicode_ci NOT NULL,
  `expire_date` date NOT NULL,
  `recurring` char(3) COLLATE utf8_unicode_ci NOT NULL,
  `listing` char(3) COLLATE utf8_unicode_ci NOT NULL,
  `event` char(3) COLLATE utf8_unicode_ci NOT NULL,
  `banner` char(3) COLLATE utf8_unicode_ci NOT NULL,
  `classified` char(3) COLLATE utf8_unicode_ci NOT NULL,
  `article` char(3) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `type` (`type`),
  KEY `status` (`status`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Discount_Code`
--


--
-- Table structure for table `Editor_Choice`
--

CREATE TABLE `Editor_Choice` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `available` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  `image_id` int(11) NOT NULL DEFAULT '0',
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `available` (`available`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Editor_Choice`
--


--
-- Table structure for table `Email_Notification`
--

CREATE TABLE `Email_Notification` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `days` tinyint(3) NOT NULL DEFAULT '0',
  `deactivate` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  `updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `bcc` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `subject` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `content_type` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL,
  `body` text COLLATE utf8_unicode_ci,
  `use_variables` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `deactivate` (`deactivate`)
) ENGINE=MyISAM AUTO_INCREMENT=41 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Email_Notification`
--



--
-- Table structure for table `Email_Notification_Default`
--

CREATE TABLE `Email_Notification_Default` (
  `id` int(11) NOT NULL,
  `subject` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `body_text` text COLLATE utf8_unicode_ci NOT NULL,
  `body_html` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Email_Notification_Default`
--

INSERT INTO `Email_Notification_Default` VALUES (1,'Listing renewal notification','Dear ACCOUNT_NAME,\r\n\r\nThank you for create your profile in EDIRECTORY_TITLE (DEFAULT_URL).\r\nClick on the link below to activate your account.\r\n\r\nLINK_ACTIVATE_ACCOUNT\r\n\r\nAfter that, you can login to manage your account with the information below.\r\n\r\nACCOUNT_LOGIN_INFORMATION\r\n\r\nRegards \r\nEDIRECTORY_TITLE Team','<html>\n<head>\n<style type=\"text/css\">\n.default_text_settings {\nfont-family: Verdana, Arial, Helvetica, sans-serif;\nfont-size: 8pt;\ncolor: #003365;\nmargin: 0;\npadding: 5px;\nbackground: #FBFBFB;\nborder: 1px solid #E9E9E9;\ntext-align: justify;\n};\n</style>\n</head>\n<body>\n<div class=\"default_text_settings\">\nDear ACCOUNT_NAME,<br /><br />\nThank you for create your profile in EDIRECTORY_TITLE (DEFAULT_URL).<br />\nClick on the link below to activate your account.<br />\nLINK_ACTIVATE_ACCOUNT<br />\nAfter that, you can login to manage your account with the e-mail and password below.<br /><br />\nACCOUNT_LOGIN_INFORMATION<br /><br />\r\nRegards<br />\r\nEDIRECTORY_TITLE Team</div>\r\n</body>\n</html>'),(2,'Listing renewal notification','Dear ACCOUNT_NAME,\r\n\r\nThank you for create your profile in EDIRECTORY_TITLE (DEFAULT_URL).\r\nClick on the link below to activate your account.\r\n\r\nLINK_ACTIVATE_ACCOUNT\r\n\r\nAfter that, you can login to manage your account with the information below.\r\n\r\nACCOUNT_LOGIN_INFORMATION\r\n\r\nRegards \r\nEDIRECTORY_TITLE Team','<html>\n<head>\n<style type=\"text/css\">\n.default_text_settings {\nfont-family: Verdana, Arial, Helvetica, sans-serif;\nfont-size: 8pt;\ncolor: #003365;\nmargin: 0;\npadding: 5px;\nbackground: #FBFBFB;\nborder: 1px solid #E9E9E9;\ntext-align: justify;\n};\n</style>\n</head>\n<body>\n<div class=\"default_text_settings\">\nDear ACCOUNT_NAME,<br /><br />\nThank you for create your profile in EDIRECTORY_TITLE (DEFAULT_URL).<br />\nClick on the link below to activate your account.<br />\nLINK_ACTIVATE_ACCOUNT<br />\nAfter that, you can login to manage your account with the e-mail and password below.<br /><br />\nACCOUNT_LOGIN_INFORMATION<br /><br />\r\nRegards<br />\r\nEDIRECTORY_TITLE Team</div>\r\n</body>\n</html>'),(3,'Listing renewal notification','Dear ACCOUNT_NAME,\r\n\r\nThank you for create your profile in EDIRECTORY_TITLE (DEFAULT_URL).\r\nClick on the link below to activate your account.\r\n\r\nLINK_ACTIVATE_ACCOUNT\r\n\r\nAfter that, you can login to manage your account with the information below.\r\n\r\nACCOUNT_LOGIN_INFORMATION\r\n\r\nRegards \r\nEDIRECTORY_TITLE Team','<html>\n<head>\n<style type=\"text/css\">\n.default_text_settings {\nfont-family: Verdana, Arial, Helvetica, sans-serif;\nfont-size: 8pt;\ncolor: #003365;\nmargin: 0;\npadding: 5px;\nbackground: #FBFBFB;\nborder: 1px solid #E9E9E9;\ntext-align: justify;\n};\n</style>\n</head>\n<body>\n<div class=\"default_text_settings\">\nDear ACCOUNT_NAME,<br /><br />\nThank you for create your profile in EDIRECTORY_TITLE (DEFAULT_URL).<br />\nClick on the link below to activate your account.<br />\nLINK_ACTIVATE_ACCOUNT<br />\nAfter that, you can login to manage your account with the e-mail and password below.<br /><br />\nACCOUNT_LOGIN_INFORMATION<br /><br />\r\nRegards<br />\r\nEDIRECTORY_TITLE Team</div>\r\n</body>\n</html>'),(4,'Listing renewal notification','Dear ACCOUNT_NAME,\r\n\r\nThank you for create your profile in EDIRECTORY_TITLE (DEFAULT_URL).\r\nClick on the link below to activate your account.\r\n\r\nLINK_ACTIVATE_ACCOUNT\r\n\r\nAfter that, you can login to manage your account with the information below.\r\n\r\nACCOUNT_LOGIN_INFORMATION\r\n\r\nRegards \r\nEDIRECTORY_TITLE Team','<html>\n<head>\n<style type=\"text/css\">\n.default_text_settings {\nfont-family: Verdana, Arial, Helvetica, sans-serif;\nfont-size: 8pt;\ncolor: #003365;\nmargin: 0;\npadding: 5px;\nbackground: #FBFBFB;\nborder: 1px solid #E9E9E9;\ntext-align: justify;\n};\n</style>\n</head>\n<body>\n<div class=\"default_text_settings\">\nDear ACCOUNT_NAME,<br /><br />\nThank you for create your profile in EDIRECTORY_TITLE (DEFAULT_URL).<br />\nClick on the link below to activate your account.<br />\nLINK_ACTIVATE_ACCOUNT<br />\nAfter that, you can login to manage your account with the e-mail and password below.<br /><br />\nACCOUNT_LOGIN_INFORMATION<br /><br />\r\nRegards<br />\r\nEDIRECTORY_TITLE Team</div>\r\n</body>\n</html>'),(5,'EDIRECTORY_TITLE Account','Dear ACCOUNT_NAME,\r\n\r\nThank you for create your profile in EDIRECTORY_TITLE (DEFAULT_URL).\r\nClick on the link below to activate your account.\r\n\r\nLINK_ACTIVATE_ACCOUNT\r\n\r\nAfter that, you can login to manage your account with the information below.\r\n\r\nACCOUNT_LOGIN_INFORMATION\r\n\r\nRegards \r\nEDIRECTORY_TITLE Team','<html>\n<head>\n<style type=\"text/css\">\n.default_text_settings {\nfont-family: Verdana, Arial, Helvetica, sans-serif;\nfont-size: 8pt;\ncolor: #003365;\nmargin: 0;\npadding: 5px;\nbackground: #FBFBFB;\nborder: 1px solid #E9E9E9;\ntext-align: justify;\n};\n</style>\n</head>\n<body>\n<div class=\"default_text_settings\">\nDear ACCOUNT_NAME,<br /><br />\nThank you for create your profile in EDIRECTORY_TITLE (DEFAULT_URL).<br />\nClick on the link below to activate your account.<br />\nLINK_ACTIVATE_ACCOUNT<br />\nAfter that, you can login to manage your account with the e-mail and password below.<br /><br />\nACCOUNT_LOGIN_INFORMATION<br /><br />\r\nRegards<br />\r\nEDIRECTORY_TITLE Team</div>\r\n</body>\n</html>'),(6,'EDIRECTORY_TITLE Account','Dear ACCOUNT_NAME,\r\n\r\nThank you for create your profile in EDIRECTORY_TITLE (DEFAULT_URL).\r\nClick on the link below to activate your account.\r\n\r\nLINK_ACTIVATE_ACCOUNT\r\n\r\nAfter that, you can login to manage your account with the information below.\r\n\r\nACCOUNT_LOGIN_INFORMATION\r\n\r\nRegards \r\nEDIRECTORY_TITLE Team','<html>\n<head>\n<style type=\"text/css\">\n.default_text_settings {\nfont-family: Verdana, Arial, Helvetica, sans-serif;\nfont-size: 8pt;\ncolor: #003365;\nmargin: 0;\npadding: 5px;\nbackground: #FBFBFB;\nborder: 1px solid #E9E9E9;\ntext-align: justify;\n};\n</style>\n</head>\n<body>\n<div class=\"default_text_settings\">\nDear ACCOUNT_NAME,<br /><br />\nThank you for create your profile in EDIRECTORY_TITLE (DEFAULT_URL).<br />\nClick on the link below to activate your account.<br />\nLINK_ACTIVATE_ACCOUNT<br />\nAfter that, you can login to manage your account with the e-mail and password below.<br /><br />\nACCOUNT_LOGIN_INFORMATION<br /><br />\r\nRegards<br />\r\nEDIRECTORY_TITLE Team</div>\r\n</body>\n</html>'),(7,'EDIRECTORY_TITLE Account','Dear ACCOUNT_NAME,\r\n\r\nThank you for create your profile in EDIRECTORY_TITLE (DEFAULT_URL).\r\nClick on the link below to activate your account.\r\n\r\nLINK_ACTIVATE_ACCOUNT\r\n\r\nAfter that, you can login to manage your account with the information below.\r\n\r\nACCOUNT_LOGIN_INFORMATION\r\n\r\nRegards \r\nEDIRECTORY_TITLE Team','<html>\n<head>\n<style type=\"text/css\">\n.default_text_settings {\nfont-family: Verdana, Arial, Helvetica, sans-serif;\nfont-size: 8pt;\ncolor: #003365;\nmargin: 0;\npadding: 5px;\nbackground: #FBFBFB;\nborder: 1px solid #E9E9E9;\ntext-align: justify;\n};\n</style>\n</head>\n<body>\n<div class=\"default_text_settings\">\nDear ACCOUNT_NAME,<br /><br />\nThank you for create your profile in EDIRECTORY_TITLE (DEFAULT_URL).<br />\nClick on the link below to activate your account.<br />\nLINK_ACTIVATE_ACCOUNT<br />\nAfter that, you can login to manage your account with the e-mail and password below.<br /><br />\nACCOUNT_LOGIN_INFORMATION<br /><br />\r\nRegards<br />\r\nEDIRECTORY_TITLE Team</div>\r\n</body>\n</html>'),(8,'EDIRECTORY_TITLE Account','Dear ACCOUNT_NAME,\r\n\r\nThank you for create your profile in EDIRECTORY_TITLE (DEFAULT_URL).\r\nClick on the link below to activate your account.\r\n\r\nLINK_ACTIVATE_ACCOUNT\r\n\r\nAfter that, you can login to manage your account with the information below.\r\n\r\nACCOUNT_LOGIN_INFORMATION\r\n\r\nRegards \r\nEDIRECTORY_TITLE Team','<html>\n<head>\n<style type=\"text/css\">\n.default_text_settings {\nfont-family: Verdana, Arial, Helvetica, sans-serif;\nfont-size: 8pt;\ncolor: #003365;\nmargin: 0;\npadding: 5px;\nbackground: #FBFBFB;\nborder: 1px solid #E9E9E9;\ntext-align: justify;\n};\n</style>\n</head>\n<body>\n<div class=\"default_text_settings\">\nDear ACCOUNT_NAME,<br /><br />\nThank you for create your profile in EDIRECTORY_TITLE (DEFAULT_URL).<br />\nClick on the link below to activate your account.<br />\nLINK_ACTIVATE_ACCOUNT<br />\nAfter that, you can login to manage your account with the e-mail and password below.<br /><br />\nACCOUNT_LOGIN_INFORMATION<br /><br />\r\nRegards<br />\r\nEDIRECTORY_TITLE Team</div>\r\n</body>\n</html>'),(9,'EDIRECTORY_TITLE account information','Dear ACCOUNT_NAME,\r\n\r\nThank you for create your profile in EDIRECTORY_TITLE (DEFAULT_URL).\r\nClick on the link below to activate your account.\r\n\r\nLINK_ACTIVATE_ACCOUNT\r\n\r\nAfter that, you can login to manage your account with the information below.\r\n\r\nACCOUNT_LOGIN_INFORMATION\r\n\r\nRegards \r\nEDIRECTORY_TITLE Team','<html>\n<head>\n<style type=\"text/css\">\n.default_text_settings {\nfont-family: Verdana, Arial, Helvetica, sans-serif;\nfont-size: 8pt;\ncolor: #003365;\nmargin: 0;\npadding: 5px;\nbackground: #FBFBFB;\nborder: 1px solid #E9E9E9;\ntext-align: justify;\n};\n</style>\n</head>\n<body>\n<div class=\"default_text_settings\">\nDear ACCOUNT_NAME,<br /><br />\nThank you for create your profile in EDIRECTORY_TITLE (DEFAULT_URL).<br />\nClick on the link below to activate your account.<br />\nLINK_ACTIVATE_ACCOUNT<br />\nAfter that, you can login to manage your account with the e-mail and password below.<br /><br />\nACCOUNT_LOGIN_INFORMATION<br /><br />\r\nRegards<br />\r\nEDIRECTORY_TITLE Team</div>\r\n</body>\n</html>'),(10,'EDIRECTORY_TITLE Notification','Dear ACCOUNT_NAME,\r\n\r\nThank you for create your profile in EDIRECTORY_TITLE (DEFAULT_URL).\r\nClick on the link below to activate your account.\r\n\r\nLINK_ACTIVATE_ACCOUNT\r\n\r\nAfter that, you can login to manage your account with the information below.\r\n\r\nACCOUNT_LOGIN_INFORMATION\r\n\r\nRegards \r\nEDIRECTORY_TITLE Team','<html>\n<head>\n<style type=\"text/css\">\n.default_text_settings {\nfont-family: Verdana, Arial, Helvetica, sans-serif;\nfont-size: 8pt;\ncolor: #003365;\nmargin: 0;\npadding: 5px;\nbackground: #FBFBFB;\nborder: 1px solid #E9E9E9;\ntext-align: justify;\n};\n</style>\n</head>\n<body>\n<div class=\"default_text_settings\">\nDear ACCOUNT_NAME,<br /><br />\nThank you for create your profile in EDIRECTORY_TITLE (DEFAULT_URL).<br />\nClick on the link below to activate your account.<br />\nLINK_ACTIVATE_ACCOUNT<br />\nAfter that, you can login to manage your account with the e-mail and password below.<br /><br />\nACCOUNT_LOGIN_INFORMATION<br /><br />\r\nRegards<br />\r\nEDIRECTORY_TITLE Team</div>\r\n</body>\n</html>'),(11,'EDIRECTORY_TITLE Notification','Dear ACCOUNT_NAME,\r\n\r\nThank you for create your profile in EDIRECTORY_TITLE (DEFAULT_URL).\r\nClick on the link below to activate your account.\r\n\r\nLINK_ACTIVATE_ACCOUNT\r\n\r\nAfter that, you can login to manage your account with the information below.\r\n\r\nACCOUNT_LOGIN_INFORMATION\r\n\r\nRegards \r\nEDIRECTORY_TITLE Team','<html>\n<head>\n<style type=\"text/css\">\n.default_text_settings {\nfont-family: Verdana, Arial, Helvetica, sans-serif;\nfont-size: 8pt;\ncolor: #003365;\nmargin: 0;\npadding: 5px;\nbackground: #FBFBFB;\nborder: 1px solid #E9E9E9;\ntext-align: justify;\n};\n</style>\n</head>\n<body>\n<div class=\"default_text_settings\">\nDear ACCOUNT_NAME,<br /><br />\nThank you for create your profile in EDIRECTORY_TITLE (DEFAULT_URL).<br />\nClick on the link below to activate your account.<br />\nLINK_ACTIVATE_ACCOUNT<br />\nAfter that, you can login to manage your account with the e-mail and password below.<br /><br />\nACCOUNT_LOGIN_INFORMATION<br /><br />\r\nRegards<br />\r\nEDIRECTORY_TITLE Team</div>\r\n</body>\n</html>'),(12,'EDIRECTORY_TITLE Notification','Dear ACCOUNT_NAME,\r\n\r\nThank you for create your profile in EDIRECTORY_TITLE (DEFAULT_URL).\r\nClick on the link below to activate your account.\r\n\r\nLINK_ACTIVATE_ACCOUNT\r\n\r\nAfter that, you can login to manage your account with the information below.\r\n\r\nACCOUNT_LOGIN_INFORMATION\r\n\r\nRegards \r\nEDIRECTORY_TITLE Team','<html>\n<head>\n<style type=\"text/css\">\n.default_text_settings {\nfont-family: Verdana, Arial, Helvetica, sans-serif;\nfont-size: 8pt;\ncolor: #003365;\nmargin: 0;\npadding: 5px;\nbackground: #FBFBFB;\nborder: 1px solid #E9E9E9;\ntext-align: justify;\n};\n</style>\n</head>\n<body>\n<div class=\"default_text_settings\">\nDear ACCOUNT_NAME,<br /><br />\nThank you for create your profile in EDIRECTORY_TITLE (DEFAULT_URL).<br />\nClick on the link below to activate your account.<br />\nLINK_ACTIVATE_ACCOUNT<br />\nAfter that, you can login to manage your account with the e-mail and password below.<br /><br />\nACCOUNT_LOGIN_INFORMATION<br /><br />\r\nRegards<br />\r\nEDIRECTORY_TITLE Team</div>\r\n</body>\n</html>'),(13,'EDIRECTORY_TITLE Notification','Dear ACCOUNT_NAME,\r\n\r\nThank you for create your profile in EDIRECTORY_TITLE (DEFAULT_URL).\r\nClick on the link below to activate your account.\r\n\r\nLINK_ACTIVATE_ACCOUNT\r\n\r\nAfter that, you can login to manage your account with the information below.\r\n\r\nACCOUNT_LOGIN_INFORMATION\r\n\r\nRegards \r\nEDIRECTORY_TITLE Team','<html>\n<head>\n<style type=\"text/css\">\n.default_text_settings {\nfont-family: Verdana, Arial, Helvetica, sans-serif;\nfont-size: 8pt;\ncolor: #003365;\nmargin: 0;\npadding: 5px;\nbackground: #FBFBFB;\nborder: 1px solid #E9E9E9;\ntext-align: justify;\n};\n</style>\n</head>\n<body>\n<div class=\"default_text_settings\">\nDear ACCOUNT_NAME,<br /><br />\nThank you for create your profile in EDIRECTORY_TITLE (DEFAULT_URL).<br />\nClick on the link below to activate your account.<br />\nLINK_ACTIVATE_ACCOUNT<br />\nAfter that, you can login to manage your account with the e-mail and password below.<br /><br />\nACCOUNT_LOGIN_INFORMATION<br /><br />\r\nRegards<br />\r\nEDIRECTORY_TITLE Team</div>\r\n</body>\n</html>'),(14,'EDIRECTORY_TITLE Notification','Dear ACCOUNT_NAME,\r\n\r\nThank you for create your profile in EDIRECTORY_TITLE (DEFAULT_URL).\r\nClick on the link below to activate your account.\r\n\r\nLINK_ACTIVATE_ACCOUNT\r\n\r\nAfter that, you can login to manage your account with the information below.\r\n\r\nACCOUNT_LOGIN_INFORMATION\r\n\r\nRegards \r\nEDIRECTORY_TITLE Team','<html>\n<head>\n<style type=\"text/css\">\n.default_text_settings {\nfont-family: Verdana, Arial, Helvetica, sans-serif;\nfont-size: 8pt;\ncolor: #003365;\nmargin: 0;\npadding: 5px;\nbackground: #FBFBFB;\nborder: 1px solid #E9E9E9;\ntext-align: justify;\n};\n</style>\n</head>\n<body>\n<div class=\"default_text_settings\">\nDear ACCOUNT_NAME,<br /><br />\nThank you for create your profile in EDIRECTORY_TITLE (DEFAULT_URL).<br />\nClick on the link below to activate your account.<br />\nLINK_ACTIVATE_ACCOUNT<br />\nAfter that, you can login to manage your account with the e-mail and password below.<br /><br />\nACCOUNT_LOGIN_INFORMATION<br /><br />\r\nRegards<br />\r\nEDIRECTORY_TITLE Team</div>\r\n</body>\n</html>'),(15,'[EDIRECTORY_TITLE] Invoice','Dear ACCOUNT_NAME,\r\n\r\nThank you for create your profile in EDIRECTORY_TITLE (DEFAULT_URL).\r\nClick on the link below to activate your account.\r\n\r\nLINK_ACTIVATE_ACCOUNT\r\n\r\nAfter that, you can login to manage your account with the information below.\r\n\r\nACCOUNT_LOGIN_INFORMATION\r\n\r\nRegards \r\nEDIRECTORY_TITLE Team','<html>\n<head>\n<style type=\"text/css\">\n.default_text_settings {\nfont-family: Verdana, Arial, Helvetica, sans-serif;\nfont-size: 8pt;\ncolor: #003365;\nmargin: 0;\npadding: 5px;\nbackground: #FBFBFB;\nborder: 1px solid #E9E9E9;\ntext-align: justify;\n};\n</style>\n</head>\n<body>\n<div class=\"default_text_settings\">\nDear ACCOUNT_NAME,<br /><br />\nThank you for create your profile in EDIRECTORY_TITLE (DEFAULT_URL).<br />\nClick on the link below to activate your account.<br />\nLINK_ACTIVATE_ACCOUNT<br />\nAfter that, you can login to manage your account with the e-mail and password below.<br /><br />\nACCOUNT_LOGIN_INFORMATION<br /><br />\r\nRegards<br />\r\nEDIRECTORY_TITLE Team</div>\r\n</body>\n</html>'),(16,'EDIRECTORY_TITLE Activation Notification','Dear ACCOUNT_NAME,\r\n\r\nThank you for create your profile in EDIRECTORY_TITLE (DEFAULT_URL).\r\nClick on the link below to activate your account.\r\n\r\nLINK_ACTIVATE_ACCOUNT\r\n\r\nAfter that, you can login to manage your account with the information below.\r\n\r\nACCOUNT_LOGIN_INFORMATION\r\n\r\nRegards \r\nEDIRECTORY_TITLE Team','<html>\n<head>\n<style type=\"text/css\">\n.default_text_settings {\nfont-family: Verdana, Arial, Helvetica, sans-serif;\nfont-size: 8pt;\ncolor: #003365;\nmargin: 0;\npadding: 5px;\nbackground: #FBFBFB;\nborder: 1px solid #E9E9E9;\ntext-align: justify;\n};\n</style>\n</head>\n<body>\n<div class=\"default_text_settings\">\nDear ACCOUNT_NAME,<br /><br />\nThank you for create your profile in EDIRECTORY_TITLE (DEFAULT_URL).<br />\nClick on the link below to activate your account.<br />\nLINK_ACTIVATE_ACCOUNT<br />\nAfter that, you can login to manage your account with the e-mail and password below.<br /><br />\nACCOUNT_LOGIN_INFORMATION<br /><br />\r\nRegards<br />\r\nEDIRECTORY_TITLE Team</div>\r\n</body>\n</html>'),(17,'EDIRECTORY_TITLE Activation Notification','Dear ACCOUNT_NAME,\r\n\r\nThank you for create your profile in EDIRECTORY_TITLE (DEFAULT_URL).\r\nClick on the link below to activate your account.\r\n\r\nLINK_ACTIVATE_ACCOUNT\r\n\r\nAfter that, you can login to manage your account with the information below.\r\n\r\nACCOUNT_LOGIN_INFORMATION\r\n\r\nRegards \r\nEDIRECTORY_TITLE Team','<html>\n<head>\n<style type=\"text/css\">\n.default_text_settings {\nfont-family: Verdana, Arial, Helvetica, sans-serif;\nfont-size: 8pt;\ncolor: #003365;\nmargin: 0;\npadding: 5px;\nbackground: #FBFBFB;\nborder: 1px solid #E9E9E9;\ntext-align: justify;\n};\n</style>\n</head>\n<body>\n<div class=\"default_text_settings\">\nDear ACCOUNT_NAME,<br /><br />\nThank you for create your profile in EDIRECTORY_TITLE (DEFAULT_URL).<br />\nClick on the link below to activate your account.<br />\nLINK_ACTIVATE_ACCOUNT<br />\nAfter that, you can login to manage your account with the e-mail and password below.<br /><br />\nACCOUNT_LOGIN_INFORMATION<br /><br />\r\nRegards<br />\r\nEDIRECTORY_TITLE Team</div>\r\n</body>\n</html>'),(18,'EDIRECTORY_TITLE Activation Notification','Dear ACCOUNT_NAME,\r\n\r\nThank you for create your profile in EDIRECTORY_TITLE (DEFAULT_URL).\r\nClick on the link below to activate your account.\r\n\r\nLINK_ACTIVATE_ACCOUNT\r\n\r\nAfter that, you can login to manage your account with the information below.\r\n\r\nACCOUNT_LOGIN_INFORMATION\r\n\r\nRegards \r\nEDIRECTORY_TITLE Team','<html>\n<head>\n<style type=\"text/css\">\n.default_text_settings {\nfont-family: Verdana, Arial, Helvetica, sans-serif;\nfont-size: 8pt;\ncolor: #003365;\nmargin: 0;\npadding: 5px;\nbackground: #FBFBFB;\nborder: 1px solid #E9E9E9;\ntext-align: justify;\n};\n</style>\n</head>\n<body>\n<div class=\"default_text_settings\">\nDear ACCOUNT_NAME,<br /><br />\nThank you for create your profile in EDIRECTORY_TITLE (DEFAULT_URL).<br />\nClick on the link below to activate your account.<br />\nLINK_ACTIVATE_ACCOUNT<br />\nAfter that, you can login to manage your account with the e-mail and password below.<br /><br />\nACCOUNT_LOGIN_INFORMATION<br /><br />\r\nRegards<br />\r\nEDIRECTORY_TITLE Team</div>\r\n</body>\n</html>'),(19,'EDIRECTORY_TITLE Activation Notification','Dear ACCOUNT_NAME,\r\n\r\nThank you for create your profile in EDIRECTORY_TITLE (DEFAULT_URL).\r\nClick on the link below to activate your account.\r\n\r\nLINK_ACTIVATE_ACCOUNT\r\n\r\nAfter that, you can login to manage your account with the information below.\r\n\r\nACCOUNT_LOGIN_INFORMATION\r\n\r\nRegards \r\nEDIRECTORY_TITLE Team','<html>\n<head>\n<style type=\"text/css\">\n.default_text_settings {\nfont-family: Verdana, Arial, Helvetica, sans-serif;\nfont-size: 8pt;\ncolor: #003365;\nmargin: 0;\npadding: 5px;\nbackground: #FBFBFB;\nborder: 1px solid #E9E9E9;\ntext-align: justify;\n};\n</style>\n</head>\n<body>\n<div class=\"default_text_settings\">\nDear ACCOUNT_NAME,<br /><br />\nThank you for create your profile in EDIRECTORY_TITLE (DEFAULT_URL).<br />\nClick on the link below to activate your account.<br />\nLINK_ACTIVATE_ACCOUNT<br />\nAfter that, you can login to manage your account with the e-mail and password below.<br /><br />\nACCOUNT_LOGIN_INFORMATION<br /><br />\r\nRegards<br />\r\nEDIRECTORY_TITLE Team</div>\r\n</body>\n</html>'),(20,'EDIRECTORY_TITLE Activation Notification','Dear ACCOUNT_NAME,\r\n\r\nThank you for create your profile in EDIRECTORY_TITLE (DEFAULT_URL).\r\nClick on the link below to activate your account.\r\n\r\nLINK_ACTIVATE_ACCOUNT\r\n\r\nAfter that, you can login to manage your account with the information below.\r\n\r\nACCOUNT_LOGIN_INFORMATION\r\n\r\nRegards \r\nEDIRECTORY_TITLE Team','<html>\n<head>\n<style type=\"text/css\">\n.default_text_settings {\nfont-family: Verdana, Arial, Helvetica, sans-serif;\nfont-size: 8pt;\ncolor: #003365;\nmargin: 0;\npadding: 5px;\nbackground: #FBFBFB;\nborder: 1px solid #E9E9E9;\ntext-align: justify;\n};\n</style>\n</head>\n<body>\n<div class=\"default_text_settings\">\nDear ACCOUNT_NAME,<br /><br />\nThank you for create your profile in EDIRECTORY_TITLE (DEFAULT_URL).<br />\nClick on the link below to activate your account.<br />\nLINK_ACTIVATE_ACCOUNT<br />\nAfter that, you can login to manage your account with the e-mail and password below.<br /><br />\nACCOUNT_LOGIN_INFORMATION<br /><br />\r\nRegards<br />\r\nEDIRECTORY_TITLE Team</div>\r\n</body>\n</html>'),(22,'EDIRECTORY_TITLE Signup Notification','Dear ACCOUNT_NAME,\r\n\r\nThank you for create your profile in EDIRECTORY_TITLE (DEFAULT_URL).\r\nClick on the link below to activate your account.\r\n\r\nLINK_ACTIVATE_ACCOUNT\r\n\r\nAfter that, you can login to manage your account with the information below.\r\n\r\nACCOUNT_LOGIN_INFORMATION\r\n\r\nRegards \r\nEDIRECTORY_TITLE Team','<html>\n<head>\n<style type=\"text/css\">\n.default_text_settings {\nfont-family: Verdana, Arial, Helvetica, sans-serif;\nfont-size: 8pt;\ncolor: #003365;\nmargin: 0;\npadding: 5px;\nbackground: #FBFBFB;\nborder: 1px solid #E9E9E9;\ntext-align: justify;\n};\n</style>\n</head>\n<body>\n<div class=\"default_text_settings\">\nDear ACCOUNT_NAME,<br /><br />\nThank you for create your profile in EDIRECTORY_TITLE (DEFAULT_URL).<br />\nClick on the link below to activate your account.<br />\nLINK_ACTIVATE_ACCOUNT<br />\nAfter that, you can login to manage your account with the e-mail and password below.<br /><br />\nACCOUNT_LOGIN_INFORMATION<br /><br />\r\nRegards<br />\r\nEDIRECTORY_TITLE Team</div>\r\n</body>\n</html>'),(23,'EDIRECTORY_TITLE Signup Notification','Dear ACCOUNT_NAME,\r\n\r\nThank you for create your profile in EDIRECTORY_TITLE (DEFAULT_URL).\r\nClick on the link below to activate your account.\r\n\r\nLINK_ACTIVATE_ACCOUNT\r\n\r\nAfter that, you can login to manage your account with the information below.\r\n\r\nACCOUNT_LOGIN_INFORMATION\r\n\r\nRegards \r\nEDIRECTORY_TITLE Team','<html>\n<head>\n<style type=\"text/css\">\n.default_text_settings {\nfont-family: Verdana, Arial, Helvetica, sans-serif;\nfont-size: 8pt;\ncolor: #003365;\nmargin: 0;\npadding: 5px;\nbackground: #FBFBFB;\nborder: 1px solid #E9E9E9;\ntext-align: justify;\n};\n</style>\n</head>\n<body>\n<div class=\"default_text_settings\">\nDear ACCOUNT_NAME,<br /><br />\nThank you for create your profile in EDIRECTORY_TITLE (DEFAULT_URL).<br />\nClick on the link below to activate your account.<br />\nLINK_ACTIVATE_ACCOUNT<br />\nAfter that, you can login to manage your account with the e-mail and password below.<br /><br />\nACCOUNT_LOGIN_INFORMATION<br /><br />\r\nRegards<br />\r\nEDIRECTORY_TITLE Team</div>\r\n</body>\n</html>'),(24,'EDIRECTORY_TITLE Signup Notification','Dear ACCOUNT_NAME,\r\n\r\nThank you for create your profile in EDIRECTORY_TITLE (DEFAULT_URL).\r\nClick on the link below to activate your account.\r\n\r\nLINK_ACTIVATE_ACCOUNT\r\n\r\nAfter that, you can login to manage your account with the information below.\r\n\r\nACCOUNT_LOGIN_INFORMATION\r\n\r\nRegards \r\nEDIRECTORY_TITLE Team','<html>\n<head>\n<style type=\"text/css\">\n.default_text_settings {\nfont-family: Verdana, Arial, Helvetica, sans-serif;\nfont-size: 8pt;\ncolor: #003365;\nmargin: 0;\npadding: 5px;\nbackground: #FBFBFB;\nborder: 1px solid #E9E9E9;\ntext-align: justify;\n};\n</style>\n</head>\n<body>\n<div class=\"default_text_settings\">\nDear ACCOUNT_NAME,<br /><br />\nThank you for create your profile in EDIRECTORY_TITLE (DEFAULT_URL).<br />\nClick on the link below to activate your account.<br />\nLINK_ACTIVATE_ACCOUNT<br />\nAfter that, you can login to manage your account with the e-mail and password below.<br /><br />\nACCOUNT_LOGIN_INFORMATION<br /><br />\r\nRegards<br />\r\nEDIRECTORY_TITLE Team</div>\r\n</body>\n</html>'),(25,'EDIRECTORY_TITLE Signup Notification','Dear ACCOUNT_NAME,\r\n\r\nThank you for create your profile in EDIRECTORY_TITLE (DEFAULT_URL).\r\nClick on the link below to activate your account.\r\n\r\nLINK_ACTIVATE_ACCOUNT\r\n\r\nAfter that, you can login to manage your account with the information below.\r\n\r\nACCOUNT_LOGIN_INFORMATION\r\n\r\nRegards \r\nEDIRECTORY_TITLE Team','<html>\n<head>\n<style type=\"text/css\">\n.default_text_settings {\nfont-family: Verdana, Arial, Helvetica, sans-serif;\nfont-size: 8pt;\ncolor: #003365;\nmargin: 0;\npadding: 5px;\nbackground: #FBFBFB;\nborder: 1px solid #E9E9E9;\ntext-align: justify;\n};\n</style>\n</head>\n<body>\n<div class=\"default_text_settings\">\nDear ACCOUNT_NAME,<br /><br />\nThank you for create your profile in EDIRECTORY_TITLE (DEFAULT_URL).<br />\nClick on the link below to activate your account.<br />\nLINK_ACTIVATE_ACCOUNT<br />\nAfter that, you can login to manage your account with the e-mail and password below.<br /><br />\nACCOUNT_LOGIN_INFORMATION<br /><br />\r\nRegards<br />\r\nEDIRECTORY_TITLE Team</div>\r\n</body>\n</html>'),(26,'EDIRECTORY_TITLE Signup Notification','Dear ACCOUNT_NAME,\r\n\r\nThank you for create your profile in EDIRECTORY_TITLE (DEFAULT_URL).\r\nClick on the link below to activate your account.\r\n\r\nLINK_ACTIVATE_ACCOUNT\r\n\r\nAfter that, you can login to manage your account with the information below.\r\n\r\nACCOUNT_LOGIN_INFORMATION\r\n\r\nRegards \r\nEDIRECTORY_TITLE Team','<html>\n<head>\n<style type=\"text/css\">\n.default_text_settings {\nfont-family: Verdana, Arial, Helvetica, sans-serif;\nfont-size: 8pt;\ncolor: #003365;\nmargin: 0;\npadding: 5px;\nbackground: #FBFBFB;\nborder: 1px solid #E9E9E9;\ntext-align: justify;\n};\n</style>\n</head>\n<body>\n<div class=\"default_text_settings\">\nDear ACCOUNT_NAME,<br /><br />\nThank you for create your profile in EDIRECTORY_TITLE (DEFAULT_URL).<br />\nClick on the link below to activate your account.<br />\nLINK_ACTIVATE_ACCOUNT<br />\nAfter that, you can login to manage your account with the e-mail and password below.<br /><br />\nACCOUNT_LOGIN_INFORMATION<br /><br />\r\nRegards<br />\r\nEDIRECTORY_TITLE Team</div>\r\n</body>\n</html>'),(27,'EDIRECTORY_TITLE Claimer Signup Notification','Dear ACCOUNT_NAME,\r\n\r\nThank you for create your profile in EDIRECTORY_TITLE (DEFAULT_URL).\r\nClick on the link below to activate your account.\r\n\r\nLINK_ACTIVATE_ACCOUNT\r\n\r\nAfter that, you can login to manage your account with the information below.\r\n\r\nACCOUNT_LOGIN_INFORMATION\r\n\r\nRegards \r\nEDIRECTORY_TITLE Team','<html>\n<head>\n<style type=\"text/css\">\n.default_text_settings {\nfont-family: Verdana, Arial, Helvetica, sans-serif;\nfont-size: 8pt;\ncolor: #003365;\nmargin: 0;\npadding: 5px;\nbackground: #FBFBFB;\nborder: 1px solid #E9E9E9;\ntext-align: justify;\n};\n</style>\n</head>\n<body>\n<div class=\"default_text_settings\">\nDear ACCOUNT_NAME,<br /><br />\nThank you for create your profile in EDIRECTORY_TITLE (DEFAULT_URL).<br />\nClick on the link below to activate your account.<br />\nLINK_ACTIVATE_ACCOUNT<br />\nAfter that, you can login to manage your account with the e-mail and password below.<br /><br />\nACCOUNT_LOGIN_INFORMATION<br /><br />\r\nRegards<br />\r\nEDIRECTORY_TITLE Team</div>\r\n</body>\n</html>'),(28,'EDIRECTORY_TITLE Claim Approved Notification','Dear ACCOUNT_NAME,\r\n\r\nThank you for create your profile in EDIRECTORY_TITLE (DEFAULT_URL).\r\nClick on the link below to activate your account.\r\n\r\nLINK_ACTIVATE_ACCOUNT\r\n\r\nAfter that, you can login to manage your account with the information below.\r\n\r\nACCOUNT_LOGIN_INFORMATION\r\n\r\nRegards \r\nEDIRECTORY_TITLE Team','<html>\n<head>\n<style type=\"text/css\">\n.default_text_settings {\nfont-family: Verdana, Arial, Helvetica, sans-serif;\nfont-size: 8pt;\ncolor: #003365;\nmargin: 0;\npadding: 5px;\nbackground: #FBFBFB;\nborder: 1px solid #E9E9E9;\ntext-align: justify;\n};\n</style>\n</head>\n<body>\n<div class=\"default_text_settings\">\nDear ACCOUNT_NAME,<br /><br />\nThank you for create your profile in EDIRECTORY_TITLE (DEFAULT_URL).<br />\nClick on the link below to activate your account.<br />\nLINK_ACTIVATE_ACCOUNT<br />\nAfter that, you can login to manage your account with the e-mail and password below.<br /><br />\nACCOUNT_LOGIN_INFORMATION<br /><br />\r\nRegards<br />\r\nEDIRECTORY_TITLE Team</div>\r\n</body>\n</html>'),(29,'EDIRECTORY_TITLE Claim Approved Notification','Dear ACCOUNT_NAME,\r\n\r\nThank you for create your profile in EDIRECTORY_TITLE (DEFAULT_URL).\r\nClick on the link below to activate your account.\r\n\r\nLINK_ACTIVATE_ACCOUNT\r\n\r\nAfter that, you can login to manage your account with the information below.\r\n\r\nACCOUNT_LOGIN_INFORMATION\r\n\r\nRegards \r\nEDIRECTORY_TITLE Team','<html>\n<head>\n<style type=\"text/css\">\n.default_text_settings {\nfont-family: Verdana, Arial, Helvetica, sans-serif;\nfont-size: 8pt;\ncolor: #003365;\nmargin: 0;\npadding: 5px;\nbackground: #FBFBFB;\nborder: 1px solid #E9E9E9;\ntext-align: justify;\n};\n</style>\n</head>\n<body>\n<div class=\"default_text_settings\">\nDear ACCOUNT_NAME,<br /><br />\nThank you for create your profile in EDIRECTORY_TITLE (DEFAULT_URL).<br />\nClick on the link below to activate your account.<br />\nLINK_ACTIVATE_ACCOUNT<br />\nAfter that, you can login to manage your account with the e-mail and password below.<br /><br />\nACCOUNT_LOGIN_INFORMATION<br /><br />\r\nRegards<br />\r\nEDIRECTORY_TITLE Team</div>\r\n</body>\n</html>'),(30,'EDIRECTORY_TITLE Claim Denied Notification','Dear ACCOUNT_NAME,\r\n\r\nThank you for create your profile in EDIRECTORY_TITLE (DEFAULT_URL).\r\nClick on the link below to activate your account.\r\n\r\nLINK_ACTIVATE_ACCOUNT\r\n\r\nAfter that, you can login to manage your account with the information below.\r\n\r\nACCOUNT_LOGIN_INFORMATION\r\n\r\nRegards \r\nEDIRECTORY_TITLE Team','<html>\n<head>\n<style type=\"text/css\">\n.default_text_settings {\nfont-family: Verdana, Arial, Helvetica, sans-serif;\nfont-size: 8pt;\ncolor: #003365;\nmargin: 0;\npadding: 5px;\nbackground: #FBFBFB;\nborder: 1px solid #E9E9E9;\ntext-align: justify;\n};\n</style>\n</head>\n<body>\n<div class=\"default_text_settings\">\nDear ACCOUNT_NAME,<br /><br />\nThank you for create your profile in EDIRECTORY_TITLE (DEFAULT_URL).<br />\nClick on the link below to activate your account.<br />\nLINK_ACTIVATE_ACCOUNT<br />\nAfter that, you can login to manage your account with the e-mail and password below.<br /><br />\nACCOUNT_LOGIN_INFORMATION<br /><br />\r\nRegards<br />\r\nEDIRECTORY_TITLE Team</div>\r\n</body>\n</html>'),(31,'[EDIRECTORY_TITLE] Reply Approved Notification','Dear ACCOUNT_NAME,\r\n\r\nThank you for create your profile in EDIRECTORY_TITLE (DEFAULT_URL).\r\nClick on the link below to activate your account.\r\n\r\nLINK_ACTIVATE_ACCOUNT\r\n\r\nAfter that, you can login to manage your account with the information below.\r\n\r\nACCOUNT_LOGIN_INFORMATION\r\n\r\nRegards \r\nEDIRECTORY_TITLE Team','<html>\n<head>\n<style type=\"text/css\">\n.default_text_settings {\nfont-family: Verdana, Arial, Helvetica, sans-serif;\nfont-size: 8pt;\ncolor: #003365;\nmargin: 0;\npadding: 5px;\nbackground: #FBFBFB;\nborder: 1px solid #E9E9E9;\ntext-align: justify;\n};\n</style>\n</head>\n<body>\n<div class=\"default_text_settings\">\nDear ACCOUNT_NAME,<br /><br />\nThank you for create your profile in EDIRECTORY_TITLE (DEFAULT_URL).<br />\nClick on the link below to activate your account.<br />\nLINK_ACTIVATE_ACCOUNT<br />\nAfter that, you can login to manage your account with the e-mail and password below.<br /><br />\nACCOUNT_LOGIN_INFORMATION<br /><br />\r\nRegards<br />\r\nEDIRECTORY_TITLE Team</div>\r\n</body>\n</html>'),(32,'[EDIRECTORY_TITLE] Review Approved Notification','Dear ACCOUNT_NAME,\r\n\r\nThank you for create your profile in EDIRECTORY_TITLE (DEFAULT_URL).\r\nClick on the link below to activate your account.\r\n\r\nLINK_ACTIVATE_ACCOUNT\r\n\r\nAfter that, you can login to manage your account with the information below.\r\n\r\nACCOUNT_LOGIN_INFORMATION\r\n\r\nRegards \r\nEDIRECTORY_TITLE Team','<html>\n<head>\n<style type=\"text/css\">\n.default_text_settings {\nfont-family: Verdana, Arial, Helvetica, sans-serif;\nfont-size: 8pt;\ncolor: #003365;\nmargin: 0;\npadding: 5px;\nbackground: #FBFBFB;\nborder: 1px solid #E9E9E9;\ntext-align: justify;\n};\n</style>\n</head>\n<body>\n<div class=\"default_text_settings\">\nDear ACCOUNT_NAME,<br /><br />\nThank you for create your profile in EDIRECTORY_TITLE (DEFAULT_URL).<br />\nClick on the link below to activate your account.<br />\nLINK_ACTIVATE_ACCOUNT<br />\nAfter that, you can login to manage your account with the e-mail and password below.<br /><br />\nACCOUNT_LOGIN_INFORMATION<br /><br />\r\nRegards<br />\r\nEDIRECTORY_TITLE Team</div>\r\n</body>\n</html>'),(33,'[EDIRECTORY_TITLE] New Review Notification','Dear ACCOUNT_NAME,\r\n\r\nThank you for create your profile in EDIRECTORY_TITLE (DEFAULT_URL).\r\nClick on the link below to activate your account.\r\n\r\nLINK_ACTIVATE_ACCOUNT\r\n\r\nAfter that, you can login to manage your account with the information below.\r\n\r\nACCOUNT_LOGIN_INFORMATION\r\n\r\nRegards \r\nEDIRECTORY_TITLE Team','<html>\n<head>\n<style type=\"text/css\">\n.default_text_settings {\nfont-family: Verdana, Arial, Helvetica, sans-serif;\nfont-size: 8pt;\ncolor: #003365;\nmargin: 0;\npadding: 5px;\nbackground: #FBFBFB;\nborder: 1px solid #E9E9E9;\ntext-align: justify;\n};\n</style>\n</head>\n<body>\n<div class=\"default_text_settings\">\nDear ACCOUNT_NAME,<br /><br />\nThank you for create your profile in EDIRECTORY_TITLE (DEFAULT_URL).<br />\nClick on the link below to activate your account.<br />\nLINK_ACTIVATE_ACCOUNT<br />\nAfter that, you can login to manage your account with the e-mail and password below.<br /><br />\nACCOUNT_LOGIN_INFORMATION<br /><br />\r\nRegards<br />\r\nEDIRECTORY_TITLE Team</div>\r\n</body>\n</html>'),(34,'[EDIRECTORY_TITLE] Invoice Notification','Dear ACCOUNT_NAME,\r\n\r\nThank you for create your profile in EDIRECTORY_TITLE (DEFAULT_URL).\r\nClick on the link below to activate your account.\r\n\r\nLINK_ACTIVATE_ACCOUNT\r\n\r\nAfter that, you can login to manage your account with the information below.\r\n\r\nACCOUNT_LOGIN_INFORMATION\r\n\r\nRegards \r\nEDIRECTORY_TITLE Team','<html>\n<head>\n<style type=\"text/css\">\n.default_text_settings {\nfont-family: Verdana, Arial, Helvetica, sans-serif;\nfont-size: 8pt;\ncolor: #003365;\nmargin: 0;\npadding: 5px;\nbackground: #FBFBFB;\nborder: 1px solid #E9E9E9;\ntext-align: justify;\n};\n</style>\n</head>\n<body>\n<div class=\"default_text_settings\">\nDear ACCOUNT_NAME,<br /><br />\nThank you for create your profile in EDIRECTORY_TITLE (DEFAULT_URL).<br />\nClick on the link below to activate your account.<br />\nLINK_ACTIVATE_ACCOUNT<br />\nAfter that, you can login to manage your account with the e-mail and password below.<br /><br />\nACCOUNT_LOGIN_INFORMATION<br /><br />\r\nRegards<br />\r\nEDIRECTORY_TITLE Team</div>\r\n</body>\n</html>'),(35,'EDIRECTORY_TITLE Profile','Prezado(a) ACCOUNT_NAME,\r\n\r\nObrigado por criar seu perfil em EDIRECTORY_TITLE (DEFAULT_URL).\r\nClique no link abaixo para ativar sua conta.\r\n\r\nLINK_ACTIVATE_ACCOUNT\r\n\r\nUma vez ativada, você poderá fazer login e gerenciar sua conta com os dados abaixo.\r\n\r\nACCOUNT_LOGIN_INFORMATION\r\n\r\nAtenciosamente \r\nEquipe EDIRECTORY_TITLE','<html>\r\n<head>\r\n<style type=\"text/css\">\r\n.default_text_settings {\r\nfont-family: Verdana, Arial, Helvetica, sans-serif;\r\nfont-size: 8pt;\r\ncolor: #003365;\r\nmargin: 0;\r\npadding: 5px;\r\nbackground: #FBFBFB;\r\nborder: 1px solid #E9E9E9;\r\ntext-align: justify;\r\n};\r\n</style>\r\n</head>\r\n<body>\r\n<div class=\"default_text_settings\">\r\nPrezado(a) ACCOUNT_NAME,<br /><br />\r\nObrigado por criar seu perfil em EDIRECTORY_TITLE (DEFAULT_URL).<br />\r\nClique no link abaixo para ativar sua conta.<br />\r\nLINK_ACTIVATE_ACCOUNT<br />\r\nUma vez ativada, você poderá fazer login e gerenciar sua conta com os dados abaixo.<br /><br />\r\nACCOUNT_LOGIN_INFORMATION<br /><br />\r\nAtenciosamente<br />\r\nEquipe EDIRECTORY_TITLE</div>\r\n</body>\r\n</html>'),(36,'Activity for your listing on EDIRECTORY_TITLE','Dear ACCOUNT_NAME,\r\n\r\nThank you for create your profile in EDIRECTORY_TITLE (DEFAULT_URL).\r\nClick on the link below to activate your account.\r\n\r\nLINK_ACTIVATE_ACCOUNT\r\n\r\nAfter that, you can login to manage your account with the information below.\r\n\r\nACCOUNT_LOGIN_INFORMATION\r\n\r\nRegards \r\nEDIRECTORY_TITLE Team','<html>\n<head>\n<style type=\"text/css\">\n.default_text_settings {\nfont-family: Verdana, Arial, Helvetica, sans-serif;\nfont-size: 8pt;\ncolor: #003365;\nmargin: 0;\npadding: 5px;\nbackground: #FBFBFB;\nborder: 1px solid #E9E9E9;\ntext-align: justify;\n};\n</style>\n</head>\n<body>\n<div class=\"default_text_settings\">\nDear ACCOUNT_NAME,<br /><br />\nThank you for create your profile in EDIRECTORY_TITLE (DEFAULT_URL).<br />\nClick on the link below to activate your account.<br />\nLINK_ACTIVATE_ACCOUNT<br />\nAfter that, you can login to manage your account with the e-mail and password below.<br /><br />\nACCOUNT_LOGIN_INFORMATION<br /><br />\r\nRegards<br />\r\nEDIRECTORY_TITLE Team</div>\r\n</body>\n</html>'),(37,'[EDIRECTORY_TITLE] Deal Redeemed Notification','Dear ACCOUNT_NAME,\r\n\r\nThank you for create your profile in EDIRECTORY_TITLE (DEFAULT_URL).\r\nClick on the link below to activate your account.\r\n\r\nLINK_ACTIVATE_ACCOUNT\r\n\r\nAfter that, you can login to manage your account with the information below.\r\n\r\nACCOUNT_LOGIN_INFORMATION\r\n\r\nRegards \r\nEDIRECTORY_TITLE Team','<html>\n<head>\n<style type=\"text/css\">\n.default_text_settings {\nfont-family: Verdana, Arial, Helvetica, sans-serif;\nfont-size: 8pt;\ncolor: #003365;\nmargin: 0;\npadding: 5px;\nbackground: #FBFBFB;\nborder: 1px solid #E9E9E9;\ntext-align: justify;\n};\n</style>\n</head>\n<body>\n<div class=\"default_text_settings\">\nDear ACCOUNT_NAME,<br /><br />\nThank you for create your profile in EDIRECTORY_TITLE (DEFAULT_URL).<br />\nClick on the link below to activate your account.<br />\nLINK_ACTIVATE_ACCOUNT<br />\nAfter that, you can login to manage your account with the e-mail and password below.<br /><br />\nACCOUNT_LOGIN_INFORMATION<br /><br />\r\nRegards<br />\r\nEDIRECTORY_TITLE Team</div>\r\n</body>\n</html>'),(38,'[EDIRECTORY_TITLE] Deal Redeemed','Dear ACCOUNT_NAME,\r\n\r\nThank you for create your profile in EDIRECTORY_TITLE (DEFAULT_URL).\r\nClick on the link below to activate your account.\r\n\r\nLINK_ACTIVATE_ACCOUNT\r\n\r\nAfter that, you can login to manage your account with the information below.\r\n\r\nACCOUNT_LOGIN_INFORMATION\r\n\r\nRegards \r\nEDIRECTORY_TITLE Team','<html>\n<head>\n<style type=\"text/css\">\n.default_text_settings {\nfont-family: Verdana, Arial, Helvetica, sans-serif;\nfont-size: 8pt;\ncolor: #003365;\nmargin: 0;\npadding: 5px;\nbackground: #FBFBFB;\nborder: 1px solid #E9E9E9;\ntext-align: justify;\n};\n</style>\n</head>\n<body>\n<div class=\"default_text_settings\">\nDear ACCOUNT_NAME,<br /><br />\nThank you for create your profile in EDIRECTORY_TITLE (DEFAULT_URL).<br />\nClick on the link below to activate your account.<br />\nLINK_ACTIVATE_ACCOUNT<br />\nAfter that, you can login to manage your account with the e-mail and password below.<br /><br />\nACCOUNT_LOGIN_INFORMATION<br /><br />\r\nRegards<br />\r\nEDIRECTORY_TITLE Team</div>\r\n</body>\n</html>'),(39,'[EDIRECTORY_TITLE] Account Activation','Dear ACCOUNT_NAME,\r\n\r\nTo activate your account, please click on the link below.\r\n\r\nLINK_ACTIVATE_ACCOUNT\r\n\r\nFor further assistance please contact SITEMGR_EMAIL.\r\n\r\nRegards\r\n\r\nEDIRECTORY_TITLE Team','<html>\r\n<head>\r\n<style type=\"text/css\">\r\n.default_text_settings {\r\nfont-family: Verdana, Arial, Helvetica, sans-serif;\r\nfont-size: 8pt;\r\ncolor: #003365;\r\nmargin: 0;\r\npadding: 5px;\r\nbackground: #FBFBFB;\r\nborder: 1px solid #E9E9E9;\r\ntext-align: justify;\r\n};\r\n</style>\r\n</head>\r\n<body>\r\n<div class=\"default_text_settings\">\r\nDear ACCOUNT_NAME,<br /><br />\r\nTo activate your account, please click on the link below.<br />\r\nLINK_ACTIVATE_ACCOUNT<br />\r\nFor further assistance please contact SITEMGR_EMAIL.<br /><br />\r\nRegards<br />\r\nEDIRECTORY_TITLE Team</div>\r\n</body>\r\n</html>'),(40,'[EDIRECTORY_TITLE] New Lead Notification','Dear ACCOUNT_NAME,     Your item on EDIRECTORY_TITLE received the following lead.  LEAD_MESSAGE   You can see it in DEFAULT_URL/MEMBERS_URL/    Thank you for being a member of the EDIRECTORY_TITLE!  Regards   EDIRECTORY_TITLE Team','<html> <head> <style type=\"text/css\"> .default_text_settings { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 8pt; color: #003365; margin: 0; padding: 5px; background: #FBFBFB; border: 1px solid #E9E9E9; text-align: justify; }; </style> </head> <body> <div class=\"default_text_settings\"> Dear ACCOUNT_NAME,<br /><br /> Your item on EDIRECTORY_TITLE received the following lead.<br /><br /> LEAD_MESSAGE<br /><br /> You can see it in DEFAULT_URL/MEMBERS_URL/ <br /><br /> Thank you for being a member of the EDIRECTORY_TITLE!<br /><br /> Regards<br /> EDIRECTORY_TITLE Team</div> </body> </html>');

--
-- Table structure for table `Event`
--

CREATE TABLE `Event` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `importID` int(11) NOT NULL,
  `account_id` int(11) NOT NULL DEFAULT '0',
  `discount_id` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `seo_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `friendly_url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `image_id` int(11) NOT NULL DEFAULT '0',
  `thumb_id` int(11) NOT NULL DEFAULT '0',
  `cover_id` int(11) NOT NULL DEFAULT '0',
  `location_1` int(11) NOT NULL DEFAULT '0',
  `location_2` int(11) NOT NULL DEFAULT '0',
  `location_3` int(11) NOT NULL DEFAULT '0',
  `location_4` int(11) NOT NULL DEFAULT '0',
  `location_5` int(11) NOT NULL DEFAULT '0',
  `description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `seo_description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `long_description` text COLLATE utf8_unicode_ci NOT NULL,
  `keywords` text COLLATE utf8_unicode_ci NOT NULL,
  `seo_keywords` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `entered` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `start_date` date NOT NULL DEFAULT '0000-00-00',
  `has_start_time` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'n',
  `start_time` time NOT NULL DEFAULT '00:00:00',
  `end_date` date NOT NULL DEFAULT '0000-00-00',
  `has_end_time` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'n',
  `end_time` time NOT NULL DEFAULT '00:00:00',
  `location` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `address` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `zip_code` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `zip5` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  `latitude` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `longitude` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `maptuning` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `maptuning_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `contact_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `phone` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `renewal_date` date NOT NULL DEFAULT '0000-00-00',
  `status` char(1) COLLATE utf8_unicode_ci NOT NULL,
  `suspended_sitemgr` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'n',
  `level` tinyint(3) NOT NULL DEFAULT '0',
  `random_number` bigint(15) NOT NULL DEFAULT '0',
  `cat_1_id` int(11) NOT NULL DEFAULT '0',
  `parcat_1_level1_id` int(11) NOT NULL DEFAULT '0',
  `parcat_1_level2_id` int(11) NOT NULL DEFAULT '0',
  `parcat_1_level3_id` int(11) NOT NULL DEFAULT '0',
  `parcat_1_level4_id` int(11) NOT NULL DEFAULT '0',
  `cat_2_id` int(11) NOT NULL DEFAULT '0',
  `parcat_2_level1_id` int(11) NOT NULL DEFAULT '0',
  `parcat_2_level2_id` int(11) NOT NULL DEFAULT '0',
  `parcat_2_level3_id` int(11) NOT NULL DEFAULT '0',
  `parcat_2_level4_id` int(11) NOT NULL DEFAULT '0',
  `cat_3_id` int(11) NOT NULL DEFAULT '0',
  `parcat_3_level1_id` int(11) NOT NULL DEFAULT '0',
  `parcat_3_level2_id` int(11) NOT NULL DEFAULT '0',
  `parcat_3_level3_id` int(11) NOT NULL DEFAULT '0',
  `parcat_3_level4_id` int(11) NOT NULL DEFAULT '0',
  `cat_4_id` int(11) NOT NULL DEFAULT '0',
  `parcat_4_level1_id` int(11) NOT NULL DEFAULT '0',
  `parcat_4_level2_id` int(11) NOT NULL DEFAULT '0',
  `parcat_4_level3_id` int(11) NOT NULL DEFAULT '0',
  `parcat_4_level4_id` int(11) NOT NULL DEFAULT '0',
  `cat_5_id` int(11) NOT NULL DEFAULT '0',
  `parcat_5_level1_id` int(11) NOT NULL DEFAULT '0',
  `parcat_5_level2_id` int(11) NOT NULL DEFAULT '0',
  `parcat_5_level3_id` int(11) NOT NULL DEFAULT '0',
  `parcat_5_level4_id` int(11) NOT NULL DEFAULT '0',
  `fulltextsearch_keyword` text COLLATE utf8_unicode_ci NOT NULL,
  `fulltextsearch_where` text COLLATE utf8_unicode_ci NOT NULL,
  `video_snippet` text COLLATE utf8_unicode_ci NOT NULL,
  `video_url` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `recurring` char(1) COLLATE utf8_unicode_ci NOT NULL,
  `day` int(3) NOT NULL DEFAULT '0',
  `dayofweek` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
  `week` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `month` int(3) NOT NULL DEFAULT '0',
  `until_date` date DEFAULT '0000-00-00',
  `repeat_event` char(1) COLLATE utf8_unicode_ci NOT NULL,
  `number_views` int(11) NOT NULL DEFAULT '0',
  `map_zoom` int(11) NOT NULL,
  `package_id` int(11) NOT NULL,
  `package_price` decimal(10,2) NOT NULL,
  `custom_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `friendly_url_2` (`friendly_url`),
  KEY `start_date` (`start_date`),
  KEY `end_date` (`end_date`),
  KEY `account_id` (`account_id`),
  KEY `latitude` (`latitude`),
  KEY `longitude` (`longitude`),
  KEY `country_id` (`location_1`),
  KEY `state_id` (`location_2`),
  KEY `region_id` (`location_3`),
  KEY `status` (`status`),
  KEY `level` (`level`),
  KEY `city_id` (`location_4`),
  KEY `area_id` (`location_5`),
  KEY `title` (`title`),
  KEY `friendly_url` (`friendly_url`),
  KEY `random_number` (`random_number`),
  KEY `cat_1_id` (`cat_1_id`),
  KEY `parcat_1_level1_id` (`parcat_1_level1_id`),
  KEY `cat_2_id` (`cat_2_id`),
  KEY `parcat_2_level1_id` (`parcat_2_level1_id`),
  KEY `cat_3_id` (`cat_3_id`),
  KEY `parcat_3_level1_id` (`parcat_3_level1_id`),
  KEY `cat_4_id` (`cat_4_id`),
  KEY `parcat_4_level1_id` (`parcat_4_level1_id`),
  KEY `cat_5_id` (`cat_5_id`),
  KEY `parcat_5_level1_id` (`parcat_5_level1_id`),
  FULLTEXT KEY `fulltextsearch_keyword` (`fulltextsearch_keyword`),
  FULLTEXT KEY `fulltextsearch_where` (`fulltextsearch_where`),
  FULLTEXT KEY `fulltextsearch_title` (`title`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Event`
--


--
-- Table structure for table `EventCategory`
--

CREATE TABLE `EventCategory` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `category_id` int(11) NOT NULL DEFAULT '0',
  `thumb_id` int(11) NOT NULL DEFAULT '0',
  `image_id` int(11) NOT NULL DEFAULT '0',
  `featured` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'n',
  `summary_description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `seo_description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `page_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `friendly_url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `keywords` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `seo_keywords` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `content` text COLLATE utf8_unicode_ci,
  `active_event` int(11) NOT NULL DEFAULT '0',
  `enabled` char(1) COLLATE utf8_unicode_ci NOT NULL,
  `count_sub` int(5) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `category_id` (`category_id`),
  KEY `active_event` (`active_event`),
  KEY `title2` (`title`),
  KEY `friendly_url2` (`friendly_url`),
  FULLTEXT KEY `keywords` (`keywords`,`title`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `EventCategory`
--


--
-- Table structure for table `EventLevel`
--

CREATE TABLE `EventLevel` (
  `value` int(3) NOT NULL DEFAULT '0',
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `defaultlevel` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'n',
  `detail` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'y',
  `images` int(3) NOT NULL DEFAULT '0',
  `price` decimal(10,2) NOT NULL DEFAULT '0.00',
  `active` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'y',
  `popular` char(1) COLLATE utf8_unicode_ci NOT NULL,
  `featured` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `content` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`value`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `EventLevel`
--

INSERT INTO `EventLevel` VALUES (50,'prata','n','n',0,0.00,'y','','',''),(30,'ouro','n','n',0,25.00,'y','','',''),(10,'diamante','y','y',3,50.00,'y','y','y','');

--
-- Table structure for table `EventLevel_Field`
--

CREATE TABLE `EventLevel_Field` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `level` int(3) NOT NULL,
  `field` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `theme` (`level`)
) ENGINE=MyISAM AUTO_INCREMENT=111 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `EventLevel_Field`
--

INSERT INTO `EventLevel_Field` VALUES (102,10,'summary_description'),(101,30,'summary_description'),(95,10,'email'),(96,10,'url'),(104,10,'contact_name'),(108,10,'end_time'),(107,10,'start_time'),(106,30,'end_time'),(105,30,'start_time'),(103,10,'long_description'),(110,10,'main_image'),(109,30,'main_image'),(99,10,'phone'),(98,30,'phone'),(97,50,'phone'),(100,10,'video');

--
-- Table structure for table `Event_LocationCounter`
--

CREATE TABLE `Event_LocationCounter` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `location_level` int(11) NOT NULL,
  `location_id` int(11) NOT NULL,
  `count` int(11) NOT NULL,
  `title` varchar(255) CHARACTER SET utf8 NOT NULL,
  `full_friendly_url` varchar(255) CHARACTER SET utf8 NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Event_LocationCounter`
--


--
-- Table structure for table `FAQ`
--

CREATE TABLE `FAQ` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sitemgr` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'n',
  `member` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'n',
  `frontend` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'n',
  `question` text COLLATE utf8_unicode_ci NOT NULL,
  `answer` text COLLATE utf8_unicode_ci NOT NULL,
  `editable` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'y',
  `keyword` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  FULLTEXT KEY `keyword` (`keyword`)
) ENGINE=MyISAM AUTO_INCREMENT=89 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `FAQ`
--



--
-- Table structure for table `Gallery`
--

CREATE TABLE `Gallery` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `account_id` int(11) NOT NULL DEFAULT '0',
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `entered` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  KEY `account_id` (`account_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Gallery`
--


--
-- Table structure for table `Gallery_Image`
--

CREATE TABLE `Gallery_Image` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `gallery_id` int(11) NOT NULL DEFAULT '0',
  `image_id` int(11) NOT NULL DEFAULT '0',
  `image_caption` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `thumb_id` int(11) NOT NULL DEFAULT '0',
  `thumb_caption` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `image_default` varchar(1) COLLATE utf8_unicode_ci NOT NULL,
  `order` int(3) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `gallery_id` (`gallery_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Gallery_Image`
--


--
-- Table structure for table `Gallery_Item`
--

CREATE TABLE `Gallery_Item` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `item_type` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `item_id` int(11) NOT NULL DEFAULT '0',
  `gallery_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `item_type` (`item_type`),
  KEY `item_id` (`item_id`),
  KEY `gallery_id` (`gallery_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Gallery_Item`
--


--
-- Table structure for table `Gallery_Temp`
--

CREATE TABLE `Gallery_Temp` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `image_id` int(11) NOT NULL,
  `image_caption` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `thumb_id` int(11) NOT NULL,
  `thumb_caption` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `image_default` char(1) COLLATE utf8_unicode_ci NOT NULL,
  `sess_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Gallery_Temp`
--


--
-- Table structure for table `Image`
--

CREATE TABLE `Image` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` set('JPG','GIF','SWF','PNG') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'JPG',
  `width` smallint(6) NOT NULL DEFAULT '0',
  `height` smallint(6) NOT NULL DEFAULT '0',
  `prefix` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Image`
--


--
-- Table structure for table `ImportLog`
--

CREATE TABLE `ImportLog` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date` date NOT NULL DEFAULT '0000-00-00',
  `time` time NOT NULL DEFAULT '00:00:00',
  `filename` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `linesadded` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `phisicalname` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `status` char(1) COLLATE utf8_unicode_ci NOT NULL,
  `action` char(2) COLLATE utf8_unicode_ci NOT NULL,
  `progress` char(5) COLLATE utf8_unicode_ci NOT NULL,
  `totallines` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `errorlines` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `itens_added` int(11) NOT NULL,
  `accounts_added` int(11) NOT NULL,
  `history` longtext COLLATE utf8_unicode_ci NOT NULL,
  `update_itens` varchar(1) COLLATE utf8_unicode_ci NOT NULL,
  `from_export` char(1) COLLATE utf8_unicode_ci NOT NULL,
  `active_item` char(1) COLLATE utf8_unicode_ci NOT NULL,
  `update_friendlyurl` char(1) COLLATE utf8_unicode_ci NOT NULL,
  `featured_categs` char(1) COLLATE utf8_unicode_ci NOT NULL,
  `default_level` char(3) COLLATE utf8_unicode_ci NOT NULL,
  `same_account` char(1) COLLATE utf8_unicode_ci NOT NULL,
  `account_id` int(11) NOT NULL,
  `delimiter` varchar(3) COLLATE utf8_unicode_ci NOT NULL,
  `mysqlerror` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `type` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'listing',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ImportLog`
--


--
-- Table structure for table `ImportTemporary`
--

CREATE TABLE `ImportTemporary` (
  `id` bigint(255) NOT NULL AUTO_INCREMENT,
  `import_log_id` int(11) NOT NULL DEFAULT '0',
  `account_username` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `account_password` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `account_first_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `account_last_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `account_company` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `account_address` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `account_address2` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `account_country` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `account_state` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `account_city` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `account_zip` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `account_phone` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `account_fax` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `account_email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `account_url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `listing_id` int(11) DEFAULT '0',
  `listing_title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `listing_seo_title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `listing_email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `listing_url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `listing_address` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `listing_address2` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `listing_location1` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `listing_location1_abbreviation` char(5) COLLATE utf8_unicode_ci DEFAULT NULL,
  `listing_location2` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `listing_location2_abbreviation` char(5) COLLATE utf8_unicode_ci DEFAULT NULL,
  `listing_location3` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `listing_location3_abbreviation` char(5) COLLATE utf8_unicode_ci DEFAULT NULL,
  `listing_location4` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `listing_location4_abbreviation` char(5) COLLATE utf8_unicode_ci DEFAULT NULL,
  `listing_location5` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `listing_location5_abbreviation` char(5) COLLATE utf8_unicode_ci DEFAULT NULL,
  `listing_zip` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `listing_latitude` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `listing_longitude` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `listing_phone` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `listing_fax` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `listing_description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `listing_long_description` text COLLATE utf8_unicode_ci,
  `listing_seo_description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `listing_keyword` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `listing_renewal_date` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `listing_status` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `listing_level` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `listing_category_1` text COLLATE utf8_unicode_ci,
  `listing_category_2` text COLLATE utf8_unicode_ci,
  `listing_category_3` text COLLATE utf8_unicode_ci,
  `listing_category_4` text COLLATE utf8_unicode_ci,
  `listing_category_5` text COLLATE utf8_unicode_ci,
  `listing_template` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `custom_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `file_line_number` int(11) NOT NULL DEFAULT '0',
  `inserted` varchar(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'n',
  `error` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'n',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ImportTemporary`
--


--
-- Table structure for table `ImportTemporary_Event`
--

CREATE TABLE `ImportTemporary_Event` (
  `id` bigint(255) NOT NULL AUTO_INCREMENT,
  `import_log_id` int(11) NOT NULL DEFAULT '0',
  `account_username` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `account_password` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `account_first_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `account_last_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `account_company` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `account_address` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `account_address2` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `account_country` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `account_state` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `account_city` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `account_zip` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `account_phone` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `account_fax` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `account_email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `account_url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `event_id` int(11) DEFAULT '0',
  `event_title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `event_seo_title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `event_email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `event_url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `event_address` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `event_locationname` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `event_contactname` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `event_startdate` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `event_enddate` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `event_starttime` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `event_starttime_mode` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `event_endtime` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `event_endtime_mode` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `event_location1` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `event_location1_abbreviation` char(5) COLLATE utf8_unicode_ci DEFAULT NULL,
  `event_location2` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `event_location2_abbreviation` char(5) COLLATE utf8_unicode_ci DEFAULT NULL,
  `event_location3` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `event_location3_abbreviation` char(5) COLLATE utf8_unicode_ci DEFAULT NULL,
  `event_location4` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `event_location4_abbreviation` char(5) COLLATE utf8_unicode_ci DEFAULT NULL,
  `event_location5` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `event_location5_abbreviation` char(5) COLLATE utf8_unicode_ci DEFAULT NULL,
  `event_zip` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `event_latitude` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `event_longitude` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `event_phone` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `event_description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `event_long_description` text COLLATE utf8_unicode_ci,
  `event_seo_description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `event_keyword` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `event_renewal_date` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `event_status` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `event_level` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `event_category_1` text COLLATE utf8_unicode_ci,
  `event_category_2` text COLLATE utf8_unicode_ci,
  `event_category_3` text COLLATE utf8_unicode_ci,
  `event_category_4` text COLLATE utf8_unicode_ci,
  `event_category_5` text COLLATE utf8_unicode_ci,
  `custom_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `file_line_number` int(11) NOT NULL DEFAULT '0',
  `inserted` varchar(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'n',
  `error` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'n',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ImportTemporary_Event`
--


--
-- Table structure for table `Invoice`
--

CREATE TABLE `Invoice` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `account_id` int(11) NOT NULL DEFAULT '0',
  `username` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `ip` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL,
  `date` datetime DEFAULT NULL,
  `status` char(1) COLLATE utf8_unicode_ci DEFAULT NULL,
  `subtotal_amount` decimal(10,2) DEFAULT NULL,
  `tax_amount` decimal(10,2) NOT NULL DEFAULT '0.00',
  `amount` decimal(10,2) DEFAULT NULL,
  `currency` char(3) COLLATE utf8_unicode_ci NOT NULL,
  `expire_date` date DEFAULT NULL,
  `payment_date` datetime DEFAULT NULL,
  `hidden` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'n',
  PRIMARY KEY (`id`),
  KEY `account_id` (`account_id`),
  KEY `date` (`date`),
  KEY `status` (`status`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Invoice`
--


--
-- Table structure for table `Invoice_Article`
--

CREATE TABLE `Invoice_Article` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `invoice_id` int(11) NOT NULL DEFAULT '0',
  `article_id` int(11) NOT NULL DEFAULT '0',
  `article_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `discount_id` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `level` tinyint(4) DEFAULT NULL,
  `level_label` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `renewal_date` date DEFAULT NULL,
  `amount` decimal(10,2) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `invoice_id` (`invoice_id`),
  KEY `article_id` (`article_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Invoice_Article`
--


--
-- Table structure for table `Invoice_Banner`
--

CREATE TABLE `Invoice_Banner` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `invoice_id` int(11) NOT NULL DEFAULT '0',
  `banner_id` int(11) NOT NULL DEFAULT '0',
  `banner_caption` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `discount_id` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `level` tinyint(4) DEFAULT NULL,
  `level_label` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `renewal_date` date DEFAULT NULL,
  `impressions` mediumint(9) NOT NULL DEFAULT '0',
  `amount` decimal(10,2) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `invoice_id` (`invoice_id`),
  KEY `banner_id` (`banner_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Invoice_Banner`
--


--
-- Table structure for table `Invoice_Classified`
--

CREATE TABLE `Invoice_Classified` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `invoice_id` int(11) NOT NULL DEFAULT '0',
  `classified_id` int(11) NOT NULL DEFAULT '0',
  `classified_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `discount_id` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `level` tinyint(4) DEFAULT NULL,
  `level_label` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `renewal_date` date DEFAULT NULL,
  `amount` decimal(10,2) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `invoice_id` (`invoice_id`),
  KEY `classified_id` (`classified_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Invoice_Classified`
--


--
-- Table structure for table `Invoice_CustomInvoice`
--

CREATE TABLE `Invoice_CustomInvoice` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `invoice_id` int(11) NOT NULL DEFAULT '0',
  `custom_invoice_id` int(11) NOT NULL DEFAULT '0',
  `title` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `items` text COLLATE utf8_unicode_ci NOT NULL,
  `items_price` text COLLATE utf8_unicode_ci NOT NULL,
  `subtotal` decimal(10,2) NOT NULL,
  `tax` decimal(10,2) NOT NULL DEFAULT '0.00',
  `amount` decimal(10,2) NOT NULL DEFAULT '0.00',
  PRIMARY KEY (`id`),
  KEY `invoice_id` (`invoice_id`),
  KEY `custom_invoice_id` (`custom_invoice_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Invoice_CustomInvoice`
--


--
-- Table structure for table `Invoice_Event`
--

CREATE TABLE `Invoice_Event` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `invoice_id` int(11) NOT NULL DEFAULT '0',
  `event_id` int(11) NOT NULL DEFAULT '0',
  `event_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `discount_id` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `level` tinyint(4) DEFAULT NULL,
  `level_label` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `renewal_date` date DEFAULT NULL,
  `amount` decimal(10,2) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `invoice_id` (`invoice_id`),
  KEY `event_id` (`event_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Invoice_Event`
--


--
-- Table structure for table `Invoice_Listing`
--

CREATE TABLE `Invoice_Listing` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `invoice_id` int(11) NOT NULL DEFAULT '0',
  `listing_id` int(11) NOT NULL DEFAULT '0',
  `listing_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `discount_id` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `level` tinyint(4) DEFAULT NULL,
  `level_label` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `renewal_date` date DEFAULT NULL,
  `categories` tinyint(4) NOT NULL,
  `extra_categories` tinyint(4) NOT NULL DEFAULT '0',
  `listingtemplate_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `amount` decimal(10,2) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `invoice_id` (`invoice_id`),
  KEY `listing_id` (`listing_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Invoice_Listing`
--


--
-- Table structure for table `Invoice_Package`
--

CREATE TABLE `Invoice_Package` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `invoice_id` int(11) NOT NULL DEFAULT '0',
  `package_id` int(11) NOT NULL DEFAULT '0',
  `package_title` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `items` text COLLATE utf8_unicode_ci NOT NULL,
  `items_price` text COLLATE utf8_unicode_ci NOT NULL,
  `subtotal` decimal(10,2) NOT NULL,
  `tax` decimal(10,2) NOT NULL DEFAULT '0.00',
  `amount` decimal(10,2) NOT NULL DEFAULT '0.00',
  PRIMARY KEY (`id`),
  KEY `invoice_id` (`invoice_id`),
  KEY `package_id` (`package_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Invoice_Package`
--


--
-- Table structure for table `ItemStatistic`
--

CREATE TABLE `ItemStatistic` (
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `value` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ItemStatistic`
--


--
-- Table structure for table `Lang`
--

CREATE TABLE `Lang` (
  `id_number` int(11) NOT NULL AUTO_INCREMENT,
  `id` char(5) COLLATE utf8_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `lang_enabled` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'n',
  `lang_default` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'n',
  `lang_order` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_number`),
  KEY `name` (`name`),
  KEY `enabled` (`lang_enabled`),
  KEY `default` (`lang_default`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Lang`
--

INSERT INTO `Lang` VALUES (1,'en_us','English','n','n',1),(2,'pt_br','Português','y','y',0),(3,'es_es','Español','n','n',3),(4,'fr_fr','Français','n','n',4),(5,'it_it','Italiano','n','n',2),(6,'ge_ge','Deutsch','n','n',5),(7,'tr_tr','Türkçe','n','n',6);

--
-- Table structure for table `Leads`
--

CREATE TABLE `Leads` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `item_id` int(11) NOT NULL,
  `member_id` int(11) NOT NULL,
  `type` varchar(10) COLLATE utf8_unicode_ci NOT NULL COMMENT 'listing/event/classified/general',
  `first_name` varchar(25) COLLATE utf8_unicode_ci NOT NULL,
  `last_name` varchar(25) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `phone` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `subject` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `message` text COLLATE utf8_unicode_ci NOT NULL,
  `entered` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `reply_date` datetime DEFAULT '0000-00-00 00:00:00',
  `forward_date` datetime DEFAULT '0000-00-00 00:00:00',
  `status` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'P' COMMENT 'A : read / P: unread',
  `new` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'y' COMMENT 'y/n',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Leads`
--


--
-- Table structure for table `Listing`
--

CREATE TABLE `Listing` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `account_id` int(11) NOT NULL DEFAULT '0',
  `image_id` int(11) NOT NULL DEFAULT '0',
  `thumb_id` int(11) NOT NULL DEFAULT '0',
  `cover_id` int(11) NOT NULL DEFAULT '0',
  `promotion_id` int(11) NOT NULL DEFAULT '0',
  `location_1` int(11) NOT NULL DEFAULT '0',
  `location_2` int(11) NOT NULL DEFAULT '0',
  `location_3` int(11) NOT NULL DEFAULT '0',
  `location_4` int(11) NOT NULL DEFAULT '0',
  `location_5` int(11) NOT NULL DEFAULT '0',
  `updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `entered` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `renewal_date` date NOT NULL DEFAULT '0000-00-00',
  `discount_id` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `seo_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `friendly_url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `show_email` enum('y','n') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'y',
  `url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `display_url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `address` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `address2` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `zip_code` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `zip5` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  `latitude` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `longitude` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `maptuning` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `maptuning_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `phone` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `fax` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `seo_description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `long_description` text COLLATE utf8_unicode_ci NOT NULL,
  `keywords` text COLLATE utf8_unicode_ci NOT NULL,
  `seo_keywords` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `attachment_file` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `attachment_caption` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `features` text COLLATE utf8_unicode_ci NOT NULL,
  `price` int(10) DEFAULT NULL COMMENT 'price range (1-4)',
  `facebook_page` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `status` char(1) COLLATE utf8_unicode_ci NOT NULL,
  `suspended_sitemgr` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'n',
  `level` tinyint(3) NOT NULL DEFAULT '0',
  `random_number` bigint(15) NOT NULL DEFAULT '0',
  `reminder` tinyint(4) NOT NULL DEFAULT '0',
  `fulltextsearch_keyword` text COLLATE utf8_unicode_ci NOT NULL,
  `fulltextsearch_where` text COLLATE utf8_unicode_ci NOT NULL,
  `video_snippet` text COLLATE utf8_unicode_ci NOT NULL,
  `video_url` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `video_description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `importID` int(11) NOT NULL DEFAULT '0',
  `hours_work` text COLLATE utf8_unicode_ci NOT NULL,
  `locations` text COLLATE utf8_unicode_ci NOT NULL,
  `claim_disable` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'n',
  `listingtemplate_id` int(11) DEFAULT NULL,
  `custom_checkbox0` char(1) COLLATE utf8_unicode_ci NOT NULL,
  `custom_checkbox1` char(1) COLLATE utf8_unicode_ci NOT NULL,
  `custom_checkbox2` char(1) COLLATE utf8_unicode_ci NOT NULL,
  `custom_checkbox3` char(1) COLLATE utf8_unicode_ci NOT NULL,
  `custom_checkbox4` char(1) COLLATE utf8_unicode_ci NOT NULL,
  `custom_checkbox5` char(1) COLLATE utf8_unicode_ci NOT NULL,
  `custom_checkbox6` char(1) COLLATE utf8_unicode_ci NOT NULL,
  `custom_checkbox7` char(1) COLLATE utf8_unicode_ci NOT NULL,
  `custom_checkbox8` char(1) COLLATE utf8_unicode_ci NOT NULL,
  `custom_checkbox9` char(1) COLLATE utf8_unicode_ci NOT NULL,
  `custom_dropdown0` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `custom_dropdown1` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `custom_dropdown2` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `custom_dropdown3` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `custom_dropdown4` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `custom_dropdown5` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `custom_dropdown6` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `custom_dropdown7` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `custom_dropdown8` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `custom_dropdown9` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `custom_text0` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `custom_text1` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `custom_text2` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `custom_text3` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `custom_text4` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `custom_text5` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `custom_text6` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `custom_text7` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `custom_text8` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `custom_text9` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `custom_short_desc0` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `custom_short_desc1` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `custom_short_desc2` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `custom_short_desc3` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `custom_short_desc4` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `custom_short_desc5` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `custom_short_desc6` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `custom_short_desc7` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `custom_short_desc8` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `custom_short_desc9` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `custom_long_desc0` text COLLATE utf8_unicode_ci NOT NULL,
  `custom_long_desc1` text COLLATE utf8_unicode_ci NOT NULL,
  `custom_long_desc2` text COLLATE utf8_unicode_ci NOT NULL,
  `custom_long_desc3` text COLLATE utf8_unicode_ci NOT NULL,
  `custom_long_desc4` text COLLATE utf8_unicode_ci NOT NULL,
  `custom_long_desc5` text COLLATE utf8_unicode_ci NOT NULL,
  `custom_long_desc6` text COLLATE utf8_unicode_ci NOT NULL,
  `custom_long_desc7` text COLLATE utf8_unicode_ci NOT NULL,
  `custom_long_desc8` text COLLATE utf8_unicode_ci NOT NULL,
  `custom_long_desc9` text COLLATE utf8_unicode_ci NOT NULL,
  `number_views` int(11) NOT NULL DEFAULT '0',
  `avg_review` int(11) NOT NULL DEFAULT '0',
  `map_zoom` int(11) NOT NULL,
  `package_id` int(11) NOT NULL,
  `package_price` decimal(10,2) NOT NULL,
  `backlink` varchar(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'n',
  `backlink_url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `clicktocall_number` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL,
  `clicktocall_extension` int(5) DEFAULT NULL,
  `clicktocall_date` date DEFAULT NULL,
  `last_traffic_sent` date NOT NULL,
  `custom_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `friendly_url_2` (`friendly_url`),
  KEY `title` (`title`),
  KEY `random_number` (`random_number`),
  KEY `country_id` (`location_1`),
  KEY `state_id` (`location_2`),
  KEY `region_id` (`location_3`),
  KEY `account_id` (`account_id`),
  KEY `renewal_date` (`renewal_date`),
  KEY `status` (`status`),
  KEY `promotion_id` (`promotion_id`),
  KEY `latitude` (`latitude`),
  KEY `longitude` (`longitude`),
  KEY `level` (`level`),
  KEY `city_id` (`location_4`),
  KEY `area_id` (`location_5`),
  KEY `zip_code` (`zip_code`),
  KEY `friendly_url` (`friendly_url`),
  KEY `listingtemplate_id` (`listingtemplate_id`),
  KEY `image_id` (`image_id`),
  KEY `thumb_id` (`thumb_id`),
  KEY `idx_fulltextsearch_keyword` (`fulltextsearch_keyword`(3)),
  KEY `idx_fulltextsearch_where` (`fulltextsearch_where`(3)),
  KEY `updated_date` (`updated`),
  KEY `clicktocall_number` (`clicktocall_number`),
  KEY `Listing_Promotion` (`level`,`promotion_id`,`account_id`,`title`,`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Listing`
--


--
-- Table structure for table `ListingCategory`
--

CREATE TABLE `ListingCategory` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `root_id` int(11) DEFAULT '0',
  `left` int(11) DEFAULT '0',
  `right` int(11) DEFAULT '0',
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `category_id` int(11) NOT NULL DEFAULT '0',
  `thumb_id` int(11) NOT NULL DEFAULT '0',
  `image_id` int(11) NOT NULL DEFAULT '0',
  `featured` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'n',
  `summary_description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `seo_description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `page_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `friendly_url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `keywords` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `seo_keywords` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `content` text COLLATE utf8_unicode_ci,
  `active_listing` int(11) NOT NULL DEFAULT '0',
  `full_friendly_url` text COLLATE utf8_unicode_ci,
  `enabled` char(1) COLLATE utf8_unicode_ci NOT NULL,
  `count_sub` int(5) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `category_id` (`category_id`),
  KEY `active_listing` (`active_listing`),
  KEY `title2` (`title`),
  KEY `friendly_url2` (`friendly_url`),
  KEY `right` (`right`),
  KEY `root_id` (`root_id`),
  KEY `left` (`left`),
  KEY `cat_tree` (`root_id`,`left`,`right`),
  KEY `category_id_2` (`category_id`,`active_listing`),
  FULLTEXT KEY `keywords` (`keywords`,`title`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ListingCategory`
--


--
-- Table structure for table `ListingLevel`
--

CREATE TABLE `ListingLevel` (
  `value` int(3) NOT NULL DEFAULT '0',
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `defaultlevel` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'n',
  `detail` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'n',
  `images` int(3) NOT NULL DEFAULT '0',
  `has_promotion` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'n',
  `has_review` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'y',
  `has_sms` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'n',
  `has_call` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'n',
  `backlink` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'n',
  `price` decimal(10,2) NOT NULL DEFAULT '0.00',
  `free_category` int(3) NOT NULL DEFAULT '0',
  `category_price` decimal(10,2) NOT NULL DEFAULT '0.00',
  `active` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'y',
  `popular` char(1) COLLATE utf8_unicode_ci NOT NULL,
  `featured` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `content` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`value`),
  KEY `active_value` (`active`,`value`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ListingLevel`
--

INSERT INTO `ListingLevel` VALUES (70,'bronze','n','n',0,'y','n','n','n','n',0.00,1,20.00,'y','','',''),(50,'prata','n','n',0,'y','y','n','n','n',0.00,1,20.00,'y','','',''),(30,'ouro','n','n',0,'y','y','n','n','n',199.00,2,18.00,'y','','',''),(10,'diamante','y','y',9,'y','y','n','n','y',299.00,3,15.00,'y','y','y','');

--
-- Table structure for table `ListingLevel_Field`
--

CREATE TABLE `ListingLevel_Field` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `level` int(3) NOT NULL,
  `field` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `theme` (`level`)
) ENGINE=MyISAM AUTO_INCREMENT=176 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ListingLevel_Field`
--

INSERT INTO `ListingLevel_Field` VALUES (167,10,'summary_description'),(154,10,'email'),(161,10,'phone'),(157,10,'url'),(163,10,'fax'),(164,10,'video'),(165,10,'attachment_file'),(168,10,'long_description'),(169,10,'hours_of_work'),(172,10,'locations'),(171,10,'badges'),(173,10,'main_image'),(166,30,'summary_description'),(153,30,'email'),(160,30,'phone'),(156,30,'url'),(162,30,'fax'),(170,30,'badges'),(152,50,'email'),(159,50,'phone'),(155,50,'url'),(158,70,'phone'),(174,10,'fbpage'),(175,10,'features');

--
-- Table structure for table `ListingTemplate`
--

CREATE TABLE `ListingTemplate` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `layout_id` int(11) NOT NULL DEFAULT '0',
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `updated` datetime NOT NULL,
  `entered` datetime NOT NULL,
  `status` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `price` decimal(10,2) NOT NULL DEFAULT '0.00',
  `cat_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `editable` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'y',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ListingTemplate`
--

INSERT INTO `ListingTemplate` VALUES (1,0,'Listing','0000-00-00 00:00:00','0000-00-00 00:00:00','enabled',0.00,'','n');

--
-- Table structure for table `ListingTemplate_Field`
--

CREATE TABLE `ListingTemplate_Field` (
  `listingtemplate_id` int(11) NOT NULL,
  `field` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `label` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `fieldvalues` text COLLATE utf8_unicode_ci NOT NULL,
  `instructions` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `required` char(1) COLLATE utf8_unicode_ci NOT NULL,
  `search` char(1) COLLATE utf8_unicode_ci NOT NULL,
  `searchbykeyword` char(1) COLLATE utf8_unicode_ci NOT NULL,
  `searchbyrange` char(1) COLLATE utf8_unicode_ci NOT NULL,
  `show_order` int(11) NOT NULL DEFAULT '0',
  `enabled` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'y',
  PRIMARY KEY (`listingtemplate_id`,`field`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ListingTemplate_Field`
--


--
-- Table structure for table `Listing_Category`
--

CREATE TABLE `Listing_Category` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `listing_id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL,
  `category_root_id` int(11) NOT NULL,
  `category_node_left` int(11) NOT NULL,
  `category_node_right` int(11) NOT NULL,
  `status` varchar(1) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `listing_id` (`listing_id`),
  KEY `category_id` (`category_id`),
  KEY `status` (`status`),
  KEY `category_status` (`category_id`,`status`),
  KEY `category_listing_id` (`category_id`,`category_root_id`,`listing_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Listing_Category`
--


--
-- Table structure for table `Listing_Choice`
--

CREATE TABLE `Listing_Choice` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `editor_choice_id` int(11) NOT NULL DEFAULT '0',
  `listing_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `EditorChoice_has_Listing_FKIndex1` (`editor_choice_id`),
  KEY `EditorChoice_has_Listing_FKIndex2` (`listing_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Listing_Choice`
--


--
-- Table structure for table `Listing_FeaturedTemp`
--

CREATE TABLE `Listing_FeaturedTemp` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `listing_id` int(11) NOT NULL,
  `listing_level` int(11) NOT NULL,
  `random_number` bigint(15) NOT NULL,
  `status` varchar(1) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `Listing_FeaturedTemp` (`listing_level`,`status`,`listing_id`,`random_number`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Listing_FeaturedTemp`
--


--
-- Table structure for table `Listing_LocationCounter`
--

CREATE TABLE `Listing_LocationCounter` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `location_level` int(11) NOT NULL,
  `location_id` int(11) NOT NULL,
  `count` int(11) NOT NULL,
  `title` varchar(255) CHARACTER SET utf8 NOT NULL,
  `full_friendly_url` varchar(255) CHARACTER SET utf8 NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Listing_LocationCounter`
--


--
-- Table structure for table `Listing_Summary`
--

CREATE TABLE `Listing_Summary` (
  `id` int(11) NOT NULL,
  `account_id` int(11) NOT NULL,
  `location_1` int(11) NOT NULL,
  `location_1_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `location_1_abbreviation` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `location_1_friendly_url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `location_2` int(11) NOT NULL,
  `location_2_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `location_2_abbreviation` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `location_2_friendly_url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `location_3` int(11) NOT NULL,
  `location_3_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `location_3_abbreviation` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `location_3_friendly_url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `location_4` int(11) NOT NULL,
  `location_4_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `location_4_abbreviation` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `location_4_friendly_url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `location_5` int(11) NOT NULL,
  `location_5_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `location_5_abbreviation` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `location_5_friendly_url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `image_id` int(11) NOT NULL,
  `friendly_url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `show_email` enum('y','n') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'y',
  `url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `display_url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `address` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `address2` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `zip_code` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `zip5` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  `latitude` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `longitude` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `maptuning` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `phone` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `fax` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `attachment_file` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `attachment_caption` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `status` char(1) COLLATE utf8_unicode_ci NOT NULL,
  `renewal_date` date NOT NULL DEFAULT '0000-00-00',
  `level` tinyint(3) NOT NULL DEFAULT '0',
  `random_number` bigint(15) NOT NULL DEFAULT '0',
  `claim_disable` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'n',
  `locations` text COLLATE utf8_unicode_ci NOT NULL,
  `keywords` text COLLATE utf8_unicode_ci NOT NULL,
  `seo_keywords` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `fulltextsearch_keyword` text COLLATE utf8_unicode_ci NOT NULL,
  `fulltextsearch_where` text COLLATE utf8_unicode_ci NOT NULL,
  `custom_checkbox0` char(1) COLLATE utf8_unicode_ci NOT NULL,
  `custom_checkbox1` char(1) COLLATE utf8_unicode_ci NOT NULL,
  `custom_checkbox2` char(1) COLLATE utf8_unicode_ci NOT NULL,
  `custom_checkbox3` char(1) COLLATE utf8_unicode_ci NOT NULL,
  `custom_checkbox4` char(1) COLLATE utf8_unicode_ci NOT NULL,
  `custom_checkbox5` char(1) COLLATE utf8_unicode_ci NOT NULL,
  `custom_checkbox6` char(1) COLLATE utf8_unicode_ci NOT NULL,
  `custom_checkbox7` char(1) COLLATE utf8_unicode_ci NOT NULL,
  `custom_checkbox8` char(1) COLLATE utf8_unicode_ci NOT NULL,
  `custom_checkbox9` char(1) COLLATE utf8_unicode_ci NOT NULL,
  `custom_dropdown0` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `custom_dropdown1` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `custom_dropdown2` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `custom_dropdown3` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `custom_dropdown4` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `custom_dropdown5` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `custom_dropdown6` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `custom_dropdown7` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `custom_dropdown8` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `custom_dropdown9` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `custom_text0` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `custom_text1` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `custom_text2` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `custom_text3` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `custom_text4` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `custom_text5` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `custom_text6` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `custom_text7` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `custom_text8` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `custom_text9` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `custom_short_desc0` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `custom_short_desc1` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `custom_short_desc2` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `custom_short_desc3` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `custom_short_desc4` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `custom_short_desc5` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `custom_short_desc6` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `custom_short_desc7` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `custom_short_desc8` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `custom_short_desc9` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `custom_long_desc0` text COLLATE utf8_unicode_ci NOT NULL,
  `custom_long_desc1` text COLLATE utf8_unicode_ci NOT NULL,
  `custom_long_desc2` text COLLATE utf8_unicode_ci NOT NULL,
  `custom_long_desc3` text COLLATE utf8_unicode_ci NOT NULL,
  `custom_long_desc4` text COLLATE utf8_unicode_ci NOT NULL,
  `custom_long_desc5` text COLLATE utf8_unicode_ci NOT NULL,
  `custom_long_desc6` text COLLATE utf8_unicode_ci NOT NULL,
  `custom_long_desc7` text COLLATE utf8_unicode_ci NOT NULL,
  `custom_long_desc8` text COLLATE utf8_unicode_ci NOT NULL,
  `custom_long_desc9` text COLLATE utf8_unicode_ci NOT NULL,
  `number_views` int(11) NOT NULL DEFAULT '0',
  `avg_review` int(11) NOT NULL DEFAULT '0',
  `price` int(10) DEFAULT NULL COMMENT 'price range (1-4)',
  `promotion_start_date` date NOT NULL DEFAULT '0000-00-00',
  `promotion_end_date` date NOT NULL DEFAULT '0000-00-00',
  `thumb_id` int(11) NOT NULL,
  `thumb_type` set('JPG','GIF','SWF','PNG') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'JPG',
  `thumb_width` smallint(6) NOT NULL DEFAULT '0',
  `thumb_height` smallint(6) NOT NULL DEFAULT '0',
  `listingtemplate_id` int(11) NOT NULL DEFAULT '0',
  `template_layout_id` int(11) NOT NULL DEFAULT '0',
  `template_cat_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `template_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `template_status` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `template_price` decimal(10,2) NOT NULL DEFAULT '0.00',
  `updated` datetime NOT NULL,
  `entered` datetime NOT NULL,
  `promotion_id` int(11) DEFAULT NULL,
  `backlink` varchar(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'n',
  `clicktocall_number` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL,
  `clicktocall_extension` int(5) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `title` (`title`),
  KEY `title_keywords_seokeywords` (`status`,`title`(100)),
  KEY `id_status` (`id`,`status`),
  KEY `clicktocall_number` (`clicktocall_number`),
  KEY `Listing_Promotion` (`level`,`promotion_id`,`account_id`,`title`,`id`),
  KEY `rating_filter` (`level`,`status`,`avg_review`),
  KEY `price_filter` (`level`,`status`,`price`),
  FULLTEXT KEY `fulltextsearch_keyword` (`fulltextsearch_keyword`),
  FULLTEXT KEY `fulltextsearch_where` (`fulltextsearch_where`),
  FULLTEXT KEY `fulltextsearch_title` (`title`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Listing_Summary`
--


--
-- Table structure for table `MailAppList`
--

CREATE TABLE `MailAppList` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) CHARACTER SET utf8 DEFAULT NULL,
  `module` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `status` varchar(1) CHARACTER SET utf8 DEFAULT NULL COMMENT 'P=Pending, F=Finished, R=Running, E=Error',
  `filename` varchar(100) CHARACTER SET utf8 DEFAULT NULL,
  `categories` text CHARACTER SET utf8,
  `progress` int(11) DEFAULT NULL,
  `total_item_exported` int(11) NOT NULL DEFAULT '0',
  `last_account_exported` int(11) NOT NULL DEFAULT '0',
  `date` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `MailAppList`
--


--
-- Table structure for table `MailApp_Subscribers`
--

CREATE TABLE `MailApp_Subscribers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `account_id` int(11) NOT NULL,
  `subscriber_name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `subscriber_email` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `subscriber_type` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `list_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `MailApp_Subscribers`
--


--
-- Table structure for table `Payment_Article_Log`
--

CREATE TABLE `Payment_Article_Log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `payment_log_id` int(11) NOT NULL DEFAULT '0',
  `article_id` int(11) NOT NULL DEFAULT '0',
  `article_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `discount_id` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `level` tinyint(4) NOT NULL DEFAULT '0',
  `level_label` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `renewal_date` date NOT NULL DEFAULT '0000-00-00',
  `amount` decimal(10,2) NOT NULL DEFAULT '0.00',
  PRIMARY KEY (`id`),
  KEY `payment_log_id` (`payment_log_id`),
  KEY `article_id` (`article_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Payment_Article_Log`
--


--
-- Table structure for table `Payment_Banner_Log`
--

CREATE TABLE `Payment_Banner_Log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `payment_log_id` int(11) NOT NULL DEFAULT '0',
  `banner_id` int(11) NOT NULL DEFAULT '0',
  `banner_caption` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `discount_id` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `level` tinyint(4) NOT NULL DEFAULT '0',
  `level_label` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `renewal_date` date NOT NULL DEFAULT '0000-00-00',
  `impressions` mediumint(9) NOT NULL DEFAULT '0',
  `amount` decimal(10,2) NOT NULL DEFAULT '0.00',
  PRIMARY KEY (`id`),
  KEY `payment_log_id` (`payment_log_id`),
  KEY `banner_id` (`banner_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Payment_Banner_Log`
--


--
-- Table structure for table `Payment_Classified_Log`
--

CREATE TABLE `Payment_Classified_Log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `payment_log_id` int(11) NOT NULL DEFAULT '0',
  `classified_id` int(11) NOT NULL DEFAULT '0',
  `classified_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `discount_id` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `level` tinyint(4) NOT NULL DEFAULT '0',
  `level_label` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `renewal_date` date NOT NULL DEFAULT '0000-00-00',
  `amount` decimal(10,2) NOT NULL DEFAULT '0.00',
  PRIMARY KEY (`id`),
  KEY `payment_log_id` (`payment_log_id`),
  KEY `classified_id` (`classified_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Payment_Classified_Log`
--


--
-- Table structure for table `Payment_CustomInvoice_Log`
--

CREATE TABLE `Payment_CustomInvoice_Log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `payment_log_id` int(11) NOT NULL DEFAULT '0',
  `custom_invoice_id` int(11) NOT NULL DEFAULT '0',
  `title` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `items` text COLLATE utf8_unicode_ci NOT NULL,
  `items_price` text COLLATE utf8_unicode_ci NOT NULL,
  `amount` decimal(10,2) NOT NULL DEFAULT '0.00',
  PRIMARY KEY (`id`),
  KEY `payment_log_id` (`payment_log_id`),
  KEY `custom_invoice_id` (`custom_invoice_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Payment_CustomInvoice_Log`
--


--
-- Table structure for table `Payment_Event_Log`
--

CREATE TABLE `Payment_Event_Log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `payment_log_id` int(11) NOT NULL DEFAULT '0',
  `event_id` int(11) NOT NULL DEFAULT '0',
  `event_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `discount_id` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `level` tinyint(4) NOT NULL DEFAULT '0',
  `level_label` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `renewal_date` date NOT NULL DEFAULT '0000-00-00',
  `amount` decimal(10,2) NOT NULL DEFAULT '0.00',
  PRIMARY KEY (`id`),
  KEY `payment_log_id` (`payment_log_id`),
  KEY `event_id` (`event_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Payment_Event_Log`
--


--
-- Table structure for table `Payment_Listing_Log`
--

CREATE TABLE `Payment_Listing_Log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `payment_log_id` int(11) NOT NULL DEFAULT '0',
  `listing_id` int(11) NOT NULL DEFAULT '0',
  `listing_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `discount_id` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `level` tinyint(4) NOT NULL DEFAULT '0',
  `level_label` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `renewal_date` date NOT NULL DEFAULT '0000-00-00',
  `categories` tinyint(4) NOT NULL DEFAULT '0',
  `extra_categories` tinyint(4) NOT NULL DEFAULT '0',
  `listingtemplate_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `amount` decimal(10,2) NOT NULL DEFAULT '0.00',
  PRIMARY KEY (`id`),
  KEY `payment_log_id` (`payment_log_id`),
  KEY `listing_id` (`listing_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Payment_Listing_Log`
--


--
-- Table structure for table `Payment_Log`
--

CREATE TABLE `Payment_Log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `account_id` int(11) NOT NULL DEFAULT '0',
  `username` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `ip` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
  `transaction_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `transaction_status` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `transaction_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `transaction_subtotal` decimal(10,2) NOT NULL,
  `transaction_tax` decimal(10,2) NOT NULL DEFAULT '0.00',
  `transaction_amount` decimal(10,2) NOT NULL DEFAULT '0.00',
  `transaction_currency` char(3) COLLATE utf8_unicode_ci NOT NULL,
  `system_type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `recurring` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'n',
  `notes` text COLLATE utf8_unicode_ci NOT NULL,
  `return_fields` text COLLATE utf8_unicode_ci NOT NULL,
  `hidden` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'n',
  PRIMARY KEY (`id`),
  KEY `account_id` (`account_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Payment_Log`
--


--
-- Table structure for table `Payment_Package_Log`
--

CREATE TABLE `Payment_Package_Log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `payment_log_id` int(11) NOT NULL DEFAULT '0',
  `package_id` int(11) NOT NULL DEFAULT '0',
  `package_title` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `items` text COLLATE utf8_unicode_ci NOT NULL,
  `items_price` text COLLATE utf8_unicode_ci NOT NULL,
  `amount` decimal(10,2) NOT NULL DEFAULT '0.00',
  PRIMARY KEY (`id`),
  KEY `payment_log_id` (`payment_log_id`),
  KEY `package_id` (`package_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Payment_Package_Log`
--


--
-- Table structure for table `Post`
--

CREATE TABLE `Post` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `image_id` int(11) NOT NULL DEFAULT '0',
  `thumb_id` int(11) NOT NULL DEFAULT '0',
  `cover_id` int(11) NOT NULL DEFAULT '0',
  `updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `entered` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `seo_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `friendly_url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `image_caption` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `thumb_caption` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `keywords` text COLLATE utf8_unicode_ci NOT NULL,
  `seo_keywords` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `seo_abstract` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `fulltextsearch_keyword` text COLLATE utf8_unicode_ci NOT NULL,
  `fulltextsearch_where` text COLLATE utf8_unicode_ci NOT NULL,
  `content` text COLLATE utf8_unicode_ci NOT NULL,
  `status` char(1) COLLATE utf8_unicode_ci NOT NULL,
  `number_views` int(11) NOT NULL DEFAULT '0',
  `legacy_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `legacy_id` (`legacy_id`(7)),
  KEY `title` (`title`),
  KEY `status` (`status`),
  KEY `friendly_url` (`friendly_url`),
  KEY `entered` (`entered`),
  KEY `updated` (`updated`),
  FULLTEXT KEY `fulltextsearch_keyword` (`fulltextsearch_keyword`),
  FULLTEXT KEY `fulltextsearch_where` (`fulltextsearch_where`),
  FULLTEXT KEY `fulltextsearch_title` (`title`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Post`
--


--
-- Table structure for table `Promotion`
--

CREATE TABLE `Promotion` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `account_id` int(11) NOT NULL DEFAULT '0',
  `image_id` int(11) NOT NULL DEFAULT '0',
  `thumb_id` int(11) NOT NULL DEFAULT '0',
  `cover_id` int(11) NOT NULL DEFAULT '0',
  `updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `entered` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `seo_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `long_description` text COLLATE utf8_unicode_ci NOT NULL,
  `seo_description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `keywords` text COLLATE utf8_unicode_ci NOT NULL,
  `seo_keywords` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `fulltextsearch_keyword` text COLLATE utf8_unicode_ci NOT NULL,
  `fulltextsearch_where` text COLLATE utf8_unicode_ci NOT NULL,
  `start_date` date NOT NULL DEFAULT '0000-00-00',
  `end_date` date NOT NULL DEFAULT '0000-00-00',
  `random_number` bigint(15) NOT NULL DEFAULT '0',
  `conditions` text COLLATE utf8_unicode_ci NOT NULL,
  `number_views` int(11) NOT NULL DEFAULT '0',
  `visibility_start` int(11) NOT NULL,
  `visibility_end` int(11) NOT NULL,
  `realvalue` double(8,2) NOT NULL,
  `dealvalue` double(8,2) NOT NULL,
  `deal_type` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'monetary value' COMMENT 'percentage/monetary value',
  `amount` int(8) NOT NULL,
  `avg_review` int(11) NOT NULL,
  `friendly_url` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
  `listing_id` int(11) NOT NULL,
  `listing_status` char(1) COLLATE utf8_unicode_ci NOT NULL,
  `listing_level` tinyint(3) NOT NULL,
  `listing_location1` int(11) DEFAULT NULL,
  `listing_location2` int(11) DEFAULT NULL,
  `listing_location3` int(11) DEFAULT NULL,
  `listing_location4` int(11) DEFAULT NULL,
  `listing_location5` int(11) DEFAULT NULL,
  `listing_address` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `listing_address2` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `listing_zipcode` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `listing_zip5` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  `listing_latitude` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `listing_longitude` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `account_id` (`account_id`),
  KEY `start_date` (`start_date`),
  KEY `end_date` (`end_date`),
  KEY `name` (`name`),
  KEY `random_number` (`random_number`),
  KEY `listing_level` (`listing_level`),
  KEY `listing_id` (`listing_id`,`listing_status`),
  FULLTEXT KEY `fulltextsearch_keyword` (`fulltextsearch_keyword`),
  FULLTEXT KEY `fulltextsearch_where` (`fulltextsearch_where`),
  FULLTEXT KEY `fulltextsearch_title` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Promotion`
--


--
-- Table structure for table `Promotion_LocationCounter`
--

CREATE TABLE `Promotion_LocationCounter` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `location_level` int(11) NOT NULL,
  `location_id` int(11) NOT NULL,
  `count` int(11) NOT NULL,
  `title` varchar(255) CHARACTER SET utf8 NOT NULL,
  `full_friendly_url` varchar(255) CHARACTER SET utf8 NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Promotion_LocationCounter`
--


--
-- Table structure for table `Promotion_Redeem`
--

CREATE TABLE `Promotion_Redeem` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `account_id` int(11) NOT NULL,
  `profile_name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `promotion_id` int(11) NOT NULL,
  `twittered` int(11) NOT NULL,
  `facebooked` int(11) NOT NULL,
  `network_response` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
  `redeem_code` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
  `datetime` datetime NOT NULL,
  `used` smallint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `promotion_info` (`account_id`,`promotion_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Promotion_Redeem`
--


--
-- Table structure for table `Quicklist`
--

CREATE TABLE `Quicklist` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `account_id` int(11) NOT NULL,
  `item_id` int(11) NOT NULL,
  `item_type` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Quicklist`
--


--
-- Table structure for table `Report_Article`
--

CREATE TABLE `Report_Article` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `article_id` int(11) NOT NULL DEFAULT '0',
  `report_type` tinyint(1) NOT NULL DEFAULT '0',
  `report_amount` int(11) NOT NULL DEFAULT '0',
  `date` date NOT NULL DEFAULT '0000-00-00',
  PRIMARY KEY (`id`),
  UNIQUE KEY `report_info` (`article_id`,`report_type`,`date`),
  KEY `article_id` (`article_id`),
  KEY `report_type` (`report_type`),
  KEY `date` (`date`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Report_Article`
--


--
-- Table structure for table `Report_Article_Daily`
--

CREATE TABLE `Report_Article_Daily` (
  `article_id` int(11) NOT NULL DEFAULT '0',
  `day` date NOT NULL DEFAULT '0000-00-00',
  `summary_view` int(11) NOT NULL DEFAULT '0',
  `detail_view` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`article_id`,`day`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Report_Article_Daily`
--


--
-- Table structure for table `Report_Article_Monthly`
--

CREATE TABLE `Report_Article_Monthly` (
  `article_id` int(11) NOT NULL DEFAULT '0',
  `day` date NOT NULL,
  `summary_view` int(11) NOT NULL DEFAULT '0',
  `detail_view` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`article_id`,`day`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Report_Article_Monthly`
--


--
-- Table structure for table `Report_Banner`
--

CREATE TABLE `Report_Banner` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `banner_id` int(11) NOT NULL DEFAULT '0',
  `report_type` tinyint(1) NOT NULL DEFAULT '0',
  `report_amount` int(11) NOT NULL DEFAULT '0',
  `date` date NOT NULL DEFAULT '0000-00-00',
  PRIMARY KEY (`id`),
  UNIQUE KEY `report_info` (`banner_id`,`report_type`,`date`),
  KEY `banner_id` (`banner_id`),
  KEY `report_type` (`report_type`),
  KEY `date` (`date`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Report_Banner`
--


--
-- Table structure for table `Report_Banner_Daily`
--

CREATE TABLE `Report_Banner_Daily` (
  `banner_id` int(11) NOT NULL DEFAULT '0',
  `day` date NOT NULL DEFAULT '0000-00-00',
  `view` int(11) NOT NULL DEFAULT '0',
  `click_thru` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`banner_id`,`day`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Report_Banner_Daily`
--


--
-- Table structure for table `Report_Banner_Monthly`
--

CREATE TABLE `Report_Banner_Monthly` (
  `banner_id` int(11) NOT NULL DEFAULT '0',
  `day` date NOT NULL,
  `view` int(11) NOT NULL DEFAULT '0',
  `click_thru` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`banner_id`,`day`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Report_Banner_Monthly`
--


--
-- Table structure for table `Report_Classified`
--

CREATE TABLE `Report_Classified` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `classified_id` int(11) NOT NULL DEFAULT '0',
  `report_type` tinyint(1) NOT NULL DEFAULT '0',
  `report_amount` int(11) NOT NULL DEFAULT '0',
  `date` date NOT NULL DEFAULT '0000-00-00',
  PRIMARY KEY (`id`),
  UNIQUE KEY `report_info` (`classified_id`,`report_type`,`date`),
  KEY `classified_id` (`classified_id`),
  KEY `report_type` (`report_type`),
  KEY `date` (`date`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Report_Classified`
--


--
-- Table structure for table `Report_Classified_Daily`
--

CREATE TABLE `Report_Classified_Daily` (
  `classified_id` int(11) NOT NULL DEFAULT '0',
  `day` date NOT NULL DEFAULT '0000-00-00',
  `summary_view` int(11) NOT NULL DEFAULT '0',
  `detail_view` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`classified_id`,`day`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Report_Classified_Daily`
--


--
-- Table structure for table `Report_Classified_Monthly`
--

CREATE TABLE `Report_Classified_Monthly` (
  `classified_id` int(11) NOT NULL DEFAULT '0',
  `day` date NOT NULL,
  `summary_view` int(11) NOT NULL DEFAULT '0',
  `detail_view` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`classified_id`,`day`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Report_Classified_Monthly`
--


--
-- Table structure for table `Report_Event`
--

CREATE TABLE `Report_Event` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `event_id` int(11) NOT NULL DEFAULT '0',
  `report_type` tinyint(1) NOT NULL DEFAULT '0',
  `report_amount` int(11) NOT NULL DEFAULT '0',
  `date` date NOT NULL DEFAULT '0000-00-00',
  PRIMARY KEY (`id`),
  UNIQUE KEY `report_info` (`event_id`,`report_type`,`date`),
  KEY `event_id` (`event_id`),
  KEY `report_type` (`report_type`),
  KEY `date` (`date`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Report_Event`
--


--
-- Table structure for table `Report_Event_Daily`
--

CREATE TABLE `Report_Event_Daily` (
  `event_id` int(11) NOT NULL DEFAULT '0',
  `day` date NOT NULL DEFAULT '0000-00-00',
  `summary_view` int(11) NOT NULL DEFAULT '0',
  `detail_view` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`event_id`,`day`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Report_Event_Daily`
--


--
-- Table structure for table `Report_Event_Monthly`
--

CREATE TABLE `Report_Event_Monthly` (
  `event_id` int(11) NOT NULL DEFAULT '0',
  `day` date NOT NULL,
  `summary_view` int(11) NOT NULL DEFAULT '0',
  `detail_view` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`event_id`,`day`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Report_Event_Monthly`
--


--
-- Table structure for table `Report_Listing`
--

CREATE TABLE `Report_Listing` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `listing_id` int(11) NOT NULL DEFAULT '0',
  `report_type` tinyint(1) NOT NULL DEFAULT '0',
  `report_amount` int(11) NOT NULL DEFAULT '0',
  `date` date NOT NULL DEFAULT '0000-00-00',
  PRIMARY KEY (`id`),
  UNIQUE KEY `report_info` (`listing_id`,`report_type`,`date`),
  KEY `listing_id` (`listing_id`),
  KEY `report_type` (`report_type`),
  KEY `date` (`date`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Report_Listing`
--


--
-- Table structure for table `Report_Listing_Daily`
--

CREATE TABLE `Report_Listing_Daily` (
  `listing_id` int(11) NOT NULL DEFAULT '0',
  `day` date NOT NULL DEFAULT '0000-00-00',
  `summary_view` int(11) NOT NULL DEFAULT '0',
  `detail_view` int(11) NOT NULL DEFAULT '0',
  `click_thru` int(11) NOT NULL DEFAULT '0',
  `email_sent` int(11) NOT NULL DEFAULT '0',
  `phone_view` int(11) NOT NULL DEFAULT '0',
  `fax_view` int(11) NOT NULL DEFAULT '0',
  `send_phone` int(11) NOT NULL DEFAULT '0',
  `click_call` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`listing_id`,`day`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Report_Listing_Daily`
--


--
-- Table structure for table `Report_Listing_Monthly`
--

CREATE TABLE `Report_Listing_Monthly` (
  `listing_id` int(11) NOT NULL DEFAULT '0',
  `day` date NOT NULL,
  `summary_view` int(11) NOT NULL DEFAULT '0',
  `detail_view` int(11) NOT NULL DEFAULT '0',
  `click_thru` int(11) NOT NULL DEFAULT '0',
  `email_sent` int(11) NOT NULL DEFAULT '0',
  `phone_view` int(11) NOT NULL DEFAULT '0',
  `fax_view` int(11) NOT NULL DEFAULT '0',
  `send_phone` int(11) NOT NULL DEFAULT '0',
  `click_call` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`listing_id`,`day`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Report_Listing_Monthly`
--


--
-- Table structure for table `Report_Login`
--

CREATE TABLE `Report_Login` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `ip` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `page` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `username` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Report_Login`
--


--
-- Table structure for table `Report_Post`
--

CREATE TABLE `Report_Post` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `post_id` int(11) NOT NULL DEFAULT '0',
  `report_type` tinyint(1) NOT NULL DEFAULT '0',
  `report_amount` int(11) NOT NULL DEFAULT '0',
  `date` date NOT NULL DEFAULT '0000-00-00',
  PRIMARY KEY (`id`),
  UNIQUE KEY `report_info` (`post_id`,`report_type`,`date`),
  KEY `post_id` (`post_id`),
  KEY `report_type` (`report_type`),
  KEY `date` (`date`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Report_Post`
--


--
-- Table structure for table `Report_Post_Daily`
--

CREATE TABLE `Report_Post_Daily` (
  `post_id` int(11) NOT NULL DEFAULT '0',
  `day` date NOT NULL DEFAULT '0000-00-00',
  `summary_view` int(11) NOT NULL DEFAULT '0',
  `detail_view` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`post_id`,`day`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Report_Post_Daily`
--


--
-- Table structure for table `Report_Post_Monthly`
--

CREATE TABLE `Report_Post_Monthly` (
  `post_id` int(11) NOT NULL DEFAULT '0',
  `day` date NOT NULL,
  `summary_view` int(11) NOT NULL DEFAULT '0',
  `detail_view` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`post_id`,`day`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Report_Post_Monthly`
--


--
-- Table structure for table `Report_Promotion`
--

CREATE TABLE `Report_Promotion` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `promotion_id` int(11) NOT NULL DEFAULT '0',
  `report_type` tinyint(1) NOT NULL DEFAULT '0',
  `report_amount` int(11) NOT NULL DEFAULT '0',
  `date` date NOT NULL DEFAULT '0000-00-00',
  PRIMARY KEY (`id`),
  UNIQUE KEY `report_info` (`promotion_id`,`report_type`,`date`),
  KEY `promotion_id` (`promotion_id`),
  KEY `report_type` (`report_type`),
  KEY `date` (`date`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Report_Promotion`
--


--
-- Table structure for table `Report_Promotion_Daily`
--

CREATE TABLE `Report_Promotion_Daily` (
  `promotion_id` int(11) NOT NULL DEFAULT '0',
  `day` date NOT NULL DEFAULT '0000-00-00',
  `summary_view` int(11) NOT NULL DEFAULT '0',
  `detail_view` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`promotion_id`,`day`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Report_Promotion_Daily`
--


--
-- Table structure for table `Report_Promotion_Monthly`
--

CREATE TABLE `Report_Promotion_Monthly` (
  `promotion_id` int(11) NOT NULL DEFAULT '0',
  `day` date NOT NULL,
  `summary_view` int(11) NOT NULL DEFAULT '0',
  `detail_view` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`promotion_id`,`day`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Report_Promotion_Monthly`
--


--
-- Table structure for table `Report_Statistic`
--

CREATE TABLE `Report_Statistic` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `search_date` datetime NOT NULL,
  `module` char(1) CHARACTER SET utf8 NOT NULL,
  `keyword` varchar(50) CHARACTER SET utf8 NOT NULL,
  `category_id` int(11) NOT NULL DEFAULT '0',
  `location_1` int(11) NOT NULL DEFAULT '0',
  `location_2` int(11) NOT NULL DEFAULT '0',
  `location_3` int(11) NOT NULL DEFAULT '0',
  `location_4` int(11) NOT NULL DEFAULT '0',
  `location_5` int(11) NOT NULL DEFAULT '0',
  `search_where` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `search_date` (`search_date`),
  KEY `module` (`module`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Report_Statistic`
--


--
-- Table structure for table `Report_Statistic_Daily`
--

CREATE TABLE `Report_Statistic_Daily` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `day` date NOT NULL,
  `module` char(1) CHARACTER SET utf8 NOT NULL,
  `key` varchar(255) CHARACTER SET utf8 NOT NULL,
  `value` varchar(255) CHARACTER SET utf8 NOT NULL,
  `quantity` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `key` (`key`),
  KEY `module` (`module`),
  KEY `day` (`day`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Report_Statistic_Daily`
--


--
-- Table structure for table `Review`
--

CREATE TABLE `Review` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `item_type` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `item_id` int(11) NOT NULL DEFAULT '0',
  `member_id` int(11) DEFAULT NULL,
  `added` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `ip` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `review_title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `review` text COLLATE utf8_unicode_ci,
  `reviewer_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `reviewer_email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `reviewer_location` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `rating` tinyint(2) NOT NULL DEFAULT '0',
  `approved` int(1) NOT NULL DEFAULT '0',
  `response` text COLLATE utf8_unicode_ci,
  `responseapproved` int(1) NOT NULL DEFAULT '0',
  `like` int(11) NOT NULL DEFAULT '0',
  `dislike` int(11) NOT NULL DEFAULT '0',
  `like_ips` text COLLATE utf8_unicode_ci,
  `dislike_ips` text COLLATE utf8_unicode_ci,
  `new` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'y' COMMENT 'y/n',
  PRIMARY KEY (`id`),
  KEY `approved` (`approved`),
  KEY `item_info` (`item_type`,`item_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Review`
--


--
-- Table structure for table `Setting`
--

CREATE TABLE `Setting` (
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `value` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Setting`
--

INSERT INTO `Setting` VALUES ('custom_classified_feature','on'),('custom_blog_feature','on'),('custom_banner_feature','on'),('default_url','demodirectory.com.br'),('custom_article_feature','on'),('todo_paymentgateway','yes'),('todo_pricing','yes'),('todo_invoice','yes'),('todo_email','yes'),('todo_emailnotification','yes'),('todo_googleads','yes'),('todo_googlemaps','yes'),('todo_googleanalytics','yes'),('todo_headerlogo','yes'),('todo_noimage','yes'),('todo_claim','yes'),('todo_langcenter','yes'),('todo_levels','yes'),('todo_emailconfig','yes'),('sitemgr_email',''),('sitemgr_send_email','on'),('sitemgr_listing_email',''),('sitemgr_event_email',''),('sitemgr_banner_email',''),('sitemgr_classified_email',''),('sitemgr_article_email',''),('sitemgr_account_email',''),('sitemgr_contactus_email',''),('sitemgr_support_email',''),('sitemgr_payment_email',''),('sitemgr_rate_email',''),('sitemgr_claim_email',''),('review_listing_enabled','on'),('review_article_enabled','on'),('review_approve','on'),('review_manditory','on'),('claim_approve','on'),('claim_deny','on'),('claim_approveemail','on'),('claim_denyemail','on'),('import_enable_listing_active',''),('import_defaultlevel','10'),('import_sameaccount',''),('import_account_id',''),('import_from_export',''),('last_report_rollup','0000-00-00'),('last_listing_randomizer','0'),('last_promotion_randomizer','0'),('last_banner_randomizer','0'),('last_event_randomizer','0'),('last_classified_randomizer','0'),('last_article_randomizer','0'),('last_listing_reminder','0'),('edir_default_language','en_us'),('edir_languages','en_us'),('edir_languagenames','English'),('edir_language','en_us'),('emailconf_method','smtp'),('emailconf_host',''),('emailconf_port','465'),('emailconf_auth','secure'),('emailconf_email',''),('emailconf_username',''),('emailconf_password',''),('foreignaccount_facebook',''),('foreignaccount_facebook_apikey',''),('last_datetime_cronmgr','0000-00-00 00:00:00'),('last_datetime_dailymaintenance','0000-00-00 00:00:00'),('last_datetime_import','0000-00-00 00:00:00'),('last_datetime_randomizer','0000-00-00 00:00:00'),('last_datetime_renewalreminder','0000-00-00 00:00:00'),('last_datetime_reportrollup','0000-00-00 00:00:00'),('last_datetime_sitemap','0000-00-00 00:00:00'),('last_datetime_statisticreport','0000-00-00 00:00:00'),('last_cronmgr_run','0'),('featuredcategory','on'),('listing_featuredcategory',''),('article_featuredcategory',''),('classified_featuredcategory',''),('event_featuredcategory',''),('article_approve_free','on'),('article_approve_paid','on'),('listing_approve_updated','on'),('banner_approve_paid','on'),('event_approve_updated','on'),('classified_approve_paid','on'),('banner_approve_free','on'),('classified_approve_updated','on'),('event_approve_free','on'),('event_approve_paid','on'),('article_approve_updated','on'),('classified_approve_free','on'),('banner_approve_updated','on'),('toggle_all',''),('new_listing_email','on'),('update_listing_email','on'),('new_event_email','on'),('update_event_email','on'),('new_classified_email','on'),('update_classified_email','on'),('new_article_email','on'),('update_article_email','on'),('new_banner_email','on'),('update_banner_email','on'),('todo_approvalconfig','yes'),('foreignaccount_facebook_apisecret',''),('todo_locations','yes'),('payment_tax_status','on'),('payment_tax_value','3'),('custom_event_feature','on'),('custom_promotion_feature','on'),('last_listing_randomizer_domain','20000'),('last_promotion_randomizer_domain','0'),('last_event_randomizer_domain','0'),('last_banner_randomizer_domain','0'),('last_classified_randomizer_domain','0'),('last_article_randomizer_domain','0'),('custom_has_promotion','on'),('foreignaccount_facebook_apiid',''),('listing_approve_paid','on'),('listing_approve_free','on'),('twitter_account',''),('signinenabled_edirectory','on'),('setting_linkedin_link',''),('setting_facebook_link',''),('twilio_enabled_call',''),('twilio_account_sid',''),('twilio_auth_token',''),('appbuilder_previewpassword',''),('twilio_clicktocall_message',''),('email_traffic_listing_30',''),('email_traffic_listing_10','on'),('commenting_edir','on'),('commenting_fb',''),('slider_feature','on'),('commenting_fb_user_id',''),('commenting_fb_number_comments',''),('import_automatic_start','1'),('import_automatic_start_event','1'),('last_favicon_id','2'),('foreignaccount_google','on'),('wp_enabled',''),('import_update_listings',''),('import_featured_categs',''),('import_sameaccount_event',''),('import_account_id_event',''),('import_from_export_event',''),('import_update_events',''),('import_featured_categs_event',''),('import_enable_event_active',''),('import_defaultlevel_event','50'),('todo_theme','yes'),('percentage_todo','100'),('blog_featuredcategory',''),('emailconf_protocol','ssl'),('email_traffic_listing_50',''),('email_traffic_listing_70',''),('button_share_facebook',''),('button_share_google',''),('button_share_pinterest',''),('pendingReviews_per_page','2'),('h™leditor_first_change','no'),('sitemgr_blog_email',''),('sitemgr_import_email',''),('arcamailer_customer_country',''),('arcamailer_customer_email',''),('arcamailer_customer_name',''),('arcamailer_customer_id',''),('contact_address',''),('contact_zipcode',''),('contact_country',''),('contact_state',''),('contact_city',''),('contact_phone',''),('contact_email',''),('contact_mapzoom',''),('contact_latitude',''),('contact_longitude',''),('maintenance_mode','off'),('arcamailer_customer_timezone',''),('arcamailer_enable_list',''),('arcamailer_list_label',''),('arcamailer_customer_listname',''),('arcamailer_customer_listid',''),('foreignaccount_google_clientid',''),('foreignaccount_google_clientsecret',''),('appbuilder_logo_id',''),('appbuilder_logo_extension',''),('appbuilder_about_email',''),('appbuilder_about_phone',''),('appbuilder_about_website',''),('appbuilder_about_text',''),('appbuilder_percentage',''),('appbuilder_step_2',''),('contact_company',''),('contact_fax','');

--
-- Table structure for table `Setting_Google`
--

CREATE TABLE `Setting_Google` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `value` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=40 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Setting_Google`
--

INSERT INTO `Setting_Google` VALUES (1,'google_ad_client',''),(2,'google_maps_key',''),(3,'google_analytics_account',''),(4,'google_analytics_front',''),(5,'google_analytics_members',''),(6,'google_analytics_sitemgr',''),(7,'google_ad_channel',''),(8,'google_ad_status','off'),(10,'google_ad_type','text_image'),(11,'google_tag_status','off'),(12,'google_tag_client',''),(13,'ad_client',''),(14,'maps_key',''),(15,'analytics_account',''),(16,'analytics_front',''),(17,'analytics_members',''),(18,'analytics_sitemgr',''),(19,'ad_channel',''),(20,'ad_status',''),(21,'maps_status','on'),(22,'ad_type',''),(23,'tag_status',''),(24,'tag_client',''),(25,'recaptcha_status',''),(26,'recaptcha_sitekey',''),(27,'recaptcha_secretkey',''),(28,'google_ad_client',''),(29,'google_maps_key',''),(30,'google_analytics_account',''),(31,'google_analytics_front',''),(32,'google_analytics_members',''),(33,'google_analytics_sitemgr',''),(34,'google_ad_channel',''),(35,'google_ad_status','off'),(37,'google_ad_type','text_image'),(38,'google_tag_status','off'),(39,'google_tag_client','');

--
-- Table structure for table `Setting_Location`
--

CREATE TABLE `Setting_Location` (
  `id` tinyint(4) NOT NULL,
  `default_id` int(11) NOT NULL DEFAULT '0',
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `name_plural` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `enabled` char(1) COLLATE utf8_unicode_ci NOT NULL,
  `show` char(1) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Setting_Location`
--

INSERT INTO `Setting_Location` VALUES (1,2,'COUNTRY','COUNTRIES','y','n'),(2,0,'REGION','REGIONS','n','b'),(3,0,'STATE','STATES','y','b'),(4,0,'CITY','CITIES','y','b'),(5,0,'NEIGHBORHOOD','NEIGHBORHOODS','n','b');

--
-- Table structure for table `Setting_Navigation`
--

CREATE TABLE `Setting_Navigation` (
  `order` int(11) NOT NULL,
  `label` varchar(100) CHARACTER SET utf8 NOT NULL,
  `link` varchar(255) CHARACTER SET utf8 NOT NULL,
  `area` varchar(20) CHARACTER SET utf8 NOT NULL,
  `custom` char(1) CHARACTER SET utf8 NOT NULL,
  PRIMARY KEY (`order`,`area`),
  KEY `label` (`label`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Setting_Navigation`
--

INSERT INTO `Setting_Navigation` VALUES (5,'Ofertas','PROMOTION_DEFAULT_URL','header','n'),(4,'Artigos','ARTICLE_DEFAULT_URL','header','n'),(3,'Classificados','CLASSIFIED_DEFAULT_URL','header','n'),(2,'Eventos','EVENT_DEFAULT_URL','header','n'),(1,'Empresas','LISTING_DEFAULT_URL','header','n'),(0,'Home','NON_SECURE_URL','header','n'),(0,'Empresas','LISTING_DEFAULT_URL','footer','n'),(1,'Eventos','EVENT_DEFAULT_URL','footer','n'),(2,'Classificados','CLASSIFIED_DEFAULT_URL','footer','n'),(3,'Artigos','ARTICLE_DEFAULT_URL','footer','n'),(4,'Ofertas','PROMOTION_DEFAULT_URL','footer','n'),(5,'Blog','BLOG_DEFAULT_URL','footer','n'),(6,'Blog','BLOG_DEFAULT_URL','header','n'),(7,'Anuncie Aqui','ALIAS_ADVERTISE_URL_DIVISOR','header','n'),(8,'Contato','ALIAS_CONTACTUS_URL_DIVISOR','header','n'),(0,'Listings','listings','tabbar','n'),(1,'Nearby','nearby','tabbar','n'),(2,'Reviews','reviews','tabbar','n'),(3,'Events','events','tabbar','n'),(4,'Classifieds','classifieds','tabbar','n'),(5,'Articles','articles','tabbar','n'),(6,'Deals','deals','tabbar','n'),(7,'Blog','blog','tabbar','n'),(8,'My Favorites','favorites','tabbar','n'),(9,'My Account','account','tabbar','n'),(10,'About Us','about','tabbar','n');

--
-- Table structure for table `Setting_Payment`
--

CREATE TABLE `Setting_Payment` (
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `value` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Setting_Payment`
--

INSERT INTO `Setting_Payment` VALUES ('PAYPAL_ACCOUNT',''),('PAYPALAPI_USERNAME',''),('PAYPALAPI_PASSWORD',''),('PAYPALAPI_SIGNATURE',''),('PAYFLOW_LOGIN',''),('PAYFLOW_PARTNER',''),('TWOCHECKOUT_LOGIN',''),('PSIGATE_STOREID',''),('PSIGATE_PASSPHRASE',''),('WORLDPAY_INSTID',''),('ITRANSACT_VENDORID',''),('AUTHORIZE_LOGIN',''),('AUTHORIZE_TXNKEY',''),('LINKPOINT_CONFIGFILE',''),('LINKPOINT_KEYFILE',''),('SIMPLEPAY_ACCESSKEY',''),('SIMPLEPAY_SECRETKEY',''),('PAYPAL_STATUS','off'),('PAYPALAPI_STATUS','off'),('PAYFLOW_STATUS','off'),('TWOCHECKOUT_STATUS','off'),('PSIGATE_STATUS','off'),('WORLDPAY_STATUS','off'),('ITRANSACT_STATUS','off'),('AUTHORIZE_STATUS','off'),('LINKPOINT_STATUS','off'),('SIMPLEPAY_STATUS','off'),('SIMPLEPAY_RECURRING','off'),('PAYPAL_RECURRING','off'),('LINKPOINT_RECURRING','off'),('AUTHORIZE_RECURRING','off'),('SIMPLEPAY_RECURRINGCYCLE',' '),('SIMPLEPAY_RECURRINGUNIT',' '),('SIMPLEPAY_RECURRINGTIMES',' '),('PAYPAL_RECURRINGCYCLE',' '),('PAYPAL_RECURRINGTIMES',' '),('PAYPAL_RECURRINGUNIT',' '),('LINKPOINT_RECURRINGTYPE',' '),('AUTHORIZE_RECURRINGLENGTH',' '),('AUTHORIZE_RECURRINGUNIT','months'),('CURRENCY_SYMBOL','R$'),('LISTING_RENEWAL_PERIOD','1Y'),('EVENT_RENEWAL_PERIOD','3M'),('BANNER_RENEWAL_PERIOD','1Y'),('CLASSIFIED_RENEWAL_PERIOD','30D'),('ARTICLE_RENEWAL_PERIOD','1Y'),('INVOICEPAYMENT_FEATURE','on'),('MANUALPAYMENT_FEATURE','on'),('PAYMENT_CURRENCY','BRL'),('PAGSEGURO_STATUS','off'),('PAGSEGURO_EMAIL',''),('PAGSEGURO_TOKEN','');

--
-- Table structure for table `Setting_Search_Tag`
--

CREATE TABLE `Setting_Search_Tag` (
  `id` int(50) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `value` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Setting_Search_Tag`
--


--
-- Table structure for table `Setting_Social_Network`
--

CREATE TABLE `Setting_Social_Network` (
  `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `value` varchar(3) COLLATE utf8_unicode_ci NOT NULL,
  `label` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Setting_Social_Network`
--

INSERT INTO `Setting_Social_Network` VALUES ('general_see_profile','no','LANG_SITEMGR_SN_SEE_PROFILE'),('listing_rate','yes','LANG_SITEMGR_SN_RATE'),('article_rate','yes','LANG_SITEMGR_SN_RATE');

--
-- Table structure for table `Slider`
--

CREATE TABLE `Slider` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `image_id` int(11) NOT NULL,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `summary` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `alternative_text` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `title_text` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `link` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `price` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `slide_order` int(11) NOT NULL,
  `target` varchar(10) CHARACTER SET utf8 NOT NULL DEFAULT 'self',
  PRIMARY KEY (`id`),
  KEY `order` (`slide_order`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Slider`
--


--
-- Table structure for table `Timeline`
--

CREATE TABLE `Timeline` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `item_type` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `item_id` int(11) NOT NULL,
  `action` set('new','edit') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'new',
  `datetime` datetime NOT NULL,
  `new` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'y',
  PRIMARY KEY (`id`),
  KEY `item_type` (`item_type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Timeline`
--



