diff options
Diffstat (limited to '')
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 | ||
3 | MySQL is used as reference script against which differences are listed. | 3 | MySQL is used as reference script against which differences are listed. |
4 | 4 | ||
5 | Generally MySQL create table options should be removed for other databases. | 5 | Generally 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 @@ | |||
1 | CREATE TABLE EstateSettings ( | 1 | CREATE 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 | ||
32 | CREATE TABLE EstateRegionLink ( | 32 | CREATE 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 | ||
39 | CREATE INDEX EstateRegionLinkEstateIDIndex ON EstateRegionLink (EstateID); | 39 | CREATE INDEX EstateRegionLinkEstateIDIndex ON EstateRegionLink (EstateID); |
40 | CREATE INDEX EstateRegionLinkERegionIDIndex ON EstateRegionLink (RegionID); | 40 | CREATE 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 @@ | |||
1 | CREATE TABLE EstateSettings ( | 1 | CREATE 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 | ||
32 | CREATE TABLE EstateRegionLink ( | 32 | CREATE 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 | ||
39 | CREATE INDEX EstateRegionLinkEstateIDIndex ON EstateRegionLink (EstateID); | 39 | CREATE INDEX EstateRegionLinkEstateIDIndex ON EstateRegionLink (EstateID); |
40 | CREATE INDEX EstateRegionLinkERegionIDIndex ON EstateRegionLink (RegionID); | 40 | CREATE 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 @@ | |||
1 | CREATE TABLE EstateSettings ( | 1 | CREATE 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 | ||
32 | CREATE TABLE EstateRegionLink ( | 32 | CREATE 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 | ||
39 | CREATE INDEX EstateRegionLinkEstateIDIndex ON EstateRegionLink (EstateID); | 39 | CREATE INDEX EstateRegionLinkEstateIDIndex ON EstateRegionLink (EstateID); |
40 | CREATE INDEX EstateRegionLinkERegionIDIndex ON EstateRegionLink (RegionID); | 40 | CREATE 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 @@ | |||
1 | CREATE TABLE EstateSettings ( | 1 | CREATE 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 | ||
32 | CREATE TABLE EstateRegionLink ( | 32 | CREATE 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 | ||
39 | CREATE INDEX EstateRegionLinkEstateIDIndex ON EstateRegionLink (EstateID); | 39 | CREATE INDEX EstateRegionLinkEstateIDIndex ON EstateRegionLink (EstateID); |
40 | CREATE INDEX EstateRegionLinkERegionIDIndex ON EstateRegionLink (RegionID); | 40 | CREATE INDEX EstateRegionLinkERegionIDIndex ON EstateRegionLink (RegionID); |