:VERSION 4 # -------------------------- BEGIN; CREATE TABLE IF NOT EXISTS `Presence` ( `UserID` varchar(255) NOT NULL, `RegionID` char(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000', `SessionID` char(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000', `SecureSessionID` char(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000', `LastSeen` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, UNIQUE KEY `SessionID` (`SessionID`), KEY `UserID` (`UserID`), KEY `RegionID` (`RegionID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; COMMIT;