1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
|
--
-- Create schema avatar_appearance
--
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
SET ANSI_PADDING ON
CREATE TABLE [avatarappearance] (
[UUID] uniqueidentifier NOT NULL,
[Serial] int NOT NULL,
[WearableItem0] uniqueidentifier NOT NULL,
[WearableAsset0] uniqueidentifier NOT NULL,
[WearableItem1] uniqueidentifier NOT NULL,
[WearableAsset1] uniqueidentifier NOT NULL,
[WearableItem2] uniqueidentifier NOT NULL,
[WearableAsset2] uniqueidentifier NOT NULL,
[WearableItem3] uniqueidentifier NOT NULL,
[WearableAsset3] uniqueidentifier NOT NULL,
[WearableItem4] uniqueidentifier NOT NULL,
[WearableAsset4] uniqueidentifier NOT NULL,
[WearableItem5] uniqueidentifier NOT NULL,
[WearableAsset5] uniqueidentifier NOT NULL,
[WearableItem6] uniqueidentifier NOT NULL,
[WearableAsset6] uniqueidentifier NOT NULL,
[WearableItem7] uniqueidentifier NOT NULL,
[WearableAsset7] uniqueidentifier NOT NULL,
[WearableItem8] uniqueidentifier NOT NULL,
[WearableAsset8] uniqueidentifier NOT NULL,
[WearableItem9] uniqueidentifier NOT NULL,
[WearableAsset9] uniqueidentifier NOT NULL,
[WearableItem10] uniqueidentifier NOT NULL,
[WearableAsset10] uniqueidentifier NOT NULL,
[WearableItem11] uniqueidentifier NOT NULL,
[WearableAsset11] uniqueidentifier NOT NULL,
[WearableItem12] uniqueidentifier NOT NULL,
[WearableAsset12] uniqueidentifier NOT NULL
PRIMARY KEY CLUSTERED (
[UUID]
) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
SET ANSI_PADDING OFF
|
