diff options
author | Justin Clarke Casey | 2008-12-04 20:48:08 +0000 |
---|---|---|
committer | Justin Clarke Casey | 2008-12-04 20:48:08 +0000 |
commit | bdee86563cfce5211f182b78e64503a05fc7ffa1 (patch) | |
tree | 9b1e7e941e787d36f2248ff4b57f101a779351a6 /OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_GridStore.sql | |
parent | * Apply http://opensimulator.org/mantis/view.php?id=2750 with a small tweak. (diff) | |
download | opensim-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.sql | 38 |
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 @@ | |||
1 | BEGIN TRANSACTION; | ||
2 | |||
3 | create 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 | |||
35 | create index region_handle on Regions (RegionHandle); | ||
36 | create index region_name on Regions (RegionName); | ||
37 | |||
38 | COMMIT; \ No newline at end of file | ||