1: 2010-04-02 (Fri) 20:35:35 admin  |
Cur: 2013-09-30 (Mon) 17:13:50 iseki |
| - | *** inventoryfolders [#uc75f4e9] | + | ** inventoryfolders [#uc75f4e9] |
| | + | - ユーザ生成時に自動的に作られる |
| | + | #br |
| | | | |
| | + | *** DB [#t9f7b134] |
| | mysql> show columns from inventoryfolders; | | mysql> show columns from inventoryfolders; |
| | +----------------+-------------+------+-----+--------------------------------------+-------+ | | +----------------+-------------+------+-----+--------------------------------------+-------+ |
| | | parentFolderID | char(36) | YES | MUL | NULL | | | | | parentFolderID | char(36) | YES | MUL | NULL | | |
| | +----------------+-------------+------+-----+--------------------------------------+-------+ | | +----------------+-------------+------+-----+--------------------------------------+-------+ |
| | + | |
| | + | *** Ex. [#s895d70b] |
| | + | mysql> select * from inventoryfolders where agentID='0dc023b7-a10d-483e-b001-8b037ddbb984'; |
| | + | +----------------+------+---------+--------------------------------------+--------------------------------------+--------------------------------------+ |
| | + | | folderName | type | version | folderID | agentID | parentFolderID | |
| | + | +----------------+------+---------+--------------------------------------+--------------------------------------+--------------------------------------+ |
| | + | | My Inventory | 9 | 15 | 1071b308-fadc-4dc8-b317-4156072172ef | 0dc023b7-a10d-483e-b001-8b037ddbb984 | 00000000-0000-0000-0000-000000000000 | |
| | + | | Calling Cards | 2 | 1 | 18e72787-5b1f-4a7a-af9e-1004bd43ef31 | 0dc023b7-a10d-483e-b001-8b037ddbb984 | 1071b308-fadc-4dc8-b317-4156072172ef | |
| | + | | Trash | 14 | 1 | 291d9494-12a5-4fae-ad97-27b4e2c94cce | 0dc023b7-a10d-483e-b001-8b037ddbb984 | 1071b308-fadc-4dc8-b317-4156072172ef | |
| | + | | Sounds | 1 | 1 | 2ba4210f-9db4-4a76-9d0f-a61e74d8effe | 0dc023b7-a10d-483e-b001-8b037ddbb984 | 1071b308-fadc-4dc8-b317-4156072172ef | |
| | + | | Gestures | 21 | 1 | 51bc6042-5289-4e5e-ae10-cea1a151c495 | 0dc023b7-a10d-483e-b001-8b037ddbb984 | 1071b308-fadc-4dc8-b317-4156072172ef | |
| | + | | Lost And Found | 16 | 1 | 751a77ba-5e5a-4a08-a330-c3d4eac6ab79 | 0dc023b7-a10d-483e-b001-8b037ddbb984 | 1071b308-fadc-4dc8-b317-4156072172ef | |
| | + | | Clothing | 5 | 3 | 80971833-381f-4590-9896-41e3fb76feb5 | 0dc023b7-a10d-483e-b001-8b037ddbb984 | 1071b308-fadc-4dc8-b317-4156072172ef | |
| | + | | Objects | 6 | 1 | 8fbf7383-b3a3-4a0c-8605-6b99124c7b22 | 0dc023b7-a10d-483e-b001-8b037ddbb984 | 1071b308-fadc-4dc8-b317-4156072172ef | |
| | + | | Body Parts | 13 | 5 | 907354d3-832a-49f9-89a3-e004efd15119 | 0dc023b7-a10d-483e-b001-8b037ddbb984 | 1071b308-fadc-4dc8-b317-4156072172ef | |
| | + | | Scripts | 10 | 1 | 9f877bd6-3009-467a-b3d7-35fec87c8695 | 0dc023b7-a10d-483e-b001-8b037ddbb984 | 1071b308-fadc-4dc8-b317-4156072172ef | |
| | + | | Photo Album | 15 | 1 | d623d6da-7954-474f-bc3c-4eb3784d77b1 | 0dc023b7-a10d-483e-b001-8b037ddbb984 | 1071b308-fadc-4dc8-b317-4156072172ef | |
| | + | | Animations | 20 | 1 | d6ebfe26-fc62-46c8-950c-7c6f13fdf3b1 | 0dc023b7-a10d-483e-b001-8b037ddbb984 | 1071b308-fadc-4dc8-b317-4156072172ef | |
| | + | | Landmarks | 3 | 1 | f254faaf-c6ad-4dd4-b534-61585886fc20 | 0dc023b7-a10d-483e-b001-8b037ddbb984 | 1071b308-fadc-4dc8-b317-4156072172ef | |
| | + | | Textures | 0 | 1 | f41cf6f6-6b17-4528-930b-5af3065ac774 | 0dc023b7-a10d-483e-b001-8b037ddbb984 | 1071b308-fadc-4dc8-b317-4156072172ef | |
| | + | | Notecards | 7 | 1 | fd62dd08-1d05-47f7-8964-6fd4bfe552e1 | 0dc023b7-a10d-483e-b001-8b037ddbb984 | 1071b308-fadc-4dc8-b317-4156072172ef | |
| | + | +----------------+------+---------+--------------------------------------+--------------------------------------+--------------------------------------+ |
| | + | 15 rows in set (0.00 sec) |
