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