opensim/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_RegionStore.sql

create table Prims (
  UUID NVARCHAR(255) not null,
   ParentID INT null,
   ParentUUID NVARCHAR(255) null,
   RegionID NVARCHAR(255) null,
   CreationDate INT null,
   Name NVARCHAR(255) null,
   Text NVARCHAR(255) null,
   Description NVARCHAR(255) null,
   SitName NVARCHAR(255) null,
   TouchName NVARCHAR(255) null,
   ObjectFlags INT null,
   CreatorID NVARCHAR(255) null,
   OwnerID NVARCHAR(255) null,
   GroupID NVARCHAR(255) null,
   LastOwnerID NVARCHAR(255) null,
   OwnerMask INT null,
   NextOwnerMask INT null,
   GroupMask INT null,
   EveryoneMask INT null,
   BaseMask INT null,
   PositionX REAL null,
   PositionY REAL null,
   PositionZ REAL null,
   GroupPositionX REAL null,
   GroupPositionY REAL null,
   GroupPositionZ REAL null,
   VelocityX REAL null,
   VelocityY REAL null,
   VelocityZ REAL null,
   AngularVelocityX REAL null,
   AngularVelocityY REAL null,
   AngularVelocityZ REAL null,
   AccelerationX REAL null,
   AccelerationY REAL null,
   AccelerationZ REAL null,
   SitTargetOffsetX REAL null,
   SitTargetOffsetY REAL null,
   SitTargetOffsetZ REAL null,
   RotationX REAL null,
   RotationY REAL null,
   RotationZ REAL null,
   RotationW REAL null,
   SitTargetOrientX REAL null,
   SitTargetOrientY REAL null,
   SitTargetOrientZ REAL null,
   SitTargetOrientW REAL null,
   ScaleX REAL null,
   ScaleY REAL null,
   ScaleZ REAL null,
   PCode TINYINT null,
   PathBegin INT null,
   PathEnd INT null,
   PathScaleX TINYINT null,
   PathScaleY TINYINT null,
   PathShearX TINYINT null,
   PathShearY TINYINT null,
   PathSkew TINYINT null,
   PathCurve TINYINT null,
   PathRadiusOffset TINYINT null,
   PathRevolutions TINYINT null,
   PathTaperX TINYINT null,
   PathTaperY TINYINT null,
   PathTwist TINYINT null,
   ProfileBegin INT null,
   ProfileEnd INT null,
   ProfileCurve TINYINT null,
   ProfileHollow INT null,
   Texture VARBINARY(8000) null,
   ExtraParams VARBINARY(8000) null,
   State TINYINT null,
   primary key (UUID)
)

create table PrimItems (
  ItemID NVARCHAR(255) not null,
   PrimID NVARCHAR(255) null,
   AssetID NVARCHAR(255) null,
   ParentFolderID NVARCHAR(255) null,
   CreatorID NVARCHAR(255) null,
   OwnerID NVARCHAR(255) null,
   GroupID NVARCHAR(255) null,
   LastOwnerID NVARCHAR(255) null,
   CurrentPermissions INT null,
   BasePermissions INT null,
   EveryonePermissions INT null,
   GroupPermissions INT null,
   NextPermissions INT null,
   Name NVARCHAR(255) null,
   Description NVARCHAR(255) null,
   CreationDate INT null,
   Flags INT null,
   Type INT null,
   InvType INT null,
   primary key (ItemID)
)

create table Terrain (
   RegionID NVARCHAR(255) not null,
   MapData VARBINARY(max) null,
   primary key (RegionID)
)