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, 162 insertions, 144 deletions

diff --git a/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_RegionStore.sql b/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_RegionStore.sql
index eaa0964..7b591be 100644
--- a/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_RegionStore.sql
+++ b/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_RegionStore.sql
@@ -1,150 +1,168 @@
-BEGIN TRANSACTION;
-
-create table Prims (
-  UUID TEXT not null,
-   RegionID TEXT,
-   GroupID TEXT,
-   ParentID INTEGER,
-   ParentUUID TEXT,
-   OwnerID TEXT,
-   LastOwnerID TEXT,
-   CreatorID TEXT,
-   CreationDate INTEGER,
-   LinkNum INTEGER,   
-   Name TEXT,
-   Text TEXT,
-   Description TEXT,
-   SitName TEXT,
-   TouchName TEXT,
-   ObjectFlags INTEGER,
-   OwnerMask INTEGER,
-   NextOwnerMask INTEGER,
-   GroupMask INTEGER,
-   EveryoneMask INTEGER,
-   BaseMask INTEGER,
-   Material INTEGER,
-   ScriptAccessPin INTEGER,
-   TextureAnimation BLOB,
-   ParticleSystem BLOB,
-   ClickAction INTEGER,
-   Color INTEGER,
-   PositionX NUMERIC,
-   PositionY NUMERIC,
-   PositionZ NUMERIC,
-   GroupPositionX NUMERIC,
-   GroupPositionY NUMERIC,
-   GroupPositionZ NUMERIC,
-   VelocityX NUMERIC,
-   VelocityY NUMERIC,
-   VelocityZ NUMERIC,
-   AngularVelocityX NUMERIC,
-   AngularVelocityY NUMERIC,
-   AngularVelocityZ NUMERIC,
-   AccelerationX NUMERIC,
-   AccelerationY NUMERIC,
-   AccelerationZ NUMERIC,
-   SitTargetOffsetX NUMERIC,
-   SitTargetOffsetY NUMERIC,
-   SitTargetOffsetZ NUMERIC,
-   RotationX NUMERIC,
-   RotationY NUMERIC,
-   RotationZ NUMERIC,
-   RotationW NUMERIC,
-   SitTargetOrientX NUMERIC,
-   SitTargetOrientY NUMERIC,
-   SitTargetOrientZ NUMERIC,
-   SitTargetOrientW NUMERIC,
-   ScaleX NUMERIC,
-   ScaleY NUMERIC,
-   ScaleZ NUMERIC,
-   PCode INTEGER,
-   PathBegin INTEGER,
-   PathEnd INTEGER,
-   PathScaleX INTEGER,
-   PathScaleY INTEGER,
-   PathShearX INTEGER,
-   PathShearY INTEGER,
-   PathSkew INTEGER,
-   PathCurve INTEGER,
-   PathRadiusOffset INTEGER,
-   PathRevolutions INTEGER,
-   PathTaperX INTEGER,
-   PathTwist INTEGER,
-   ProfileBegin INTEGER,
-   ProfileEnd INTEGER,
-   ProfileCurve INTEGER,
-   ProfileHollow INTEGER,
-   Texture BLOB,
-   ExtraParams BLOB,
-   State INTEGER,
-   primary key (UUID)
+CREATE TABLE Prims (
+  UUID VARCHAR(36) NOT NULL,
+  RegionID VARCHAR(36) DEFAULT NULL,
+  GroupID VARCHAR(36) DEFAULT NULL,
+  ParentID INT DEFAULT NULL,
+  ParentUUID VARCHAR(36) DEFAULT NULL,
+  OwnerID VARCHAR(36) DEFAULT NULL,
+  LastOwnerID VARCHAR(36) DEFAULT NULL,
+  CreatorID VARCHAR(36) DEFAULT NULL,
+  CreationDate INT DEFAULT NULL,
+  LinkNum INT DEFAULT NULL,
+  Name VARCHAR(255) DEFAULT NULL,
+  Text VARCHAR(255) DEFAULT NULL,
+  Description VARCHAR(255) DEFAULT NULL,
+  SitName VARCHAR(255) DEFAULT NULL,
+  TouchName VARCHAR(255) DEFAULT NULL,
+  ObjectFlags INT DEFAULT NULL,
+  OwnerMask INT DEFAULT NULL,
+  NextOwnerMask INT DEFAULT NULL,
+  GroupMask INT DEFAULT NULL,
+  EveryoneMask INT DEFAULT NULL,
+  BaseMask INT DEFAULT NULL,
+  Material TINYINT DEFAULT NULL,  
+  ScriptAccessPin INT DEFAULT NULL,
+  TextureAnimation BLOB,
+  ParticleSystem BLOB,
+  ClickAction TINYINT DEFAULT NULL,  
+  Color INT DEFAULT NULL,
+  PositionX DOUBLE DEFAULT NULL,
+  PositionY DOUBLE DEFAULT NULL,
+  PositionZ DOUBLE DEFAULT NULL,
+  GroupPositionX DOUBLE DEFAULT NULL,
+  GroupPositionY DOUBLE DEFAULT NULL,
+  GroupPositionZ DOUBLE DEFAULT NULL,
+  VelocityX DOUBLE DEFAULT NULL,
+  VelocityY DOUBLE DEFAULT NULL,
+  VelocityZ DOUBLE DEFAULT NULL,
+  AngularVelocityX DOUBLE DEFAULT NULL,
+  AngularVelocityY DOUBLE DEFAULT NULL,
+  AngularVelocityZ DOUBLE DEFAULT NULL,
+  AccelerationX DOUBLE DEFAULT NULL,
+  AccelerationY DOUBLE DEFAULT NULL,
+  AccelerationZ DOUBLE DEFAULT NULL,
+  RotationX DOUBLE DEFAULT NULL,
+  RotationY DOUBLE DEFAULT NULL,
+  RotationZ DOUBLE DEFAULT NULL,
+  RotationW DOUBLE DEFAULT NULL,
+  SitTargetOffsetX DOUBLE DEFAULT NULL,
+  SitTargetOffsetY DOUBLE DEFAULT NULL,
+  SitTargetOffsetZ DOUBLE DEFAULT NULL,
+  SitTargetOrientW DOUBLE DEFAULT NULL,
+  SitTargetOrientX DOUBLE DEFAULT NULL,
+  SitTargetOrientY DOUBLE DEFAULT NULL,
+  SitTargetOrientZ DOUBLE DEFAULT NULL,
+  -- this is the shape
+  Shape INT DEFAULT NULL,
+  ScaleX DOUBLE DEFAULT NULL,
+  ScaleY DOUBLE DEFAULT NULL,
+  ScaleZ DOUBLE DEFAULT NULL,
+  PCode INT DEFAULT NULL,
+  PathBegin INT DEFAULT NULL,
+  PathEnd INT DEFAULT NULL,
+  PathScaleX INT DEFAULT NULL,
+  PathScaleY INT DEFAULT NULL,
+  PathShearX INT DEFAULT NULL,
+  PathShearY INT DEFAULT NULL,
+  PathSkew INT DEFAULT NULL,
+  PathCurve INT DEFAULT NULL,
+  PathRadiusOffset INT DEFAULT NULL,
+  PathRevolutions INT DEFAULT NULL,
+  PathTaperX INT DEFAULT NULL,
+  PathTaperY INT DEFAULT NULL,
+  PathTwist INT DEFAULT NULL,
+  PathTwistBegin INT DEFAULT NULL,
+  ProfileBegin INT DEFAULT NULL,
+  ProfileEnd INT DEFAULT NULL,
+  ProfileCurve INT DEFAULT NULL,
+  ProfileHollow INT DEFAULT NULL,
+  State INT DEFAULT NULL,
+  Texture BLOB,
+  ExtraParams BLOB,
+  PRIMARY KEY (UUID)
 );
-create table Terrain (
-  RegionID TEXT not null,
-   MapData BLOB,
-   primary key (RegionID)
+
+CREATE INDEX PrimsRegionIdIndex ON Prims (RegionID);
+CREATE INDEX PrimsRegionParentUuidIndex ON Prims (ParentUUID);
+
+CREATE TABLE Terrain (
+  RegionID VARCHAR(36) NOT NULL,
+  MapData BLOB,
+  PRIMARY KEY (RegionID)
 );
-create table PrimItems (
-  ItemID TEXT not null,
-   PrimID TEXT,
-   AssetID TEXT,
-   ParentFolderID TEXT,
-   CreatorID TEXT,
-   OwnerID TEXT,
-   GroupID TEXT,
-   LastOwnerID TEXT,
-   CurrentPermissions INTEGER,
-   BasePermissions INTEGER,
-   EveryonePermissions INTEGER,
-   GroupPermissions INTEGER,
-   NextPermissions INTEGER,
-   Name TEXT,
-   Description TEXT,
-   CreationDate INTEGER,
-   Flags INTEGER,
-   InvType INTEGER,
-   primary key (ItemID)
+
+CREATE TABLE PrimItems (
+  ItemID VARCHAR(36) NOT NULL,
+  GroupID VARCHAR(36) DEFAULT NULL,
+  PrimID VARCHAR(36) DEFAULT NULL,
+  ParentFolderID VARCHAR(36) DEFAULT NULL,
+  AssetID VARCHAR(36) DEFAULT NULL,
+  OwnerID VARCHAR(36) DEFAULT NULL,
+  LastOwnerID VARCHAR(36) DEFAULT NULL,
+  CreatorID VARCHAR(36) DEFAULT NULL,
+  CreationDate BIGINT DEFAULT NULL,
+  InvType INT DEFAULT NULL,
+  Name VARCHAR(255) DEFAULT NULL,
+  Description VARCHAR(255) DEFAULT NULL,
+  NextPermissions INT DEFAULT NULL,
+  CurrentPermissions INT DEFAULT NULL,
+  BasePermissions INT DEFAULT NULL,
+  EveryonePermissions INT DEFAULT NULL,
+  GroupPermissions INT DEFAULT NULL,
+  Flags INT DEFAULT NULL,
+  PRIMARY KEY (ItemID)
 );
 
+CREATE INDEX PrimItemsPrimIdIndex ON PrimItems (PrimID);
+
 CREATE TABLE RegionSettings (
-  RegionID TEXT not null,
-  BlockTerraform BIT,
-  BlockFly BIT,
-  AllowDamage BIT,
-  RestrictPushing BIT,
-  AllowLandResell BIT,
-  AllowLandJoinDivide BIT,
-  BlockShowInSearch BIT,
-  AgentLimit INTEGER,
-  ObjectBonus NUMERIC,
-  Maturity INTEGER,
-  DisableScripts BIT,
-  DisableCollisions BIT,
-  DisablePhysics BIT,
-  TerrainTexture1 TEXT,
-  TerrainTexture2 TEXT,
-  TerrainTexture3 TEXT,
-  TerrainTexture4 TEXT,
-  Elevation1NW NUMERIC,
-  Elevation2NW NUMERIC,
-  Elevation1NE NUMERIC,
-  Elevation2NE NUMERIC,
-  Elevation1SE NUMERIC,
-  Elevation2SE NUMERIC,
-  Elevation1SW NUMERIC,
-  Elevation2SW NUMERIC,
-  WaterHeight NUMERIC,
-  TerrainRaiseLimit NUMERIC,
-  TerrainLowerLimit NUMERIC,
-  UseEstateSun BIT,
-  Sandbox BIT,
-  SunVectorX NUMERIC,
-  SunVectorY NUMERIC,
-  SunVectorZ NUMERIC,
-  FixedSun BIT, 
-  SunPosition NUMERIC,
-  Covenant TEXT,
-  primary key (RegionID)
-);
+  RegionID VARCHAR(36) NOT NULL,
+  
+  BlockTerraform BIT DEFAULT NULL,
+  BlockFly BIT DEFAULT NULL,
+  AllowDamage BIT DEFAULT NULL,
+  RestrictPushing BIT DEFAULT NULL,
+  AllowLandResell BIT DEFAULT NULL,
+  AllowLandJoinDivide BIT DEFAULT NULL,
+  BlockShowInSearch BIT DEFAULT NULL,
+  
+  AgentLimit INT DEFAULT NULL,
+  ObjectBonus DOUBLE DEFAULT NULL,
+  Maturity INT DEFAULT NULL,
+  
+  DisableScripts BIT DEFAULT NULL,
+  DisableCollisions BIT DEFAULT NULL,
+  DisablePhysics BIT DEFAULT NULL,
+
+  TerrainTexture1 VARCHAR(36) DEFAULT NULL,
+  TerrainTexture2 VARCHAR(36) DEFAULT NULL,
+  TerrainTexture3 VARCHAR(36) DEFAULT NULL,
+  TerrainTexture4 VARCHAR(36) DEFAULT NULL,
+
+  Elevation1NW DOUBLE DEFAULT NULL,
+  Elevation2NW DOUBLE DEFAULT NULL,
+  Elevation1NE DOUBLE DEFAULT NULL,
+  Elevation2NE DOUBLE DEFAULT NULL,
+  Elevation1SE DOUBLE DEFAULT NULL,
+  Elevation2SE DOUBLE DEFAULT NULL,
+  Elevation1SW DOUBLE DEFAULT NULL,
+  Elevation2SW DOUBLE DEFAULT NULL,
+  
+  WaterHeight DOUBLE DEFAULT NULL,
+  TerrainRaiseLimit DOUBLE DEFAULT NULL,
+  TerrainLowerLimit DOUBLE DEFAULT NULL,    
 
-COMMIT;
+  UseEstateSun BIT DEFAULT NULL,
+  Sandbox BIT DEFAULT NULL,
+
+  SunVectorX DOUBLE DEFAULT NULL,
+  SunVectorY DOUBLE DEFAULT NULL,
+  SunVectorZ DOUBLE DEFAULT NULL,
+ 
+  FixedSun BIT DEFAULT NULL, 
+  SunPosition DOUBLE DEFAULT NULL, 
+ 
+  Covenant VARCHAR(36) DEFAULT NULL,
+   
+  PRIMARY KEY  (RegionID)
+);