mysql - how to design a expandable database? -


i'm working on card game reference website. need have table i'm sure expand in future.

for example, if have table used save attributes of cards, , each card has following information:

card_name    rarity    race    skill1 

in future, game may add skill or other information card this:

card_name    rarity    race    skill1    skill2    others 

in case, wondering best solution me design database. add new columns or use table save new information of cards?

also, i'm looking tips have watch out. btw, i'm using mysql

create relation table. add primary key id cards table, autoincrement, , store base data cards. create relation table, foreing key card table id. later can extend table.

here post about, how create it: how create relation table in mysql?

here littlebit more detailed post it: http://www.techrepublic.com/article/relational-databases-defining-relationships-between-database-tables/


Comments