aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL/Resources
diff options
context:
space:
mode:
authorMW2008-06-29 11:48:58 +0000
committerMW2008-06-29 11:48:58 +0000
commitf3f31744abaf8a9df952a0d547faa59035b46ff3 (patch)
treed400f1ef6854d9f7b57007f92e774b5c7b1a1c81 /OpenSim/Data/MySQL/Resources
parentcouple of small fixes to try to fix support for multiple inventory servers in... (diff)
downloadopensim-SC_OLD-f3f31744abaf8a9df952a0d547faa59035b46ff3.zip
opensim-SC_OLD-f3f31744abaf8a9df952a0d547faa59035b46ff3.tar.gz
opensim-SC_OLD-f3f31744abaf8a9df952a0d547faa59035b46ff3.tar.bz2
opensim-SC_OLD-f3f31744abaf8a9df952a0d547faa59035b46ff3.tar.xz
patch and files from mantis #1630, Thanks Melanie
Diffstat (limited to 'OpenSim/Data/MySQL/Resources')
-rw-r--r--OpenSim/Data/MySQL/Resources/005_RegionStore.sql40
1 files changed, 40 insertions, 0 deletions
diff --git a/OpenSim/Data/MySQL/Resources/005_RegionStore.sql b/OpenSim/Data/MySQL/Resources/005_RegionStore.sql
new file mode 100644
index 0000000..c4a9527
--- /dev/null
+++ b/OpenSim/Data/MySQL/Resources/005_RegionStore.sql
@@ -0,0 +1,40 @@
1BEGIN;
2
3create table regionsettings (
4 regionUUID char(36) not null,
5 block_terraform integer not null,
6 block_fly integer not null,
7 allow_damage integer not null,
8 restrict_pushing integer not null,
9 allow_land_resell integer not null,
10 allow_land_join_divide integer not null,
11 block_show_in_search integer not null,
12 agent_limit integer not null,
13 object_bonus float not null,
14 maturity integer not null,
15 disable_scripts integer not null,
16 disable_collisions integer not null,
17 disable_physics integer not null,
18 terrain_texture_1 char(36) not null,
19 terrain_texture_2 char(36) not null,
20 terrain_texture_3 char(36) not null,
21 terrain_texture_4 char(36) not null,
22 elevation_1_nw float not null,
23 elevation_2_nw float not null,
24 elevation_1_ne float not null,
25 elevation_2_ne float not null,
26 elevation_1_se float not null,
27 elevation_2_se float not null,
28 elevation_1_sw float not null,
29 elevation_2_sw float not null,
30 water_height float not null,
31 terrain_raise_limit float not null,
32 terrain_lower_limit float not null,
33 use_estate_sun integer not null,
34 fixed_sun integer not null,
35 sun_position float not null,
36 covenant char(36),
37 primary key(regionUUID)
38);
39
40COMMIT;