NOTE: with prefixes such as zen_ on your table names, you need to use:
PHP Code:DROP TABLE IF EXISTS zen_admin_activity_log;
CREATE TABLE zen_admin_activity_log (
log_id int(15) NOT NULL auto_increment,
access_date datetime NOT NULL default '0001-01-01 00:00:00',
admin_id int(11) NOT NULL default '0',
page_accessed varchar(80) NOT NULL default '',
page_parameters text,
ip_address varchar(15) NOT NULL default '',
PRIMARY KEY (log_id),
KEY idx_page_accessed_zen (page_accessed),
KEY idx_access_date_zen (access_date),
KEY idx_ip_zen (ip_address)
) TYPE=MyISAM;



