Thread: Column history
View Single Post
Old 03-04-2021, 11:43 PM   #2
BetterRed
null operator (he/him)
BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.
 
Posts: 21,772
Karma: 30237628
Join Date: Mar 2012
Location: Sydney Australia
Device: none
Quote:
Originally Posted by ownedbycats View Post
Is there any way to save a history of column changes?
Changes to column content or column definition?

If former try the Audit Log plugin.

If latter, perhaps SQLIte maintains a log of schema changes. If not, looking at the metadata.db file in one of these might give a clue, 1) if enabled the Windows Previous Versions tool, or 2) if you use a mirroring backup with version history, then wherever it stashes previous versions.

BR
BetterRed is offline   Reply With Quote