// Table that stores the actual data about visits
$stats_table_sql =
	"CREATE TABLE IF NOT EXISTS {$GLOBALS['wpdb']->prefix}slim_stats (
		id INT UNSIGNED NOT NULL auto_increment,
		ip INT UNSIGNED DEFAULT 0,
		other_ip INT UNSIGNED DEFAULT 0,
		user VARCHAR(255) DEFAULT '',
		language VARCHAR(5) DEFAULT '',
		country VARCHAR(16) DEFAULT '',
		domain VARCHAR(255) DEFAULT '',
		referer VARCHAR(2048) DEFAULT '',
		searchterms VARCHAR(2048) DEFAULT '',
		resource VARCHAR(2048) DEFAULT '',
		browser_id SMALLINT UNSIGNED NOT NULL DEFAULT 0,
		screenres_id MEDIUMINT UNSIGNED NOT NULL DEFAULT 0,
		content_info_id MEDIUMINT UNSIGNED NOT NULL DEFAULT 0,
		plugins VARCHAR(255) DEFAULT '',
		notes VARCHAR(2048) DEFAULT '',
		visit_id INT UNSIGNED NOT NULL DEFAULT 0,
		dt INT(10) UNSIGNED DEFAULT 0,
		PRIMARY KEY id (id)
	) COLLATE utf8_general_ci";

// Lookup tables
$browsers_table_sql =
	"CREATE TABLE IF NOT EXISTS {$GLOBALS['wpdb']->base_prefix}slim_browsers (
		browser_id MEDIUMINT UNSIGNED NOT NULL auto_increment,
		browser VARCHAR(40) DEFAULT '',
		version VARCHAR(15) DEFAULT '',
		platform VARCHAR(15) DEFAULT '',
		css_version VARCHAR(5) DEFAULT '',
		type TINYINT UNSIGNED DEFAULT 0,
		user_agent VARCHAR(2048) DEFAULT '',
		PRIMARY KEY (browser_id),
		UNIQUE KEY unique_browser (browser, version, platform, css_version, type)
	) COLLATE utf8_general_ci";

$screen_res_table_sql =
	"CREATE TABLE IF NOT EXISTS {$GLOBALS['wpdb']->base_prefix}slim_screenres (
		screenres_id MEDIUMINT UNSIGNED NOT NULL auto_increment,
		resolution VARCHAR(12) DEFAULT '',
		colordepth VARCHAR(5) DEFAULT '',
		antialias BOOL DEFAULT FALSE,
		PRIMARY KEY (screenres_id),
		UNIQUE KEY unique_screenres (resolution, colordepth, antialias)
	) COLLATE utf8_general_ci";

$content_info_table_sql =
	"CREATE TABLE IF NOT EXISTS {$GLOBALS['wpdb']->base_prefix}slim_content_info (
		content_info_id INT UNSIGNED NOT NULL auto_increment,
		content_type VARCHAR(64) DEFAULT '',
		category VARCHAR(256) DEFAULT '',
		author VARCHAR(64) DEFAULT '',
		content_id BIGINT(20) UNSIGNED DEFAULT 0,
		PRIMARY KEY (content_info_id),
		UNIQUE KEY unique_content_info (content_type(20), category(20), author(20), content_id)
	) COLLATE utf8_general_ci $use_innodb";