![[PukiWiki]](image/pukiwiki.png "[PukiWiki]")
#author("2024-09-02T04:38:23+00:00","default:iseki","iseki") ** inventoryitems [#y2a61977] - インベントリのデータ #br *** DB [#e8e7100b] mysql> show columns from inventoryitems; +------------------------------+------------------+------+-----+--------------------------------------+-------+ | Field | Type | Null | Key | Default | Extra | +------------------------------+------------------+------+-----+--------------------------------------+-------+ | assetID | varchar(36) | YES | | NULL | | | assetType | int(11) | YES | | NULL | | | inventoryName | varchar(64) | YES | | NULL | | | inventoryDescription | varchar(128) | YES | | NULL | | | inventoryNextPermissions | int(10) unsigned | YES | | NULL | | | inventoryCurrentPermissions | int(10) unsigned | YES | | NULL | | | invType | int(11) | YES | | NULL | | | creatorID | varchar(255) | NO | | 00000000-0000-0000-0000-000000000000 | | | inventoryBasePermissions | int(10) unsigned | NO | | 0 | | | inventoryEveryOnePermissions | int(10) unsigned | NO | | 0 | | | salePrice | int(11) | NO | | 0 | | | saleType | tinyint(4) | NO | | 0 | | | creationDate | int(11) | NO | | 0 | | | groupID | varchar(36) | NO | | 00000000-0000-0000-0000-000000000000 | | | groupOwned | tinyint(4) | NO | | 0 | | | flags | int(11) unsigned | NO | | 0 | | | inventoryID | char(36) | NO | PRI | 00000000-0000-0000-0000-000000000000 | | | avatarID | char(36) | YES | MUL | NULL | | | parentFolderID | char(36) | YES | MUL | NULL | | | inventoryGroupPermissions | int(10) unsigned | NO | | 0 | | +------------------------------+------------------+------+-----+--------------------------------------+-------+ 20 rows in set (0.00 sec) *** Ex. [#v4cc5cd9] mysql> select * from inventoryitems where avatarID='0dc023b7-a10d-483e-b001-8b037ddbb984'; +--------------------------------------+-----------+---------------+----------------------+--------------------------+-----------------------------+---------+--------------------------------------+--------------------------+------------------------------+-----------+----------+--------------+--------------------------------------+------------+-------+--------------------------------------+--------------------------------------+--------------------------------------+---------------------------+ | assetID | assetType | inventoryName | inventoryDescription | inventoryNextPermissions | inventoryCurrentPermissions | invType | creatorID | inventoryBasePermissions | inventoryEveryOnePermissions | salePrice | saleType | creationDate | groupID | groupOwned | flags | inventoryID | avatarID | parentFolderID | inventoryGroupPermissions | +--------------------------------------+-----------+---------------+----------------------+--------------------------+-----------------------------+---------+--------------------------------------+--------------------------+------------------------------+-----------+----------+--------------+--------------------------------------+------------+-------+--------------------------------------+--------------------------------------+--------------------------------------+---------------------------+ | 66c41e39-38f9-f75a-024e-585989bfab73 | 13 | Default Shape | | 581632 | 581632 | 18 | 0dc023b7-a10d-483e-b001-8b037ddbb984 | 581632 | 581632 | 0 | 0 | 1380526900 | 00000000-0000-0000-0000-000000000000 | 0 | 0 | 45ac2bd3-d28b-4c5b-8877-d37cab0e77b4 | 0dc023b7-a10d-483e-b001-8b037ddbb984 | 907354d3-832a-49f9-89a3-e004efd15119 | 581632 | | 77c41e39-38f9-f75a-024e-585989bbabbb | 13 | Default Skin | | 581632 | 581632 | 18 | 0dc023b7-a10d-483e-b001-8b037ddbb984 | 581632 | 581632 | 0 | 0 | 1380526900 | 00000000-0000-0000-0000-000000000000 | 0 | 1 | 924e19e2-b96c-4f24-a15e-03076b51a19c | 0dc023b7-a10d-483e-b001-8b037ddbb984 | 907354d3-832a-49f9-89a3-e004efd15119 | 581632 | | d342e6c0-b9d2-11dc-95ff-0800200c9a66 | 13 | Default Hair | | 581632 | 581632 | 18 | 0dc023b7-a10d-483e-b001-8b037ddbb984 | 581632 | 581632 | 0 | 0 | 1380526900 | 00000000-0000-0000-0000-000000000000 | 0 | 2 | cce8ab9b-9967-4be5-8a57-46c000c87d9f | 0dc023b7-a10d-483e-b001-8b037ddbb984 | 907354d3-832a-49f9-89a3-e004efd15119 | 581632 | | 4bb6fa4d-1cd2-498a-a84c-95c1a0e745a7 | 13 | Default Eyes | | 581632 | 581632 | 18 | 0dc023b7-a10d-483e-b001-8b037ddbb984 | 581632 | 581632 | 0 | 0 | 1380526900 | 00000000-0000-0000-0000-000000000000 | 0 | 3 | 2f954254-e2b9-4d56-ac55-46759ae7ed49 | 0dc023b7-a10d-483e-b001-8b037ddbb984 | 907354d3-832a-49f9-89a3-e004efd15119 | 581632 | | 00000000-38f9-1111-024e-222222111110 | 5 | Default Shirt | | 581632 | 581632 | 18 | 0dc023b7-a10d-483e-b001-8b037ddbb984 | 581632 | 581632 | 0 | 0 | 1380526900 | 00000000-0000-0000-0000-000000000000 | 0 | 4 | a68f54d7-24e1-4e1e-93d4-2daf61290a18 | 0dc023b7-a10d-483e-b001-8b037ddbb984 | 80971833-381f-4590-9896-41e3fb76feb5 | 581632 | | 00000000-38f9-1111-024e-222222111120 | 5 | Default Pants | | 581632 | 581632 | 18 | 0dc023b7-a10d-483e-b001-8b037ddbb984 | 581632 | 581632 | 0 | 0 | 1380526900 | 00000000-0000-0000-0000-000000000000 | 0 | 5 | f1cf1d15-c42c-49c9-bdcb-2eb1f40d6416 | 0dc023b7-a10d-483e-b001-8b037ddbb984 | 80971833-381f-4590-9896-41e3fb76feb5 | 581632 | +--------------------------------------+-----------+---------------+----------------------+--------------------------+-----------------------------+---------+--------------------------------------+--------------------------+------------------------------+-----------+----------+--------------+--------------------------------------+------------+-------+--------------------------------------+--------------------------------------+--------------------------------------+---------------------------+ 6 rows in set (0.00 sec)
