inventoryitems†[edit]
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)
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)
![[PukiWiki]](image/pukiwiki.png "[PukiWiki]")
