Difference between revisions of "Category:Database Timelines"
From Lianjapedia
Barrymavin (Talk | contribs) |
Barrymavin (Talk | contribs) |
||
| Line 2: | Line 2: | ||
Database timelines record who did what from where, when they did it and what they changed. | Database timelines record who did what from where, when they did it and what they changed. | ||
| + | |||
| + | <div style="height:80px;margin-bottom:5px;padding:5px;border:0px solid orange;border-left:5px solid orange;background:#fff8dc;vertical-align:middle;position:relative;"> | ||
| + | [[File:bm-noteicon.png|top|40px|link=]]<div style="position:absolute;top:3px;margin-bottom;bottom:5px;margin-left:50px;"><b> Pro Tip</b> | ||
| + | Database timelines can be enabled for all the tables in a database:<br/> | ||
| + | ''alter database southwind metadata "timeline=on"'' | ||
| + | </div> | ||
| + | <span style="height:6px;"> </span> | ||
| + | </div> | ||
[[Category:Documentation]] | [[Category:Documentation]] | ||
Revision as of 09:20, 30 November 2017
Lianja database timelines provide row versioning for database tables for all CRUD operations performed on data. Whenever a change is made to a table that is timeline enabled then delta changes are automatically recorded for each transaction. Changes made to any tables that are timeline enabled can be undone much like you would undo changes to program code that you edit in a text editor.
Database timelines record who did what from where, when they did it and what they changed.
Pro Tip
Database timelines can be enabled for all the tables in a database:
alter database southwind metadata "timeline=on"
Pages in category "Database Timelines"
The following 11 pages are in this category, out of 11 total.
