Do we know if there are any issues with linking a sponsor from the DYN_sponsor table to more than one team?
For example, if both team X and team Y have 7-Eleven as a sponsor, can one use the same sponsor entry for both or is it necessary to create a duplicate sponsor entry with a unique ID?
It was eleven more than necessary. Jacques Anquetil
Yes I recall that, but I'm browsing the PCM Daily Expansion Pack for 2011 db file while I wait on the next patch and the PCM Daily Expansion update for 2012.
Looking at the DYN_Sponsor table I see lots of entries here that I may want to use for custom/added teams and I had expected to have to create them myself, manually. However, seeing some here it makes me wonder if I can use any of these sponsors on new teams. For example, how to tell which of the sponsors in the table currently aren't used by an existing team? I wonder if 'gene_i_contract_end = 0' means that sponsor currently isn't in use and would be safe to attach to a new team? Or, is there another way to tell?
Your help is, as ever, appreciated.
It was eleven more than necessary. Jacques Anquetil
Yes. If there's a value different than 0 in gene_i_contract_end, then the sponsor is assigned to a team. If it's 0, then no team, and no problem in linking it to a new one (or an existing one as well). Just don't forget to fill a 'valid' value here (gene_i_contract_end), besides filling the sponsor ID in DYN_team (fkIDsponsor_principale/secondaire, more specifically).
