1
0

002_RegionStore.sql 1.6 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950
  1. BEGIN TRANSACTION
  2. CREATE TABLE regionban (
  3. [regionUUID] VARCHAR(36) NOT NULL,
  4. [bannedUUID] VARCHAR(36) NOT NULL,
  5. [bannedIp] VARCHAR(16) NOT NULL,
  6. [bannedIpHostMask] VARCHAR(16) NOT NULL)
  7. create table [dbo].[regionsettings] (
  8. [regionUUID] [varchar](36) not null,
  9. [block_terraform] [bit] not null,
  10. [block_fly] [bit] not null,
  11. [allow_damage] [bit] not null,
  12. [restrict_pushing] [bit] not null,
  13. [allow_land_resell] [bit] not null,
  14. [allow_land_join_divide] [bit] not null,
  15. [block_show_in_search] [bit] not null,
  16. [agent_limit] [int] not null,
  17. [object_bonus] [float] not null,
  18. [maturity] [int] not null,
  19. [disable_scripts] [bit] not null,
  20. [disable_collisions] [bit] not null,
  21. [disable_physics] [bit] not null,
  22. [terrain_texture_1] [varchar](36) not null,
  23. [terrain_texture_2] [varchar](36) not null,
  24. [terrain_texture_3] [varchar](36) not null,
  25. [terrain_texture_4] [varchar](36) not null,
  26. [elevation_1_nw] [float] not null,
  27. [elevation_2_nw] [float] not null,
  28. [elevation_1_ne] [float] not null,
  29. [elevation_2_ne] [float] not null,
  30. [elevation_1_se] [float] not null,
  31. [elevation_2_se] [float] not null,
  32. [elevation_1_sw] [float] not null,
  33. [elevation_2_sw] [float] not null,
  34. [water_height] [float] not null,
  35. [terrain_raise_limit] [float] not null,
  36. [terrain_lower_limit] [float] not null,
  37. [use_estate_sun] [bit] not null,
  38. [fixed_sun] [bit] not null,
  39. [sun_position] [float] not null,
  40. [covenant] [varchar](36) default NULL,
  41. [Sandbox] [bit] NOT NULL,
  42. PRIMARY KEY CLUSTERED
  43. (
  44. [regionUUID] ASC
  45. )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
  46. ) ON [PRIMARY]
  47. COMMIT