Comments on: MTG:DB Updates http://codespatter.com/2008/01/19/mtgdb-updates/ Sun, 27 Sep 2009 16:48:42 -0500 http://wordpress.org/?v=2.8.4 hourly 1 By: Greg Allard http://codespatter.com/2008/01/19/mtgdb-updates/comment-page-1/#comment-18 Greg Allard Mon, 28 Jan 2008 15:55:32 +0000 http://codespatter.com/2008/01/19/mtgdb-updates/#comment-18 Some more ideas of ways to improve the data of the site. Get an updated copy of the database. There are new cards out. Then reapply and document the procedure to get it to pretty MySQL tables. There are currently 842 different Card Types since each different creature type is in that field. Break the creature type from the card type. Once that is done, it would be easier to do a groupby-searchby box like card rarity. Split card color to a separate table and join it to the card table with a join table. Each card can have multiple colors and it will be easier to search for cards containing the color Red. Some more ideas of ways to improve the data of the site.

Get an updated copy of the database. There are new cards out. Then reapply and document the procedure to get it to pretty MySQL tables.

There are currently 842 different Card Types since each different creature type is in that field. Break the creature type from the card type. Once that is done, it would be easier to do a groupby-searchby box like card rarity.

Split card color to a separate table and join it to the card table with a join table. Each card can have multiple colors and it will be easier to search for cards containing the color Red.

]]> By: Greg Allard http://codespatter.com/2008/01/19/mtgdb-updates/comment-page-1/#comment-13359 Greg Allard Mon, 28 Jan 2008 15:55:32 +0000 http://codespatter.com/2008/01/19/mtgdb-updates/#comment-13359 Some more ideas of ways to improve the data of the site. <br><br>Get an updated copy of the database. There are new cards out. Then reapply and document the procedure to get it to pretty MySQL tables.<br><br>There are currently 842 different Card Types since each different creature type is in that field. Break the creature type from the card type. Once that is done, it would be easier to do a groupby-searchby box like card rarity.<br><br>Split card color to a separate table and join it to the card table with a join table. Each card can have multiple colors and it will be easier to search for cards containing the color Red. Some more ideas of ways to improve the data of the site.

Get an updated copy of the database. There are new cards out. Then reapply and document the procedure to get it to pretty MySQL tables.

There are currently 842 different Card Types since each different creature type is in that field. Break the creature type from the card type. Once that is done, it would be easier to do a groupby-searchby box like card rarity.

Split card color to a separate table and join it to the card table with a join table. Each card can have multiple colors and it will be easier to search for cards containing the color Red.

]]>