aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_EstateStore.sql
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/MySQLDialect/001_EstateStore.sql
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/MySQLDialect/001_EstateStore.sql')
-rw-r--r--OpenSim/Data/NHibernate/Resources/MySQLDialect/001_EstateStore.sql80
1 files changed, 40 insertions, 40 deletions
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);