diff options
author | lbsa71 | 2008-04-02 13:06:52 +0000 |
---|---|---|
committer | lbsa71 | 2008-04-02 13:06:52 +0000 |
commit | f210cf01956eecc92495d005174a8cd6cef27a55 (patch) | |
tree | e8e56fc5830ab42026a27451203d22081fae7c83 /OpenSim/Framework/Data.MSSQL/Resources/AvatarAppearance.sql | |
parent | * Reworked Data Framework so that MSSQL works (diff) | |
download | opensim-SC_OLD-f210cf01956eecc92495d005174a8cd6cef27a55.zip opensim-SC_OLD-f210cf01956eecc92495d005174a8cd6cef27a55.tar.gz opensim-SC_OLD-f210cf01956eecc92495d005174a8cd6cef27a55.tar.bz2 opensim-SC_OLD-f210cf01956eecc92495d005174a8cd6cef27a55.tar.xz |
* Added AvatarAppearance.sql for MSSQL
Diffstat (limited to '')
-rw-r--r-- | OpenSim/Framework/Data.MSSQL/Resources/AvatarAppearance.sql | 44 |
1 files changed, 44 insertions, 0 deletions
diff --git a/OpenSim/Framework/Data.MSSQL/Resources/AvatarAppearance.sql b/OpenSim/Framework/Data.MSSQL/Resources/AvatarAppearance.sql new file mode 100644 index 0000000..ccefba2 --- /dev/null +++ b/OpenSim/Framework/Data.MSSQL/Resources/AvatarAppearance.sql | |||
@@ -0,0 +1,44 @@ | |||
1 | -- | ||
2 | -- Create schema avatar_appearance | ||
3 | -- | ||
4 | |||
5 | SET ANSI_NULLS ON | ||
6 | SET QUOTED_IDENTIFIER ON | ||
7 | SET ANSI_PADDING ON | ||
8 | |||
9 | CREATE TABLE [avatarappearance] ( | ||
10 | [UUID] uniqueidentifier NOT NULL, | ||
11 | [Serial] int NOT NULL, | ||
12 | [WearableItem0] uniqueidentifier NOT NULL, | ||
13 | [WearableAsset0] uniqueidentifier NOT NULL, | ||
14 | [WearableItem1] uniqueidentifier NOT NULL, | ||
15 | [WearableAsset1] uniqueidentifier NOT NULL, | ||
16 | [WearableItem2] uniqueidentifier NOT NULL, | ||
17 | [WearableAsset2] uniqueidentifier NOT NULL, | ||
18 | [WearableItem3] uniqueidentifier NOT NULL, | ||
19 | [WearableAsset3] uniqueidentifier NOT NULL, | ||
20 | [WearableItem4] uniqueidentifier NOT NULL, | ||
21 | [WearableAsset4] uniqueidentifier NOT NULL, | ||
22 | [WearableItem5] uniqueidentifier NOT NULL, | ||
23 | [WearableAsset5] uniqueidentifier NOT NULL, | ||
24 | [WearableItem6] uniqueidentifier NOT NULL, | ||
25 | [WearableAsset6] uniqueidentifier NOT NULL, | ||
26 | [WearableItem7] uniqueidentifier NOT NULL, | ||
27 | [WearableAsset7] uniqueidentifier NOT NULL, | ||
28 | [WearableItem8] uniqueidentifier NOT NULL, | ||
29 | [WearableAsset8] uniqueidentifier NOT NULL, | ||
30 | [WearableItem9] uniqueidentifier NOT NULL, | ||
31 | [WearableAsset9] uniqueidentifier NOT NULL, | ||
32 | [WearableItem10] uniqueidentifier NOT NULL, | ||
33 | [WearableAsset10] uniqueidentifier NOT NULL, | ||
34 | [WearableItem11] uniqueidentifier NOT NULL, | ||
35 | [WearableAsset11] uniqueidentifier NOT NULL, | ||
36 | [WearableItem12] uniqueidentifier NOT NULL, | ||
37 | [WearableAsset12] uniqueidentifier NOT NULL | ||
38 | |||
39 | PRIMARY KEY CLUSTERED ( | ||
40 | [UUID] | ||
41 | ) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] | ||
42 | ) ON [PRIMARY] | ||
43 | |||
44 | SET ANSI_PADDING OFF | ||