OpenSim​/DB​/0.7.0​/Avatars

Avatars

• 装着物

  mysql> show columns from Avatars;
  +-------------+--------------+------+-----+---------+-------+
  | Field       | Type         | Null | Key | Default | Extra |
  +-------------+--------------+------+-----+---------+-------+
  | PrincipalID | char(36)     | NO   | PRI | NULL    |       | 
  | Name        | varchar(32)  | NO   | PRI | NULL    |       | 
  | Value       | varchar(255) | NO   |     |         |       | 
  +-------------+--------------+------+-----+---------+-------+

• 装着物

  mysql> select * from Avatars;
  +--------------------------------------+-----------------+--------------------------------------+
  | PrincipalID                          | Name            | Value                                |
  +--------------------------------------+-----------------+--------------------------------------+
  | 751c1531-03b5-48a9-8f2d-51a0527be7ca | UnderPantsAsset | 79731125-31b9-414a-bb1e-3458e629799c | 
  | 751c1531-03b5-48a9-8f2d-51a0527be7ca | UnderShirtAsset | 0049510a-e0f9-471d-9128-08930b3d8f5a | 
  | 751c1531-03b5-48a9-8f2d-51a0527be7ca | SocksAsset      | 565c5109-40b7-48e8-ada8-303611b91e30 | 
  | 751c1531-03b5-48a9-8f2d-51a0527be7ca | SkirtAsset      | 00000000-0000-0000-0000-000000000000 | 
  | 751c1531-03b5-48a9-8f2d-51a0527be7ca | SkinAsset       | 9586e719-14bd-4130-af16-4b46943ff265 | 
  | 751c1531-03b5-48a9-8f2d-51a0527be7ca | ShoesAsset      | 00000000-0000-0000-0000-000000000000 | 
  | 751c1531-03b5-48a9-8f2d-51a0527be7ca | PantsAsset      | 82cdc415-f56b-4271-acff-e4e221d3562f | 
  | 751c1531-03b5-48a9-8f2d-51a0527be7ca | ShirtAsset      | b5b146b3-8c20-4c2e-977a-d84f1a66beb6 | 
  | 751c1531-03b5-48a9-8f2d-51a0527be7ca | EyesAsset       | 17718b9a-b040-4fec-b1ad-3a3e0705b422 | 
  | 751c1531-03b5-48a9-8f2d-51a0527be7ca | GlovesAsset     | 00000000-0000-0000-0000-000000000000 | 
  | 751c1531-03b5-48a9-8f2d-51a0527be7ca | HairAsset       | d4a7c839-513e-e450-c563-26ceefdb845e | 
  | 751c1531-03b5-48a9-8f2d-51a0527be7ca | JacketAsset     | 00000000-0000-0000-0000-000000000000 | 
  | 751c1531-03b5-48a9-8f2d-51a0527be7ca | BodyAsset       | 66207dfb-723a-4ea4-ad24-32e21a266b2a | 
  | 751c1531-03b5-48a9-8f2d-51a0527be7ca | UnderPantsItem  | 4d5af7ca-1401-43f5-bd34-2a9a78ae042f | 
  | 751c1531-03b5-48a9-8f2d-51a0527be7ca | UnderShirtItem  | d4d92b93-ece7-4df9-8bae-3b0ca3af6dc2 | 
  | 751c1531-03b5-48a9-8f2d-51a0527be7ca | SocksItem       | 589839da-fd4b-4af3-8de0-c65a2bd0946c | 
  | 751c1531-03b5-48a9-8f2d-51a0527be7ca | SkirtItem       | 00000000-0000-0000-0000-000000000000 | 
  | 751c1531-03b5-48a9-8f2d-51a0527be7ca | SkinItem        | 002a473d-2128-4054-8db4-ef8c6687c439 | 
  | 751c1531-03b5-48a9-8f2d-51a0527be7ca | ShoesItem       | 00000000-0000-0000-0000-000000000000 | 
  | 751c1531-03b5-48a9-8f2d-51a0527be7ca | ShirtItem       | f7aaa131-862e-47c0-865d-90259a871426 | 
  | 751c1531-03b5-48a9-8f2d-51a0527be7ca | PantsItem       | a9e16c8f-b640-4607-907d-7f73241f7c6c | 
  | 751c1531-03b5-48a9-8f2d-51a0527be7ca | JacketItem      | 00000000-0000-0000-0000-000000000000 | 
  | 751c1531-03b5-48a9-8f2d-51a0527be7ca | HairItem        | 33eb9a48-3483-4ebc-b1dc-2b235aa5b4f3 | 
  | 751c1531-03b5-48a9-8f2d-51a0527be7ca | BodyItem        | 4bd2cad4-eca1-44df-a89f-e29125b179bf | 
  | 751c1531-03b5-48a9-8f2d-51a0527be7ca | GlovesItem      | 00000000-0000-0000-0000-000000000000 | 
  | 751c1531-03b5-48a9-8f2d-51a0527be7ca | EyesItem        | dbbed340-5963-400b-b7bf-9d239b16d9d4 | 
  | 751c1531-03b5-48a9-8f2d-51a0527be7ca | AvatarHeight    | 1.489767                             | 
  | 751c1531-03b5-48a9-8f2d-51a0527be7ca | Serial          | 1                                    | 
  | 751c1531-03b5-48a9-8f2d-51a0527be7ca | UserID          | 751c1531-03b5-48a9-8f2d-51a0527be7ca | 
  | 751c1531-03b5-48a9-8f2d-51a0527be7ca | METHOD          | setavatar                            | 
  | 751c1531-03b5-48a9-8f2d-51a0527be7ca | VERSIONMAX      | 0                                    | 
  | 751c1531-03b5-48a9-8f2d-51a0527be7ca | VERSIONMIN      | 0                                    | 
  | 751c1531-03b5-48a9-8f2d-51a0527be7ca | AvatarType      | 1                                    | 
  +--------------------------------------+-----------------+--------------------------------------+