The content below is pulled from an old local todo.txt file. I've changed my mind on some of the details, but posting here as-is for now. I plan to loop back later and refine the details before working to implement this.
-
Create meta table for logging when any other table was last updated (presumably we won't be wholesale nuking the existing tables on each run by this point)
meta.db_last_modifiedmeta.db_revision (auto-increment for every update to database)
-
Create TRIGGER to handle updating meta.db_last_modified column when any other table is modified
- possibly have this same TRIGGER handle updating the
meta.db_revision column too
The content below is pulled from an old local todo.txt file. I've changed my mind on some of the details, but posting here as-is for now. I plan to loop back later and refine the details before working to implement this.
Create
metatable for logging when any other table was last updated (presumably we won't be wholesale nuking the existing tables on each run by this point)meta.db_last_modifiedmeta.db_revision(auto-increment for every update to database)Create TRIGGER to handle updating
meta.db_last_modifiedcolumn when any other table is modifiedmeta.db_revisioncolumn too