I work on the 2005 DB and changed the whole calendar to the dates back in 2005. Because of the different dates compared to 2013, I guess I have to change something in the DB if I want riders to target and participate in races.
For example, I added the Tour of Germany. It's a few weeks before the Vuelta. Now I want that riders who're riding the Vuelta are participating in that race as preparation.
There are some tables in the DB I'm not sure to do with and if they are important for what I'm trying to do?
That said, it's written for PCM11; I don't know if the changes in fitness system of PCM13 affect how it used to work.
(in an even more summed up version, you basically have to add the race ID in the corresponding month/rider type cells in STA_program_info; but to know which cells corresponds to which months, you need STA_program_info; to know which type_leader/type_leader_specialisation corresponds to which rider you need STA_type_leader/STA_type_leader_specialisation. The link between rider type and fitness schedules would be on this last table, where you add the ID of the fitness schedule according to STA_fitness_schedule; finally, in STA_fitness_schedule_info you have the week-by-week description of each fitness schedule - that is, if fitness for AI riders still work the same way it did, of course ).
fitness now works with how important certain races are..
and then you need sta_program_info and sta_program to define in which races, each type of leader will participate in.
It looks like a lot of work but when I edited it for the 2000 DB for stylus I was pretty much done in 2 days.
I'm now doing the same for the next PCM Focus version (they added world champs TTT which needed a stronger field)
).
