OpenSim/DB/0.7.5/inventoryitems
をテンプレートにして作成
[
トップ
] [
タイトル一覧
|
ページ一覧
|
新規
|
検索
|
最終更新
|
ヘルプ
|
ログイン
]
開始行:
** inventoryitems [#y2a61977]
- インベントリのデータ
#br
*** DB [#e8e7100b]
mysql> show columns from inventoryitems;
+------------------------------+------------------+-----...
| Field | Type | Null...
+------------------------------+------------------+-----...
| assetID | varchar(36) | YES ...
| assetType | int(11) | YES ...
| inventoryName | varchar(64) | YES ...
| inventoryDescription | varchar(128) | YES ...
| inventoryNextPermissions | int(10) unsigned | YES ...
| inventoryCurrentPermissions | int(10) unsigned | YES ...
| invType | int(11) | YES ...
| creatorID | varchar(255) | NO ...
| inventoryBasePermissions | int(10) unsigned | NO ...
| inventoryEveryOnePermissions | int(10) unsigned | NO ...
| salePrice | int(11) | NO ...
| saleType | tinyint(4) | NO ...
| creationDate | int(11) | NO ...
| groupID | varchar(36) | NO ...
| groupOwned | tinyint(4) | NO ...
| flags | int(11) unsigned | NO ...
| inventoryID | char(36) | NO ...
| avatarID | char(36) | YES ...
| parentFolderID | char(36) | YES ...
| inventoryGroupPermissions | int(10) unsigned | NO ...
+------------------------------+------------------+-----...
20 rows in set (0.00 sec)
*** Ex. [#v4cc5cd9]
mysql> select * from inventoryitems where avatarID='0dc0...
+--------------------------------------+-----------+----...
| assetID | assetType | inv...
+--------------------------------------+-----------+----...
| 66c41e39-38f9-f75a-024e-585989bfab73 | 13 | Def...
| 77c41e39-38f9-f75a-024e-585989bbabbb | 13 | Def...
| d342e6c0-b9d2-11dc-95ff-0800200c9a66 | 13 | Def...
| 4bb6fa4d-1cd2-498a-a84c-95c1a0e745a7 | 13 | Def...
| 00000000-38f9-1111-024e-222222111110 | 5 | Def...
| 00000000-38f9-1111-024e-222222111120 | 5 | Def...
+--------------------------------------+-----------+----...
6 rows in set (0.00 sec)
終了行:
** inventoryitems [#y2a61977]
- インベントリのデータ
#br
*** DB [#e8e7100b]
mysql> show columns from inventoryitems;
+------------------------------+------------------+-----...
| Field | Type | Null...
+------------------------------+------------------+-----...
| assetID | varchar(36) | YES ...
| assetType | int(11) | YES ...
| inventoryName | varchar(64) | YES ...
| inventoryDescription | varchar(128) | YES ...
| inventoryNextPermissions | int(10) unsigned | YES ...
| inventoryCurrentPermissions | int(10) unsigned | YES ...
| invType | int(11) | YES ...
| creatorID | varchar(255) | NO ...
| inventoryBasePermissions | int(10) unsigned | NO ...
| inventoryEveryOnePermissions | int(10) unsigned | NO ...
| salePrice | int(11) | NO ...
| saleType | tinyint(4) | NO ...
| creationDate | int(11) | NO ...
| groupID | varchar(36) | NO ...
| groupOwned | tinyint(4) | NO ...
| flags | int(11) unsigned | NO ...
| inventoryID | char(36) | NO ...
| avatarID | char(36) | YES ...
| parentFolderID | char(36) | YES ...
| inventoryGroupPermissions | int(10) unsigned | NO ...
+------------------------------+------------------+-----...
20 rows in set (0.00 sec)
*** Ex. [#v4cc5cd9]
mysql> select * from inventoryitems where avatarID='0dc0...
+--------------------------------------+-----------+----...
| assetID | assetType | inv...
+--------------------------------------+-----------+----...
| 66c41e39-38f9-f75a-024e-585989bfab73 | 13 | Def...
| 77c41e39-38f9-f75a-024e-585989bbabbb | 13 | Def...
| d342e6c0-b9d2-11dc-95ff-0800200c9a66 | 13 | Def...
| 4bb6fa4d-1cd2-498a-a84c-95c1a0e745a7 | 13 | Def...
| 00000000-38f9-1111-024e-222222111110 | 5 | Def...
| 00000000-38f9-1111-024e-222222111120 | 5 | Def...
+--------------------------------------+-----------+----...
6 rows in set (0.00 sec)
ページ名:
![[PukiWiki]](image/pukiwiki.png "[PukiWiki]")
