--
-- Host: devdb.fusion-analytics.co.uk    Database: wf0
-- ------------------------------------------------------


--
-- Table structure for table `wf_access`
--

CREATE TABLE `wf_access` (
  `login` varchar(100) NOT NULL,
  `idsite` int(10) unsigned NOT NULL,
  `access` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`login`,`idsite`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wf_access`
--


--
-- Table structure for table `wf_archive_blob_2018_02`
--

CREATE TABLE `wf_archive_blob_2018_02` (
  `idarchive` int(10) unsigned NOT NULL,
  `name` varchar(255) NOT NULL,
  `idsite` int(10) unsigned DEFAULT NULL,
  `date1` date DEFAULT NULL,
  `date2` date DEFAULT NULL,
  `period` tinyint(3) unsigned DEFAULT NULL,
  `ts_archived` datetime DEFAULT NULL,
  `value` mediumblob,
  PRIMARY KEY (`idarchive`,`name`),
  KEY `index_period_archived` (`period`,`ts_archived`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wf_archive_blob_2018_02`
--


--
-- Table structure for table `wf_archive_blob_2018_03`
--

CREATE TABLE `wf_archive_blob_2018_03` (
  `idarchive` int(10) unsigned NOT NULL,
  `name` varchar(255) NOT NULL,
  `idsite` int(10) unsigned DEFAULT NULL,
  `date1` date DEFAULT NULL,
  `date2` date DEFAULT NULL,
  `period` tinyint(3) unsigned DEFAULT NULL,
  `ts_archived` datetime DEFAULT NULL,
  `value` mediumblob,
  PRIMARY KEY (`idarchive`,`name`),
  KEY `index_period_archived` (`period`,`ts_archived`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wf_archive_blob_2018_03`
--


--
-- Table structure for table `wf_archive_numeric_2018_02`
--

CREATE TABLE `wf_archive_numeric_2018_02` (
  `idarchive` int(10) unsigned NOT NULL,
  `name` varchar(255) NOT NULL,
  `idsite` int(10) unsigned DEFAULT NULL,
  `date1` date DEFAULT NULL,
  `date2` date DEFAULT NULL,
  `period` tinyint(3) unsigned DEFAULT NULL,
  `ts_archived` datetime DEFAULT NULL,
  `value` double DEFAULT NULL,
  PRIMARY KEY (`idarchive`,`name`),
  KEY `index_idsite_dates_period` (`idsite`,`date1`,`date2`,`period`,`ts_archived`),
  KEY `index_period_archived` (`period`,`ts_archived`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wf_archive_numeric_2018_02`
--

INSERT INTO `wf_archive_numeric_2018_02` VALUES (1,'done',1,'2018-02-17','2018-02-17',1,'2018-02-18 19:42:58',1),(2,'done',1,'2018-02-18','2018-02-18',1,'2018-02-18 19:42:58',3),(3,'donefea44bece172bc9696ae57c26888bf8a.VisitsSummary',1,'2018-02-17','2018-02-17',1,'2018-02-18 19:42:58',1),(4,'donefea44bece172bc9696ae57c26888bf8a.VisitsSummary',1,'2018-02-18','2018-02-18',1,'2018-02-18 19:42:58',3),(5,'done90a5a511e1974bca37613b6daec137ba.VisitsSummary',1,'2018-02-17','2018-02-17',1,'2018-02-18 19:42:58',1),(6,'done90a5a511e1974bca37613b6daec137ba.Goals',1,'2018-02-17','2018-02-17',1,'2018-02-18 19:42:58',1),(7,'done90a5a511e1974bca37613b6daec137ba.VisitsSummary',1,'2018-02-18','2018-02-18',1,'2018-02-18 19:42:58',3),(8,'done90a5a511e1974bca37613b6daec137ba.Goals',1,'2018-02-18','2018-02-18',1,'2018-02-18 19:42:58',3),(9,'donefea44bece172bc9696ae57c26888bf8a.Goals',1,'2018-02-17','2018-02-17',1,'2018-02-18 19:42:58',1),(10,'donefea44bece172bc9696ae57c26888bf8a.Goals',1,'2018-02-18','2018-02-18',1,'2018-02-18 19:42:58',3),(11,'done',1,'2018-02-01','2018-02-28',3,'2018-02-18 19:42:58',3),(12,'done',1,'2018-02-12','2018-02-18',2,'2018-02-18 19:42:58',3),(13,'done',1,'2018-02-19','2018-02-25',2,'2018-02-18 19:42:58',3),(14,'done',1,'2018-02-19','2018-02-19',1,'2018-02-18 19:42:58',3),(15,'done',1,'2018-02-20','2018-02-20',1,'2018-02-18 19:42:58',3),(16,'done',1,'2018-02-18','2018-02-18',1,'2018-03-02 21:00:05',1),(17,'done',1,'2018-02-19','2018-02-19',1,'2018-03-02 21:00:05',1),(18,'done',1,'2018-02-20','2018-02-20',1,'2018-03-02 21:00:05',1),(19,'done',1,'2018-02-21','2018-02-21',1,'2018-03-02 21:00:05',1),(20,'done',1,'2018-02-22','2018-02-22',1,'2018-03-02 21:00:05',1),(21,'done',1,'2018-02-23','2018-02-23',1,'2018-03-02 21:00:05',1),(22,'done',1,'2018-02-24','2018-02-24',1,'2018-03-02 21:00:05',1),(23,'done',1,'2018-02-25','2018-02-25',1,'2018-03-02 21:00:05',1),(24,'done',1,'2018-02-26','2018-02-26',1,'2018-03-02 21:00:05',1),(25,'done',1,'2018-02-27','2018-02-27',1,'2018-03-02 21:00:05',1),(26,'done',1,'2018-02-28','2018-02-28',1,'2018-03-02 21:00:05',1),(27,'donefea44bece172bc9696ae57c26888bf8a.VisitsSummary',1,'2018-02-18','2018-02-18',1,'2018-03-02 21:00:05',1),(28,'donefea44bece172bc9696ae57c26888bf8a.VisitsSummary',1,'2018-02-19','2018-02-19',1,'2018-03-02 21:00:05',1),(29,'donefea44bece172bc9696ae57c26888bf8a.VisitsSummary',1,'2018-02-20','2018-02-20',1,'2018-03-02 21:00:05',1),(30,'donefea44bece172bc9696ae57c26888bf8a.VisitsSummary',1,'2018-02-21','2018-02-21',1,'2018-03-02 21:00:05',1),(31,'donefea44bece172bc9696ae57c26888bf8a.VisitsSummary',1,'2018-02-22','2018-02-22',1,'2018-03-02 21:00:05',1),(32,'donefea44bece172bc9696ae57c26888bf8a.VisitsSummary',1,'2018-02-23','2018-02-23',1,'2018-03-02 21:00:05',1),(33,'donefea44bece172bc9696ae57c26888bf8a.VisitsSummary',1,'2018-02-24','2018-02-24',1,'2018-03-02 21:00:05',1),(34,'donefea44bece172bc9696ae57c26888bf8a.VisitsSummary',1,'2018-02-25','2018-02-25',1,'2018-03-02 21:00:06',1),(35,'donefea44bece172bc9696ae57c26888bf8a.VisitsSummary',1,'2018-02-26','2018-02-26',1,'2018-03-02 21:00:06',1),(36,'donefea44bece172bc9696ae57c26888bf8a.VisitsSummary',1,'2018-02-27','2018-02-27',1,'2018-03-02 21:00:06',1),(37,'donefea44bece172bc9696ae57c26888bf8a.VisitsSummary',1,'2018-02-28','2018-02-28',1,'2018-03-02 21:00:06',1),(38,'done90a5a511e1974bca37613b6daec137ba.VisitsSummary',1,'2018-02-18','2018-02-18',1,'2018-03-02 21:00:06',1),(39,'done90a5a511e1974bca37613b6daec137ba.Goals',1,'2018-02-18','2018-02-18',1,'2018-03-02 21:00:06',1),(40,'done90a5a511e1974bca37613b6daec137ba.VisitsSummary',1,'2018-02-19','2018-02-19',1,'2018-03-02 21:00:06',1),(41,'done90a5a511e1974bca37613b6daec137ba.Goals',1,'2018-02-19','2018-02-19',1,'2018-03-02 21:00:06',1),(42,'done90a5a511e1974bca37613b6daec137ba.VisitsSummary',1,'2018-02-20','2018-02-20',1,'2018-03-02 21:00:06',1),(43,'done90a5a511e1974bca37613b6daec137ba.Goals',1,'2018-02-20','2018-02-20',1,'2018-03-02 21:00:06',1),(44,'done90a5a511e1974bca37613b6daec137ba.VisitsSummary',1,'2018-02-21','2018-02-21',1,'2018-03-02 21:00:06',1),(45,'done90a5a511e1974bca37613b6daec137ba.Goals',1,'2018-02-21','2018-02-21',1,'2018-03-02 21:00:06',1),(46,'done90a5a511e1974bca37613b6daec137ba.VisitsSummary',1,'2018-02-22','2018-02-22',1,'2018-03-02 21:00:06',1),(47,'done90a5a511e1974bca37613b6daec137ba.Goals',1,'2018-02-22','2018-02-22',1,'2018-03-02 21:00:06',1),(48,'done90a5a511e1974bca37613b6daec137ba.VisitsSummary',1,'2018-02-23','2018-02-23',1,'2018-03-02 21:00:06',1),(49,'done90a5a511e1974bca37613b6daec137ba.Goals',1,'2018-02-23','2018-02-23',1,'2018-03-02 21:00:06',1),(50,'done90a5a511e1974bca37613b6daec137ba.VisitsSummary',1,'2018-02-24','2018-02-24',1,'2018-03-02 21:00:06',1),(51,'done90a5a511e1974bca37613b6daec137ba.Goals',1,'2018-02-24','2018-02-24',1,'2018-03-02 21:00:06',1),(52,'done90a5a511e1974bca37613b6daec137ba.VisitsSummary',1,'2018-02-25','2018-02-25',1,'2018-03-02 21:00:06',1),(53,'done90a5a511e1974bca37613b6daec137ba.Goals',1,'2018-02-25','2018-02-25',1,'2018-03-02 21:00:06',1),(54,'done90a5a511e1974bca37613b6daec137ba.VisitsSummary',1,'2018-02-26','2018-02-26',1,'2018-03-02 21:00:06',1),(55,'done90a5a511e1974bca37613b6daec137ba.Goals',1,'2018-02-26','2018-02-26',1,'2018-03-02 21:00:06',1),(56,'done90a5a511e1974bca37613b6daec137ba.VisitsSummary',1,'2018-02-27','2018-02-27',1,'2018-03-02 21:00:06',1),(57,'done90a5a511e1974bca37613b6daec137ba.Goals',1,'2018-02-27','2018-02-27',1,'2018-03-02 21:00:06',1),(58,'done90a5a511e1974bca37613b6daec137ba.VisitsSummary',1,'2018-02-28','2018-02-28',1,'2018-03-02 21:00:06',1),(59,'done90a5a511e1974bca37613b6daec137ba.Goals',1,'2018-02-28','2018-02-28',1,'2018-03-02 21:00:06',1),(60,'donefea44bece172bc9696ae57c26888bf8a.Goals',1,'2018-02-18','2018-02-18',1,'2018-03-02 21:00:06',1),(61,'donefea44bece172bc9696ae57c26888bf8a.Goals',1,'2018-02-19','2018-02-19',1,'2018-03-02 21:00:06',1),(62,'donefea44bece172bc9696ae57c26888bf8a.Goals',1,'2018-02-20','2018-02-20',1,'2018-03-02 21:00:06',1),(63,'donefea44bece172bc9696ae57c26888bf8a.Goals',1,'2018-02-21','2018-02-21',1,'2018-03-02 21:00:06',1),(64,'donefea44bece172bc9696ae57c26888bf8a.Goals',1,'2018-02-22','2018-02-22',1,'2018-03-02 21:00:06',1),(65,'donefea44bece172bc9696ae57c26888bf8a.Goals',1,'2018-02-23','2018-02-23',1,'2018-03-02 21:00:06',1),(66,'donefea44bece172bc9696ae57c26888bf8a.Goals',1,'2018-02-24','2018-02-24',1,'2018-03-02 21:00:06',1),(67,'donefea44bece172bc9696ae57c26888bf8a.Goals',1,'2018-02-25','2018-02-25',1,'2018-03-02 21:00:06',1),(68,'donefea44bece172bc9696ae57c26888bf8a.Goals',1,'2018-02-26','2018-02-26',1,'2018-03-02 21:00:06',1),(69,'donefea44bece172bc9696ae57c26888bf8a.Goals',1,'2018-02-27','2018-02-27',1,'2018-03-02 21:00:06',1),(70,'donefea44bece172bc9696ae57c26888bf8a.Goals',1,'2018-02-28','2018-02-28',1,'2018-03-02 21:00:06',1);

--
-- Table structure for table `wf_archive_numeric_2018_03`
--

CREATE TABLE `wf_archive_numeric_2018_03` (
  `idarchive` int(10) unsigned NOT NULL,
  `name` varchar(255) NOT NULL,
  `idsite` int(10) unsigned DEFAULT NULL,
  `date1` date DEFAULT NULL,
  `date2` date DEFAULT NULL,
  `period` tinyint(3) unsigned DEFAULT NULL,
  `ts_archived` datetime DEFAULT NULL,
  `value` double DEFAULT NULL,
  PRIMARY KEY (`idarchive`,`name`),
  KEY `index_idsite_dates_period` (`idsite`,`date1`,`date2`,`period`,`ts_archived`),
  KEY `index_period_archived` (`period`,`ts_archived`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wf_archive_numeric_2018_03`
--

INSERT INTO `wf_archive_numeric_2018_03` VALUES (1,'done',1,'2018-03-01','2018-03-01',1,'2018-03-02 21:00:05',1),(2,'done',1,'2018-03-01','2018-03-31',3,'2018-03-02 21:00:05',3),(3,'done',1,'2018-03-02','2018-03-02',1,'2018-03-02 21:00:05',3),(4,'done',1,'2018-03-03','2018-03-03',1,'2018-03-02 21:00:05',3),(5,'done',1,'2018-03-04','2018-03-04',1,'2018-03-02 21:00:05',3),(6,'donefea44bece172bc9696ae57c26888bf8a.VisitsSummary',1,'2018-03-01','2018-03-01',1,'2018-03-02 21:00:06',1),(7,'done90a5a511e1974bca37613b6daec137ba.VisitsSummary',1,'2018-03-01','2018-03-01',1,'2018-03-02 21:00:06',1),(8,'done90a5a511e1974bca37613b6daec137ba.Goals',1,'2018-03-01','2018-03-01',1,'2018-03-02 21:00:06',1),(9,'donefea44bece172bc9696ae57c26888bf8a.Goals',1,'2018-03-01','2018-03-01',1,'2018-03-02 21:00:06',1),(10,'done',1,'2018-03-03','2018-03-03',1,'2018-03-04 17:41:20',1),(11,'done',1,'2018-03-02','2018-03-02',1,'2018-03-04 17:41:21',1),(12,'done',1,'2018-03-04','2018-03-04',1,'2018-03-05 00:39:46',1);

--
-- Table structure for table `wf_custom_dimensions`
--

CREATE TABLE `wf_custom_dimensions` (
  `idcustomdimension` bigint(20) unsigned NOT NULL,
  `idsite` bigint(20) unsigned NOT NULL,
  `name` varchar(100) NOT NULL,
  `index` smallint(5) unsigned NOT NULL,
  `scope` varchar(10) NOT NULL,
  `active` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `extractions` text NOT NULL,
  `case_sensitive` tinyint(3) unsigned NOT NULL DEFAULT '1',
  UNIQUE KEY `idcustomdimension_idsite` (`idcustomdimension`,`idsite`),
  UNIQUE KEY `uniq_hash` (`idsite`,`scope`,`index`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wf_custom_dimensions`
--


--
-- Table structure for table `wf_goal`
--

CREATE TABLE `wf_goal` (
  `idsite` int(11) NOT NULL,
  `idgoal` int(11) NOT NULL,
  `name` varchar(50) NOT NULL,
  `description` varchar(255) NOT NULL DEFAULT '',
  `match_attribute` varchar(20) NOT NULL,
  `pattern` varchar(255) NOT NULL,
  `pattern_type` varchar(10) NOT NULL,
  `case_sensitive` tinyint(4) NOT NULL,
  `allow_multiple` tinyint(4) NOT NULL,
  `revenue` float NOT NULL,
  `deleted` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`idsite`,`idgoal`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wf_goal`
--


--
-- Table structure for table `wf_log_conversion`
--

CREATE TABLE `wf_log_conversion` (
  `idvisit` bigint(10) unsigned NOT NULL,
  `idsite` int(10) unsigned NOT NULL,
  `idvisitor` binary(8) NOT NULL,
  `server_time` datetime NOT NULL,
  `idaction_url` int(10) unsigned DEFAULT NULL,
  `idlink_va` bigint(10) unsigned DEFAULT NULL,
  `idgoal` int(10) NOT NULL,
  `buster` int(10) unsigned NOT NULL,
  `idorder` varchar(100) DEFAULT NULL,
  `items` smallint(5) unsigned DEFAULT NULL,
  `url` text NOT NULL,
  `visitor_days_since_first` smallint(5) unsigned DEFAULT NULL,
  `visitor_days_since_order` smallint(5) unsigned DEFAULT NULL,
  `visitor_returning` tinyint(1) DEFAULT NULL,
  `visitor_count_visits` int(11) unsigned NOT NULL,
  `referer_keyword` varchar(255) DEFAULT NULL,
  `referer_name` varchar(70) DEFAULT NULL,
  `referer_type` tinyint(1) unsigned DEFAULT NULL,
  `config_device_brand` varchar(100) DEFAULT NULL,
  `config_device_model` varchar(100) DEFAULT NULL,
  `config_device_type` tinyint(100) DEFAULT NULL,
  `location_city` varchar(255) DEFAULT NULL,
  `location_country` char(3) DEFAULT NULL,
  `location_latitude` decimal(9,6) DEFAULT NULL,
  `location_longitude` decimal(9,6) DEFAULT NULL,
  `location_region` char(2) DEFAULT NULL,
  `revenue_discount` float DEFAULT NULL,
  `revenue` float DEFAULT NULL,
  `revenue_shipping` float DEFAULT NULL,
  `revenue_subtotal` float DEFAULT NULL,
  `revenue_tax` float DEFAULT NULL,
  `custom_var_k1` varchar(200) DEFAULT NULL,
  `custom_var_v1` varchar(200) DEFAULT NULL,
  `custom_var_k2` varchar(200) DEFAULT NULL,
  `custom_var_v2` varchar(200) DEFAULT NULL,
  `custom_var_k3` varchar(200) DEFAULT NULL,
  `custom_var_v3` varchar(200) DEFAULT NULL,
  `custom_var_k4` varchar(200) DEFAULT NULL,
  `custom_var_v4` varchar(200) DEFAULT NULL,
  `custom_var_k5` varchar(200) DEFAULT NULL,
  `custom_var_v5` varchar(200) DEFAULT NULL,
  `custom_dimension_1` varchar(255) DEFAULT NULL,
  `custom_dimension_2` varchar(255) DEFAULT NULL,
  `custom_dimension_3` varchar(255) DEFAULT NULL,
  `custom_dimension_4` varchar(255) DEFAULT NULL,
  `custom_dimension_5` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`idvisit`,`idgoal`,`buster`),
  UNIQUE KEY `unique_idsite_idorder` (`idsite`,`idorder`),
  KEY `index_idsite_datetime` (`idsite`,`server_time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wf_log_conversion`
--


--
-- Table structure for table `wf_log_conversion_item`
--

CREATE TABLE `wf_log_conversion_item` (
  `idsite` int(10) unsigned NOT NULL,
  `idvisitor` binary(8) NOT NULL,
  `server_time` datetime NOT NULL,
  `idvisit` bigint(10) unsigned NOT NULL,
  `idorder` varchar(100) NOT NULL,
  `idaction_sku` int(10) unsigned NOT NULL,
  `idaction_name` int(10) unsigned NOT NULL,
  `idaction_category` int(10) unsigned NOT NULL,
  `idaction_category2` int(10) unsigned NOT NULL,
  `idaction_category3` int(10) unsigned NOT NULL,
  `idaction_category4` int(10) unsigned NOT NULL,
  `idaction_category5` int(10) unsigned NOT NULL,
  `price` float NOT NULL,
  `quantity` int(10) unsigned NOT NULL,
  `deleted` tinyint(1) unsigned NOT NULL,
  PRIMARY KEY (`idvisit`,`idorder`,`idaction_sku`),
  KEY `index_idsite_servertime` (`idsite`,`server_time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wf_log_conversion_item`
--


--
-- Table structure for table `wf_log_link_visit_action`
--

CREATE TABLE `wf_log_link_visit_action` (
  `idlink_va` bigint(10) unsigned NOT NULL AUTO_INCREMENT,
  `idsite` int(10) unsigned NOT NULL,
  `idvisitor` binary(8) NOT NULL,
  `idvisit` bigint(10) unsigned NOT NULL,
  `idaction_url_ref` int(10) unsigned DEFAULT '0',
  `idaction_name_ref` int(10) unsigned DEFAULT NULL,
  `custom_float` float DEFAULT NULL,
  `server_time` datetime NOT NULL,
  `idpageview` char(6) DEFAULT NULL,
  `interaction_position` smallint(5) unsigned DEFAULT NULL,
  `idaction_name` int(10) unsigned DEFAULT NULL,
  `idaction_url` int(10) unsigned DEFAULT NULL,
  `time_spent_ref_action` int(10) unsigned DEFAULT NULL,
  `idaction_event_action` int(10) unsigned DEFAULT NULL,
  `idaction_event_category` int(10) unsigned DEFAULT NULL,
  `idaction_content_interaction` int(10) unsigned DEFAULT NULL,
  `idaction_content_name` int(10) unsigned DEFAULT NULL,
  `idaction_content_piece` int(10) unsigned DEFAULT NULL,
  `idaction_content_target` int(10) unsigned DEFAULT NULL,
  `custom_var_k1` varchar(200) DEFAULT NULL,
  `custom_var_v1` varchar(200) DEFAULT NULL,
  `custom_var_k2` varchar(200) DEFAULT NULL,
  `custom_var_v2` varchar(200) DEFAULT NULL,
  `custom_var_k3` varchar(200) DEFAULT NULL,
  `custom_var_v3` varchar(200) DEFAULT NULL,
  `custom_var_k4` varchar(200) DEFAULT NULL,
  `custom_var_v4` varchar(200) DEFAULT NULL,
  `custom_var_k5` varchar(200) DEFAULT NULL,
  `custom_var_v5` varchar(200) DEFAULT NULL,
  `time_spent` int(10) unsigned DEFAULT NULL,
  `custom_dimension_1` varchar(255) DEFAULT NULL,
  `custom_dimension_2` varchar(255) DEFAULT NULL,
  `custom_dimension_3` varchar(255) DEFAULT NULL,
  `custom_dimension_4` varchar(255) DEFAULT NULL,
  `custom_dimension_5` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`idlink_va`),
  KEY `index_idvisit` (`idvisit`),
  KEY `index_idsite_servertime` (`idsite`,`server_time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wf_log_link_visit_action`
--


--
-- Table structure for table `wf_log_profiling`
--

CREATE TABLE `wf_log_profiling` (
  `query` text NOT NULL,
  `count` int(10) unsigned DEFAULT NULL,
  `sum_time_ms` float DEFAULT NULL,
  UNIQUE KEY `query` (`query`(100))
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wf_log_profiling`
--


--
-- Table structure for table `wf_logger_message`
--

CREATE TABLE `wf_logger_message` (
  `idlogger_message` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `tag` varchar(50) DEFAULT NULL,
  `timestamp` timestamp NULL DEFAULT NULL,
  `level` varchar(16) DEFAULT NULL,
  `message` text,
  PRIMARY KEY (`idlogger_message`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wf_logger_message`
--


--
-- Table structure for table `wf_option`
--

CREATE TABLE `wf_option` (
  `option_name` varchar(255) NOT NULL,
  `option_value` longtext NOT NULL,
  `autoload` tinyint(4) NOT NULL DEFAULT '1',
  PRIMARY KEY (`option_name`),
  KEY `autoload` (`autoload`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wf_option`
--

INSERT INTO `wf_option` VALUES ('branding_use_custom_logo','1',1),('MobileMessaging_DelegatedManagement','false',0),('piwikUrl','https://wf0.mywebdata.co.uk/0/',1),('PrivacyManager.doNotTrackEnabled','1',0),('PrivacyManager.ipAnonymizerEnabled','0',0),('SitesManager_DefaultTimezone','Europe/London',0),('UpdateCheck_LastTimeChecked','1531153786',1),('UpdateCheck_LatestVersion','3.5.1',0),('UsersManager.lastSeen.Fusion','1520210278',1),('version_Actions','3.3.0',1),('version_Annotations','3.3.0',1),('version_API','3.3.0',1),('version_BulkTracking','3.3.0',1),('version_Contents','3.3.0',1),('version_core','3.3.0',1),('version_CoreAdminHome','3.3.0',1),('version_CoreConsole','3.3.0',1),('version_CoreHome','3.3.0',1),('version_CorePluginsAdmin','3.3.0',1),('version_CoreUpdater','3.3.0',1),('version_CoreVisualizations','3.3.0',1),('version_CustomDimensions','3.1.2',1),('version_CustomPiwikJs','3.3.0',1),('version_CustomVariables','3.3.0',1),('version_Dashboard','3.3.0',1),('version_DevicePlugins','3.3.0',1),('version_DevicesDetection','3.3.0',1),('version_Diagnostics','3.3.0',1),('version_Ecommerce','3.3.0',1),('version_Events','3.3.0',1),('version_ExampleAPI','1.0',1),('version_ExamplePlugin','0.1.0',1),('version_Feedback','3.3.0',1),('version_Goals','3.3.0',1),('version_Heartbeat','3.3.0',1),('version_ImageGraph','3.3.0',1),('version_Insights','3.3.0',1),('version_Installation','3.3.0',1),('version_Intl','3.3.0',1),('version_LanguagesManager','3.3.0',1),('version_Live','3.3.0',1),('version_Login','3.3.0',1),('version_log_conversion.revenue','float default NULL',1),('version_log_conversion.revenue_discount','float default NULL',1),('version_log_conversion.revenue_shipping','float default NULL',1),('version_log_conversion.revenue_subtotal','float default NULL',1),('version_log_conversion.revenue_tax','float default NULL',1),('version_log_link_visit_action.idaction_content_interaction','INTEGER(10) UNSIGNED DEFAULT NULL',1),('version_log_link_visit_action.idaction_content_name','INTEGER(10) UNSIGNED DEFAULT NULL',1),('version_log_link_visit_action.idaction_content_piece','INTEGER(10) UNSIGNED DEFAULT NULL',1),('version_log_link_visit_action.idaction_content_target','INTEGER(10) UNSIGNED DEFAULT NULL',1),('version_log_link_visit_action.idaction_event_action','INTEGER(10) UNSIGNED DEFAULT NULL',1),('version_log_link_visit_action.idaction_event_category','INTEGER(10) UNSIGNED DEFAULT NULL',1),('version_log_link_visit_action.idaction_name','INTEGER(10) UNSIGNED',1),('version_log_link_visit_action.idaction_url','INTEGER(10) UNSIGNED DEFAULT NULL',1),('version_log_link_visit_action.idpageview','CHAR(6) NULL DEFAULT NULL',1),('version_log_link_visit_action.interaction_position','SMALLINT UNSIGNED DEFAULT NULL',1),('version_log_link_visit_action.server_time','DATETIME NOT NULL',1),('version_log_link_visit_action.time_spent_ref_action','INTEGER(10) UNSIGNED NULL',1),('version_log_visit.config_browser_engine','VARCHAR(10) NULL',1),('version_log_visit.config_browser_name','VARCHAR(10) NULL',1),('version_log_visit.config_browser_version','VARCHAR(20) NULL',1),('version_log_visit.config_cookie','TINYINT(1) NULL',1),('version_log_visit.config_device_brand','VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL1',1),('version_log_visit.config_device_model','VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL1',1),('version_log_visit.config_device_type','TINYINT( 100 ) NULL DEFAULT NULL1',1),('version_log_visit.config_director','TINYINT(1) NULL',1),('version_log_visit.config_flash','TINYINT(1) NULL',1),('version_log_visit.config_gears','TINYINT(1) NULL',1),('version_log_visit.config_java','TINYINT(1) NULL',1),('version_log_visit.config_os','CHAR(3) NULL',1),('version_log_visit.config_os_version','VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL',1),('version_log_visit.config_pdf','TINYINT(1) NULL',1),('version_log_visit.config_quicktime','TINYINT(1) NULL',1),('version_log_visit.config_realplayer','TINYINT(1) NULL',1),('version_log_visit.config_resolution','VARCHAR(18) NULL',1),('version_log_visit.config_silverlight','TINYINT(1) NULL',1),('version_log_visit.config_windowsmedia','TINYINT(1) NULL',1),('version_log_visit.location_browser_lang','VARCHAR(20) NULL',1),('version_log_visit.location_city','varchar(255) DEFAULT NULL1',1),('version_log_visit.location_country','CHAR(3) NULL1',1),('version_log_visit.location_latitude','decimal(9, 6) DEFAULT NULL1',1),('version_log_visit.location_longitude','decimal(9, 6) DEFAULT NULL1',1),('version_log_visit.location_region','char(2) DEFAULT NULL1',1),('version_log_visit.referer_keyword','VARCHAR(255) NULL1',1),('version_log_visit.referer_name','VARCHAR(70) NULL1',1),('version_log_visit.referer_type','TINYINT(1) UNSIGNED NULL1',1),('version_log_visit.referer_url','TEXT NULL',1),('version_log_visit.user_id','VARCHAR(200) NULL',1),('version_log_visit.visitor_count_visits','INT(11) UNSIGNED NOT NULL1',1),('version_log_visit.visitor_days_since_first','SMALLINT(5) UNSIGNED NULL1',1),('version_log_visit.visitor_days_since_last','SMALLINT(5) UNSIGNED NULL',1),('version_log_visit.visitor_days_since_order','SMALLINT(5) UNSIGNED NULL1',1),('version_log_visit.visitor_localtime','TIME NULL',1),('version_log_visit.visitor_returning','TINYINT(1) NULL1',1),('version_log_visit.visit_entry_idaction_name','INTEGER(10) UNSIGNED NULL',1),('version_log_visit.visit_entry_idaction_url','INTEGER(11) UNSIGNED NULL  DEFAULT NULL',1),('version_log_visit.visit_exit_idaction_name','INTEGER(10) UNSIGNED NULL',1),('version_log_visit.visit_exit_idaction_url','INTEGER(10) UNSIGNED NULL DEFAULT 0',1),('version_log_visit.visit_first_action_time','DATETIME NOT NULL',1),('version_log_visit.visit_goal_buyer','TINYINT(1) NULL',1),('version_log_visit.visit_goal_converted','TINYINT(1) NULL',1),('version_log_visit.visit_total_actions','INT(11) UNSIGNED NULL',1),('version_log_visit.visit_total_events','INT(11) UNSIGNED NULL',1),('version_log_visit.visit_total_interactions','SMALLINT UNSIGNED DEFAULT 0',1),('version_log_visit.visit_total_searches','SMALLINT(5) UNSIGNED NULL',1),('version_log_visit.visit_total_time','INT(11) UNSIGNED NOT NULL',1),('version_Marketplace','3.3.0',1),('version_MobileMessaging','3.3.0',1),('version_Monolog','3.3.0',1),('version_Morpheus','3.3.0',1),('version_MultiSites','3.3.0',1),('version_Overlay','3.3.0',1),('version_PrivacyManager','3.3.0',1),('version_ProfessionalServices','3.3.0',1),('version_Proxy','3.3.0',1),('version_QueuedTracking','3.1.0',1),('version_Referrers','3.3.0',1),('version_Resolution','3.3.0',1),('version_RssWidget','1.0',1),('version_ScheduledReports','3.3.0',1),('version_SegmentEditor','3.3.0',1),('version_SEO','3.3.0',1),('version_SitesManager','3.3.0',1),('version_Transitions','3.3.0',1),('version_UserCountry','3.3.0',1),('version_UserCountryMap','3.3.0',1),('version_UserId','3.3.0',1),('version_UserLanguage','3.3.0',1),('version_UsersManager','3.3.0',1),('version_VisitFrequency','3.3.0',1),('version_VisitorInterest','3.3.0',1),('version_VisitsSummary','3.3.0',1),('version_VisitTime','3.3.0',1),('version_WebsiteMeasurable','3.3.0',1),('version_Widgetize','3.3.0',1);

--
-- Table structure for table `wf_plugin_setting`
--

CREATE TABLE `wf_plugin_setting` (
  `plugin_name` varchar(60) NOT NULL,
  `setting_name` varchar(255) NOT NULL,
  `setting_value` longtext NOT NULL,
  `user_login` varchar(100) NOT NULL DEFAULT '',
  KEY `plugin_name` (`plugin_name`,`user_login`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wf_plugin_setting`
--


--
-- Table structure for table `wf_report`
--

CREATE TABLE `wf_report` (
  `idreport` int(11) NOT NULL AUTO_INCREMENT,
  `idsite` int(11) NOT NULL,
  `login` varchar(100) NOT NULL,
  `description` varchar(255) NOT NULL,
  `idsegment` int(11) DEFAULT NULL,
  `period` varchar(10) NOT NULL,
  `hour` tinyint(4) NOT NULL DEFAULT '0',
  `type` varchar(10) NOT NULL,
  `format` varchar(10) NOT NULL,
  `reports` text NOT NULL,
  `parameters` text,
  `ts_created` timestamp NULL DEFAULT NULL,
  `ts_last_sent` timestamp NULL DEFAULT NULL,
  `deleted` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`idreport`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wf_report`
--


--
-- Table structure for table `wf_segment`
--

CREATE TABLE `wf_segment` (
  `idsegment` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `definition` text NOT NULL,
  `login` varchar(100) NOT NULL,
  `enable_all_users` tinyint(4) NOT NULL DEFAULT '0',
  `enable_only_idsite` int(11) DEFAULT NULL,
  `auto_archive` tinyint(4) NOT NULL DEFAULT '0',
  `ts_created` timestamp NULL DEFAULT NULL,
  `ts_last_edit` timestamp NULL DEFAULT NULL,
  `deleted` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`idsegment`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wf_segment`
--


--
-- Table structure for table `wf_sequence`
--

CREATE TABLE `wf_sequence` (
  `name` varchar(120) NOT NULL,
  `value` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wf_sequence`
--

INSERT INTO `wf_sequence` VALUES ('wf_archive_numeric_2018_02',70),('wf_archive_numeric_2018_03',12);

--
-- Table structure for table `wf_session`
--

CREATE TABLE `wf_session` (
  `id` varchar(255) NOT NULL,
  `modified` int(11) DEFAULT NULL,
  `lifetime` int(11) DEFAULT NULL,
  `data` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wf_session`
--


--
-- Table structure for table `wf_site`
--

CREATE TABLE `wf_site` (
  `idsite` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(90) NOT NULL,
  `main_url` varchar(255) NOT NULL,
  `ts_created` timestamp NULL DEFAULT NULL,
  `ecommerce` tinyint(4) DEFAULT '0',
  `sitesearch` tinyint(4) DEFAULT '1',
  `sitesearch_keyword_parameters` text NOT NULL,
  `sitesearch_category_parameters` text NOT NULL,
  `timezone` varchar(50) NOT NULL,
  `currency` char(3) NOT NULL,
  `exclude_unknown_urls` tinyint(1) DEFAULT '0',
  `excluded_ips` text NOT NULL,
  `excluded_parameters` text NOT NULL,
  `excluded_user_agents` text NOT NULL,
  `group` varchar(250) NOT NULL,
  `type` varchar(255) NOT NULL,
  `keep_url_fragment` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`idsite`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wf_site`
--

INSERT INTO `wf_site` VALUES (1,'Fusion','http://www.fusion-analytics.co.uk','2018-02-18 19:42:11',0,1,'','','Europe/London','USD',0,'','','','','website',0);

--
-- Table structure for table `wf_site_setting`
--

CREATE TABLE `wf_site_setting` (
  `idsite` int(10) unsigned NOT NULL,
  `plugin_name` varchar(60) NOT NULL,
  `setting_name` varchar(255) NOT NULL,
  `setting_value` longtext NOT NULL,
  KEY `idsite` (`idsite`,`plugin_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wf_site_setting`
--


--
-- Table structure for table `wf_site_url`
--

CREATE TABLE `wf_site_url` (
  `idsite` int(10) unsigned NOT NULL,
  `url` varchar(255) NOT NULL,
  PRIMARY KEY (`idsite`,`url`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wf_site_url`
--


--
-- Table structure for table `wf_user_dashboard`
--

CREATE TABLE `wf_user_dashboard` (
  `login` varchar(100) NOT NULL,
  `iddashboard` int(11) NOT NULL,
  `name` varchar(100) DEFAULT NULL,
  `layout` text NOT NULL,
  PRIMARY KEY (`login`,`iddashboard`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wf_user_dashboard`
--


--
-- Table structure for table `wf_user_language`
--

CREATE TABLE `wf_user_language` (
  `login` varchar(100) NOT NULL,
  `language` varchar(10) NOT NULL,
  `use_12_hour_clock` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`login`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wf_user_language`
--



