diff options
author | Justin Clarke Casey | 2009-01-12 17:51:43 +0000 |
---|---|---|
committer | Justin Clarke Casey | 2009-01-12 17:51:43 +0000 |
commit | af0fcb96a43137bfd1de0c8cca190522a549e492 (patch) | |
tree | fa28d846c81c21b7c0c6274eeb372ff57048b6dd /OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_RegionStore.sql | |
parent | * Apply http://opensimulator.org/mantis/view.php?id=2980 (diff) | |
download | opensim-SC_OLD-af0fcb96a43137bfd1de0c8cca190522a549e492.zip opensim-SC_OLD-af0fcb96a43137bfd1de0c8cca190522a549e492.tar.gz opensim-SC_OLD-af0fcb96a43137bfd1de0c8cca190522a549e492.tar.bz2 opensim-SC_OLD-af0fcb96a43137bfd1de0c8cca190522a549e492.tar.xz |
* Apply http://opensimulator.org/mantis/view.php?id=2965
* Adds first version of MsSql2005Dialect support for NHibernate
* Thanks mpallari
Diffstat (limited to '')
-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 | |||