[Boolean]

Quote:

Originally Posted by Vince 1) Use default values. This will significantly shorten your query because you don't have to insert zeros. 2) Inventory information should actually be moved to a separate table. If there can be an indefinite amount of something it should be in a separate table. Now you can argue that you only want to store three weapons, but if in the future you decide you want to store more you have to edit your database and your queries, whereas with proper normalization you wouldn't have to change anything. 3) day, month and year can probably be collapsed into a single column, using either a Unix timestamp or the DateTime type.

Could you give me an example of how to use default values? Also, if I were to make a separate table for the inventory, how would I link it to the house I'm creating?