aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/NHibernate/Resources
diff options
context:
space:
mode:
authorSean Dague2009-02-16 19:23:53 +0000
committerSean Dague2009-02-16 19:23:53 +0000
commitc7a08752c0d49a470534fcebcd13710f517b3d00 (patch)
tree15fc841c9aff09eacd956bb6e9370cb591f86d0e /OpenSim/Data/NHibernate/Resources
parent* refactor: remove AssetCache field hanging off Scene (diff)
downloadopensim-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')
-rw-r--r--OpenSim/Data/NHibernate/Resources/EstateRegionLink.hbm.xml24
-rw-r--r--OpenSim/Data/NHibernate/Resources/EstateSettings.hbm.xml78
-rw-r--r--OpenSim/Data/NHibernate/Resources/MigrationSyntaxDifferences.txt28
-rw-r--r--OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_EstateStore.sql80
-rw-r--r--OpenSim/Data/NHibernate/Resources/MySQLDialect/001_EstateStore.sql80
-rw-r--r--OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_EstateStore.sql80
-rw-r--r--OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_EstateStore.sql80
7 files changed, 225 insertions, 225 deletions
diff --git a/OpenSim/Data/NHibernate/Resources/EstateRegionLink.hbm.xml b/OpenSim/Data/NHibernate/Resources/EstateRegionLink.hbm.xml
index 91bddee..fd66910 100644
--- a/OpenSim/Data/NHibernate/Resources/EstateRegionLink.hbm.xml
+++ b/OpenSim/Data/NHibernate/Resources/EstateRegionLink.hbm.xml
@@ -1,12 +1,12 @@
1<?xml version="1.0" encoding="utf-8" ?> 1<?xml version="1.0" encoding="utf-8" ?>
2<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2"> 2<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2">
3 <class name="OpenSim.Data.NHibernate.EstateRegionLink, OpenSim.Data.NHibernate" table="EstateRegionLink" lazy="false"> 3 <class name="OpenSim.Data.NHibernate.EstateRegionLink, OpenSim.Data.NHibernate" table="EstateRegionLink" lazy="false">
4 <id name="EstateRegionLinkID" column="EstateRegionLinkID" type="OpenSim.Data.NHibernate.UUIDUserType, OpenSim.Data.NHibernate"> 4 <id name="EstateRegionLinkID" column="EstateRegionLinkID" type="OpenSim.Data.NHibernate.UUIDUserType, OpenSim.Data.NHibernate">
5 <generator class="assigned" /> 5 <generator class="assigned" />
6 </id> 6 </id>
7 7
8 <property name="EstateID" type="OpenSim.Data.NHibernate.UInt32Type, OpenSim.Data.NHibernate" /> 8 <property name="EstateID" type="OpenSim.Data.NHibernate.UInt32Type, OpenSim.Data.NHibernate" />
9 <property name="RegionID" type="OpenSim.Data.NHibernate.UUIDUserType, OpenSim.Data.NHibernate" /> 9 <property name="RegionID" type="OpenSim.Data.NHibernate.UUIDUserType, OpenSim.Data.NHibernate" />
10 10
11 </class> 11 </class>
12</hibernate-mapping> 12</hibernate-mapping>
diff --git a/OpenSim/Data/NHibernate/Resources/EstateSettings.hbm.xml b/OpenSim/Data/NHibernate/Resources/EstateSettings.hbm.xml
index 1ff0f10..2dc3949 100644
--- a/OpenSim/Data/NHibernate/Resources/EstateSettings.hbm.xml
+++ b/OpenSim/Data/NHibernate/Resources/EstateSettings.hbm.xml
@@ -1,39 +1,39 @@
1<?xml version="1.0" encoding="utf-8" ?> 1<?xml version="1.0" encoding="utf-8" ?>
2<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2"> 2<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2">
3 <class name="OpenSim.Framework.EstateSettings, OpenSim.Framework" table="EstateSettings" lazy="false"> 3 <class name="OpenSim.Framework.EstateSettings, OpenSim.Framework" table="EstateSettings" lazy="false">
4 4
5 <id name="EstateID" column="EstateID" type="OpenSim.Data.NHibernate.UInt32Type, OpenSim.Data.NHibernate"> 5 <id name="EstateID" column="EstateID" type="OpenSim.Data.NHibernate.UInt32Type, OpenSim.Data.NHibernate">
6 <generator class="increment" /> 6 <generator class="increment" />
7 </id> 7 </id>
8 8
9 <property name="ParentEstateID" type="OpenSim.Data.NHibernate.UInt32Type, OpenSim.Data.NHibernate" /> 9 <property name="ParentEstateID" type="OpenSim.Data.NHibernate.UInt32Type, OpenSim.Data.NHibernate" />
10 <property name="EstateOwner" column="EstateOwnerID" type="OpenSim.Data.NHibernate.UUIDUserType, OpenSim.Data.NHibernate" /> 10 <property name="EstateOwner" column="EstateOwnerID" type="OpenSim.Data.NHibernate.UUIDUserType, OpenSim.Data.NHibernate" />
11 11
12 <property name="EstateName" column="Name" type="String" length="64" /> 12 <property name="EstateName" column="Name" type="String" length="64" />
13 13
14 <property name="RedirectGridX" type="System.Int32" /> 14 <property name="RedirectGridX" type="System.Int32" />
15 <property name="RedirectGridY" type="System.Int32" /> 15 <property name="RedirectGridY" type="System.Int32" />
16 16
17 <property name="BillableFactor" type="System.Single" /> 17 <property name="BillableFactor" type="System.Single" />
18 <property name="PricePerMeter" type="System.Int32" /> 18 <property name="PricePerMeter" type="System.Int32" />
19 <property name="SunPosition" type="System.Double" /> 19 <property name="SunPosition" type="System.Double" />
20 20
21 <property name="UseGlobalTime" type="System.Boolean" /> 21 <property name="UseGlobalTime" type="System.Boolean" />
22 <property name="FixedSun" type="System.Boolean" /> 22 <property name="FixedSun" type="System.Boolean" />
23 <property name="AllowVoice" type="System.Boolean" /> 23 <property name="AllowVoice" type="System.Boolean" />
24 <property name="AllowDirectTeleport" type="System.Boolean" /> 24 <property name="AllowDirectTeleport" type="System.Boolean" />
25 <property name="ResetHomeOnTeleport" type="System.Boolean" /> 25 <property name="ResetHomeOnTeleport" type="System.Boolean" />
26 <property name="PublicAccess" type="System.Boolean" /> 26 <property name="PublicAccess" type="System.Boolean" />
27 <property name="DenyAnonymous" type="System.Boolean" /> 27 <property name="DenyAnonymous" type="System.Boolean" />
28 <property name="DenyIdentified" type="System.Boolean" /> 28 <property name="DenyIdentified" type="System.Boolean" />
29 <property name="DenyTransacted" type="System.Boolean" /> 29 <property name="DenyTransacted" type="System.Boolean" />
30 <property name="DenyMinors" type="System.Boolean" /> 30 <property name="DenyMinors" type="System.Boolean" />
31 <property name="BlockDwell" type="System.Boolean" /> 31 <property name="BlockDwell" type="System.Boolean" />
32 <property name="EstateSkipScripts" type="System.Boolean" /> 32 <property name="EstateSkipScripts" type="System.Boolean" />
33 <property name="TaxFree" type="System.Boolean" /> 33 <property name="TaxFree" type="System.Boolean" />
34 <property name="AbuseEmailToEstateOwner" type="System.Boolean" /> 34 <property name="AbuseEmailToEstateOwner" type="System.Boolean" />
35 35
36 <property name="AbuseEmail" type="String" length="255" /> 36 <property name="AbuseEmail" type="String" length="255" />
37 37
38 </class> 38 </class>
39</hibernate-mapping> 39</hibernate-mapping>
diff --git a/OpenSim/Data/NHibernate/Resources/MigrationSyntaxDifferences.txt b/OpenSim/Data/NHibernate/Resources/MigrationSyntaxDifferences.txt
index f3d86df..1c89516 100644
--- a/OpenSim/Data/NHibernate/Resources/MigrationSyntaxDifferences.txt
+++ b/OpenSim/Data/NHibernate/Resources/MigrationSyntaxDifferences.txt
@@ -1,14 +1,14 @@
1?This file describes the differences in schema creation and migration scripts. 1?This file describes the differences in schema creation and migration scripts.
2 2
3MySQL is used as reference script against which differences are listed. 3MySQL is used as reference script against which differences are listed.
4 4
5Generally MySQL create table options should be removed for other databases. 5Generally MySQL create table options should be removed for other databases.
6 6
7_PostgreSQL_ 7_PostgreSQL_
8* DOUBLE->DOUBLE PRECISION 8* DOUBLE->DOUBLE PRECISION
9* BIT->BOOLEAN 9* BIT->BOOLEAN
10 10
11_MsSql_ 11_MsSql_
12* VARCHAR->NVARCHAR 12* VARCHAR->NVARCHAR
13* Remove DEFAULT-keywords 13* Remove DEFAULT-keywords
14* DOUBLE->REAL 14* DOUBLE->REAL
diff --git a/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_EstateStore.sql b/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_EstateStore.sql
index 0e95963..4ca51be 100644
--- a/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_EstateStore.sql
+++ b/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/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 NULL, 3 ParentEstateID INT NULL,
4 EstateOwnerID NVARCHAR(36) NULL, 4 EstateOwnerID NVARCHAR(36) NULL,
5 Name NVARCHAR(64) NULL, 5 Name NVARCHAR(64) NULL,
6 RedirectGridX INT NULL, 6 RedirectGridX INT NULL,
7 RedirectGridY INT NULL, 7 RedirectGridY INT NULL,
8 BillableFactor REAL NULL, 8 BillableFactor REAL NULL,
9 PricePerMeter INT NULL, 9 PricePerMeter INT NULL,
10 SunPosition FLOAT NULL, 10 SunPosition FLOAT NULL,
11 11
12 UseGlobalTime BIT NULL, 12 UseGlobalTime BIT NULL,
13 FixedSun BIT NULL, 13 FixedSun BIT NULL,
14 AllowVoice BIT NULL, 14 AllowVoice BIT NULL,
15 AllowDirectTeleport BIT NULL, 15 AllowDirectTeleport BIT NULL,
16 ResetHomeOnTeleport BIT NULL, 16 ResetHomeOnTeleport BIT NULL,
17 PublicAccess BIT NULL, 17 PublicAccess BIT NULL,
18 DenyAnonymous BIT NULL, 18 DenyAnonymous BIT NULL,
19 DenyIdentified BIT NULL, 19 DenyIdentified BIT NULL,
20 DenyTransacted BIT NULL, 20 DenyTransacted BIT NULL,
21 DenyMinors BIT NULL, 21 DenyMinors BIT NULL,
22 BlockDwell BIT NULL, 22 BlockDwell BIT NULL,
23 EstateSkipScripts BIT NULL, 23 EstateSkipScripts BIT NULL,
24 TaxFree BIT NULL, 24 TaxFree BIT NULL,
25 AbuseEmailToEstateOwner BIT NULL, 25 AbuseEmailToEstateOwner BIT NULL,
26 26
27 AbuseEmail NVARCHAR(255) NULL, 27 AbuseEmail NVARCHAR(255) NULL,
28 28
29 PRIMARY KEY (EstateID) 29 PRIMARY KEY (EstateID)
30); 30);
31 31
32CREATE TABLE EstateRegionLink ( 32CREATE TABLE EstateRegionLink (
33 EstateRegionLinkID NVARCHAR(36) NOT NULL, 33 EstateRegionLinkID NVARCHAR(36) NOT NULL,
34 EstateID INT NULL, 34 EstateID INT NULL,
35 RegionID NVARCHAR(36) NULL, 35 RegionID NVARCHAR(36) 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);
diff --git a/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_EstateStore.sql b/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_EstateStore.sql
index a791bc6..2114186 100644
--- a/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_EstateStore.sql
+++ b/OpenSim/Data/NHibernate/Resources/MySQLDialect/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 DEFAULT NULL, 8 BillableFactor DOUBLE DEFAULT NULL,
9 PricePerMeter INT DEFAULT NULL, 9 PricePerMeter INT DEFAULT NULL,
10 SunPosition DOUBLE DEFAULT NULL, 10 SunPosition DOUBLE DEFAULT NULL,
11 11
12 UseGlobalTime BIT DEFAULT NULL, 12 UseGlobalTime BIT DEFAULT NULL,
13 FixedSun BIT DEFAULT NULL, 13 FixedSun BIT DEFAULT NULL,
14 AllowVoice BIT DEFAULT NULL, 14 AllowVoice BIT DEFAULT NULL,
15 AllowDirectTeleport BIT DEFAULT NULL, 15 AllowDirectTeleport BIT DEFAULT NULL,
16 ResetHomeOnTeleport BIT DEFAULT NULL, 16 ResetHomeOnTeleport BIT DEFAULT NULL,
17 PublicAccess BIT DEFAULT NULL, 17 PublicAccess BIT DEFAULT NULL,
18 DenyAnonymous BIT DEFAULT NULL, 18 DenyAnonymous BIT DEFAULT NULL,
19 DenyIdentified BIT DEFAULT NULL, 19 DenyIdentified BIT DEFAULT NULL,
20 DenyTransacted BIT DEFAULT NULL, 20 DenyTransacted BIT DEFAULT NULL,
21 DenyMinors BIT DEFAULT NULL, 21 DenyMinors BIT DEFAULT NULL,
22 BlockDwell BIT DEFAULT NULL, 22 BlockDwell BIT DEFAULT NULL,
23 EstateSkipScripts BIT DEFAULT NULL, 23 EstateSkipScripts BIT DEFAULT NULL,
24 TaxFree BIT DEFAULT NULL, 24 TaxFree BIT DEFAULT NULL,
25 AbuseEmailToEstateOwner BIT DEFAULT NULL, 25 AbuseEmailToEstateOwner BIT 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) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev. 1'; 30) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev. 1';
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) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev. 1'; 37) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev. 1';
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);
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);
diff --git a/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_EstateStore.sql b/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_EstateStore.sql
index b16ae82..b540bc6 100644
--- a/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_EstateStore.sql
+++ b/OpenSim/Data/NHibernate/Resources/SQLiteDialect/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 DEFAULT NULL, 8 BillableFactor DOUBLE DEFAULT NULL,
9 PricePerMeter INT DEFAULT NULL, 9 PricePerMeter INT DEFAULT NULL,
10 SunPosition DOUBLE DEFAULT NULL, 10 SunPosition DOUBLE DEFAULT NULL,
11 11
12 UseGlobalTime BIT DEFAULT NULL, 12 UseGlobalTime BIT DEFAULT NULL,
13 FixedSun BIT DEFAULT NULL, 13 FixedSun BIT DEFAULT NULL,
14 AllowVoice BIT DEFAULT NULL, 14 AllowVoice BIT DEFAULT NULL,
15 AllowDirectTeleport BIT DEFAULT NULL, 15 AllowDirectTeleport BIT DEFAULT NULL,
16 ResetHomeOnTeleport BIT DEFAULT NULL, 16 ResetHomeOnTeleport BIT DEFAULT NULL,
17 PublicAccess BIT DEFAULT NULL, 17 PublicAccess BIT DEFAULT NULL,
18 DenyAnonymous BIT DEFAULT NULL, 18 DenyAnonymous BIT DEFAULT NULL,
19 DenyIdentified BIT DEFAULT NULL, 19 DenyIdentified BIT DEFAULT NULL,
20 DenyTransacted BIT DEFAULT NULL, 20 DenyTransacted BIT DEFAULT NULL,
21 DenyMinors BIT DEFAULT NULL, 21 DenyMinors BIT DEFAULT NULL,
22 BlockDwell BIT DEFAULT NULL, 22 BlockDwell BIT DEFAULT NULL,
23 EstateSkipScripts BIT DEFAULT NULL, 23 EstateSkipScripts BIT DEFAULT NULL,
24 TaxFree BIT DEFAULT NULL, 24 TaxFree BIT DEFAULT NULL,
25 AbuseEmailToEstateOwner BIT DEFAULT NULL, 25 AbuseEmailToEstateOwner BIT 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);