diff options
author | Charles Krinke | 2009-01-12 20:14:39 +0000 |
---|---|---|
committer | Charles Krinke | 2009-01-12 20:14:39 +0000 |
commit | c00c855cc5decf73d598af5d74a2ef57c547efd3 (patch) | |
tree | 03a6e3622db531537c2cfb47a99acd5edf4fe6b7 /OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_GridStore.sql | |
parent | * Separate starting a client thread into a separate Start() method (which mat... (diff) | |
download | opensim-SC_OLD-c00c855cc5decf73d598af5d74a2ef57c547efd3.zip opensim-SC_OLD-c00c855cc5decf73d598af5d74a2ef57c547efd3.tar.gz opensim-SC_OLD-c00c855cc5decf73d598af5d74a2ef57c547efd3.tar.bz2 opensim-SC_OLD-c00c855cc5decf73d598af5d74a2ef57c547efd3.tar.xz |
Thank you kindly, Tlaukkan (Tommil) for a patch that:
Cleaned up schema creation scripts of MySQL to compliant form and created
SQLite scripts from them. In future it would be optimal if scripts from
different databases could be generated from MySQL scripts to ensure optimal
consistency between schemas of different databases. Did not yet review
column names. ID columns seem to have variety in naming which can be confusing.
Diffstat (limited to 'OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_GridStore.sql')
-rw-r--r-- | OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_GridStore.sql | 69 |
1 files changed, 33 insertions, 36 deletions
diff --git a/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_GridStore.sql b/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_GridStore.sql index 1cb18e3..336a277 100644 --- a/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_GridStore.sql +++ b/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_GridStore.sql | |||
@@ -1,38 +1,35 @@ | |||
1 | BEGIN TRANSACTION; | 1 | CREATE TABLE Regions ( |
2 | 2 | RegionId VARCHAR(36) NOT NULL, | |
3 | create table Regions ( | 3 | RegionHandle BIGINT UNSIGNED NOT NULL, |
4 | Uuid NVARCHAR(255) not null, | 4 | RegionName VARCHAR(32) DEFAULT NULL, |
5 | RegionHandle BIGINT null, | 5 | RegionRecvKey VARCHAR(128) DEFAULT NULL, |
6 | RegionName NVARCHAR(32) null, | 6 | RegionSendKey VARCHAR(128) DEFAULT NULL, |
7 | RegionRecvKey NVARCHAR(128) null, | 7 | RegionSecret VARCHAR(128) DEFAULT NULL, |
8 | RegionSendKey NVARCHAR(128) null, | 8 | RegionDataURI VARCHAR(255) DEFAULT NULL, |
9 | RegionSecret NVARCHAR(128) null, | 9 | ServerIP VARCHAR(64) DEFAULT NULL, |
10 | RegionDataURI NVARCHAR(255) null, | 10 | ServerPort INT UNSIGNED DEFAULT NULL, |
11 | ServerIP NVARCHAR(64) null, | 11 | ServerURI VARCHAR(255) DEFAULT NULL, |
12 | ServerPort INT null, | 12 | RegionLocX INT UNSIGNED DEFAULT NULL, |
13 | ServerURI NVARCHAR(255) null, | 13 | RegionLocY INT UNSIGNED DEFAULT NULL, |
14 | RegionLocX INT null, | 14 | RegionLocZ INT UNSIGNED DEFAULT NULL, |
15 | RegionLocY INT null, | 15 | EastOverrideHandle BIGINT UNSIGNED DEFAULT NULL, |
16 | RegionLocZ INT null, | 16 | WestOverrideHandle BIGINT UNSIGNED DEFAULT NULL, |
17 | EastOverrideHandle BIGINT null, | 17 | SouthOverrideHandle BIGINT UNSIGNED DEFAULT NULL, |
18 | WestOverrideHandle BIGINT null, | 18 | NorthOverrideHandle BIGINT UNSIGNED DEFAULT NULL, |
19 | SouthOverrideHandle BIGINT null, | 19 | RegionAssetURI VARCHAR(255) DEFAULT NULL, |
20 | NorthOverrideHandle BIGINT null, | 20 | RegionAssetRecvKey VARCHAR(128) DEFAULT NULL, |
21 | RegionAssetURI NVARCHAR(255) null, | 21 | RegionAssetSendKey VARCHAR(128) DEFAULT NULL, |
22 | RegionAssetRecvKey NVARCHAR(128) null, | 22 | RegionUserURI VARCHAR(255) DEFAULT NULL, |
23 | RegionAssetSendKey NVARCHAR(128) null, | 23 | RegionUserRecvKey VARCHAR(128) DEFAULT NULL, |
24 | RegionUserURI NVARCHAR(255) null, | 24 | RegionUserSendKey VARCHAR(128) DEFAULT NULL, |
25 | RegionUserRecvKey NVARCHAR(128) null, | 25 | regionMapTexture VARCHAR(36) DEFAULT NULL, |
26 | RegionUserSendKey NVARCHAR(128) null, | 26 | ServerHttpPort INT DEFAULT NULL, |
27 | ServerHttpPort INT null, | 27 | ServerRemotingPort INT DEFAULT NULL, |
28 | ServerRemotingPort INT null, | 28 | OwnerID VARCHAR(36) DEFAULT NULL, |
29 | RegionMapTextureID NVARCHAR(255) null, | 29 | OriginID VARCHAR(36) DEFAULT NULL, |
30 | Owner_uuid NVARCHAR(255) null, | 30 | PRIMARY KEY (uuid), |
31 | OriginUUID NVARCHAR(255) null, | ||
32 | primary key (Uuid) | ||
33 | ); | 31 | ); |
34 | 32 | ||
35 | create index region_handle on Regions (RegionHandle); | 33 | CREATE INDEX RegionNameIndex ON Regions (RegionName); |
36 | create index region_name on Regions (RegionName); | 34 | CREATE INDEX RegionHandleIndex ON Regions (RegionHandle); |
37 | 35 | CREATE INDEX RegionHandlesIndex ON Regions (EastOverrideHandle,WestOverrideHandle,SouthOverrideHandle,NorthOverrideHandle); | |
38 | COMMIT; \ No newline at end of file | ||