Database:regionsettings

From OpenSimulator

Revision as of 18:33, 21 January 2013 by Justincc (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Overview

Raw MySQL table description as of OpenSimulator 0.7.5

mysql> describe regionsettings;
+--------------------------+------------------+------+-----+--------------------------------------+-------+
| Field                    | Type             | Null | Key | Default                              | Extra |
+--------------------------+------------------+------+-----+--------------------------------------+-------+
| regionUUID               | char(36)         | NO   | PRI | NULL                                 |       |
| block_terraform          | int(11)          | NO   |     | NULL                                 |       |
| block_fly                | int(11)          | NO   |     | NULL                                 |       |
| allow_damage             | int(11)          | NO   |     | NULL                                 |       |
| restrict_pushing         | int(11)          | NO   |     | NULL                                 |       |
| allow_land_resell        | int(11)          | NO   |     | NULL                                 |       |
| allow_land_join_divide   | int(11)          | NO   |     | NULL                                 |       |
| block_show_in_search     | int(11)          | NO   |     | NULL                                 |       |
| agent_limit              | int(11)          | NO   |     | NULL                                 |       |
| object_bonus             | double           | NO   |     | NULL                                 |       |
| maturity                 | int(11)          | NO   |     | NULL                                 |       |
| disable_scripts          | int(11)          | NO   |     | NULL                                 |       |
| disable_collisions       | int(11)          | NO   |     | NULL                                 |       |
| disable_physics          | int(11)          | NO   |     | NULL                                 |       |
| terrain_texture_1        | char(36)         | NO   |     | NULL                                 |       |
| terrain_texture_2        | char(36)         | NO   |     | NULL                                 |       |
| terrain_texture_3        | char(36)         | NO   |     | NULL                                 |       |
| terrain_texture_4        | char(36)         | NO   |     | NULL                                 |       |
| elevation_1_nw           | double           | NO   |     | NULL                                 |       |
| elevation_2_nw           | double           | NO   |     | NULL                                 |       |
| elevation_1_ne           | double           | NO   |     | NULL                                 |       |
| elevation_2_ne           | double           | NO   |     | NULL                                 |       |
| elevation_1_se           | double           | NO   |     | NULL                                 |       |
| elevation_2_se           | double           | NO   |     | NULL                                 |       |
| elevation_1_sw           | double           | NO   |     | NULL                                 |       |
| elevation_2_sw           | double           | NO   |     | NULL                                 |       |
| water_height             | double           | NO   |     | NULL                                 |       |
| terrain_raise_limit      | double           | NO   |     | NULL                                 |       |
| terrain_lower_limit      | double           | NO   |     | NULL                                 |       |
| use_estate_sun           | int(11)          | NO   |     | NULL                                 |       |
| fixed_sun                | int(11)          | NO   |     | NULL                                 |       |
| sun_position             | double           | NO   |     | NULL                                 |       |
| covenant                 | char(36)         | YES  |     | NULL                                 |       |
| Sandbox                  | tinyint(4)       | NO   |     | NULL                                 |       |
| sunvectorx               | double           | NO   |     | 0                                    |       |
| sunvectory               | double           | NO   |     | 0                                    |       |
| sunvectorz               | double           | NO   |     | 0                                    |       |
| loaded_creation_id       | varchar(64)      | YES  |     | NULL                                 |       |
| loaded_creation_datetime | int(10) unsigned | NO   |     | 0                                    |       |
| map_tile_ID              | char(36)         | NO   |     | 00000000-0000-0000-0000-000000000000 |       |
| TelehubObject            | varchar(36)      | NO   |     | 00000000-0000-0000-0000-000000000000 |       |
| parcel_tile_ID           | char(36)         | NO   |     | 00000000-0000-0000-0000-000000000000 |       |
| covenant_datetime        | int(10) unsigned | NO   |     | 0                                    |       |
+--------------------------+------------------+------+-----+--------------------------------------+-------+

Description

Please fill in as and when possible.

maturity - Maturity of the region. 0 is PG, 1 is mature, 2 is adult.

Personal tools
General
About This Wiki