aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect
diff options
context:
space:
mode:
Diffstat (limited to 'OpenSim/Data/NHibernate/Resources/MsSql2005Dialect')
-rw-r--r--OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_EstateStore.sql80
1 files changed, 40 insertions, 40 deletions
diff --git a/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_EstateStore.sql b/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_EstateStore.sql
index 0e95963..4ca51be 100644
--- a/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_EstateStore.sql
+++ b/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_EstateStore.sql
@@ -1,40 +1,40 @@
1CREATE TABLE EstateSettings ( 1CREATE TABLE EstateSettings (
2 EstateID INT NOT NULL, 2 EstateID INT NOT NULL,
3 ParentEstateID INT NULL, 3 ParentEstateID INT NULL,
4 EstateOwnerID NVARCHAR(36) NULL, 4 EstateOwnerID NVARCHAR(36) NULL,
5 Name NVARCHAR(64) NULL, 5 Name NVARCHAR(64) NULL,
6 RedirectGridX INT NULL, 6 RedirectGridX INT NULL,
7 RedirectGridY INT NULL, 7 RedirectGridY INT NULL,
8 BillableFactor REAL NULL, 8 BillableFactor REAL NULL,
9 PricePerMeter INT NULL, 9 PricePerMeter INT NULL,
10 SunPosition FLOAT NULL, 10 SunPosition FLOAT NULL,
11 11
12 UseGlobalTime BIT NULL, 12 UseGlobalTime BIT NULL,
13 FixedSun BIT NULL, 13 FixedSun BIT NULL,
14 AllowVoice BIT NULL, 14 AllowVoice BIT NULL,
15 AllowDirectTeleport BIT NULL, 15 AllowDirectTeleport BIT NULL,
16 ResetHomeOnTeleport BIT NULL, 16 ResetHomeOnTeleport BIT NULL,
17 PublicAccess BIT NULL, 17 PublicAccess BIT NULL,
18 DenyAnonymous BIT NULL, 18 DenyAnonymous BIT NULL,
19 DenyIdentified BIT NULL, 19 DenyIdentified BIT NULL,
20 DenyTransacted BIT NULL, 20 DenyTransacted BIT NULL,
21 DenyMinors BIT NULL, 21 DenyMinors BIT NULL,
22 BlockDwell BIT NULL, 22 BlockDwell BIT NULL,
23 EstateSkipScripts BIT NULL, 23 EstateSkipScripts BIT NULL,
24 TaxFree BIT NULL, 24 TaxFree BIT NULL,
25 AbuseEmailToEstateOwner BIT NULL, 25 AbuseEmailToEstateOwner BIT NULL,
26 26
27 AbuseEmail NVARCHAR(255) NULL, 27 AbuseEmail NVARCHAR(255) NULL,
28 28
29 PRIMARY KEY (EstateID) 29 PRIMARY KEY (EstateID)
30); 30);
31 31
32CREATE TABLE EstateRegionLink ( 32CREATE TABLE EstateRegionLink (
33 EstateRegionLinkID NVARCHAR(36) NOT NULL, 33 EstateRegionLinkID NVARCHAR(36) NOT NULL,
34 EstateID INT NULL, 34 EstateID INT NULL,
35 RegionID NVARCHAR(36) NULL, 35 RegionID NVARCHAR(36) NULL,
36 PRIMARY KEY (EstateRegionLinkID) 36 PRIMARY KEY (EstateRegionLinkID)
37); 37);
38 38
39CREATE INDEX EstateRegionLinkEstateIDIndex ON EstateRegionLink (EstateID); 39CREATE INDEX EstateRegionLinkEstateIDIndex ON EstateRegionLink (EstateID);
40CREATE INDEX EstateRegionLinkERegionIDIndex ON EstateRegionLink (RegionID); 40CREATE INDEX EstateRegionLinkERegionIDIndex ON EstateRegionLink (RegionID);