1 files changed, 40 insertions, 0 deletions

diff --git a/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_EstateStore.sql b/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_EstateStore.sql
new file mode 100644
index 0000000..a791bc6
--- /dev/null
+++ b/OpenSim/Data/NHibernate/Resources/MySQLDialect/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 DEFAULT NULL,

+  PricePerMeter INT DEFAULT NULL,

+  SunPosition DOUBLE DEFAULT NULL,

+  

+  UseGlobalTime BIT DEFAULT NULL,

+  FixedSun BIT DEFAULT NULL,

+  AllowVoice BIT DEFAULT NULL,

+  AllowDirectTeleport BIT DEFAULT NULL,

+  ResetHomeOnTeleport BIT DEFAULT NULL,

+  PublicAccess BIT DEFAULT NULL,

+  DenyAnonymous BIT DEFAULT NULL,

+  DenyIdentified BIT DEFAULT NULL,

+  DenyTransacted BIT DEFAULT NULL,

+  DenyMinors BIT DEFAULT NULL,

+  BlockDwell BIT DEFAULT NULL,

+  EstateSkipScripts BIT DEFAULT NULL,

+  TaxFree BIT DEFAULT NULL,

+  AbuseEmailToEstateOwner BIT DEFAULT NULL,

+  

+  AbuseEmail VARCHAR(255) DEFAULT NULL,

+

+  PRIMARY KEY (EstateID)

+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev. 1';

+

+CREATE TABLE EstateRegionLink (

+  EstateRegionLinkID VARCHAR(36) NOT NULL,

+  EstateID INT DEFAULT NULL,

+  RegionID VARCHAR(36) DEFAULT NULL,

+  PRIMARY KEY (EstateRegionLinkID)

+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev. 1';

+

+CREATE INDEX EstateRegionLinkEstateIDIndex ON EstateRegionLink (EstateID);

+CREATE INDEX EstateRegionLinkERegionIDIndex ON EstateRegionLink (RegionID);