diff options
Diffstat (limited to 'OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_RegionStore.sql')
| -rw-r--r-- | OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_RegionStore.sql | 101 |
1 files changed, 101 insertions, 0 deletions
diff --git a/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_RegionStore.sql b/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_RegionStore.sql new file mode 100644 index 0000000..934e12f --- /dev/null +++ b/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_RegionStore.sql | |||
| @@ -0,0 +1,101 @@ | |||
| 1 | create table Prims ( | ||
| 2 | UUID NVARCHAR(255) not null, | ||
| 3 | ParentID INT null, | ||
| 4 | ParentUUID NVARCHAR(255) null, | ||
| 5 | RegionID NVARCHAR(255) null, | ||
| 6 | CreationDate INT null, | ||
| 7 | Name NVARCHAR(255) null, | ||
| 8 | Text NVARCHAR(255) null, | ||
| 9 | Description NVARCHAR(255) null, | ||
| 10 | SitName NVARCHAR(255) null, | ||
| 11 | TouchName NVARCHAR(255) null, | ||
| 12 | ObjectFlags INT null, | ||
| 13 | CreatorID NVARCHAR(255) null, | ||
| 14 | OwnerID NVARCHAR(255) null, | ||
| 15 | GroupID NVARCHAR(255) null, | ||
| 16 | LastOwnerID NVARCHAR(255) null, | ||
| 17 | OwnerMask INT null, | ||
| 18 | NextOwnerMask INT null, | ||
| 19 | GroupMask INT null, | ||
| 20 | EveryoneMask INT null, | ||
| 21 | BaseMask INT null, | ||
| 22 | PositionX REAL null, | ||
| 23 | PositionY REAL null, | ||
| 24 | PositionZ REAL null, | ||
| 25 | GroupPositionX REAL null, | ||
| 26 | GroupPositionY REAL null, | ||
| 27 | GroupPositionZ REAL null, | ||
| 28 | VelocityX REAL null, | ||
| 29 | VelocityY REAL null, | ||
| 30 | VelocityZ REAL null, | ||
| 31 | AngularVelocityX REAL null, | ||
| 32 | AngularVelocityY REAL null, | ||
| 33 | AngularVelocityZ REAL null, | ||
| 34 | AccelerationX REAL null, | ||
| 35 | AccelerationY REAL null, | ||
| 36 | AccelerationZ REAL null, | ||
| 37 | SitTargetOffsetX REAL null, | ||
| 38 | SitTargetOffsetY REAL null, | ||
| 39 | SitTargetOffsetZ REAL null, | ||
| 40 | RotationX REAL null, | ||
| 41 | RotationY REAL null, | ||
| 42 | RotationZ REAL null, | ||
| 43 | RotationW REAL null, | ||
| 44 | SitTargetOrientX REAL null, | ||
| 45 | SitTargetOrientY REAL null, | ||
| 46 | SitTargetOrientZ REAL null, | ||
| 47 | SitTargetOrientW REAL null, | ||
| 48 | ScaleX REAL null, | ||
| 49 | ScaleY REAL null, | ||
| 50 | ScaleZ REAL null, | ||
| 51 | PCode TINYINT null, | ||
| 52 | PathBegin SMALLINT null, | ||
| 53 | PathEnd SMALLINT null, | ||
| 54 | PathScaleX TINYINT null, | ||
| 55 | PathScaleY TINYINT null, | ||
| 56 | PathShearX TINYINT null, | ||
| 57 | PathShearY TINYINT null, | ||
| 58 | PathSkew TINYINT null, | ||
| 59 | PathCurve TINYINT null, | ||
| 60 | PathRadiusOffset TINYINT null, | ||
| 61 | PathRevolutions TINYINT null, | ||
| 62 | PathTaperX TINYINT null, | ||
| 63 | PathTwist TINYINT null, | ||
| 64 | ProfileBegin SMALLINT null, | ||
| 65 | ProfileEnd SMALLINT null, | ||
| 66 | ProfileCurve TINYINT null, | ||
| 67 | ProfileHollow SMALLINT null, | ||
| 68 | Texture VARBINARY(8000) null, | ||
| 69 | ExtraParams VARBINARY(8000) null, | ||
| 70 | State TINYINT null, | ||
| 71 | primary key (UUID) | ||
| 72 | ) | ||
| 73 | |||
| 74 | create table PrimItems ( | ||
| 75 | ItemID NVARCHAR(255) not null, | ||
| 76 | PrimID NVARCHAR(255) null, | ||
| 77 | AssetID NVARCHAR(255) null, | ||
| 78 | ParentFolderID NVARCHAR(255) null, | ||
| 79 | CreatorID NVARCHAR(255) null, | ||
| 80 | OwnerID NVARCHAR(255) null, | ||
| 81 | GroupID NVARCHAR(255) null, | ||
| 82 | LastOwnerID NVARCHAR(255) null, | ||
| 83 | CurrentPermissions INT null, | ||
| 84 | BasePermissions INT null, | ||
| 85 | EveryonePermissions INT null, | ||
| 86 | GroupPermissions INT null, | ||
| 87 | NextPermissions INT null, | ||
| 88 | Name NVARCHAR(255) null, | ||
| 89 | Description NVARCHAR(255) null, | ||
| 90 | CreationDate INT null, | ||
| 91 | Flags INT null, | ||
| 92 | InvType INT null, | ||
| 93 | primary key (ItemID) | ||
| 94 | ) | ||
| 95 | |||
| 96 | create table Terrain ( | ||
| 97 | RegionID NVARCHAR(255) not null, | ||
| 98 | MapData VARBINARY(max) null, | ||
| 99 | primary key (RegionID) | ||
| 100 | ) | ||
| 101 | |||