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/PostgreSQLDialect | |
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/PostgreSQLDialect')
-rw-r--r-- | OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_EstateStore.sql | 80 |
1 files changed, 40 insertions, 40 deletions
diff --git a/OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_EstateStore.sql b/OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_EstateStore.sql index 421a0c4..e43fd86 100644 --- a/OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_EstateStore.sql +++ b/OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/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 DEFAULT NULL, | 3 | ParentEstateID INT DEFAULT NULL, |
4 | EstateOwnerID VARCHAR(36) DEFAULT NULL, | 4 | EstateOwnerID VARCHAR(36) DEFAULT NULL, |
5 | Name VARCHAR(64) DEFAULT NULL, | 5 | Name VARCHAR(64) DEFAULT NULL, |
6 | RedirectGridX INT DEFAULT NULL, | 6 | RedirectGridX INT DEFAULT NULL, |
7 | RedirectGridY INT DEFAULT NULL, | 7 | RedirectGridY INT DEFAULT NULL, |
8 | BillableFactor DOUBLE PRECISION DEFAULT NULL, | 8 | BillableFactor DOUBLE PRECISION DEFAULT NULL, |
9 | PricePerMeter INT DEFAULT NULL, | 9 | PricePerMeter INT DEFAULT NULL, |
10 | SunPosition DOUBLE PRECISION DEFAULT NULL, | 10 | SunPosition DOUBLE PRECISION DEFAULT NULL, |
11 | 11 | ||
12 | UseGlobalTime BOOLEAN DEFAULT NULL, | 12 | UseGlobalTime BOOLEAN DEFAULT NULL, |
13 | FixedSun BOOLEAN DEFAULT NULL, | 13 | FixedSun BOOLEAN DEFAULT NULL, |
14 | AllowVoice BOOLEAN DEFAULT NULL, | 14 | AllowVoice BOOLEAN DEFAULT NULL, |
15 | AllowDirectTeleport BOOLEAN DEFAULT NULL, | 15 | AllowDirectTeleport BOOLEAN DEFAULT NULL, |
16 | ResetHomeOnTeleport BOOLEAN DEFAULT NULL, | 16 | ResetHomeOnTeleport BOOLEAN DEFAULT NULL, |
17 | PublicAccess BOOLEAN DEFAULT NULL, | 17 | PublicAccess BOOLEAN DEFAULT NULL, |
18 | DenyAnonymous BOOLEAN DEFAULT NULL, | 18 | DenyAnonymous BOOLEAN DEFAULT NULL, |
19 | DenyIdentified BOOLEAN DEFAULT NULL, | 19 | DenyIdentified BOOLEAN DEFAULT NULL, |
20 | DenyTransacted BOOLEAN DEFAULT NULL, | 20 | DenyTransacted BOOLEAN DEFAULT NULL, |
21 | DenyMinors BOOLEAN DEFAULT NULL, | 21 | DenyMinors BOOLEAN DEFAULT NULL, |
22 | BlockDwell BOOLEAN DEFAULT NULL, | 22 | BlockDwell BOOLEAN DEFAULT NULL, |
23 | EstateSkipScripts BOOLEAN DEFAULT NULL, | 23 | EstateSkipScripts BOOLEAN DEFAULT NULL, |
24 | TaxFree BOOLEAN DEFAULT NULL, | 24 | TaxFree BOOLEAN DEFAULT NULL, |
25 | AbuseEmailToEstateOwner BOOLEAN DEFAULT NULL, | 25 | AbuseEmailToEstateOwner BOOLEAN DEFAULT NULL, |
26 | 26 | ||
27 | AbuseEmail VARCHAR(255) DEFAULT NULL, | 27 | AbuseEmail VARCHAR(255) DEFAULT 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 VARCHAR(36) NOT NULL, | 33 | EstateRegionLinkID VARCHAR(36) NOT NULL, |
34 | EstateID INT DEFAULT NULL, | 34 | EstateID INT DEFAULT NULL, |
35 | RegionID VARCHAR(36) DEFAULT NULL, | 35 | RegionID VARCHAR(36) DEFAULT 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); |