diff options
author | Sean Dague | 2009-02-16 19:23:53 +0000 |
---|---|---|
committer | Sean Dague | 2009-02-16 19:23:53 +0000 |
commit | c7a08752c0d49a470534fcebcd13710f517b3d00 (patch) | |
tree | 15fc841c9aff09eacd956bb6e9370cb591f86d0e /OpenSim/Data/NHibernate/Resources/MsSql2005Dialect | |
parent | * refactor: remove AssetCache field hanging off Scene (diff) | |
download | opensim-SC_OLD-c7a08752c0d49a470534fcebcd13710f517b3d00.zip opensim-SC_OLD-c7a08752c0d49a470534fcebcd13710f517b3d00.tar.gz opensim-SC_OLD-c7a08752c0d49a470534fcebcd13710f517b3d00.tar.bz2 opensim-SC_OLD-c7a08752c0d49a470534fcebcd13710f517b3d00.tar.xz |
line ending fixes and set native eol property
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); |