OpenSim/DB/0.7.5/Avatars の変更点

• 追加された行はこの色です。
• 削除された行はこの色です。
• OpenSim/DB/0.7.5/Avatars へ行く。
• OpenSim/DB/0.7.5/Avatars の差分を削除

#author("2024-09-02T04:40:19+00:00","default:iseki","iseki")
***Avatars [#kcb3003d]
- アバターの持ち物を管理
#br
*** 装着物 [#jeec7920]
 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   |     |         |       | 
 +-------------+--------------+------+-----+---------+-------+

*** 装着物 [#sc725a30]
- 0.7.6 (アバター作成時)

 mysql> select * from Avatars where PrincipalID='0dc023b7-a10d-483e-b001-8b037ddbb984';
 +--------------------------------------+--------------+---------------------------------------------------------------------------+
 | PrincipalID                          | Name         | Value                                                                     |
 +--------------------------------------+--------------+---------------------------------------------------------------------------+
 | 0dc023b7-a10d-483e-b001-8b037ddbb984 | AvatarHeight | 1.690999                                                                  |
 | 0dc023b7-a10d-483e-b001-8b037ddbb984 | AvatarType   | 1                                                                         |
 | 0dc023b7-a10d-483e-b001-8b037ddbb984 | Serial       | 0                                                                         |
 | 0dc023b7-a10d-483e-b001-8b037ddbb984 | VisualParams | 33,61,85,23,58,127,63,...........................................,150,150 |
 | 0dc023b7-a10d-483e-b001-8b037ddbb984 | Wearable 0:0 | 45ac2bd3-d28b-4c5b-8877-d37cab0e77b4:66c41e39-38f9-f75a-024e-585989bfab73 |
 | 0dc023b7-a10d-483e-b001-8b037ddbb984 | Wearable 1:0 | 924e19e2-b96c-4f24-a15e-03076b51a19c:77c41e39-38f9-f75a-024e-585989bbabbb |
 | 0dc023b7-a10d-483e-b001-8b037ddbb984 | Wearable 2:0 | cce8ab9b-9967-4be5-8a57-46c000c87d9f:d342e6c0-b9d2-11dc-95ff-0800200c9a66 |
 | 0dc023b7-a10d-483e-b001-8b037ddbb984 | Wearable 3:0 | 2f954254-e2b9-4d56-ac55-46759ae7ed49:4bb6fa4d-1cd2-498a-a84c-95c1a0e745a7 |
 | 0dc023b7-a10d-483e-b001-8b037ddbb984 | Wearable 4:0 | a68f54d7-24e1-4e1e-93d4-2daf61290a18:00000000-38f9-1111-024e-222222111110 |
 | 0dc023b7-a10d-483e-b001-8b037ddbb984 | Wearable 5:0 | f1cf1d15-c42c-49c9-bdcb-2eb1f40d6416:00000000-38f9-1111-024e-222222111120 |
 +--------------------------------------+--------------+---------------------------------------------------------------------------+
 10 rows in set (0.00 sec)

- Name
-- Wearable 0:0 : Shape
-- Wearable 1:0 : Skin
-- Wearable 2:0 : Hair
-- Wearable 3:0 : Eye
-- Wearable 4:0 : Shirt
-- Wearable 5:0 : Pant
- Value
-- インベントリID: アセットID
#br
**** アバター作成時 [#ze55c8a0]
-- アッセットIDはシステムに依存． [[assets>../assets]]
-- インベントリID はアバター毎に作成． [[inventoryitems>../inventoryitems]]
#br

*** 装着物　（OLD） [#x20f5717]
 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                                    | 
 +--------------------------------------+-----------------+--------------------------------------+