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.

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 @@
-CREATE TABLE `regions` (
-  `Uuid` varchar(36) NOT NULL,
-  `RegionHandle` bigint(20) unsigned NOT NULL,
-  `RegionName` varchar(32) default NULL,
-  `RegionRecvKey` varchar(128) default NULL,
-  `RegionSendKey` varchar(128) default NULL,
-  `RegionSecret` varchar(128) default NULL,
-  `RegionDataURI` varchar(255) default NULL,
-  `ServerIP` varchar(64) default NULL,
-  `ServerPort` int(10) unsigned default NULL,
-  `ServerURI` varchar(255) default NULL,
-  `RegionLocX` int(10) unsigned default NULL,
-  `RegionLocY` int(10) unsigned default NULL,
-  `RegionLocZ` int(10) unsigned default NULL,
-  `EastOverrideHandle` bigint(20) unsigned default NULL,
-  `WestOverrideHandle` bigint(20) unsigned default NULL,
-  `SouthOverrideHandle` bigint(20) unsigned default NULL,
-  `NorthOverrideHandle` bigint(20) unsigned default NULL,
-  `RegionAssetURI` varchar(255) default NULL,
-  `RegionAssetRecvKey` varchar(128) default NULL,
-  `RegionAssetSendKey` varchar(128) default NULL,
-  `RegionUserURI` varchar(255) default NULL,
-  `RegionUserRecvKey` varchar(128) default NULL,
-  `RegionUserSendKey` varchar(128) default NULL, `regionMapTexture` varchar(36) default NULL,
-  `ServerHttpPort` int(10) default NULL, `serverRemotingPort` int(10) default NULL,
-  `Owner_uuid` varchar(36) default '00000000-0000-0000-0000-000000000000' not null,
-  `OriginUUID` varchar(36),
-  PRIMARY KEY  (`uuid`),
-  KEY `region_name` (`RegionName`),
-  KEY `region_handle` (`RegionHandle`),
-  KEY `overrideHandles` (`EastOverrideHandle`,`WestOverrideHandle`,`SouthOverrideHandle`,`NorthOverrideHandle`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Rev. 3';
\ No newline at end of file
+CREATE TABLE Regions (
+  RegionID VARCHAR(36) NOT NULL,
+  OwnerID VARCHAR(36) DEFAULT NULL,
+  OriginID VARCHAR(36) DEFAULT NULL,
+  RegionHandle BIGINT DEFAULT NULL,
+  RegionName VARCHAR(32) DEFAULT NULL,
+  RegionRecvKey VARCHAR(128) DEFAULT NULL,
+  RegionSendKey VARCHAR(128) DEFAULT NULL,
+  RegionSecret VARCHAR(128) DEFAULT NULL,
+  RegionDataURI VARCHAR(255) DEFAULT NULL,
+  ServerIP VARCHAR(64) DEFAULT NULL,
+  ServerPort INT DEFAULT NULL,
+  ServerURI VARCHAR(255) DEFAULT NULL,
+  RegionLocX INT DEFAULT NULL,
+  RegionLocY INT DEFAULT NULL,
+  RegionLocZ INT DEFAULT NULL,
+  EastOverrideHandle BIGINT DEFAULT NULL,
+  WestOverrideHandle BIGINT DEFAULT NULL,
+  SouthOverrideHandle BIGINT DEFAULT NULL,
+  NorthOverrideHandle BIGINT DEFAULT NULL,
+  RegionAssetURI VARCHAR(255) DEFAULT NULL,
+  RegionAssetRecvKey VARCHAR(128) DEFAULT NULL,
+  RegionAssetSendKey VARCHAR(128) DEFAULT NULL,
+  RegionUserURI VARCHAR(255) DEFAULT NULL,
+  RegionUserRecvKey VARCHAR(128) DEFAULT NULL,
+  RegionUserSendKey VARCHAR(128) DEFAULT NULL, 
+  RegionMapTexture VARCHAR(36) DEFAULT NULL,
+  ServerHttpPort INT DEFAULT NULL, 
+  ServerRemotingPort INT DEFAULT NULL,
+  PRIMARY KEY  (uuid),
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev. 1';
+
+CREATE INDEX RegionNameIndex ON Regions (RegionName);
+CREATE INDEX RegionHandleIndex ON Regions (RegionHandle);
+CREATE INDEX RegionHandlesIndex ON Regions (EastOverrideHandle,WestOverrideHandle,SouthOverrideHandle,NorthOverrideHandle);