Presence.migrations 513 B

123456789101112131415161718192021222324252627282930
  1. :VERSION 1
  2. BEGIN TRANSACTION;
  3. CREATE TABLE Presence (
  4. "UserID" varchar(255) NOT NULL,
  5. "RegionID" uuid NOT NULL,
  6. "SessionID" uuid NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000',
  7. "SecureSessionID" uuid NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000'
  8. );
  9. COMMIT;
  10. :VERSION 2
  11. BEGIN TRANSACTION;
  12. CREATE UNIQUE INDEX SessionID ON Presence("SessionID");
  13. CREATE INDEX UserID ON Presence("UserID");
  14. COMMIT;
  15. :VERSION 2
  16. BEGIN TRANSACTION;
  17. ALTER TABLE Presence ADD "LastSeen" Timestamp;
  18. COMMIT;