search

FAI-CIVL / FAI-Airscore

AirScore - online paragliding / hanggliding GAP-based scoring software.
https://airscore.cc/
GNU General Public License v3.0
13 stars 17 forks source link

new columns / new table #169

Open biuti opened 3 years ago

biuti commented 3 years ago

Telegram feature is in the code but not the logic to associate a channel to a comp. As we would like to change db the least possible after release, I was thinking about the correct way to add it. We could very simply add a column to Competition table, or we could add a table, named CompFeature, with columns comp_id, feature, value. This way, if any new feature is added and turned on, we will have a new row for each feature and each competition, and probably we could reduce need of changing db in the future. The same could be done for other object that we think could be helpful in the future, maybe task.

Thoughts?

kuaka commented 3 years ago

seems like a sensible idea to me. Then any query on comp join with this table.

Note that if DB migrations can be automated then this is not an issue.

@philderbeast thoughts?