diff options
author | Melanie Thielker | 2008-09-01 17:10:01 +0000 |
---|---|---|
committer | Melanie Thielker | 2008-09-01 17:10:01 +0000 |
commit | b6bb5f944f19b330656105ff79cd5ca3f2d5c242 (patch) | |
tree | 433ee8a24136ac10ed63dc3cf715b16ba786b8a8 /OpenSim/Data/MSSQL/Resources/002_RegionStore.sql | |
parent | Mantis #2072 (diff) | |
download | opensim-SC_OLD-b6bb5f944f19b330656105ff79cd5ca3f2d5c242.zip opensim-SC_OLD-b6bb5f944f19b330656105ff79cd5ca3f2d5c242.tar.gz opensim-SC_OLD-b6bb5f944f19b330656105ff79cd5ca3f2d5c242.tar.bz2 opensim-SC_OLD-b6bb5f944f19b330656105ff79cd5ca3f2d5c242.tar.xz |
Mantis #2095
Thank you, RuudL, for a complete adaptation of migration and estate
data to MSSQL, and the updating of the RegionData handling in MSSQL.
Diffstat (limited to '')
-rw-r--r-- | OpenSim/Data/MSSQL/Resources/002_RegionStore.sql | 50 |
1 files changed, 50 insertions, 0 deletions
diff --git a/OpenSim/Data/MSSQL/Resources/002_RegionStore.sql b/OpenSim/Data/MSSQL/Resources/002_RegionStore.sql new file mode 100644 index 0000000..1801035 --- /dev/null +++ b/OpenSim/Data/MSSQL/Resources/002_RegionStore.sql | |||
@@ -0,0 +1,50 @@ | |||
1 | BEGIN TRANSACTION | ||
2 | |||
3 | CREATE TABLE regionban ( | ||
4 | [regionUUID] VARCHAR(36) NOT NULL, | ||
5 | [bannedUUID] VARCHAR(36) NOT NULL, | ||
6 | [bannedIp] VARCHAR(16) NOT NULL, | ||
7 | [bannedIpHostMask] VARCHAR(16) NOT NULL) | ||
8 | |||
9 | create table [dbo].[regionsettings] ( | ||
10 | [regionUUID] [varchar](36) not null, | ||
11 | [block_terraform] [bit] not null, | ||
12 | [block_fly] [bit] not null, | ||
13 | [allow_damage] [bit] not null, | ||
14 | [restrict_pushing] [bit] not null, | ||
15 | [allow_land_resell] [bit] not null, | ||
16 | [allow_land_join_divide] [bit] not null, | ||
17 | [block_show_in_search] [bit] not null, | ||
18 | [agent_limit] [int] not null, | ||
19 | [object_bonus] [float] not null, | ||
20 | [maturity] [int] not null, | ||
21 | [disable_scripts] [bit] not null, | ||
22 | [disable_collisions] [bit] not null, | ||
23 | [disable_physics] [bit] not null, | ||
24 | [terrain_texture_1] [varchar](36) not null, | ||
25 | [terrain_texture_2] [varchar](36) not null, | ||
26 | [terrain_texture_3] [varchar](36) not null, | ||
27 | [terrain_texture_4] [varchar](36) not null, | ||
28 | [elevation_1_nw] [float] not null, | ||
29 | [elevation_2_nw] [float] not null, | ||
30 | [elevation_1_ne] [float] not null, | ||
31 | [elevation_2_ne] [float] not null, | ||
32 | [elevation_1_se] [float] not null, | ||
33 | [elevation_2_se] [float] not null, | ||
34 | [elevation_1_sw] [float] not null, | ||
35 | [elevation_2_sw] [float] not null, | ||
36 | [water_height] [float] not null, | ||
37 | [terrain_raise_limit] [float] not null, | ||
38 | [terrain_lower_limit] [float] not null, | ||
39 | [use_estate_sun] [bit] not null, | ||
40 | [fixed_sun] [bit] not null, | ||
41 | [sun_position] [float] not null, | ||
42 | [covenant] [varchar](36) default NULL, | ||
43 | [Sandbox] [bit] NOT NULL, | ||
44 | PRIMARY KEY CLUSTERED | ||
45 | ( | ||
46 | [regionUUID] ASC | ||
47 | )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] | ||
48 | ) ON [PRIMARY] | ||
49 | |||
50 | COMMIT \ No newline at end of file | ||