On Fri, Aug 30, 2019 at 3:35 PM Keith Medcalf <kmedc...@dessus.com> wrote: > Seems fine, other than that event.first_seen and event.last_seen can be NULL, > in which case that field will never be updated. So while you may claim that > you never store NULL in those fields, doing so will cause non-workage due to > integrity failure,
Good point. There are no code paths that could put NULL in there now, but as you say, I should make sure that's the case in the design, in case the insert logic changes in the future. Thanks for catching this. > and the purpose of a DBMS is to enforce integrity. And thanks a ton for this comment, I need to get in this mentality, clearly. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users