diff options
author | Melanie Thielker | 2008-09-02 20:05:20 +0000 |
---|---|---|
committer | Melanie Thielker | 2008-09-02 20:05:20 +0000 |
commit | 9806c0b37471b33fc3a4631ec68fada81ebeeaef (patch) | |
tree | 20398c237d1836bb1cb505092b49715ec1180bee /OpenSim/Data/MSSQL/Resources/001_RegionStore.sql | |
parent | Small fix to a cast in list parsing (diff) | |
download | opensim-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.sql | 161 |
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 @@ | |||
1 | CREATE 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, | ||
48 | PRIMARY KEY CLUSTERED | ||
49 | ( | ||
50 | [UUID] ASC | ||
51 | )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] | ||
52 | ) ON [PRIMARY] | ||
53 | |||
54 | CREATE 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, | ||
82 | PRIMARY KEY CLUSTERED | ||
83 | ( | ||
84 | [UUID] ASC | ||
85 | )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] | ||
86 | ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] | ||
87 | |||
88 | CREATE 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, | ||
107 | PRIMARY KEY CLUSTERED | ||
108 | ( | ||
109 | [itemID] ASC | ||
110 | )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] | ||
111 | ) ON [PRIMARY] | ||
112 | |||
113 | CREATE 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 | |||
119 | CREATE 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, | ||
151 | PRIMARY KEY CLUSTERED | ||
152 | ( | ||
153 | [UUID] ASC | ||
154 | )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] | ||
155 | ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] | ||
156 | |||
157 | CREATE 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 | ||