View Single Post
Old 07-06-2007, 02:20 PM   #4 (permalink)
plannine
Major Leagues
 
plannine's Avatar
 
Join Date: Mar 2003
Location: Michigan
Posts: 387
Quote:
Originally Posted by HerbD View Post
I don't think you have to have any of the stats but they will not be imported if you don't have them. You do need these:

yearID Year
lgID League
teamID Team
franchID Franchise (links to TeamsFranchise table)
divID Team's division
team full name

If you are doing MLB history and you want to change the structure then all you need to do is change the league and divisions to where you want them to be.
that's kind what i was hoping, but wanted to be sure before i edited 100 years of baseball history.

Quote:
It's also important to have the franchise file filled out.
is the franchise file (mentioned above) the franchise ID or another file???

thanks
p9
__________________
"Baseball gives every American boy a chance to excel, not just to be as good as someone else but to be better than someone else. This is the nature of man and the name of the game.
Ted Williams (1918-2002)

Last edited by plannine : 07-06-2007 at 02:22 PM.
plannine is offline   Reply With Quote