aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/NHibernate/Resources/PostgreSQLDialect
diff options
context:
space:
mode:
Diffstat (limited to 'OpenSim/Data/NHibernate/Resources/PostgreSQLDialect')
-rw-r--r--OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_EstateStore.sql80
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 @@
1CREATE TABLE EstateSettings ( 1CREATE 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
32CREATE TABLE EstateRegionLink ( 32CREATE 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
39CREATE INDEX EstateRegionLinkEstateIDIndex ON EstateRegionLink (EstateID); 39CREATE INDEX EstateRegionLinkEstateIDIndex ON EstateRegionLink (EstateID);
40CREATE INDEX EstateRegionLinkERegionIDIndex ON EstateRegionLink (RegionID); 40CREATE INDEX EstateRegionLinkERegionIDIndex ON EstateRegionLink (RegionID);