Home
News
Forum
Wiki
Blog
Contents
Gallery
Movies
Downloads
About NSL
[
List of Titles
|
List of Pages
|
New
|
Search
|
Recent changes
|
Help
]
OpenSim/DB/0.7.5/inventoryitems
[
Front page
]
[ ]
Start:
** inventoryitems
- インベントリのデータ
#br
*** DB
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.
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)
End:
** inventoryitems
- インベントリのデータ
#br
*** DB
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.
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)
Page:
Site Search
Advanced Search
Login
Username:
Password:
Lost Password?
Register now!!
Sub Menu
New Arrivals
Books
Web Links
Site Map
e-Learning
TUIS Certificate
mini Calendar
Sep 2024
Su
Mo
Tu
We
Th
Fr
Sa
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
Today
Who's Online
67 user(s) are online (13 user(s) are browsing xpwiki)
Members: 0
Guests: 67
more...
Access Counter
Today :
Yesterday :
Total :
Powered by XOOPS Cube 2.1© 2001-2006
XOOPS Cube Project
Design by
XoopsDesign.com