CREATE TABLE #TABLEPREFIX#coreaccesslog (
       logid BIGINT(20) NOT NULL AUTO_INCREMENT
     , remote_addr VARCHAR(20)
     , remote_host TEXT
     , request_method VARCHAR(20)
     , request_uri TEXT
     , request_time TIMESTAMP(19)
     , http_referer TEXT
     , http_user_agent TEXT
     , location TEXT
     , module TEXT
     , action TEXT
     , logdate DATETIME DEFAULT '0000-00-00 00:00:00'
     , userid VARCHAR(100)
     , PRIMARY KEY (logid)
);

