Feature: Add review-log schema

Review log will be used to schedule notes for review as well as keep
track of failures

1 files changed, 9 insertions, 1 deletions

diff --git a/gnosis.el b/gnosis.el
index c38394e..1e87819 100644
--- a/gnosis.el
+++ b/gnosis.el
@@ -209,11 +209,17 @@ TAGS are used to organize questions."
 				   (ef integer :not-null) ;; Easiness factor
 				   (ff integer :not-null) ;; Forgetting factor
 				   (n integer :not-null) ;; Number of reviews
-				   (failures integer :not-null) ;; Number of consecutive review failures
 				   (interval integer :not-null)] ;; Interval
 				  (:foreign-key [id] :references notes [id]
 						:on-delete :cascade)))
 
+(defvar gnosis-db-review-log-schema '([(id integer :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
+				      (:foreign-key [id] :references notes [id]
+						    :on-delete :cascade)))
+
 
 ;; testing
 (defun gnosis-test-buffer ()
@@ -248,6 +254,8 @@ TAGS are used to organize questions."
   (gnosis--create-table 'notes gnosis-db-notes-schema)
   ;; Create review table
   (gnosis--create-table 'review gnosis-db-review-schema)
+  ;; Create review-log table
+  (gnosis--create-table 'review-log gnosis-db-review-log-schema)
   (gnosis-add-deck "Anatomy"))
 
 ;; Gnosis mode ;;