004_RegionStore.sql 1.1 KB

1234567891011121314151617181920212223242526272829303132333435363738
  1. BEGIN;
  2. create table regionsettings (
  3. regionUUID char(36) not null,
  4. block_terraform integer not null,
  5. block_fly integer not null,
  6. allow_damage integer not null,
  7. restrict_pushing integer not null,
  8. allow_land_resell integer not null,
  9. allow_land_join_divide integer not null,
  10. block_show_in_search integer not null,
  11. agent_limit integer not null,
  12. object_bonus float not null,
  13. maturity integer not null,
  14. disable_scripts integer not null,
  15. disable_collisions integer not null,
  16. disable_physics integer not null,
  17. terrain_texture_1 char(36) not null,
  18. terrain_texture_2 char(36) not null,
  19. terrain_texture_3 char(36) not null,
  20. terrain_texture_4 char(36) not null,
  21. elevation_1_nw float not null,
  22. elevation_2_nw float not null,
  23. elevation_1_ne float not null,
  24. elevation_2_ne float not null,
  25. elevation_1_se float not null,
  26. elevation_2_se float not null,
  27. elevation_1_sw float not null,
  28. elevation_2_sw float not null,
  29. water_height float not null,
  30. terrain_raise_limit float not null,
  31. terrain_lower_limit float not null,
  32. use_estate_sun integer not null,
  33. fixed_sun integer not null,
  34. sun_position float not null,
  35. covenant char(36));
  36. COMMIT;