aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL/Resources/AvatarAppearance.sql
blob: 0deb0992f603c8064017d6cdf1e6e9323f8970d4 (plain)
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
--
-- Create schema avatar_appearance
--

DROP TABLE IF EXISTS `avatarappearance`;
CREATE TABLE `avatarappearance` (
  `UUID` char(36) NOT NULL,
  `Serial` int(10) unsigned NOT NULL,
  `WearableItem0` char(36) NOT NULL,
  `WearableAsset0` char(36) NOT NULL,
  `WearableItem1` char(36) NOT NULL,
  `WearableAsset1` char(36) NOT NULL,
  `WearableItem2` char(36) NOT NULL,
  `WearableAsset2` char(36) NOT NULL,
  `WearableItem3` char(36) NOT NULL,
  `WearableAsset3` char(36) NOT NULL,
  `WearableItem4` char(36) NOT NULL,
  `WearableAsset4` char(36) NOT NULL,
  `WearableItem5` char(36) NOT NULL,
  `WearableAsset5` char(36) NOT NULL,
  `WearableItem6` char(36) NOT NULL,
  `WearableAsset6` char(36) NOT NULL,
  `WearableItem7` char(36) NOT NULL,
  `WearableAsset7` char(36) NOT NULL,
  `WearableItem8` char(36) NOT NULL,
  `WearableAsset8` char(36) NOT NULL,
  `WearableItem9` char(36) NOT NULL,
  `WearableAsset9` char(36) NOT NULL,
  `WearableItem10` char(36) NOT NULL,
  `WearableAsset10` char(36) NOT NULL,
  `WearableItem11` char(36) NOT NULL,
  `WearableAsset11` char(36) NOT NULL,
  `WearableItem12` char(36) NOT NULL,
  `WearableAsset12` char(36) NOT NULL,


  PRIMARY KEY  (`UUID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev.1';