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-users.sql

Mssql-users.sql 1.4 KB
History Raw

123456789101112131415161718192021222324252627282930313233343536373839404142 
  1. SET ANSI_NULLS ON
    2. 

  2. 

  3. SET QUOTED_IDENTIFIER ON
    4. 

  4. 

  5. SET ANSI_PADDING ON
    6. 

  6. 

  7. CREATE TABLE [users] (
    8. 

  8.   [UUID] [varchar](36) NOT NULL default '',
    9. 

  9.   [username] [varchar](32) NOT NULL,
    10. 

  10.   [lastname] [varchar](32) NOT NULL,
    11. 

  11.   [passwordHash] [varchar](32) NOT NULL,
    12. 

  12.   [passwordSalt] [varchar](32) NOT NULL,
    13. 

  13.   [homeRegion] [bigint] default NULL,
    14. 

  14.   [homeLocationX] [float] default NULL,
    15. 

  15.   [homeLocationY] [float] default NULL,
    16. 

  16.   [homeLocationZ] [float] default NULL,
    17. 

  17.   [homeLookAtX] [float] default NULL,
    18. 

  18.   [homeLookAtY] [float] default NULL,
    19. 

  19.   [homeLookAtZ] [float] default NULL,
    20. 

  20.   [created] [int] NOT NULL,
    21. 

  21.   [lastLogin] [int] NOT NULL,
    22. 

  22.   [userInventoryURI] [varchar](255) default NULL,
    23. 

  23.   [userAssetURI] [varchar](255) default NULL,
    24. 

  24.   [profileCanDoMask] [int] default NULL,
    25. 

  25.   [profileWantDoMask] [int] default NULL,
    26. 

  26.   [profileAboutText] [ntext],
    27. 

  27.   [profileFirstText] [ntext],
    28. 

  28.   [profileImage] [varchar](36) default NULL,
    29. 

  29.   [profileFirstImage] [varchar](36) default NULL,
    30. 

  30.   [webLoginKey] [varchar](36) default NULL,
    31. 

  31.   PRIMARY KEY CLUSTERED
    32. 

  32. (
    33. 

  33. 	[UUID] ASC
    34. 

  34. )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
    35. 

  35. ) ON [PRIMARY]
    36. 

  36. 

  37. 

  38. CREATE NONCLUSTERED INDEX [usernames] ON [users]
    39. 

  39. (
    40. 

  40. 	[username] ASC,
    41. 

  41. 	[lastname] ASC
    42. 

  42. )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]
    43.