diff options
Diffstat (limited to '')
-rw-r--r-- | OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_RegionStore.sql | 104 |
1 files changed, 0 insertions, 104 deletions
diff --git a/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_RegionStore.sql b/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_RegionStore.sql deleted file mode 100644 index 181a74c..0000000 --- a/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_RegionStore.sql +++ /dev/null | |||
@@ -1,104 +0,0 @@ | |||
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 INT null, | ||
53 | PathEnd INT 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 | PathTaperY TINYINT null, | ||
64 | PathTwist TINYINT null, | ||
65 | ProfileBegin INT null, | ||
66 | ProfileEnd INT null, | ||
67 | ProfileCurve TINYINT null, | ||
68 | ProfileHollow INT null, | ||
69 | Texture VARBINARY(8000) null, | ||
70 | ExtraParams VARBINARY(8000) null, | ||
71 | State TINYINT null, | ||
72 | primary key (UUID) | ||
73 | ) | ||
74 | |||
75 | create table PrimItems ( | ||
76 | ItemID NVARCHAR(255) not null, | ||
77 | PrimID NVARCHAR(255) null, | ||
78 | AssetID NVARCHAR(255) null, | ||
79 | ParentFolderID NVARCHAR(255) null, | ||
80 | CreatorID NVARCHAR(255) null, | ||
81 | OwnerID NVARCHAR(255) null, | ||
82 | GroupID NVARCHAR(255) null, | ||
83 | LastOwnerID NVARCHAR(255) null, | ||
84 | CurrentPermissions INT null, | ||
85 | BasePermissions INT null, | ||
86 | EveryonePermissions INT null, | ||
87 | GroupPermissions INT null, | ||
88 | NextPermissions INT null, | ||
89 | Name NVARCHAR(255) null, | ||
90 | Description NVARCHAR(255) null, | ||
91 | CreationDate INT null, | ||
92 | Flags INT null, | ||
93 | Type INT null, | ||
94 | InvType INT null, | ||
95 | primary key (ItemID) | ||
96 | ) | ||
97 | |||
98 | create table Terrain ( | ||
99 | RegionID NVARCHAR(255) not null, | ||
100 | MapData VARBINARY(max) null, | ||
101 | primary key (RegionID) | ||
102 | ) | ||
103 | |||
104 | |||