aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MSSQL/Resources/001_RegionStore.sql
diff options
context:
space:
mode:
authorMelanie Thielker2008-09-02 20:05:20 +0000
committerMelanie Thielker2008-09-02 20:05:20 +0000
commit9806c0b37471b33fc3a4631ec68fada81ebeeaef (patch)
tree20398c237d1836bb1cb505092b49715ec1180bee /OpenSim/Data/MSSQL/Resources/001_RegionStore.sql
parentSmall fix to a cast in list parsing (diff)
downloadopensim-SC-9806c0b37471b33fc3a4631ec68fada81ebeeaef.zip
opensim-SC-9806c0b37471b33fc3a4631ec68fada81ebeeaef.tar.gz
opensim-SC-9806c0b37471b33fc3a4631ec68fada81ebeeaef.tar.bz2
opensim-SC-9806c0b37471b33fc3a4631ec68fada81ebeeaef.tar.xz
Committing the missing resource file for MSSQL. Sorry...
Diffstat (limited to 'OpenSim/Data/MSSQL/Resources/001_RegionStore.sql')
-rw-r--r--OpenSim/Data/MSSQL/Resources/001_RegionStore.sql161
1 files changed, 161 insertions, 0 deletions
diff --git a/OpenSim/Data/MSSQL/Resources/001_RegionStore.sql b/OpenSim/Data/MSSQL/Resources/001_RegionStore.sql
new file mode 100644
index 0000000..fe7c58f
--- /dev/null
+++ b/OpenSim/Data/MSSQL/Resources/001_RegionStore.sql
@@ -0,0 +1,161 @@
1CREATE TABLE [dbo].[prims](
2 [UUID] [varchar](255) NOT NULL,
3 [RegionUUID] [varchar](255) NULL,
4 [ParentID] [int] NULL,
5 [CreationDate] [int] NULL,
6 [Name] [varchar](255) NULL,
7 [SceneGroupID] [varchar](255) NULL,
8 [Text] [varchar](255) NULL,
9 [Description] [varchar](255) NULL,
10 [SitName] [varchar](255) NULL,
11 [TouchName] [varchar](255) NULL,
12 [ObjectFlags] [int] NULL,
13 [CreatorID] [varchar](255) NULL,
14 [OwnerID] [varchar](255) NULL,
15 [GroupID] [varchar](255) NULL,
16 [LastOwnerID] [varchar](255) NULL,
17 [OwnerMask] [int] NULL,
18 [NextOwnerMask] [int] NULL,
19 [GroupMask] [int] NULL,
20 [EveryoneMask] [int] NULL,
21 [BaseMask] [int] NULL,
22 [PositionX] [float] NULL,
23 [PositionY] [float] NULL,
24 [PositionZ] [float] NULL,
25 [GroupPositionX] [float] NULL,
26 [GroupPositionY] [float] NULL,
27 [GroupPositionZ] [float] NULL,
28 [VelocityX] [float] NULL,
29 [VelocityY] [float] NULL,
30 [VelocityZ] [float] NULL,
31 [AngularVelocityX] [float] NULL,
32 [AngularVelocityY] [float] NULL,
33 [AngularVelocityZ] [float] NULL,
34 [AccelerationX] [float] NULL,
35 [AccelerationY] [float] NULL,
36 [AccelerationZ] [float] NULL,
37 [RotationX] [float] NULL,
38 [RotationY] [float] NULL,
39 [RotationZ] [float] NULL,
40 [RotationW] [float] NULL,
41 [SitTargetOffsetX] [float] NULL,
42 [SitTargetOffsetY] [float] NULL,
43 [SitTargetOffsetZ] [float] NULL,
44 [SitTargetOrientW] [float] NULL,
45 [SitTargetOrientX] [float] NULL,
46 [SitTargetOrientY] [float] NULL,
47 [SitTargetOrientZ] [float] NULL,
48PRIMARY KEY CLUSTERED
49(
50 [UUID] ASC
51)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
52) ON [PRIMARY]
53
54CREATE TABLE [dbo].[primshapes](
55 [UUID] [varchar](255) NOT NULL,
56 [Shape] [int] NULL,
57 [ScaleX] [float] NULL,
58 [ScaleY] [float] NULL,
59 [ScaleZ] [float] NULL,
60 [PCode] [int] NULL,
61 [PathBegin] [int] NULL,
62 [PathEnd] [int] NULL,
63 [PathScaleX] [int] NULL,
64 [PathScaleY] [int] NULL,
65 [PathShearX] [int] NULL,
66 [PathShearY] [int] NULL,
67 [PathSkew] [int] NULL,
68 [PathCurve] [int] NULL,
69 [PathRadiusOffset] [int] NULL,
70 [PathRevolutions] [int] NULL,
71 [PathTaperX] [int] NULL,
72 [PathTaperY] [int] NULL,
73 [PathTwist] [int] NULL,
74 [PathTwistBegin] [int] NULL,
75 [ProfileBegin] [int] NULL,
76 [ProfileEnd] [int] NULL,
77 [ProfileCurve] [int] NULL,
78 [ProfileHollow] [int] NULL,
79 [State] [int] NULL,
80 [Texture] [image] NULL,
81 [ExtraParams] [image] NULL,
82PRIMARY KEY CLUSTERED
83(
84 [UUID] ASC
85)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
86) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
87
88CREATE TABLE [dbo].[primitems](
89 [itemID] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
90 [primID] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
91 [assetID] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
92 [parentFolderID] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
93 [invType] [int] NULL,
94 [assetType] [int] NULL,
95 [name] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
96 [description] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
97 [creationDate] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
98 [creatorID] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
99 [ownerID] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
100 [lastOwnerID] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
101 [groupID] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
102 [nextPermissions] [int] NULL,
103 [currentPermissions] [int] NULL,
104 [basePermissions] [int] NULL,
105 [everyonePermissions] [int] NULL,
106 [groupPermissions] [int] NULL,
107PRIMARY KEY CLUSTERED
108(
109 [itemID] ASC
110)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
111) ON [PRIMARY]
112
113CREATE TABLE [dbo].[terrain](
114 [RegionUUID] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
115 [Revision] [int] NULL,
116 [Heightfield] [image] NULL
117) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
118
119CREATE TABLE [dbo].[land](
120 [UUID] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
121 [RegionUUID] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
122 [LocalLandID] [int] NULL,
123 [Bitmap] [image] NULL,
124 [Name] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
125 [Description] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
126 [OwnerUUID] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
127 [IsGroupOwned] [int] NULL,
128 [Area] [int] NULL,
129 [AuctionID] [int] NULL,
130 [Category] [int] NULL,
131 [ClaimDate] [int] NULL,
132 [ClaimPrice] [int] NULL,
133 [GroupUUID] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
134 [SalePrice] [int] NULL,
135 [LandStatus] [int] NULL,
136 [LandFlags] [int] NULL,
137 [LandingType] [int] NULL,
138 [MediaAutoScale] [int] NULL,
139 [MediaTextureUUID] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
140 [MediaURL] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
141 [MusicURL] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
142 [PassHours] [float] NULL,
143 [PassPrice] [int] NULL,
144 [SnapshotUUID] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
145 [UserLocationX] [float] NULL,
146 [UserLocationY] [float] NULL,
147 [UserLocationZ] [float] NULL,
148 [UserLookAtX] [float] NULL,
149 [UserLookAtY] [float] NULL,
150 [UserLookAtZ] [float] NULL,
151PRIMARY KEY CLUSTERED
152(
153 [UUID] ASC
154)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
155) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
156
157CREATE TABLE [dbo].[landaccesslist](
158 [LandUUID] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
159 [AccessUUID] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
160 [Flags] [int] NULL
161) ON [PRIMARY] \ No newline at end of file