Player should not have ids of items he owns, rather the items should have the account name of the player they belong to. The items should also be indexed by their account name.
Quote:
Originally Posted by xXziroXx
<snip>
|
#1. Why are you using AUTOINCREMENT?
#2. Do you know that the INTEGER PRIMARY KEY column is an alias for the built-in rowid column?
#3. VARCHAR is not a type in SQLite, it is just changed to TEXT, I suggest using that.
#4. If you only update the SQL when the player logs out then you're not using SQL correctly.