Home Explore Help
Sign In
GwynethLlewelyn
/
OpenSim-Test
1
0
Fork 0
Files Issues 0 Pull Requests 0
Tree: c1e901989a
Branches Tags
OpenSim-Test
/
OpenSim
/
Data
/
MSSQL
/
Resources
/
Mssql-regions.sql

Mssql-regions.sql 2.0 KB
History Raw

1234567891011121314151617181920212223242526272829303132333435363738394041 
  1. SET ANSI_NULLS ON
    2. 

  2. 

  3. SET QUOTED_IDENTIFIER ON
    4. 

  4. 

  5. SET ANSI_PADDING ON
    6. 

  6. 

  7. CREATE TABLE [dbo].[regions](
    8. 

  8.  [regionHandle] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
    9. 

  9.  [regionName] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
    10. 

  10.  [uuid] [varchar](255) COLLATE Latin1_General_CI_AS NOT NULL,
    11. 

  11.  [regionRecvKey] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
    12. 

  12.  [regionSecret] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
    13. 

  13.  [regionSendKey] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
    14. 

  14.  [regionDataURI] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
    15. 

  15.  [serverIP] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
    16. 

  16.  [serverPort] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
    17. 

  17.  [serverURI] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
    18. 

  18.  [locX] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
    19. 

  19.  [locY] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
    20. 

  20.  [locZ] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
    21. 

  21.  [eastOverrideHandle] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
    22. 

  22.  [westOverrideHandle] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
    23. 

  23.  [southOverrideHandle] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
    24. 

  24.  [northOverrideHandle] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
    25. 

  25.  [regionAssetURI] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
    26. 

  26.  [regionAssetRecvKey] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
    27. 

  27.  [regionAssetSendKey] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
    28. 

  28.  [regionUserURI] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
    29. 

  29.  [regionUserRecvKey] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
    30. 

  30.  [regionUserSendKey] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
    31. 

  31.  [regionMapTexture] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
    32. 

  32.  [serverHttpPort] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
    33. 

  33.  [serverRemotingPort] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
    34. 

  34.  [owner_uuid] [varchar](36) COLLATE Latin1_General_CI_AS NULL,
    35. 

  35. PRIMARY KEY CLUSTERED 
    36. 

  36. (
    37. 

  37.  [uuid] ASC
    38. 

  38. )WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
    39. 

  39. ) ON [PRIMARY]
    40. 

  40. 

  41. SET ANSI_PADDING OFF
    42.