Skip to content

Instantly share code, notes, and snippets.

@tyler71

tyler71/gist:ad318f40bb00417ea1f1d2a19c101ee4 Secret

Last active April 4, 2019 20:05
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save tyler71/ad318f40bb00417ea1f1d2a19c101ee4 to your computer and use it in GitHub Desktop.
Save tyler71/ad318f40bb00417ea1f1d2a19c101ee4 to your computer and use it in GitHub Desktop.
Download ZIP
show create table piwik_log_visit
Raw
gistfile1.txt
show create table piwik_log_visit;
+-----------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
+-----------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| piwik_log_visit | CREATE TABLE `piwik_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,
`location_longitude` decimal(9,6) DEFAULT NULL,
`location_latitude` decimal(9,6) DEFAULT NULL,
`location_region` char(2) DEFAULT NULL,
`visitor_localtime` time DEFAULT NULL,
`location_country` char(3) DEFAULT NULL,
`location_city` varchar(255) DEFAULT NULL,
`config_device_type` tinyint(100) DEFAULT NULL,
`config_device_model` varchar(100) DEFAULT NULL,
`config_os` char(3) DEFAULT NULL,
`config_os_version` varchar(100) DEFAULT NULL,
`visit_total_events` smallint(5) unsigned NOT NULL,
`visitor_days_since_last` smallint(5) unsigned DEFAULT NULL,
`config_quicktime` tinyint(1) DEFAULT NULL,
`config_pdf` tinyint(1) DEFAULT NULL,
`config_realplayer` tinyint(1) DEFAULT NULL,
`config_silverlight` tinyint(1) DEFAULT NULL,
`config_windowsmedia` tinyint(1) DEFAULT NULL,
`config_java` tinyint(1) DEFAULT NULL,
`config_gears` tinyint(1) DEFAULT NULL,
`config_resolution` varchar(18) DEFAULT NULL,
`config_cookie` tinyint(1) DEFAULT NULL,
`config_director` tinyint(1) DEFAULT NULL,
`config_flash` tinyint(1) DEFAULT NULL,
`config_device_brand` varchar(100) DEFAULT NULL,
`config_browser_version` varchar(20) DEFAULT NULL,
`visitor_returning` tinyint(1) DEFAULT NULL,
`visitor_days_since_order` smallint(5) unsigned DEFAULT NULL,
`visitor_count_visits` int(11) unsigned NOT NULL,
`visit_entry_idaction_name` int(10) unsigned DEFAULT NULL,
`visit_entry_idaction_url` int(11) unsigned DEFAULT NULL,
`visit_first_action_time` datetime NOT NULL,
`visitor_days_since_first` smallint(5) unsigned DEFAULT NULL,
`visit_total_time` int(11) unsigned NOT NULL,
`user_id` varchar(200) DEFAULT NULL,
`visit_goal_buyer` tinyint(1) DEFAULT NULL,
`visit_goal_converted` tinyint(1) DEFAULT NULL,
`visit_exit_idaction_name` int(10) unsigned DEFAULT NULL,
`visit_exit_idaction_url` int(10) unsigned DEFAULT 0,
`referer_url` text DEFAULT NULL,
`location_browser_lang` varchar(20) DEFAULT NULL,
`config_browser_engine` varchar(10) DEFAULT NULL,
`config_browser_name` varchar(10) DEFAULT NULL,
`referer_type` tinyint(1) unsigned DEFAULT NULL,
`referer_name` varchar(70) DEFAULT NULL,
`visit_total_actions` int(11) unsigned DEFAULT NULL,
`visit_total_searches` smallint(5) unsigned DEFAULT NULL,
`referer_keyword` varchar(255) DEFAULT NULL,
`location_provider` varchar(200) 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,
`visit_total_interactions` smallint(5) unsigned DEFAULT 0,
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` (`idsite`,`idvisitor`)
) ENGINE=InnoDB AUTO_INCREMENT=143509 DEFAULT CHARSET=utf8 |
+-----------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.000 sec)
MariaDB [piwik]> show create table matomo_log_visit;
ERROR 1146 (42S02): Table 'piwik.matomo_log_visit' doesn't exist
MariaDB [piwik]>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment