Presence.migrations 495 B

123456789101112131415
  1. :VERSION 1 # --------------------------
  2. BEGIN;
  3. CREATE TABLE `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. ) ENGINE=InnoDB;
  9. CREATE UNIQUE INDEX SessionID ON Presence(SessionID);
  10. CREATE INDEX UserID ON Presence(UserID);
  11. COMMIT;