gistfile1.txt

DROP TABLE IF EXISTS `log_visitor`;

CREATE TABLE `log_visitor` ( 
`visitor_id` bigint(20) unsigned NOT NULL auto_increment, 
`session_id` char(64) NOT NULL default '', 
`store_id` char(64) NOT NULL default '', 
`first_visit_at` datetime default NULL, 
`last_visit_at` datetime NOT NULL default '0000-00-00 00:00:00', 
`last_url_id` bigint(20) unsigned NOT NULL default '0', 
PRIMARY KEY (`visitor_id`) 
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='System visitors log';

gistfile2.txt

CREATE TABLE IF NOT EXISTS `log_visitor_info` (
  `visitor_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'Visitor ID',
  `http_referer` varchar(255) DEFAULT NULL COMMENT 'HTTP Referrer',
  `http_user_agent` varchar(255) DEFAULT NULL COMMENT 'HTTP User-Agent',
  `http_accept_charset` varchar(255) DEFAULT NULL COMMENT 'HTTP Accept-Charset',
  `http_accept_language` varchar(255) DEFAULT NULL COMMENT 'HTTP Accept-Language',
  `server_addr` bigint(20) DEFAULT NULL COMMENT 'Server Address',
  `remote_addr` bigint(20) DEFAULT NULL COMMENT 'Remote Address',
  PRIMARY KEY (`visitor_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Log Visitor Info Table';

Hey again Ryaan -

This generated this output:

Error
There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem

ERROR: Unknown Punctuation String @ 469
STR: =
SQL: DROP TABLE IF EXISTS log_visitor;# MySQL returned an empty result set (i.e. zero rows).

CREATE TABLE log_visitor (
visitor_id bigint(20) unsigned NOT NULL auto_increment,
session_id char(64) NOT NULL default \’\’,
first_visit_at datetime default NULL,
last_visit_at datetime NOT NULL default \’0000-00-00 00:00:00\’,
last_url_id bigint(20) unsigned NOT NULL default \’0\’,
PRIMARY KEY (visitor_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT=\’System visitors log\’;

CREATE TABLE log_visitor (
visitor_id bigint(20) unsigned NOT NULL auto_increment,
session_id char(64) NOT NULL default \’\’,
first_visit_at datetime default NULL,
last_visit_at datetime NOT NULL default \’0000-00-00 00:00:00\’,
last_url_id bigint(20) unsigned NOT NULL default \’0\’,
PRIMARY KEY (visitor_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT=\’System visitors log\’;

SQL query:

CREATE TABLE log_visitor ( visitor_id bigint(20) unsigned NOT NULL auto_increment, session_id char(64) NOT NULL default \’\’, first_visit_at datetime default NULL, last_visit_at datetime NOT NULL default \’0000-00-00 00:00:00\’, last_url_id bigint(20) unsigned NOT NULL default \’0\’, PRIMARY KEY (visitor_id) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT=\’System visitors log\’;

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\’\’,

first_visit_at datetime default NULL,
last_visit_at datetime N' at line 3