Mssql-agents.sql 1.2 KB

12345678910111213141516171819202122232425262728293031323334353637
  1. SET ANSI_NULLS ON
  2. SET QUOTED_IDENTIFIER ON
  3. SET ANSI_PADDING ON
  4. CREATE TABLE [agents] (
  5. [UUID] [varchar](36) NOT NULL,
  6. [sessionID] [varchar](36) NOT NULL,
  7. [secureSessionID] [varchar](36) NOT NULL,
  8. [agentIP] [varchar](16) NOT NULL,
  9. [agentPort] [int] NOT NULL,
  10. [agentOnline] [tinyint] NOT NULL,
  11. [loginTime] [int] NOT NULL,
  12. [logoutTime] [int] NOT NULL,
  13. [currentRegion] [varchar](36) NOT NULL,
  14. [currentHandle] [bigint] NOT NULL,
  15. [currentPos] [varchar](64) NOT NULL,
  16. PRIMARY KEY CLUSTERED
  17. (
  18. [UUID] ASC
  19. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  20. ) ON [PRIMARY]
  21. CREATE NONCLUSTERED INDEX [session] ON [agents]
  22. (
  23. [sessionID] ASC
  24. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  25. CREATE NONCLUSTERED INDEX [ssession] ON [agents]
  26. (
  27. [secureSessionID] ASC
  28. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  29. SET ANSI_PADDING OFF