From a70e10741c6fda5dd0316617d876988e06a6226b Mon Sep 17 00:00:00 2001 From: Thanos Apollo Date: Wed, 27 Dec 2023 06:37:41 +0200 Subject: db: Update review-log schema Add: - Total number of successful reviews & failures - Consecutive successful reviews & failures --- gnosis.el | 13 ++++++++----- 1 file changed, 8 insertions(+), 5 deletions(-) diff --git a/gnosis.el b/gnosis.el index 2993067..c722e52 100644 --- a/gnosis.el +++ b/gnosis.el @@ -359,11 +359,14 @@ Returns a list of the form (ef-increase ef-decrease ef)." :on-delete :cascade))) (defvar gnosis-db-schema-review-log '([(id integer :primary-key :not-null) ;; note-id - (last-rev integer :not-null) ;; Last review date - (next-rev integer :not-null) ;; Next review date - (failures integer :not-null) ;; Number of consecutive review failures - (suspend integer :not-null) ;; Binary value, 1=suspended - (n integer :not-null)] ;; Number of reviews + (last-rev integer :not-null) ;; Last review date + (next-rev integer :not-null) ;; Next review date + (c-success integer :not-null) ;; number of consecutive successful reviews + (t-success integer :not-null) ;; Number of total successful reviews + (c-fails integer :not-null) ;; Number of consecutive failed reviewss + (t-fails integer :not-null) ;; Number of total failed reviews + (suspend integer :not-null) ;; Binary value, 1=suspended + (n integer :not-null)] ;; Number of reviews (:foreign-key [id] :references notes [id] :on-delete :cascade))) -- cgit v1.2.3