Timeline for How do I store Items in MySQL?
Current License: CC BY-SA 3.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Oct 3, 2011 at 16:52 | history | edited | Coyote | CC BY-SA 3.0 |
added 8 characters in body
|
| Oct 3, 2011 at 16:42 | comment | added | user1430 | Yup, I agree about the duplication thing, I didn't want to get too deep into the complexities of a system I was advocating the OP not use anyhow, though. :D | |
| Oct 3, 2011 at 16:32 | comment | added | Coyote | I can't comment elsewhere: Josh Petrie has a good answer but I would add something to ShopInventory: shopId, itemId + quantity. filling the table with 300 duplicates if you have 300 of a resource in a shop is also a violation of 1NF: simple-talk.com/content/print.aspx?article=712 but for prototyping always go with something more dynamic (like XML of Json) you will lose less time. | |
| Oct 3, 2011 at 16:25 | history | answered | Coyote | CC BY-SA 3.0 |