Quote:
Originally posted by A.J. Holz
Awesome, Joe! Can't wait!
Will there be an upgrade path for leagues that are using BOSI v1 right now? Also, since my league is hosted on the BOSI server, will that data be updated, or will we have to start from scratch?
|
Central and official servers will be upgraded automatically(after being backed up of course
), and data will be brought along with it. The only thing I might not be able to bring forward will be amateur draft picks. I plan on totally overhauling the way I store that information. It is my intention to provide an upgrade path for those as well, but I might not be able to pull it off.
Currently, our upgrade script is 285 lines and growing. The database is being changed in a lot of ways:
1. I'm using a new table type .. Inno DB. It allows me to have foreign keys. This means that if 2 tables are related, a value must exist in the master table in order to be referenced in the child one. For example, in PLAYER, a TEAM_ID has to exist in the TEAM table before it can be used in PLAYER. What this also does is allow me to "cascade delete". When I say delete from PLAYER where PLAYER_ID = 1, it not only deletes the player record, but all his stats, ratings, history, etc. as well.
2. Putting bosi_ in front of all tables so you can install it in an existing DB and not worry about it overwriting any of your existing tables. This could come in handy if your plan has a small # of MySQL DBs available.
3. Taking all the Month, Day, Year columns and making them into a date field.
4. Paying close attention to indexes. They take up some storage space, but, when created properly, they make the application run much faster.