--
-- Host: localhost    Database: Package_11005_empty_main
-- ------------------------------------------------------


--
-- Table structure for table `Account`
--

CREATE TABLE `Account` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `entered` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `agree_tou` char(1) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lastlogin` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `facebook_username` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `username` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `password` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `foreignaccount` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'n',
  `foreignaccount_done` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'n',
  `foreignaccount_redirect` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `foreignaccount_auth` text COLLATE utf8_unicode_ci NOT NULL,
  `facebook_firstname` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `facebook_lastname` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `faillogin_count` int(11) NOT NULL DEFAULT '0',
  `faillogin_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `importID` int(11) NOT NULL DEFAULT '0',
  `domain_importID` int(11) NOT NULL,
  `importID_event` int(11) NOT NULL DEFAULT '0',
  `domain_importID_event` int(11) NOT NULL,
  `is_sponsor` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'n',
  `has_profile` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'y',
  `publish_contact` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'n',
  `notify_traffic_listing` char(1) COLLATE utf8_unicode_ci NOT NULL,
  `complementary_info` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `active` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'n',
  `newsletter` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'n',
  PRIMARY KEY (`id`),
  KEY `username` (`username`),
  KEY `lastlogin` (`lastlogin`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Account`
--


--
-- Table structure for table `Account_Activation`
--

CREATE TABLE `Account_Activation` (
  `account_id` int(11) NOT NULL DEFAULT '0',
  `unique_key` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `entered` date NOT NULL DEFAULT '0000-00-00',
  KEY `account_id` (`account_id`),
  KEY `unique_key` (`unique_key`),
  KEY `entered` (`entered`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Account_Activation`
--


--
-- Table structure for table `Account_Domain`
--

CREATE TABLE `Account_Domain` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `account_id` int(11) NOT NULL,
  `domain_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `account_domain` (`account_id`,`domain_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Account_Domain`
--


--
-- Table structure for table `Contact`
--

CREATE TABLE `Contact` (
  `account_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',
  `first_name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `last_name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `company` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `address` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `address2` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `city` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `state` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `zip` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
  `country` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `phone` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `fax` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `url` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `importID` int(11) NOT NULL DEFAULT '0',
  `importID_event` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`account_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Contact`
--


--
-- Table structure for table `Control_Cron`
--

CREATE TABLE `Control_Cron` (
  `domain_id` int(11) NOT NULL,
  `running` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
  `last_run_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `type` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  KEY `domain_id` (`domain_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Control_Cron`
--

INSERT INTO `Control_Cron` VALUES (1,'N','2013-03-07 16:53:18','count_article_category'),(1,'N','2013-03-07 16:53:24','count_classified_category'),(1,'N','2013-03-07 16:53:28','count_event_category'),(1,'N','2013-03-07 16:51:53','count_listing_category'),(1,'N','2013-03-07 16:53:13','count_post_tag'),(1,'N','0000-00-00 00:00:00','daily_maintenance'),(1,'N','2013-07-30 14:38:38','randomizer'),(1,'N','0000-00-00 00:00:00','renewal_reminder'),(1,'N','2012-11-26 16:03:26','report_rollup'),(1,'N','2013-01-24 08:38:48','sitemap'),(1,'N','2012-11-26 16:01:21','statisticreport'),(1,'N','2013-06-12 09:33:23','location_update'),(1,'N','0000-00-00 00:00:00','prepare_import_events'),(1,'N','0000-00-00 00:00:00','email_traffic'),(1,'N','0000-00-00 00:00:00','rollback_import'),(1,'N','0000-00-00 00:00:00','prepare_import'),(1,'N','0000-00-00 00:00:00','rollback_import_events'),(1,'N','2013-08-30 11:15:22','count_locations');

--
-- Table structure for table `Control_Export_Event`
--

CREATE TABLE `Control_Export_Event` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `domain_id` int(11) NOT NULL DEFAULT '0',
  `last_run_date` datetime NOT NULL,
  `total_event_exported` int(11) NOT NULL,
  `last_event_id` int(11) NOT NULL,
  `block` int(11) NOT NULL,
  `finished` varchar(1) NOT NULL,
  `filename` varchar(100) NOT NULL,
  `type` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT 'csv / csv - data',
  `running_cron` varchar(1) NOT NULL,
  `scheduled` varchar(1) NOT NULL,
  PRIMARY KEY (`id`,`domain_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Control_Export_Event`
--

INSERT INTO `Control_Export_Event` VALUES (1,1,'0000-00-00 00:00:00',0,0,50000,'Y','','csv','N','N'),(2,1,'0000-00-00 00:00:00',0,0,10000,'Y','','csv - data','N','N');

--
-- Table structure for table `Control_Export_Listing`
--

CREATE TABLE `Control_Export_Listing` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `domain_id` int(11) NOT NULL DEFAULT '0',
  `last_run_date` datetime NOT NULL,
  `total_listing_exported` int(11) NOT NULL,
  `last_listing_id` int(11) NOT NULL,
  `block` int(11) NOT NULL,
  `finished` varchar(1) NOT NULL,
  `filename` varchar(100) NOT NULL,
  `type` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT 'csv / csv - data',
  `running_cron` varchar(1) NOT NULL,
  `scheduled` varchar(1) NOT NULL,
  PRIMARY KEY (`id`,`domain_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Control_Export_Listing`
--

INSERT INTO `Control_Export_Listing` VALUES (1,1,'0000-00-00 00:00:00',0,0,50000,'Y','','csv','N','N'),(2,1,'0000-00-00 00:00:00',0,0,10000,'Y','','csv - data','N','N');

--
-- Table structure for table `Control_Export_MailApp`
--

CREATE TABLE `Control_Export_MailApp` (
  `domain_id` int(11) NOT NULL,
  `scheduled` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
  `running` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
  `last_run_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `last_exportlog` int(11) NOT NULL,
  PRIMARY KEY (`domain_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Control_Export_MailApp`
--

INSERT INTO `Control_Export_MailApp` VALUES (1,'N','N','0000-00-00 00:00:00',0);

--
-- Table structure for table `Control_Import_Event`
--

CREATE TABLE `Control_Import_Event` (
  `domain_id` int(11) NOT NULL,
  `scheduled` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
  `running` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
  `status` char(2) COLLATE utf8_unicode_ci NOT NULL,
  `last_run_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `last_importlog` int(11) NOT NULL,
  PRIMARY KEY (`domain_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Control_Import_Event`
--

INSERT INTO `Control_Import_Event` VALUES (1,'N','N','','0000-00-00 00:00:00',0);

--
-- Table structure for table `Control_Import_Listing`
--

CREATE TABLE `Control_Import_Listing` (
  `domain_id` int(11) NOT NULL,
  `scheduled` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
  `running` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
  `status` char(2) COLLATE utf8_unicode_ci NOT NULL,
  `last_run_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `last_importlog` int(11) NOT NULL,
  PRIMARY KEY (`domain_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Control_Import_Listing`
--

INSERT INTO `Control_Import_Listing` VALUES (1,'N','N','','0000-00-00 00:00:00',0);

--
-- Table structure for table `Cron_Log`
--

CREATE TABLE `Cron_Log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `domain_id` int(11) NOT NULL,
  `cron` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `date` datetime NOT NULL,
  `history` text COLLATE utf8_unicode_ci NOT NULL,
  `finished` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'n',
  `time` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Cron_Log`
--


--
-- Table structure for table `Domain`
--

CREATE TABLE `Domain` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `smaccount_id` int(11) NOT NULL,
  `name` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
  `database_host` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
  `database_port` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `database_username` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
  `database_password` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
  `database_name` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
  `url` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
  `status` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'P' COMMENT 'A - Active, D - Deleted, P - Pending',
  `activation_status` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'P' COMMENT 'A - Active, P - Pending',
  `created` date NOT NULL DEFAULT '0000-00-00',
  `deleted_date` date NOT NULL DEFAULT '0000-00-00',
  `article_feature` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'off',
  `banner_feature` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'off',
  `classified_feature` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'off',
  `event_feature` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'off',
  `subfolder` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `domain_info` (`url`,`status`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Domain`
--


--
-- Table structure for table `Forgot_Password`
--

CREATE TABLE `Forgot_Password` (
  `account_id` int(11) NOT NULL DEFAULT '0',
  `unique_key` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `entered` date NOT NULL DEFAULT '0000-00-00',
  `section` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  KEY `account_id` (`account_id`),
  KEY `unique_key` (`unique_key`),
  KEY `entered` (`entered`),
  KEY `section` (`section`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Forgot_Password`
--


--
-- 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 `Location_1`
--

CREATE TABLE `Location_1` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `abbreviation` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `friendly_url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `seo_description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `seo_keywords` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `friendly_url` (`friendly_url`),
  KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Location_1`
--


--
-- Table structure for table `Location_2`
--

CREATE TABLE `Location_2` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `location_1` int(11) NOT NULL DEFAULT '0',
  `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `abbreviation` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `friendly_url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `seo_description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `seo_keywords` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `friendly_url` (`friendly_url`),
  KEY `country_id` (`location_1`),
  KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Location_2`
--


--
-- Table structure for table `Location_3`
--

CREATE TABLE `Location_3` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `location_2` int(11) NOT NULL DEFAULT '0',
  `location_1` int(11) NOT NULL DEFAULT '0',
  `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `abbreviation` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `friendly_url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `seo_description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `seo_keywords` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `friendly_url` (`friendly_url`),
  KEY `state_id` (`location_2`),
  KEY `name` (`name`),
  KEY `location_2_level` (`location_1`,`location_2`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Location_3`
--


--
-- Table structure for table `Location_4`
--

CREATE TABLE `Location_4` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `location_3` int(11) NOT NULL DEFAULT '0',
  `location_2` int(11) NOT NULL DEFAULT '0',
  `location_1` int(11) NOT NULL DEFAULT '0',
  `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `abbreviation` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `friendly_url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `seo_description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `seo_keywords` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `region_id` (`location_3`),
  KEY `friendly_url` (`friendly_url`),
  KEY `name` (`name`),
  KEY `location_3_level` (`location_1`,`location_2`,`location_3`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Location_4`
--


--
-- Table structure for table `Location_5`
--

CREATE TABLE `Location_5` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `location_4` int(11) NOT NULL DEFAULT '0',
  `location_3` int(11) NOT NULL DEFAULT '0',
  `location_2` int(11) NOT NULL DEFAULT '0',
  `location_1` int(11) NOT NULL DEFAULT '0',
  `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `abbreviation` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `friendly_url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `seo_description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `seo_keywords` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `city_id` (`location_4`),
  KEY `friendly_url` (`friendly_url`),
  KEY `name` (`name`),
  KEY `location_4_level` (`location_1`,`location_2`,`location_3`,`location_4`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Location_5`
--


--
-- Table structure for table `Location_Featured`
--

CREATE TABLE `Location_Featured` (
  `domain_id` int(11) NOT NULL,
  `location_level` int(11) NOT NULL,
  `location_id` int(11) NOT NULL,
  PRIMARY KEY (`domain_id`,`location_level`,`location_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Location_Featured`
--


--
-- Table structure for table `Package`
--

CREATE TABLE `Package` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `parent_domain` int(11) DEFAULT NULL,
  `module` varchar(50) DEFAULT NULL,
  `level` int(11) DEFAULT NULL,
  `status` varchar(1) NOT NULL,
  `image_id` int(11) NOT NULL,
  `thumb_id` int(11) NOT NULL,
  `show_info` varchar(1) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `content` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `entered` datetime NOT NULL,
  `updated` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `parent_domain` (`parent_domain`),
  KEY `module` (`module`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Package`
--


--
-- Table structure for table `PackageItems`
--

CREATE TABLE `PackageItems` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `package_id` int(11) NOT NULL,
  `domain_id` int(11) NOT NULL,
  `module` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `level` int(11) NOT NULL,
  `price` decimal(10,2) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `PackageItems`
--


--
-- Table structure for table `PackageItemsLOG`
--

CREATE TABLE `PackageItemsLOG` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `package_id` int(11) NOT NULL,
  `old_items` text NOT NULL,
  `new_items` text NOT NULL,
  `updated` datetime NOT NULL,
  `smaccount` varchar(255) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `package_id` (`package_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `PackageItemsLOG`
--


--
-- Table structure for table `PackageModules`
--

CREATE TABLE `PackageModules` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `account_id` int(11) NOT NULL,
  `package_id` int(11) NOT NULL,
  `domain_id` int(11) DEFAULT NULL,
  `parent_domain_id` int(11) NOT NULL,
  `module` varchar(50) DEFAULT NULL,
  `module_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `module_id` int(11) DEFAULT NULL,
  `date` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `domain_id` (`domain_id`),
  KEY `fk_PackageModules_Package1` (`package_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `PackageModules`
--


--
-- Table structure for table `Profile`
--

CREATE TABLE `Profile` (
  `account_id` int(11) 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,
  `nickname` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `friendly_url` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'MD5(account_id)',
  `entered` datetime NOT NULL,
  `updated` datetime NOT NULL,
  `personal_message` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `twitter_account` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `facebook_uid` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
  `fb_post` smallint(1) NOT NULL,
  `tw_post` smallint(1) NOT NULL,
  `usefacebooklocation` smallint(1) NOT NULL,
  `tw_oauth_token` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
  `location` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
  `tw_oauth_token_secret` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
  `tw_screen_name` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
  `profile_complete` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'n',
  PRIMARY KEY (`account_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Profile`
--


--
-- Table structure for table `Registration`
--

CREATE TABLE `Registration` (
  `name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `domain` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `date_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `value` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`name`,`domain`,`date_time`),
  KEY `domain` (`domain`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Registration`
--


--
-- Table structure for table `RobotsFilter`
--

CREATE TABLE `RobotsFilter` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `value` char(15) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=274 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `RobotsFilter`
--

INSERT INTO `RobotsFilter` VALUES (1,'72.14.199.*'),(2,'74.125.75.*'),(3,'74.125.75.*'),(4,'92.235.213.*'),(5,'84 .58.171.*'),(6,'174.129.91.*'),(7,'202.93.76.*'),(8,'71.162.124.*'),(9,'66.24 9.73.*'),(10,'125.177.35.*'),(11,'207.44.196.*'),(12,'222.238.81.*'),(13,'66.249. 64.*'),(14,'66.249.71.*'),(15,'81.32.188.*'),(16,'65.57.245.*'),(17,'91.208.212.*'),(18,'208.78.176.*'),(19,'64.233.178.*'),(20,'141.51.167.*'),(21,'84.58.174.*'),(22,'84.58.96.*'),(23,'218.132.56.*'),(24,'213.91.216.*'),(25,'66.249.65.*'),(26,'6 6.249.70.*'),(27,'66.249.72.*'),(28,'64.178.97.*'),(29,'24.7.232.*'),(30,'82.47.1. *'),(31,'68.193.180.*'),(32,'60.10.2.*'),(33,'41.200.113.*'),(34,'198.184.0.*'),(35,'207.46.126.*'),(36,'207.46.127.*'),(37,'64.4.54.*'),(38,'65.54.233.*'),(39,'65.5 5.189.*'),(40,'205.209.134.*'),(41,'66.249.66.*'),(42,'66.249.67.*'),(43,'66.249. 68.*'),(44,'85.114.130.*'),(45,'66.230.157.*'),(46,'125.22.91.*'),(47,'202.160.17 8.*'),(48,'202.160.181.*'),(49,'202.160.185.*'),(50,'202.160.188.*'),(51,'202.160 .189.*'),(52,'203.209.252.*'),(53,'202.160.179.*'),(54,'66.228.165.*'),(55,'202.16 0.180.*'),(56,'202.160.183.*'),(57,'203.83.248.*'),(58,'217.11.235.*'),(59,'66.19 6.101.*'),(60,'66.196.65.*'),(61,'66.196.77.*'),(62,'66.196.90.*'),(63,'66.196.91 .*'),(64,'66.196.92.*'),(65,'66.228.167.*'),(66,'67.195.111.*'),(67,'67.195.112.*'),(68,'67.195.113.*'),(69,'67.195.115.*'),(70,'67.195.37.*'),(71,'67.195.44.*'),(72,'68.142.246.*'),(73,'68.142.249.*'),(74,'68.142.250.*'),(75,'68.142.251.*'),(76,'68.180.251.*'),(77,'72.30.101.*'),(78,'72.30.102.*'),(79,'72.30.103.*'),(80,'72.3 0.104.*'),(81,'72.30.107.*'),(82,'72.30.110.*'),(83,'72.30.111.*'),(84,'72.30.128 .*'),(85,'72.30.129.*'),(86,'72.30.131.*'),(87,'72.30.132.*'),(88,'72.30.133.*'),(89,'72.30.134.*'),(90,'72.30.135.*'),(91,'72.30.142.*'),(92,'72.30.161.*'),(93,'72. 30.177.*'),(94,'72.30.179.*'),(95,'72.30.214.*'),(96,'72.30.215.*'),(97,'72.30.21 6.*'),(98,'72.30.221.*'),(99,'72.30.226.*'),(100,'72.30.252.*'),(101,'72.30.54.*'),(102,'72.30.56.*'),(103,'72.30.61.*'),(104,'72.30.65.*'),(105,'72.30.78.*'),(106,'72.30.7 9.*'),(107,'72.30.81.*'),(108,'72.30.87.*'),(109,'72.30.97.*'),(110,'72.30.97.*'),(111,'7 2.30.98.*'),(112,'72.30.99.*'),(113,'74.6.11.*'),(114,'74.6.12.*'),(115,'74.6.130.*'),(116,'74.6.131.*'),(117,'74.6.16.*'),(118,'74.6.17.*'),(119,'74.6.18.*'),(120,'74.6.19.*'),(121,'74.6.20.*'),(122,'74.6.21.*'),(123,'74.6.22.*'),(124,'74.6.23.*'),(125,'74.6.24.*'),(126,'74.6.25.*'),(127,'74.6.26.*'),(128,'74.6.27.*'),(129,'74.6.28.*'),(130,'74.6.29. *'),(131,'74.6.30.*'),(132,'74.6.31.*'),(133,'74.6.65.*'),(134,'74.6.66.*'),(135,'74.6.67 .*'),(136,'74.6.68.*'),(137,'74.6.69.*'),(138,'74.6.7.*'),(139,'74.6.70.*'),(140,'74.6.71 .*'),(141,'74.6.72.*'),(142,'74.6.73.*'),(143,'74.6.74.*'),(144,'74.6.75.*'),(145,'74.6.7 6.*'),(146,'74.6.79.*'),(147,'74.6.8.*'),(148,'74.6.85.*'),(149,'74.6.86.*'),(150,'74.6.8 7.*'),(151,'74.6.9.*'),(152,'130.203.146.*'),(153,'80.131.221.*'),(154,'84.188.206.*'),(155,'68.142.215.*'),(156,'68.180.201.*'),(157,'69.147.127.*'),(158,'209.131.61.*'),(159,'202.165.97.*'),(160,'203.209.241.*'),(161,'209.191.122.*'),(162,'209.73.172.*'),(163,'209.73.174.*'),(164,'66.196.85.*'),(165,'68.180.203.*'),(166,'72.30.12.*'),(167,'65.55.4.*'),(168,'65.55.51.*'),(169,'89.146.29.*'),(170,'65.55.108.*'),(171,'65.55.21 7.*'),(172,'65.55.220.*'),(173,'65.55.230.*'),(174,'65.55.231.*'),(175,'65.54.112.*'),(176,'65.55.214.*'),(177,'65.55.216.*'),(178,'65.54.164.*'),(179,'65.55.212.*'),(180,'65 .55.213.*'),(181,'131.107.0.*'),(182,'202.96.51.*'),(183,'207.46.89.*'),(184,'207.46. 98.*'),(185,'207.68.146.*'),(186,'207.68.154.*'),(187,'207.68.157.*'),(188,'207.68.18 8.*'),(189,'219.141.219.*'),(190,'219.142.53.*'),(191,'64.4.8.*'),(192,'65.54.165.*'),(193,'65.54.188.*'),(194,'65.55.104.*'),(195,'65.55.107.*'),(196,'65.55.208.*'),(197,'65 .55.209.*'),(198,'65.55.210.*'),(199,'65.55.215.*'),(200,'65.55.232.*'),(201,'65.55.23 3.*'),(202,'65.55.234.*'),(203,'65.55.235.*'),(204,'65.55.246.*'),(205,'65.55.250.*'),(206,'65.55.252.*'),(207,'65.55.105.*'),(208,'65.55.120.*'),(209,'65.55.211.*'),(210,'65 .55.25.*'),(211,'65.55.37.*'),(212,'65.55.106.*'),(213,'65.55.115.*'),(214,'65.54.116 .*'),(215,'65.54.158.*'),(216,'207.46.119.*'),(217,'209.191.82.*'),(218,'209.191.123. *'),(219,'68.180.216.*'),(220,'69.147.79.*'),(221,'70.187.130.*'),(222,'129.215.4.*'),(223,'69.64.47.*'),(224,'88.248.8.*'),(225,'38.100.213.*'),(226,'66.214.230.*'),(227,'21 8.160.32.*'),(228,'218.160.34.*'),(229,'70.143.77.*'),(230,'209.249.86.*'),(231,'66.18 0.173.*'),(232,'124.83.179.*'),(233,'203.141.52.*'),(234,'211.14.11.*'),(235,'211.14. 8.*'),(236,'209.191.71.*'),(237,'209.191.83.*'),(238,'68.142.195.*'),(239,'206.190.43 .*'),(240,'68.142.210.*'),(241,'209.191.113.*'),(242,'216.39.60.*'),(243,'66.163.174. *'),(244,'66.163.175.*'),(245,'69.147.82.*'),(246,'98.136.119.*'),(247,'209.191.65.*'),(248,'66.94.238.*'),(249,'68.142.212.*'),(250,'209.131.41.*'),(251,'216.39.58.*'),(252,'66.94.237.*'),(253,'216.109.121.*'),(254,'66.218.65.*'),(255,'209.191.126.*'),(256,'2 16.145.53.*'),(257,'217.12.1.*'),(258,'217.146.191.*'),(259,'66.163.187.*'),(260,'66. 196.99.*'),(261,'66.94.229.*'),(262,'68.180.208.*'),(263,'216.39.51.*'),(264,'68.142. 230.*'),(265,'64.157.138.*'),(266,'202.46.19.*'),(267,'159.226.20.*'),(268,'221.3.100 .*'),(269,'67.202.33.*'),(270,'75.101.197.*'),(271,'75.101.199.*'),(272,'75.101.205.*'),(273,'75.101.251.*');

--
-- Table structure for table `SMAccount`
--

CREATE TABLE `SMAccount` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `entered` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `username` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `password` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `permission` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `iprestriction` text COLLATE utf8_unicode_ci NOT NULL,
  `faillogin_count` int(11) NOT NULL DEFAULT '0',
  `faillogin_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `phone` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `complementary_info` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `active` varchar(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'y',
  PRIMARY KEY (`id`),
  KEY `username` (`username`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `SMAccount`
--


--
-- Table structure for table `SQL_Log`
--

CREATE TABLE `SQL_Log` (
  `sql` text COLLATE utf8_unicode_ci NOT NULL,
  `type` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `date` date NOT NULL,
  `time` time NOT NULL,
  `ip` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `page` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `session` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `username` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `execution_time` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `SQL_Log`
--


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

CREATE TABLE `Setting` (
  `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`
--

INSERT INTO `Setting` VALUES ('sitemgr_username','sitemgr@demodirectory.com'),('sitemgr_password','e99a18c428cb38d5f260853678922e03'),('sitemgr_faillogin_count','0'),('sitemgr_faillogin_datetime','0000-00-00 00:00:00'),('sitemgr_first_login','yes'),('sitemgr_language','en_us'),('complementary_info','e3d35c82b32a48c1496241bc482f90a5');


