aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/SQLiteNG/Resources/004_RegionStore.sql
diff options
context:
space:
mode:
authorJustin Clark-Casey (justincc)2010-04-23 17:17:15 +0100
committerJustin Clark-Casey (justincc)2010-04-23 17:17:15 +0100
commita23bebdc0f106c19de09e54d88eebc6b086fdaab (patch)
tree5a0141201ae27b796608f0af77f4d9a1e1cd1d19 /OpenSim/Data/SQLiteNG/Resources/004_RegionStore.sql
parentminor: change a comment and replace some magic numbers with the AssetType enum (diff)
downloadopensim-SC-a23bebdc0f106c19de09e54d88eebc6b086fdaab.zip
opensim-SC-a23bebdc0f106c19de09e54d88eebc6b086fdaab.tar.gz
opensim-SC-a23bebdc0f106c19de09e54d88eebc6b086fdaab.tar.bz2
opensim-SC-a23bebdc0f106c19de09e54d88eebc6b086fdaab.tar.xz
Duplicate OpenSim.Data.SQLite into OpenSim.Data.SQLiteNG. SQLiteNG will shortly be changed to work under mono 2.6 and above
Diffstat (limited to '')
-rw-r--r--OpenSim/Data/SQLiteNG/Resources/004_RegionStore.sql38
1 files changed, 38 insertions, 0 deletions
diff --git a/OpenSim/Data/SQLiteNG/Resources/004_RegionStore.sql b/OpenSim/Data/SQLiteNG/Resources/004_RegionStore.sql
new file mode 100644
index 0000000..de328cb
--- /dev/null
+++ b/OpenSim/Data/SQLiteNG/Resources/004_RegionStore.sql
@@ -0,0 +1,38 @@
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
38COMMIT;