[CherryMond]

What is the best way to store items attached to a player in the mysql database? What should be the columns?

I was thinking over:

PHP Code:

 _______________________________________
|   ...........items....................|
 ---------------------------------------
| id       | int(8), PRIMARY KEY, A_I   |
| pid      | int(8) FOREIGN KEY (pid)   | // player register id from `players`
| modelid  | int(8)                     |
| slot     | int(8)                     |
| boneid   | int(8)                     |
| fOffsetX | Float                      |
| fOffsetY | Float                      |
| fOffsetZ | Float                      |
| fRotX    | Float                      |
| fRotY    | Float                      |
| fRotZ    | Float                      |
| fScaleX  | Float                      |
| fScaleY  | Float                      |
| fScaleZ  | Float                      |
 --------------------------------------- 


This will be working, I think, but if player is using all slots (0-9), will be 10 rows per player, what do you think about this? maybe you have better ways?