1
0

Presence.migrations 552 B

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