CREATE TABLE IF NOT EXISTS `ubbt_ADMIN_LOG` (
`LOG_DATE` int(9) unsigned NOT NULL,
`USER_ID` int(9) unsigned NOT NULL,
`LOG_IP` varchar(15) default NULL,
`LOG_ACTION` varchar(50) default NULL,
`LOG_INFO` text,
KEY `log_date` (`LOG_DATE`),
KEY `user_id` (`USER_ID`),
KEY `log_ip` (`LOG_IP`),
KEY `log_action` (`LOG_ACTION`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;