Code:
CREATE TABLE `smwa`.`sm_logging` (
`ID` INT( 11 ) NOT NULL AUTO_INCREMENT ,
`Server_ID` INT( 11 ) NOT NULL ,
`steamid` VARCHAR( 100 ) NOT NULL ,
`logtag` VARCHAR( 100 ) NOT NULL ,
`message` VARCHAR( 255 ) NOT NULL ,
`time_modified` TIMESTAMP( 14 ) ON UPDATE CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ,
PRIMARY KEY ( `ID` )
) ENGINE = MYISAM
Engine definitions for steamids are 64 characters, and you can store a steamid as a 4 byte unsigned int if you convert the steamid to a friendID.