aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_GridStore.sql
diff options
context:
space:
mode:
authorJohn Hurliman2009-10-19 16:52:27 -0700
committerJohn Hurliman2009-10-19 16:52:27 -0700
commitfdce1be3db287bed901332b90ba57165e201d3fc (patch)
tree8f0792e4c4ac4c14a50559f8439573740a7b3326 /OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_GridStore.sql
parentMerge branch 'prioritization' of ssh://opensimulator.org/var/git/opensim into... (diff)
downloadopensim-SC_OLD-fdce1be3db287bed901332b90ba57165e201d3fc.zip
opensim-SC_OLD-fdce1be3db287bed901332b90ba57165e201d3fc.tar.gz
opensim-SC_OLD-fdce1be3db287bed901332b90ba57165e201d3fc.tar.bz2
opensim-SC_OLD-fdce1be3db287bed901332b90ba57165e201d3fc.tar.xz
* Removed OpenSim.Data.NHibernate
* Replaced calls to ThreadPool.QueueUserWorkItem() with ThreadPool.UnsafeQueueUserWorkItem() since OpenSim does not use Code Access Security sandboxing
Diffstat (limited to 'OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_GridStore.sql')
-rw-r--r--OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_GridStore.sql35
1 files changed, 0 insertions, 35 deletions
diff --git a/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_GridStore.sql b/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_GridStore.sql
deleted file mode 100644
index 4f09848..0000000
--- a/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_GridStore.sql
+++ /dev/null
@@ -1,35 +0,0 @@
1CREATE TABLE Regions (
2 RegionId VARCHAR(36) NOT NULL,
3 RegionHandle BIGINT UNSIGNED NOT NULL,
4 RegionName VARCHAR(32) DEFAULT NULL,
5 RegionRecvKey VARCHAR(128) DEFAULT NULL,
6 RegionSendKey VARCHAR(128) DEFAULT NULL,
7 RegionSecret VARCHAR(128) DEFAULT NULL,
8 RegionDataURI VARCHAR(255) DEFAULT NULL,
9 ServerIP VARCHAR(64) DEFAULT NULL,
10 ServerPort INT UNSIGNED DEFAULT NULL,
11 ServerURI VARCHAR(255) DEFAULT NULL,
12 RegionLocX INT UNSIGNED DEFAULT NULL,
13 RegionLocY INT UNSIGNED DEFAULT NULL,
14 RegionLocZ INT UNSIGNED DEFAULT NULL,
15 EastOverrideHandle BIGINT UNSIGNED DEFAULT NULL,
16 WestOverrideHandle BIGINT UNSIGNED DEFAULT NULL,
17 SouthOverrideHandle BIGINT UNSIGNED DEFAULT NULL,
18 NorthOverrideHandle BIGINT UNSIGNED DEFAULT NULL,
19 RegionAssetURI VARCHAR(255) DEFAULT NULL,
20 RegionAssetRecvKey VARCHAR(128) DEFAULT NULL,
21 RegionAssetSendKey VARCHAR(128) DEFAULT NULL,
22 RegionUserURI VARCHAR(255) DEFAULT NULL,
23 RegionUserRecvKey VARCHAR(128) DEFAULT NULL,
24 RegionUserSendKey VARCHAR(128) DEFAULT NULL,
25 RegionMapTextureId VARCHAR(36) DEFAULT NULL,
26 ServerHttpPort INT DEFAULT NULL,
27 ServerRemotingPort INT DEFAULT NULL,
28 OwnerID VARCHAR(36) DEFAULT NULL,
29 OriginID VARCHAR(36) DEFAULT NULL,
30 PRIMARY KEY (RegionId)
31);
32
33CREATE INDEX RegionNameIndex ON Regions (RegionName);
34CREATE INDEX RegionHandleIndex ON Regions (RegionHandle);
35CREATE INDEX RegionHandlesIndex ON Regions (EastOverrideHandle,WestOverrideHandle,SouthOverrideHandle,NorthOverrideHandle);