aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Framework/Data.MySQL/Resources/AvatarAppearance.sql
blob: d9d3de08ad628e4dd5ec67ff27e5253e5e398f54 (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
40
41
42
--
-- Create schema avatar_appearance
--

CREATE DATABASE IF NOT EXISTS avatar_appearance;
USE 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;