1 files changed, 40 insertions, 0 deletions

diff --git a/OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_EstateStore.sql b/OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_EstateStore.sql
new file mode 100644
index 0000000..421a0c4
--- /dev/null
+++ b/OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_EstateStore.sql
@@ -0,0 +1,40 @@
+CREATE TABLE EstateSettings (

+  EstateID INT NOT NULL,

+  ParentEstateID INT DEFAULT NULL,

+  EstateOwnerID VARCHAR(36) DEFAULT NULL,

+  Name VARCHAR(64) DEFAULT NULL,

+  RedirectGridX INT DEFAULT NULL,

+  RedirectGridY INT DEFAULT NULL,

+  BillableFactor DOUBLE PRECISION DEFAULT NULL,

+  PricePerMeter INT DEFAULT NULL,

+  SunPosition DOUBLE PRECISION DEFAULT NULL,

+  

+  UseGlobalTime BOOLEAN DEFAULT NULL,

+  FixedSun BOOLEAN DEFAULT NULL,

+  AllowVoice BOOLEAN DEFAULT NULL,

+  AllowDirectTeleport BOOLEAN DEFAULT NULL,

+  ResetHomeOnTeleport BOOLEAN DEFAULT NULL,

+  PublicAccess BOOLEAN DEFAULT NULL,

+  DenyAnonymous BOOLEAN DEFAULT NULL,

+  DenyIdentified BOOLEAN DEFAULT NULL,

+  DenyTransacted BOOLEAN DEFAULT NULL,

+  DenyMinors BOOLEAN DEFAULT NULL,

+  BlockDwell BOOLEAN DEFAULT NULL,

+  EstateSkipScripts BOOLEAN DEFAULT NULL,

+  TaxFree BOOLEAN DEFAULT NULL,

+  AbuseEmailToEstateOwner BOOLEAN DEFAULT NULL,

+  

+  AbuseEmail VARCHAR(255) DEFAULT NULL,

+

+  PRIMARY KEY (EstateID)

+);

+

+CREATE TABLE EstateRegionLink (

+  EstateRegionLinkID VARCHAR(36) NOT NULL,

+  EstateID INT DEFAULT NULL,

+  RegionID VARCHAR(36) DEFAULT NULL,

+  PRIMARY KEY (EstateRegionLinkID)

+);

+

+CREATE INDEX EstateRegionLinkEstateIDIndex ON EstateRegionLink (EstateID);

+CREATE INDEX EstateRegionLinkERegionIDIndex ON EstateRegionLink (RegionID);