diff options
Diffstat (limited to 'OpenSim/Data/NHibernate/Resources/MsSql2005Dialect')
-rw-r--r-- | OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_EstateStore.sql | 80 |
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 @@ | |||
1 | CREATE TABLE EstateSettings ( | 1 | CREATE 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 | ||
32 | CREATE TABLE EstateRegionLink ( | 32 | CREATE 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 | ||
39 | CREATE INDEX EstateRegionLinkEstateIDIndex ON EstateRegionLink (EstateID); | 39 | CREATE INDEX EstateRegionLinkEstateIDIndex ON EstateRegionLink (EstateID); |
40 | CREATE INDEX EstateRegionLinkERegionIDIndex ON EstateRegionLink (RegionID); | 40 | CREATE INDEX EstateRegionLinkERegionIDIndex ON EstateRegionLink (RegionID); |