Archive info database overhaul - Githubissues

Police-Data-Accessibility-Project / prod-to-dev-migration

Regularly migrates production database and schema to development database

1 stars 0 forks source link

Archive info database overhaul #19

Closed EvilDrPurple closed 3 months ago

EvilDrPurple commented 3 months ago

Fixes

Part of https://github.com/Police-Data-Accessibility-Project/data-sources-app/issues/309 and https://github.com/Police-Data-Accessibility-Project/automatic-archives/issues/21

Description

Adds a new table called data_sources_archive_info that contains update_frequency, last_cached and a new column called next_cache
Relevant data from data_sources is migrated to data_sources_archive_info then dropped from the old table
Adds a trigger that will create a linked row any time a row is inserted into data_sources