I'm working on a Django web application (with a mySQL back-end) that uses non-maintained tables(tables not modified by the web app). However, I have two copies of the data tables (one for production and one for development).
A problem occurs when I need to manually modify the non-maintained data in the development version. Because there are two separate tables, I need to manually update the corresponding data in the production version.
Is there a recommended form of version control for the non-maintained tables? I was thinking of using SQLite for the non-maintained data tables and letting Git track their files.
To clarify, the production and development versions each have their own separate databases.
The production version's database has 1 copy of the non-maintained data tables. The development version's database has 1 copy of the non-maintained data tables.
The non-maintained data consists of standardized data (ie county FIPS, city lat/lngs, etc.)