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 @@
-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);

+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);