1
0

Presence.migrations 617 B

1234567891011121314151617181920212223
  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;
  12. :VERSION 2 # --------------------------
  13. BEGIN;
  14. ALTER TABLE `Presence` ADD COLUMN LastSeen timestamp;
  15. COMMIT;