Server IP : 66.29.132.124 / Your IP : 18.221.217.100 Web Server : LiteSpeed System : Linux business141.web-hosting.com 4.18.0-553.lve.el8.x86_64 #1 SMP Mon May 27 15:27:34 UTC 2024 x86_64 User : wavevlvu ( 1524) PHP Version : 7.4.33 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /var/softaculous/piwik/ |
Upload File : |
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- Database: `matomo520` -- -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]access` -- CREATE TABLE `[[dbprefix]]access` ( `idaccess` int(10) unsigned NOT NULL AUTO_INCREMENT, `login` varchar(100) NOT NULL, `idsite` int(10) unsigned NOT NULL, `access` varchar(50) DEFAULT NULL, PRIMARY KEY (`idaccess`), KEY `index_loginidsite` (`login`,`idsite`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]archive_invalidations` -- CREATE TABLE `[[dbprefix]]archive_invalidations` ( `idinvalidation` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `idarchive` int(10) unsigned DEFAULT NULL, `name` varchar(255) NOT NULL, `idsite` int(10) unsigned NOT NULL, `date1` date NOT NULL, `date2` date NOT NULL, `period` tinyint(3) unsigned NOT NULL, `ts_invalidated` datetime DEFAULT NULL, `ts_started` datetime DEFAULT NULL, `status` tinyint(1) unsigned DEFAULT '0', `report` varchar(255) DEFAULT NULL, PRIMARY KEY (`idinvalidation`), KEY `index_idsite_dates_period_name` (`idsite`,`date1`,`period`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]brute_force_log` -- CREATE TABLE `[[dbprefix]]brute_force_log` ( `id_brute_force_log` bigint(11) NOT NULL AUTO_INCREMENT, `ip_address` varchar(60) DEFAULT NULL, `attempted_at` datetime NOT NULL, `login` varchar(100) DEFAULT NULL, PRIMARY KEY (`id_brute_force_log`), KEY `index_ip_address` (`ip_address`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]changes` -- CREATE TABLE `[[dbprefix]]changes` ( `idchange` int(10) unsigned NOT NULL AUTO_INCREMENT, `created_time` datetime NOT NULL, `plugin_name` varchar(60) NOT NULL, `version` varchar(20) NOT NULL, `title` varchar(255) NOT NULL, `description` text, `link_name` varchar(255) DEFAULT NULL, `link` varchar(255) DEFAULT NULL, PRIMARY KEY (`idchange`), UNIQUE KEY `unique_plugin_version_title` (`plugin_name`,`version`,`title`(100)) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]custom_dimensions` -- CREATE TABLE `[[dbprefix]]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', PRIMARY KEY (`idcustomdimension`,`idsite`), UNIQUE KEY `uniq_hash` (`idsite`,`scope`,`index`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]goal` -- CREATE TABLE `[[dbprefix]]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(25) NOT NULL, `case_sensitive` tinyint(4) NOT NULL, `allow_multiple` tinyint(4) NOT NULL, `revenue` double NOT NULL, `deleted` tinyint(4) NOT NULL DEFAULT '0', `event_value_as_revenue` tinyint(4) NOT NULL DEFAULT '0', PRIMARY KEY (`idsite`,`idgoal`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]locks` -- CREATE TABLE `[[dbprefix]]locks` ( `key` varchar(70) NOT NULL, `value` varchar(255) DEFAULT NULL, `expiry_time` bigint(20) unsigned DEFAULT '9999999999', PRIMARY KEY (`key`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]logger_message` -- CREATE TABLE `[[dbprefix]]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=utf8mb4 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]log_action` -- CREATE TABLE `[[dbprefix]]log_action` ( `idaction` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(4096) DEFAULT NULL, `hash` int(10) unsigned NOT NULL, `type` tinyint(3) unsigned DEFAULT NULL, `url_prefix` tinyint(2) DEFAULT NULL, PRIMARY KEY (`idaction`), KEY `index_type_hash` (`type`,`hash`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]log_conversion` -- CREATE TABLE `[[dbprefix]]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` varchar(4096) NOT NULL, `revenue` float DEFAULT NULL, `revenue_shipping` double DEFAULT NULL, `revenue_subtotal` double DEFAULT NULL, `revenue_tax` double DEFAULT NULL, `revenue_discount` double DEFAULT NULL, `pageviews_before` smallint(5) unsigned DEFAULT NULL, `visitor_returning` tinyint(1) DEFAULT NULL, `visitor_seconds_since_first` int(11) unsigned DEFAULT NULL, `visitor_seconds_since_order` int(11) unsigned DEFAULT NULL, `visitor_count_visits` int(11) unsigned NOT NULL DEFAULT '0', `referer_keyword` varchar(255) DEFAULT NULL, `referer_name` varchar(255) DEFAULT NULL, `referer_type` tinyint(1) unsigned DEFAULT NULL, `config_browser_name` varchar(40) DEFAULT NULL, `config_client_type` tinyint(1) DEFAULT NULL, `config_device_brand` varchar(100) CHARACTER SET utf8 DEFAULT NULL, `config_device_model` varchar(100) CHARACTER SET utf8 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(3) 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=utf8mb4 ROW_FORMAT=DYNAMIC; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]log_conversion_item` -- CREATE TABLE `[[dbprefix]]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` double 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=utf8mb4 ROW_FORMAT=DYNAMIC; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]log_link_visit_action` -- CREATE TABLE `[[dbprefix]]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` double DEFAULT NULL, `pageview_position` mediumint(8) unsigned DEFAULT NULL, `server_time` datetime NOT NULL, `idpageview` char(6) DEFAULT NULL, `idaction_name` int(10) unsigned DEFAULT NULL, `idaction_url` int(10) unsigned DEFAULT NULL, `search_cat` varchar(200) DEFAULT NULL, `search_count` int(10) unsigned DEFAULT NULL, `time_spent_ref_action` int(10) unsigned DEFAULT NULL, `idaction_product_cat` int(10) unsigned DEFAULT NULL, `idaction_product_cat2` int(10) unsigned DEFAULT NULL, `idaction_product_cat3` int(10) unsigned DEFAULT NULL, `idaction_product_cat4` int(10) unsigned DEFAULT NULL, `idaction_product_cat5` int(10) unsigned DEFAULT NULL, `idaction_product_name` int(10) unsigned DEFAULT NULL, `product_price` double DEFAULT NULL, `idaction_product_sku` 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, `time_dom_completion` mediumint(10) unsigned DEFAULT NULL, `time_dom_processing` mediumint(10) unsigned DEFAULT NULL, `time_network` mediumint(10) unsigned DEFAULT NULL, `time_on_load` mediumint(10) unsigned DEFAULT NULL, `time_server` mediumint(10) unsigned DEFAULT NULL, `time_transfer` mediumint(10) unsigned 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=utf8mb4 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]log_profiling` -- CREATE TABLE `[[dbprefix]]log_profiling` ( `query` text NOT NULL, `count` int(10) unsigned DEFAULT NULL, `sum_time_ms` float DEFAULT NULL, `idprofiling` bigint(20) unsigned NOT NULL AUTO_INCREMENT, PRIMARY KEY (`idprofiling`), UNIQUE KEY `query` (`query`(100)) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]log_visit` -- CREATE TABLE `[[dbprefix]]log_visit` ( `idvisit` bigint(10) unsigned NOT NULL AUTO_INCREMENT, `idsite` int(10) unsigned NOT NULL, `idvisitor` binary(8) NOT NULL, `visit_last_action_time` datetime NOT NULL, `config_id` binary(8) NOT NULL, `location_ip` varbinary(16) NOT NULL, `profilable` tinyint(1) DEFAULT NULL, `user_id` varchar(200) DEFAULT NULL, `visit_first_action_time` datetime NOT NULL, `visit_goal_buyer` tinyint(1) DEFAULT NULL, `visit_goal_converted` tinyint(1) DEFAULT NULL, `visitor_returning` tinyint(1) DEFAULT NULL, `visitor_seconds_since_first` int(11) unsigned DEFAULT NULL, `visitor_seconds_since_order` int(11) unsigned DEFAULT NULL, `visitor_count_visits` int(11) unsigned NOT NULL DEFAULT '0', `visit_entry_idaction_name` int(10) unsigned DEFAULT NULL, `visit_entry_idaction_url` int(11) unsigned DEFAULT NULL, `visit_exit_idaction_name` int(10) unsigned DEFAULT NULL, `visit_exit_idaction_url` int(10) unsigned DEFAULT '0', `visit_total_actions` int(11) unsigned DEFAULT NULL, `visit_total_interactions` mediumint(8) unsigned DEFAULT '0', `visit_total_searches` smallint(5) unsigned DEFAULT NULL, `referer_keyword` varchar(255) DEFAULT NULL, `referer_name` varchar(255) DEFAULT NULL, `referer_type` tinyint(1) unsigned DEFAULT NULL, `referer_url` varchar(1500) DEFAULT NULL, `location_browser_lang` varchar(20) DEFAULT NULL, `config_browser_engine` varchar(10) DEFAULT NULL, `config_browser_name` varchar(40) DEFAULT NULL, `config_browser_version` varchar(20) DEFAULT NULL, `config_client_type` tinyint(1) DEFAULT NULL, `config_device_brand` varchar(100) CHARACTER SET utf8 DEFAULT NULL, `config_device_model` varchar(100) CHARACTER SET utf8 DEFAULT NULL, `config_device_type` tinyint(100) DEFAULT NULL, `config_os` char(3) DEFAULT NULL, `config_os_version` varchar(100) CHARACTER SET utf8 DEFAULT NULL, `visit_total_events` int(11) unsigned DEFAULT NULL, `visitor_localtime` time DEFAULT NULL, `visitor_seconds_since_last` int(11) unsigned DEFAULT NULL, `config_resolution` varchar(18) DEFAULT NULL, `config_cookie` tinyint(1) DEFAULT NULL, `config_flash` tinyint(1) DEFAULT NULL, `config_java` tinyint(1) DEFAULT NULL, `config_pdf` tinyint(1) DEFAULT NULL, `config_quicktime` tinyint(1) DEFAULT NULL, `config_realplayer` tinyint(1) DEFAULT NULL, `config_silverlight` tinyint(1) DEFAULT NULL, `config_windowsmedia` tinyint(1) DEFAULT NULL, `visit_total_time` int(11) unsigned NOT 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(3) DEFAULT NULL, `last_idlink_va` bigint(20) 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 (`idvisit`), KEY `index_idsite_config_datetime` (`idsite`,`config_id`,`visit_last_action_time`), KEY `index_idsite_datetime` (`idsite`,`visit_last_action_time`), KEY `index_idsite_idvisitor_time` (`idsite`,`idvisitor`,`visit_last_action_time`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]option` -- CREATE TABLE `[[dbprefix]]option` ( `option_name` varchar(191) 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=utf8mb4 ROW_FORMAT=DYNAMIC; -- -- Dumping data for table `[[dbprefix]]option` -- INSERT INTO `[[dbprefix]]option` VALUES ('fingerprint_salt_1_[[date_dby]]', '{"value":"[[fingerprint_salt1]]","time":[[timestamp]]}', 0), ('fingerprint_salt_1_[[date_yesterday]]', '{"value":"[[fingerprint_salt2]]","time":[[timestamp]]}', 0), ('fingerprint_salt_1_[[date_today]]', '{"value":"[[fingerprint_salt3]]","time":[[timestamp]]}', 0), ('fingerprint_salt_1_[[date_tomorrow]]', '{"value":"[[fingerprint_salt4]]","time":[[timestamp]]}', 0), ('geoip2.loc_db_url', 'https://download.db-ip.com/free/dbip-city-lite-2024-12.mmdb.gz', 0), ('geoip2.updater_last_run_time', '[[timestamp]]', 0), ('geoip2.updater_period', 'month', 0), ('install_mail_sent', '1', 0), ('install_version', '5.2.0', 0), ('MatomoUpdateHistory', '5.2.0,', 0), ('MobileMessaging_DelegatedManagement', 'false', 0), ('piwikUrl', '[[softurl]]/', 1), ('PrivacyManager.ipAnonymizerEnabled', '1', 0), ('SitesManager_DefaultCurrency', 'USD', 0), ('SitesManager_DefaultTimezone', 'America/New_York', 0), ('TaskScheduler.timetable', 'a:1:{s:45:"Piwik\\Plugins\\GeoIp2\\GeoIP2AutoUpdater.update";i:[[timestamp_nextday]];}', 0), ('UpdateCheck_LastCheckFailed', '', 0), ('UpdateCheck_LastTimeChecked', '[[timestamp]]', 1), ('UpdateCheck_LatestVersion', '5.2.0', 0), ('useridsalt', '', 1), ('UsersManager.lastSeen.super user was set', '[[timestamp]]', 1), ('version_Actions', '5.2.0', 1), ('version_Annotations', '5.2.0', 1), ('version_API', '5.2.0', 1), ('version_BulkTracking', '5.2.0', 1), ('version_Contents', '5.2.0', 1), ('version_core', '5.2.0', 1), ('version_CoreAdminHome', '5.2.0', 1), ('version_CoreConsole', '5.2.0', 1), ('version_CoreHome', '5.2.0', 1), ('version_CorePluginsAdmin', '5.2.0', 1), ('version_CoreUpdater', '5.2.0', 1), ('version_CoreVisualizations', '5.2.0', 1), ('version_CoreVue', '5.2.0', 1), ('version_CustomDimensions', '5.2.0', 1), ('version_CustomJsTracker', '5.2.0', 1), ('version_Dashboard', '5.2.0', 1), ('version_DevicePlugins', '5.2.0', 1), ('version_DevicesDetection', '5.2.0', 1), ('version_Diagnostics', '5.2.0', 1), ('version_Ecommerce', '5.2.0', 1), ('version_Events', '5.2.0', 1), ('version_FeatureFlags', '5.2.0', 1), ('version_Feedback', '5.2.0', 1), ('version_GeoIp2', '5.2.0', 1), ('version_Goals', '5.2.0', 1), ('version_Heartbeat', '5.2.0', 1), ('version_ImageGraph', '5.2.0', 1), ('version_Insights', '5.2.0', 1), ('version_Installation', '5.2.0', 1), ('version_Intl', '5.2.0', 1), ('version_IntranetMeasurable', '5.2.0', 1), ('version_JsTrackerInstallCheck', '5.2.0', 1), ('version_LanguagesManager', '5.2.0', 1), ('version_Live', '5.2.0', 1), ('version_Login', '5.2.0', 1), ('version_log_conversion.pageviews_before', 'SMALLINT UNSIGNED DEFAULT NULL', 1), ('version_log_conversion.revenue', '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_product_cat', 'INT(10) UNSIGNED NULL', 1), ('version_log_link_visit_action.idaction_product_cat2', 'INT(10) UNSIGNED NULL', 1), ('version_log_link_visit_action.idaction_product_cat3', 'INT(10) UNSIGNED NULL', 1), ('version_log_link_visit_action.idaction_product_cat4', 'INT(10) UNSIGNED NULL', 1), ('version_log_link_visit_action.idaction_product_cat5', 'INT(10) UNSIGNED NULL', 1), ('version_log_link_visit_action.idaction_product_name', 'INT(10) UNSIGNED NULL', 1), ('version_log_link_visit_action.idaction_product_sku', 'INT(10) UNSIGNED NULL', 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.product_price', 'DOUBLE NULL', 1), ('version_log_link_visit_action.search_cat', 'VARCHAR(200) NULL', 1), ('version_log_link_visit_action.search_count', 'INTEGER(10) UNSIGNED NULL', 1), ('version_log_link_visit_action.server_time', 'DATETIME NOT NULL', 1), ('version_log_link_visit_action.time_dom_completion', 'MEDIUMINT(10) UNSIGNED NULL', 1), ('version_log_link_visit_action.time_dom_processing', 'MEDIUMINT(10) UNSIGNED NULL', 1), ('version_log_link_visit_action.time_network', 'MEDIUMINT(10) UNSIGNED NULL', 1), ('version_log_link_visit_action.time_on_load', 'MEDIUMINT(10) UNSIGNED NULL', 1), ('version_log_link_visit_action.time_server', 'MEDIUMINT(10) UNSIGNED NULL', 1), ('version_log_link_visit_action.time_spent_ref_action', 'INTEGER(10) UNSIGNED NULL', 1), ('version_log_link_visit_action.time_transfer', 'MEDIUMINT(10) UNSIGNED NULL', 1), ('version_log_visit.config_browser_engine', 'VARCHAR(10) NULL', 1), ('version_log_visit.config_browser_name', 'VARCHAR(40) NULL1', 1), ('version_log_visit.config_browser_version', 'VARCHAR(20) NULL', 1), ('version_log_visit.config_client_type', 'TINYINT( 1 ) NULL DEFAULT NULL1', 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_flash', '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(3) DEFAULT NULL1', 1), ('version_log_visit.profilable', 'TINYINT(1) NULL', 1), ('version_log_visit.referer_keyword', 'VARCHAR(255) NULL1', 1), ('version_log_visit.referer_name', 'VARCHAR(255) NULL1', 1), ('version_log_visit.referer_type', 'TINYINT(1) UNSIGNED NULL1', 1), ('version_log_visit.referer_url', 'VARCHAR(1500) NULL', 1), ('version_log_visit.user_id', 'VARCHAR(200) NULL', 1), ('version_log_visit.visitor_count_visits', 'INT(11) UNSIGNED NOT NULL DEFAULT 01', 1), ('version_log_visit.visitor_localtime', 'TIME NULL', 1), ('version_log_visit.visitor_returning', 'TINYINT(1) NULL1', 1), ('version_log_visit.visitor_seconds_since_first', 'INT(11) UNSIGNED NULL1', 1), ('version_log_visit.visitor_seconds_since_last', 'INT(11) UNSIGNED NULL', 1), ('version_log_visit.visitor_seconds_since_order', 'INT(11) UNSIGNED 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', 'MEDIUMINT 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', '5.2.0', 1), ('version_MobileMessaging', '5.2.0', 1), ('version_Monolog', '5.2.0', 1), ('version_Morpheus', '5.2.0', 1), ('version_MultiSites', '5.2.0', 1), ('version_Overlay', '5.2.0', 1), ('version_PagePerformance', '5.2.0', 1), ('version_PrivacyManager', '5.2.0', 1), ('version_ProfessionalServices', '5.2.0', 1), ('version_Proxy', '5.2.0', 1), ('version_Referrers', '5.2.0', 1), ('version_Resolution', '5.2.0', 1), ('version_RssWidget', '1.0', 1), ('version_ScheduledReports', '5.2.0', 1), ('version_SegmentEditor', '5.2.0', 1), ('version_SEO', '5.2.0', 1), ('version_SitesManager', '5.2.0', 1), ('version_Tour', '5.2.0', 1), ('version_Transitions', '5.2.0', 1), ('version_TwoFactorAuth', '5.2.0', 1), ('version_UserCountry', '5.2.0', 1), ('version_UserCountryMap', '5.2.0', 1), ('version_UserId', '5.2.0', 1), ('version_UserLanguage', '5.2.0', 1), ('version_UsersManager', '5.2.0', 1), ('version_VisitFrequency', '5.2.0', 1), ('version_VisitorInterest', '5.2.0', 1), ('version_VisitsSummary', '5.2.0', 1), ('version_VisitTime', '5.2.0', 1), ('version_WebsiteMeasurable', '5.2.0', 1), ('version_Widgetize', '5.2.0', 1); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]plugin_setting` -- CREATE TABLE `[[dbprefix]]plugin_setting` ( `plugin_name` varchar(60) NOT NULL, `setting_name` varchar(255) NOT NULL, `setting_value` longtext NOT NULL, `json_encoded` tinyint(3) unsigned NOT NULL DEFAULT '0', `user_login` varchar(100) NOT NULL DEFAULT '', `idplugin_setting` bigint(20) unsigned NOT NULL AUTO_INCREMENT, PRIMARY KEY (`idplugin_setting`), KEY `plugin_name` (`plugin_name`,`user_login`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]privacy_logdata_anonymizations` -- CREATE TABLE `[[dbprefix]]privacy_logdata_anonymizations` ( `idlogdata_anonymization` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `idsites` text, `date_start` datetime NOT NULL, `date_end` datetime NOT NULL, `anonymize_ip` tinyint(1) unsigned NOT NULL DEFAULT '0', `anonymize_location` tinyint(1) unsigned NOT NULL DEFAULT '0', `anonymize_userid` tinyint(1) unsigned NOT NULL DEFAULT '0', `unset_visit_columns` text NOT NULL, `unset_link_visit_action_columns` text NOT NULL, `output` mediumtext, `scheduled_date` datetime DEFAULT NULL, `job_start_date` datetime DEFAULT NULL, `job_finish_date` datetime DEFAULT NULL, `requester` varchar(100) NOT NULL DEFAULT '', PRIMARY KEY (`idlogdata_anonymization`), KEY `job_start_date` (`job_start_date`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]report` -- CREATE TABLE `[[dbprefix]]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', `evolution_graph_within_period` tinyint(4) NOT NULL DEFAULT '0', `evolution_graph_period_n` int(11) NOT NULL, `period_param` varchar(10) DEFAULT NULL, PRIMARY KEY (`idreport`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]report_subscriptions` -- CREATE TABLE `[[dbprefix]]report_subscriptions` ( `idreport` int(11) NOT NULL, `token` varchar(100) DEFAULT NULL, `email` varchar(100) NOT NULL, `ts_subscribed` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `ts_unsubscribed` timestamp NULL DEFAULT NULL, PRIMARY KEY (`idreport`,`email`), UNIQUE KEY `unique_token` (`token`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]segment` -- CREATE TABLE `[[dbprefix]]segment` ( `idsegment` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `definition` text NOT NULL, `hash` char(32) DEFAULT 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=utf8mb4 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]sequence` -- CREATE TABLE `[[dbprefix]]sequence` ( `name` varchar(120) NOT NULL, `value` bigint(20) unsigned NOT NULL, PRIMARY KEY (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]session` -- CREATE TABLE `[[dbprefix]]session` ( `id` varchar(191) NOT NULL, `modified` int(11) DEFAULT NULL, `lifetime` int(11) DEFAULT NULL, `data` mediumtext, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC; -- -- Dumping data for table `[[dbprefix]]session` -- -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]site` -- CREATE TABLE `[[dbprefix]]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, `excluded_referrers` text NOT NULL, `group` varchar(250) NOT NULL, `type` varchar(255) NOT NULL, `keep_url_fragment` tinyint(4) NOT NULL DEFAULT '0', `creator_login` varchar(100) DEFAULT NULL, PRIMARY KEY (`idsite`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=2 ; -- -- Dumping data for table `[[dbprefix]]site` -- INSERT INTO `[[dbprefix]]site` VALUES (1, '[[site_name]]', '[[softurl]]', '[[regtime]]', 0, 1, '', '', 'America/New_York', 'USD', 0, '', '', '', '', '', 'website', 0, 'anonymous'); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]site_setting` -- CREATE TABLE `[[dbprefix]]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, `json_encoded` tinyint(3) unsigned NOT NULL DEFAULT '0', `idsite_setting` bigint(20) unsigned NOT NULL AUTO_INCREMENT, PRIMARY KEY (`idsite_setting`), KEY `idsite` (`idsite`,`plugin_name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]site_url` -- CREATE TABLE `[[dbprefix]]site_url` ( `idsite` int(10) unsigned NOT NULL, `url` varchar(190) NOT NULL, PRIMARY KEY (`idsite`,`url`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]tracking_failure` -- CREATE TABLE `[[dbprefix]]tracking_failure` ( `idsite` bigint(20) unsigned NOT NULL, `idfailure` smallint(5) unsigned NOT NULL, `date_first_occurred` datetime NOT NULL, `request_url` mediumtext NOT NULL, PRIMARY KEY (`idsite`,`idfailure`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]twofactor_recovery_code` -- CREATE TABLE `[[dbprefix]]twofactor_recovery_code` ( `idrecoverycode` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `login` varchar(100) NOT NULL, `recovery_code` varchar(40) NOT NULL, PRIMARY KEY (`idrecoverycode`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]user` -- CREATE TABLE `[[dbprefix]]user` ( `login` varchar(100) NOT NULL, `password` varchar(255) NOT NULL, `email` varchar(100) NOT NULL, `twofactor_secret` varchar(40) NOT NULL DEFAULT '', `superuser_access` tinyint(2) unsigned NOT NULL DEFAULT '0', `date_registered` timestamp NULL DEFAULT NULL, `ts_password_modified` timestamp NULL DEFAULT NULL, `idchange_last_viewed` int(10) unsigned DEFAULT NULL, `invited_by` varchar(100) DEFAULT NULL, `invite_token` varchar(191) DEFAULT NULL, `invite_link_token` varchar(191) DEFAULT NULL, `invite_expired_at` timestamp NULL DEFAULT NULL, `invite_accept_at` timestamp NULL DEFAULT NULL, `ts_changes_shown` timestamp NULL DEFAULT NULL, PRIMARY KEY (`login`), UNIQUE KEY `uniq_email` (`email`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC; -- -- Dumping data for table `[[dbprefix]]user` -- INSERT INTO `[[dbprefix]]user` VALUES ('anonymous', '', 'anonymous@example.org', '', 0, '[[date_registered]]', '[[date_registered]]', NULL, NULL, NULL, NULL, NULL, NULL, NULL), ('[[admin_username]]', '[[admin_pass]]', '[[admin_email]]', '', 1, '[[date_registered]]', '[[date_registered]]', NULL, NULL, NULL, NULL, NULL, NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]user_dashboard` -- CREATE TABLE `[[dbprefix]]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=utf8mb4 ROW_FORMAT=DYNAMIC; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]user_language` -- CREATE TABLE `[[dbprefix]]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=utf8mb4 ROW_FORMAT=DYNAMIC; INSERT INTO `[[dbprefix]]user_language` VALUES('[[admin_username]]', '[[language]]', 0); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]user_token_auth` -- CREATE TABLE `[[dbprefix]]user_token_auth` ( `idusertokenauth` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `login` varchar(100) NOT NULL, `description` varchar(100) NOT NULL, `password` varchar(191) NOT NULL, `hash_algo` varchar(30) NOT NULL, `system_token` tinyint(1) NOT NULL DEFAULT '0', `last_used` datetime DEFAULT NULL, `date_created` datetime NOT NULL, `date_expired` datetime DEFAULT NULL, `secure_only` tinyint(2) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`idusertokenauth`), UNIQUE KEY `uniq_password` (`password`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=2 ; -- -- Dumping data for table `[[dbprefix]]user_token_auth` -- INSERT INTO `[[dbprefix]]user_token_auth` VALUES (1, 'anonymous', 'anonymous default token', '7010440890a0d530818bc3f216ce87f4a06435fecde48da198bc38f416354fea28352cfd9b8cadf32aa399cd58cb11c02336f6b8d37995a8b962479103257e4e', 'sha512', 0, '[[regtime]]', '[[regtime]]', NULL, 0); /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;