Presence.migrations 610 B

12345678910111213141516
  1. :VERSION 4 # --------------------------
  2. BEGIN;
  3. CREATE TABLE IF NOT EXISTS `Presence` (
  4. `UserID` varchar(255) NOT NULL,
  5. `RegionID` char(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000',
  6. `SessionID` char(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000',
  7. `SecureSessionID` char(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000',
  8. `LastSeen` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  9. UNIQUE KEY `SessionID` (`SessionID`),
  10. KEY `UserID` (`UserID`),
  11. KEY `RegionID` (`RegionID`)
  12. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  13. COMMIT;