MySQL/PHP - Web Based Game -User specific inventory table or 1 giant table? Another option?
PHP Snippet 1:
PRIMARY KEY(id),
INDEX(user_id)
PHP Snippet 2:
PRIMARY KEY(user_id, id),
INDEX(id)
PRIMARY KEY(id),
INDEX(user_id)
PRIMARY KEY(user_id, id),
INDEX(id)