diff options
author | Jeff Ames | 2008-04-03 18:25:01 +0000 |
---|---|---|
committer | Jeff Ames | 2008-04-03 18:25:01 +0000 |
commit | 4f174fbf57160acc05911e9e3b342e8da9eb3644 (patch) | |
tree | cfbc8ecf3470dc729aec6cfe2ba2db3d7b63774e /OpenSim/Data/MSSQL/Resources | |
parent | * Attempted resolution for mantis 854 (diff) | |
download | opensim-SC-4f174fbf57160acc05911e9e3b342e8da9eb3644.zip opensim-SC-4f174fbf57160acc05911e9e3b342e8da9eb3644.tar.gz opensim-SC-4f174fbf57160acc05911e9e3b342e8da9eb3644.tar.bz2 opensim-SC-4f174fbf57160acc05911e9e3b342e8da9eb3644.tar.xz |
Update svn properties.
Diffstat (limited to 'OpenSim/Data/MSSQL/Resources')
-rw-r--r-- | OpenSim/Data/MSSQL/Resources/AvatarAppearance.sql | 88 |
1 files changed, 44 insertions, 44 deletions
diff --git a/OpenSim/Data/MSSQL/Resources/AvatarAppearance.sql b/OpenSim/Data/MSSQL/Resources/AvatarAppearance.sql index ccefba2..f396005 100644 --- a/OpenSim/Data/MSSQL/Resources/AvatarAppearance.sql +++ b/OpenSim/Data/MSSQL/Resources/AvatarAppearance.sql | |||
@@ -1,44 +1,44 @@ | |||
1 | -- | 1 | -- |
2 | -- Create schema avatar_appearance | 2 | -- Create schema avatar_appearance |
3 | -- | 3 | -- |
4 | 4 | ||
5 | SET ANSI_NULLS ON | 5 | SET ANSI_NULLS ON |
6 | SET QUOTED_IDENTIFIER ON | 6 | SET QUOTED_IDENTIFIER ON |
7 | SET ANSI_PADDING ON | 7 | SET ANSI_PADDING ON |
8 | 8 | ||
9 | CREATE TABLE [avatarappearance] ( | 9 | CREATE TABLE [avatarappearance] ( |
10 | [UUID] uniqueidentifier NOT NULL, | 10 | [UUID] uniqueidentifier NOT NULL, |
11 | [Serial] int NOT NULL, | 11 | [Serial] int NOT NULL, |
12 | [WearableItem0] uniqueidentifier NOT NULL, | 12 | [WearableItem0] uniqueidentifier NOT NULL, |
13 | [WearableAsset0] uniqueidentifier NOT NULL, | 13 | [WearableAsset0] uniqueidentifier NOT NULL, |
14 | [WearableItem1] uniqueidentifier NOT NULL, | 14 | [WearableItem1] uniqueidentifier NOT NULL, |
15 | [WearableAsset1] uniqueidentifier NOT NULL, | 15 | [WearableAsset1] uniqueidentifier NOT NULL, |
16 | [WearableItem2] uniqueidentifier NOT NULL, | 16 | [WearableItem2] uniqueidentifier NOT NULL, |
17 | [WearableAsset2] uniqueidentifier NOT NULL, | 17 | [WearableAsset2] uniqueidentifier NOT NULL, |
18 | [WearableItem3] uniqueidentifier NOT NULL, | 18 | [WearableItem3] uniqueidentifier NOT NULL, |
19 | [WearableAsset3] uniqueidentifier NOT NULL, | 19 | [WearableAsset3] uniqueidentifier NOT NULL, |
20 | [WearableItem4] uniqueidentifier NOT NULL, | 20 | [WearableItem4] uniqueidentifier NOT NULL, |
21 | [WearableAsset4] uniqueidentifier NOT NULL, | 21 | [WearableAsset4] uniqueidentifier NOT NULL, |
22 | [WearableItem5] uniqueidentifier NOT NULL, | 22 | [WearableItem5] uniqueidentifier NOT NULL, |
23 | [WearableAsset5] uniqueidentifier NOT NULL, | 23 | [WearableAsset5] uniqueidentifier NOT NULL, |
24 | [WearableItem6] uniqueidentifier NOT NULL, | 24 | [WearableItem6] uniqueidentifier NOT NULL, |
25 | [WearableAsset6] uniqueidentifier NOT NULL, | 25 | [WearableAsset6] uniqueidentifier NOT NULL, |
26 | [WearableItem7] uniqueidentifier NOT NULL, | 26 | [WearableItem7] uniqueidentifier NOT NULL, |
27 | [WearableAsset7] uniqueidentifier NOT NULL, | 27 | [WearableAsset7] uniqueidentifier NOT NULL, |
28 | [WearableItem8] uniqueidentifier NOT NULL, | 28 | [WearableItem8] uniqueidentifier NOT NULL, |
29 | [WearableAsset8] uniqueidentifier NOT NULL, | 29 | [WearableAsset8] uniqueidentifier NOT NULL, |
30 | [WearableItem9] uniqueidentifier NOT NULL, | 30 | [WearableItem9] uniqueidentifier NOT NULL, |
31 | [WearableAsset9] uniqueidentifier NOT NULL, | 31 | [WearableAsset9] uniqueidentifier NOT NULL, |
32 | [WearableItem10] uniqueidentifier NOT NULL, | 32 | [WearableItem10] uniqueidentifier NOT NULL, |
33 | [WearableAsset10] uniqueidentifier NOT NULL, | 33 | [WearableAsset10] uniqueidentifier NOT NULL, |
34 | [WearableItem11] uniqueidentifier NOT NULL, | 34 | [WearableItem11] uniqueidentifier NOT NULL, |
35 | [WearableAsset11] uniqueidentifier NOT NULL, | 35 | [WearableAsset11] uniqueidentifier NOT NULL, |
36 | [WearableItem12] uniqueidentifier NOT NULL, | 36 | [WearableItem12] uniqueidentifier NOT NULL, |
37 | [WearableAsset12] uniqueidentifier NOT NULL | 37 | [WearableAsset12] uniqueidentifier NOT NULL |
38 | 38 | ||
39 | PRIMARY KEY CLUSTERED ( | 39 | PRIMARY KEY CLUSTERED ( |
40 | [UUID] | 40 | [UUID] |
41 | ) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] | 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] | 42 | ) ON [PRIMARY] |
43 | 43 | ||
44 | SET ANSI_PADDING OFF | 44 | SET ANSI_PADDING OFF |