|
現: 2016-07-10 (日) 12:16:52 iseki  |
| | + | 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) |
