View Single Post
Old 09-02-2009, 06:18 PM   #9 (permalink)
fhomess
Hall Of Famer
 
fhomess's Avatar
 
Join Date: Nov 2002
Posts: 2,749
Thanks: 15
Thanked 275x in 125 posts
Quote:
Originally Posted by wellsoliver View Post
About to move my league into its second season and I'm curious (afraid) of the mysql export - specifically the players_game_batting, players_game_pitching_stats, and team_record tables. Will these be reset and emptied of the last year's data, or appended to?

My guess is team_record will have to be reset as there is no date column...
All three get reset, although team_record information is stored in team_history_record for past seasons, so you don't lose that information. You just have to look elswhere for it. I think most of the other team tables work the same way.

e.g.
team_record -> team_history_record
team_batting_stats -> team_history_batting_stats
team_pitching_stats -> team_history_pitching_stats
...

Note that not all team tables have a corresponding history table
__________________
StatsLab11 - PHP/MySQL based utilities for Online Leagues
Other Mods:
19th Century: Schedules, FaceGen
BBCards: 1887 Allen & Ginter, 1934 Goudey, 1988 Score, 1996 fhomess, 2005 fhomess
FaceGen: 1960-Pres MLB, 32 Colleges, Backgrounds

PEBA - Connecticut Nutmeggers

Last edited by fhomess; 09-02-2009 at 06:20 PM.
fhomess is offline   Reply With Quote