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

002_RegionStore.sql 1.6 KB
History Raw

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950 
  1. BEGIN TRANSACTION
    2. 

  2. 

  3. CREATE TABLE regionban (
    4. 

  4. 	[regionUUID] VARCHAR(36) NOT NULL, 
    5. 

  5. 	[bannedUUID] VARCHAR(36) NOT NULL, 
    6. 

  6. 	[bannedIp] VARCHAR(16) NOT NULL, 
    7. 

  7. 	[bannedIpHostMask] VARCHAR(16) NOT NULL)
    8. 

  8. 

  9. create table [dbo].[regionsettings] (
    10. 

  10. 	[regionUUID] [varchar](36) not null,
    11. 

  11. 	[block_terraform] [bit] not null,
    12. 

  12. 	[block_fly] [bit] not null,
    13. 

  13. 	[allow_damage] [bit] not null,
    14. 

  14. 	[restrict_pushing] [bit] not null,
    15. 

  15. 	[allow_land_resell] [bit] not null,
    16. 

  16. 	[allow_land_join_divide] [bit] not null,
    17. 

  17. 	[block_show_in_search] [bit] not null,
    18. 

  18. 	[agent_limit] [int] not null,
    19. 

  19. 	[object_bonus] [float] not null,
    20. 

  20. 	[maturity] [int] not null,
    21. 

  21. 	[disable_scripts] [bit] not null,
    22. 

  22. 	[disable_collisions] [bit] not null,
    23. 

  23. 	[disable_physics] [bit] not null,
    24. 

  24. 	[terrain_texture_1] [varchar](36) not null,
    25. 

  25. 	[terrain_texture_2] [varchar](36) not null,
    26. 

  26. 	[terrain_texture_3] [varchar](36) not null,
    27. 

  27. 	[terrain_texture_4] [varchar](36) not null,
    28. 

  28. 	[elevation_1_nw] [float] not null,
    29. 

  29. 	[elevation_2_nw] [float] not null,
    30. 

  30. 	[elevation_1_ne] [float] not null,
    31. 

  31. 	[elevation_2_ne] [float] not null,
    32. 

  32. 	[elevation_1_se] [float] not null,
    33. 

  33. 	[elevation_2_se] [float] not null,
    34. 

  34. 	[elevation_1_sw] [float] not null,
    35. 

  35. 	[elevation_2_sw] [float] not null,
    36. 

  36. 	[water_height] [float] not null,
    37. 

  37. 	[terrain_raise_limit] [float] not null,
    38. 

  38. 	[terrain_lower_limit] [float] not null,
    39. 

  39. 	[use_estate_sun] [bit] not null,
    40. 

  40. 	[fixed_sun] [bit] not null,
    41. 

  41. 	[sun_position] [float] not null,
    42. 

  42. 	[covenant] [varchar](36) default NULL,
    43. 

  43. 	[Sandbox] [bit] NOT NULL,
    44. 

  44. PRIMARY KEY CLUSTERED 
    45. 

  45. (
    46. 

  46. 	[regionUUID] ASC
    47. 

  47. )WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
    48. 

  48. ) ON [PRIMARY]
    49. 

  49. 

  50. COMMIT
    51.