diff options
| author | Thanos Apollo <[email protected]> | 2023-12-27 06:37:41 +0200 |
|---|---|---|
| committer | Thanos Apollo <[email protected]> | 2023-12-27 06:37:41 +0200 |
| commit | a70e10741c6fda5dd0316617d876988e06a6226b (patch) | |
| tree | 21a7f7c6ae90e3d54a081f88d4efe686a5e52670 | |
| parent | 85416b592bd2df02a07f60b3f1d1851f27639f0b (diff) | |
db: Update review-log schema
Add:
- Total number of successful reviews & failures
- Consecutive successful reviews & failures
| -rw-r--r-- | gnosis.el | 13 |
1 files changed, 8 insertions, 5 deletions
@@ -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))) |