Here is a copy of my KTRose database from my local test server on my ofice PC
don't forget it is a very different design for inventory and storage.
Each player gets a single line of data rather than each item getting one as done before.
Each field is then split up into a series of numbers separated by vertical bar ' | '
These sections correspond to slot position in the inventory/storage.
Each sub-stat for the items has it's own field, also seperated out into individual values.
So as an example you might have 4 items in the first 4 slots
the first field contains the id of the owner.
ItemID
403|44|1|705
Itemtype
10|10|10|10 so they are all consumables
refine
0|0|0|0 of course they are not refined
and so on
There is also a backupstorage table that contains a whole bunch of entries for each character.
The reason for this is so that every transaction is recorded with the present state of the entire storage for that character. Really easy to roll it back that way and also to keep track of scammers or duplicators.
Turns out I don't have an osirose database. I will try to find the time to set up an osirose server at some point to get the data from it. Right now the server is refusing to run properly and I don't really have the time to track down the problem.