Hi!
On 2018-10-08 08:11, Hick Gunter wrote:
> 1) Include an "inserted at" timestamp column in each table
> 2) create a history table for each real table
> 3) use before triggers to copy the old record to the history table and set
> the "inserted at" timestamp
Using triggers is an interesting
sult set
of the old state query into the live table.
-Ursprüngliche Nachricht-
Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im
Auftrag von Daniel Kraft
Gesendet: Freitag, 05. Oktober 2018 17:40
An: sqlite-users@mailinglists.sqlite.org
Betreff: [EXTERNAL] [sqlite]
2 matches
Mail list logo