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/MySQLDialect/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/MySQLDialect/001_GridStore.sql')
-rw-r--r-- | OpenSim/Data/NHibernate/Resources/MySQLDialect/001_GridStore.sql | 67 |
1 files changed, 35 insertions, 32 deletions
diff --git a/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_GridStore.sql b/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_GridStore.sql index df09603..5fb1c19 100644 --- a/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_GridStore.sql +++ b/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_GridStore.sql | |||
@@ -1,32 +1,35 @@ | |||
1 | CREATE TABLE `regions` ( | 1 | CREATE TABLE Regions ( |
2 | `Uuid` varchar(36) NOT NULL, | 2 | RegionID VARCHAR(36) NOT NULL, |
3 | `RegionHandle` bigint(20) unsigned NOT NULL, | 3 | OwnerID VARCHAR(36) DEFAULT NULL, |
4 | `RegionName` varchar(32) default NULL, | 4 | OriginID VARCHAR(36) DEFAULT NULL, |
5 | `RegionRecvKey` varchar(128) default NULL, | 5 | RegionHandle BIGINT DEFAULT NULL, |
6 | `RegionSendKey` varchar(128) default NULL, | 6 | RegionName VARCHAR(32) DEFAULT NULL, |
7 | `RegionSecret` varchar(128) default NULL, | 7 | RegionRecvKey VARCHAR(128) DEFAULT NULL, |
8 | `RegionDataURI` varchar(255) default NULL, | 8 | RegionSendKey VARCHAR(128) DEFAULT NULL, |
9 | `ServerIP` varchar(64) default NULL, | 9 | RegionSecret VARCHAR(128) DEFAULT NULL, |
10 | `ServerPort` int(10) unsigned default NULL, | 10 | RegionDataURI VARCHAR(255) DEFAULT NULL, |
11 | `ServerURI` varchar(255) default NULL, | 11 | ServerIP VARCHAR(64) DEFAULT NULL, |
12 | `RegionLocX` int(10) unsigned default NULL, | 12 | ServerPort INT DEFAULT NULL, |
13 | `RegionLocY` int(10) unsigned default NULL, | 13 | ServerURI VARCHAR(255) DEFAULT NULL, |
14 | `RegionLocZ` int(10) unsigned default NULL, | 14 | RegionLocX INT DEFAULT NULL, |
15 | `EastOverrideHandle` bigint(20) unsigned default NULL, | 15 | RegionLocY INT DEFAULT NULL, |
16 | `WestOverrideHandle` bigint(20) unsigned default NULL, | 16 | RegionLocZ INT DEFAULT NULL, |
17 | `SouthOverrideHandle` bigint(20) unsigned default NULL, | 17 | EastOverrideHandle BIGINT DEFAULT NULL, |
18 | `NorthOverrideHandle` bigint(20) unsigned default NULL, | 18 | WestOverrideHandle BIGINT DEFAULT NULL, |
19 | `RegionAssetURI` varchar(255) default NULL, | 19 | SouthOverrideHandle BIGINT DEFAULT NULL, |
20 | `RegionAssetRecvKey` varchar(128) default NULL, | 20 | NorthOverrideHandle BIGINT DEFAULT NULL, |
21 | `RegionAssetSendKey` varchar(128) default NULL, | 21 | RegionAssetURI VARCHAR(255) DEFAULT NULL, |
22 | `RegionUserURI` varchar(255) default NULL, | 22 | RegionAssetRecvKey VARCHAR(128) DEFAULT NULL, |
23 | `RegionUserRecvKey` varchar(128) default NULL, | 23 | RegionAssetSendKey VARCHAR(128) DEFAULT NULL, |
24 | `RegionUserSendKey` varchar(128) default NULL, `regionMapTexture` varchar(36) default NULL, | 24 | RegionUserURI VARCHAR(255) DEFAULT NULL, |
25 | `ServerHttpPort` int(10) default NULL, `serverRemotingPort` int(10) default NULL, | 25 | RegionUserRecvKey VARCHAR(128) DEFAULT NULL, |
26 | `Owner_uuid` varchar(36) default '00000000-0000-0000-0000-000000000000' not null, | 26 | RegionUserSendKey VARCHAR(128) DEFAULT NULL, |
27 | `OriginUUID` varchar(36), | 27 | RegionMapTexture VARCHAR(36) DEFAULT NULL, |
28 | PRIMARY KEY (`uuid`), | 28 | ServerHttpPort INT DEFAULT NULL, |
29 | KEY `region_name` (`RegionName`), | 29 | ServerRemotingPort INT DEFAULT NULL, |
30 | KEY `region_handle` (`RegionHandle`), | 30 | PRIMARY KEY (uuid), |
31 | KEY `overrideHandles` (`EastOverrideHandle`,`WestOverrideHandle`,`SouthOverrideHandle`,`NorthOverrideHandle`) | 31 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev. 1'; |
32 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Rev. 3'; \ No newline at end of file | 32 | |
33 | CREATE INDEX RegionNameIndex ON Regions (RegionName); | ||
34 | CREATE INDEX RegionHandleIndex ON Regions (RegionHandle); | ||
35 | CREATE INDEX RegionHandlesIndex ON Regions (EastOverrideHandle,WestOverrideHandle,SouthOverrideHandle,NorthOverrideHandle); | ||