CREATE TABLE IF NOT EXISTS `adminlog` (
  `adminlogid` int(10) unsigned NOT NULL auto_increment,
  `userid` int(10) unsigned NOT NULL default '0',
  `dateline` int(10) unsigned NOT NULL default '0',
  `script` varchar(50) NOT NULL default '',
  `action` varchar(20) NOT NULL default '',
  `extrainfo` varchar(200) NOT NULL default '',
  `ipaddress` char(15) NOT NULL default '',
  PRIMARY KEY  (`adminlogid`),
  KEY `script_action` (`script`,`action`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;