aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_GridStore.sql
diff options
context:
space:
mode:
authorJustin Clarke Casey2008-12-04 20:48:08 +0000
committerJustin Clarke Casey2008-12-04 20:48:08 +0000
commitbdee86563cfce5211f182b78e64503a05fc7ffa1 (patch)
tree9b1e7e941e787d36f2248ff4b57f101a779351a6 /OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_GridStore.sql
parent* Apply http://opensimulator.org/mantis/view.php?id=2750 with a small tweak. (diff)
downloadopensim-SC_OLD-bdee86563cfce5211f182b78e64503a05fc7ffa1.zip
opensim-SC_OLD-bdee86563cfce5211f182b78e64503a05fc7ffa1.tar.gz
opensim-SC_OLD-bdee86563cfce5211f182b78e64503a05fc7ffa1.tar.bz2
opensim-SC_OLD-bdee86563cfce5211f182b78e64503a05fc7ffa1.tar.xz
* Check in another patch from http://opensimulator.org/mantis/view.php?id=2710
* This allows removal of the old NHiberate.Mapping.Attributes.dll * Also add in the files I forgot about last time. Doh!
Diffstat (limited to 'OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_GridStore.sql')
-rw-r--r--OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_GridStore.sql38
1 files changed, 38 insertions, 0 deletions
diff --git a/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_GridStore.sql b/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_GridStore.sql
new file mode 100644
index 0000000..1cb18e3
--- /dev/null
+++ b/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_GridStore.sql
@@ -0,0 +1,38 @@
1BEGIN TRANSACTION;
2
3create table Regions (
4 Uuid NVARCHAR(255) not null,
5 RegionHandle BIGINT null,
6 RegionName NVARCHAR(32) null,
7 RegionRecvKey NVARCHAR(128) null,
8 RegionSendKey NVARCHAR(128) null,
9 RegionSecret NVARCHAR(128) null,
10 RegionDataURI NVARCHAR(255) null,
11 ServerIP NVARCHAR(64) null,
12 ServerPort INT null,
13 ServerURI NVARCHAR(255) null,
14 RegionLocX INT null,
15 RegionLocY INT null,
16 RegionLocZ INT null,
17 EastOverrideHandle BIGINT null,
18 WestOverrideHandle BIGINT null,
19 SouthOverrideHandle BIGINT null,
20 NorthOverrideHandle BIGINT null,
21 RegionAssetURI NVARCHAR(255) null,
22 RegionAssetRecvKey NVARCHAR(128) null,
23 RegionAssetSendKey NVARCHAR(128) null,
24 RegionUserURI NVARCHAR(255) null,
25 RegionUserRecvKey NVARCHAR(128) null,
26 RegionUserSendKey NVARCHAR(128) null,
27 ServerHttpPort INT null,
28 ServerRemotingPort INT null,
29 RegionMapTextureID NVARCHAR(255) null,
30 Owner_uuid NVARCHAR(255) null,
31 OriginUUID NVARCHAR(255) null,
32 primary key (Uuid)
33);
34
35create index region_handle on Regions (RegionHandle);
36create index region_name on Regions (RegionName);
37
38COMMIT; \ No newline at end of file